[draft] dirty buffer pool pages at the end of shutdown

[Laurynas Biveinis]

On 5.6 trunk:

innodb_zip.innodb_wl6347_comp_indx_stat w4 [ fail ] Found warnings/errors in server log file!
        Test ended at 2017-03-25 10:10:25
line
Attempting backtrace. You can use the following information to find out
^ Found warnings in /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/debian-jessie-64bit/build/mysql-test/var/4/log/mysqld.1.err
ok
...
Program terminated with signal SIGABRT, Aborted.
#0 0x00007f4a79e810c1 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
61 ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c: No such file or directory.
#0 0x00007f4a79e810c1 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x0000000000ac9dea in my_write_core (sig=6) at /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/debian-jessie-64bit/mysys/stacktrace.c:424
#2 0x000000000073c192 in handle_fatal_signal (sig=6) at /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/debian-jessie-64bit/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x00007f4a78014067 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5 0x00007f4a78015448 in __GI_abort () at abort.c:89
#6 0x0000000000d2ceab in buf_flush_page_cleaner_thread (arg=0x0) at /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/debian-jessie-64bit/storage/innobase/buf/buf0flu.cc:2807
#7 0x00007f4a79e7c064 in start_thread (arg=0x7f4a633f8700) at pthread_create.c:309
#8 0x00007f4a780c762d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
...
Thread 12 (Thread 0x7f4a4ffff700 (LWP 4035)):
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185
#1 0x0000000000bd41d3 in os_cond_wait (cond=0x1ceba58, fast_mutex=0x1ceba20) at /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/debian-jessie-64bit/storage/innobase/os/os0sync.cc:196
#2 0x0000000000bd4506 in os_event_wait_low (event=0x1ceba20, reset_sig_count=42) at /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/debian-jessie-64bit/storage/innobase/os/os0sync.cc:477
#3 0x0000000000d2acf2 in buf_flush_wait_batch_end (buf_pool=0x1cd37d8, type=BUF_FLUSH_LRU) at /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/debian-jessie-64bit/storage/innobase/buf/buf0flu.cc:1925
#4 0x0000000000d2b6c5 in buf_flush_LRU_tail () at /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/debian-jessie-64bit/storage/innobase/buf/buf0flu.cc:2270
#5 0x0000000000d2cfdd in buf_flush_lru_manager_thread (arg=0x0) at /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/debian-jessie-64bit/storage/innobase/buf/buf0flu.cc:2868
#6 0x00007f4a79e7c064 in start_thread (arg=0x7f4a4ffff700) at pthread_create.c:309
#7 0x00007f4a780c762d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

I/O handler threads are idle.

It is not clear why the LRU flusher is stuck on waiting for a batch to complete.

This could be related to https://bugs.mysql.com/bug.php?id=85585

[Laurynas Biveinis (laurynas-biveinis)]

See bug 1689552

[Laurynas Biveinis (laurynas-biveinis)]

This could have been fixed by fixing bug 1689552, let's wait for a reoccurrence.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-3669