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

Bug #1713475 reported by jixianliang on 2017-08-28
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL Server
Unknown
Unknown
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.5
New
Undecided
Unassigned
5.6
New
Undecided
Unassigned
5.7
Triaged
High
Unassigned

Bug Description

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) wrote :
Download full text (3.8 KiB)

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

Read more...

summary: - Percona-Server-5.7.18-16 deadlock
+ deadlock with --log-isam=myisam.log --myisam_use_mmap=1 --initialize-
+ insecure
tags: added: upstream

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

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.