Details
-
Type:
Bug
-
Status: Open
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 10.0.17
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
Environment: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
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 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.
Gliffy Diagrams
Attachments
Issue Links
- blocks
-
-
- Open
-
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Seems to be a server issue, definetly not ODBC related.
Thanks for your update Richter , Please forward this ticket for particular team.
Thanks.
B.V.M.Prasanth.
Hi,
What exactly do you mean by non-responsive state, what worked and what not? Apparently, you could connect, SHOW SLAVE STATUS worked, while SHOW PROCESSLIST was not, what else?
How exactly did SHOW PROCESSLIST not work, would it hang, would it return an empty set?
When did it happen? As I understand, you were able to run set sql_slave_skip_counter=1, so after the initial replication failure the server was still responsive? Did this SET finish all right? Were you able to run START SLAVE after that, and did it finish all right, or did it hang, or...?
SHOW SLAVE STATUS output looks weird indeed. On one hand, it indicates that SQL threads are running, on the other hand shows an error on SQL thread. Something like that could have happened in some versions with parallel replication, but your config file has no indication that you are using parallel replication, is it so?
Finally, even though you say you ran set sql_slave_skip_counter=1, the error log you attached has no sign of it. Is it really the latest log? Did you check that you had not run out of disk space on the box? (Which could explain both missing records in the log and odd behavior of the server).
Hi Stepanova,
I mean that the MariaDB gone to non-responsive state that means .
when we flush the tables the query is executed but when we are firing on the processlist or to check the show slave status that was executing contentiously for much time and not giving any results.
Please let me know this abnormality in the MariaDB server.
Please update the issue ASAP