abort in handler::ha_thd | sql/handler.cc:2419: THD* handler::ha_thd() const: Assertion `!table || !table->in_use || table->in_use == _current_thd()' failed. (sig6)
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Invalid
|
High
|
Unassigned | ||
5.1 |
Won't Fix
|
Undecided
|
Unassigned | ||
5.5 |
Invalid
|
High
|
Unassigned | ||
5.6 |
Invalid
|
High
|
Unassigned |
Bug Description
Thread 1 (LWP 18612):
+bt
#0 0x000000340cc0c69c in pthread_kill () from /lib64/
#1 0x0000000000686bde in handle_fatal_signal (sig=6) at /bzr/5.
#2 <signal handler called>
#3 0x000000340c4328a5 in raise () from /lib64/libc.so.6
#4 0x000000340c434085 in abort () from /lib64/libc.so.6
#5 0x000000340c42ba1e in __assert_fail_base () from /lib64/libc.so.6
#6 0x000000340c42bae0 in __assert_fail () from /lib64/libc.so.6
#7 0x00000000005b9dec in handler::ha_thd (this=0x7fde341
#8 0x00000000009f6f81 in ha_innobase:
#9 0x00000000005b376c in handler:
#10 0x000000000085050a in lock_external (count=2, tables=<optimized out>, thd=0x3062a60) at /bzr/5.
#11 mysql_lock_tables (thd=0x3062a60, tables=
#12 0x00000000006c35fb in lock_tables (thd=0x3062a60, tables=
#13 0x00000000007490ff in mysql_select (thd=0x3062a60, tables=
#14 0x0000000000749dbb in handle_select (thd=0x3062a60, result=
#15 0x0000000000726748 in mysql_execute_
#16 0x0000000000727818 in mysql_parse (thd=0x3062a60, rawbuf=0x3064e28 "\360R7\001", length=<optimized out>, parser_
#17 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x3062a60, packet=0x310fae1 " INSERT INTO z SELECT * FROM `table100_
#18 0x0000000000729a47 in do_command (thd=0x3062a60) at /bzr/5.
#19 0x00000000006ed63f in do_handle_
#20 0x00000000006ed727 in handle_
#21 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x2f13790) at /bzr/5.
#22 0x000000340cc07851 in start_thread () from /lib64/
#23 0x000000340c4e890d in clone () from /lib64/libc.so.6
[...]
2013-07-19 22:45:00 18509 [ERROR] /ssd/Percona-
2013-07-19 22:45:00 18509 [ERROR] /ssd/Percona-
2013-07-19 22:45:03 18509 [ERROR] /ssd/Percona-
2013-07-19 22:45:03 18509 [ERROR] /ssd/Percona-
2013-07-19 22:45:03 18509 [ERROR] /ssd/Percona-
2013-07-19 22:45:03 18509 [ERROR] /ssd/Percona-
mysqld: /bzr/5.
19:45:03 UTC - mysqld got signal 6 ;
[...]
Query (7fde34004c60): INSERT INTO z SELECT * FROM `table100_
tags: | added: upstream |
[roel@qaserver 209184]$ cat cmd293 cmdrun_ 293 cmdrun_ 293 runall. pl --queries=100000000 --seed=21668 --duration=300 --querytimeout=60 --reporter= Shutdown, Backtrace, QueryTimeout, ErrorLog, ErrorLogAlarm --mysqld= --log-output= none --mysqld= --sql_mode= ONLY_FULL_ GROUP_BY --mysqld= --slow_ query_log --mysqld=--userstat --threads=25 --notnull --basedir= /ssd/Percona- Server- 5.6.12- rc60.4- 405-debug. Linux.x86_ 64 --grammar= /tmp/976291/ 89.yy --gendata= /ssd/randgen/ conf/drizzle/ many_indexes_ drizzle. zz --mtr-build- thread= 766 --mask=64840 --vardir1= /ssd/209184/ cmdrun_ 293 > /ssd/209184/ cmdrun293. log 2>&1"
ps -ef | grep 'cmdrun_293' | grep -v grep | awk '{print $2}' | xargs sudo kill -9
rm -Rf /ssd/209184/
mkdir /ssd/209184/
cd /ssd/randgen
bash -c "set -o pipefail; perl /ssd/randgen/