Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.0.11
-
None
-
None
-
2017-21
Description
This issue reported by a customer, they dont have the Local Query Feature set, but it shows that replication messages are being sent to the pm nodes. Should only be the UM.
I am concerned about this in the debug.log from the startup:
Sep 28 13:48:26 mcs1-um1 ProcessMonitor[33788]: 26.625489 |0|0|0| I 18 CAL0000: MSG RECEIVED: Run Master Replication script
Sep 28 13:48:26 mcs1-um1 ProcessMonitor[33788]: 26.625545 |0|0|0| D 18 CAL0000: changeMyCnf function called for master
Sep 28 13:48:26 mcs1-um1 DMLProc[42458]: 26.631175 |0|0|0| I 20 CAL0002: DMLProc will rollback 0 tables.
Sep 28 13:48:26 mcs1-um1 DMLProc[42458]: 26.641852 |0|0|0| I 20 CAL0002: DMLProc finished rollbackAll.
Sep 28 13:48:35 mcs1-um1 ProcessMonitor[33788]: 35.720853 |0|0|0| D 18 CAL0000: changeMyCnf function successfully completed
Sep 28 13:48:35 mcs1-um1 ProcessMonitor[33788]: 35.720937 |0|0|0| D 18 CAL0000: runMasterRep function called
Sep 28 13:48:35 mcs1-um1 ProcessMonitor[33788]: 35.721950 |0|0|0| D 18 CAL0000: cmd = /usr/local/mariadb/columnstore/bin/master-rep-columnstore.sh --password='RMSAdmin' --installdir=/usr/local/mariadb/columnstore --hostIP=10.232.52.87 > /tmp/master-rep-columnstore-um1.log 2>&1
Sep 28 13:48:35 mcs1-um1 ProcessMonitor[33788]: 35.771243 |0|0|0| D 18 CAL0000: master-rep-columnstore.sh: Successful return for node um1
Sep 28 13:48:35 mcs1-um1 ProcessMonitor[33788]: 35.771297 |0|0|0| D 18 CAL0000: cmd = /usr/local/mariadb/columnstore/bin/master-rep-columnstore.sh --password='RMSAdmin' --installdir=/usr/local/mariadb/columnstore --hostIP=10.232.52.160 > /tmp/master-rep-columnstore-um2.log 2>&1
Sep 28 13:48:35 mcs1-um1 ProcessMonitor[33788]: 35.819111 |0|0|0| D 18 CAL0000: master-rep-columnstore.sh: Successful return for node um2
Sep 28 13:48:35 mcs1-um1 ProcessMonitor[33788]: 35.819164 |0|0|0| D 18 CAL0000: cmd = /usr/local/mariadb/columnstore/bin/master-rep-columnstore.sh --password='RMSAdmin' --installdir=/usr/local/mariadb/columnstore --hostIP=10.232.52.137 > /tmp/master-rep-columnstore-um3.log 2>&1
Sep 28 13:48:35 mcs1-um1 ProcessMonitor[33788]: 35.865990 |0|0|0| D 18 CAL0000: master-rep-columnstore.sh: Successful return for node um3
Sep 28 13:48:35 mcs1-um1 ProcessMonitor[33788]: 35.866040 |0|0|0| D 18 CAL0000: cmd = /usr/local/mariadb/columnstore/bin/master-rep-columnstore.sh --password='RMSAdmin' --installdir=/usr/local/mariadb/columnstore --hostIP=10.232.52.80 > /tmp/master-rep-columnstore-pm1.log 2>&1
Sep 28 13:48:35 mcs1-um1 ProcessMonitor[33788]: 35.913374 |0|0|0| D 18 CAL0000: master-rep-columnstore.sh: Successful return for node pm1
Sep 28 13:48:35 mcs1-um1 ProcessMonitor[33788]: 35.913426 |0|0|0| D 18 CAL0000: cmd = /usr/local/mariadb/columnstore/bin/master-rep-columnstore.sh --password='RMSAdmin' --installdir=/usr/local/mariadb/columnstore --hostIP=10.232.52.154 > /tmp/master-rep-columnstore-pm2.log 2>&1
Sep 28 13:48:35 mcs1-um1 ProcessMonitor[33788]: 35.960529 |0|0|0| D 18 CAL0000: master-rep-columnstore.sh: Successful return for node pm2
Sep 28 13:48:35 mcs1-um1 ProcessMonitor[33788]: 35.960580 |0|0|0| D 18 CAL0000: cmd = /usr/local/mariadb/columnstore/bin/master-rep-columnstore.sh --password='RMSAdmin' --installdir=/usr/local/mariadb/columnstore --hostIP=10.232.52.61 > /tmp/master-rep-columnstore-pm3.log 2>&1
Sep 28 13:48:36 mcs1-um1 ProcessMonitor[33788]: 36.013787 |0|0|0| D 18 CAL0000: master-rep-columnstore.sh: Successful return for node pm3
Sep 28 13:48:36 mcs1-um1 ProcessMonitor[33788]: 36.013838 |0|0|0| D 18 CAL0000: cmd = /usr/local/mariadb/columnstore/bin/master-rep-columnstore.sh --password='RMSAdmin' --installdir=/usr/local/mariadb/columnstore --hostIP=10.232.52.142 > /tmp/master-rep-columnstore-pm4.log 2>&1
Sep 28 13:48:36 mcs1-um1 ProcessMonitor[33788]: 36.064471 |0|0|0| D 18 CAL0000: master-rep-columnstore.sh: Successful return for node pm4
Sep 28 13:48:36 mcs1-um1 ProcessMonitor[33788]: 36.064527 |0|0|0| D 18 CAL0000: cmd = /usr/local/mariadb/columnstore/bin/master-rep-columnstore.sh --password='RMSAdmin' --installdir=/usr/local/mariadb/columnstore --hostIP=10.232.52.148 > /tmp/master-rep-columnstore-pm5.log 2>&1
Sep 28 13:48:36 mcs1-um1 ProcessMonitor[33788]: 36.111411 |0|0|0| D 18 CAL0000: master-rep-columnstore.sh: Successful return for node pm5
Sep 28 13:48:36 mcs1-um1 ProcessMonitor[33788]: 36.111493 |0|0|0| D 18 CAL0000: runMasterRep: masterlogfile=mysql-bin.000006, masterlogpos=3425
Sep 28 13:48:36 mcs1-um1 ProcessMonitor[33788]: 36.111542 |0|0|0| D 18 CAL0000: runDisableRep function called
Sep 28 13:48:36 mcs1-um1 ProcessMonitor[33788]: 36.111634 |0|0|0| D 18 CAL0000: cmd = /usr/local/mariadb/columnstore/bin/disable-rep-columnstore.sh --password='RMSAdmin' --installdir=/usr/local/mariadb/columnstore > /tmp/disable-rep-columnstore.log 2>&1
Sep 28 13:48:36 mcs1-um1 ProcessMonitor[33788]: 36.139146 |0|0|0| D 18 CAL0000: disable-rep-columnstore.sh: Successful return
Sep 28 13:48:36 mcs1-um1 ProcessMonitor[33788]: 36.139221 |0|0|0| I 18 CAL0000: MASTERREP: ACK back to ProcMgr return status = 0
Sep 28 13:48:59 mcs1-um1 ProcessMonitor[33788]: 59.552185 |0|0|0| I 18 CAL0000: MSG RECEIVED: Update Calpont Config file
Sep 28 13:48:59 mcs1-um1 ProcessMonitor[33788]: 59.552506 |0|0|0| I 18 CAL0000: UPDATECONFIGFILE: Completed
Show processlist on um1 shows the expected replication running to um2 and um3.
The log output above shows a successful response from each of the pm machines.
We disabled the local pm query option last week.
Indeed there is not a mysqld process running on any of the pm's
How could it get a successful response from a machine that is not running mysqld?
Why did it even try to start replication on the pm's?