deadlock with --log-isam=myisam.log --myisam_use_mmap=1 --initialize-insecure

[jixianliang]

With both myisam_use_mmap and log-isam enabled，Percona-Server-5.7.18-16 deadlock happened when running statement 'Load Data' against a Myisam table.

[Nickolay Ihalainen (ihanick)]

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*...

[Shahriyar Rzayev (rzayev-sehriyar)]

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