[MDEV-8783] Replications Got Struct in the slave server. Created: 2015-09-09  Updated: 2023-01-22  Resolved: 2023-01-22

Status: Closed
Project: MariaDB Server
Component/s: Replication
Affects Version/s: 10.0.17
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: PrasanthBVM Assignee: Unassigned
Resolution: Cannot Reproduce Votes: 0
Labels: None
Environment:

Windows 64 bit Operating system

Attachments: File Assam_RepDB.err     PNG File MariaDB_sc1.PNG     PNG File MariaDB_sc2.PNG     File my.ini    

 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.

 Comments   
Comment by PrasanthBVM [ 2015-09-09 ]

Please update the issue ASAP

Comment by Georg Richter [ 2015-09-09 ]

Seems to be a server issue, definetly not ODBC related.

Comment by PrasanthBVM [ 2015-09-10 ]

Thanks for your update Richter , Please forward this ticket for particular team.

Thanks.
B.V.M.Prasanth.

Comment by Elena Stepanova [ 2015-09-10 ]

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).

Comment by PrasanthBVM [ 2015-09-14 ]

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.

Generated at Thu Feb 08 07:29:46 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.