Details
-
New Feature
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
2.5.21, 6.3.1, 6.4.2, 22.08.1
-
None
-
MXS-SPRINT-176
Description
I tried to setup xpand parallel replication and I this error. This is on the xpand master.
2022-09-29 10:54:11.949066 UTC nid 1 hnn-xpand1-mxp-0.hnn-xpand1-mxp clxnode: INFO mysql/replication/master.c:534 start_replication_master(): {conn_id=214017 closing=0 lock count=1}: Replication request from IPv4(10.156.15.221:56124) for xpand-bin: cid 0x6335778e10085806 pos { proto: clx current_commit_id: 0x6335778e10085806 current_event_id: 2 flags: WANT_ROWS SLOW_START batch_size: 21474836480 low_bound: 15372286728091293014 high_bound: 18446744073709551615} |
2022-09-29 10:54:11.951066 UTC nid 1 hnn-xpand1-mxp-0.hnn-xpand1-mxp clxnode: INFO mysql/replication/master.c:534 start_replication_master(): {conn_id=215041 closing=0 lock count=1}: Replication request from IPv4(10.156.15.221:56132) for xpand-bin: cid 0x6335778e10085806 pos { proto: clx current_commit_id: 0x6335778e10085806 current_event_id: 2 flags: WANT_STATEMENTS SLOW_START batch_size: 21474836480 low_bound: 0 high_bound: 0} |
2022-09-29 10:54:12.392068 UTC nid 1 hnn-xpand1-mxp-0.hnn-xpand1-mxp clxnode: WARNING mysql/replication/master.c:96 mysql_master_close(): Replication master error: slave IPv4(10.156.15.221:56124): Session killed due to closed client socket: |
2022-09-29 10:54:12.393068 UTC nid 1 hnn-xpand1-mxp-0.hnn-xpand1-mxp clxnode: WARNING mysql/replication/master.c:96 mysql_master_close(): Replication master error: slave IPv4(10.156.15.221:56132): Session killed due to closed client socket: |
Maxscale logs on the master:
2022-09-29 12:09:10 error : (54) Unexpected result state. cmd: 0x00, len: 28 server: @@Xpand-Monitor:node-2 |
2022-09-29 12:09:10 error : (54) Unexpected result state. cmd: 0x00, len: 28 server: @@Xpand-Monitor:node-2 |
2022-09-29 12:09:10 error : (54) Unexpected result state. cmd: 0x00, len: 28 server: @@Xpand-Monitor:node-2 |
2022-09-29 12:09:10 error : (54) Unexpected result state. cmd: 0x00, len: 28 server: @@Xpand-Monitor:node-2 (subsequent similar messages suppressed for 10000 milliseconds) |
2022-09-29 12:09:29 error : (60) Unexpected result state. cmd: 0x00, len: 28 server: @@Xpand-Monitor:node-2 |
2022-09-29 12:09:29 error : (60) Unexpected result state. cmd: 0x00, len: 334 server: @@Xpand-Monitor:node-2 |
2022-09-29 12:09:29 error : (60) Unexpected result state. cmd: 0x00, len: 28 server: @@Xpand-Monitor:node-2 |
2022-09-29 12:09:29 error : (60) Unexpected result state. cmd: 0x00, len: 28 server: @@Xpand-Monitor:node-2 |
2022-09-29 12:09:29 error : (60) Unexpected result state. cmd: 0x00, len: 197 server: @@Xpand-Monitor:node-2 |
2022-09-29 12:09:29 error : (60) Unexpected result state. cmd: 0x00, len: 28 server: @@Xpand-Monitor:node-2 |
2022-09-29 12:09:29 error : (60) Unexpected result state. cmd: 0x00, len: 28 server: @@Xpand-Monitor:node-2 |
2022-09-29 12:09:29 error : (60) Unexpected result state. cmd: 0x00, len: 120 server: @@Xpand-Monitor:node-2 |
2022-09-29 12:09:29 error : (60) Unexpected result state. cmd: 0x00, len: 28 server: @@Xpand-Monitor:node-2 |
2022-09-29 12:09:29 error : (60) Unexpected result state. cmd: 0x00, len: 28 server: @@Xpand-Monitor:node-2 (subsequent similar messages suppressed for 10000 milliseconds) |
I have added one database with 1 table with 2 rows in the master xpand.
Only the database and the table were replicated very slowly, but the two rows in the table never got replicated.
On the same xpands I changed the two maxscales images to version 6.2.3 then I setup the replication again and all the data was replicated.