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

[Roel Van de Paar]

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)]

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"

[Laurynas Biveinis (laurynas-biveinis)]

Most likely upstream.

[Roel Van de Paar (roel11)]

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

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-703