RangeError [ERR_BUFFER_OUT_OF_BOUNDS]: Attempt to access memory outside buffer bounds
Hi,
When i start my application, and i do a UPDATE from my database, i get this error:
RangeError [ERR_BUFFER_OUT_OF_BOUNDS]: Attempt to access memory outside buffer b ounds
at new NodeError (node:internal/errors:329:5)
at boundsError (node:internal/buffer:84:11)
at Buffer.readUInt8 (node:internal/buffer:252:5)
at parseBinaryBuffer (/projects/whatsapp/complimaatje/node_modules/@rodrigog s/zongji/lib/json_decode.js:55:24)
at module.exports (/projects/whatsapp/complimaatje/node_modules/@rodrigogs/z ongji/lib/json_decode.js:28:25)
at Object.exports.readMysqlValue (/projects/whatsapp/complimaatje/node_modul es/@rodrigogs/zongji/lib/common.js:468:16)
at readRow (/projects/whatsapp/complimaatje/node_modules/@rodrigogs/zongji/l ib/rows_event.js:111:16)
at UpdateRows._fetchOneRow (/projects/whatsapp/complimaatje/node_modules/@ro drigogs/zongji/lib/rows_event.js:143:13)
at UpdateRows.RowsEvent (/projects/whatsapp/complimaatje/node_modules/@rodri gogs/zongji/lib/rows_event.js:62:27)
at new UpdateRows (/projects/whatsapp/complimaatje/node_modules/@rodrigogs/z ongji/lib/rows_event.js:135:13) {
code: 'ERR_BUFFER_OUT_OF_BOUNDS'
}
Error: Packets out of order. Got: 28 Expected: 7
at Parser._tryReadPacketHeader (/projects/whatsapp/complimaatje/node_modules /mysql/lib/protocol/Parser.js:470:15)
at Parser.write (/projects/whatsapp/complimaatje/node_modules/mysql/lib/prot ocol/Parser.js:33:29)
at processTicksAndRejections (node:internal/process/task_queues:76:11)
--------------------
at Protocol._enqueue (/projects/whatsapp/complimaatje/node_modules/mysql/lib /protocol/Protocol.js:144:48)
at Immediate._start (/projects/whatsapp/complimaatje/node_modules/@rodrigogs /zongji/index.js:240:31)
at processImmediate (node:internal/timers:464:21) {
code: 'PROTOCOL_PACKETS_OUT_OF_ORDER',
fatal: true
}
It happends sometimes, but not always. How can i fix this?
Debug log:
`<-- (4052) RowDataPacket { COLUMN_NAME: 'mode', COLLATION_NAME: 'utf8mb4_0900_ai_ci', CHARACTER_SET_NAME: 'utf8mb4', COLUMN_COMMENT: '1 = "elke week", 2 = "elke twee weken"', COLUMN_TYPE: "enum('1','2','3')" }
<-- (4052) EofPacket { fieldCount: 254, warningCount: 0, serverStatus: 2, protocol41: true }
<-- (4054) BinlogHeader { _error: RangeError [ERR_BUFFER_OUT_OF_BOUNDS]: Attempt to access memory outside buffer bounds at new NodeError (node:internal/errors:329:5) at boundsError (node:internal/buffer:84:11) at Buffer.readUInt8 (node:internal/buffer:252:5) at parseBinaryBuffer (/projects/whatsapp/complimaatje/node_modules/@rodrigogs/zongji/lib/json_decode.js:55:24) at module.exports (/projects/whatsapp/complimaatje/node_modules/@rodrigogs/zongji/lib/json_decode.js:28:25) at Object.exports.readMysqlValue (/projects/whatsapp/complimaatje/node_modules/@rodrigogs/zongji/lib/common.js:468:16) at readRow (/projects/whatsapp/complimaatje/node_modules/@rodrigogs/zongji/lib/rows_event.js:111:16) at UpdateRows._fetchOneRow (/projects/whatsapp/complimaatje/node_modules/@rodrigogs/zongji/lib/rows_event.js:143:13) at UpdateRows.RowsEvent (/projects/whatsapp/complimaatje/node_modules/@rodrigogs/zongji/lib/rows_event.js:62:27) at new UpdateRows (/projects/whatsapp/complimaatje/node_modules/@rodrigogs/zongji/lib/rows_event.js:135:13) { code: 'ERR_BUFFER_OUT_OF_BOUNDS' } }
RangeError [ERR_BUFFER_OUT_OF_BOUNDS]: Attempt to access memory outside buffer bounds at new NodeError (node:internal/errors:329:5) at boundsError (node:internal/buffer:84:11) at Buffer.readUInt8 (node:internal/buffer:252:5) at parseBinaryBuffer (/projects/whatsapp/complimaatje/node_modules/@rodrigogs/zongji/lib/json_decode.js:55:24) at module.exports (/projects/whatsapp/complimaatje/node_modules/@rodrigogs/zongji/lib/json_decode.js:28:25) at Object.exports.readMysqlValue (/projects/whatsapp/complimaatje/node_modules/@rodrigogs/zongji/lib/common.js:468:16) at readRow (/projects/whatsapp/complimaatje/node_modules/@rodrigogs/zongji/lib/rows_event.js:111:16) at UpdateRows._fetchOneRow (/projects/whatsapp/complimaatje/node_modules/@rodrigogs/zongji/lib/rows_event.js:143:13) at UpdateRows.RowsEvent (/projects/whatsapp/complimaatje/node_modules/@rodrigogs/zongji/lib/rows_event.js:62:27) at new UpdateRows (/projects/whatsapp/complimaatje/node_modules/@rodrigogs/zongji/lib/rows_event.js:135:13) { code: 'ERR_BUFFER_OUT_OF_BOUNDS' } Error: Packets out of order. Got: 48 Expected: 7 at Parser._tryReadPacketHeader (/projects/whatsapp/complimaatje/node_modules/mysql/lib/protocol/Parser.js:470:15) at Parser.write (/projects/whatsapp/complimaatje/node_modules/mysql/lib/protocol/Parser.js:33:29) at processTicksAndRejections (node:internal/process/task_queues:76:11) -------------------- at Protocol._enqueue (/projects/whatsapp/complimaatje/node_modules/mysql/lib/protocol/Protocol.js:144:48) at Immediate._start (/projects/whatsapp/complimaatje/node_modules/@rodrigogs/zongji/index.js:240:31) at processImmediate (node:internal/timers:464:21) { code: 'PROTOCOL_PACKETS_OUT_OF_ORDER', fatal: true } `
the same!
try edit or add
"binlog_format = row"
to my.cnf file