Assertion `thd->is_error() || kill_errno' failed in sql/filesort.cc:443: ha_rows filesort | abort in filesort from mysql_update

Bug #1205216 reported by Roel Van de Paar on 2013-07-26
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server
Status tracked in 5.7
5.1
Undecided
Unassigned
5.5
Undecided
Unassigned
5.6
High
Unassigned
5.7
High
Unassigned

Bug Description

Thread 11 (LWP 20038):
+bt
#0 0x000000340cc0c69c in pthread_kill () from /lib64/libpthread.so.0
#1 0x00000000006ecc9d in handle_fatal_signal (sig=6) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/signal_handler.cc:251
#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=<optimized out>, examined_rows=0x21afa538, found_rows=0x21afa530) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/filesort.cc:443
#8 0x00000000007e4c2f in mysql_update (thd=0x203b1980, table_list=0x206ba568, fields=..., values=..., conds=0x0, order_num=565159056, order=0x195bd2a0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x21afb268, updated_return=0x21afb270) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_update.cc:571
#9 0x0000000000777c5e in mysql_execute_command (thd=0x203b1a68) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3511
#10 0x000000000077bc88 in mysql_parse (thd=0x203b1980, rawbuf=0x203b1988 "\340cA\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#11 0x000000000077c81f in dispatch_command (command=<optimized out>, thd=0x203b1980, packet=<optimized out>, packet_length=543924987) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#12 0x000000000077d4f5 in do_command (thd=0x203b1980) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#13 0x0000000000746ecf in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#14 0x0000000000746f90 in handle_one_connection (arg=<optimized out>) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#15 0x00000000009e4ce9 in pfs_spawn_thread (arg=0x207561e0) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#16 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#17 0x000000340c4e890d in clone () from /lib64/libc.so.6

mysqld: /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/filesort.cc:443: ha_rows filesort(THD*, TABLE*, Filesort*, bool, ha_rows*, ha_rows*): Assertion `thd->is_error() || kill_errno' failed.
04:44:28 UTC - mysqld got signal 6 ;
[...]
Query (206ba1a0): UPDATE `table18_int_autoinc` SET `col_char_10_key` = (`pk` + `pk`), `col_bigint_not_null` = LOAD_FILE('/ssd/randgen/data/earth579kb.jpg') WHERE `col_char_10_key` = 'zcshlewvrzgakduiqujeyhhneuwkoksoker' OR ((`col_int_key` < (`col_char_255_not_null_key` + `pk`)) AND (`col_int_key` >= DATEDIFF(NOW(), '2009-08-11'))) ORDER BY `col_char_255_not_null`
Connection ID (thread ID): 25

Roel Van de Paar (roel11) wrote :
Roel Van de Paar (roel11) wrote :
Roel Van de Paar (roel11) wrote :
Roel Van de Paar (roel11) wrote :
Roel Van de Paar (roel11) wrote :

ps -ef | grep 'cmdrun_315' | grep -v grep | awk '{print $2}' | xargs sudo kill -9
rm -Rf /ssd/209184/cmdrun_315
mkdir /ssd/209184/cmdrun_315
cd /ssd/randgen
bash -c "set -o pipefail; perl /ssd/randgen/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"

Most likely upstream.

tags: added: upstream
Roel Van de Paar (roel11) wrote :

Laurynas, feel free to remove 56qual tag if this bug is "as good as certain" upstream.

tags: added: 56qual
tags: removed: 56qual
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers