Skip to content
This repository has been archived by the owner on May 11, 2023. It is now read-only.

Error: Packets out of order. Got: 0 Expected: 13 #65

Closed
tskxz opened this issue Oct 3, 2022 · 5 comments
Closed

Error: Packets out of order. Got: 0 Expected: 13 #65

tskxz opened this issue Oct 3, 2022 · 5 comments
Assignees

Comments

@tskxz
Copy link
Owner

tskxz commented Oct 3, 2022

No description provided.

@tskxz tskxz self-assigned this Oct 3, 2022
@tskxz
Copy link
Owner Author

tskxz commented Oct 6, 2022

con.query('SET GLOBAL interactive_timeout=28800')

@tskxz tskxz closed this as completed Oct 6, 2022
@tskxz tskxz reopened this Oct 9, 2022
@tskxz
Copy link
Owner Author

tskxz commented Oct 9, 2022

events.js:291
throw er; // Unhandled 'error' event
^

Error: Packets out of order. Got: 0 Expected: 12
at Parser._tryReadPacketHeader (/home/ubuntu/Desktop/browsemuscle/node_modules/mysql/lib/protocol/Parser.js:470:15)
at Parser.write (/home/ubuntu/Desktop/browsemuscle/node_modules/mysql/lib/protocol/Parser.js:33:29)
at Protocol.write (/home/ubuntu/Desktop/browsemuscle/node_modules/mysql/lib/protocol/Protocol.js:38:16)
at Socket. (/home/ubuntu/Desktop/browsemuscle/node_modules/mysql/lib/Connection.js:88:28)
at Socket. (/home/ubuntu/Desktop/browsemuscle/node_modules/mysql/lib/Connection.js:526:10)
at Socket.emit (events.js:314:20)
at addChunk (_stream_readable.js:297:12)
at readableAddChunk (_stream_readable.js:272:9)
at Socket.Readable.push (_stream_readable.js:213:10)
at TCP.onStreamRead (internal/stream_base_commons.js:188:23)
Emitted 'error' event on Connection instance at:
at Connection._handleProtocolError (/home/ubuntu/Desktop/browsemuscle/node_modules/mysql/lib/Connection.js:423:8)
at Protocol.emit (events.js:314:20)
at Protocol._delegateError (/home/ubuntu/Desktop/browsemuscle/node_modules/mysql/lib/protocol/Protocol.js:398:10)
at Protocol.handleParserError (/home/ubuntu/Desktop/browsemuscle/node_modules/mysql/lib/protocol/Protocol.js:380:10)
at Parser._tryReadPacketHeader (/home/ubuntu/Desktop/browsemuscle/node_modules/mysql/lib/protocol/Parser.js:478:10)
at Parser.write (/home/ubuntu/Desktop/browsemuscle/node_modules/mysql/lib/protocol/Parser.js:33:29)
[... lines matching original stack trace ...]
at Socket.emit (events.js:314:20) {
code: 'PROTOCOL_PACKETS_OUT_OF_ORDER',
fatal: true
}

@tskxz
Copy link
Owner Author

tskxz commented Oct 9, 2022

@tskxz
Copy link
Owner Author

tskxz commented Oct 9, 2022

#95

@tskxz
Copy link
Owner Author

tskxz commented Oct 9, 2022

mysqljs/mysql#2534 (comment)

var mysql = require('mysql');

var pool  = mysql.createPool({
  host     : 'example.org',
  user     : 'bob',
  password : 'secret',
  database : 'my_db'
});

pool.getConnection(function(err, connection));

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
Status: Done
Development

No branches or pull requests

1 participant