Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.0.17
-
None
-
Windows 64 bit Operating system
Description
Hi Team,
We are facing a problem in the slave server, That the Slave server gone to the non-responsive state,we are unable to check the Process list in the server.we Identified that
Slave_IO_Running Yes
|
Slave_SQL_Running Yes
|
but there is a error in the
Last_Errno 1146
|
Last_Error Error 'Table 'test.dishnetobdcounts' doesn't exist' on query. Default database: 'test'. Query: 'truncate dishnetobdcounts'
|
by looking this error we tried to sql_skip_counter=1 but the slave gone to non-responsive state, but we are able to connect to that server
Please find the slave status below
Delay is 66647 Seconds
|
Slave_IO_State Waiting for master to send event
|
Master_Host 172.19.0.6
|
Master_User replication
|
Master_Port 3306
|
Connect_Retry 10
|
Master_Log_File mysql-bin.001230
|
Read_Master_Log_Pos 494636242
|
Relay_Log_File Assam_RepDB-relay-bin.003629
|
Relay_Log_Pos 719757010
|
Relay_Master_Log_File mysql-bin.001214
|
|
ATTENTION: |
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
|
|
ATTENTION: |
Last_Errno 1146
|
Last_Error Error 'Table 'test.dishnetobdcounts' doesn't exist' on query. Default database: 'test'. Query: 'truncate dishnetobdcounts'
|
Skip_Counter 0
|
Exec_Master_Log_Pos 719756723
|
Relay_Log_Space 18748274523
|
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 66647
|
Master_SSL_Verify_Server_Cert No
|
Last_IO_Errno 0
|
Last_IO_Error
|
Last_SQL_Errno 1146
|
Last_SQL_Error Error 'Table 'test.dishnetobdcounts' doesn't exist' on query. Default database: 'test'. Query: 'truncate dishnetobdcounts'
|
Replicate_Ignore_Server_Ids
|
Master_Server_Id 1
|
Master_SSL_Crl
|
Master_SSL_Crlpath
|
Using_Gtid No
|
Gtid_IO_Pos
|
Version:
|
MySQL Version : 5.5.5-10.0.17-MariaDB-log
|
Port : 3306
|
Server Default Charset : latin1
|
Thanks.
