MySQL [test4]> set autocommit=0;
Query OK, 0 rows affected (0.00 sec)
MySQL [test4]> load data infile '/tmp/t2' into table tbtest1;
Query OK, 10004 rows affected (1.95 sec)
Records: 10004 Deleted: 0 Skipped: 0 Warnings: 0
MySQL [test4]> set autocommit=1;
Query OK, 0 rows affected (0.00 sec)
MySQL [test4]> select count(*) from tbtest1;
===============================================
(gdb) bt
#0 0x00007ffff5f5e389 in raise () from /usr/lib/libc.so.6
#1 0x00007ffff5f5f788 in abort () from /usr/lib/libc.so.6
#2 0x00007ffff5f574a6 in __assert_fail_base () from /usr/lib/libc.so.6
#3 0x00007ffff5f57552 in __assert_fail () from /usr/lib/libc.so.6
#4 0x000000000091bd47 in binlog_cache_data::finalize (this=this@entry=0x7fff5c01c840, thd=thd@entry=0x2e18230, end_event=end_event@entry=0x7fffbc5660b0)
at /media/Tintin/Work/code/percona-xtradb-cluster/pxc56/Percona-Server/sql/binlog.cc:1187
#5 0x000000000092ac0b in MYSQL_BIN_LOG::commit (this=0x153a380 <mysql_bin_log>, thd=0x2e18230, all=<optimized out>) at /media/Tintin/Work/code/percona-xtradb-cluster/pxc56/Percona-Server/sql/binlog.cc:6419
#6 0x000000000064de53 in ha_commit_trans (thd=thd@entry=0x2e18230, all=all@entry=false, ignore_global_read_lock=ignore_global_read_lock@entry=false)
at /media/Tintin/Work/code/percona-xtradb-cluster/pxc56/Percona-Server/sql/handler.cc:1521
#7 0x0000000000807718 in trans_commit_stmt (thd=thd@entry=0x2e18230) at /media/Tintin/Work/code/percona-xtradb-cluster/pxc56/Percona-Server/sql/transaction.cc:473
#8 0x000000000077cfe8 in mysql_execute_command (thd=thd@entry=0x2e18230) at /media/Tintin/Work/code/percona-xtradb-cluster/pxc56/Percona-Server/sql/sql_parse.cc:5785
#9 0x0000000000780f68 in mysql_parse (thd=thd@entry=0x2e18230, rawbuf=rawbuf@entry=0x7fff5c006d50 "select count(*) from tbtest1", length=length@entry=28, parser_state=parser_state@entry=0x7fffbc5687e0)
at /media/Tintin/Work/code/percona-xtradb-cluster/pxc56/Percona-Server/sql/sql_parse.cc:7188
#10 0x000000000078161c in wsrep_mysql_parse (thd=thd@entry=0x2e18230, rawbuf=0x7fff5c006d50 "select count(*) from tbtest1", length=length@entry=28, parser_state=parser_state@entry=0x7fffbc5687e0)
at /media/Tintin/Work/code/percona-xtradb-cluster/pxc56/Percona-Server/sql/sql_parse.cc:6940
#11 0x0000000000783099 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x2e18230, packet=packet@entry=0x2f3e421 "", packet_length=packet_length@entry=28)
at /media/Tintin/Work/code/percona-xtradb-cluster/pxc56/Percona-Server/sql/sql_parse.cc:1630
#12 0x0000000000783833 in do_command (thd=0x2e18230) at /media/Tintin/Work/code/percona-xtradb-cluster/pxc56/Percona-Server/sql/sql_parse.cc:1133
#13 0x000000000074e3e2 in do_handle_one_connection (thd_arg=thd_arg@entry=0x2e18230) at /media/Tintin/Work/code/percona-xtradb-cluster/pxc56/Percona-Server/sql/sql_connect.cc:1557
#14 0x000000000074e520 in handle_one_connection (arg=arg@entry=0x2e18230) at /media/Tintin/Work/code/percona-xtradb-cluster/pxc56/Percona-Server/sql/sql_connect.cc:1461
#15 0x0000000000bf53a3 in pfs_spawn_thread (arg=0x2dae780) at /media/Tintin/Work/code/percona-xtradb-cluster/pxc56/Percona-Server/storage/perfschema/pfs.cc:1858
#16 0x00007ffff7bc70a2 in start_thread () from /usr/lib/libpthread.so.0
#17 0x00007ffff600ed1d in clone () from /usr/lib/libc.so.6
(
Seeing another crash:
======= ======= ======
MySQL [test4]> truncate tbtest1;
Query OK, 0 rows affected (0.03 sec)
MySQL [test4]> set autocommit=0;
Query OK, 0 rows affected (0.00 sec)
MySQL [test4]> load data infile '/tmp/t2' into table tbtest1;
Query OK, 10004 rows affected (1.95 sec)
Records: 10004 Deleted: 0 Skipped: 0 Warnings: 0
MySQL [test4]> set autocommit=1;
Query OK, 0 rows affected (0.00 sec)
MySQL [test4]> select count(*) from tbtest1;
======= ======= ======= ======= ======= ======= ===== cache_data: :finalize (this=this@ entry=0x7fff5c0 1c840, thd=thd@ entry=0x2e18230 , end_event= end_event@ entry=0x7fffbc5 660b0) Tintin/ Work/code/ percona- xtradb- cluster/ pxc56/Percona- Server/ sql/binlog. cc:1187 LOG::commit (this=0x153a380 <mysql_bin_log>, thd=0x2e18230, all=<optimized out>) at /media/ Tintin/ Work/code/ percona- xtradb- cluster/ pxc56/Percona- Server/ sql/binlog. cc:6419 entry=0x2e18230 , all=all@ entry=false, ignore_ global_ read_lock= ignore_ global_ read_lock@ entry=false) Tintin/ Work/code/ percona- xtradb- cluster/ pxc56/Percona- Server/ sql/handler. cc:1521 entry=0x2e18230 ) at /media/ Tintin/ Work/code/ percona- xtradb- cluster/ pxc56/Percona- Server/ sql/transaction .cc:473 command (thd=thd@ entry=0x2e18230 ) at /media/ Tintin/ Work/code/ percona- xtradb- cluster/ pxc56/Percona- Server/ sql/sql_ parse.cc: 5785 entry=0x2e18230 , rawbuf= rawbuf@ entry=0x7fff5c0 06d50 "select count(*) from tbtest1", length= length@ entry=28, parser_ state=parser_ state@entry= 0x7fffbc5687e0) Tintin/ Work/code/ percona- xtradb- cluster/ pxc56/Percona- Server/ sql/sql_ parse.cc: 7188 entry=0x2e18230 , rawbuf= 0x7fff5c006d50 "select count(*) from tbtest1", length= length@ entry=28, parser_ state=parser_ state@entry= 0x7fffbc5687e0) Tintin/ Work/code/ percona- xtradb- cluster/ pxc56/Percona- Server/ sql/sql_ parse.cc: 6940 command@ entry=COM_ QUERY, thd=thd@ entry=0x2e18230 , packet= packet@ entry=0x2f3e421 "", packet_ length= packet_ length@ entry=28) Tintin/ Work/code/ percona- xtradb- cluster/ pxc56/Percona- Server/ sql/sql_ parse.cc: 1630 Tintin/ Work/code/ percona- xtradb- cluster/ pxc56/Percona- Server/ sql/sql_ parse.cc: 1133 one_connection (thd_arg= thd_arg@ entry=0x2e18230 ) at /media/ Tintin/ Work/code/ percona- xtradb- cluster/ pxc56/Percona- Server/ sql/sql_ connect. cc:1557 one_connection (arg=arg@ entry=0x2e18230 ) at /media/ Tintin/ Work/code/ percona- xtradb- cluster/ pxc56/Percona- Server/ sql/sql_ connect. cc:1461 Tintin/ Work/code/ percona- xtradb- cluster/ pxc56/Percona- Server/ storage/ perfschema/ pfs.cc: 1858 libpthread. so.0
(gdb) bt
#0 0x00007ffff5f5e389 in raise () from /usr/lib/libc.so.6
#1 0x00007ffff5f5f788 in abort () from /usr/lib/libc.so.6
#2 0x00007ffff5f574a6 in __assert_fail_base () from /usr/lib/libc.so.6
#3 0x00007ffff5f57552 in __assert_fail () from /usr/lib/libc.so.6
#4 0x000000000091bd47 in binlog_
at /media/
#5 0x000000000092ac0b in MYSQL_BIN_
#6 0x000000000064de53 in ha_commit_trans (thd=thd@
at /media/
#7 0x0000000000807718 in trans_commit_stmt (thd=thd@
#8 0x000000000077cfe8 in mysql_execute_
#9 0x0000000000780f68 in mysql_parse (thd=thd@
at /media/
#10 0x000000000078161c in wsrep_mysql_parse (thd=thd@
at /media/
#11 0x0000000000783099 in dispatch_command (command=
at /media/
#12 0x0000000000783833 in do_command (thd=0x2e18230) at /media/
#13 0x000000000074e3e2 in do_handle_
#14 0x000000000074e520 in handle_
#15 0x0000000000bf53a3 in pfs_spawn_thread (arg=0x2dae780) at /media/
#16 0x00007ffff7bc70a2 in start_thread () from /usr/lib/
#17 0x00007ffff600ed1d in clone () from /usr/lib/libc.so.6
(