sql/sql_error.cc:436: void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `! is_set()' failed | abort in Diagnostics_area::set_ok_status

[Roel Van de Paar]

Thread 1 (LWP 5985):
+bt
#0 0x000000340cc0c69c in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000686bde in handle_fatal_signal (sig=6) at /bzr/5.6_dbg/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 0x00000000006f40dd in Diagnostics_area::set_ok_status (this=0x2486410, affected_rows=0, last_insert_id=0, message=0x7fed4ab74e70 "Rows matched: 0 Changed: 0 Warnings: 2") at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_error.cc:436
#8 0x000000000079dc1c in my_ok (message=0x7fed4ab74e70 "Rows matched: 0 Changed: 0 Warnings: 2", id=0, affected_rows=0, thd=0x2482db0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_class.h:4266
#9 mysql_update (thd=0x2482db0, table_list=<optimized out>, fields=..., values=..., conds=0x0, order_num=0, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7fed4ab76038, updated_return=0x7fed4ab76040) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_update.cc:1015
#10 0x00000000007212cb in mysql_execute_command (thd=0x2482db0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3511
#11 0x0000000000727818 in mysql_parse (thd=0x2482db0, rawbuf=0x2485178 "\360R7\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#12 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x2482db0, packet=0x2486d41 "UPDATE `B` SET `col_int_default_null` = (`col_char_255` + `col_enum_not_null_key`), `col_enum_default_null` = '2008-01-20 13:34:08.031770' WHERE `col_char_255_key_default_null` > (SELECT `col_char_255_not_null_key` FROM `DD` WHERE `col_char_255` <> \"I'll\" AND (`col_bigint` = '2009-08-16 17:58:41.011208') LIMIT 0,1) OR `col_char_255_key` <= 'jtcjlxoasnegzzhmhcwkvfpxwiunqxnyzuvuwofnsccmhsgugzkmuosdgghguqtiqdnujcxddgtxaxuybzodbhsjxszqnzmjcdpgctcpyhjeyypdpzsalhhtjmefeiuwbrdggokshueilvdhuvgumrrcqeojyjyhgqdjaltvqnwqbnuskfwswupjjegyzhvnjyyqmqaiwwiirtfatjykxgpjagcua' OR ((`col_char_10_not_null` >= 'tcjlxoasnegzzhmhcwkvfpxwiunqxnyzuvuwofnsccmhsgugzkmuosdgghguqtiqdnujcxddgtxaxuybzodbhsjxszqnzmjcdpgctcpyhjeyypdpzsalhhtjmefeiuw') AND (`col_bigint_not_null` IS NOT NULL))", packet_length=768) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#13 0x0000000000729a47 in do_command (thd=0x2482db0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#14 0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#15 0x00000000006ed727 in handle_one_connection (arg=0x2482db0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#16 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x23a3730) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#18 0x000000340c4e890d in clone () from /lib64/libc.so.6

2013-07-14 14:50:27 5892 [ERROR] /ssd/Percona-Server-5.6.12-rc60.4-405-debug.Linux.x86_64/bin/mysqld: Lock wait timeout exceeded; try restarting transaction
2013-07-14 14:50:27 5892 [ERROR] /ssd/Percona-Server-5.6.12-rc60.4-405-debug.Linux.x86_64/bin/mysqld: Sort aborted: Lock wait timeout exceeded; try restarting transaction
2013-07-14 14:50:42 5892 [ERROR] /ssd/Percona-Server-5.6.12-rc60.4-405-debug.Linux.x86_64/bin/mysqld: Sort aborted: Query execution was interrupted
mysqld: /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_error.cc:436: void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `! is_set()' failed.
11:50:42 UTC - mysqld got signal 6 ;
[...]
Query (7fed04004c50): UPDATE `B` SET `col_int_default_null` = (`col_char_255` + `col_enum_not_null_key`), `col_enum_default_null` = '2008-01-20 13:34:08.031770' WHERE `col_char_255_key_default_null` > (SELECT `col_char_255_not_null_key` FROM `DD` WHERE `col_char_255` <> "I'll" AND (`col_bigint` = '2009-08-16 17:58:41.011208') LIMIT 0,1) OR `col_char_255_key` <= 'jtcjlxoasnegzzhmhcwkvfpxwiunqxnyzuvuwofnsccmhsgugzkmuosdgghguqtiqdnujcxddgtxaxuybzodbhsjxszqnzmjcdpgctcpyhjeyypdpzsalhhtjmefeiuwbrdggokshueilvdhuvgumrrcqeojyjyhgqdjaltvqnwqbnuskfwswupjjegyzhvnjyyqmqaiwwiirtfatjykxgpjagcua' OR ((`col_char_10_not_null` >= 'tcjlxoasnegzzhmhcwkvfpxwiunqxnyzuvuwofnsccmhsgugzkmuosdgghguqtiqdnujcxddgtxaxuybzodbhsjxszqnzmjcdpgctcpyhjeyypdpzsalhhtjmefeiuw') AND (`col_bigint_not_null` IS NOT NULL))
Connection ID (thread ID): 19
Status: NOT_KILLED

[Roel Van de Paar (roel11)]

No yy file available

[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.

[Roel Van de Paar (roel11)]

https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1234421

[Roel Van de Paar (roel11)]

Upstream http://bugs.mysql.com/bug.php?id=74597

[Laurynas Biveinis (laurynas-biveinis)]

What is the testcase?

[Shahriyar Rzayev (rzayev-sehriyar)]

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