Error: Packets out of order. Got: 0 Expected:

Hambeer 2022. 8. 1. 23:40

Error: Packets out of order. Got: 0 Expected: 9
    at Parser._tryReadPacketHeader (D:\BIZN\API\api_userapp\node_modules\mysql\lib\protocol\Parser.js:470:15)
    at Parser.write (D:\BIZN\API\api_userapp\node_modules\mysql\lib\protocol\Parser.js:33:29)
    at Protocol.write (D:\BIZN\API\api_userapp\node_modules\mysql\lib\protocol\Protocol.js:38:16)
    at Socket.<anonymous> (D:\BIZN\API\api_userapp\node_modules\mysql\lib\Connection.js:88:28)
    at Socket.<anonymous> (D:\BIZN\API\api_userapp\node_modules\mysql\lib\Connection.js:526:10)
    at Socket.emit (node:events:527:28)
    at addChunk (node:internal/streams/readable:315:12)
    at readableAddChunk (node:internal/streams/readable:289:9)
    at Socket.Readable.push (node:internal/streams/readable:228:10)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
  code: 'PROTOCOL_PACKETS_OUT_OF_ORDER',
  fatal: true

await 설정 늘려주기

set global interactive_timeout = 31536000;

set global wait_timeout = 31536000;

set session interactive_timeout = 31536000;

set session wait_timeout = 31536000;

단점 : 서버 재시작시 매번 입력이 필요하다