[MDEV-14568] Server does not shut down with SIGTERM after installing Spider 3.3 plugin Created: 2017-12-04  Updated: 2017-12-21  Resolved: 2017-12-12

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Spider
Affects Version/s: 10.3
Fix Version/s: 10.3.3

Type: Bug Priority: Major
Reporter: Simon Mudd Assignee: Jacob Mathew (Inactive)
Resolution: Fixed Votes: 0
Labels: 10.3, hang, shutdown, spider, stuck
Environment:

Reproduces in the 10.3 and bb-10.2-spider branches.


Issue Links:
Relates
relates to MDEV-14577 Server Shutdown hangs after installin... Closed

 Description   

Problem: After installing the spider plugin I tried to shut the server down and it just stuck.

  • Compiled from source on CentOS 7
  • installed into /usr/local/mysql via make install.
  • I ran a clean setup into an empty datadir. /usr/local/mysql/scripts/mysql_install_db --user=mysql --datadir=/path/to/datadir
  • Started mysqld with /usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --user=mysql
  • I installed the spider plugin with: mysql < /usr/local/mysql/share//install_spider.sql
  • I tried to stop the server with KILL -TERM to mysqld process

Logging from server shows:

2017-12-04 16:13:54 0 [Note] Got signal 15 to shutdown mysqld
2017-12-04 16:13:54 0 [Note] /usr/local/mysql/bin/mysqld (unknown): Normal shutdown
 
2017-12-04 16:13:54 0 [Note] InnoDB: FTS optimize thread exiting.
2017-12-04 16:13:54 0 [Note] Event Scheduler: Killing the scheduler thread, thread id 6
2017-12-04 16:13:54 0 [Note] Event Scheduler: Waiting for the scheduler thread to reply
2017-12-04 16:13:54 0 [Note] Event Scheduler: Stopped
2017-12-04 16:13:54 0 [Note] Event Scheduler: Purging the queue. 0 events
2017-12-04 16:15:43 0 [Note] Got signal 15 to shutdown mysqld
2017-12-04 16:16:03 0 [Note] Got signal 15 to shutdown mysqld
2017-12-04 16:16:05 0 [Note] Got signal 15 to shutdown mysqld

but it does not shutdown.

There is no specific spider configuration (yet).

Build is from commit: 60c446584c614f19f9 in branch 10.3

My expectation is that mysqld would close down cleanly and stop.



 Comments   
Comment by Jacob Mathew (Inactive) [ 2017-12-06 ]

Kentoku, please review my fix for this problem 04a4b21 in my branch.

Comment by Kentoku Shiba (Inactive) [ 2017-12-12 ]

Jacob, it's ok to push. Thank you for fixing.

Comment by Jacob Mathew (Inactive) [ 2017-12-12 ]

MDEV-14568: Server does not shut down with SIGTERM after installing
Spider 3.3 plugin

  • Server shutdown hangs when it waits for the new Spider 3.3 table
    background threads to stop despite being unable to signal them to stop
  • Changed the way that the new Spider 3.3 table background threads are
    created in order to enable server shutdown to signal them to stop

Fix pushed to 10.3 in commit 751e0f6
Fix pushed to bb-10.2-spider in commit c4d9212

Comment by Aurélien LEQUOY [ 2017-12-21 ]

technically i got this problem too but it take a lot of
................. time

Generated at Thu Feb 08 08:14:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.