InnoDB: Assertion failure in thread 139660623910656 in file trx0roll.cc line 264 | abort (sig=6) in trx_rollback_last_sql_stat_for_mysql
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
|||
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
High
|
Unassigned | ||
5.1 |
Won't Fix
|
Undecided
|
Unassigned | ||
5.5 |
Invalid
|
Undecided
|
Unassigned | ||
5.6 |
Fix Released
|
High
|
Unassigned |
Bug Description
Version: '5.6.21-69.0-debug' socket: '/dev/shm/
2014-10-20 09:05:52 25097 [Note] Event Scheduler: scheduler thread started with id 7
2014-10-20 09:05:52 25097 [Note] Event Scheduler: Killing the scheduler thread, thread id 7
2014-10-20 09:05:52 25097 [Note] Event Scheduler: Waiting for the scheduler thread to reply
2014-10-20 09:05:52 25097 [Note] Event Scheduler: Stopped
2014-10-20 09:05:52 25097 [Warning] Monitor ibuf_merges is already enabled.
2014-10-20 09:05:52 7f0545e09700 InnoDB: Assertion failure in thread 139660623910656 in file trx0roll.cc line 264
[...]
Query (7f04f4004e90): select f1(-1, 0)
Connection ID (thread ID): 4
Single threaded run, single mysqld involved
Thread 1 (Thread 0x7f0545e09700 (LWP 25367)):
+bt
#0 0x00007f055f1f2771 in pthread_kill () from /lib64/
#1 0x0000000000ab7586 in my_write_core (sig=6) at /mnt/workspace/
#2 0x000000000072f9ff in handle_fatal_signal (sig=6) at /mnt/workspace/
#3 <signal handler called>
#4 0x00007f055ddf65c9 in raise () from /lib64/libc.so.6
#5 0x00007f055ddf7cd8 in abort () from /lib64/libc.so.6
#6 0x0000000000c5379d in trx_rollback_
#7 0x0000000000ad172f in innobase_rollback (hton=0x2d7fde0, thd=0x2d5dca0, rollback_trx=false) at /mnt/workspace/
#8 0x000000000063f529 in ha_rollback_low (thd=0x2d5dca0, all=false) at /mnt/workspace/
#9 0x0000000000719a67 in TC_LOG_
#10 0x000000000063f759 in ha_rollback_trans (thd=0x2d5dca0, all=false) at /mnt/workspace/
#11 0x00000000008b78a2 in trans_rollback_stmt (thd=0x2d5dca0) at /mnt/workspace/
#12 0x00000000007ea161 in mysql_execute_
#13 0x00000000007ed193 in mysql_parse (thd=0x2d5dca0, rawbuf=
#14 0x00000000007df5fc in dispatch_command (command=COM_QUERY, thd=0x2d5dca0, packet=0x3557b61 "", packet_length=17) at /mnt/workspace/
#15 0x00000000007de528 in do_command (thd=0x2d5dca0) at /mnt/workspace/
#16 0x00000000008c2c30 in threadpool_
#17 0x00000000008c5572 in handle_event (connection=
#18 0x00000000008c57a2 in worker_main (param=0x1898400 <all_groups+2048>) at /mnt/workspace/
#19 0x0000000000dc5bac in pfs_spawn_thread (arg=0x7f04f400
#20 0x00007f055f1eddf3 in start_thread () from /lib64/
#21 0x00007f055deb701d in clone () from /lib64/libc.so.6
********* testcase
DROP DATABASE test;CREATE DATABASE test;USE test; 0x2030405060, 0xb; ,0x2030405060, 11;
CREATE TABLE t1(c1 DATE,c2 BINARY (1),c3 INT(1),c4 VARBINARY(1) KEY,c5 DATE UNIQUE KEY,c6 NUMERIC(0,0) DEFAULT 3.141592);
create function f2()returns int return (select data FROM t1 LIMIT 1);
xa start 0x7465737462,
EXPLAIN SELECT * FROM t1 WHERE c1=f2(rand());
xa end 'testb',' 0@P`',11;
xa prepare 'testb'
SELECT f2();