There is a deadlock even during --initialize-insecure: docker run --cap-add sys_ptrace --rm -it -e MYSQL_ALLOW_EMPTY_PASSWORD=1 --name lp1713475 mysql:5.7 --log-isam=myisam.log --myisam_use_mmap=1
I've created upstream: https://bugs.mysql.com/bug.php?id=87984 Probably it will be marked as "Won't fix" due to log-isam feature deprecation: https://bugs.mysql.com/bug.php?id=68623 https://bugs.mysql.com/bug.php?id=82958 pt-pmp Thu Oct 5 04:29:30 UTC 2017 92 pthread_join.c: No such file or directory. 10 libaio::??(libaio.so.1),LinuxAIOHandler::collect,LinuxAIOHandler::poll,os_aio_handler,fil_aio_wait,io_handler_thread,start_thread,clone 3 pthread_cond_wait,os_event::wait_low,srv_worker_thread,start_thread,clone 1 pthread_join,bootstrap,mysqld_main,__libc_start_main,_start 1 pthread_cond_wait,os_event::wait_low,srv_purge_coordinator_thread,start_thread,clone 1 pthread_cond_wait,os_event::wait_low,buf_resize_thread,start_thread,clone 1 pthread_cond_wait,os_event::wait_low,buf_dump_thread,start_thread,clone 1 pthread_cond_timedwait,os_event::timed_wait,os_event::wait_time_low,srv_monitor_thread,start_thread,clone 1 pthread_cond_timedwait,os_event::timed_wait,os_event::wait_time_low,srv_error_monitor_thread,start_thread,clone 1 pthread_cond_timedwait,os_event::timed_wait,os_event::wait_time_low,lock_wait_timeout_thread,start_thread,clone 1 pthread_cond_timedwait,os_event::timed_wait,os_event::wait_time_low,ib_wqueue_timedwait,fts_optimize_thread,start_thread,clone 1 pthread_cond_timedwait,os_event::timed_wait,os_event::wait_time_low,dict_stats_thread,start_thread,clone 1 pthread_cond_timedwait,os_event::timed_wait,os_event::wait_time_low,buf_flush_page_cleaner_coordinator,start_thread,clone 1 nanosleep,os_thread_sleep,srv_master_thread,start_thread,clone 1 nanosleep,os_thread_sleep,buf_lru_manager,start_thread,clone 1 do_sigwaitinfo,__GI___sigwaitinfo,::??,start_thread,clone 1 do_sigwait,__sigwait,signal_hand,pfs_spawn_thread,start_thread,clone 1 __lll_lock_wait,_L_lock_909(libpthread.so.0),__GI___pthread_mutex_lock,_myisam_log_command,mi_extra,mi_open_share,ha_myisam::open,handler::ha_open,open_table_from_share,open_table,open_tables,open_and_lock_tables,mysql_execute_command,mysql_parse,::??,handle_bootstrap,pfs_spawn_thread,start_thread,clone Thread 2 (Thread 0x7f93acff9700 (LWP 57)): #0 __lll_lock_wait () at ../nptl/sysdeps/unix/sysv/linux/x86_64/lowlevellock.S:135 #1 0x00007f93cb37b479 in _L_lock_909 () from /lib/x86_64-linux-gnu/libpthread.so.0 #2 0x00007f93cb37b2a0 in __GI___pthread_mutex_lock (mutex=0x1e9aa60 <THR_LOCK_myisam>) at ../nptl/pthread_mutex_lock.c:79 #3 0x0000000001248a9c in _myisam_log_command () #4 0x0000000001244edd in mi_extra () #5 0x000000000124f097 in mi_open_share () #6 0x000000000122b4ec in ha_myisam::open(char const*, int, unsigned int) () #7 0x00000000007fe283 in handler::ha_open(TABLE*, char const*, int, int) () #8 0x0000000000d068cb in open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool) () #9 0x0000000000c09f2a in open_table(THD*, TABLE_LIST*, Open_table_context*) () #10 0x0000000000c10f66 in open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) () #11 0x0000000000c11654 in open_and_lock_tables(THD*, TABLE_LIST*, unsigned int, Prelocking_strategy*) () #12 0x0000000000c666dd in mysql_execute_command(THD*, bool) () #13 0x0000000000c69e15 in mysql_parse(THD*, Parser_state*) () #14 0x00000000007cce18 in ?? () #15 0x00000000007cd2bc in handle_bootstrap () #16 0x0000000000eb2674 in pfs_spawn_thread () #17 0x00007f93cb379064 in start_thread (arg=0x7f93acff9700) at pthread_create.c:309 #18 0x00007f93c93b962d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111 ** Also affects: percona-server/5.5 Importance: Undecided Status: New ** Also affects: percona-server/5.7 Importance: Undecided Status: New ** Also affects: percona-server/5.6 Importance: Undecided Status: New ** Changed in: percona-server/5.7 Status: New => Confirmed ** Bug watch added: MySQL Bug System #87984 http://bugs.mysql.com/bug.php?id=87984 ** Also affects: mysql-server via http://bugs.mysql.com/bug.php?id=87984 Importance: Unknown Status: Unknown ** Bug watch added: MySQL Bug System #68623 http://bugs.mysql.com/bug.php?id=68623 ** Bug watch added: MySQL Bug System #82958 http://bugs.mysql.com/bug.php?id=82958 -- You received this bug notification because you are a member of Ubuntu Server/Client Support Team, which is subscribed to MySQL. Matching subscriptions: Ubuntu Server/Client Support Team https://bugs.launchpad.net/bugs/1713475 Title: Percona-Server-5.7.18-16 deadlock To manage notifications about this bug go to: https://bugs.launchpad.net/mysql-server/+bug/1713475/+subscriptions -- Mailing list: https://launchpad.net/~enterprise-support Post to : [email protected] Unsubscribe : https://launchpad.net/~enterprise-support More help : https://help.launchpad.net/ListHelp
