jan@jan-GE70-0NC-0ND ~/mysql/mariadb-patches $ sh -x runit22.sh
|
+ perl ./runall-new.pl --grammar=conf/engines/engine_stress.yy --gendata=conf/engines/engine_stress.zz --duration=2000 --queries=100M --threads=16 --galera=mmm --basedir=/home/jan/mysql/10.0-galera --vardir=/home/jan/mysql/galera-test --mysqld=--wsrep-provider=/usr/lib/libgalera_smm.so --mysqld=--wsrep_sst_method=rsync --mysqld=--wsrep-on=1 --mysqld=--wsrep_causal_reads=ON
|
# 2014-10-03T11:23:21 [19165] Copyright (c) 2010,2011 Oracle and/or its affiliates. All rights reserved. Use is subject to license terms.
|
# 2014-10-03T11:23:21 [19165] Please see http://forge.mysql.com/wiki/Category:RandomQueryGenerator for more information on this test framework.
|
# 2014-10-03T11:23:21 [19165] Starting
|
# 2014-10-03T11:23:21 [19165] # ./runall-new.pl \
|
# 2014-10-03T11:23:21 [19165] # --grammar=conf/engines/engine_stress.yy \
|
# 2014-10-03T11:23:21 [19165] # --gendata=conf/engines/engine_stress.zz \
|
# 2014-10-03T11:23:21 [19165] # --duration=2000 \
|
# 2014-10-03T11:23:21 [19165] # --queries=100M \
|
# 2014-10-03T11:23:21 [19165] # --threads=16 \
|
# 2014-10-03T11:23:21 [19165] # --galera=mmm \
|
# 2014-10-03T11:23:21 [19165] # --basedir=/home/jan/mysql/10.0-galera \
|
# 2014-10-03T11:23:21 [19165] # --vardir=/home/jan/mysql/galera-test \
|
# 2014-10-03T11:23:21 [19165] # --mysqld=--wsrep-provider=/usr/lib/libgalera_smm.so \
|
# 2014-10-03T11:23:21 [19165] # --mysqld=--wsrep_sst_method=rsync \
|
# 2014-10-03T11:23:21 [19165] # --mysqld=--wsrep-on=1 \
|
# 2014-10-03T11:23:21 [19165] # --mysqld=--wsrep_causal_reads=ON
|
# 2014-10-03T11:23:21 [19165] master_port : 19300 slave_port : 19302 ports : 19300 19302 MTR_BUILD_THREAD : 930
|
# 2014-10-03T11:23:21 [19165] /home/jan/mysql/mariadb-patches Revno: 994
|
# 2014-10-03T11:23:21 [19165] /home/jan/mysql/mariadb-patches Revision-Id: elenst@montyprogram.com-20140927205339-ovi1rxegcvl9t8ed
|
# 2014-10-03T11:25:23 [19165] /home/jan/mysql/10.0-galera Revno: 3895
|
# 2014-10-03T11:25:23 [19165] /home/jan/mysql/10.0-galera Revision-Id: nirbhay@skysql.com-20140924161729-8ayjtmqjf0dplquf
|
# 2014-10-03T11:25:23 [19165] Final command line:
|
# 2014-10-03T11:25:23 [19165] perl ./runall-new.pl --grammar=conf/engines/engine_stress.yy --gendata=conf/engines/engine_stress.zz --duration=2000 --queries=100M --threads=16 --galera=mmm --basedir=/home/jan/mysql/10.0-galera --vardir=/home/jan/mysql/galera-test --mysqld=--wsrep-provider=/usr/lib/libgalera_smm.so --mysqld=--wsrep_sst_method=rsync --mysqld=--wsrep-on=1 --mysqld=--wsrep_causal_reads=ON
|
# 2014-10-03T11:25:24 [19165] Found source directory at /home/jan/mysql/10.0-galera
|
# 2014-10-03T11:25:24 [19165] Creating MySQL 10.0.13 database at /home/jan/mysql/galera-test/node0/data
|
# 2014-10-03T11:25:24 [19165] Running bootstrap: "/home/jan/mysql/10.0-galera/sql/mysqld" "--no-defaults" "--bootstrap" "--basedir=/home/jan/mysql/10.0-galera" "--datadir=/home/jan/mysql/galera-test/node0/data" "--lc-messages-dir=/home/jan/mysql/10.0-galera/sql/share" "--character-sets-dir=/home/jan/mysql/10.0-galera/sql/share/charsets" "--tmpdir=/home/jan/mysql/galera-test/node0/tmp" "--wsrep_sst_method=rsync" "--innodb_autoinc_lock_mode=2" "--default-storage-engine=InnoDB" "--innodb_locks_unsafe_for_binlog=1" "--binlog-format=row" "--wsrep_cluster_address=gcomm://?gmcast.listen_addr=tcp://127.0.0.1:4800" "--wsrep-provider=/usr/lib/libgalera_smm.so" "--wsrep_sst_method=rsync" "--wsrep-on=1" "--wsrep_causal_reads=ON" "--sql-mode=no_engine_substitution" "--skip-log-bin" (and feeding /home/jan/mysql/galera-test/node0/boot.sql to it)
|
# 2014-10-03T11:25:45 [19165] Found source directory at /home/jan/mysql/10.0-galera
|
# 2014-10-03T11:25:45 [19165] Creating MySQL 10.0.13 database at /home/jan/mysql/galera-test/node1/data
|
# 2014-10-03T11:25:45 [19165] Running bootstrap: "/home/jan/mysql/10.0-galera/sql/mysqld" "--no-defaults" "--bootstrap" "--basedir=/home/jan/mysql/10.0-galera" "--datadir=/home/jan/mysql/galera-test/node1/data" "--lc-messages-dir=/home/jan/mysql/10.0-galera/sql/share" "--character-sets-dir=/home/jan/mysql/10.0-galera/sql/share/charsets" "--tmpdir=/home/jan/mysql/galera-test/node1/tmp" "--wsrep_sst_method=rsync" "--innodb_autoinc_lock_mode=2" "--default-storage-engine=InnoDB" "--innodb_locks_unsafe_for_binlog=1" "--binlog-format=row" "--wsrep_cluster_address=gcomm://127.0.0.1:4800?gmcast.listen_addr=tcp://127.0.0.1:4801" "--wsrep-provider=/usr/lib/libgalera_smm.so" "--wsrep_sst_method=rsync" "--wsrep-on=1" "--wsrep_causal_reads=ON" "--sql-mode=no_engine_substitution" "--skip-log-bin" (and feeding /home/jan/mysql/galera-test/node1/boot.sql to it)
|
# 2014-10-03T11:26:02 [19165] Found source directory at /home/jan/mysql/10.0-galera
|
# 2014-10-03T11:26:02 [19165] Creating MySQL 10.0.13 database at /home/jan/mysql/galera-test/node2/data
|
# 2014-10-03T11:26:02 [19165] Running bootstrap: "/home/jan/mysql/10.0-galera/sql/mysqld" "--no-defaults" "--bootstrap" "--basedir=/home/jan/mysql/10.0-galera" "--datadir=/home/jan/mysql/galera-test/node2/data" "--lc-messages-dir=/home/jan/mysql/10.0-galera/sql/share" "--character-sets-dir=/home/jan/mysql/10.0-galera/sql/share/charsets" "--tmpdir=/home/jan/mysql/galera-test/node2/tmp" "--wsrep_sst_method=rsync" "--innodb_autoinc_lock_mode=2" "--default-storage-engine=InnoDB" "--innodb_locks_unsafe_for_binlog=1" "--binlog-format=row" "--wsrep_cluster_address=gcomm://127.0.0.1:4800?gmcast.listen_addr=tcp://127.0.0.1:4802" "--wsrep-provider=/usr/lib/libgalera_smm.so" "--wsrep_sst_method=rsync" "--wsrep-on=1" "--wsrep_causal_reads=ON" "--sql-mode=no_engine_substitution" "--skip-log-bin" (and feeding /home/jan/mysql/galera-test/node2/boot.sql to it)
|
# 2014-10-03T11:26:20 [19165] MySQL Version:10.0.13
|
# 2014-10-03T11:26:20 [19165] Binary: /home/jan/mysql/10.0-galera/sql/mysqld
|
# 2014-10-03T11:26:20 [19165] Type: Debug
|
# 2014-10-03T11:26:20 [19165] Datadir: /home/jan/mysql/galera-test/node0/data
|
# 2014-10-03T11:26:20 [19165] Tmpdir: /home/jan/mysql/galera-test/node0/tmp
|
# 2014-10-03T11:26:20 [19165] Corefile: /home/jan/mysql/galera-test/node0/data/core.
|
# 2014-10-03T11:26:20 [19165] Starting MySQL 10.0.13: "/home/jan/mysql/10.0-galera/sql/mysqld" "--no-defaults" "--basedir=/home/jan/mysql/10.0-galera" "--datadir=/home/jan/mysql/galera-test/node0/data" "--lc-messages-dir=/home/jan/mysql/10.0-galera/sql/share" "--character-sets-dir=/home/jan/mysql/10.0-galera/sql/share/charsets" "--tmpdir=/home/jan/mysql/galera-test/node0/tmp" "--core-file" "--max-allowed-packet=128Mb" "--port=19300" "--socket=/home/jan/mysql/galera-test/node0/mysql.sock" "--pid-file=/home/jan/mysql/galera-test/node0/mysql.pid" "--general-log" "--general-log-file=/home/jan/mysql/galera-test/node0/mysql.log" --wsrep_sst_method=rsync --innodb_autoinc_lock_mode=2 --default-storage-engine=InnoDB --innodb_locks_unsafe_for_binlog=1 --binlog-format=row --wsrep_cluster_address=gcomm://?gmcast.listen_addr=tcp://127.0.0.1:4800 --wsrep-provider=/usr/lib/libgalera_smm.so --wsrep_sst_method=rsync --wsrep-on=1 --wsrep_causal_reads=ON --sql-mode=no_engine_substitution
|
# 2014-10-03T11:26:23 [19165] Connecting to 19300
|
# 2014-10-03T11:26:24 [19165] Cluster size after starting node 0: 1
|
# 2014-10-03T11:26:24 [19165] MySQL Version:10.0.13
|
# 2014-10-03T11:26:24 [19165] Binary: /home/jan/mysql/10.0-galera/sql/mysqld
|
# 2014-10-03T11:26:24 [19165] Type: Debug
|
# 2014-10-03T11:26:24 [19165] Datadir: /home/jan/mysql/galera-test/node1/data
|
# 2014-10-03T11:26:24 [19165] Tmpdir: /home/jan/mysql/galera-test/node1/tmp
|
# 2014-10-03T11:26:24 [19165] Corefile: /home/jan/mysql/galera-test/node1/data/core.
|
# 2014-10-03T11:26:24 [19165] Starting MySQL 10.0.13: "/home/jan/mysql/10.0-galera/sql/mysqld" "--no-defaults" "--basedir=/home/jan/mysql/10.0-galera" "--datadir=/home/jan/mysql/galera-test/node1/data" "--lc-messages-dir=/home/jan/mysql/10.0-galera/sql/share" "--character-sets-dir=/home/jan/mysql/10.0-galera/sql/share/charsets" "--tmpdir=/home/jan/mysql/galera-test/node1/tmp" "--core-file" "--max-allowed-packet=128Mb" "--port=19301" "--socket=/home/jan/mysql/galera-test/node1/mysql.sock" "--pid-file=/home/jan/mysql/galera-test/node1/mysql.pid" "--general-log" "--general-log-file=/home/jan/mysql/galera-test/node1/mysql.log" --wsrep_sst_method=rsync --innodb_autoinc_lock_mode=2 --default-storage-engine=InnoDB --innodb_locks_unsafe_for_binlog=1 --binlog-format=row --wsrep_cluster_address=gcomm://127.0.0.1:4800?gmcast.listen_addr=tcp://127.0.0.1:4801 --wsrep-provider=/usr/lib/libgalera_smm.so --wsrep_sst_method=rsync --wsrep-on=1 --wsrep_causal_reads=ON --sql-mode=no_engine_substitution
|
# 2014-10-03T11:26:40 [19165] Connecting to 19301
|
# 2014-10-03T11:26:40 [19165] Cluster size after starting node 1: 2
|
# 2014-10-03T11:26:40 [19165] MySQL Version:10.0.13
|
# 2014-10-03T11:26:40 [19165] Binary: /home/jan/mysql/10.0-galera/sql/mysqld
|
# 2014-10-03T11:26:40 [19165] Type: Debug
|
# 2014-10-03T11:26:40 [19165] Datadir: /home/jan/mysql/galera-test/node2/data
|
# 2014-10-03T11:26:40 [19165] Tmpdir: /home/jan/mysql/galera-test/node2/tmp
|
# 2014-10-03T11:26:40 [19165] Corefile: /home/jan/mysql/galera-test/node2/data/core.
|
# 2014-10-03T11:26:40 [19165] Starting MySQL 10.0.13: "/home/jan/mysql/10.0-galera/sql/mysqld" "--no-defaults" "--basedir=/home/jan/mysql/10.0-galera" "--datadir=/home/jan/mysql/galera-test/node2/data" "--lc-messages-dir=/home/jan/mysql/10.0-galera/sql/share" "--character-sets-dir=/home/jan/mysql/10.0-galera/sql/share/charsets" "--tmpdir=/home/jan/mysql/galera-test/node2/tmp" "--core-file" "--max-allowed-packet=128Mb" "--port=19302" "--socket=/home/jan/mysql/galera-test/node2/mysql.sock" "--pid-file=/home/jan/mysql/galera-test/node2/mysql.pid" "--general-log" "--general-log-file=/home/jan/mysql/galera-test/node2/mysql.log" --wsrep_sst_method=rsync --innodb_autoinc_lock_mode=2 --default-storage-engine=InnoDB --innodb_locks_unsafe_for_binlog=1 --binlog-format=row --wsrep_cluster_address=gcomm://127.0.0.1:4800?gmcast.listen_addr=tcp://127.0.0.1:4802 --wsrep-provider=/usr/lib/libgalera_smm.so --wsrep_sst_method=rsync --wsrep-on=1 --wsrep_causal_reads=ON --sql-mode=no_engine_substitution
|
# 2014-10-03T11:26:56 [19165] Connecting to 19302
|
# 2014-10-03T11:26:56 [19165] Cluster size after starting node 2: 3
|
# 2014-10-03T11:26:56 [19165] -------------------------------
|
# 2014-10-03T11:26:56 [19165] Configuration
|
# 2014-10-03T11:26:56 [19165] debug_server => ['', '']
|
# 2014-10-03T11:26:56 [19165] dsn => ['dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test', 'dbi:mysql:host=127.0.0.1:port=19301:user=root:database=test', 'dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test']
|
# 2014-10-03T11:26:56 [19165] duration => 2000
|
# 2014-10-03T11:26:56 [19165] gendata => conf/engines/engine_stress.zz
|
# 2014-10-03T11:26:56 [19165] generator => FromGrammar
|
# 2014-10-03T11:26:56 [19165] grammar => conf/engines/engine_stress.yy
|
# 2014-10-03T11:26:56 [19165] multi-master => 1
|
# 2014-10-03T11:26:56 [19165] queries => 100000000
|
# 2014-10-03T11:26:56 [19165] servers => ['DBServer::MySQL::MySQLd=ARRAY(0x2f8f220)', 'DBServer::MySQL::MySQLd=ARRAY(0x2e58498)', 'DBServer::MySQL::MySQLd=ARRAY(0x2f93340)']
|
# 2014-10-03T11:26:56 [19165] threads => 16
|
# 2014-10-03T11:26:56 [19165] views => ['', '']
|
# 2014-10-03T11:26:56 [19165] Sleeping:::JAN
|
# 2014-10-03T11:27:41 [19165] Sleeping___done:::JAN
|
# 2014-10-03T11:27:41 [19165] # Creating MySQL table: test.table0_int_autoinc; engine: ; rows: 0 .
|
# 2014-10-03T11:27:45 [19165] # Creating MySQL table: test.table0_key_pk_parts_2_int_autoinc; engine: ; rows: 0 .
|
# 2014-10-03T11:27:51 [19165] # Creating MySQL table: test.table1_int_autoinc; engine: ; rows: 1 .
|
# 2014-10-03T11:27:57 [19165] # Creating MySQL table: test.table1_key_pk_parts_2_int_autoinc; engine: ; rows: 1 .
|
# 2014-10-03T11:28:11 [19165] # Creating MySQL table: test.table2_int_autoinc; engine: ; rows: 2 .
|
# 2014-10-03T11:28:18 [19165] # Creating MySQL table: test.table2_key_pk_parts_2_int_autoinc; engine: ; rows: 2 .
|
# 2014-10-03T11:28:27 [19165] # Creating MySQL table: test.table10_int_autoinc; engine: ; rows: 10 .
|
# 2014-10-03T11:28:34 [19165] # Creating MySQL table: test.table10_key_pk_parts_2_int_autoinc; engine: ; rows: 10 .
|
# 2014-10-03T11:28:42 [19165] # Creating MySQL table: test.table100_int_autoinc; engine: ; rows: 100 .
|
# 2014-10-03T11:28:48 [19165] # Creating MySQL table: test.table100_key_pk_parts_2_int_autoinc; engine: ; rows: 100 .
|
# 2014-10-03T11:29:01 [19165] Reporters: ErrorLog, Backtrace
|
# 2014-10-03T11:29:10 [19165] Validators: (none)
|
# 2014-10-03T11:29:10 [19165] Caching schema metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test
|
# 2014-10-03T11:29:11 [19165] Caching schema metadata for dbi:mysql:host=127.0.0.1:port=19301:user=root:database=test
|
# 2014-10-03T11:29:11 [19165] Caching schema metadata for dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test
|
# 2014-10-03T11:29:11 [19165] Starting 16 processes, 100000000 queries each, duration 2000 seconds.
|
# 2014-10-03T11:29:11 [19165] GenTest::ErrorFilter(20082) started
|
# 2014-10-03T11:29:13 [20083] Started periodic reporting process...
|
# 2014-10-03T11:29:13 [20082] Query: INSERT LOW_PRIORITY IGNORE INTO `table10_key_pk_parts_2_int_autoinc` ( `col_int` , `col_int` ) VALUES ( 'y' , 1639514112 ) , ( 6 , 1388707840 ) failed: 1110 Column '%s' specified twice. Further errors of this kind will be suppressed.
|
# 2014-10-03T11:29:21 [20082] Query: UPDATE LOW_PRIORITY IGNORE `table10_key_pk_parts_2_int_autoinc` AS X SET `col_char_12` = 'd' ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 8 failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed.
|
# 2014-10-03T11:29:34 [20082] Query: DELETE LOW_PRIORITY IGNORE FROM `table0_int_autoinc` WHERE `col_int_key` IN ( SELECT `col_char_12_key` FROM `table0_int_autoinc` WHERE `pk` = 4154130432 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 failed: 1093 Table 'table%d_int_autoinc' is specified twice, both as a target for 'DELETE' and as a separate source for data. Further errors of this kind will be suppressed.
|
# 2014-10-03T11:30:07 [20082] Query: ROLLBACK TO SAVEPOINT A failed: 1305 SAVEPOINT %s does not exist. Further errors of this kind will be suppressed.
|
# 2014-10-03T11:31:16 [20082] Query: DELETE LOW_PRIORITY IGNORE FROM `table0_key_pk_parts_2_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `col_char_12_key` FROM `table0_key_pk_parts_2_int_autoinc` WHERE `pk` = 1 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 failed: 1093 Table 'table%d_key_pk_parts_%d_int_autoinc' is specified twice, both as a target for 'DELETE' and as a separate source for data. Further errors of this kind will be suppressed.
|
# 2014-10-03T11:32:53 [20082] Query: UPDATE LOW_PRIORITY IGNORE `table0_key_pk_parts_2_int_autoinc` AS X SET `col_int` = 2 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 5 failed: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed.
|
# 2014-10-03T11:39:16 [20082] Query: UPDATE LOW_PRIORITY `table100_int_autoinc` AS X SET `col_char_12_key` = 84 WHERE X . `col_int_key` = ( SELECT `col_int_key` FROM `table100_int_autoinc` WHERE `pk` = 151 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 7 failed: 1093 Table 'X' is specified twice, both as a target for 'UPDATE' and as a separate source for data. Further errors of this kind will be suppressed.
|
# 2014-10-03T11:40:18 [20104] Query: SELECT X . `pk` FROM `table1_key_pk_parts_2_int_autoinc` AS X WHERE X . `col_int_key` IN ( 'b' , 't' , 5 , 929366016 , 0 ) LIMIT 5 LOCK IN SHARE MODE failed: 2013 Lost connection to MySQL server during query
|
# 2014-10-03T11:40:18 [20088] Query: SELECT * FROM `table1_key_pk_parts_2_int_autoinc` AS X WHERE X . `col_int_key` BETWEEN 2 AND 5 LIMIT 6 FOR UPDATE failed: 2013 Lost connection to MySQL server during query
|
# 2014-10-03T11:40:18 [20102] Query: SET AUTOCOMMIT=ON failed: 2013 Lost connection to MySQL server during query
|
# 2014-10-03T11:40:18 [20088] Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=19301:user=root:database=test
|
# 2014-10-03T11:40:18 [20104] Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=19301:user=root:database=test
|
# 2014-10-03T11:40:18 [20090] Query: SELECT X . `col_char_12` FROM `table0_int_autoinc` AS X WHERE X . `col_char_12_key` < 2074017792 LIMIT 7 failed: 2013 Lost connection to MySQL server during query
|
# 2014-10-03T11:40:18 [20100] Query: UPDATE LOW_PRIORITY `table100_int_autoinc` AS X SET `col_char_12` = 7 WHERE X . `col_char_12_key` = ( SELECT `col_int_key` FROM `table0_int_autoinc` WHERE `pk` = 46 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 6 failed: 2013 Lost connection to MySQL server during query
|
# 2014-10-03T11:40:18 [20117] Query: UPDATE LOW_PRIORITY IGNORE `table10_int_autoinc` AS X SET `col_char_12_key` = 4 WHERE X . `col_char_12_key` < 'w' ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 6 failed: 2013 Lost connection to MySQL server during query
|
# 2014-10-03T11:40:18 [20090] Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=19301:user=root:database=test
|
# 2014-10-03T11:40:18 [20100] Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=19301:user=root:database=test
|
# 2014-10-03T11:40:18 [20117] Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=19301:user=root:database=test
|
# 2014-10-03T11:40:18 [20084] Query: SELECT X . `col_char_12_key` FROM `table2_key_pk_parts_2_int_autoinc` AS X WHERE X . `col_char_12_key` BETWEEN 78 AND 3518955520 LIMIT 7 FOR UPDATE failed: 2013 Lost connection to MySQL server during query
|
# 2014-10-03T11:40:18 [20084] Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=19301:user=root:database=test
|
# 2014-10-03T11:40:18 [20106] Query: UPDATE LOW_PRIORITY IGNORE `table2_int_autoinc` AS X SET `col_char_12` = 'a' WHERE X . `col_char_12_key` IN ( 'u' , 0 , 3881566208 , 0 , 220 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 5 failed: 2013 Lost connection to MySQL server during query
|
# 2014-10-03T11:40:18 [20106] Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=19301:user=root:database=test
|
# 2014-10-03T11:40:18 [20102] Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=19301:user=root:database=test
|
# 2014-10-03T11:40:18 [20108] Query: UPDATE LOW_PRIORITY `table100_int_autoinc` AS X SET `col_int` = 104 WHERE X . `col_char_12_key` = ( SELECT `col_int_key` FROM `table10_key_pk_parts_2_int_autoinc` WHERE `pk` = 0 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 6 failed: 2013 Lost connection to MySQL server during query
|
# 2014-10-03T11:40:18 [20108] Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=19301:user=root:database=test
|
# 2014-10-03T11:40:18 [20123] Query: DELETE LOW_PRIORITY QUICK FROM `table2_key_pk_parts_2_int_autoinc` WHERE `col_char_12_key` IN ( 332464128 , 3 , 25 , 'v' , 6 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 failed: 2013 Lost connection to MySQL server during query
|
# 2014-10-03T11:40:18 [20121] Query: START TRANSACTION failed: 2013 Lost connection to MySQL server during query
|
# 2014-10-03T11:40:18 [20110] Query: DELETE LOW_PRIORITY QUICK FROM `table1_key_pk_parts_2_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 failed: 2013 Lost connection to MySQL server during query
|
# 2014-10-03T11:40:18 [19165] Process with pid 20088 ended with status STATUS_SERVER_CRASHED
|
# 2014-10-03T11:40:18 [19165] Killing remaining worker process with pid 20123...
|
# 2014-10-03T11:40:18 [20121] Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=19301:user=root:database=test
|
# 2014-10-03T11:40:18 [20110] Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=19301:user=root:database=test
|
# 2014-10-03T11:40:18 [19165] Killing remaining worker process with pid 20125...
|
# 2014-10-03T11:40:18 [19165] Killing remaining worker process with pid 20108...
|
# 2014-10-03T11:40:18 [19165] Killing remaining worker process with pid 20092...
|
# 2014-10-03T11:40:18 [19165] Killing remaining worker process with pid 20110...
|
# 2014-10-03T11:40:18 [19165] Killing remaining worker process with pid 20084...
|
# 2014-10-03T11:40:18 [19165] Killing remaining worker process with pid 20102...
|
# 2014-10-03T11:40:18 [19165] Killing remaining worker process with pid 20094...
|
# 2014-10-03T11:40:18 [19165] Killing remaining worker process with pid 20090...
|
# 2014-10-03T11:40:18 [19165] Killing remaining worker process with pid 20119...
|
# 2014-10-03T11:40:18 [19165] Killing remaining worker process with pid 20117...
|
# 2014-10-03T11:40:18 [19165] Killing remaining worker process with pid 20100...
|
# 2014-10-03T11:40:18 [19165] Killing remaining worker process with pid 20121...
|
# 2014-10-03T11:40:18 [19165] Killing remaining worker process with pid 20106...
|
# 2014-10-03T11:40:18 [19165] Killing remaining worker process with pid 20104...
|
# 2014-10-03T11:40:18 [20123] Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=19301:user=root:database=test
|
# 2014-10-03T11:40:19 [19165] Killing periodic reporting process with pid 20083...
|
# 2014-10-03T11:40:19 [19165] For pid 20083 reporter status STATUS_OK
|
# 2014-10-03T11:40:19 [19165] Kill GenTest::ErrorFilter(20082)
|
# 2014-10-03T11:40:19 [19165] Server crash reported, initiating post-crash analysis...
|
# 2014-10-03T11:40:19 [19165] The last 100 lines from /home/jan/mysql/galera-test/node0/data//../mysql.err :
|
141003 11:26:42 [Note] WSREP: declaring f72324d3-4ad6-11e4-a5a3-5ef8d4dc6573 stable
|
141003 11:26:42 [Note] WSREP: Node f4b8ee21-4ad6-11e4-8d76-7640357fee10 state prim
|
141003 11:26:42 [Note] WSREP: view(view_id(PRIM,00c97b90-4ad7-11e4-9101-3ec8ad0f661d,3) memb {
|
00c97b90-4ad7-11e4-9101-3ec8ad0f661d,0
|
f4b8ee21-4ad6-11e4-8d76-7640357fee10,0
|
f72324d3-4ad6-11e4-a5a3-5ef8d4dc6573,0
|
} joined {
|
} left {
|
} partitioned {
|
})
|
141003 11:26:42 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 3
|
141003 11:26:42 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
|
141003 11:26:42 [Note] WSREP: STATE EXCHANGE: sent state msg: 0116828d-4ad7-11e4-a9dc-fadf937215d1
|
141003 11:26:42 [Note] WSREP: STATE EXCHANGE: got state msg: 0116828d-4ad7-11e4-a9dc-fadf937215d1 from 0 (jan-GE70-0NC-0ND)
|
141003 11:26:42 [Note] WSREP: STATE EXCHANGE: got state msg: 0116828d-4ad7-11e4-a9dc-fadf937215d1 from 2 (jan-GE70-0NC-0ND)
|
141003 11:26:42 [Note] WSREP: STATE EXCHANGE: got state msg: 0116828d-4ad7-11e4-a9dc-fadf937215d1 from 1 (jan-GE70-0NC-0ND)
|
141003 11:26:42 [Note] WSREP: Quorum results:
|
version = 3,
|
component = PRIMARY,
|
conf_id = 2,
|
members = 2/3 (joined/total),
|
act_id = 0,
|
last_appl. = 0,
|
protocols = 0/5/3 (gcs/repl/appl),
|
group UUID = f4b9ca7d-4ad6-11e4-964b-5b14e3a83a76
|
141003 11:26:42 [Note] WSREP: Flow-control interval: [28, 28]
|
141003 11:26:42 [Note] WSREP: New cluster view: global state: f4b9ca7d-4ad6-11e4-964b-5b14e3a83a76:0, view# 3: Primary, number of nodes: 3, my index: 1, protocol version 3
|
141003 11:26:42 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
|
141003 11:26:42 [Note] WSREP: REPL Protocols: 5 (3, 1)
|
141003 11:26:42 [Note] WSREP: Service thread queue flushed.
|
141003 11:26:42 [Note] WSREP: Assign initial position for certification: 0, protocol version: 3
|
141003 11:26:42 [Note] WSREP: Service thread queue flushed.
|
141003 11:26:44 [Note] WSREP: Member 0.0 (jan-GE70-0NC-0ND) requested state transfer from '*any*'. Selected 1.0 (jan-GE70-0NC-0ND)(SYNCED) as donor.
|
141003 11:26:44 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 0)
|
141003 11:26:44 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
|
141003 11:26:44 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'donor' --address '178.251.60.217:4444/rsync_sst' --auth '(null)' --socket '/home/jan/mysql/galera-test/node0/mysql.sock' --datadir '/home/jan/mysql/galera-test/node0/data/' --defaults-file '' '' --gtid 'f4b9ca7d-4ad6-11e4-964b-5b14e3a83a76:0''
|
141003 11:26:44 [Note] WSREP: sst_donor_thread signaled with 0
|
141003 11:26:44 [Note] WSREP: Flushing tables for SST...
|
141003 11:26:44 [Note] WSREP: Provider paused at f4b9ca7d-4ad6-11e4-964b-5b14e3a83a76:0 (10)
|
141003 11:26:44 [Note] WSREP: Tables flushed.
|
141003 11:26:52 [Note] WSREP: resuming provider at 10
|
141003 11:26:52 [Note] WSREP: Provider resumed.
|
141003 11:26:52 [Note] WSREP: 1.0 (jan-GE70-0NC-0ND): State transfer to 0.0 (jan-GE70-0NC-0ND) complete.
|
141003 11:26:52 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 0)
|
141003 11:26:52 [Note] WSREP: Member 1.0 (jan-GE70-0NC-0ND) synced with group.
|
141003 11:26:52 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
|
141003 11:26:52 [Note] WSREP: Synchronized with group, ready for connections
|
141003 11:26:52 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
|
141003 11:26:56 [Note] WSREP: 0.0 (jan-GE70-0NC-0ND): State transfer from 1.0 (jan-GE70-0NC-0ND) complete.
|
141003 11:26:56 [Note] WSREP: Member 0.0 (jan-GE70-0NC-0ND) synced with group.
|
141003 11:30:43 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:31:01 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:31:01 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:31:13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:31:13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:31:53 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:31:53 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:31:53 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:32:02 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:32:02 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:32:02 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:32:53 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:32:53 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:32:54 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:32:55 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:32:56 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:32:58 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:32:58 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:33:05 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:34:35 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:34:35 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:34:35 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:34:35 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:34:58 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:35:44 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:35:45 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:35:45 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:35:46 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:35:49 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:35:54 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:36:28 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:36:36 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:37:21 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:38:09 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:38:18 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:38:18 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:38:21 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:38:23 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:38:28 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:38:29 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:39:00 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:39:08 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:39:19 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:39:44 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:39:50 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:39:53 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:39:55 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:39:56 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:40:17 [Note] WSREP: (f4b8ee21-4ad6-11e4-8d76-7640357fee10, 'tcp://127.0.0.1:4800') turning message relay requesting on, nonlive peers: tcp://127.0.0.1:4801
|
141003 11:40:18 [Note] WSREP: (f4b8ee21-4ad6-11e4-8d76-7640357fee10, 'tcp://127.0.0.1:4800') reconnecting to f72324d3-4ad6-11e4-a5a3-5ef8d4dc6573 (tcp://127.0.0.1:4801), attempt 0
|
# 2014-10-03T11:40:19 [19165] datadir is /home/jan/mysql/galera-test/node0/data/
|
# 2014-10-03T11:40:19 [19165] binary is /home/jan/mysql/10.0-galera/sql/mysqld
|
# 2014-10-03T11:40:19 [19165] bindir is /home/jan/mysql/10.0-galera/sql
|
# 2014-10-03T11:40:19 [19165] WARNING: Core file not found!
|
gdb: /usr/local/lib/liblzma.so.5: no version information available (required by gdb)
|
"/home/jan/mysql/mariadb-patches" is not a core dump: Is a directory
|
warning: backtrace.gdb: No such file or directory
|
# 2014-10-03T11:40:30 [19165]
|
gdb: /usr/local/lib/liblzma.so.5: no version information available (required by gdb)
|
"/home/jan/mysql/mariadb-patches" is not a core dump: Is a directory
|
warning: backtrace-all.gdb: No such file or directory
|
# 2014-10-03T11:40:31 [19165]
|
# 2014-10-03T11:40:31 [19165] The last 100 lines from /home/jan/mysql/galera-test/node1/data//../mysql.err :
|
141003 11:36:40 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:36:45 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:37:19 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:38:18 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:39:00 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:39:09 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:39:09 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:39:12 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:39:12 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:39:42 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:39:42 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:39:44 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:39:49 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:39:49 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:39:50 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:39:50 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:39:53 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:39:56 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:39:56 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:40:00 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:40:00 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
2014-10-03 11:40:03 7f989d21c700 InnoDB: Assertion failure in thread 140293447993088 in file lock0lock.cc line 4033
|
InnoDB: Failing assertion: lock != ctx->wait_lock
|
InnoDB: We intentionally generate a memory trap.
|
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
|
InnoDB: If you get repeated assertion failures or crashes, even
|
InnoDB: immediately after the mysqld startup, there may be
|
InnoDB: corruption in the InnoDB tablespace. Please refer to
|
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
|
InnoDB: about forcing recovery.
|
141003 11:40:03 [ERROR] mysqld got signal 6 ;
|
This could be because you hit a bug. It is also possible that this binary
|
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
|
To report this bug, see http://kb.askmonty.org/en/reporting-bugs
|
|
We will try our best to scrape up some info that will hopefully help
|
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail.
|
|
Server version: 10.0.13-MariaDB-wsrep-debug-log
|
key_buffer_size=134217728
|
read_buffer_size=131072
|
max_used_connections=17
|
max_threads=153
|
thread_count=19
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467301 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
Thread pointer: 0x0x7f987c65e070
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
stack_bottom = 0x7f989d21be40 thread_stack 0x48000
|
mysys/stacktrace.c:246(my_print_stacktrace)[0xea276d]
|
sql/signal_handler.cc:155(handle_fatal_signal)[0x8976ec]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x10340)[0x7f98a7f5d340]
|
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x39)[0x7f98a73afbb9]
|
/lib/x86_64-linux-gnu/libc.so.6(abort+0x148)[0x7f98a73b2fc8]
|
lock/lock0lock.cc:4034(lock_get_first_lock)[0xc27ce8]
|
lock/lock0lock.cc:4303(lock_deadlock_search)[0xc28742]
|
lock/lock0lock.cc:4467(lock_deadlock_check_and_resolve)[0xc28c92]
|
lock/lock0lock.cc:2259(lock_rec_enqueue_waiting)[0xc243ff]
|
lock/lock0lock.cc:2602(lock_rec_lock_slow)[0xc25000]
|
lock/lock0lock.cc:2670(lock_rec_lock)[0xc252af]
|
lock/lock0lock.cc:7028(lock_clust_rec_read_check_and_lock(unsigned long, buf_block_t const*, unsigned char const*, dict_index_t*, unsigned long const*, lock_mode, unsigned long, que_thr_t*))[0xc2f32f]
|
row/row0sel.cc:1011(sel_set_rec_lock)[0xcf4d27]
|
row/row0sel.cc:4513(row_search_for_mysql(unsigned char*, unsigned long, row_prebuilt_t*, unsigned long, unsigned long))[0xcfb432]
|
handler/ha_innodb.cc:9515(ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int))[0xbd286c]
|
handler/ha_innodb.cc:9732(ha_innobase::rnd_next(unsigned char*))[0xbd2dc2]
|
sql/handler.cc:2617(handler::ha_rnd_next(unsigned char*))[0x89db32]
|
sql/ha_partition.cc:4910(ha_partition::rnd_next(unsigned char*))[0xe6b464]
|
sql/handler.cc:2617(handler::ha_rnd_next(unsigned char*))[0x89db32]
|
sql/filesort.cc:757(find_all_keys)[0x8935ca]
|
sql/filesort.cc:299(filesort(THD*, TABLE*, st_sort_field*, unsigned int, SQL_SELECT*, unsigned long long, bool, unsigned long long*, unsigned long long*))[0x891fff]
|
sql/sql_delete.cc:480(mysql_delete(THD*, TABLE_LIST*, Item*, SQL_I_List<st_order>*, unsigned long long, unsigned long long, select_result*))[0x9facb3]
|
sql/sql_parse.cc:3931(mysql_execute_command(THD*))[0x6833ed]
|
sql/sql_parse.cc:7010(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x68c909]
|
sql/sql_parse.cc:6834(wsrep_mysql_parse)[0x68c07a]
|
sql/sql_parse.cc:1490(dispatch_command(enum_server_command, THD*, char*, unsigned int))[0x67d0b4]
|
sql/sql_parse.cc:1087(do_command(THD*))[0x67bda8]
|
sql/sql_connect.cc:1396(do_handle_one_connection(THD*))[0x7a6f4c]
|
sql/sql_connect.cc:1308(handle_one_connection)[0x7a6ca4]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x8182)[0x7f98a7f55182]
|
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f98a7473fbd]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f986a022088): DELETE LOW_PRIORITY QUICK FROM `table2_key_pk_parts_2_int_autoinc` WHERE `col_char_12_key` IN ( 332464128 , 3 , 25 , 'v' , 6 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3
|
Connection ID (thread ID): 19
|
Status: NOT_KILLED
|
|
Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on
|
|
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
|
information that should help you find out what is causing the crash.
|
Writing a core file
|
Aborted (core dumped)
|
# 2014-10-03T11:40:31 [19165] datadir is /home/jan/mysql/galera-test/node1/data/
|
# 2014-10-03T11:40:31 [19165] binary is /home/jan/mysql/10.0-galera/sql/mysqld
|
# 2014-10-03T11:40:31 [19165] bindir is /home/jan/mysql/10.0-galera/sql
|
# 2014-10-03T11:40:31 [19165] core is /home/jan/mysql/galera-test/node1/data/core
|
gdb: /usr/local/lib/liblzma.so.5: no version information available (required by gdb)
|
61 ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c: No such file or directory.
|
warning: backtrace.gdb: No such file or directory
|
# 2014-10-03T11:40:43 [19165] [New LWP 20128]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19702]
|
# 2014-10-03T11:40:43 [19165] [New LWP 20131]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19704]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19845]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19846]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19866]
|
# 2014-10-03T11:40:43 [19165] [New LWP 20133]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19858]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19848]
|
# 2014-10-03T11:40:43 [19165] [New LWP 20099]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19700]
|
# 2014-10-03T11:40:43 [19165] [New LWP 20096]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19853]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19703]
|
# 2014-10-03T11:40:43 [19165] [New LWP 20112]
|
# 2014-10-03T11:40:43 [19165] [New LWP 20098]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19854]
|
# 2014-10-03T11:40:43 [19165] [New LWP 20127]
|
# 2014-10-03T11:40:43 [19165] [New LWP 20115]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19860]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19693]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19863]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19851]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19867]
|
# 2014-10-03T11:40:43 [19165] [New LWP 20113]
|
# 2014-10-03T11:40:43 [19165] [New LWP 20129]
|
# 2014-10-03T11:40:43 [19165] [New LWP 20111]
|
# 2014-10-03T11:40:43 [19165] [New LWP 20097]
|
# 2014-10-03T11:40:43 [19165] [New LWP 20086]
|
# 2014-10-03T11:40:43 [19165] [New LWP 20114]
|
# 2014-10-03T11:40:43 [19165] [New LWP 20132]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19872]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19868]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19865]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19864]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19862]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19861]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19859]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19855]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19852]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19850]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19849]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19847]
|
# 2014-10-03T11:40:43 [19165] [New LWP 19701]
|
# 2014-10-03T11:40:43 [19165] [Thread debugging using libthread_db enabled]
|
# 2014-10-03T11:40:43 [19165] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
|
# 2014-10-03T11:40:43 [19165] Core was generated by `/home/jan/mysql/10.0-galera/sql/mysqld --no-defaults --basedir=/home/jan/mysql/'.
|
# 2014-10-03T11:40:43 [19165] Program terminated with signal SIGABRT, Aborted.
|
# 2014-10-03T11:40:43 [19165] #0 0x00007f98a7f5a621 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
|
gdb: /usr/local/lib/liblzma.so.5: no version information available (required by gdb)
|
61 ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c: No such file or directory.
|
warning: backtrace-all.gdb: No such file or directory
|
# 2014-10-03T11:40:45 [19165] [New LWP 20128]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19702]
|
# 2014-10-03T11:40:45 [19165] [New LWP 20131]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19704]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19845]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19846]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19866]
|
# 2014-10-03T11:40:45 [19165] [New LWP 20133]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19858]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19848]
|
# 2014-10-03T11:40:45 [19165] [New LWP 20099]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19700]
|
# 2014-10-03T11:40:45 [19165] [New LWP 20096]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19853]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19703]
|
# 2014-10-03T11:40:45 [19165] [New LWP 20112]
|
# 2014-10-03T11:40:45 [19165] [New LWP 20098]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19854]
|
# 2014-10-03T11:40:45 [19165] [New LWP 20127]
|
# 2014-10-03T11:40:45 [19165] [New LWP 20115]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19860]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19693]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19863]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19851]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19867]
|
# 2014-10-03T11:40:45 [19165] [New LWP 20113]
|
# 2014-10-03T11:40:45 [19165] [New LWP 20129]
|
# 2014-10-03T11:40:45 [19165] [New LWP 20111]
|
# 2014-10-03T11:40:45 [19165] [New LWP 20097]
|
# 2014-10-03T11:40:45 [19165] [New LWP 20086]
|
# 2014-10-03T11:40:45 [19165] [New LWP 20114]
|
# 2014-10-03T11:40:45 [19165] [New LWP 20132]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19872]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19868]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19865]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19864]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19862]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19861]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19859]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19855]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19852]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19850]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19849]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19847]
|
# 2014-10-03T11:40:45 [19165] [New LWP 19701]
|
# 2014-10-03T11:40:45 [19165] [Thread debugging using libthread_db enabled]
|
# 2014-10-03T11:40:45 [19165] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
|
# 2014-10-03T11:40:45 [19165] Core was generated by `/home/jan/mysql/10.0-galera/sql/mysqld --no-defaults --basedir=/home/jan/mysql/'.
|
# 2014-10-03T11:40:45 [19165] Program terminated with signal SIGABRT, Aborted.
|
# 2014-10-03T11:40:45 [19165] #0 0x00007f98a7f5a621 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
|
# 2014-10-03T11:40:45 [19165] The last 100 lines from /home/jan/mysql/galera-test/node2/data//../mysql.err :
|
141003 11:26:53 [Note] InnoDB: Database was not shutdown normally!
|
141003 11:26:53 [Note] InnoDB: Starting crash recovery.
|
141003 11:26:53 [Note] InnoDB: Reading tablespace information from the .ibd files...
|
141003 11:26:53 [Note] InnoDB: Restoring possible half-written data pages
|
141003 11:26:53 [Note] InnoDB: from the doublewrite buffer...
|
141003 11:26:55 [Note] InnoDB: 128 rollback segment(s) are active.
|
141003 11:26:56 [Note] InnoDB: Waiting for purge to start
|
141003 11:26:56 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.19-67.0 started; log sequence number 1616871
|
141003 11:26:56 [Note] Server socket created on IP: '::'.
|
141003 11:26:56 [Note] Event Scheduler: Loaded 0 events
|
141003 11:26:56 [Note] WSREP: Signalling provider to continue.
|
141003 11:26:56 [Note] WSREP: SST received: f4b9ca7d-4ad6-11e4-964b-5b14e3a83a76:0
|
141003 11:26:56 [Note] WSREP: 0.0 (jan-GE70-0NC-0ND): State transfer from 1.0 (jan-GE70-0NC-0ND) complete.
|
141003 11:26:56 [Note] WSREP: Shifting JOINER -> JOINED (TO: 0)
|
141003 11:26:56 [Note] WSREP: Member 0.0 (jan-GE70-0NC-0ND) synced with group.
|
141003 11:26:56 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
|
141003 11:26:56 [Note] WSREP: Synchronized with group, ready for connections
|
141003 11:26:56 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
|
141003 11:26:56 [Note] /home/jan/mysql/10.0-galera/sql/mysqld: ready for connections.
|
Version: '10.0.13-MariaDB-wsrep-debug-log' socket: '/home/jan/mysql/galera-test/node2/mysql.sock' port: 19302 Source distribution, wsrep_25.10.r4123
|
141003 11:30:01 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:30:11 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:30:44 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:31:04 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:31:09 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:31:10 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:31:15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:31:47 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:31:53 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:32:53 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:33:01 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:33:44 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:33:44 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:33:44 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:33:44 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:33:44 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:33:44 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:33:56 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:34:35 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:34:35 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:34:40 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:35:37 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:36:35 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:36:35 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:37:18 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:37:26 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:37:27 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:38:18 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:38:19 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:38:20 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
|
141003 11:39:12 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:39:12 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:39:43 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:39:50 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:39:50 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:39:50 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:39:51 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:39:55 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:39:56 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:39:56 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
|
141003 11:40:17 [Note] WSREP: (00c97b90-4ad7-11e4-9101-3ec8ad0f661d, 'tcp://127.0.0.1:4802') turning message relay requesting on, nonlive peers: tcp://127.0.0.1:4801
|
141003 11:40:18 [Note] WSREP: (00c97b90-4ad7-11e4-9101-3ec8ad0f661d, 'tcp://127.0.0.1:4802') reconnecting to f72324d3-4ad6-11e4-a5a3-5ef8d4dc6573 (tcp://127.0.0.1:4801), attempt 0
|
141003 11:40:19 [Note] WSREP: evs::proto(00c97b90-4ad7-11e4-9101-3ec8ad0f661d, OPERATIONAL, view_id(REG,00c97b90-4ad7-11e4-9101-3ec8ad0f661d,3)) suspecting node: f72324d3-4ad6-11e4-a5a3-5ef8d4dc6573
|
141003 11:40:20 [Note] WSREP: evs::proto(00c97b90-4ad7-11e4-9101-3ec8ad0f661d, GATHER, view_id(REG,00c97b90-4ad7-11e4-9101-3ec8ad0f661d,3)) suspecting node: f72324d3-4ad6-11e4-a5a3-5ef8d4dc6573
|
141003 11:40:20 [Note] WSREP: evs::proto(00c97b90-4ad7-11e4-9101-3ec8ad0f661d, GATHER, view_id(REG,00c97b90-4ad7-11e4-9101-3ec8ad0f661d,3)) suspecting node: f72324d3-4ad6-11e4-a5a3-5ef8d4dc6573
|
141003 11:40:21 [Note] WSREP: declaring f4b8ee21-4ad6-11e4-8d76-7640357fee10 stable
|
141003 11:40:22 [Note] WSREP: Node 00c97b90-4ad7-11e4-9101-3ec8ad0f661d state prim
|
141003 11:40:22 [Note] WSREP: view(view_id(PRIM,00c97b90-4ad7-11e4-9101-3ec8ad0f661d,4) memb {
|
00c97b90-4ad7-11e4-9101-3ec8ad0f661d,0
|
f4b8ee21-4ad6-11e4-8d76-7640357fee10,0
|
} joined {
|
} left {
|
} partitioned {
|
f72324d3-4ad6-11e4-a5a3-5ef8d4dc6573,0
|
})
|
141003 11:40:22 [Note] WSREP: forgetting f72324d3-4ad6-11e4-a5a3-5ef8d4dc6573 (tcp://127.0.0.1:4801)
|
141003 11:40:22 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2
|
141003 11:40:22 [Note] WSREP: (00c97b90-4ad7-11e4-9101-3ec8ad0f661d, 'tcp://127.0.0.1:4802') turning message relay requesting off
|
141003 11:40:22 [Note] WSREP: STATE_EXCHANGE: sent state UUID: ea0a04c3-4ad8-11e4-8d50-829089ae2380
|
141003 11:40:22 [Note] WSREP: STATE EXCHANGE: sent state msg: ea0a04c3-4ad8-11e4-8d50-829089ae2380
|
141003 11:40:22 [Note] WSREP: STATE EXCHANGE: got state msg: ea0a04c3-4ad8-11e4-8d50-829089ae2380 from 0 (jan-GE70-0NC-0ND)
|
141003 11:40:22 [Note] WSREP: STATE EXCHANGE: got state msg: ea0a04c3-4ad8-11e4-8d50-829089ae2380 from 1 (jan-GE70-0NC-0ND)
|
141003 11:40:22 [Note] WSREP: Quorum results:
|
version = 3,
|
component = PRIMARY,
|
conf_id = 3,
|
members = 2/2 (joined/total),
|
act_id = 660,
|
last_appl. = 640,
|
protocols = 0/5/3 (gcs/repl/appl),
|
group UUID = f4b9ca7d-4ad6-11e4-964b-5b14e3a83a76
|
141003 11:40:22 [Note] WSREP: Flow-control interval: [23, 23]
|
141003 11:40:27 [Note] WSREP: cleaning up f72324d3-4ad6-11e4-a5a3-5ef8d4dc6573 (tcp://127.0.0.1:4801)
|
141003 11:40:30 [Note] WSREP: New cluster view: global state: f4b9ca7d-4ad6-11e4-964b-5b14e3a83a76:660, view# 4: Primary, number of nodes: 2, my index: 0, protocol version 3
|
141003 11:40:30 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
|
141003 11:40:30 [Note] WSREP: REPL Protocols: 5 (3, 1)
|
141003 11:40:30 [Note] WSREP: Service thread queue flushed.
|
141003 11:40:30 [Note] WSREP: Assign initial position for certification: 660, protocol version: 3
|
141003 11:40:30 [Note] WSREP: Service thread queue flushed.
|
141003 11:40:30 [Warning] WSREP: Releasing seqno 660 before 661 was assigned.
|
# 2014-10-03T11:40:45 [19165] datadir is /home/jan/mysql/galera-test/node2/data/
|
# 2014-10-03T11:40:45 [19165] binary is /home/jan/mysql/10.0-galera/sql/mysqld
|
# 2014-10-03T11:40:45 [19165] bindir is /home/jan/mysql/10.0-galera/sql
|
# 2014-10-03T11:40:45 [19165] WARNING: Core file not found!
|
gdb: /usr/local/lib/liblzma.so.5: no version information available (required by gdb)
|
"/home/jan/mysql/mariadb-patches" is not a core dump: Is a directory
|
warning: backtrace.gdb: No such file or directory
|
# 2014-10-03T11:40:45 [19165]
|
gdb: /usr/local/lib/liblzma.so.5: no version information available (required by gdb)
|
"/home/jan/mysql/mariadb-patches" is not a core dump: Is a directory
|
warning: backtrace-all.gdb: No such file or directory
|
# 2014-10-03T11:40:46 [19165]
|
# 2014-10-03T11:40:46 [19165] Test completed with failure status STATUS_SERVER_CRASHED (101)
|
# 2014-10-03T11:40:46 [19165] GenTest exited with exit status STATUS_SERVER_CRASHED (101)
|
# 2014-10-03T11:40:46 [19165] Stopping server on port 19300
|
# 2014-10-03T11:40:46 [19165] Stale connection to 19300. Reconnecting
|
# 2014-10-03T11:40:46 [19165] Stopping server on port 19301
|
# 2014-10-03T11:40:46 [19165] Stale connection to 19301. Reconnecting
|
# 2014-10-03T11:40:46 [19165] ERROR: (Re)connect to 19301 failed due to 2003: Can't connect to MySQL server on '127.0.0.1' (111)
|
# 2014-10-03T11:40:46 [19165] Server would not shut down properly. Terminate it
|
# 2014-10-03T11:40:46 [19165] Terminated process 19693
|
# 2014-10-03T11:40:46 [19165] Stopping server on port 19302
|
# 2014-10-03T11:40:46 [19165] Stale connection to 19302. Reconnecting
|
# 2014-10-03T11:40:46 [19165] [19165] ./runall-new.pl will exit with exit status STATUS_SERVER_CRASHED (101)
|