Sample Header Ad - 728x90

Error: "A slave with the same server_uuid/server_id as this slave has connected to the master"

0 votes
1 answer
3645 views
I am testing a node.js client which connects to a mysql DB (mariadb). It works fine on its own, but if I launch this client simultaneously on another host, the first instance gets disconnected with the following error. I have read some posts suggesting to change the server-id in my.cnf, but that didn't help. Besides, why would I need to change the id of the server since both clients are pointing to the same server? { Error: UNKNOWN_CODE_PLEASE_REPORT: A slave with the same server_uuid/server_id as this slave has connected to the master; the first event 'mysql-b in.000024' at 334, the last event read from 'mysql-bin.000024' at 256, the last byte read from 'mysql-bin.000024' at 334. at Binlog.Sequence._packetToError (/home/myapp/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14) at Binlog.Sequence.ErrorPacket (/home/myapp/node_modules/mysql/lib/protocol/sequences/Sequence.js:96:17) at Protocol._parsePacket (/home/myapp/node_modules/mysql/lib/protocol/Protocol.js:278:23) at Parser.write (/home/myapp/node_modules/mysql/lib/protocol/Parser.js:76:12) at Protocol.write (/home/myapp/node_modules/mysql/lib/protocol/Protocol.js:38:16) at Socket. (/home/myappp/node_modules/mysql/lib/Connection.js:91:28) at Socket. (/home/myapp/node_modules/mysql/lib/Connection.js:502:10) at Socket.emit (events.js:182:13) at addChunk (_stream_readable.js:283:12) at readableAddChunk (_stream_readable.js:264:11) -------------------- at Protocol._enqueue (/home/myapp/node_modules/mysql/lib/protocol/Protocol.js:144:48) at Immediate._start (/home/myapp/node_modules/@rodrigogs/zongji/index.js:234:31) at processImmediate (timers.js:632:19) code: 'UNKNOWN_CODE_PLEASE_REPORT', errno: 4052, sqlMessage: "A slave with the same server_uuid/server_id as this slave has connected to the master; the first event 'mysql-bin.000024' at 334, the last event read from 'mysql-bin.000024' at 256, the last byte read from 'mysql-bin.000024' at 334.", sqlState: 'HY000' } { Error: Connection lost: The server closed the connection. at Protocol.end (/home/myapp/node_modules/mysql/lib/protocol/Protocol.js:112:13) at Socket. (/home/myapp/node_modules/mysql/lib/Connection.js:97:28) at Socket. (/home/myapp/node_modules/mysql/lib/Connection.js:502:10) at Socket.emit (events.js:187:15) at endReadableNT (_stream_readable.js:1094:12) at process.internalTickCallback (internal/process/next_tick.js:72:19) fatal: true, code: 'PROTOCOL_CONNECTION_LOST' }
Asked by ChrisF (21 rep)
Mar 6, 2019, 02:15 AM
Last activity: Mar 21, 2025, 06:02 PM