PS 5.6-QA tree in revid 418 (and earlier) locks up in mysqld
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Invalid
|
Critical
|
Roel Van de Paar | ||
Random Query Generator |
Fix Committed
|
Critical
|
Roel Van de Paar |
Bug Description
[roel@qaserver randgen]$ /ssd/Percona-
(...nothing happens...)
^C
[roel@qaserver randgen]$ gdb /ssd/Percona-
[...]
(gdb) thread apply all bt
+thread apply all bt
Thread 1 (process 25247):
+bt
#0 0x0000003636edf253 in poll () from /lib64/libc.so.6
#1 0x00000000005a44ba in handle_
#2 0x00000000005ab49b in mysqld_main (argc=73, argv=0x267a208) at /bzr/5.
#3 0x0000003636e1ecdd in __libc_start_main () from /lib64/libc.so.6
#4 0x000000000059c735 in _start ()
information type: | Public → Public Security |
[roel@qaserver randgen]$ ps -ef | grep 25247 Server- 5.6.12- rc60.4- 418-debug. Linux.x86_ 64/bin/ mysqld --no-defaults --basedir= /ssd/Percona- Server- 5.6.12- rc60.4- 418-debug. Linux.x86_ 64 --character- sets-dir= /ssd/Percona- Server- 5.6.12- rc60.4- 418-debug. Linux.x86_ 64/share/ charsets --secure- file-priv= /ssd//236684/ current1_ 8 --log-bin- trust-function- creators --character- set-server= latin1 --lc-messages- dir=/ssd/ Percona- Server- 5.6.12- rc60.4- 418-debug. Linux.x86_ 64/share --tmpdir= /ssd//236684/ current1_ 8/tmp --connect- timeout= 60 --pid-file= /ssd//236684/ current1_ 8/run/master. pid --port=13140 --socket= /ssd//236684/ current1_ 8/tmp/master. sock --datadir= /ssd//236684/ current1_ 8/master- data --log-output= table,file --general-log --general- log-file= /ssd//236684/ current1_ 8/log/master. log --slow-query-log --slow- query-log- file=/ssd/ /236684/ current1_ 8/log/master- slow.log --server-id=1 --loose- innodb_ data_file_ path=ibdata1: 10M:autoextend --local-infile --loose- skip-ndbcluster --key_buffer_ size=1M --sort_buffer=256K --max_heap_ table_size= 1M --ssl-ca= /ssd/Percona- Server- 5.6.12- rc60.4- 418-debug. Linux.x86_ 64/mysql- test/std_ data/cacert. pem --ssl-cert= /ssd/Percona- Server- 5.6.12- rc60.4- 418-debug. Linux.x86_ 64/mysql- test/std_ data/server- cert.pem --ssl-key= /ssd/Percona- Server- 5.6.12- rc60.4- 418-debug. Linux.x86_ 64/mysql- test/std_ data/server- key.pem --core-file --loose-new --sql-mode= no_engine_ substitution --relay- log=slave- relay-bin --loose-innodb --secure-file-priv= --max-allowed- packet= 16Mb --loose- innodb- status- file=1 --master- retry-count= 65535 --loose- debug-assert- if-crashed- table --loose- debug-assert- on-error --skip-name-resolve --log-output=none --sql_mode= ONLY_FULL_ GROUP_BY --utility- user-password= test --innodb_ change_ buffering= inserts --innodb_ changed_ pages=FORCE --innodb_ flush_log_ at_trx_ commit= 2 --innodb_ flush_method= O_DIRECT --innodb_ log_arch_ dir=/ssd/ /236684/ _epoch/ 137871087080567 2167 --innodb_ log_archive= 1 --innodb_ log_block_ size=4096 --innodb_ log_buffer_ size=1048576 --innodb_ log_files_ in_group= 3 --innodb_ max_changed_ pages=0 --innodb_ track_changed_ pages=1 --innodb_ use_global_ flush_log_ at_trx_ commit= 0 --innodb- buffer- pool-populate --loose- readonly- key-cache- division- limit=1 --query_ cache_size= 1048576 --query_ cache_type= 1 --readonly- key-cache- block-size= 1 --readonly- loose-max- connect- errors= 1 --skip- innodb_ doublewrite --thread_ handling= pool-of- threads --userstat --utility- user=roel@ % --utility- user-schema- access= mysqlinformatio n_schema --innodb_ purge_threads= 1 --innodb_ adaptive_ hash_index_ partitions= 16 --innodb_ buffer_ pool_instances= 4 --skip-log-bin --core-file --open- files-limit= 1024
roel 25247 1 0 17:14 pts/1 00:00:22 /ssd/Percona-