[MCOL-1217] newly added user module didnt have mysql replication slave setup Created: 2018-02-16  Updated: 2018-04-17  Resolved: 2018-04-17

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.1.3
Fix Version/s: 1.1.4

Type: Bug Priority: Major
Reporter: David Hill (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

amazon ami 1.1.3


Sprint: 2018-04, 2018-05, 2018-06, 2018-07, 2018-08

 Description   

started with 1um/2pm system ami created, added um2 succesfully. check for mysql rep slave and it was setup.

MariaDB [(none)]> show slave status\G;
Empty set (0.00 sec)

ERROR: No query specified

MariaDB [(none)]> exit
Bye
[mariadb-user@ip-172-30-0-165 ~]$ module
um2
[mariadb-user@ip-172-30-0-165 ~]$



 Comments   
Comment by David Hill (Inactive) [ 2018-02-16 ]

problem is because we removed the mysql rep setup after the startsystem, which now causes this issue. need to investigate further

Comment by David Hill (Inactive) [ 2018-02-17 ]

work around fix..

after module has been added, enabled started. run the following command to get the MariaDB/MySQL Replication setup on it.

mcsadmin enableMySQLReplication

Comment by David Hill (Inactive) [ 2018-03-15 ]

fixed.. code changes

1. ProcMgr addModule at the end:
start mysqld on new modules
call setupmysqlrep()
stop mysqld on new modules
2. Changed in ProcMgr setupmysqlrep to allow sending to a newly addmodule that was disabled
3. ProcMon removed a check in the master rep setup where it checks if module is active, not
needed
4. postConfigure - in helper.ccp, removed a comment out error on mysqlrep when a module is
disabled.

Comment by David Hill (Inactive) [ 2018-03-15 ]

https://github.com/mariadb-corporation/mariadb-columnstore-engine/pull/429

Comment by David Hill (Inactive) [ 2018-03-15 ]

To test...

Addmodule 0n a um or local query pm.
Enablemodule / startsystem

Check mysql rep slave setup on new module

Comment by Daniel Lee (Inactive) [ 2018-04-17 ]

Reproduced the issue in 1.1.3-1

Comment by Daniel Lee (Inactive) [ 2018-04-17 ]

Build verified: 1.1.4-1 ami (ami-66036f1e, US-west)

Verified that replication slave started after adding um2 and enabling the it.

MariaDB [(none)]> show slave status\G;

                                                      • 1. row ***************************
                                                        Slave_IO_State: Waiting for master to send event
                                                        Master_Host: 172.31.23.245
                                                        Master_User: idbrep
                                                        Master_Port: 3306
                                                        Connect_Retry: 60
                                                        Master_Log_File: mysql-bin.000002
                                                        Read_Master_Log_Pos: 150465221
                                                        Relay_Log_File: relay-bin.000004
                                                        Relay_Log_Pos: 555
                                                        Relay_Master_Log_File: mysql-bin.000002
                                                        Slave_IO_Running: Yes
                                                        Slave_SQL_Running: Yes
                                                        Replicate_Do_DB:
                                                        Replicate_Ignore_DB:
                                                        Replicate_Do_Table:
                                                        Replicate_Ignore_Table:
                                                        Replicate_Wild_Do_Table:
                                                        Replicate_Wild_Ignore_Table:
                                                        Last_Errno: 0
                                                        Last_Error:
                                                        Skip_Counter: 0
                                                        Exec_Master_Log_Pos: 150465221
                                                        Relay_Log_Space: 858
                                                        Until_Condition: None
                                                        Until_Log_File:
                                                        Until_Log_Pos: 0
                                                        Master_SSL_Allowed: No
                                                        Master_SSL_CA_File:
                                                        Master_SSL_CA_Path:
                                                        Master_SSL_Cert:
                                                        Master_SSL_Cipher:
                                                        Master_SSL_Key:
                                                        Seconds_Behind_Master: 0
                                                        Master_SSL_Verify_Server_Cert: No
                                                        Last_IO_Errno: 0
                                                        Last_IO_Error:
                                                        Last_SQL_Errno: 0
                                                        Last_SQL_Error:
                                                        Replicate_Ignore_Server_Ids:
                                                        Master_Server_Id: 1
                                                        Master_SSL_Crl:
                                                        Master_SSL_Crlpath:
                                                        Using_Gtid: No
                                                        Gtid_IO_Pos:
                                                        Replicate_Do_Domain_Ids:
                                                        Replicate_Ignore_Domain_Ids:
                                                        Parallel_Mode: conservative
                                                        SQL_Delay: 0
                                                        SQL_Remaining_Delay: NULL
                                                        Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it
                                                        1 row in set (0.00 sec)
Generated at Thu Feb 08 02:27:05 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.