[MDEV-9915] service stop with parallel replication failing Created: 2016-04-13  Updated: 2016-05-28  Resolved: 2016-05-24

Status: Closed
Project: MariaDB Server
Component/s: Platform RedHat, Replication
Affects Version/s: 10.1.12
Fix Version/s: 10.1.13

Type: Bug Priority: Critical
Reporter: Diego Hellas Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Environment:

CentOS 7
MariaDB 10.1.12
Parallel Replication with 16 threads

Attachments: PNG File service_stop.png    

 Description   

I'm using a MariaDB with replication parallel.
Whenever I need to stop the MySQL service, it does not stop effectively.
It seems that a zombie is still up process, but I can not aCesar MySQL.
But if I stop replication before stopping the MySQL service, the MySQL service is stoped successfully.

 Comments   
Comment by Daniel Black [ 2016-04-15 ]

How are you stopping the service?

Can you use gdb to grab a backtrace while it is in its zombie status?

gdb --batch --eval-command="thread apply all bt" program $(pgrep -xn mysqld)

What also are the last messages written to the error log?

If you do a STOP SLAVE SQL_THREAD; does this complete ok?

What are your replication settings? What version is the master? Are you replicating in gtid mode? Are you using any aggressive mode replication?

Comment by Kristian Nielsen [ 2016-04-15 ]

It sounds like it could be the same problem as MDEV-9595, which should be fixed in 10.1.13.

Maybe you can test if the patch for MDEV-9595 also fixes your issue? Either by installing 10.1.13, or by applying the patch from here:

http://lists.askmonty.org/pipermail/commits/2016-March/009069.html

Comment by Diego Hellas [ 2016-04-18 ]

@Daniel, look the attachment.

Comment by Elena Stepanova [ 2016-05-18 ]

diegohellas, have you had a chance to upgrade to 10.1.13 as Kristian suggested above? If you had, have you experienced the problem since then?

Comment by Diego Hellas [ 2016-05-24 ]

@Elena, in MariaDB 10.1.13 works.
I'll upgrade.
Thanks!

Comment by Kristian Nielsen [ 2016-05-24 ]

Ok, closing then as duplicate of MDEV-9595, thanks for your time looking into this!

  • Kristian.
Generated at Thu Feb 08 07:38:16 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.