← Back to team overview

enterprise-support team mailing list archive

[Bug 1713475] Re: Percona-Server-5.7.18-16 deadlock

 

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