# 2010-07-26T13:00:30 Copyright (c) 2008-2009 Sun Microsystems, Inc. All rights reserved. Use is subject to license terms. # 2010-07-26T13:00:30 Please see http://forge.mysql.com/wiki/Category:RandomQueryGenerator for more information on this test framework. # 2010-07-26T13:00:30 Starting # 2010-07-26T13:00:30 # ./runall.pl \ # 2010-07-26T13:00:30 # --basedir=/mysql/mysql-5.1.49-linux-i686-glibc23/ \ # 2010-07-26T13:00:30 # --vardir1=/tmp/51/ \ # 2010-07-26T13:00:30 # --vardir2=/tmp/52/ \ # 2010-07-26T13:00:30 # --mysqld1=--log-output=none \ # 2010-07-26T13:00:30 # --mysqld1=--log_error=/randgen/new_testing/5/51.log \ # 2010-07-26T13:00:30 # --mysqld2=--log-output=none \ # 2010-07-26T13:00:30 # --mysqld2=--log_error=/randgen/new_testing/5/52.log \ # 2010-07-26T13:00:30 # --mysqld2=--ignore-builtin-innodb \ # 2010-07-26T13:00:30 # --mysqld2=--plugin-load=innodb=ha_innodb_plugin.so:innodb_trx=ha_innodb_plugin.so:innodb_locks=ha_innodb_plugin.so:innodb_cmp=ha_innodb_plugin.so:innodb_cmp_reset=ha_innodb_plugin.so:innodb_cmpmem=ha_innodb_plugin.so:innodb_cmpmem_reset=ha_innodb_plugin.so \ # 2010-07-26T13:00:30 # --mysqld2=--plugin-dir=/mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin/ \ # 2010-07-26T13:00:30 # --gendata=/randgen/new_testing/5/5.zz \ # 2010-07-26T13:00:30 # --grammar=/randgen/new_testing/5/5.yy \ # 2010-07-26T13:00:30 # --queries=100000 \ # 2010-07-26T13:00:30 # --threads=10 \ # 2010-07-26T13:00:30 # --Validators=ResultsetComparator,MarkErrorLog,AbortOnSyntaxError # 2010-07-26T13:00:30 master_port : 19300 slave_port : 19302 master_ports : 19300 19302 MTR_BUILD_THREAD : 930 # 2010-07-26T13:00:30 Running perl mysql-test-run.pl --start-and-exit --skip-ndb --mysqld=--core-file --mysqld=--loose-new --mysqld=--sql-mode=no_engine_substitution --mysqld=--relay-log=slave-relay-bin --mysqld=--loose-innodb --mysqld=--loose-falcon-debug-mask=2 --mysqld=--secure-file-priv= --mysqld=--max-allowed-packet=16Mb --mysqld=--loose-innodb-status-file=1 --mysqld=--master-retry-count=65535 --vardir=/tmp/51/ --master_port=19300 --mysqld="--log-output=none" --mysqld="--log_error=/randgen/new_testing/5/51.log" 1st 2>&1 . ======================================================= WARNING: Using mysql-test-run.pl version 1! ======================================================= Logging: lib/v1/mysql-test-run.pl --start-and-exit --skip-ndb --mysqld=--core-file --mysqld=--loose-new --mysqld=--sql-mode=no_engine_substitution --mysqld=--relay-log=slave-relay-bin --mysqld=--loose-innodb --mysqld=--loose-falcon-debug-mask=2 --mysqld=--secure-file-priv= --mysqld=--max-allowed-packet=16Mb --mysqld=--loose-innodb-status-file=1 --mysqld=--master-retry-count=65535 --vardir=/tmp/51/ --master_port=19300 --mysqld=--log-output=none --mysqld=--log_error=/randgen/new_testing/5/51.log 1st 100726 13:00:31 [Note] Plugin 'FEDERATED' is disabled. MySQL Version 5.1.49 Using dynamic switching of binlog format Skipping ndbcluster Setting mysqld to support SSL connections Using MTR_BUILD_THREAD = 930 Using MASTER_MYPORT = 19300 Using MASTER_MYPORT1 = 19301 Using SLAVE_MYPORT = 19302 Using SLAVE_MYPORT1 = 19303 Using SLAVE_MYPORT2 = 19304 Using IM_PORT = 19307 Using IM_MYSQLD1_PORT = 19308 Using IM_MYSQLD2_PORT = 19309 Killing Possible Leftover Processes Removing Stale Files Creating Directories Installing Master Database ======================================================= TEST RESULT TIME (ms) ------------------------------------------------------- Servers started, exiting # 2010-07-26T13:00:32 Running perl mysql-test-run.pl --start-and-exit --skip-ndb --mysqld=--core-file --mysqld=--loose-new --mysqld=--sql-mode=no_engine_substitution --mysqld=--relay-log=slave-relay-bin --mysqld=--loose-innodb --mysqld=--loose-falcon-debug-mask=2 --mysqld=--secure-file-priv= --mysqld=--max-allowed-packet=16Mb --mysqld=--loose-innodb-status-file=1 --mysqld=--master-retry-count=65535 --vardir=/tmp/52/ --master_port=19302 --mysqld="--log-output=none" --mysqld="--log_error=/randgen/new_testing/5/52.log" --mysqld="--ignore-builtin-innodb" --mysqld="--plugin-load=innodb=ha_innodb_plugin.so:innodb_trx=ha_innodb_plugin.so:innodb_locks=ha_innodb_plugin.so:innodb_cmp=ha_innodb_plugin.so:innodb_cmp_reset=ha_innodb_plugin.so:innodb_cmpmem=ha_innodb_plugin.so:innodb_cmpmem_reset=ha_innodb_plugin.so" --mysqld="--plugin-dir=/mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin/" 1st 2>&1 . ======================================================= WARNING: Using mysql-test-run.pl version 1! ======================================================= Logging: lib/v1/mysql-test-run.pl --start-and-exit --skip-ndb --mysqld=--core-file --mysqld=--loose-new --mysqld=--sql-mode=no_engine_substitution --mysqld=--relay-log=slave-relay-bin --mysqld=--loose-innodb --mysqld=--loose-falcon-debug-mask=2 --mysqld=--secure-file-priv= --mysqld=--max-allowed-packet=16Mb --mysqld=--loose-innodb-status-file=1 --mysqld=--master-retry-count=65535 --vardir=/tmp/52/ --master_port=19302 --mysqld=--log-output=none --mysqld=--log_error=/randgen/new_testing/5/52.log --mysqld=--ignore-builtin-innodb --mysqld=--plugin-load=innodb=ha_innodb_plugin.so:innodb_trx=ha_innodb_plugin.so:innodb_locks=ha_innodb_plugin.so:innodb_cmp=ha_innodb_plugin.so:innodb_cmp_reset=ha_innodb_plugin.so:innodb_cmpmem=ha_innodb_plugin.so:innodb_cmpmem_reset=ha_innodb_plugin.so --mysqld=--plugin-dir=/mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin/ 1st 100726 13:00:32 [Note] Plugin 'FEDERATED' is disabled. MySQL Version 5.1.49 Using dynamic switching of binlog format Skipping ndbcluster Setting mysqld to support SSL connections Using MTR_BUILD_THREAD = 930 Using MASTER_MYPORT = 19302 Using MASTER_MYPORT1 = 19303 Using SLAVE_MYPORT = 19302 Using SLAVE_MYPORT1 = 19303 Using SLAVE_MYPORT2 = 19304 Using IM_PORT = 19307 Using IM_MYSQLD1_PORT = 19308 Using IM_MYSQLD2_PORT = 19309 Killing Possible Leftover Processes Removing Stale Files Creating Directories Installing Master Database ======================================================= TEST RESULT TIME (ms) ------------------------------------------------------- Servers started, exiting # 2010-07-26T13:00:34 Starting # 2010-07-26T13:00:34 gentest.pl \ # 2010-07-26T13:00:34 --gendata=/randgen/new_testing/5/5.zz \ # 2010-07-26T13:00:34 --validator=ResultsetComparator \ # 2010-07-26T13:00:34 --validator=MarkErrorLog \ # 2010-07-26T13:00:34 --validator=AbortOnSyntaxError \ # 2010-07-26T13:00:34 --threads=10 \ # 2010-07-26T13:00:34 --queries=100000 \ # 2010-07-26T13:00:34 --duration=3600 \ # 2010-07-26T13:00:34 --dsn=dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test \ # 2010-07-26T13:00:34 --dsn=dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test \ # 2010-07-26T13:00:34 --grammar=/randgen/new_testing/5/5.yy # 2010-07-26T13:00:34 ------------------------------- # 2010-07-26T13:00:34 Configuration # 2010-07-26T13:00:34 dsn => ['dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test', 'dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test'] # 2010-07-26T13:00:34 duration => 3600 # 2010-07-26T13:00:34 gendata => /randgen/new_testing/5/5.zz # 2010-07-26T13:00:34 grammar => /randgen/new_testing/5/5.yy # 2010-07-26T13:00:34 queries => 100000 # 2010-07-26T13:00:34 reporters => [''] # 2010-07-26T13:00:34 seed => 1 # 2010-07-26T13:00:34 threads => 10 # 2010-07-26T13:00:34 validators => ['ResultsetComparator', 'MarkErrorLog', 'AbortOnSyntaxError'] # 2010-07-26T13:00:34 Executor initialized, id # 2010-07-26T13:00:34 Default schema: test # 2010-07-26T13:00:34 # Creating MySQL table: test.table100_innodb_int_autoinc; engine: innodb; rows: 100 . # 2010-07-26T13:00:34 Executor initialized, id # 2010-07-26T13:00:34 Default schema: test # 2010-07-26T13:00:34 # Creating MySQL table: test.table100_innodb_int_autoinc; engine: innodb; rows: 100 . # 2010-07-26T13:00:35 Reporters: ErrorLog, Backtrace # 2010-07-26T13:00:35 Validators: ResultsetComparator, MarkErrorLog, AbortOnSyntaxError # 2010-07-26T13:00:35 Starting 10 processes, 100000 queries each, duration 3600 seconds. # 2010-07-26T13:00:35 GenTest::ErrorFilter(13606) started # 2010-07-26T13:00:35 Executor initialized, id 1 # 2010-07-26T13:00:35 Default schema: test # 2010-07-26T13:00:35 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-26T13:00:35 Executor initialized, id 2 # 2010-07-26T13:00:35 Default schema: test # 2010-07-26T13:00:35 Caching metadata for dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test # 2010-07-26T13:00:35 MarkErrorLog found errorlog at /randgen/new_testing/5/51.log # 2010-07-26T13:00:35 Executor initialized, id 1 # 2010-07-26T13:00:35 Default schema: test # 2010-07-26T13:00:35 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-26T13:00:35 Executor initialized, id 2 # 2010-07-26T13:00:35 Default schema: test # 2010-07-26T13:00:35 Caching metadata for dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test # 2010-07-26T13:00:35 Executor initialized, id 1 # 2010-07-26T13:00:35 Default schema: test # 2010-07-26T13:00:35 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-26T13:00:35 Query: UPDATE `table100_innodb_int_autoinc` SET `pk` = 9 WHERE `col_blob` > 'at' AND `col_blob_key` < 'kfzogybtkjkpttdftjvpfgwdleinctcibsanrkxmtskurjkbrfthplegltfvvbmyihkjcrhcfjqsgroeyjvqheofvdcujkgvyanveuqlyhnkwizomgnqqxmctihkgrzvgoxwzoaoqfhjajxhchyeexglnxgoruczozuiawdckfqxatruutqbytleszhxgopyizrctmefncptaaxhefzenjekskspdwewwowamnlmvtuountpopj' failed: 1062 Duplicate entry '%s' for key '%s'. Further errors of this kind will be suppressed. # 2010-07-26T13:00:35 Executor initialized, id 2 # 2010-07-26T13:00:35 Default schema: test # 2010-07-26T13:00:35 Caching metadata for dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test # 2010-07-26T13:00:35 MarkErrorLog found errorlog at /randgen/new_testing/5/51.log # 2010-07-26T13:00:35 Executor initialized, id 1 # 2010-07-26T13:00:35 Default schema: test # 2010-07-26T13:00:35 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-26T13:00:35 Executor initialized, id 2 # 2010-07-26T13:00:35 Default schema: test # 2010-07-26T13:00:35 Caching metadata for dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test # 2010-07-26T13:00:35 Executor initialized, id 1 # 2010-07-26T13:00:35 Default schema: test # 2010-07-26T13:00:35 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-26T13:00:35 Executor initialized, id 2 # 2010-07-26T13:00:35 MarkErrorLog found errorlog at /randgen/new_testing/5/51.log # 2010-07-26T13:00:35 Default schema: test # 2010-07-26T13:00:35 Caching metadata for dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test # 2010-07-26T13:00:35 Executor initialized, id 1 # 2010-07-26T13:00:35 Default schema: test # 2010-07-26T13:00:35 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-26T13:00:35 MarkErrorLog found errorlog at /randgen/new_testing/5/51.log # 2010-07-26T13:00:35 Executor initialized, id 2 # 2010-07-26T13:00:35 Default schema: test # 2010-07-26T13:00:35 Caching metadata for dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test # 2010-07-26T13:00:35 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 7 WHERE `col_blob` > 'kkhpglmmkdrzuodbbjsbexbzhybdtdghnhqyfesojlzybundaegjjkraxeqetxtvgoypekqdkfkeddfvkpdqmmebncpxqexsoqywbnblqtvxfddxkxcknronbaaxgwqmdtojrbsamnbryacjrmcxhmsyigssluvnahtkxbnbfvyrez' AND `pk` < '2007-08-27 03:51:38' failed: affected_rows mismatch between servers (83 vs. 2) # 2010-07-26T13:00:35 MarkErrorLog found errorlog at /randgen/new_testing/5/51.log # 2010-07-26T13:00:35 Executor initialized, id 1 # 2010-07-26T13:00:35 Default schema: test # 2010-07-26T13:00:35 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-26T13:00:35 Executor initialized, id 2 # 2010-07-26T13:00:35 Default schema: test # 2010-07-26T13:00:35 Caching metadata for dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test # 2010-07-26T13:00:36 Executor initialized, id 1 # 2010-07-26T13:00:36 Default schema: test # 2010-07-26T13:00:36 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-26T13:00:36 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob` = 5 WHERE `pk` > 'time' AND `col_blob_key` < 'bpmhwkkhpglmmkdrzuodbbjsbexbzhybdtdghnhqyfe' failed: affected_rows mismatch between servers (2 vs. 0E0) # 2010-07-26T13:00:36 MarkErrorLog found errorlog at /randgen/new_testing/5/51.log # 2010-07-26T13:00:36 MarkErrorLog found errorlog at /randgen/new_testing/5/51.log # 2010-07-26T13:00:36 Executor initialized, id 1 # 2010-07-26T13:00:36 Default schema: test # 2010-07-26T13:00:36 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-26T13:00:36 Executor initialized, id 2 # 2010-07-26T13:00:36 Default schema: test # 2010-07-26T13:00:36 Caching metadata for dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test # 2010-07-26T13:00:36 Started periodic reporting process... # 2010-07-26T13:00:36 Executor initialized, id 2 # 2010-07-26T13:00:36 Default schema: test # 2010-07-26T13:00:36 Caching metadata for dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test # 2010-07-26T13:00:36 Executor initialized, id 1 # 2010-07-26T13:00:36 Default schema: test # 2010-07-26T13:00:36 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-26T13:00:36 MarkErrorLog found errorlog at /randgen/new_testing/5/51.log # 2010-07-26T13:00:36 Executor initialized, id 2 # 2010-07-26T13:00:36 Default schema: test # 2010-07-26T13:00:36 Caching metadata for dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test # 2010-07-26T13:00:36 MarkErrorLog found errorlog at /randgen/new_testing/5/51.log # 2010-07-26T13:00:36 MarkErrorLog found errorlog at /randgen/new_testing/5/51.log # 2010-07-26T13:00:36 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set` > NULL AND `col_set` < 'ysarnzmvhawcfgdoecusotpkwswptkigpcycionazkuqikzezpjxdcrfzwhtwtysbrfdrclrerviivzafksqgqicngfrwufcouwckhgylzdekwcjtdxtsxdijwvltnvwkawmmjumbahubzbskxxdjheldhyrgkaiiqcmtrzmpxgmmhz' failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-26T13:00:36 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob` = 7 WHERE `col_blob_key` > '2005-06-14 06:43:06' AND `col_set_key` < 'got' failed: affected_rows mismatch between servers (2 vs. 0E0) # 2010-07-26T13:00:36 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 7 WHERE `pk` > 'been' AND `pk` < '2000-08-05 05:26:05' failed: affected_rows mismatch between servers (41 vs. 40) # 2010-07-26T13:00:36 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob_key` > '2005-05-20 23:37:50' AND `col_blob` < 8 failed: affected_rows mismatch between servers (2 vs. 0E0) # 2010-07-26T13:00:37 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > 1 AND `col_blob_key` < 'some' failed: affected_rows mismatch between servers (5 vs. 7) # 2010-07-26T13:00:37 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set` > '2007-12-06 05:13:09' AND `col_set` < 'lyabuysarnzmvhawcfgdoecusotpkwswptkigpcycionazkuqikzezpjxdcrfzwhtwtysbrfdrclrerviivzafksqgqicngfrwufcouwckhgylzdekwcjtdxtsxdijwvltnvwkawmmjumbahubzbskxxdjheldhyrgkaiiqcmtrzmp' failed: affected_rows mismatch between servers (9 vs. 10) # 2010-07-26T13:00:37 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'bpikqwziczkfzogybtkjkpttdftjvpfgwdleinctcibsanrkxmtskurjkbrfthplegltfvvbmyihkjcrhcfjqsgroeyjvqheofvdcujkgvyanveuqlyhnkwizomgnqqxmctihkgrzvgoxwzoaoqfhjajxhchyeexglnxgoruczozuiawdckfqxatruutqbytleszhxgopyizrctmefncptaaxhe' AND `col_set` < 'going' failed: affected_rows mismatch between servers (4 vs. 3) # 2010-07-26T13:00:37 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 8 WHERE `pk` > 'a' AND `col_blob_key` < 'what' failed: affected_rows mismatch between servers (0E0 vs. 3) # 2010-07-26T13:00:37 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'swsigdipulrcbpmhwkkhpglmmkdrzuodbbjsbexbzhybdtdghnhqyfesojlzybundaegjjkraxeqetxtvgoypekqdkfkeddfvkpdqmmebncpxqexsoqywbnblqtvxfddxkxcknronbaaxgwqmdtojrbsamnbryacjrmcxhmsyigssluvnahtkxbnbfvyre' AND `col_set_key` < '2000-09-25 06:08:30' failed: affected_rows mismatch between servers (5 vs. 0E0) # 2010-07-26T13:00:38 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'qlyabuysarnzmvhawcfgdoecusotpkwswptkigpcycionazkuqikzezpjxdcrfzwhtwtysbrfdrclrerviivzafksqgqicngfrwufcouwckhgylzdekwcjtdxts' AND `pk` < '2008-12-02 19:03:27' failed: affected_rows mismatch between servers (54 vs. 60) # 2010-07-26T13:00:38 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 4 WHERE `pk` > 'mean' AND `col_blob_key` < 'izeqtnlqpbcutbkvlfublwhlffeumbrqrxxwdtrslpkmcnclsjopedydwvtjmkgagunlclzyzcxlahuicttjvxwpvivzonlkfhrstdlifzauiugqosfzvothecgzmaabuwavfosacxgrgcaithzxtpmrknwuiexjmvokbc' failed: affected_rows mismatch between servers (1 vs. 0E0) # 2010-07-26T13:00:38 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'you' AND `pk` < '2009-02-04 05:53:20' failed: affected_rows mismatch between servers (14 vs. 13) # 2010-07-26T13:00:38 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set` > 2 AND `col_set` < 'here' failed: affected_rows mismatch between servers (2 vs. 1) # 2010-07-26T13:00:38 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob` = 2 WHERE `col_set` > '2007-01-26 11:14:19' AND `pk` < '2009-10-16 14:42:29' failed: affected_rows mismatch between servers (1 vs. 2) # 2010-07-26T13:00:39 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set` = 4 WHERE `col_set` > 5 AND `col_blob` < 'quuuzhgpyyababvmrpxqnohoirxafugyywaffoiulmtpwyngrhgkaxvgtmhzskmytmigwyruojuqvpaxlqiqhwaxgfssqja' failed: affected_rows mismatch between servers (1 vs. 2) # 2010-07-26T13:00:39 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set` = 1 WHERE `pk` > 6 AND `col_set_key` < 'zzxfbhbpikqwziczkfzogybtkjkpttdftjvpfgwdleinctcibsanrkxmtskurjkbrfthplegltfvvbmyihkjcrhcfjqsgroeyjvqheofvdcujkgvyanveuqlyhnkwizomgnqqxmctihkgrzvgoxwzoaoqfhjajxhchyeexglnxgoruczozuiawdckfqxatruutqbytleszhxgopyizrctmefncpta' failed: affected_rows mismatch between servers (0E0 vs. 1) # 2010-07-26T13:00:39 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 7 WHERE `pk` > 7 AND `pk` < '2004-07-08 21:02:02' failed: affected_rows mismatch between servers (36 vs. 37) # 2010-07-26T13:00:39 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob` > 1 AND `pk` < '2002-12-24 03:25:05' failed: affected_rows mismatch between servers (14 vs. 15) # 2010-07-26T13:00:39 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 6 WHERE `pk` > 'are' AND `col_set` < "didn't" failed: affected_rows mismatch between servers (10 vs. 9) # 2010-07-26T13:00:39 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob` = 5 WHERE `pk` > 'vcxmxeokldbfvpwjtnqlyabuysarnzmvhawcfgdoecusotpkwswptkigpcycionazkuqikzezpjxdcrfzwhtwtysbrfdrclrerviivzafksqgqicngfrwufcouwckhgylzdekwcjtdxtsxdijwvltnvwkawmmjumbahubzbskxxdjheldhyrgkaiiqcmtrzmpxgmmhzoaglwcdgrytgomxmtdtfsxssnafanim' AND `pk` < '2009-05-07 05:00:41' failed: affected_rows mismatch between servers (44 vs. 45) # 2010-07-26T13:00:39 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob` = 8 WHERE `col_blob_key` > '2004-11-03 06:11:29' AND `col_blob_key` < 7 failed: affected_rows mismatch between servers (1 vs. 0E0) # 2010-07-26T13:00:39 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'ok' AND `col_blob` < 8 failed: affected_rows mismatch between servers (44 vs. 45) # 2010-07-26T13:00:39 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 1 AND `col_set_key` < 'dchtmmprlswsigdipulrcbpmhwkkhpglmmkdrzuodbbjsbexbzhybdtdghnhqyfesojlzybundaegjjkraxeqetxtvgoypekqdkfkeddfvkpdqmmebncpxqexsoqywbnblqtvxfddxkxcknronbaaxgwqmdtojrbs' failed: affected_rows mismatch between servers (4 vs. 3) # 2010-07-26T13:00:40 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set` = 3 WHERE `pk` > 'bqngkmupkksfxcyhvgdazbueuefxyjqcytnrtjlygorngnezcdxcmekjyjvajgyzxpuk' AND `col_set` < 'tbqngkmupkksfxcyhvgdazbueuefxyjqcytnrtjlygorngnezcdxcmekjyjvajgyzxpukhsenojzfosqbtpszimznsxfelrlprsmijpgqlwrloryjxjoujnowflhlfqeevdqvijwkujgrcnsjptfviqtpadwfmwtcjmxgiknroixbcqarpbknmdrmblsdhthtgbixkbjjmbkenonh' failed: affected_rows mismatch between servers (9 vs. 0E0) # 2010-07-26T13:00:40 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > "I'm" AND `col_set` < 'nbvcyzzxfbhbpikqwziczkfzogybtkjkpttdftjvpfgwdleinctcibsanrkxmtskurjkbrfthplegltfvvbmyihkjcrhcfjqsgroeyjvqheofvdcujkgvyanveuqlyhnkwizomgnqqxmctihkgrzvgoxwzoaoqfhjajxhchyeexglnxgoruczozuiawdckfqxatruutqbytleszhxgopy' failed: affected_rows mismatch between servers (0E0 vs. 7) # 2010-07-26T13:00:40 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'zvcxmxeokldbfvpwjtnqlyabuysarnzmvhawc' AND `col_set` < 'mean' failed: affected_rows mismatch between servers (9 vs. 2) # 2010-07-26T13:00:40 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 3 WHERE `col_blob_key` > 0 AND `col_blob_key` < 4 failed: affected_rows mismatch between servers (0E0 vs. 2) # 2010-07-26T13:00:40 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'got' AND `col_set` < 8 failed: affected_rows mismatch between servers (1 vs. 0E0) # 2010-07-26T13:00:40 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'ynnhlnbvcyzzxfbhbpikqwziczkfzogybtkjkpttdftjvpfgwdleinctcibsanrkxmtskurjkbrfthplegltfvvbmyihkjcrhcfjqsgroeyjvqheofvdcujkgvyanveuqlyhnkwizomgnqqxmctihkgrzvgoxwzoaoqfhjajxhchyeexglnxgoruczozuiawdckfqxatruutqbytleszhxgopyizrctmefncptaaxhefzenjekskspd' AND `col_set` < 'vynnhlnbvcyzzxfbhbpikqwziczkfzogybtkjkpttdftjvpfgwdleinctcibsanrkxmtskurjkbrfthplegltfvvbmyihkjcrhcfjqsgroeyjvqheofvdcujkgvyanveu' failed: affected_rows mismatch between servers (0E0 vs. 1) # 2010-07-26T13:00:40 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 2 WHERE `pk` > 'yocpzvcxmxeokldbfvpwjtnqlyabuysarnzmvhawcfgdoecusotpkwswptkigpcycionazkuqikzezpjxdcrfzwhtwtysbrfdrclrerviivzafksqgqicngfrwufcouwckhgylzdek' AND `col_set_key` < 'about' failed: affected_rows mismatch between servers (0E0 vs. 8) # 2010-07-26T13:00:41 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob` = 4 WHERE `pk` > 6 AND `col_blob_key` < 'hey' failed: affected_rows mismatch between servers (1 vs. 0E0) # 2010-07-26T13:00:41 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob` = 1 WHERE `pk` > 'and' AND `col_set_key` < 8 failed: affected_rows mismatch between servers (1 vs. 9) # 2010-07-26T13:00:41 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > '2004-12-10 12:12:17' AND `col_blob` < 'because' failed: affected_rows mismatch between servers (1 vs. 0E0) # 2010-07-26T13:00:41 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'his' AND `col_set_key` < 'back' failed: affected_rows mismatch between servers (5 vs. 6) # 2010-07-26T13:00:42 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'I' AND `col_blob` < 'mnmzqeomhgvuexgyqtbqngkmupkksfxcyhvgdazbueuefxyjqcytnrtjlygorngnezcdxcmekjyjvajgyzxpukhsenojzfosqbtpszimznsxfelrlprsmijpgqlwrloryjxjoujnowflhlfqeevdqvijwkujgrcnsjptfviqtpadwfmwtcjmxgiknroixbcqar' failed: affected_rows mismatch between servers (6 vs. 7) # 2010-07-26T13:00:42 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob` > '2006-11-01 21:19:05' AND `col_blob` < 'just' failed: affected_rows mismatch between servers (1 vs. 0E0) # 2010-07-26T13:00:42 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 4 WHERE `pk` > 'xbxwkacwcyetcgurlcvgpfojidmiefcmztkntnwhbznvd' AND `col_blob` < 'fxbxwkacwcyetcgurlcvgpfojidmiefcmztkntnwhbznvddaqxbczstbaoruxzvewtefanhawhqaklqpnqfzihwtcxakuuwvxtxnzzuwfxyuxplvflyrifpfidrobgefcqctfdsrcjqfcbefuudsssxxmyykmplzsusndtgvhrvqccxxczpkoercnkmkeeshhpmdzzfsxobimcmjvqizrcnhiazdtkqpwh' failed: affected_rows mismatch between servers (2 vs. 1) # 2010-07-26T13:00:42 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob` > 3 AND `col_blob` < 'zqwuekftaylgqvhxvcodzfyocpzvcxmxeokldbfvpwjtnqlyabuysarnzmvhawcfgdoecusotpkwswptkigpcycionazkuqikzezpjxdcrfzwhtwtysbrfdrclrerviivzafksqgqicngfrwufcouwckhgylzdekwcjtdxtsxdijwvltnvwkawmmjumbahubzbskx' failed: affected_rows mismatch between servers (7 vs. 8) # 2010-07-26T13:00:42 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob` = 0 WHERE `pk` > 0 AND `col_blob` < 'rdxscnmktuvxxtbbrjmahevicyfbntxfhkuzrlsynwbvfnvyqsvsftdgxilaczcyhkiybwhvrhuzoadonlgmjrykisyihvwulahk' failed: affected_rows mismatch between servers (11 vs. 10) # 2010-07-26T13:00:42 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 5 WHERE `pk` > 6 AND `pk` < '2009-07-24 05:53:58' failed: affected_rows mismatch between servers (5 vs. 4) # 2010-07-26T13:00:42 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 9 AND `pk` < '2007-09-03 13:41:11' failed: affected_rows mismatch between servers (35 vs. 34) # 2010-07-26T13:00:43 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'kgomof' AND `col_set` < 'ykgomofatxxjyqnpmfugjezkujjvzqwnqdrwuifpizeqtnlqpbcutbkvlfublwhlffe' failed: affected_rows mismatch between servers (0E0 vs. 1) # 2010-07-26T13:00:43 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob_key` > 1 AND `col_blob_key` < 6 failed: affected_rows mismatch between servers (6 vs. 5) # 2010-07-26T13:00:43 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob` = 5 WHERE `pk` > 'bpuyjmocjmjncjhluvynnhlnbvcyzzxfbhbpikqwziczkfzogybtkjkpttdftjvpfgw' AND `col_set_key` < 'pbpuyjmocjmjncjhluvynnhlnbvcyzzxfbhbpikqwziczkfzogybtkjkpttdftjvpfgwdleinctcibsanrkxmtskurjkbrfthplegltfvvbmyihkjcrhcfjqsgroeyjvqheofvdcujkgvyanveuqlyhnkwizomgnqqxmctihkgrzvgoxwzoaoqfhjajxhchyeexglnxgoruczozuiawdckfqxatruutqby' failed: affected_rows mismatch between servers (9 vs. 10) # 2010-07-26T13:00:43 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob` > '2005-04-13 08:07:20' AND `col_set_key` < 'think' failed: affected_rows mismatch between servers (9 vs. 10) # 2010-07-26T13:00:43 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 4 WHERE `pk` > 'why' AND `col_set` < 'did' failed: affected_rows mismatch between servers (10 vs. 9) # 2010-07-26T13:00:43 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 2 AND `col_set_key` < 'tviefykgomofatxxjyqnpmfugjezkujjvzqwnqdrwuifpizeqtnlqpbcutbkvlfublwhl' failed: affected_rows mismatch between servers (12 vs. 11) # 2010-07-26T13:00:44 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set` > 0 AND `pk` < '2000-11-20 08:19:48' failed: affected_rows mismatch between servers (0E0 vs. 7) # 2010-07-26T13:00:44 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'my' AND `col_set` < 'get' failed: affected_rows mismatch between servers (8 vs. 1) # 2010-07-26T13:00:44 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob` = 6 WHERE `pk` > 'ehuymtyjejriwrhofbvxfxbxwkacwcyetcgurlcvgpfojidmiefcmztkntnwhbznvddaqxbczstbaoruxzvewtefanhawhqaklqpnqfzihwtcxakuuwvxtxnzzuwfxyuxplvflyrifpfidrobgefcqctfdsrcjqfcbefuudsssxxmyykmplzsusndtgvhrvqc' AND `col_set` < 'think' failed: affected_rows mismatch between servers (2 vs. 1) # 2010-07-26T13:00:44 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 0 WHERE `col_blob` > '2007-02-24 22:59:35' AND `col_blob` < 'fqqwdmvboxhlonkjszqwuekftaylgqvhxvcodzfyocpzvcxmxeokldbfvpwjtnqlyabuysarnzmvhawcfgdoecusotpkwswptkigpcycionazkuqikzezpjxdcrfzwhtwtysbrfdrclrerviivzafksqgqicngfrwufcouwckhgylzdekwcjtdxtsxdijwvltnvwkawmmju' failed: affected_rows mismatch between servers (7 vs. 6) # 2010-07-26T13:00:45 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 5 WHERE `pk` > 'for' AND `col_set_key` < 'the' failed: affected_rows mismatch between servers (12 vs. 11) # 2010-07-26T13:00:45 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'opompbzqfpfktpryniobsnzmfbswxicphwjvpemairgedwqeychtyqauxmqvyaddgjxbdlnbitffockgenukwwoyzqbjmbvoiwrvkzrfthvrehxjyzdebwzbkmifromaibjmjmubewrmlibbhm' AND `col_blob` < 'kopompbzqfpfktpryniobsnzmfbswxicphwjvpemairgedwqeychtyqauxmqvyaddgjxbdlnbitffockgenukwwoyzqbjmbvoiwrvkzrfthvrehxjyzdebwzbkmifromaibjmjmubewrmlibbhmaydbyjqkoepagaspeyaqpthywsggsdqrgiucufozmhyq' failed: affected_rows mismatch between servers (15 vs. 14) # 2010-07-26T13:00:45 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'jmuzyvjipdfhodkgvehatomvqwcevpyfqqlluiptwkjgsymizfddqciinbwuaiyufkigdebinqyggwaxmaoooqatnmfofyempvpmefpusoyvolkruvqmbjobwnojxkyhrycnospudlijdbzkpwecavarhqrszejtgfpbldsummxydcmjccgvgfbxphjbkofbibxisqzcshogkw' AND `col_set_key` < 'rjmuzyvjipdfhodkgvehatomvqwcevpyfqqlluiptwkjgsymizfddqciinbwuaiyufkigdebinqyggwaxmaoooqatnmfofyempvpmefpusoyvolkruvqmbjobwnojxkyhrycnospudlijdbzkpwecavarhqrszejtgfpbldsummxydcmjccgvgfbxphjbkofbibxisqzcshogkwraubnctcse' failed: affected_rows mismatch between servers (9 vs. 10) # 2010-07-26T13:00:45 Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_set_key` ) VALUES ( 2 ) failed: 2013 Lost connection to MySQL server during query # 2010-07-26T13:00:45 Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test # 2010-07-26T13:00:45 Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_set` ) VALUES ( 2 ) failed: 2013 Lost connection to MySQL server during query # 2010-07-26T13:00:45 Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test # 2010-07-26T13:00:45 Killing child process with pid 13611... # 2010-07-26T13:00:45 Killing child process with pid 13635... # 2010-07-26T13:00:45 Killing child process with pid 13614... # 2010-07-26T13:00:45 Killing child process with pid 13616... # 2010-07-26T13:00:45 Killing child process with pid 13631... # 2010-07-26T13:00:45 Killing child process with pid 13623... # 2010-07-26T13:00:45 Killing child process with pid 13626... # 2010-07-26T13:00:45 Killing child process with pid 13629... # 2010-07-26T13:00:45 Killing child process with pid 13619... # 2010-07-26T13:00:46 Killing periodic reporting process with pid 13607... # 2010-07-26T13:00:46 Kill GenTest::ErrorFilter(13606) # 2010-07-26T13:00:46 Server crash reported, initiating post-crash analysis... # 2010-07-26T13:00:46 The last 100 lines from /randgen/new_testing/5/51.log : 2010-07-26T13:00:44 [13616] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob_key` > 9 AND `col_set_key` < 'kkgwpndqhtjwfypekeedsquftjtbisdxukzedzvyqkhjdchtmmprlswsigdipulrcbpmhwkkhpglmmkdrzuodbbjsbexbzhybdtdghnhqyfesojlzybundaegjjkraxeqetxtvgoypekqdkfkeddfvkpdqmmebncpxqexsoqywbnblqtvxfddxkxcknron' 2010-07-26T13:00:44 [13616] Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob` = 7 WHERE `col_blob_key` > '2003-09-03 07:19:13' AND `col_set_key` < 'skkgwpndqhtjwfypekeedsquftjtbisdxukzedzvyqkhjdchtmmprlswsigdipulrcbpmhwkkhpglmmkdrzuodbbjsbexbzhybdtdghnhqyfesojlzybundaegjjkraxeqetxtvgoypekq' 2010-07-26T13:00:44 [13616] Query: UPDATE `table100_innodb_int_autoinc` SET `pk` = 6 WHERE `col_set_key` > 'cskkgwpndqhtjwfypekeedsquftjtbisdxukzedzvyqkhjdchtmmprlswsigdipulrcbpmhwkkhpglmmkdrzuodbbjsbexbzhybdtdghnhqyfesojlzybundaegjjkraxeqetxtvgoypekqdkfkeddfvkpdqmmebncpxqexsoqywbnb' AND `col_blob` < NULL 2010-07-26T13:00:44 [13616] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set` > 'go' AND `col_blob` < NULL 2010-07-26T13:00:44 [13616] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 0 WHERE `col_blob` > NULL AND `pk` < 'how' 2010-07-26T13:00:44 [13616] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set` > 5 AND `col_set_key` < 9 2010-07-26T13:00:44 [13616] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 2 WHERE `col_blob` > '2000-11-15 00:07:51' AND `pk` < 0 2010-07-26T13:00:44 [13616] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob_key` > 'look' AND `col_set` < NULL 2010-07-26T13:00:44 [13616] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set` > 'something' AND `col_blob` < '2005-03-03 22:36:43' 2010-07-26T13:00:44 [13616] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set` = 0 WHERE `pk` > '2001-01-11 19:11:04' AND `col_blob` < NULL 2010-07-26T13:00:44 [13629] Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob` = 6 WHERE `pk` > 'ehuymtyjejriwrhofbvxfxbxwkacwcyetcgurlcvgpfojidmiefcmztkntnwhbznvddaqxbczstbaoruxzvewtefanhawhqaklqpnqfzihwtcxakuuwvxtxnzzuwfxyuxplvflyrifpfidrobgefcqctfdsrcjqfcbefuudsssxxmyykmplzsusndtgvhrvqc' AND `col_set` < 'think' 2010-07-26T13:00:44 [13608] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_set` ) VALUES ( 3 ) 2010-07-26T13:00:44 [13629] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 6 WHERE `col_set_key` > 'tehuymtyjejriwrhofbvxfxbxwkacwcyetcgurlcvgpfojidmiefcmztkn' AND `col_set` < '2007-10-17 14:03:09' 2010-07-26T13:00:44 [13635] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_blob_key` ) VALUES ( 1 ) 2010-07-26T13:00:44 [13631] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 0 WHERE `col_blob` > '2007-02-24 22:59:35' AND `col_blob` < 'fqqwdmvboxhlonkjszqwuekftaylgqvhxvcodzfyocpzvcxmxeokldbfvpwjtnqlyabuysarnzmvhawcfgdoecusotpkwswptkigpcycionazkuqikzezpjxdcrfzwhtwtysbrfdrclrerviivzafksqgqicngfrwufcouwckhgylzdekwcjtdxtsxdijwvltnvwkawmmju' 2010-07-26T13:00:44 [13626] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_blob` ) VALUES ( 4 ) 2010-07-26T13:00:44 [13626] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set` > NULL AND `col_blob` < '2002-09-16 00:34:33' 2010-07-26T13:00:44 [13623] Query: INSERT INTO `table100_innodb_int_autoinc` ( `pk` ) VALUES ( 4 ) 2010-07-26T13:00:45 [13619] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_set` ) VALUES ( 2 ) 2010-07-26T13:00:45 [13611] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_blob` ) VALUES ( 3 ) 2010-07-26T13:00:45 [13619] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 1 WHERE `col_set_key` > 9 AND `pk` < 'he' 2010-07-26T13:00:45 [13611] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set` = 5 WHERE `col_set_key` > 'then' AND `col_blob_key` < '2004-01-08 11:30:23' 2010-07-26T13:00:45 [13619] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > 3 AND `col_blob` < NULL 2010-07-26T13:00:45 [13619] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > '2008-04-16 21:41:39' AND `col_set` < NULL 2010-07-26T13:00:45 [13619] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob` > '2001-02-17 17:07:01' AND `col_blob_key` < 'him' 2010-07-26T13:00:45 [13619] Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 7 WHERE `pk` > 9 AND `col_blob` < 0 2010-07-26T13:00:45 [13614] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_set_key` ) VALUES ( 1 ) 2010-07-26T13:00:45 [13616] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_blob` ) VALUES ( 2 ) 2010-07-26T13:00:45 [13614] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob_key` > 'I' AND `pk` < 'who' 2010-07-26T13:00:45 [13616] Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 3 WHERE `col_blob_key` > '2007-12-24 14:52:58' AND `col_blob` < NULL 2010-07-26T13:00:45 [13614] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > '2002-01-28 06:52:00' AND `pk` < 'inygxzhtjqdfhrzpbkjyfrdxscnmktuvxxtbbrjmahevicyfbntxfhkuzrlsynwbvfnvyqsvsftdgxilaczcyhkiybwhvrhuzoa' 2010-07-26T13:00:45 [13614] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > 7 AND `col_set_key` < '2005-05-27 00:41:34' 2010-07-26T13:00:45 [13614] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set` > 7 AND `col_blob_key` < 'up' 2010-07-26T13:00:45 [13614] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set` = 7 WHERE `col_blob` > '2008-01-07 20:01:16' AND `pk` < 'hey' 2010-07-26T13:00:45 [13629] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_set` ) VALUES ( 3 ) 2010-07-26T13:00:45 [13608] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 5 WHERE `pk` > 'for' AND `col_set_key` < 'the' 2010-07-26T13:00:45 [13629] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 9 AND `pk` < 8 2010-07-26T13:00:45 [13635] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'opompbzqfpfktpryniobsnzmfbswxicphwjvpemairgedwqeychtyqauxmqvyaddgjxbdlnbitffockgenukwwoyzqbjmbvoiwrvkzrfthvrehxjyzdebwzbkmifromaibjmjmubewrmlibbhm' AND `col_blob` < 'kopompbzqfpfktpryniobsnzmfbswxicphwjvpemairgedwqeychtyqauxmqvyaddgjxbdlnbitffockgenukwwoyzqbjmbvoiwrvkzrfthvrehxjyzdebwzbkmifromaibjmjmubewrmlibbhmaydbyjqkoepagaspeyaqpthywsggsdqrgiucufozmhyq' 2010-07-26T13:00:45 [13631] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_blob` ) VALUES ( 1 ) 2010-07-26T13:00:45 [13623] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_blob` ) VALUES ( 9 ) 2010-07-26T13:00:45 [13626] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_blob` ) VALUES ( 1 ) 2010-07-26T13:00:45 [13611] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_set` ) VALUES ( 0 ) 2010-07-26T13:00:45 [13619] Query: INSERT INTO `table100_innodb_int_autoinc` ( `pk` ) VALUES ( 0 ) 2010-07-26T13:00:45 [13611] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > 'no' AND `col_set_key` < 'with' 2010-07-26T13:00:45 [13611] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set` = 9 WHERE `col_blob_key` > 'pmqjkudisfstviefykgomofatxxjyqnpmfugjezkujjvzqwnqdrwuifpizeqtnlqpbcutbkvlfublwhlffeumbrqrxxwdtrslpkmcnclsjopedydwvtjmkgagunlclzyzc' AND `pk` < 'who' 2010-07-26T13:00:45 [13611] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 8 WHERE `col_set_key` > '2008-02-19 16:36:07' AND `col_set_key` < '2000-03-27 16:21:30' 2010-07-26T13:00:45 [13611] Query: UPDATE `table100_innodb_int_autoinc` SET `pk` = 2 WHERE `col_set` > 7 AND `pk` < '2001-09-10 22:22:11' 2010-07-26T13:00:45 [13611] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set` > 'xpmqjkudisfstviefykgomofatxxjyqnpmfugjezkujjvzqwnqdrwuifpizeqtnlqpbcutbkvlfublwhlffeumbrqrxxwdtrslpkmcnclsjopedydwvtjmkgagunlclzyzcxlahuicttjvxwpvivzonlkfhrstdlifzauiugqosfzvothecgzmaabuwavfosacxgrgcaithzxtpmrknwuiexjmvokbcvmnftohxbzwcagvhab' AND `col_blob` < 'gxpmqjkudisfstviefykgomofatxxjyqnpmfugjezkujjvzqwnqdrwuifpizeqtnlqpbcutbkvlfublwhlffeumbrqrxxwdtrslpkmcnclsjopedydwvtjmkgagunlclzyzcxlahuicttjvxwpvivzonlkfhrstdlifzauiugqosfzvothecgzmaabuwavfosacxgrgcaithzxtpmrknwui' 2010-07-26T13:00:45 [13611] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob` > 'her' AND `pk` < 4 2010-07-26T13:00:45 [13611] Query: UPDATE `table100_innodb_int_autoinc` SET `pk` = 4 WHERE `col_blob` > 'mgxpmqjkudisfstviefykgomofatxxjyqnpmfugjezkujjvzqwnqdrwuifpizeqtnlqpbcutbkvlfublwhlffeumbrqrxxwdtrslpkmcnclsjopedydwvtjmkgagunlclzyzcxlahuicttjvxwpvivzonlkfhrstdlifzauiugqosfzvothecgzmaabuwavfosacxgrgcaithzxtpm' AND `col_blob_key` < 5 2010-07-26T13:00:45 [13614] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_blob` ) VALUES ( 8 ) 2010-07-26T13:00:45 [13614] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set` = 1 WHERE `pk` > NULL AND `col_blob` < NULL 2010-07-26T13:00:45 [13616] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_blob_key` ) VALUES ( 4 ) 2010-07-26T13:00:45 [13614] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob` > 4 AND `col_blob_key` < '2002-01-17 12:52:00' 2010-07-26T13:00:45 [13616] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set` = 7 WHERE `col_set` > '2001-07-21 18:50:20' AND `col_set_key` < 'rcskkgwpndqhtjwfypekeedsquftjtbisdxukzedzvyqkhjdchtmmprl' 2010-07-26T13:00:45 [13608] Query: INSERT INTO `table100_innodb_int_autoinc` ( `pk` ) VALUES ( 8 ) 2010-07-26T13:00:45 [13629] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_blob_key` ) VALUES ( 7 ) 2010-07-26T13:00:45 [13635] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 7 WHERE `col_blob_key` > 5 AND `col_blob_key` < 'are' 2010-07-26T13:00:45 [13626] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_set_key` ) VALUES ( 7 ) 2010-07-26T13:00:45 [13629] Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob` = 6 WHERE `pk` > 2 AND `col_blob_key` < NULL 2010-07-26T13:00:45 [13635] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 1 WHERE `col_blob_key` > 'but' AND `pk` < 'no' 2010-07-26T13:00:45 [13631] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_blob` ) VALUES ( 3 ) 2010-07-26T13:00:45 [13635] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 4 WHERE `col_set_key` > 'a' AND `col_set` < '2007-10-21 04:54:17' 2010-07-26T13:00:45 [13635] Query: UPDATE `table100_innodb_int_autoinc` SET `pk` = 5 WHERE `col_set` > '2006-05-21 18:52:31' AND `col_set` < '2009-12-18 18:51:53' 2010-07-26T13:00:45 [13623] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'jmuzyvjipdfhodkgvehatomvqwcevpyfqqlluiptwkjgsymizfddqciinbwuaiyufkigdebinqyggwaxmaoooqatnmfofyempvpmefpusoyvolkruvqmbjobwnojxkyhrycnospudlijdbzkpwecavarhqrszejtgfpbldsummxydcmjccgvgfbxphjbkofbibxisqzcshogkw' AND `col_set_key` < 'rjmuzyvjipdfhodkgvehatomvqwcevpyfqqlluiptwkjgsymizfddqciinbwuaiyufkigdebinqyggwaxmaoooqatnmfofyempvpmefpusoyvolkruvqmbjobwnojxkyhrycnospudlijdbzkpwecavarhqrszejtgfpbldsummxydcmjccgvgfbxphjbkofbibxisqzcshogkwraubnctcse' 2010-07-26T13:00:45 [13623] Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 7 WHERE `col_blob` > 6 AND `col_set` < 5 2010-07-26T13:00:45 [13623] Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob` = 5 WHERE `col_blob_key` > '2008-02-23 21:25:05' AND `col_set_key` < 'wrjmuzyvjipdfhodkgvehatomvqwcevpyfqqlluiptwkjgsymizfddqciinbwuaiyufkigdebinqyggwaxmaoooqatnmfofyempvpmefpusoyvolkruvqmbjobwnojxkyhrycnospu' 2010-07-26T13:00:45 [13623] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > NULL AND `pk` < '2008-06-13 09:53:47' 2010-07-26T13:00:45 [13623] Query: INSERT INTO `table100_innodb_int_autoinc` ( `pk` ) VALUES ( 1 ) 2010-07-26T13:00:45 [13619] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_set` ) VALUES ( 0 ) 2010-07-26T13:00:45 [13611] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_set_key` ) VALUES ( 1 ) 2010-07-26T13:00:45 [13611] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > NULL AND `col_set_key` < '2005-02-19 19:29:37' 2010-07-26T13:00:45 [13619] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 2 WHERE `col_set` > 'but' AND `col_set_key` < 'aeeakocabmnmzqeomhgvuexgyqtbqngkmupkksfxcyhvgdazbueuefxy' 2010-07-26T13:00:45 [13611] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob` > "it's" AND `col_blob_key` < 3 2010-07-26T13:00:45 [13619] Query: INSERT INTO `table100_innodb_int_autoinc` ( `pk` ) VALUES ( 3 ) 2010-07-26T13:00:45 [13611] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob` > 'did' AND `col_blob_key` < 'rmgxpmqjkudisfstviefykgomofatxxjyqnpmfugjezkujjvzqwnqdrwuifpizeqtnlqpbcutbkvlfublwhlffeumbrqrxxwdtrslpkmcnclsjopedydwvtjmkg' 2010-07-26T13:00:45 [13608] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_blob` ) VALUES ( 1 ) 2010-07-26T13:00:45 [13614] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_set_key` ) VALUES ( 6 ) 2010-07-26T13:00:45 [13616] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_blob` ) VALUES ( 8 ) 2010-07-26T13:00:45 [13614] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > '2000-10-03 00:23:36' AND `col_set` < '2008-10-02 02:26:26' 2010-07-26T13:00:45 [13614] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob` > 9 AND `col_blob` < 'yinygxzhtjqdfhrzpbkjyfrdxscnmktuvxxtbbrjmahevicyfbntxfhkuzrlsynwbvfnvyqsvsftdgxilaczcyhkiybwhvrhuzoadonlgmjrykisyihvwulahkpzkabljyehqznlnceuvpyltpcvtclgbwfdskeqfdyjihzupcijsfuwreplqhknjtrsxgxcfpvqxoswelsdsmnlpklvlxffehuxadbnfaoqjmpagvkejyhmmnw' 2010-07-26T13:00:45 [13629] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 6 WHERE `col_blob` > 5 AND `pk` < '2008-09-25 22:46:09' 2010-07-26T13:00:45 [13626] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_blob_key` ) VALUES ( 3 ) 2010-07-26T13:00:45 [13635] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_set` ) VALUES ( 5 ) 2010-07-26T13:00:45 [13629] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 5 WHERE `col_blob_key` > NULL AND `col_set` < '2003-07-26 16:39:32' 2010-07-26T13:00:45 [13635] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set` > 2 AND `col_blob` < 3 2010-07-26T13:00:45 [13629] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > 'ptehuymtyjejriwrhofbvxfxbxwkacwcyetcgurlcvgpfojidmiefcmztkntnwhbznvddaqxbczstbaoruxzvewtefanhawhqa' AND `col_set` < NULL 2010-07-26T13:00:45 [13635] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob` > 'will' AND `col_blob` < NULL 2010-07-26T13:00:45 [13635] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set` > 4 AND `col_set` < NULL 2010-07-26T13:00:45 [13631] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_set` ) VALUES ( 9 ) 2010-07-26T13:00:45 [13626] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob_key` > 'it' AND `col_set` < 7 2010-07-26T13:00:45 [13631] Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob` = 5 WHERE `col_blob_key` > 'hfqqwdmvboxhlonkjszqwuekftaylgqvhxvcodzfyocpzvcxmxeokldbfvpwjtnqlyabuysarnzm' AND `col_set_key` < 'time' 2010-07-26T13:00:45 [13616] Query: UPDATE `table100_innodb_int_autoinc` SET `pk` = 4 WHERE `col_set` > 1 AND `pk` < '2005-01-03 18:04:45' 2010-07-26T13:00:45 [13623] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_set` ) VALUES ( 7 ) 2010-07-26T13:00:45 [13623] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > '2005-02-22 12:03:38' AND `col_set_key` < NULL 2010-07-26T13:00:45 [13623] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set` = 7 WHERE `col_set` > 'at' AND `col_set` < NULL 2010-07-26T13:00:45 [13623] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 3 WHERE `col_blob_key` > 3 AND `col_blob_key` < NULL 2010-07-26T13:00:45 [13616] Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 8 WHERE `col_blob` > 'time' AND `col_blob` < NULL 2010-07-26T13:00:45 [13608] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_set_key` ) VALUES ( 2 ) 2010-07-26T13:00:45 [13611] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_set` ) VALUES ( 2 ) # 2010-07-26T13:00:46 datadir is /tmp/51//master-data/ # 2010-07-26T13:00:46 binary is /mysql/mysql-5.1.49-linux-i686-glibc23//bin/mysqld # 2010-07-26T13:00:46 bindir is /mysql/mysql-5.1.49-linux-i686-glibc23//bin # 2010-07-26T13:00:46 core is # 2010-07-26T13:00:47 # 2010-07-26T13:00:47 # 2010-07-26T13:00:47 The last 100 lines from /randgen/new_testing/5/52.log : [0xb780f400] /lib/tls/i686/cmov/libc.so.6(abort+0x188)[0xb7638098] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6c45b8c] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6c24e87] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6c251af] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6c1c6dd] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6c08d05] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6c0ebdd] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6cb915d] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6cb98dd] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6ca311a] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6cd6073] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6ccd2bd] /lib/tls/i686/cmov/libpthread.so.0[0xb77ea4ff] /lib/tls/i686/cmov/libc.so.6(clone+0x5e)[0xb76ef5ee] 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 100726 6:00:32 [Note] Plugin 'FEDERATED' is disabled. InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use GCC atomic builtins InnoDB: Compressed tables use zlib 1.2.3 InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 100726 6:00:33 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 100726 6:00:33 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 100726 6:00:33 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 100726 6:00:33 InnoDB Plugin 1.0.10 started; log sequence number 0 100726 6:00:33 [Warning] /mysql/mysql-5.1.49-linux-i686-glibc23/bin/mysqld: unknown option '--loose-skip-ndbcluster' 100726 6:00:33 [Warning] /mysql/mysql-5.1.49-linux-i686-glibc23/bin/mysqld: unknown variable 'loose-falcon-debug-mask=2' 100726 6:00:33 [Note] Event Scheduler: Loaded 0 events 100726 6:00:33 [Note] /mysql/mysql-5.1.49-linux-i686-glibc23/bin/mysqld: ready for connections. Version: '5.1.49-log' socket: '/tmp/52//tmp/master.sock' port: 19302 MySQL Community Server (GPL) InnoDB: Error: trying to access page number 18676607 in space 0, InnoDB: space name ./ibdata1, InnoDB: which is outside the tablespace bounds. InnoDB: Byte offset 0, len 16384, i/o type 10. InnoDB: If you get this error at mysqld startup, please check that InnoDB: your my.cnf matches the ibdata files that you have in the InnoDB: MySQL server. 100726 6:00:45 InnoDB: Assertion failure in thread 2815015824 in file fil/fil0fil.c line 4306 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.1/en/forcing-recovery.html InnoDB: about forcing recovery. 100726 6:00:45 - 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. 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. key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=10 max_threads=151 threads_connected=10 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 59978 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0x0 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 = (nil) thread_stack 0x30000 /mysql/mysql-5.1.49-linux-i686-glibc23/bin/mysqld(my_print_stacktrace+0x21)[0x84e3741] /mysql/mysql-5.1.49-linux-i686-glibc23/bin/mysqld(handle_segfault+0x381)[0x8206631] [0xb786f400] /lib/tls/i686/cmov/libc.so.6(abort+0x188)[0xb7698098] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6ca5b8c] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6c84e87] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6c851af] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6c7c6dd] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6c68d05] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6c6ebdd] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6d1915d] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6d198dd] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6d0311a] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6d36073] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6d2d2bd] /lib/tls/i686/cmov/libpthread.so.0[0xb784a4ff] /lib/tls/i686/cmov/libc.so.6(clone+0x5e)[0xb774f5ee] 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 # 2010-07-26T13:00:47 datadir is /tmp/52//master-data/ # 2010-07-26T13:00:47 binary is /mysql/mysql-5.1.49-linux-i686-glibc23//bin/mysqld # 2010-07-26T13:00:47 bindir is /mysql/mysql-5.1.49-linux-i686-glibc23//bin # 2010-07-26T13:00:47 core is /tmp/52//master-data//core # 2010-07-26T13:00:48 Core was generated by `/mysql/mysql-5.1.49-linux-i686-glibc23/bin/mysqld --no-defaults --basedir=/mysq'. # 2010-07-26T13:00:48 Program terminated with signal 6, Aborted. # 2010-07-26T13:00:48 [New process 13594] # 2010-07-26T13:00:48 [New process 13593] # 2010-07-26T13:00:48 [New process 13595] # 2010-07-26T13:00:48 [New process 13579] # 2010-07-26T13:00:48 [New process 13582] # 2010-07-26T13:00:48 [New process 13592] # 2010-07-26T13:00:48 [New process 13584] # 2010-07-26T13:00:48 [New process 13625] # 2010-07-26T13:00:48 [New process 13628] # 2010-07-26T13:00:48 [New process 13586] # 2010-07-26T13:00:48 [New process 13634] # 2010-07-26T13:00:48 [New process 13587] # 2010-07-26T13:00:48 [New process 13581] # 2010-07-26T13:00:48 [New process 13589] # 2010-07-26T13:00:48 [New process 13583] # 2010-07-26T13:00:48 [New process 13591] # 2010-07-26T13:00:48 [New process 13610] # 2010-07-26T13:00:48 [New process 13637] # 2010-07-26T13:00:48 [New process 13585] # 2010-07-26T13:00:48 [New process 13588] # 2010-07-26T13:00:48 [New process 13590] # 2010-07-26T13:00:48 [New process 13622] # 2010-07-26T13:00:48 [New process 13633] # 2010-07-26T13:00:48 [New process 13617] # 2010-07-26T13:00:48 [New process 13620] # 2010-07-26T13:00:48 [New process 13613] # 2010-07-26T13:00:48 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:48 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:48 #1 0xb784f1c8 in pthread_kill () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:48 #2 0x084e370b in my_write_core (sig=6) at stacktrace.c:329 # 2010-07-26T13:00:48 #3 0x08206670 in handle_segfault (sig=6) at mysqld.cc:2605 # 2010-07-26T13:00:48 #4 # 2010-07-26T13:00:48 #5 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:48 #6 0xb76966d0 in raise () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:48 #7 0xb7698098 in abort () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:48 #8 0xb6ca5b8c in fil_io (type=10, sync=1, space_id=0, zip_size=0, block_offset=18676607, byte_offset=0, len=16384, buf=0xaf1b8000, message=0xae9936e0) at fil/fil0fil.c:4306 # 2010-07-26T13:00:48 #9 0xb6c84e87 in buf_read_page_low (err=0xa7c9a618, sync=1, mode=132, space=0, zip_size=0, unzip=0, tablespace_version=1, offset=18677759) at buf/buf0rea.c:145 # 2010-07-26T13:00:48 #10 0xb6c851af in buf_read_page (space=0, zip_size=0, offset=18677759) at buf/buf0rea.c:183 # 2010-07-26T13:00:48 #11 0xb6c7c6dd in buf_page_get_gen (space=0, zip_size=0, offset=18677759, rw_latch=2, guess=0x0, mode=10, file=0xb6d50779 "btr/btr0cur.c", line=4313, mtr=0xa7c9a6f8) # 2010-07-26T13:00:48 at buf/buf0buf.c:2095 # 2010-07-26T13:00:48 #12 0xb6c68d05 in btr_free_externally_stored_field (index=0xa120ab8, field_ref=0xaee6913c "", rec=0xaee68e27 "\200", offsets=0xa730a388, page_zip=0x0, i=4, rb_ctx=RB_NONE, # 2010-07-26T13:00:48 local_mtr=0xa7c9ac24) at btr/btr0cur.c:4312 # 2010-07-26T13:00:48 #13 0xb6c6ebdd in btr_cur_pessimistic_delete (err=0xa7c9b20c, has_reserved_extents=0, cursor=0xa0bdcd0, rb_ctx=RB_NONE, mtr=0xa7c9ac24) at btr/btr0cur.c:4414 # 2010-07-26T13:00:48 #14 0xb6d1915d in row_purge_remove_clust_if_poss_low (node=0xa0bdc90, mode=33) at row/row0purge.c:175 # 2010-07-26T13:00:48 #15 0xb6d198dd in row_purge_step (thr=0xa0bdc30) at row/row0purge.c:212 # 2010-07-26T13:00:48 #16 0xb6d0311a in que_run_threads (thr=0xa0bdc30) at que/que0que.c:1248 # 2010-07-26T13:00:48 #17 0xb6d36073 in trx_purge () at trx/trx0purge.c:1177 # 2010-07-26T13:00:48 #18 0xb6d2d2bd in srv_master_thread (arg=0x0) at srv/srv0srv.c:2601 # 2010-07-26T13:00:48 #19 0xb784a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:48 #20 0xb774f5ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:48 #5 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:48 in mysqld.cc # 2010-07-26T13:00:49 Core was generated by `/mysql/mysql-5.1.49-linux-i686-glibc23/bin/mysqld --no-defaults --basedir=/mysq'. # 2010-07-26T13:00:49 Program terminated with signal 6, Aborted. # 2010-07-26T13:00:49 [New process 13594] # 2010-07-26T13:00:49 [New process 13593] # 2010-07-26T13:00:49 [New process 13595] # 2010-07-26T13:00:49 [New process 13579] # 2010-07-26T13:00:49 [New process 13582] # 2010-07-26T13:00:49 [New process 13592] # 2010-07-26T13:00:49 [New process 13584] # 2010-07-26T13:00:49 [New process 13625] # 2010-07-26T13:00:49 [New process 13628] # 2010-07-26T13:00:49 [New process 13586] # 2010-07-26T13:00:49 [New process 13634] # 2010-07-26T13:00:49 [New process 13587] # 2010-07-26T13:00:49 [New process 13581] # 2010-07-26T13:00:49 [New process 13589] # 2010-07-26T13:00:49 [New process 13583] # 2010-07-26T13:00:49 [New process 13591] # 2010-07-26T13:00:49 [New process 13610] # 2010-07-26T13:00:49 [New process 13637] # 2010-07-26T13:00:49 [New process 13585] # 2010-07-26T13:00:49 [New process 13588] # 2010-07-26T13:00:49 [New process 13590] # 2010-07-26T13:00:49 [New process 13622] # 2010-07-26T13:00:49 [New process 13633] # 2010-07-26T13:00:49 [New process 13617] # 2010-07-26T13:00:49 [New process 13620] # 2010-07-26T13:00:49 [New process 13613] # 2010-07-26T13:00:49 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:49 # 2010-07-26T13:00:49 Thread 26 (process 13613): # 2010-07-26T13:00:49 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:49 #1 0xb785170f in fsync () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #2 0xb6ce1fbb in os_file_flush (file=8) at os/os0file.c:1933 # 2010-07-26T13:00:49 #3 0xb6c9f92f in fil_flush (space_id=4294967280) at fil/fil0fil.c:4550 # 2010-07-26T13:00:49 #4 0xb6cd648c in log_write_up_to (lsn=4147866, wait=92, flush_to_disk=1) at log/log0log.c:1496 # 2010-07-26T13:00:49 #5 0xb6d42ac5 in trx_commit_complete_for_mysql (trx=0xa181570) at trx/trx0trx.c:1601 # 2010-07-26T13:00:49 #6 0xb6cb9065 in innobase_commit (hton=0x9ae2c38, thd=0xa171ef0, all=false) at handler/ha_innodb.cc:2531 # 2010-07-26T13:00:49 #7 0x082fe2ee in ha_commit_trans (thd=0xa171ef0, all=false) at handler.cc:1233 # 2010-07-26T13:00:49 #8 0x082fe680 in ha_autocommit_or_rollback (thd=0xa171ef0, error=0) at handler.cc:1367 # 2010-07-26T13:00:49 #9 0x0821e27d in dispatch_command (command=COM_QUERY, thd=0xa171ef0, packet=0xa173ec1 "INSERT INTO `table100_innodb_int_autoinc` ( `col_set` ) VALUES ( 2 )", packet_length=68) # 2010-07-26T13:00:49 at sql_parse.cc:1657 # 2010-07-26T13:00:49 #10 0x0821fc60 in do_command (thd=0xa171ef0) at sql_parse.cc:882 # 2010-07-26T13:00:49 #11 0x082101e3 in handle_one_connection (arg=0xa171ef0) at sql_connect.cc:1136 # 2010-07-26T13:00:49 #12 0xb784a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #13 0xb774f5ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 # 2010-07-26T13:00:49 Thread 25 (process 13620): # 2010-07-26T13:00:49 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:49 #1 0xb78510fb in read () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #2 0x081fab3f in my_real_read (net=0xa191658, complen=0xa72ce328) at net_serv.cc:816 # 2010-07-26T13:00:49 #3 0x081fb122 in my_net_read (net=0xa191658) at net_serv.cc:1011 # 2010-07-26T13:00:49 #4 0x0821fbeb in do_command (thd=0xa1915e0) at sql_parse.cc:824 # 2010-07-26T13:00:49 #5 0x082101e3 in handle_one_connection (arg=0xa1915e0) at sql_connect.cc:1136 # 2010-07-26T13:00:49 #6 0xb784a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #7 0xb774f5ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 # 2010-07-26T13:00:49 Thread 24 (process 13617): # 2010-07-26T13:00:49 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:49 #1 0xb784e0e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #2 0xb6ce63b5 in os_event_wait_low (event=0xa0b9128, reset_sig_count=0) at os/os0sync.c:399 # 2010-07-26T13:00:49 #3 0xb6d42ac5 in trx_commit_complete_for_mysql (trx=0xa14b268) at trx/trx0trx.c:1601 # 2010-07-26T13:00:49 #4 0xb6cb9065 in innobase_commit (hton=0x9ae2c38, thd=0xa185bf0, all=false) at handler/ha_innodb.cc:2531 # 2010-07-26T13:00:49 #5 0x082fe2ee in ha_commit_trans (thd=0xa185bf0, all=false) at handler.cc:1233 # 2010-07-26T13:00:49 #6 0x082fe680 in ha_autocommit_or_rollback (thd=0xa185bf0, error=0) at handler.cc:1367 # 2010-07-26T13:00:49 #7 0x0821e27d in dispatch_command (command=COM_QUERY, thd=0xa185bf0, packet=0xa1875a9 "INSERT INTO `table100_innodb_int_autoinc` ( `col_set_key` ) VALUES ( 4 )", # 2010-07-26T13:00:49 packet_length=72) at sql_parse.cc:1657 # 2010-07-26T13:00:49 #8 0x0821fc60 in do_command (thd=0xa185bf0) at sql_parse.cc:882 # 2010-07-26T13:00:49 #9 0x082101e3 in handle_one_connection (arg=0xa185bf0) at sql_connect.cc:1136 # 2010-07-26T13:00:49 #10 0xb784a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #11 0xb774f5ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 # 2010-07-26T13:00:49 Thread 23 (process 13633): # 2010-07-26T13:00:49 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:49 #1 0xb78510fb in read () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #2 0x081fab3f in my_real_read (net=0xa15f228, complen=0xa720a328) at net_serv.cc:816 # 2010-07-26T13:00:49 #3 0x081fb122 in my_net_read (net=0xa15f228) at net_serv.cc:1011 # 2010-07-26T13:00:49 #4 0x0821fbeb in do_command (thd=0xa15f1b0) at sql_parse.cc:824 # 2010-07-26T13:00:49 #5 0x082101e3 in handle_one_connection (arg=0xa15f1b0) at sql_connect.cc:1136 # 2010-07-26T13:00:49 #6 0xb784a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #7 0xb774f5ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 # 2010-07-26T13:00:49 Thread 22 (process 13622): # 2010-07-26T13:00:49 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:49 #1 0xb784e0e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #2 0xb6ce63b5 in os_event_wait_low (event=0xa0b9128, reset_sig_count=0) at os/os0sync.c:399 # 2010-07-26T13:00:49 #3 0xb6d42ac5 in trx_commit_complete_for_mysql (trx=0xa1808e0) at trx/trx0trx.c:1601 # 2010-07-26T13:00:49 #4 0xb6cb9065 in innobase_commit (hton=0x9ae2c38, thd=0xa14ccf0, all=false) at handler/ha_innodb.cc:2531 # 2010-07-26T13:00:49 #5 0x082fe2ee in ha_commit_trans (thd=0xa14ccf0, all=false) at handler.cc:1233 # 2010-07-26T13:00:49 #6 0x082fe680 in ha_autocommit_or_rollback (thd=0xa14ccf0, error=0) at handler.cc:1367 # 2010-07-26T13:00:49 #7 0x0821e27d in dispatch_command (command=COM_QUERY, thd=0xa14ccf0, # 2010-07-26T13:00:49 packet=0xa14e6a9 "DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set` > '2005-12-25 19:15:37' AND `pk` < '2002-05-14 03:34:28'", packet_length=114) # 2010-07-26T13:00:49 at sql_parse.cc:1657 # 2010-07-26T13:00:49 #8 0x0821fc60 in do_command (thd=0xa14ccf0) at sql_parse.cc:882 # 2010-07-26T13:00:49 #9 0x082101e3 in handle_one_connection (arg=0xa14ccf0) at sql_connect.cc:1136 # 2010-07-26T13:00:49 #10 0xb784a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #11 0xb774f5ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 # 2010-07-26T13:00:49 Thread 21 (process 13590): # 2010-07-26T13:00:49 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:49 #1 0xb784e0e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #2 0xb6ce63b5 in os_event_wait_low (event=0x9e1b558, reset_sig_count=0) at os/os0sync.c:399 # 2010-07-26T13:00:49 #3 0xb6ce3e48 in os_aio_simulated_handle (global_segment=9, message1=0xa9f2d38c, message2=0xa9f2d388, type=0xa9f2d384) at os/os0file.c:4199 # 2010-07-26T13:00:49 #4 0xb6c9f385 in fil_aio_wait (segment=9) at fil/fil0fil.c:4439 # 2010-07-26T13:00:49 #5 0xb6d30668 in io_handler_thread (arg=0xb6d74384) at srv/srv0start.c:475 # 2010-07-26T13:00:49 #6 0xb784a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #7 0xb774f5ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 # 2010-07-26T13:00:49 Thread 20 (process 13588): # 2010-07-26T13:00:49 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:49 #1 0xb784e0e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #2 0xb6ce63b5 in os_event_wait_low (event=0x9e1b488, reset_sig_count=0) at os/os0sync.c:399 # 2010-07-26T13:00:49 #3 0xb6ce3e48 in os_aio_simulated_handle (global_segment=7, message1=0xaaf2f38c, message2=0xaaf2f388, type=0xaaf2f384) at os/os0file.c:4199 # 2010-07-26T13:00:49 #4 0xb6c9f385 in fil_aio_wait (segment=7) at fil/fil0fil.c:4439 # 2010-07-26T13:00:49 #5 0xb6d30668 in io_handler_thread (arg=0xb6d7437c) at srv/srv0start.c:475 # 2010-07-26T13:00:49 #6 0xb784a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #7 0xb774f5ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 # 2010-07-26T13:00:49 Thread 19 (process 13585): # 2010-07-26T13:00:49 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:49 #1 0xb784e0e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #2 0xb6ce63b5 in os_event_wait_low (event=0x9e1b350, reset_sig_count=0) at os/os0sync.c:399 # 2010-07-26T13:00:49 #3 0xb6ce3e48 in os_aio_simulated_handle (global_segment=4, message1=0xac73238c, message2=0xac732388, type=0xac732384) at os/os0file.c:4199 # 2010-07-26T13:00:49 #4 0xb6c9f385 in fil_aio_wait (segment=4) at fil/fil0fil.c:4439 # 2010-07-26T13:00:49 #5 0xb6d30668 in io_handler_thread (arg=0xb6d74370) at srv/srv0start.c:475 # 2010-07-26T13:00:49 #6 0xb784a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #7 0xb774f5ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 # 2010-07-26T13:00:49 Thread 18 (process 13637): # 2010-07-26T13:00:49 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:49 #1 0xb78510fb in read () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #2 0x081fab3f in my_real_read (net=0xa1a71b0, complen=0xa71a8328) at net_serv.cc:816 # 2010-07-26T13:00:49 #3 0x081fb122 in my_net_read (net=0xa1a71b0) at net_serv.cc:1011 # 2010-07-26T13:00:49 #4 0x0821fbeb in do_command (thd=0xa1a7138) at sql_parse.cc:824 # 2010-07-26T13:00:49 #5 0x082101e3 in handle_one_connection (arg=0xa1a7138) at sql_connect.cc:1136 # 2010-07-26T13:00:49 #6 0xb784a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #7 0xb774f5ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 # 2010-07-26T13:00:49 Thread 17 (process 13610): # 2010-07-26T13:00:49 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:49 #1 0xb784e0e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #2 0xb6ce63b5 in os_event_wait_low (event=0xa0b9128, reset_sig_count=0) at os/os0sync.c:399 # 2010-07-26T13:00:49 #3 0xb6d42ac5 in trx_commit_complete_for_mysql (trx=0xa11ebb8) at trx/trx0trx.c:1601 # 2010-07-26T13:00:49 #4 0xb6cb9065 in innobase_commit (hton=0x9ae2c38, thd=0x9ad8d68, all=false) at handler/ha_innodb.cc:2531 # 2010-07-26T13:00:49 #5 0x082fe2ee in ha_commit_trans (thd=0x9ad8d68, all=false) at handler.cc:1233 # 2010-07-26T13:00:49 #6 0x082fe680 in ha_autocommit_or_rollback (thd=0x9ad8d68, error=0) at handler.cc:1367 # 2010-07-26T13:00:49 #7 0x0821e27d in dispatch_command (command=COM_QUERY, thd=0x9ad8d68, packet=0xa114491 "INSERT INTO `table100_innodb_int_autoinc` ( `col_set_key` ) VALUES ( 2 )", # 2010-07-26T13:00:49 packet_length=72) at sql_parse.cc:1657 # 2010-07-26T13:00:49 #8 0x0821fc60 in do_command (thd=0x9ad8d68) at sql_parse.cc:882 # 2010-07-26T13:00:49 #9 0x082101e3 in handle_one_connection (arg=0x9ad8d68) at sql_connect.cc:1136 # 2010-07-26T13:00:49 #10 0xb784a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #11 0xb774f5ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 # 2010-07-26T13:00:49 Thread 16 (process 13591): # 2010-07-26T13:00:49 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:49 #1 0xb77478d1 in select () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 #2 0xb6ce6fce in os_thread_sleep (tm=0) at os/os0thread.c:295 # 2010-07-26T13:00:49 #3 0xb6d2bbac in srv_lock_timeout_thread (arg=0x0) at srv/srv0srv.c:2139 # 2010-07-26T13:00:49 #4 0xb784a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #5 0xb774f5ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 # 2010-07-26T13:00:49 Thread 15 (process 13583): # 2010-07-26T13:00:49 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:49 #1 0xb784e0e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #2 0xb6ce63b5 in os_event_wait_low (event=0x9e1b280, reset_sig_count=0) at os/os0sync.c:399 # 2010-07-26T13:00:49 #3 0xb6ce3e48 in os_aio_simulated_handle (global_segment=2, message1=0xad73438c, message2=0xad734388, type=0xad734384) at os/os0file.c:4199 # 2010-07-26T13:00:49 #4 0xb6c9f385 in fil_aio_wait (segment=2) at fil/fil0fil.c:4439 # 2010-07-26T13:00:49 #5 0xb6d30668 in io_handler_thread (arg=0xb6d74368) at srv/srv0start.c:475 # 2010-07-26T13:00:49 #6 0xb784a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #7 0xb774f5ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 # 2010-07-26T13:00:49 Thread 14 (process 13589): # 2010-07-26T13:00:49 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:49 #1 0xb784e0e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #2 0xb6ce63b5 in os_event_wait_low (event=0x9e1b4f0, reset_sig_count=0) at os/os0sync.c:399 # 2010-07-26T13:00:49 #3 0xb6ce3e48 in os_aio_simulated_handle (global_segment=8, message1=0xaa72e38c, message2=0xaa72e388, type=0xaa72e384) at os/os0file.c:4199 # 2010-07-26T13:00:49 #4 0xb6c9f385 in fil_aio_wait (segment=8) at fil/fil0fil.c:4439 # 2010-07-26T13:00:49 #5 0xb6d30668 in io_handler_thread (arg=0xb6d74380) at srv/srv0start.c:475 # 2010-07-26T13:00:49 #6 0xb784a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #7 0xb774f5ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 # 2010-07-26T13:00:49 Thread 13 (process 13581): # 2010-07-26T13:00:49 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:49 #1 0xb784e0e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #2 0xb6ce63b5 in os_event_wait_low (event=0x9e1b1b0, reset_sig_count=0) at os/os0sync.c:399 # 2010-07-26T13:00:49 #3 0xb6ce3e48 in os_aio_simulated_handle (global_segment=0, message1=0xb766838c, message2=0xb7668388, type=0xb7668384) at os/os0file.c:4199 # 2010-07-26T13:00:49 #4 0xb6c9f385 in fil_aio_wait (segment=0) at fil/fil0fil.c:4439 # 2010-07-26T13:00:49 #5 0xb6d30668 in io_handler_thread (arg=0xb6d74360) at srv/srv0start.c:475 # 2010-07-26T13:00:49 #6 0xb784a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #7 0xb774f5ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 # 2010-07-26T13:00:49 Thread 12 (process 13587): # 2010-07-26T13:00:49 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:49 #1 0xb784e0e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #2 0xb6ce63b5 in os_event_wait_low (event=0x9e1b420, reset_sig_count=0) at os/os0sync.c:399 # 2010-07-26T13:00:49 #3 0xb6ce3e48 in os_aio_simulated_handle (global_segment=6, message1=0xab73038c, message2=0xab730388, type=0xab730384) at os/os0file.c:4199 # 2010-07-26T13:00:49 #4 0xb6c9f385 in fil_aio_wait (segment=6) at fil/fil0fil.c:4439 # 2010-07-26T13:00:49 #5 0xb6d30668 in io_handler_thread (arg=0xb6d74378) at srv/srv0start.c:475 # 2010-07-26T13:00:49 #6 0xb784a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #7 0xb774f5ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 # 2010-07-26T13:00:49 Thread 11 (process 13634): # 2010-07-26T13:00:49 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:49 #1 0xb78510fb in read () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #2 0x081fab3f in my_real_read (net=0xa12d538, complen=0xa71d9328) at net_serv.cc:816 # 2010-07-26T13:00:49 #3 0x081fb122 in my_net_read (net=0xa12d538) at net_serv.cc:1011 # 2010-07-26T13:00:49 #4 0x0821fbeb in do_command (thd=0xa12d4c0) at sql_parse.cc:824 # 2010-07-26T13:00:49 #5 0x082101e3 in handle_one_connection (arg=0xa12d4c0) at sql_connect.cc:1136 # 2010-07-26T13:00:49 #6 0xb784a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #7 0xb774f5ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 # 2010-07-26T13:00:49 Thread 10 (process 13586): # 2010-07-26T13:00:49 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:49 #1 0xb784e0e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #2 0xb6ce63b5 in os_event_wait_low (event=0x9e1b3b8, reset_sig_count=0) at os/os0sync.c:399 # 2010-07-26T13:00:49 #3 0xb6ce3e48 in os_aio_simulated_handle (global_segment=5, message1=0xabf3138c, message2=0xabf31388, type=0xabf31384) at os/os0file.c:4199 # 2010-07-26T13:00:49 #4 0xb6c9f385 in fil_aio_wait (segment=5) at fil/fil0fil.c:4439 # 2010-07-26T13:00:49 #5 0xb6d30668 in io_handler_thread (arg=0xb6d74374) at srv/srv0start.c:475 # 2010-07-26T13:00:49 #6 0xb784a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #7 0xb774f5ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 # 2010-07-26T13:00:49 Thread 9 (process 13628): # 2010-07-26T13:00:49 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:49 #1 0xb78510fb in read () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #2 0x081fab3f in my_real_read (net=0xa13eba0, complen=0xa723b328) at net_serv.cc:816 # 2010-07-26T13:00:49 #3 0x081fb122 in my_net_read (net=0xa13eba0) at net_serv.cc:1011 # 2010-07-26T13:00:49 #4 0x0821fbeb in do_command (thd=0xa13eb28) at sql_parse.cc:824 # 2010-07-26T13:00:49 #5 0x082101e3 in handle_one_connection (arg=0xa13eb28) at sql_connect.cc:1136 # 2010-07-26T13:00:49 #6 0xb784a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #7 0xb774f5ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 # 2010-07-26T13:00:49 Thread 8 (process 13625): # 2010-07-26T13:00:49 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:49 #1 0xb78510fb in read () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #2 0x081fab3f in my_real_read (net=0xa142be8, complen=0xa726c328) at net_serv.cc:816 # 2010-07-26T13:00:49 #3 0x081fb122 in my_net_read (net=0xa142be8) at net_serv.cc:1011 # 2010-07-26T13:00:49 #4 0x0821fbeb in do_command (thd=0xa142b70) at sql_parse.cc:824 # 2010-07-26T13:00:49 #5 0x082101e3 in handle_one_connection (arg=0xa142b70) at sql_connect.cc:1136 # 2010-07-26T13:00:49 #6 0xb784a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #7 0xb774f5ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 # 2010-07-26T13:00:49 Thread 7 (process 13584): # 2010-07-26T13:00:49 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:49 #1 0xb784e0e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #2 0xb6ce63b5 in os_event_wait_low (event=0x9e1b2e8, reset_sig_count=0) at os/os0sync.c:399 # 2010-07-26T13:00:49 #3 0xb6ce3e48 in os_aio_simulated_handle (global_segment=3, message1=0xacf3338c, message2=0xacf33388, type=0xacf33384) at os/os0file.c:4199 # 2010-07-26T13:00:49 #4 0xb6c9f385 in fil_aio_wait (segment=3) at fil/fil0fil.c:4439 # 2010-07-26T13:00:49 #5 0xb6d30668 in io_handler_thread (arg=0xb6d7436c) at srv/srv0start.c:475 # 2010-07-26T13:00:49 #6 0xb784a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #7 0xb774f5ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 # 2010-07-26T13:00:49 Thread 6 (process 13592): # 2010-07-26T13:00:49 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:49 #1 0xb77478d1 in select () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 #2 0xb6ce6fce in os_thread_sleep (tm=0) at os/os0thread.c:295 # 2010-07-26T13:00:49 #3 0xb6d2bda1 in srv_error_monitor_thread (arg=0x0) at srv/srv0srv.c:2304 # 2010-07-26T13:00:49 #4 0xb784a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #5 0xb774f5ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 # 2010-07-26T13:00:49 Thread 5 (process 13582): # 2010-07-26T13:00:49 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:49 #1 0xb784e0e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #2 0xb6ce63b5 in os_event_wait_low (event=0x9e1b218, reset_sig_count=0) at os/os0sync.c:399 # 2010-07-26T13:00:49 #3 0xb6ce3e48 in os_aio_simulated_handle (global_segment=1, message1=0xadf3538c, message2=0xadf35388, type=0xadf35384) at os/os0file.c:4199 # 2010-07-26T13:00:49 #4 0xb6c9f385 in fil_aio_wait (segment=1) at fil/fil0fil.c:4439 # 2010-07-26T13:00:49 #5 0xb6d30668 in io_handler_thread (arg=0xb6d74364) at srv/srv0start.c:475 # 2010-07-26T13:00:49 #6 0xb784a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #7 0xb774f5ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 # 2010-07-26T13:00:49 Thread 4 (process 13579): # 2010-07-26T13:00:49 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:49 #1 0xb77478d1 in select () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 #2 0x0820ae12 in handle_connections_sockets (arg=0x0) at mysqld.cc:5103 # 2010-07-26T13:00:49 #3 0x0820bad7 in main (argc=24576, argv=0x0) at mysqld.cc:4587 # 2010-07-26T13:00:49 # 2010-07-26T13:00:49 Thread 3 (process 13595): # 2010-07-26T13:00:49 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:49 #1 0xb7852300 in sigwait () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #2 0x08206014 in signal_hand (arg=0x0) at mysqld.cc:2807 # 2010-07-26T13:00:49 #3 0xb784a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #4 0xb774f5ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 # 2010-07-26T13:00:49 Thread 2 (process 13593): # 2010-07-26T13:00:49 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:49 #1 0xb77478d1 in select () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 #2 0xb6ce6fce in os_thread_sleep (tm=0) at os/os0thread.c:295 # 2010-07-26T13:00:49 #3 0xb6d2c5bb in srv_monitor_thread (arg=0x0) at srv/srv0srv.c:1997 # 2010-07-26T13:00:49 #4 0xb784a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #5 0xb774f5ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 # 2010-07-26T13:00:49 Thread 1 (process 13594): # 2010-07-26T13:00:49 #0 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:49 #1 0xb784f1c8 in pthread_kill () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #2 0x084e370b in my_write_core (sig=6) at stacktrace.c:329 # 2010-07-26T13:00:49 #3 0x08206670 in handle_segfault (sig=6) at mysqld.cc:2605 # 2010-07-26T13:00:49 #4 # 2010-07-26T13:00:49 #5 0xb786f430 in __kernel_vsyscall () # 2010-07-26T13:00:49 #6 0xb76966d0 in raise () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 #7 0xb7698098 in abort () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 #8 0xb6ca5b8c in fil_io (type=10, sync=1, space_id=0, zip_size=0, block_offset=18676607, byte_offset=0, len=16384, buf=0xaf1b8000, message=0xae9936e0) at fil/fil0fil.c:4306 # 2010-07-26T13:00:49 #9 0xb6c84e87 in buf_read_page_low (err=0xa7c9a618, sync=1, mode=132, space=0, zip_size=0, unzip=0, tablespace_version=1, offset=18677759) at buf/buf0rea.c:145 # 2010-07-26T13:00:49 #10 0xb6c851af in buf_read_page (space=0, zip_size=0, offset=18677759) at buf/buf0rea.c:183 # 2010-07-26T13:00:49 #11 0xb6c7c6dd in buf_page_get_gen (space=0, zip_size=0, offset=18677759, rw_latch=2, guess=0x0, mode=10, file=0xb6d50779 "btr/btr0cur.c", line=4313, mtr=0xa7c9a6f8) # 2010-07-26T13:00:49 at buf/buf0buf.c:2095 # 2010-07-26T13:00:49 #12 0xb6c68d05 in btr_free_externally_stored_field (index=0xa120ab8, field_ref=0xaee6913c "", rec=0xaee68e27 "\200", offsets=0xa730a388, page_zip=0x0, i=4, rb_ctx=RB_NONE, # 2010-07-26T13:00:49 local_mtr=0xa7c9ac24) at btr/btr0cur.c:4312 # 2010-07-26T13:00:49 #13 0xb6c6ebdd in btr_cur_pessimistic_delete (err=0xa7c9b20c, has_reserved_extents=0, cursor=0xa0bdcd0, rb_ctx=RB_NONE, mtr=0xa7c9ac24) at btr/btr0cur.c:4414 # 2010-07-26T13:00:49 #14 0xb6d1915d in row_purge_remove_clust_if_poss_low (node=0xa0bdc90, mode=33) at row/row0purge.c:175 # 2010-07-26T13:00:49 #15 0xb6d198dd in row_purge_step (thr=0xa0bdc30) at row/row0purge.c:212 # 2010-07-26T13:00:49 #16 0xb6d0311a in que_run_threads (thr=0xa0bdc30) at que/que0que.c:1248 # 2010-07-26T13:00:49 #17 0xb6d36073 in trx_purge () at trx/trx0purge.c:1177 # 2010-07-26T13:00:49 #18 0xb6d2d2bd in srv_master_thread (arg=0x0) at srv/srv0srv.c:2601 # 2010-07-26T13:00:49 #19 0xb784a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T13:00:49 #20 0xb774f5ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T13:00:49 Test completed with failure status 101. # 2010-07-26T13:00:49 gentest.pl exited with exit status 101 2010-07-26T13:00:49 [13529] ./runall.pl will exit with exit status 101