deadlock with --log-isam=myisam.log --myisam_use_mmap=1 --initialize-insecure
Bug #1713475 reported by
jixianliang
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,
summary: |
- Percona-Server-5.7.18-16 deadlock + deadlock with --log-isam=myisam.log --myisam_use_mmap=1 --initialize- + insecure |
tags: | added: upstream |
To post a comment you must log in.
There is a deadlock even during --initialize- insecure: EMPTY_PASSWORD= 1 --name lp1713475 mysql:5.7 --log-isam= myisam. log --myisam_use_mmap=1
docker run --cap-add sys_ptrace --rm -it -e MYSQL_ALLOW_
I've created upstream: https:/ /bugs.mysql. com/bug. php?id= 87984 /bugs.mysql. com/bug. php?id= 68623 /bugs.mysql. com/bug. php?id= 82958
Probably it will be marked as "Won't fix" due to log-isam feature deprecation:
https:/
https:/
pt-pmp :??(libaio. so.1),LinuxAIOH andler: :collect, LinuxAIOHandler ::poll, os_aio_ handler, fil_aio_ wait,io_ handler_ thread, start_thread, clone cond_wait, os_event: :wait_low, srv_worker_ thread, start_thread, clone join,bootstrap, mysqld_ main,__ libc_start_ main,_start cond_wait, os_event: :wait_low, srv_purge_ coordinator_ thread, start_thread, clone cond_wait, os_event: :wait_low, buf_resize_ thread, start_thread, clone cond_wait, os_event: :wait_low, buf_dump_ thread, start_thread, clone cond_timedwait, os_event: :timed_ wait,os_ event:: wait_time_ low,srv_ monitor_ thread, start_thread, clone cond_timedwait, os_event: :timed_ wait,os_ event:: wait_time_ low,srv_ error_monitor_ thread, start_thread, clone cond_timedwait, os_event: :timed_ wait,os_ event:: wait_time_ low,lock_ wait_timeout_ thread, start_thread, clone cond_timedwait, os_event: :timed_ wait,os_ event:: wait_time_ low,ib_ wqueue_ timedwait, fts_optimize_ thread, start_thread, clone cond_timedwait, os_event: :timed_ wait,os_ event:: wait_time_ low,dict_ stats_thread, start_thread, clone cond_timedwait, os_event: :timed_ wait,os_ event:: wait_time_ low,buf_ flush_page_ cleaner_ coordinator, start_thread, clone os_thread_ sleep,srv_ master_ thread, start_thread, clone os_thread_ sleep,buf_ lru_manager, start_thread, clone __GI___ sigwaitinfo, ::??,start_ thread, clone __sigwait, signal_ hand,pfs_ spawn_thread, start_thread, clone 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
Thu Oct 5 04:29:30 UTC 2017
92 pthread_join.c: No such file or directory.
10 libaio:
3 pthread_
1 pthread_
1 pthread_
1 pthread_
1 pthread_
1 pthread_
1 pthread_
1 pthread_
1 pthread_
1 pthread_
1 pthread_
1 nanosleep,
1 nanosleep,
1 do_sigwaitinfo,
1 do_sigwait,
1 __lll_lock_
Thread 2 (Thread 0x7f93acff9700 (LWP 57)): sysdeps/ unix/sysv/ linux/x86_ 64/lowlevellock .S:135 64-linux- gnu/libpthread. so.0 pthread_ mutex_lock (mutex=0x1e9aa60 <THR_LOCK_myisam>) at ../nptl/ pthread_ mutex_lock. c:79 :open(char const*, int, unsigned int) () :ha_open( TABLE*, char const*, int, int) () from_share( THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool) ()
#0 __lll_lock_wait () at ../nptl/
#1 0x00007f93cb37b479 in _L_lock_909 () from /lib/x86_
#2 0x00007f93cb37b2a0 in __GI___
#3 0x0000000001248a9c in _myisam_log_command ()
#4 0x0000000001244edd in mi_extra ()
#5 0x000000000124f097 in mi_open_share ()
#6 0x000000000122b4ec in ha_myisam:
#7 0x00000000007fe283 in handler:
#8 0x0000000000d068cb in open_table_
#9 0x0000000000c09f2a in open_table(THD*, TABLE_LIST*...