RangeError [ERR_BUFFER_OUT_OF_BOUNDS]: Attempt to access memory outside buffer bounds

[ikheetjeff]

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?

[ikheetjeff]

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
}
`

[IUGAI1398]

the same!

[IUGAI1398]

try edit or add
"binlog_format = row"
to my.cnf file