Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6
-
None
-
None
Description
Executing the Change Master(CM) with too long string as master_password , After the the CM command fails with a string is too long. The show slave status shows the output and the error log doesn't log the CM command. As the CM command failed with an error, the SSS should be empty? The SSS show slave status shows the output after the CM failure, then CM should be logged in the error log.
|
15:40:13 [(none)]> reset slave all;
|
Query OK, 0 rows affected (0.005 sec)
|
|
15:41:31 [(none)]> show slave status\G
|
Empty set (0.002 sec)
|
|
15:41:31 [(none)]> change master to master_host='mariadb1',master_port=6606,master_password='bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb';
|
ERROR 1470 (HY000): String 'bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb...' is too long for MASTER_PASSWORD (should be no longer than 96)
|
15:41:31 [(none)]> show slave status\G
|
*************************** 1. row ***************************
|
Slave_IO_State:
|
Master_Host: mariadb1
|
Master_User:
|
Master_Port: 3306
|
Connect_Retry: 60
|
Master_Log_File:
|
Read_Master_Log_Pos: 4
|
Relay_Log_File: mariadb2-relay-bin.000001
|
Relay_Log_Pos: 4
|
Relay_Master_Log_File:
|
Slave_IO_Running: No
|
Slave_SQL_Running: No
|
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: 0
|
Relay_Log_Space: 256
|
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: NULL
|
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: 1000
|
Master_SSL_Crl:
|
Master_SSL_Crlpath:
|
Using_Gtid: No
|
Gtid_IO_Pos:
|
Replicate_Do_Domain_Ids:
|
Replicate_Ignore_Domain_Ids:
|
Parallel_Mode: optimistic
|
SQL_Delay: 0
|
SQL_Remaining_Delay: NULL
|
Slave_SQL_Running_State:
|
Slave_DDL_Groups: 2
|
Slave_Non_Transactional_Groups: 0
|
Slave_Transactional_Groups: 0
|
|
Error log:
2024-04-09 15:40:46 53 [Warning] Aborted connection 36 to db: 'unconnected' user: 'unauthenticated' host: '' (KILLED)
|
2024-04-09 15:40:46 36 [Note] Slave I/O thread exiting, read up to log 'mariadb1-bin.000001', position 596; GTID position 1-1000-2, master 172.20.0.2:3306
|
2024-04-09 15:41:13 54 [Note] Deleted Master_info file '/var/lib/mysql/master.info'.
|
2024-04-09 15:41:13 54 [Note] Deleted Master_info file '/var/lib/mysql/relay-log.info'.
|
2024-04-09 15:41:31 54 [Note] Master connection name: '' Master_info_file: 'master.info' Relay_info_file: 'relay-log.info'
|