Assertion `thd->is_error() || kill_errno' failed in sql/filesort.cc:443: ha_rows filesort | abort in filesort from mysql_update
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.1 |
Won't Fix
|
Undecided
|
Unassigned | |||
5.5 |
New
|
Undecided
|
Unassigned | |||
5.6 |
Incomplete
|
High
|
Unassigned | |||
5.7 |
Incomplete
|
High
|
Unassigned |
Bug Description
Thread 11 (LWP 20038):
+bt
#0 0x000000340cc0c69c in pthread_kill () from /lib64/
#1 0x00000000006ecc9d 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 0x0000000000875050 in filesort (thd=0x203b1980, table=0x20226670, filesort=<optimized out>, sort_positions=
#8 0x00000000007e4c2f in mysql_update (thd=0x203b1980, table_list=
#9 0x0000000000777c5e in mysql_execute_
#10 0x000000000077bc88 in mysql_parse (thd=0x203b1980, rawbuf=0x203b1988 "\340cA\001", length=<optimized out>, parser_
#11 0x000000000077c81f in dispatch_command (command=<optimized out>, thd=0x203b1980, packet=<optimized out>, packet_
#12 0x000000000077d4f5 in do_command (thd=0x203b1980) at /bzr/5.
#13 0x0000000000746ecf in do_handle_
#14 0x0000000000746f90 in handle_
#15 0x00000000009e4ce9 in pfs_spawn_thread (arg=0x207561e0) at /bzr/5.
#16 0x000000340cc07851 in start_thread () from /lib64/
#17 0x000000340c4e890d in clone () from /lib64/libc.so.6
mysqld: /bzr/5.
04:44:28 UTC - mysqld got signal 6 ;
[...]
Query (206ba1a0): UPDATE `table18_
Connection ID (thread ID): 25
ps -ef | grep 'cmdrun_315' | grep -v grep | awk '{print $2}' | xargs sudo kill -9 cmdrun_ 315 cmdrun_ 315 runall. pl --queries=100000000 --seed=27103 --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- valgrind. Linux.x86_ 64 --valgrind --reporter= ValgrindErrors --validator= MarkErrorLog --grammar= /tmp/976291/ 48.yy --gendata= /ssd/randgen/ conf/percona/ innodb_ dict_size_ limit.zz --mtr-build- thread= 711 --mask=24683 --vardir1= /ssd/209184/ cmdrun_ 315 > /ssd/209184/ cmdrun315. log 2>&1"
rm -Rf /ssd/209184/
mkdir /ssd/209184/
cd /ssd/randgen
bash -c "set -o pipefail; perl /ssd/randgen/