| Bug #71390 | Replicator is not running. | ||
|---|---|---|---|
| Submitted: | 15 Jan 2014 14:50 | Modified: | 16 Jan 2014 17:48 |
| Reporter: | Oguzhan Isleyen | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server: Replication | Severity: | S2 (Serious) |
| Version: | 5.0.46 | OS: | Solaris |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | master, Replicator, slave | ||
[16 Jan 2014 17:48]
Sveta Smirnova
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug. Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/ Thank you for your interest in MySQL.
Description: I have entered the following command, mysql> show slave status\G; *************************** 1. row *************************** Slave_IO_State: Connecting to master Master_Host: unit0-priv0 Master_User: mysql_repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.002174 Read_Master_Log_Pos: 169 Relay_Log_File: unit0-relay-bin.000032 Relay_Log_Pos: 98 Relay_Master_Log_File: mysql-bin.002174 Slave_IO_Running: No 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: 169 Relay_Log_Space: 98 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 1 row in set (0.00 sec) ERROR: No query specified mysql> Therefore, i can not switch activity to other unit, reboot (etc). It seems that, Slave_IO_Running: No and Seconds_Behind_Master: NULL must be 'Yes' and '0' respectively. I have tried "change to ..." commands to some parameter but it can not successfully. How can i solve this problem? Regards. How to repeat: unit1(inactive):/> mysqlServer restart Shutting down MySQL . SUCCESS! Starting MySQL . SUCCESS! unit1(inactive):/> problem is still going on...