App Crashes after awhile with this exception #1

New issue

Closed

opened 2024-04-25 18:07:47 -05:00 by JMTNTBANG · 1 comment

JMTNTBANG commented

2024-04-25 18:07:47 -05:00

(Migrated from github.com)

node:events:497
      throw er; // Unhandled 'error' event
      ^
Error: Packets out of order. Got: 0 Expected: 2
    at Parser._tryReadPacketHeader (/root/MySQL-Web-Frontend/node_modules/
mysql/lib/protocol/Parser.js:470:15)
    at Parser.write (/root/MySQL-Web-Frontend/node_modules/mysql/lib/proto
col/Parser.js:33:29)
    at Protocol.write (/root/MySQL-Web-Frontend/node_modules/mysql/lib/pro
tocol/Protocol.js:38:16)
    at Socket.<anonymous> (/root/MySQL-Web-Frontend/node_modules/mysql/lib
/Connection.js:88:28)
    at Socket.<anonymous> (/root/MySQL-Web-Frontend/node_modules/mysql/lib
/Connection.js:526:10)
    at Socket.emit (node:events:519:28)
    at addChunk (node:internal/streams/readable:559:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:510:3)
    at Readable.push (node:internal/streams/readable:390:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23)
Emitted 'error' event on Connection instance at:
    at Connection._handleProtocolError (/root/MySQL-Web-Frontend/node_modu
les/mysql/lib/Connection.js:423:8)
    at Protocol.emit (node:events:519:28)
    at Protocol._delegateError (/root/MySQL-Web-Frontend/node_modules/mysq
l/lib/protocol/Protocol.js:398:10)
    at Protocol.handleParserError (/root/MySQL-Web-Frontend/node_modules/m
ysql/lib/protocol/Protocol.js:380:10)
    at Parser._tryReadPacketHeader (/root/MySQL-Web-Frontend/node_modules/
mysql/lib/protocol/Parser.js:478:10)
    at Parser.write (/root/MySQL-Web-Frontend/node_modules/mysql/lib/proto
col/Parser.js:33:29)
    [... lines matching original stack trace ...]
    at Socket.emit (node:events:519:28) {
  code: 'PROTOCOL_PACKETS_OUT_OF_ORDER',
  fatal: true
}

```js node:events:497 throw er; // Unhandled 'error' event ^ Error: Packets out of order. Got: 0 Expected: 2 at Parser._tryReadPacketHeader (/root/MySQL-Web-Frontend/node_modules/ mysql/lib/protocol/Parser.js:470:15) at Parser.write (/root/MySQL-Web-Frontend/node_modules/mysql/lib/proto col/Parser.js:33:29) at Protocol.write (/root/MySQL-Web-Frontend/node_modules/mysql/lib/pro tocol/Protocol.js:38:16) at Socket.<anonymous> (/root/MySQL-Web-Frontend/node_modules/mysql/lib /Connection.js:88:28) at Socket.<anonymous> (/root/MySQL-Web-Frontend/node_modules/mysql/lib /Connection.js:526:10) at Socket.emit (node:events:519:28) at addChunk (node:internal/streams/readable:559:12) at readableAddChunkPushByteMode (node:internal/streams/readable:510:3) at Readable.push (node:internal/streams/readable:390:5) at TCP.onStreamRead (node:internal/stream_base_commons:190:23) Emitted 'error' event on Connection instance at: at Connection._handleProtocolError (/root/MySQL-Web-Frontend/node_modu les/mysql/lib/Connection.js:423:8) at Protocol.emit (node:events:519:28) at Protocol._delegateError (/root/MySQL-Web-Frontend/node_modules/mysq l/lib/protocol/Protocol.js:398:10) at Protocol.handleParserError (/root/MySQL-Web-Frontend/node_modules/m ysql/lib/protocol/Protocol.js:380:10) at Parser._tryReadPacketHeader (/root/MySQL-Web-Frontend/node_modules/ mysql/lib/protocol/Parser.js:478:10) at Parser.write (/root/MySQL-Web-Frontend/node_modules/mysql/lib/proto col/Parser.js:33:29) [... lines matching original stack trace ...] at Socket.emit (node:events:519:28) { code: 'PROTOCOL_PACKETS_OUT_OF_ORDER', fatal: true } ```

JMTNTBANG commented

2024-05-04 00:35:14 -05:00

(Migrated from github.com)

Fixed By Adding max_allowed_packet=500M to MySQL Config File

Fixed By Adding `max_allowed_packet=500M` to MySQL Config File