Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.2(EOL)
-
None
Description
To reproduce:
- start server with all defaults;
- run mysql -e "set global innodb_spin_wait_delay = 164723660; shutdown"
- wait
It takes a while (up to a couple of minutes on my machine), but eventually the server goes down with the assertion failure:
2016-12-30 17:57:50 140352190149376 [Note] /data/bld/10.2/bin/mysqld (root[root] @ localhost [127.0.0.1]): Normal shutdown
|
|
|
2016-12-30 17:57:50 140352190149376 [Note] Event Scheduler: Purging the queue. 0 events
|
mysqld: /data/src/10.2/sql/sql_list.h:665: void ilink::assert_linked(): Assertion `prev != 0 && next != 0' failed.
|
161230 17:58:15 [ERROR] mysqld got signal 6 ;
|
..
|
#6 0x00007fbb74a9c266 in __assert_fail_base (fmt=0x7fbb74bd5238 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x7fbb77fd3ece "prev != 0 && next != 0", file=file@entry=0x7fbb77fd3eb0 "/data/src/10.2/sql/sql_list.h", line=line@entry=665, function=function@entry=0x7fbb77fddd30 <ilink::assert_linked()::__PRETTY_FUNCTION__> "void ilink::assert_linked()") at assert.c:92
|
#7 0x00007fbb74a9c312 in __GI___assert_fail (assertion=0x7fbb77fd3ece "prev != 0 && next != 0", file=0x7fbb77fd3eb0 "/data/src/10.2/sql/sql_list.h", line=665, function=0x7fbb77fddd30 <ilink::assert_linked()::__PRETTY_FUNCTION__> "void ilink::assert_linked()") at assert.c:101
|
#8 0x00007fbb774ab553 in ilink::assert_linked (this=0x7fbb33416070) at /data/src/10.2/sql/sql_list.h:665
|
#9 0x00007fbb774ac5ee in unlink_not_visible_thd (thd=0x7fbb33416070) at /data/src/10.2/sql/sql_class.h:4409
|
#10 0x00007fbb7749e846 in delete_running_thd (thd=0x7fbb33416070) at /data/src/10.2/sql/mysqld.cc:2909
|
#11 0x00007fbb7753a4b3 in destroy_thd (thd=0x7fbb33416070) at /data/src/10.2/sql/sql_class.cc:4481
|
#12 0x00007fbb77a1e35b in innobase_destroy_background_thd (thd=0x7fbb33416070) at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:1815
|
#13 0x00007fbb77beb9bb in srv_worker_thread (arg=0x0) at /data/src/10.2/storage/innobase/srv/srv0srv.cc:2800
|
#14 0x00007fbb76ba90a4 in start_thread (arg=0x7fbb353f8700) at pthread_create.c:309
|
#15 0x00007fbb74b5687d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
On 10.1 or MySQL 5.7 the shutdown is also slow, which I assume is totally expected, but it ends all right, without any trouble:
|
5.7 |
2016-12-30T15:50:12.438654Z 0 [Note] InnoDB: Starting shutdown...
|
2016-12-30T15:50:12.538897Z 0 [Note] InnoDB: Dumping buffer pool(s) to /data/bld/mysql-5.7/data/ib_buffer_pool
|
2016-12-30T15:50:12.545087Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 161230 17:50:12
|
2016-12-30T15:51:12.576742Z 0 [Note] InnoDB: Waiting for worker threads to be suspended
|
2016-12-30T15:51:32.666637Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2396622
|
2016-12-30T15:51:32.671000Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
|
2016-12-30T15:51:32.672984Z 0 [Note] /data/bld/mysql-5.7/bin/mysqld: Shutdown complete
|
|
10.1 |
2016-12-30 17:51:56 139709912304384 [Note] /data/bld/10.1/bin/mysqld: Normal shutdown
|
|
|
2016-12-30 17:51:56 139709912304384 [Note] Event Scheduler: Purging the queue. 0 events
|
2016-12-30 17:51:56 139709141473024 [Note] InnoDB: FTS optimize thread exiting.
|
2016-12-30 17:51:56 139709912304384 [Note] InnoDB: Starting shutdown...
|
2016-12-30 17:51:56 139709912304384 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
|
2016-12-30 17:53:15 139709912304384 [Note] InnoDB: Shutdown completed; log sequence number 1662538
|
2016-12-30 17:53:15 139709912304384 [Note] /data/bld/10.1/bin/mysqld: Shutdown complete
|
Attachments
Issue Links
- duplicates
-
-
- Closed
-