# 2010-07-26T19:35:44 Copyright (c) 2008-2009 Sun Microsystems, Inc. All rights reserved. Use is subject to license terms. # 2010-07-26T19:35:44 Please see http://forge.mysql.com/wiki/Category:RandomQueryGenerator for more information on this test framework. # 2010-07-26T19:35:44 Starting # 2010-07-26T19:35:44 # ./runall.pl \ # 2010-07-26T19:35:44 # --basedir=/mysql/mysql-5.1.49-linux-i686-glibc23/ \ # 2010-07-26T19:35:44 # --vardir1=/tmp/51/ \ # 2010-07-26T19:35:44 # --vardir2=/tmp/52/ \ # 2010-07-26T19:35:44 # --mysqld1=--log-output=none \ # 2010-07-26T19:35:44 # --mysqld1=--log_error=/randgen/new_testing/5/51.log \ # 2010-07-26T19:35:44 # --mysqld2=--log-output=none \ # 2010-07-26T19:35:44 # --mysqld2=--log_error=/randgen/new_testing/5/52.log \ # 2010-07-26T19:35:44 # --mysqld2=--ignore-builtin-innodb \ # 2010-07-26T19:35:44 # --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-26T19:35:44 # --mysqld2=--plugin-dir=/mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin/ \ # 2010-07-26T19:35:44 # --gendata=/randgen/new_testing/5/5.zz \ # 2010-07-26T19:35:44 # --grammar=/randgen/new_testing/5/5.yy \ # 2010-07-26T19:35:44 # --queries=5000 \ # 2010-07-26T19:35:44 # --threads=10 \ # 2010-07-26T19:35:44 # --Validators=ResultsetComparator,MarkErrorLog,AbortOnSyntaxError # 2010-07-26T19:35:44 master_port : 19300 slave_port : 19302 master_ports : 19300 19302 MTR_BUILD_THREAD : 930 # 2010-07-26T19:35:44 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 19:35:44 [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-26T19:35:45 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 19:35:45 [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-26T19:35:46 Starting # 2010-07-26T19:35:46 gentest.pl \ # 2010-07-26T19:35:46 --gendata=/randgen/new_testing/5/5.zz \ # 2010-07-26T19:35:46 --validator=ResultsetComparator \ # 2010-07-26T19:35:46 --validator=MarkErrorLog \ # 2010-07-26T19:35:46 --validator=AbortOnSyntaxError \ # 2010-07-26T19:35:46 --threads=10 \ # 2010-07-26T19:35:46 --queries=5000 \ # 2010-07-26T19:35:46 --duration=3600 \ # 2010-07-26T19:35:46 --dsn=dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test \ # 2010-07-26T19:35:46 --dsn=dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test \ # 2010-07-26T19:35:46 --grammar=/randgen/new_testing/5/5.yy # 2010-07-26T19:35:46 ------------------------------- # 2010-07-26T19:35:46 Configuration # 2010-07-26T19:35:46 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-26T19:35:46 duration => 3600 # 2010-07-26T19:35:46 gendata => /randgen/new_testing/5/5.zz # 2010-07-26T19:35:46 grammar => /randgen/new_testing/5/5.yy # 2010-07-26T19:35:46 queries => 5000 # 2010-07-26T19:35:46 reporters => [''] # 2010-07-26T19:35:46 seed => 1 # 2010-07-26T19:35:46 threads => 10 # 2010-07-26T19:35:46 validators => ['ResultsetComparator', 'MarkErrorLog', 'AbortOnSyntaxError'] # 2010-07-26T19:35:46 Executor initialized, id # 2010-07-26T19:35:46 Default schema: test # 2010-07-26T19:35:46 # Creating MySQL table: test.table100_innodb_int_autoinc; engine: innodb; rows: 100 . # 2010-07-26T19:35:46 Executor initialized, id # 2010-07-26T19:35:46 Default schema: test # 2010-07-26T19:35:46 # Creating MySQL table: test.table100_innodb_int_autoinc; engine: innodb; rows: 100 . # 2010-07-26T19:35:46 Reporters: ErrorLog, Backtrace # 2010-07-26T19:35:46 Validators: ResultsetComparator, MarkErrorLog, AbortOnSyntaxError # 2010-07-26T19:35:46 Starting 10 processes, 5000 queries each, duration 3600 seconds. # 2010-07-26T19:35:46 GenTest::ErrorFilter(21204) started # 2010-07-26T19:35:46 Executor initialized, id 1 # 2010-07-26T19:35:46 Default schema: test # 2010-07-26T19:35:46 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-26T19:35:46 Executor initialized, id 2 # 2010-07-26T19:35:46 Default schema: test # 2010-07-26T19:35:46 Caching metadata for dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test # 2010-07-26T19:35:46 MarkErrorLog found errorlog at /randgen/new_testing/5/51.log # 2010-07-26T19:35:46 Executor initialized, id 1 # 2010-07-26T19:35:46 Default schema: test # 2010-07-26T19:35:46 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-26T19:35:46 Executor initialized, id 2 # 2010-07-26T19:35:46 Default schema: test # 2010-07-26T19:35:46 Caching metadata for dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test # 2010-07-26T19:35:46 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-26T19:35:46 MarkErrorLog found errorlog at /randgen/new_testing/5/51.log # 2010-07-26T19:35:46 Executor initialized, id 1 # 2010-07-26T19:35:46 Default schema: test # 2010-07-26T19:35:46 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-26T19:35:46 Executor initialized, id 2 # 2010-07-26T19:35:46 Default schema: test # 2010-07-26T19:35:46 Caching metadata for dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test # 2010-07-26T19:35:46 MarkErrorLog found errorlog at /randgen/new_testing/5/51.log # 2010-07-26T19:35:47 Executor initialized, id 1 # 2010-07-26T19:35:47 Default schema: test # 2010-07-26T19:35:47 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-26T19:35:47 Executor initialized, id 2 # 2010-07-26T19:35:47 Default schema: test # 2010-07-26T19:35:47 Caching metadata for dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test # 2010-07-26T19:35:47 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 (0E0 vs. 2) # 2010-07-26T19:35:47 MarkErrorLog found errorlog at /randgen/new_testing/5/51.log # 2010-07-26T19:35:47 Executor initialized, id 1 # 2010-07-26T19:35:47 Default schema: test # 2010-07-26T19:35:47 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-26T19:35:47 Executor initialized, id 2 # 2010-07-26T19:35:47 Default schema: test # 2010-07-26T19:35:47 Caching metadata for dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test # 2010-07-26T19:35:47 MarkErrorLog found errorlog at /randgen/new_testing/5/51.log # 2010-07-26T19:35:47 Executor initialized, id 1 # 2010-07-26T19:35:47 Default schema: test # 2010-07-26T19:35:47 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-26T19:35:47 Executor initialized, id 2 # 2010-07-26T19:35:47 Default schema: test # 2010-07-26T19:35:47 Caching metadata for dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test # 2010-07-26T19:35:47 MarkErrorLog found errorlog at /randgen/new_testing/5/51.log # 2010-07-26T19:35:47 Executor initialized, id 1 # 2010-07-26T19:35:47 Default schema: test # 2010-07-26T19:35:47 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-26T19:35:47 Executor initialized, id 2 # 2010-07-26T19:35:47 Default schema: test # 2010-07-26T19:35:47 Caching metadata for dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test # 2010-07-26T19:35:47 MarkErrorLog found errorlog at /randgen/new_testing/5/51.log # 2010-07-26T19:35:47 Executor initialized, id 1 # 2010-07-26T19:35:47 Default schema: test # 2010-07-26T19:35:47 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-26T19:35:47 Executor initialized, id 2 # 2010-07-26T19:35:47 Default schema: test # 2010-07-26T19:35:47 Caching metadata for dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test # 2010-07-26T19:35:47 MarkErrorLog found errorlog at /randgen/new_testing/5/51.log # 2010-07-26T19:35:47 Executor initialized, id 1 # 2010-07-26T19:35:47 Default schema: test # 2010-07-26T19:35:47 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-26T19:35:47 Executor initialized, id 2 # 2010-07-26T19:35:47 Default schema: test # 2010-07-26T19:35:47 Caching metadata for dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test # 2010-07-26T19:35:47 MarkErrorLog found errorlog at /randgen/new_testing/5/51.log # 2010-07-26T19:35:47 Executor initialized, id 1 # 2010-07-26T19:35:47 Default schema: test # 2010-07-26T19:35:47 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-26T19:35:47 Executor initialized, id 2 # 2010-07-26T19:35:47 Default schema: test # 2010-07-26T19:35:47 Caching metadata for dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test # 2010-07-26T19:35:47 Started periodic reporting process... # 2010-07-26T19:35:47 MarkErrorLog found errorlog at /randgen/new_testing/5/51.log # 2010-07-26T19:35:48 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set` = 5 WHERE `col_set` > '2005-06-28 22:23:19' AND `col_set` < 'okay' failed: affected_rows mismatch between servers (1 vs. 3) # 2010-07-26T19:35:48 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set` > '2006-05-05 04:06:47' AND `col_blob_key` < 4 failed: affected_rows mismatch between servers (1 vs. 0E0) # 2010-07-26T19:35:48 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 (3 vs. 4) # 2010-07-26T19:35:48 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'really' AND `col_blob_key` < 'at' failed: affected_rows mismatch between servers (9 vs. 10) # 2010-07-26T19:35:48 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 (10 vs. 11) # 2010-07-26T19:35:48 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 3 WHERE `pk` > 'symizfddqciinbwuaiyufkigdebinqyggwaxmaoooqatnmfofyempvpmefpusoyvolkruvqmbjobwnojxkyhrycnospudlijdbzkpwecavarhqrszejtgfpbldsummxydcmjccgvgfbxphjbkofbibxisqzcshogkwraubnctcsevqrsawevqvbraveevwfrvtrqsdfbkotrqhjcrogjdwsskagej' AND `col_set` < 'gsymizfddqciinbwuaiyufkigdebinqyggwaxmaoooqatnmfofyempvpmefpusoyvolkruvqmbjobwnojxkyhrycnospudlijdbzkpwecavarhqrszejtgfpbldsummxydcmjccgvgfbxphjbkofbibxisqzcshogkwraubnctcsevqrsawevqvbraveevwfrvtrqsdfbkotrqhjcrogj' failed: affected_rows mismatch between servers (3 vs. 2) # 2010-07-26T19:35:48 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'my' AND `col_set` < 'xfbhbpikqwziczkfzogybtkjkpttdftjvpfgwdleinctcibsanrkxmtskurjkbrfthplegltfvv' failed: affected_rows mismatch between servers (8 vs. 7) # 2010-07-26T19:35:48 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 8 WHERE `col_set` > '2000-06-19 12:02:09' AND `col_blob` < 'the' failed: affected_rows mismatch between servers (0E0 vs. 2) # 2010-07-26T19:35:48 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'know' AND `col_set_key` < '2004-12-05 16:03:36' failed: affected_rows mismatch between servers (0E0 vs. 20) # 2010-07-26T19:35:48 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'qlyabuysarnzmvhawcfgdoecusotpkwswptkigpcycionazkuqikzezpjxdcrfzwhtwtysbrfdrclrerviivzafksqgqicngfrwufcouwckhgylzdekwcjtdxts' AND `pk` < '2008-12-02 19:03:27' failed: affected_rows mismatch between servers (47 vs. 0E0) # 2010-07-26T19:35:48 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'you' AND `pk` < '2009-02-04 05:53:20' failed: affected_rows mismatch between servers (1 vs. 27) # 2010-07-26T19:35:48 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'got' AND `col_set_key` < 8 failed: affected_rows mismatch between servers (6 vs. 5) # 2010-07-26T19:35:48 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 0 WHERE `col_blob_key` > '2001-06-07 18:21:03' AND `col_blob_key` < 9 failed: affected_rows mismatch between servers (1 vs. 0E0) # 2010-07-26T19:35:48 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob_key` > '2003-07-02 08:12:33' AND `pk` < '2008-02-15 15:44:57' failed: affected_rows mismatch between servers (1 vs. 0E0) # 2010-07-26T19:35:48 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set` = 0 WHERE `col_blob` > 6 AND `pk` < '2009-12-23 13:06:54' failed: affected_rows mismatch between servers (0E0 vs. 3) # 2010-07-26T19:35:48 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 8 WHERE `pk` > 'see' AND `col_set_key` < 9 failed: affected_rows mismatch between servers (1 vs. 2) # 2010-07-26T19:35:48 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 0 WHERE `col_blob_key` > 5 AND `col_blob_key` < 'got' failed: affected_rows mismatch between servers (1 vs. 2) # 2010-07-26T19:35:48 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob` = 3 WHERE `pk` > 'synwbvfnvyqsvsftdgxilaczcyhkiybwhvrhuzoadonlgmjrykisyihvwulahkpzkabljyehqznlnceuvpyltpcvtclgbwfdskeqfdyjihzupcijsfuwreplqhknjtrsxgxcfpvqxoswelsdsmnlpklvlxffehuxadbnfaoqjmpagvkejyhmmnw' AND `col_set_key` < 'come' failed: affected_rows mismatch between servers (5 vs. 6) # 2010-07-26T19:35:49 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > '2003-07-13 22:49:36' AND `pk` < '2009-03-06 06:26:57' failed: affected_rows mismatch between servers (5 vs. 0E0) # 2010-07-26T19:35:49 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > '2001-10-28 02:09:46' AND `col_set_key` < 'then' failed: affected_rows mismatch between servers (0E0 vs. 6) # 2010-07-26T19:35:49 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 (2 vs. 3) # 2010-07-26T19:35:49 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set` = 2 WHERE `pk` > 'gkmupkksfxcyhvgdazbueuefxyjqcytnrtjlygorngnezcdxcmekjyjvajgyzxpukhsenojzfosqbtpszimznsxfelrlprsmijpgqlwrloryjxjoujnowflhlf' AND `col_blob_key` < 'had' failed: affected_rows mismatch between servers (10 vs. 11) # 2010-07-26T19:35:49 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 4 WHERE `pk` > "didn't" AND `col_set_key` < 'mean' failed: affected_rows mismatch between servers (1 vs. 0E0) # 2010-07-26T19:35:49 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > '2002-10-25 03:18:16' AND `pk` < '2004-10-13 08:36:03' failed: affected_rows mismatch between servers (1 vs. 0E0) # 2010-07-26T19:35:49 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 1 AND `col_set_key` < 'dchtmmprlswsigdipulrcbpmhwkkhpglmmkdrzuodbbjsbexbzhybdtdghnhqyfesojlzybundaegjjkraxeqetxtvgoypekqdkfkeddfvkpdqmmebncpxqexsoqywbnblqtvxfddxkxcknronbaaxgwqmdtojrbs' failed: affected_rows mismatch between servers (2 vs. 3) # 2010-07-26T19:35:49 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > "I'm" AND `col_set` < 'nbvcyzzxfbhbpikqwziczkfzogybtkjkpttdftjvpfgwdleinctcibsanrkxmtskurjkbrfthplegltfvvbmyihkjcrhcfjqsgroeyjvqheofvdcujkgvyanveuqlyhnkwizomgnqqxmctihkgrzvgoxwzoaoqfhjajxhchyeexglnxgoruczozuiawdckfqxatruutqbytleszhxgopy' failed: affected_rows mismatch between servers (16 vs. 17) # 2010-07-26T19:35:49 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > '2007-09-24 11:24:57' AND `col_blob` < '2007-10-11 15:19:38' failed: affected_rows mismatch between servers (5 vs. 0E0) # 2010-07-26T19:35:49 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > '2004-08-01 11:08:55' AND `col_blob` < 'that' failed: affected_rows mismatch between servers (0E0 vs. 5) # 2010-07-26T19:35:49 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 0 WHERE `pk` > 'yfueptquuuzhgpyyababvmrpxqnohoirxafugyywaffoiulmtpwyngrhgkaxvgtmhzskmytmigwyruojuqvpaxlqiqhwaxg' AND `col_set_key` < 'qyfueptquuuzhgpyyababvmrpxqnohoirxafugyywaffoiulmtpwyngrhgkaxvgtmhzskmytmigwyruojuqvpaxlqiqhwaxgfssqjaljlzmwrueleducnrmjjzlmyfboznamseirxclsudlwscbytkxeldkelvxtneysggolpcdscavvddiscbduxmptydcmudhmwswamiqe' failed: affected_rows mismatch between servers (12 vs. 7) # 2010-07-26T19:35:49 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob` = 6 WHERE `col_blob_key` > '2009-11-21 02:56:00' AND `col_blob_key` < 'would' failed: affected_rows mismatch between servers (1 vs. 0E0) # 2010-07-26T19:35:49 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'ok' AND `col_blob` < 8 failed: affected_rows mismatch between servers (4 vs. 5) # 2010-07-26T19:35:49 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set` > 4 AND `col_blob` < "you're" failed: affected_rows mismatch between servers (3 vs. 0E0) # 2010-07-26T19:35:49 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 (28 vs. 27) # 2010-07-26T19:35:49 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'ynnhlnbvcyzzxfbhbpikqwziczkfzogybtkjkpttdftjvpfgwdleinctcibsanrkxmtskurjkbrfthplegltfvvbmyihkjcrhcfjqsgroeyjvqheofvdcujkgvyanveuqlyhnkwizomgnqqxmctihkgrzvgoxwzoaoqfhjajxhchyeexglnxgoruczozuiawdckfqxatruutqbytleszhxgopyizrctmefncptaaxhefzenjekskspd' AND `col_set` < 'vynnhlnbvcyzzxfbhbpikqwziczkfzogybtkjkpttdftjvpfgwdleinctcibsanrkxmtskurjkbrfthplegltfvvbmyihkjcrhcfjqsgroeyjvqheofvdcujkgvyanveu' failed: affected_rows mismatch between servers (1 vs. 3) # 2010-07-26T19:35:49 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set` > 'at' AND `col_set` < 'hey' failed: affected_rows mismatch between servers (2 vs. 3) # 2010-07-26T19:35:49 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'cjhluvynnhlnbvcyzzxfbhbpikqwziczkfzogybtkjkpttdftjvpfgwdleinctcibsanrkxmtskurjkbrfthplegltfvvbmyihkjcrhc' AND `col_blob` < 'ncjhluvynnhlnbvcyzzxfbhbpikqwziczkfzogybtkjkpttdftjvpfgwdleinctcibsanrkxmtskurjkbrfthplegltfvvbmyihkjcrhcfjqsgroeyjvqheofvdcujkgvyanveuqlyhnkwizomgnqqxmcti' failed: affected_rows mismatch between servers (23 vs. 22) # 2010-07-26T19:35:49 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set` = 0 WHERE `col_set` > '2009-09-16 05:16:54' AND `col_set_key` < 'rlcvgpfojidmiefcmztkntnwhbznvddaqxbczstbaoruxzvewtefanhawhqaklqpnqfzihwtcxakuuwvxtxnzzuwfxyuxplvflyrifpfidrobgefcqctfdsrcjqfcbefuudsssxxmyykmplzsusndtgvhrvqccxxczpkoercnkmkeeshhpmdzzfsxobimcmjvqizrcnhiazdtkqpwhmxogiosgjziowbxxbwyqsrvcprfwcjgk' failed: affected_rows mismatch between servers (0E0 vs. 5) # 2010-07-26T19:35:50 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 4 AND `col_set_key` < 'then' failed: affected_rows mismatch between servers (8 vs. 9) # 2010-07-26T19:35:50 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 0 AND `col_blob_key` < 'jncjhluvynnhlnbvcyzzxfbhbpikqwziczkfzo' failed: affected_rows mismatch between servers (7 vs. 6) # 2010-07-26T19:35:50 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 5 AND `col_blob_key` < 'urlcvgpfojidmiefcmztkntnwhbznvddaqxbczstbaoruxzvewtefanhawhqaklqpn' failed: affected_rows mismatch between servers (0E0 vs. 1) # 2010-07-26T19:35:50 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'zvcxmxeokldbfvpwjtnqlyabuysarnzmvhawc' AND `col_set` < 'mean' failed: affected_rows mismatch between servers (3 vs. 4) # 2010-07-26T19:35:50 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-26T19:35:50 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 3 WHERE `col_blob` > '2007-09-23 15:52:39' AND `col_blob` < 'kzedzvyqkhjdchtmmprlswsigdipulrcbpmhwkkhpglmmkdrzuodbbjsbexbzhybdtdghnhqyfesojlzybundae' failed: affected_rows mismatch between servers (2 vs. 1) # 2010-07-26T19:35:50 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 (10 vs. 9) # 2010-07-26T19:35:50 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set` = 3 WHERE `pk` > 'pemairgedwqeychtyqauxmqvyaddgjxbdlnbitff' AND `col_set_key` < 3 failed: affected_rows mismatch between servers (2 vs. 3) # 2010-07-26T19:35:50 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set` = 9 WHERE `pk` > 'how' AND `col_set` < 'are' failed: affected_rows mismatch between servers (8 vs. 9) # 2010-07-26T19:35:50 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'tbisdxukzedzvyqkhjdchtmmprlswsigdipulrcbpmhwkkhpglmmkdrzuodbbjsbexbzhybdtdghnhqyfesojlz' AND `col_set_key` < 'jtbisdx' failed: affected_rows mismatch between servers (12 vs. 10) # 2010-07-26T19:35:50 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set` = 1 WHERE `col_set_key` > '2004-08-01 11:23:06' AND `col_blob` < 'tell' failed: affected_rows mismatch between servers (6 vs. 0E0) # 2010-07-26T19:35:50 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 4 WHERE `col_set` > 'acuxqrigkciowsvjfacxbahbarqyfueptquuuzhgpyyababvmrpxqnohoi' AND `col_blob` < 'dacuxqrigkciowsvjfacxbahbarqyfueptquuuzhgpyyababvmrpxqnohoirxafugyywaf' failed: affected_rows mismatch between servers (0E0 vs. 2) # 2010-07-26T19:35:51 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set` > 3 AND `col_set_key` < 'know' failed: affected_rows mismatch between servers (0E0 vs. 8) # 2010-07-26T19:35:51 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > '2007-09-01 02:55:09' AND `col_set` < 7 failed: affected_rows mismatch between servers (6 vs. 0E0) # 2010-07-26T19:35:51 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob` > '2001-09-21 18:10:28' AND `col_blob` < 'that' failed: affected_rows mismatch between servers (13 vs. 14) # 2010-07-26T19:35:51 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob_key` > '2004-07-22 22:07:26' AND `col_blob_key` < 'acwcyetcgurlcvgpfojidmiefcmztkntnwhbznvddaqxbczstbaoruxzvewtefanhawhqaklqpnqfzihwtcxakuuwvxtxnzzuwfxyuxplvfly' failed: affected_rows mismatch between servers (3 vs. 4) # 2010-07-26T19:35:51 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'mktuvxxtbbrjmahevicyfbntxfhkuzrlsynwbvfnvyqsvsftdgxilaczcyhkiybwhvrhuzoadonlgmjrykisyihvwulahkpzkabljyehqznlnceuvpyltpcvtclgbwfdskeqfdyjihzupcijsfuwreplqhk' AND `col_blob_key` < 'good' failed: affected_rows mismatch between servers (15 vs. 14) # 2010-07-26T19:35:51 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set` > '2002-03-01 19:18:54' AND `col_set` < 3 failed: affected_rows mismatch between servers (0E0 vs. 2) # 2010-07-26T19:35:51 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 9 AND `pk` < '2007-09-03 13:41:11' failed: affected_rows mismatch between servers (16 vs. 15) # 2010-07-26T19:35:51 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob` = 5 WHERE `pk` > 'bpuyjmocjmjncjhluvynnhlnbvcyzzxfbhbpikqwziczkfzogybtkjkpttdftjvpfgw' AND `col_set_key` < 'pbpuyjmocjmjncjhluvynnhlnbvcyzzxfbhbpikqwziczkfzogybtkjkpttdftjvpfgwdleinctcibsanrkxmtskurjkbrfthplegltfvvbmyihkjcrhcfjqsgroeyjvqheofvdcujkgvyanveuqlyhnkwizomgnqqxmctihkgrzvgoxwzoaoqfhjajxhchyeexglnxgoruczozuiawdckfqxatruutqby' failed: affected_rows mismatch between servers (0E0 vs. 1) # 2010-07-26T19:35:51 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set` > '2007-04-15 15:55:02' AND `col_blob_key` < '2005-10-21 17:35:45' failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-26T19:35:51 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob` = 0 WHERE `pk` > 0 AND `col_blob` < 'rdxscnmktuvxxtbbrjmahevicyfbntxfhkuzrlsynwbvfnvyqsvsftdgxilaczcyhkiybwhvrhuzoadonlgmjrykisyihvwulahk' failed: affected_rows mismatch between servers (6 vs. 7) # 2010-07-26T19:35:51 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 3 WHERE `col_blob_key` > '2009-12-28 22:12:02' AND `col_blob_key` < 'there' failed: affected_rows mismatch between servers (9 vs. 8) # 2010-07-26T19:35:51 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > '2007-01-23 21:22:47' AND `col_set_key` < 'we' failed: affected_rows mismatch between servers (21 vs. 20) # 2010-07-26T19:35:51 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 5 WHERE `col_blob_key` > 4 AND `col_blob` < 'y' failed: affected_rows mismatch between servers (17 vs. 0E0) # 2010-07-26T19:35:51 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 (39 vs. 38) # 2010-07-26T19:35:52 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set` = 8 WHERE `pk` > 2 AND `col_set_key` < 6 failed: affected_rows mismatch between servers (1 vs. 3) # 2010-07-26T19:35:52 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'going' AND `col_blob_key` < 'yeah' failed: affected_rows mismatch between servers (5 vs. 6) # 2010-07-26T19:35:52 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'they' AND `col_set_key` < 'hwdy' failed: affected_rows mismatch between servers (11 vs. 10) # 2010-07-26T19:35:52 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 3 WHERE `pk` > 'me' AND `col_blob_key` < 'dfhrzpbkjyfrdxscnmktuvxxtbbrjmah' failed: affected_rows mismatch between servers (6 vs. 5) # 2010-07-26T19:35:52 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob` = 3 WHERE `col_blob_key` > 4 AND `col_set_key` < 'and' failed: affected_rows mismatch between servers (5 vs. 4) # 2010-07-26T19:35:52 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 6 WHERE `pk` > 'jqdfhrzpbkjyfrdxs' AND `col_blob` < 3 failed: affected_rows mismatch between servers (6 vs. 5) # 2010-07-26T19:35:52 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 3 AND `col_set_key` < 'fpfktpryniobsnzmfbswxicphwjvpemairgedwqeychtyqauxmqvyaddgjxbd' failed: affected_rows mismatch between servers (0E0 vs. 12) # 2010-07-26T19:35:52 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob_key` > '2006-01-17 01:00:34' AND `col_blob_key` < "didn't" failed: affected_rows mismatch between servers (12 vs. 6) # 2010-07-26T19:35:52 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'about' AND `pk` < '2000-06-11 10:27:48' failed: affected_rows mismatch between servers (28 vs. 22) # 2010-07-26T19:35:53 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 8 AND `col_blob` < 3 failed: affected_rows mismatch between servers (4 vs. 5) # 2010-07-26T19:35:53 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob` = 6 WHERE `col_set` > '2002-02-11 18:40:32' AND `col_set` < "that's" failed: affected_rows mismatch between servers (0E0 vs. 9) # 2010-07-26T19:35:53 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 7 WHERE `pk` > 8 AND `col_set_key` < 'qyinygxzhtjqdfhrzpbkjyfrdxscnmktuvxxtbbrjmahevicyfbntxfhkuzrlsynwbvfnvyqsvsftdgxilaczcyhkiybwhvrhuzoadonlgmjrykisyihvwulahkpzkabljyehqznlnceuvpyltpcvtclgbwfdskeqfdyjihzupcijsfuwreplqhk' failed: affected_rows mismatch between servers (17 vs. 16) # 2010-07-26T19:35:53 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'opompbzqfpfktpryniobsnzmfbswxicphwjvpemairgedwqeychtyqauxmqvyaddgjxbdlnbitffockgenukwwoyzqbjmbvoiwrvkzrfthvrehxjyzdebwzbkmifromaibjmjmubewrmlibbhm' AND `col_blob` < 'kopompbzqfpfktpryniobsnzmfbswxicphwjvpemairgedwqeychtyqauxmqvyaddgjxbdlnbitffockgenukwwoyzqbjmbvoiwrvkzrfthvrehxjyzdebwzbkmifromaibjmjmubewrmlibbhmaydbyjqkoepagaspeyaqpthywsggsdqrgiucufozmhyq' failed: affected_rows mismatch between servers (17 vs. 14) # 2010-07-26T19:35:53 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 5 WHERE `pk` > 7 AND `col_set` < 'get' failed: affected_rows mismatch between servers (0E0 vs. 2) # 2010-07-26T19:35:53 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 2 WHERE `pk` > 3 AND `col_blob` < 8 failed: affected_rows mismatch between servers (3 vs. 5) # 2010-07-26T19:35:53 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > '2006-02-06 01:35:00' AND `col_set_key` < 'orcskkgwpndqhtjwfypekeedsquftjtbisdxukzedzvyqkhjdchtmmprlswsigdipulrcbpmhwkkhpglmmkdrzuodbbjsbexbzhybdtdghnhqyfesojlzybundaegjjkraxeqetxtvgoypekqdkfkeddfvkpdqmmebncpxqexsoqywbnblqtvxfddxkxcknronbaaxgwqmdtojrbsamnbryacjrmcxhmsyigssluvn' failed: affected_rows mismatch between servers (11 vs. 12) # 2010-07-26T19:35:53 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set` > 4 AND `pk` < '2002-01-06 09:00:30' failed: affected_rows mismatch between servers (0E0 vs. 6) # 2010-07-26T19:35:53 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set` > '2009-01-02 15:22:11' AND `pk` < '2009-12-01 04:38:34' failed: affected_rows mismatch between servers (8 vs. 2) # 2010-07-26T19:35:53 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 4 WHERE `pk` > 'oaljhfqqwdmvboxhlonkjszqwuekftaylgqvhxvcodzfyo' AND `col_set_key` < 'eoaljhfqqwdmvboxhlonkjszqwuekftaylgqvhxvcodzfyocpzvcxmxeokldbfvpwjtnqlyabuysar' failed: affected_rows mismatch between servers (7 vs. 8) # 2010-07-26T19:35:53 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 6 WHERE `col_blob` > 5 AND `pk` < '2008-09-25 22:46:09' failed: affected_rows mismatch between servers (0E0 vs. 6) # 2010-07-26T19:35:53 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 8 WHERE `pk` > 'jrmgxpmqjkudisfstviefykgomofatxxjyqnpmfugjezkujjvzqwnqdrwuifpizeqtnlqpbcutbkvlfublwhlffeumbrqrxxwd' AND `col_set` < 'at' failed: affected_rows mismatch between servers (0E0 vs. 2) # 2010-07-26T19:35:53 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob` > '2009-10-20 09:53:51' AND `col_blob` < 'are' failed: affected_rows mismatch between servers (10 vs. 11) # 2010-07-26T19:35:53 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'eeoaljhfqqwdmvboxhlonkjszqwuekftaylgqvhxvcodzfyocpzvcxmxeokldbfvpwjtnqlyabuysarnzmvhawcfgdoecusotpkwswptkigpcycionazkuqikzezpjxdcrf' AND `col_blob` < 'beeoaljhfqqwdmvboxhlonkjszqwuekftaylgqvhxvcodzfyocpzvcxmxeo' failed: affected_rows mismatch between servers (5 vs. 4) # 2010-07-26T19:35:53 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'when' AND `col_blob` < 'what' failed: affected_rows mismatch between servers (17 vs. 18) # 2010-07-26T19:35:54 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 8 AND `col_blob_key` < 4 failed: affected_rows mismatch between servers (0E0 vs. 6) # 2010-07-26T19:35:54 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set` = 0 WHERE `pk` > 'uhbtldbcpauivrdmchwdyejunxpbpuyjmocjmjncjhluvynnhlnbvcyzzxfbhbpikqwziczkfzogybtkjkpttdftjvpfgwdleinctcibsanrkxmtskurjkbrfthplegltfvvbmyihkjcrhcfjqsgroeyjvqheofvdcujkgvyanveuql' AND `col_set` < 'euhbtldbcpauivrdmchwdye' failed: affected_rows mismatch between servers (6 vs. 7) # 2010-07-26T19:35:54 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'we' AND `col_blob_key` < 'here' failed: affected_rows mismatch between servers (8 vs. 2) # 2010-07-26T19:35:54 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 0 AND `col_blob_key` < 'xdhhqkoyqyinygxzhtjqdfhr' failed: affected_rows mismatch between servers (1 vs. 0E0) # 2010-07-26T19:35:54 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 0 AND `pk` < '2000-08-18 03:28:31' failed: affected_rows mismatch between servers (38 vs. 37) # 2010-07-26T19:35:54 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob_key` > '2009-06-02 10:46:23' AND `pk` < '2005-05-07 00:05:20' failed: affected_rows mismatch between servers (0E0 vs. 1) # 2010-07-26T19:35:54 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob` = 4 WHERE `pk` > 'cmn' AND `col_blob` < 5 failed: affected_rows mismatch between servers (0E0 vs. 1) # 2010-07-26T19:35:54 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob` > '2009-05-22 08:44:56' AND `col_blob` < 'wixrcqqrorvorcskkgwpndqhtjwfypekeedsquftjtbisdxukzedzvyqkhjdchtmmprlswsigdipulrcbpmhwkkhpglmmkdrzuodbbjsbexbzhybdtdghnhqyfesojlzybundaegjjkraxeqetxtvgoypekqdkfkeddfvkpdqmmebncpxqexs' failed: affected_rows mismatch between servers (3 vs. 5) # 2010-07-26T19:35:54 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 7 AND `col_set` < 'one' failed: affected_rows mismatch between servers (1 vs. 2) # 2010-07-26T19:35:54 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 8 WHERE `pk` > 'see' AND `col_blob_key` < 'gfgwtvggwarjrmgxpmqjkudisfstviefykgomofatxxjyqnpmfugjezkujjvzqwnqdrwuifpizeqtnlqpbcutbkvlfublwhlffeu' failed: affected_rows mismatch between servers (9 vs. 8) # 2010-07-26T19:35:54 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 8 AND `col_blob_key` < 'can' failed: affected_rows mismatch between servers (1 vs. 2) # 2010-07-26T19:35:54 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'bnmcrzaxdhhqkoyqyinygxzhtj' AND `col_set` < 7 failed: affected_rows mismatch between servers (1 vs. 0E0) # 2010-07-26T19:35:54 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'wmbnmcrzaxdhhqkoyqyinygxzhtjqdfhrzpbkjyfrdxscnmktuvxx' AND `col_blob_key` < "he's" failed: affected_rows mismatch between servers (9 vs. 8) # 2010-07-26T19:35:54 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > '2000-07-17 17:10:05' AND `col_set_key` < 3 failed: affected_rows mismatch between servers (2 vs. 0E0) # 2010-07-26T19:35:54 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > '2007-02-17 13:36:56' AND `pk` < '2005-04-26 04:40:29' failed: affected_rows mismatch between servers (9 vs. 0E0) # 2010-07-26T19:35:55 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > '2004-06-19 09:22:04' AND `col_set_key` < 'ibgcxkttlgugmgjjfsipdimaeeakocabmnmzqeomhgvuexgyqtbqngkmupkksfxcyhvgdazbueuefxyjqcytnrtjlygorngnezcdxcmekjyjvajgyzxpukhsenojzfosqbtpszimznsxfelrlprsmijpgqlwrloryjxjoujnowflhlfqeevdqvijwkujgrcnsjptfviqtpadwfmwtcjmxgi' failed: affected_rows mismatch between servers (0E0 vs. 11) # 2010-07-26T19:35:55 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 6 WHERE `pk` > 'dbyyeonpkvezbhnckopompbzqfpfktpryniobsnzmfbswxicphwjvpemairgedwqeychtyqauxmqvyaddgjxbdlnbitffockgenukwwoyzqbjmbvoiwrvkzrfthvrehxjyzdebwzbkmifromaibjmjmubewrmlibbhmaydbyjqkoepagaspeyaqpthywsggsdqrgiucufozm' AND `col_blob` < 'gdbyyeonpkvezbhnckopompbzqfpfktpryniobsnzmfbswxicphwjvpemairgedwqeychtyqauxmqvyaddgjxbdlnbitffockgenukwwoyzqbjmbvoiwrvkzrfthvrehxjyzdebwzb' failed: affected_rows mismatch between servers (12 vs. 10) # 2010-07-26T19:35:55 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'see' AND `col_set` < 'not' failed: affected_rows mismatch between servers (9 vs. 7) # 2010-07-26T19:35:55 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 2 WHERE `col_set_key` > '2006-10-27 02:50:04' AND `col_blob` < 6 failed: affected_rows mismatch between servers (5 vs. 3) # 2010-07-26T19:35:55 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > '2004-12-24 13:17:12' AND `col_blob` < 'enjribgcxkttlgugmgjjfsipdimaeeakocabmnmzq' failed: affected_rows mismatch between servers (8 vs. 6) # 2010-07-26T19:35:55 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'zgdbyyeon' AND `col_set` < 'could' failed: affected_rows mismatch between servers (4 vs. 8) # 2010-07-26T19:35:55 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob` = 9 WHERE `col_blob_key` > 2 AND `pk` < '2009-07-09 20:14:44' failed: affected_rows mismatch between servers (11 vs. 12) # 2010-07-26T19:35:55 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set` > 7 AND `col_set` < 'here' failed: affected_rows mismatch between servers (4 vs. 2) # 2010-07-26T19:35:55 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 8 WHERE `col_blob_key` > '2002-10-07 11:14:06' AND `col_blob` < 'xdvxohupoicmnczwptehuymtyjejriwrhofbvxfxbxwkacwcyetcgurlcvgpfojidmiefcmztkntnwhbznvddaqxbczstbaoruxzvewtefanhawhqaklqpnqfzihwtcxakuuwvxtxnzzuwfxyuxplvflyrifpfidrobgefcqctfdsrcjqfcbefuudsssxxmyykmplzsusndtgvhrvqccxxczpkoercnkmkeeshhpmdzzf' failed: affected_rows mismatch between servers (0E0 vs. 12) # 2010-07-26T19:35:55 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'or' AND `col_set_key` < 1 failed: affected_rows mismatch between servers (2 vs. 0E0) # 2010-07-26T19:35:55 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob` > 6 AND `col_blob_key` < 'yxpxvylwm' failed: affected_rows mismatch between servers (7 vs. 12) # 2010-07-26T19:35:55 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob` = 1 WHERE `col_set` > 5 AND `col_set` < "didn't" failed: affected_rows mismatch between servers (3 vs. 5) # 2010-07-26T19:35:55 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 3 WHERE `col_set` > 2 AND `col_blob` < '2001-02-20 06:34:38' failed: affected_rows mismatch between servers (3 vs. 5) # 2010-07-26T19:35:55 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 0 WHERE `pk` > 'really' AND `col_blob_key` < 'get' failed: affected_rows mismatch between servers (11 vs. 13) # 2010-07-26T19:35:55 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set` = 8 WHERE `col_set` > '2001-07-27 11:28:58' AND `col_blob_key` < 'elywjjvqduqwqqpqhgfgwtvggwarjrmgxpmqjkudisfstviefykgomofatxxjyqnpmfugjezkujjvzqwnqdrwuifpizeqtnlqpbcutbkvlfublwhlffeumbrqrxxwdtrslpkmcnclsjopedydwvtjmkgag' failed: affected_rows mismatch between servers (3 vs. 5) # 2010-07-26T19:35:55 Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 4 WHERE `col_set` > '2002-08-01 22:01:53' AND `col_blob` < 6 failed: affected_rows mismatch between servers (3 vs. 5) # 2010-07-26T19:35:55 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > '2008-01-03 05:31:14' AND `pk` < '2006-10-13 13:23:10' failed: affected_rows mismatch between servers (18 vs. 21) # 2010-07-26T19:35:56 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > 0 AND `col_set` < 7 failed: affected_rows mismatch between servers (0E0 vs. 15) # 2010-07-26T19:35:56 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 1 AND `col_set` < 9 failed: affected_rows mismatch between servers (1 vs. 0E0) # 2010-07-26T19:35:56 Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 3 WHERE `col_set` > '2000-07-08 19:20:42' AND `col_blob_key` < 4 failed: affected_rows mismatch between servers (0E0 vs. 11) # 2010-07-26T19:35:56 Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set` > 0 AND `col_set` < 'zxsqseykasmxuzenjribgcxkttlgugmgjjfsipdimaeeakocabmnmzqeomhgvuexgyqtbqngkmupkksfxcyhvgdazbueuefxyjqcytnrtjlygorngnezcdxcmekjyjvajgyzxpukhsenojzfosqbtpszimznsxfelrlprsmijpgqlwrloryjxjoujnowflhlfqeevdqvijwkujgrc' failed: affected_rows mismatch between servers (19 vs. 4) # 2010-07-26T19:35:56 Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_set` ) VALUES ( 3 ) failed: 2013 Lost connection to MySQL server during query # 2010-07-26T19:35:56 Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test # 2010-07-26T19:35:56 Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_blob` ) VALUES ( 2 ) failed: 2013 Lost connection to MySQL server during query # 2010-07-26T19:35:56 Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=19302:user=root:database=test # 2010-07-26T19:35:56 Killing child process with pid 21233... # 2010-07-26T19:35:56 Killing child process with pid 21221... # 2010-07-26T19:35:56 Killing child process with pid 21209... # 2010-07-26T19:35:56 Killing child process with pid 21227... # 2010-07-26T19:35:56 Killing child process with pid 21215... # 2010-07-26T19:35:56 Killing child process with pid 21224... # 2010-07-26T19:35:56 Killing child process with pid 21206... # 2010-07-26T19:35:56 Killing child process with pid 21218... # 2010-07-26T19:35:56 Killing child process with pid 21230... # 2010-07-26T19:35:57 Killing periodic reporting process with pid 21205... # 2010-07-26T19:35:57 Kill GenTest::ErrorFilter(21204) # 2010-07-26T19:35:57 Server crash reported, initiating post-crash analysis... # 2010-07-26T19:35:57 The last 100 lines from /randgen/new_testing/5/51.log : 2010-07-26T19:35:56 [21209] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob_key` > 'vzelywjjvqduqwqqpqhgfgwtvggwarjrmgxpmqjkudisfstviefykgomofatxxjyqnpmfugjezkujjvzqwnqdrwuifpizeqtnlqpbcutbkvlfublwhlffeumbrqrxxwdtrslpkmcnclsjopedydwvtjmkgagunlcl' AND `col_set_key` < NULL 2010-07-26T19:35:56 [21209] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob` > 'fvzelywjjvqduqwqqpqhgfgwtvggwarjrmgxpmqjkudisfstviefykgomofatxxjyqnpmfugjezkujjvzqwn' AND `pk` < 5 2010-07-26T19:35:56 [21212] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob_key` > 4 AND `col_blob` < 'her' 2010-07-26T19:35:56 [21209] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set` = 9 WHERE `pk` > NULL AND `col_set_key` < NULL 2010-07-26T19:35:56 [21227] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_blob` ) VALUES ( 1 ) 2010-07-26T19:35:56 [21209] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 3 WHERE `col_blob` > '2004-01-24 13:09:18' AND `col_blob_key` < 'me' 2010-07-26T19:35:56 [21221] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > NULL AND `col_blob` < 4 2010-07-26T19:35:56 [21209] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 0 WHERE `col_blob` > NULL AND `col_blob_key` < NULL 2010-07-26T19:35:56 [21209] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 9 AND `pk` < 1 2010-07-26T19:35:56 [21221] Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob` = 1 WHERE `col_blob_key` > 2 AND `col_blob` < '2007-12-12 12:03:28' 2010-07-26T19:35:56 [21233] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 1 WHERE `pk` > 'oustczgdbyyeonpkvezbhnckopompbzqfpfktpryniobsnzmfbswxicphwjvpemairgedwqeychtyqauxmqvyaddgjxbdlnbitffockgenukwwoyzqbjm' AND `col_blob_key` < 'moustczgdbyyeonpkvezbhnckopompbzqfpfktpryniobsnzmfbswxicphwjvpemairgedwqeychtyqauxmqvyaddgjxbdlnbitff' 2010-07-26T19:35:56 [21215] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_set` ) VALUES ( 2 ) 2010-07-26T19:35:56 [21233] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > '2006-10-07 13:39:14' AND `pk` < NULL 2010-07-26T19:35:56 [21215] Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 8 WHERE `col_blob` > 'boumklbihcnexskyatndnlsbjvpbntwixrcqqrorvorcskkgwpndqhtjwfypekeedsquftjtbisdxukzedzvyqkhjdchtmmprlswsigdipulrcbpmhwkkhpglmmkdrzuodbbjsbexbzhybdtdghnhqyfesojlzybundaegjjkraxeqetxtvgoypekqdkfkeddfvkpdqmmebncpxqexsoqywbnblqtv' AND `col_set_key` < "can't" 2010-07-26T19:35:56 [21215] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set` = 3 WHERE `pk` > NULL AND `col_set_key` < "can't" 2010-07-26T19:35:56 [21215] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 7 WHERE `col_set` > NULL AND `col_set_key` < 'dboumklbihcnexskyatndnlsbjvpbntwixrcqqrorvorcskkgwpndqhtjwfypekeedsquftjtbisdxukzedzvyqkhjdchtmmprlswsigdipulrcbpmhwkkhpglmmkdrzuodbbjsbexbzhybdtdghnhqyfesojlzybundaegjjkraxeqetxtvgoypekqdkfkeddfvkpdqmmebncpxqexsoqywbnblqtv' 2010-07-26T19:35:56 [21218] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_set_key` ) VALUES ( 0 ) 2010-07-26T19:35:56 [21218] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > 5 AND `col_set` < 9 2010-07-26T19:35:56 [21218] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob` > 6 AND `col_set_key` < 'eykasmxuzenjribgcxkttlgugmgjjfsipdimaeeakocabmnmzqeomhgvuexgyqtbqngkmupkksfxcyhvgdazbueuefxyjqcytnrtjlygorngnezcdxc' 2010-07-26T19:35:56 [21218] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob_key` > 4 AND `col_blob` < 5 2010-07-26T19:35:56 [21218] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob_key` > 4 AND `pk` < 'come' 2010-07-26T19:35:56 [21218] Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 3 WHERE `col_set` > 'seykasmxuzenjribgcxkttlgugmgjjfsipdimaeeakocabmnmzqeomhgvuexgyqtbqngkmupkksfxcyhvgdazbueuefxyjqcytnrtjlygorngnezcdxc' AND `col_set_key` < 'qseykasmxuzenjribgcxkttlgugmgjjfsipdimaeeakocabmnmzqeomhgvuexgyqtbqngkmupkksfxcyhvgdazbueuefxyjqcytnrtjlygorngnez' 2010-07-26T19:35:56 [21218] Query: UPDATE `table100_innodb_int_autoinc` SET `pk` = 2 WHERE `col_set` > 5 AND `pk` < 'we' 2010-07-26T19:35:56 [21218] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > 9 AND `col_set` < '2009-03-12 08:54:54' 2010-07-26T19:35:56 [21218] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > 'sqseykasmxuzenjribgcxkttlgugmgjjfsipdimaeeakocabmnmzqeomhgvuexgyqtbqngkmupkksfxcyhvgdazbueuefxyjqcytnrtjlygorngnezcdxcmekjyjvajgyzxpukhsenojzfosqbtpszimznsxfelrlprsm' AND `col_blob_key` < 'xsqseykasmxuzenjribgcxkttlgugmgjjfsipdimaeeakocabmnmzqeomhgvuexgyqtbqngkmupkksfxcyhvgdazbueuefxyjqcytnrtjlygorngnezcdxcmekjyjvajgyzxpukhsenojzfosqbtpszimznsxfelrlprs' 2010-07-26T19:35:56 [21206] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_blob` ) VALUES ( 3 ) 2010-07-26T19:35:56 [21224] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_blob_key` ) VALUES ( 0 ) 2010-07-26T19:35:56 [21230] Query: INSERT INTO `table100_innodb_int_autoinc` ( `pk` ) VALUES ( 0 ) 2010-07-26T19:35:56 [21230] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 4 WHERE `col_set` > 5 AND `pk` < '2002-12-17 02:38:11' 2010-07-26T19:35:56 [21230] Query: INSERT INTO `table100_innodb_int_autoinc` ( `pk` ) VALUES ( 4 ) 2010-07-26T19:35:56 [21230] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set` > 1 AND `col_blob` < 'we' 2010-07-26T19:35:56 [21230] Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 4 WHERE `col_set_key` > 'pwjizbaghxzhccbedtobeeoaljhfqqwdmvboxhlonkjszqwuekftaylgqvh' AND `col_set_key` < 'ok' 2010-07-26T19:35:56 [21230] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > '2001-11-12 05:39:09' AND `pk` < NULL 2010-07-26T19:35:56 [21230] Query: UPDATE `table100_innodb_int_autoinc` SET `pk` = 6 WHERE `col_set` > 'rpwjizbaghxzhccbedtobeeoaljhfqqwdmvboxhlonkjszqwuekftaylgqvhxvcodzfyocpzvcxmxeokldbfvpwjtnqlyabuysarnzmvhawcfgdo' AND `col_set_key` < NULL 2010-07-26T19:35:56 [21230] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob_key` > 'zrpwjizbaghxzhccbedtobeeoaljhfqqwdmvboxhlonkjszqwuekftaylgqvhxvcodzfyocpzvcxmxeokldbfvpwjtnqlyabuysarnzmvhawcfgdoecusotpkwswptkigpcycionazkuqikzezpjxdcrfzwhtwtysbrfdrclrerviivzafksqgqicngfrwufcouwckhgylzdekwcjtdxtsxdijwvltnvwkawmmjumbahubzbskxxdjhel' AND `col_set_key` < 'jzrpwjizbaghxzhccbedtobeeoaljhfqqwdmvboxhlonkjszqwuekftaylgqvhxvcodzfyocpzvcxm' 2010-07-26T19:35:56 [21230] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > NULL AND `col_set` < 'qjzrpwjizbaghxzhccbedtobeeoaljhfqqwdmvboxhlonk' 2010-07-26T19:35:56 [21230] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob` > 'sqjzrpwjizbaghxzhccbedtobeeoalj' AND `pk` < '2004-09-03 10:40:42' 2010-07-26T19:35:56 [21227] Query: UPDATE `table100_innodb_int_autoinc` SET `pk` = 0 WHERE `pk` > 6 AND `col_set` < 3 2010-07-26T19:35:56 [21212] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set` = 4 WHERE `pk` > 7 AND `col_blob_key` < 'with' 2010-07-26T19:35:56 [21209] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_blob` ) VALUES ( 3 ) 2010-07-26T19:35:56 [21221] Query: INSERT INTO `table100_innodb_int_autoinc` ( `pk` ) VALUES ( 0 ) 2010-07-26T19:35:56 [21212] Query: INSERT INTO `table100_innodb_int_autoinc` ( `pk` ) VALUES ( 6 ) 2010-07-26T19:35:56 [21212] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set_key` = 9 WHERE `col_set` > '2005-10-27 04:35:03' AND `col_blob` < 2 2010-07-26T19:35:56 [21212] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set` = 9 WHERE `col_blob_key` > NULL AND `col_set_key` < '2004-08-04 14:01:35' 2010-07-26T19:35:56 [21233] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_set` ) VALUES ( 3 ) 2010-07-26T19:35:56 [21221] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set` > '2003-05-17 15:57:25' AND `col_blob_key` < NULL 2010-07-26T19:35:56 [21221] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set` = 3 WHERE `col_blob` > 1 AND `col_set_key` < 'as' 2010-07-26T19:35:56 [21215] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_blob_key` ) VALUES ( 8 ) 2010-07-26T19:35:56 [21218] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_blob` ) VALUES ( 8 ) 2010-07-26T19:35:56 [21215] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'can' AND `col_set_key` < NULL 2010-07-26T19:35:56 [21215] Query: UPDATE `table100_innodb_int_autoinc` SET `pk` = 7 WHERE `col_set` > '2003-11-05 12:14:38' AND `col_blob_key` < 0 2010-07-26T19:35:56 [21218] Query: UPDATE `table100_innodb_int_autoinc` SET `pk` = 1 WHERE `pk` > '2006-08-25 08:15:14' AND `col_set` < 0 2010-07-26T19:35:56 [21215] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob` > "can't" AND `col_blob` < '2006-07-21 12:51:34' 2010-07-26T19:35:56 [21218] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob` > 'can' AND `col_blob` < 'have' 2010-07-26T19:35:56 [21215] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob` > '2000-02-25 04:11:28' AND `col_blob` < NULL 2010-07-26T19:35:56 [21218] Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 8 WHERE `col_blob` > NULL AND `col_set` < 3 2010-07-26T19:35:56 [21206] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_blob` ) VALUES ( 7 ) 2010-07-26T19:35:56 [21209] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_blob_key` ) VALUES ( 7 ) 2010-07-26T19:35:56 [21212] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_set_key` ) VALUES ( 6 ) 2010-07-26T19:35:56 [21230] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_set` ) VALUES ( 1 ) 2010-07-26T19:35:56 [21233] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_set_key` ) VALUES ( 0 ) 2010-07-26T19:35:56 [21230] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob` > 8 AND `pk` < 'tell' 2010-07-26T19:35:56 [21212] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > 'hwisgyxpxvylwmbnmc' AND `col_set_key` < '2002-09-24 09:44:37' 2010-07-26T19:35:56 [21221] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_set_key` ) VALUES ( 4 ) 2010-07-26T19:35:56 [21209] Query: UPDATE `table100_innodb_int_autoinc` SET `pk` = 1 WHERE `col_blob` > NULL AND `col_blob_key` < 'hfvzelywjjvqduqwqqpqhgfgwtvggwarjrmgxp' 2010-07-26T19:35:56 [21221] Query: UPDATE `table100_innodb_int_autoinc` SET `pk` = 3 WHERE `col_set` > 'pvhnnnnctmhbzsxuulrnbeujarwwrjmuzyvjipdfhodkgvehatomvqwcevpyfqqlluiptwkjgsymizfddqciinbwuaiyufkigdebinqyggwaxmaoooqatnmfofyempvpmefpusoyvolkruvqmbjob' AND `col_blob` < '2006-09-16 01:58:46' 2010-07-26T19:35:56 [21227] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_set_key` ) VALUES ( 7 ) 2010-07-26T19:35:56 [21227] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob` > 'yopmfxdvxohupoicmnczwptehuymtyjejriwrhofbvxfxbxwkacwcyetcgurlcvgpfojidmiefcmztkntnwhbznvddaqxbczstbaoruxzvewtefanhawhqaklqpnqfzihwtcxakuuwvxtxnzzuwfxyuxplvflyrifpfidrobgefcqctfdsrcjqfcbefuudsssxxmyykmplzsusndtgvhrvqccxxczpkoercnkmkeeshhpmdzzfsxobim' AND `col_blob_key` < 'was' 2010-07-26T19:35:56 [21227] Query: INSERT INTO `table100_innodb_int_autoinc` ( `pk` ) VALUES ( 7 ) 2010-07-26T19:35:56 [21227] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob_key` > 'going' AND `pk` < 'she' 2010-07-26T19:35:56 [21224] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_blob_key` ) VALUES ( 6 ) 2010-07-26T19:35:56 [21206] Query: UPDATE `table100_innodb_int_autoinc` SET `pk` = 2 WHERE `pk` > 7 AND `col_set` < 'know' 2010-07-26T19:35:56 [21215] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_blob` ) VALUES ( 6 ) 2010-07-26T19:35:56 [21215] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob_key` > 9 AND `col_blob_key` < 'her' 2010-07-26T19:35:56 [21215] Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 1 WHERE `col_blob` > 'ddboumklbihcnexskyatndnlsbjvpbntwixrcqqrorvorcskkgwpndqhtjwfypekeedsquftjtbisdxukzedzvyqkhjdchtmmprlswsigdipu' AND `col_blob_key` < 7 2010-07-26T19:35:56 [21215] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob` > 8 AND `col_blob_key` < NULL 2010-07-26T19:35:56 [21215] Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 5 WHERE `col_blob_key` > 'v' AND `col_set` < 'here' 2010-07-26T19:35:56 [21215] Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 9 WHERE `col_set_key` > 5 AND `col_blob_key` < 'fvddboumklbihcnexskyatndnlsbjvpbntwixrcqqrorvorcskkgwpndqhtjwfypekeedsquftjtbisdxukzedzvyqkhjdchtmmpr' 2010-07-26T19:35:56 [21215] Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob` = 2 WHERE `col_set` > NULL AND `pk` < 'why' 2010-07-26T19:35:56 [21215] Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 5 WHERE `col_blob_key` > 'nfvddboumklbihcnexskyatndnlsbjvpbntwi' AND `col_blob` < 'onfvddboumklbihcnexskyatndnlsbjvpbntwixrcqqrorvorcskkgwpndqhtjwfypekeedsquftjtbisdxukzedzvyqkhjdchtmmprlswsigdipulrcbpmhwkkhpglmmkdrzuodbbjs' 2010-07-26T19:35:56 [21215] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob_key` > 'is' AND `col_set_key` < 'yonfvddboumklbihcnexskyatndnlsbjvpbntwixrcqqrorvorcskkgwpndqhtjwfypekeedsquftjtbisdxukzedzvyqkhjdchtmmprlswsigdipulrcbpmhwkkhpglmmkdrzuodbbjsbexbzhybdtdghnhqyfesoj' 2010-07-26T19:35:56 [21212] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set_key` > 0 AND `col_set` < 7 2010-07-26T19:35:56 [21227] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 1 AND `col_set` < 9 2010-07-26T19:35:56 [21233] Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 3 WHERE `col_set` > '2000-07-08 19:20:42' AND `col_blob_key` < 4 2010-07-26T19:35:56 [21218] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_set` > 0 AND `col_set` < 'zxsqseykasmxuzenjribgcxkttlgugmgjjfsipdimaeeakocabmnmzqeomhgvuexgyqtbqngkmupkksfxcyhvgdazbueuefxyjqcytnrtjlygorngnezcdxcmekjyjvajgyzxpukhsenojzfosqbtpszimznsxfelrlprsmijpgqlwrloryjxjoujnowflhlfqeevdqvijwkujgrc' 2010-07-26T19:35:56 [21233] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > '2007-04-20 22:05:22' AND `col_blob` < 'all' 2010-07-26T19:35:56 [21218] Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 0 WHERE `pk` > NULL AND `col_set_key` < 'mzxsqseykasmxuzenjribgcxkttlgugmgjjfsipdimaeeakocabmnmzqeomhgvuexgyqtbqngkmupkksfxcyhvgdazbueuefxyjqcytnrtjlygorngnezcdxcmekjyjvajgyzxpukhsenojzfosqbtpszimznsxfelrlprsmijpgqlwrloryjxjoujnowflhlfqeevdqvijwkujgrcnsjptfviqtpadwfmwtcjmxgiknroixbcqarpbknmdrmbl' 2010-07-26T19:35:56 [21233] Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob` = 8 WHERE `col_blob` > 'omoustczgdbyyeonpkvezbhnckopompbzqfpfktpryniobsnzmfbswxicphwjvpemairgedwqeychtyqauxmqvyaddgjx' AND `col_set` < 0 2010-07-26T19:35:56 [21218] Query: INSERT INTO `table100_innodb_int_autoinc` ( `pk` ) VALUES ( 3 ) 2010-07-26T19:35:56 [21230] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_blob_key` ) VALUES ( 9 ) 2010-07-26T19:35:56 [21230] Query: DELETE FROM `table100_innodb_int_autoinc` WHERE `col_blob` > NULL AND `col_blob` < 3 2010-07-26T19:35:56 [21230] Query: INSERT INTO `table100_innodb_int_autoinc` ( `pk` ) VALUES ( 5 ) 2010-07-26T19:35:56 [21209] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_set` ) VALUES ( 4 ) 2010-07-26T19:35:56 [21221] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_blob_key` ) VALUES ( 6 ) 2010-07-26T19:35:56 [21224] Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob` = 5 WHERE `col_blob_key` > '2005-12-19 11:17:22' AND `col_blob_key` < 'gjeppfmjxciwpehefddjz' 2010-07-26T19:35:56 [21224] Query: UPDATE `table100_innodb_int_autoinc` SET `col_blob_key` = 8 WHERE `pk` > 'they' AND `pk` < 'zgjeppfmjxciwpehefddjzhlkgmnlvjmmrmvylmatrlmbeitfkveflpmymhkdacuxqrigkciowsvjfacxbahbarqyfueptq' 2010-07-26T19:35:56 [21224] Query: UPDATE `table100_innodb_int_autoinc` SET `col_set` = 3 WHERE `col_blob` > 9 AND `col_set` < NULL 2010-07-26T19:35:56 [21206] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_set_key` ) VALUES ( 9 ) 2010-07-26T19:35:56 [21212] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_set` ) VALUES ( 3 ) 2010-07-26T19:35:56 [21209] Query: INSERT INTO `table100_innodb_int_autoinc` ( `col_blob` ) VALUES ( 2 ) # 2010-07-26T19:35:57 datadir is /tmp/51//master-data/ # 2010-07-26T19:35:57 binary is /mysql/mysql-5.1.49-linux-i686-glibc23//bin/mysqld # 2010-07-26T19:35:57 bindir is /mysql/mysql-5.1.49-linux-i686-glibc23//bin # 2010-07-26T19:35:57 core is # 2010-07-26T19:35:59 # 2010-07-26T19:35:59 # 2010-07-26T19:35:59 The last 100 lines from /randgen/new_testing/5/52.log : 100726 11:51:23 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 100726 11:51:24 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 11:51:24 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 11:51:24 InnoDB Plugin 1.0.10 started; log sequence number 0 100726 11:51:24 [Warning] /mysql/mysql-5.1.49-linux-i686-glibc23/bin/mysqld: unknown option '--loose-skip-ndbcluster' 100726 11:51:24 [Warning] /mysql/mysql-5.1.49-linux-i686-glibc23/bin/mysqld: unknown variable 'loose-falcon-debug-mask=2' 100726 11:51:24 [Note] Event Scheduler: Loaded 0 events 100726 11:51:24 [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) 100726 12:35:45 [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 12:35:45 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 100726 12:35:45 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 12:35:45 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 12:35:45 InnoDB Plugin 1.0.10 started; log sequence number 0 100726 12:35:45 [Warning] /mysql/mysql-5.1.49-linux-i686-glibc23/bin/mysqld: unknown option '--loose-skip-ndbcluster' 100726 12:35:45 [Warning] /mysql/mysql-5.1.49-linux-i686-glibc23/bin/mysqld: unknown variable 'loose-falcon-debug-mask=2' 100726 12:35:45 [Note] Event Scheduler: Loaded 0 events 100726 12:35:45 [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 813366143 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 12:35:56 InnoDB: Assertion failure in thread 2814393232 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 12:35:56 - 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] [0xb77d7400] /lib/tls/i686/cmov/libc.so.6(abort+0x188)[0xb7600098] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6c0db8c] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6bece87] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6bed1af] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6be46dd] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6bd0d05] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6bd6bdd] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6c8115d] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6c818dd] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6c6b11a] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6c9e073] /mysql/mysql-5.1.49-linux-i686-glibc23/lib/plugin//ha_innodb_plugin.so[0xb6c952bd] /lib/tls/i686/cmov/libpthread.so.0[0xb77b24ff] /lib/tls/i686/cmov/libc.so.6(clone+0x5e)[0xb76b75ee] 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-26T19:35:59 datadir is /tmp/52//master-data/ # 2010-07-26T19:35:59 binary is /mysql/mysql-5.1.49-linux-i686-glibc23//bin/mysqld # 2010-07-26T19:35:59 bindir is /mysql/mysql-5.1.49-linux-i686-glibc23//bin # 2010-07-26T19:35:59 core is /tmp/52//master-data//core # 2010-07-26T19:35:59 Core was generated by `/mysql/mysql-5.1.49-linux-i686-glibc23/bin/mysqld --no-defaults --basedir=/mysq'. # 2010-07-26T19:35:59 Program terminated with signal 6, Aborted. # 2010-07-26T19:35:59 [New process 21192] # 2010-07-26T19:35:59 [New process 21193] # 2010-07-26T19:35:59 [New process 21191] # 2010-07-26T19:35:59 [New process 21190] # 2010-07-26T19:35:59 [New process 21226] # 2010-07-26T19:35:59 [New process 21177] # 2010-07-26T19:35:59 [New process 21181] # 2010-07-26T19:35:59 [New process 21179] # 2010-07-26T19:35:59 [New process 21183] # 2010-07-26T19:35:59 [New process 21185] # 2010-07-26T19:35:59 [New process 21180] # 2010-07-26T19:35:59 [New process 21187] # 2010-07-26T19:35:59 [New process 21182] # 2010-07-26T19:35:59 [New process 21184] # 2010-07-26T19:35:59 [New process 21189] # 2010-07-26T19:35:59 [New process 21188] # 2010-07-26T19:35:59 [New process 21186] # 2010-07-26T19:35:59 [New process 21220] # 2010-07-26T19:35:59 [New process 21223] # 2010-07-26T19:35:59 [New process 21211] # 2010-07-26T19:35:59 [New process 21229] # 2010-07-26T19:35:59 [New process 21232] # 2010-07-26T19:35:59 [New process 21208] # 2010-07-26T19:35:59 [New process 21235] # 2010-07-26T19:35:59 [New process 21217] # 2010-07-26T19:35:59 [New process 21214] # 2010-07-26T19:35:59 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:35:59 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:35:59 #1 0xb77b71c8 in pthread_kill () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:35:59 #2 0x084e370b in my_write_core (sig=6) at stacktrace.c:329 # 2010-07-26T19:35:59 #3 0x08206670 in handle_segfault (sig=6) at mysqld.cc:2605 # 2010-07-26T19:35:59 #4 # 2010-07-26T19:35:59 #5 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:35:59 #6 0xb75fe6d0 in raise () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:35:59 #7 0xb7600098 in abort () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:35:59 #8 0xb6c0db8c in fil_io (type=10, sync=1, space_id=0, zip_size=0, block_offset=813366143, byte_offset=0, len=16384, buf=0xaf13c000, message=0xae8fbc90) at fil/fil0fil.c:4306 # 2010-07-26T19:35:59 #9 0xb6bece87 in buf_read_page_low (err=0xa7c02618, sync=1, mode=132, space=0, zip_size=0, unzip=0, tablespace_version=1, offset=813367295) at buf/buf0rea.c:145 # 2010-07-26T19:35:59 #10 0xb6bed1af in buf_read_page (space=0, zip_size=0, offset=813367295) at buf/buf0rea.c:183 # 2010-07-26T19:35:59 #11 0xb6be46dd in buf_page_get_gen (space=0, zip_size=0, offset=813367295, rw_latch=2, guess=0x0, mode=10, file=0xb6cb8779 "btr/btr0cur.c", line=4313, mtr=0xa7c026f8) # 2010-07-26T19:35:59 at buf/buf0buf.c:2095 # 2010-07-26T19:35:59 #12 0xb6bd0d05 in btr_free_externally_stored_field (index=0xa94cab8, field_ref=0xaedd113c "", rec=0xaedd0e27 "\200", offsets=0xa9e71b8, page_zip=0x0, i=4, rb_ctx=RB_NONE, # 2010-07-26T19:35:59 local_mtr=0xa7c02c24) at btr/btr0cur.c:4312 # 2010-07-26T19:35:59 #13 0xb6bd6bdd in btr_cur_pessimistic_delete (err=0xa7c0320c, has_reserved_extents=0, cursor=0xa8e9cd0, rb_ctx=RB_NONE, mtr=0xa7c02c24) at btr/btr0cur.c:4414 # 2010-07-26T19:35:59 #14 0xb6c8115d in row_purge_remove_clust_if_poss_low (node=0xa8e9c90, mode=33) at row/row0purge.c:175 # 2010-07-26T19:35:59 #15 0xb6c818dd in row_purge_step (thr=0xa8e9c30) at row/row0purge.c:212 # 2010-07-26T19:35:59 #16 0xb6c6b11a in que_run_threads (thr=0xa8e9c30) at que/que0que.c:1248 # 2010-07-26T19:35:59 #17 0xb6c9e073 in trx_purge () at trx/trx0purge.c:1177 # 2010-07-26T19:35:59 #18 0xb6c952bd in srv_master_thread (arg=0x0) at srv/srv0srv.c:2601 # 2010-07-26T19:35:59 #19 0xb77b24ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:35:59 #20 0xb76b75ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:35:59 #5 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:35:59 in mysqld.cc # 2010-07-26T19:36:00 Core was generated by `/mysql/mysql-5.1.49-linux-i686-glibc23/bin/mysqld --no-defaults --basedir=/mysq'. # 2010-07-26T19:36:00 Program terminated with signal 6, Aborted. # 2010-07-26T19:36:00 [New process 21192] # 2010-07-26T19:36:00 [New process 21193] # 2010-07-26T19:36:00 [New process 21191] # 2010-07-26T19:36:00 [New process 21190] # 2010-07-26T19:36:00 [New process 21226] # 2010-07-26T19:36:00 [New process 21177] # 2010-07-26T19:36:00 [New process 21181] # 2010-07-26T19:36:00 [New process 21179] # 2010-07-26T19:36:00 [New process 21183] # 2010-07-26T19:36:00 [New process 21185] # 2010-07-26T19:36:00 [New process 21180] # 2010-07-26T19:36:00 [New process 21187] # 2010-07-26T19:36:00 [New process 21182] # 2010-07-26T19:36:00 [New process 21184] # 2010-07-26T19:36:00 [New process 21189] # 2010-07-26T19:36:00 [New process 21188] # 2010-07-26T19:36:00 [New process 21186] # 2010-07-26T19:36:00 [New process 21220] # 2010-07-26T19:36:00 [New process 21223] # 2010-07-26T19:36:00 [New process 21211] # 2010-07-26T19:36:00 [New process 21229] # 2010-07-26T19:36:00 [New process 21232] # 2010-07-26T19:36:00 [New process 21208] # 2010-07-26T19:36:00 [New process 21235] # 2010-07-26T19:36:00 [New process 21217] # 2010-07-26T19:36:00 [New process 21214] # 2010-07-26T19:36:00 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:36:00 # 2010-07-26T19:36:00 Thread 26 (process 21214): # 2010-07-26T19:36:00 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:36:00 #1 0xb77b970f in fsync () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #2 0xb6c49fbb in os_file_flush (file=8) at os/os0file.c:1933 # 2010-07-26T19:36:00 #3 0xb6c0792f in fil_flush (space_id=4294967280) at fil/fil0fil.c:4550 # 2010-07-26T19:36:00 #4 0xb6c3e48c in log_write_up_to (lsn=4311619, wait=92, flush_to_disk=1) at log/log0log.c:1496 # 2010-07-26T19:36:00 #5 0xb6caaac5 in trx_commit_complete_for_mysql (trx=0xa9bd908) at trx/trx0trx.c:1601 # 2010-07-26T19:36:00 #6 0xb6c21065 in innobase_commit (hton=0xa30ec38, thd=0xa9bf1c0, all=false) at handler/ha_innodb.cc:2531 # 2010-07-26T19:36:00 #7 0x082fe2ee in ha_commit_trans (thd=0xa9bf1c0, all=false) at handler.cc:1233 # 2010-07-26T19:36:00 #8 0x082fe680 in ha_autocommit_or_rollback (thd=0xa9bf1c0, error=0) at handler.cc:1367 # 2010-07-26T19:36:00 #9 0x0821e27d in dispatch_command (command=COM_QUERY, thd=0xa9bf1c0, packet=0xa9c0b79 "INSERT INTO `table100_innodb_int_autoinc` ( `col_set` ) VALUES ( 3 )", packet_length=68) # 2010-07-26T19:36:00 at sql_parse.cc:1657 # 2010-07-26T19:36:00 #10 0x0821fc60 in do_command (thd=0xa9bf1c0) at sql_parse.cc:882 # 2010-07-26T19:36:00 #11 0x082101e3 in handle_one_connection (arg=0xa9bf1c0) at sql_connect.cc:1136 # 2010-07-26T19:36:00 #12 0xb77b24ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #13 0xb76b75ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 # 2010-07-26T19:36:00 Thread 25 (process 21217): # 2010-07-26T19:36:00 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:36:00 #1 0xb77b60e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #2 0xb6c4e3b5 in os_event_wait_low (event=0xa8e5128, reset_sig_count=0) at os/os0sync.c:399 # 2010-07-26T19:36:00 #3 0xb6caaac5 in trx_commit_complete_for_mysql (trx=0xa9be1a8) at trx/trx0trx.c:1601 # 2010-07-26T19:36:00 #4 0xb6c21065 in innobase_commit (hton=0xa30ec38, thd=0xa9aafb0, all=false) at handler/ha_innodb.cc:2531 # 2010-07-26T19:36:00 #5 0x082fe2ee in ha_commit_trans (thd=0xa9aafb0, all=false) at handler.cc:1233 # 2010-07-26T19:36:00 #6 0x082fe680 in ha_autocommit_or_rollback (thd=0xa9aafb0, error=0) at handler.cc:1367 # 2010-07-26T19:36:00 #7 0x0821e27d in dispatch_command (command=COM_QUERY, thd=0xa9aafb0, packet=0xa9a3179 "INSERT INTO `table100_innodb_int_autoinc` ( `col_blob_key` ) VALUES ( 4 )", # 2010-07-26T19:36:00 packet_length=73) at sql_parse.cc:1657 # 2010-07-26T19:36:00 #8 0x0821fc60 in do_command (thd=0xa9aafb0) at sql_parse.cc:882 # 2010-07-26T19:36:00 #9 0x082101e3 in handle_one_connection (arg=0xa9aafb0) at sql_connect.cc:1136 # 2010-07-26T19:36:00 #10 0xb77b24ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #11 0xb76b75ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 # 2010-07-26T19:36:00 Thread 24 (process 21235): # 2010-07-26T19:36:00 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:36:00 #1 0xb77b60e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #2 0xb6c4e3b5 in os_event_wait_low (event=0xa8e50c0, reset_sig_count=0) at os/os0sync.c:399 # 2010-07-26T19:36:00 #3 0xb6c3df2e in log_write_up_to (lsn=4311920, wait=92, flush_to_disk=1) at log/log0log.c:1404 # 2010-07-26T19:36:00 #4 0xb6caaac5 in trx_commit_complete_for_mysql (trx=0xa995890) at trx/trx0trx.c:1601 # 2010-07-26T19:36:00 #5 0xb6c21065 in innobase_commit (hton=0xa30ec38, thd=0xa991e80, all=false) at handler/ha_innodb.cc:2531 # 2010-07-26T19:36:00 #6 0x082fe2ee in ha_commit_trans (thd=0xa991e80, all=false) at handler.cc:1233 # 2010-07-26T19:36:00 #7 0x082fe680 in ha_autocommit_or_rollback (thd=0xa991e80, error=0) at handler.cc:1367 # 2010-07-26T19:36:00 #8 0x0821e27d in dispatch_command (command=COM_QUERY, thd=0xa991e80, packet=0xa9dd1a9 "INSERT INTO `table100_innodb_int_autoinc` ( `col_set` ) VALUES ( 5 )", packet_length=68) # 2010-07-26T19:36:00 at sql_parse.cc:1657 # 2010-07-26T19:36:00 #9 0x0821fc60 in do_command (thd=0xa991e80) at sql_parse.cc:882 # 2010-07-26T19:36:00 #10 0x082101e3 in handle_one_connection (arg=0xa991e80) at sql_connect.cc:1136 # 2010-07-26T19:36:00 #11 0xb77b24ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #12 0xb76b75ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 # 2010-07-26T19:36:00 Thread 23 (process 21208): # 2010-07-26T19:36:00 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:36:00 #1 0xb77b90fb in read () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #2 0x081fab3f in my_real_read (net=0xa304de0, complen=0xa73d1328) at net_serv.cc:816 # 2010-07-26T19:36:00 #3 0x081fb122 in my_net_read (net=0xa304de0) at net_serv.cc:1011 # 2010-07-26T19:36:00 #4 0x0821fbeb in do_command (thd=0xa304d68) at sql_parse.cc:824 # 2010-07-26T19:36:00 #5 0x082101e3 in handle_one_connection (arg=0xa304d68) at sql_connect.cc:1136 # 2010-07-26T19:36:00 #6 0xb77b24ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #7 0xb76b75ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 # 2010-07-26T19:36:00 Thread 22 (process 21232): # 2010-07-26T19:36:00 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:36:00 #1 0xb77b60e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #2 0xb6c4e3b5 in os_event_wait_low (event=0xa8e50c0, reset_sig_count=0) at os/os0sync.c:399 # 2010-07-26T19:36:00 #3 0xb6c3df2e in log_write_up_to (lsn=4334968, wait=92, flush_to_disk=1) at log/log0log.c:1404 # 2010-07-26T19:36:00 #4 0xb6caaac5 in trx_commit_complete_for_mysql (trx=0xa998d50) at trx/trx0trx.c:1601 # 2010-07-26T19:36:00 #5 0xb6c21065 in innobase_commit (hton=0xa30ec38, thd=0xa997358, all=false) at handler/ha_innodb.cc:2531 # 2010-07-26T19:36:00 #6 0x082fe2ee in ha_commit_trans (thd=0xa997358, all=false) at handler.cc:1233 # 2010-07-26T19:36:00 #7 0x082fe680 in ha_autocommit_or_rollback (thd=0xa997358, error=0) at handler.cc:1367 # 2010-07-26T19:36:00 #8 0x0821e27d in dispatch_command (command=COM_QUERY, thd=0xa997358, # 2010-07-26T19:36:00 packet=0xa98bee1 "DELETE FROM `table100_innodb_int_autoinc` WHERE `pk` > 'back' AND `col_blob_key` < 'look'", packet_length=89) at sql_parse.cc:1657 # 2010-07-26T19:36:00 #9 0x0821fc60 in do_command (thd=0xa997358) at sql_parse.cc:882 # 2010-07-26T19:36:00 #10 0x082101e3 in handle_one_connection (arg=0xa997358) at sql_connect.cc:1136 # 2010-07-26T19:36:00 #11 0xb77b24ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #12 0xb76b75ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 # 2010-07-26T19:36:00 Thread 21 (process 21229): # 2010-07-26T19:36:00 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:36:00 #1 0xb77b60e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #2 0xb6c4e3b5 in os_event_wait_low (event=0xa8e50c0, reset_sig_count=0) at os/os0sync.c:399 # 2010-07-26T19:36:00 #3 0xb6c3df2e in log_write_up_to (lsn=4312107, wait=92, flush_to_disk=1) at log/log0log.c:1404 # 2010-07-26T19:36:00 #4 0xb6caaac5 in trx_commit_complete_for_mysql (trx=0xa97fab0) at trx/trx0trx.c:1601 # 2010-07-26T19:36:00 #5 0xb6c21065 in innobase_commit (hton=0xa30ec38, thd=0xa97e0b8, all=false) at handler/ha_innodb.cc:2531 # 2010-07-26T19:36:00 #6 0x082fe2ee in ha_commit_trans (thd=0xa97e0b8, all=false) at handler.cc:1233 # 2010-07-26T19:36:00 #7 0x082fe680 in ha_autocommit_or_rollback (thd=0xa97e0b8, error=0) at handler.cc:1367 # 2010-07-26T19:36:00 #8 0x0821e27d in dispatch_command (command=COM_QUERY, thd=0xa97e0b8, packet=0xa981ea9 "INSERT INTO `table100_innodb_int_autoinc` ( `col_blob_key` ) VALUES ( 7 )", # 2010-07-26T19:36:00 packet_length=73) at sql_parse.cc:1657 # 2010-07-26T19:36:00 #9 0x0821fc60 in do_command (thd=0xa97e0b8) at sql_parse.cc:882 # 2010-07-26T19:36:00 #10 0x082101e3 in handle_one_connection (arg=0xa97e0b8) at sql_connect.cc:1136 # 2010-07-26T19:36:00 #11 0xb77b24ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #12 0xb76b75ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 # 2010-07-26T19:36:00 Thread 20 (process 21211): # 2010-07-26T19:36:00 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:36:00 #1 0xb77b90fb in read () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #2 0x081fab3f in my_real_read (net=0xa9c89a8, complen=0xa73a0328) at net_serv.cc:816 # 2010-07-26T19:36:00 #3 0x081fb122 in my_net_read (net=0xa9c89a8) at net_serv.cc:1011 # 2010-07-26T19:36:00 #4 0x0821fbeb in do_command (thd=0xa9c8930) at sql_parse.cc:824 # 2010-07-26T19:36:00 #5 0x082101e3 in handle_one_connection (arg=0xa9c8930) at sql_connect.cc:1136 # 2010-07-26T19:36:00 #6 0xb77b24ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #7 0xb76b75ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 # 2010-07-26T19:36:00 Thread 19 (process 21223): # 2010-07-26T19:36:00 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:36:00 #1 0xb77b90fb in read () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #2 0x081fab3f in my_real_read (net=0xa95ef10, complen=0xa72dc328) at net_serv.cc:816 # 2010-07-26T19:36:00 #3 0x081fb122 in my_net_read (net=0xa95ef10) at net_serv.cc:1011 # 2010-07-26T19:36:00 #4 0x0821fbeb in do_command (thd=0xa95ee98) at sql_parse.cc:824 # 2010-07-26T19:36:00 #5 0x082101e3 in handle_one_connection (arg=0xa95ee98) at sql_connect.cc:1136 # 2010-07-26T19:36:00 #6 0xb77b24ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #7 0xb76b75ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 # 2010-07-26T19:36:00 Thread 18 (process 21220): # 2010-07-26T19:36:00 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:36:00 #1 0xb77b60e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #2 0xb6c4e3b5 in os_event_wait_low (event=0xa8e50c0, reset_sig_count=0) at os/os0sync.c:399 # 2010-07-26T19:36:00 #3 0xb6c3df2e in log_write_up_to (lsn=4311927, wait=92, flush_to_disk=1) at log/log0log.c:1404 # 2010-07-26T19:36:00 #4 0xb6caaac5 in trx_commit_complete_for_mysql (trx=0xa9534e8) at trx/trx0trx.c:1601 # 2010-07-26T19:36:00 #5 0xb6c21065 in innobase_commit (hton=0xa30ec38, thd=0xa951a40, all=false) at handler/ha_innodb.cc:2531 # 2010-07-26T19:36:00 #6 0x082fe2ee in ha_commit_trans (thd=0xa951a40, all=false) at handler.cc:1233 # 2010-07-26T19:36:00 #7 0x082fe680 in ha_autocommit_or_rollback (thd=0xa951a40, error=0) at handler.cc:1367 # 2010-07-26T19:36:00 #8 0x0821e27d in dispatch_command (command=COM_QUERY, thd=0xa951a40, packet=0xa9539e9 "INSERT INTO `table100_innodb_int_autoinc` ( `col_set` ) VALUES ( 6 )", packet_length=68) # 2010-07-26T19:36:00 at sql_parse.cc:1657 # 2010-07-26T19:36:00 #9 0x0821fc60 in do_command (thd=0xa951a40) at sql_parse.cc:882 # 2010-07-26T19:36:00 #10 0x082101e3 in handle_one_connection (arg=0xa951a40) at sql_connect.cc:1136 # 2010-07-26T19:36:00 #11 0xb77b24ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #12 0xb76b75ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 # 2010-07-26T19:36:00 Thread 17 (process 21186): # 2010-07-26T19:36:00 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:36:00 #1 0xb77b60e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #2 0xb6c4e3b5 in os_event_wait_low (event=0xa647488, reset_sig_count=0) at os/os0sync.c:399 # 2010-07-26T19:36:00 #3 0xb6c4be48 in os_aio_simulated_handle (global_segment=7, message1=0xaae9738c, message2=0xaae97388, type=0xaae97384) at os/os0file.c:4199 # 2010-07-26T19:36:00 #4 0xb6c07385 in fil_aio_wait (segment=7) at fil/fil0fil.c:4439 # 2010-07-26T19:36:00 #5 0xb6c98668 in io_handler_thread (arg=0xb6cdc37c) at srv/srv0start.c:475 # 2010-07-26T19:36:00 #6 0xb77b24ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #7 0xb76b75ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 # 2010-07-26T19:36:00 Thread 16 (process 21188): # 2010-07-26T19:36:00 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:36:00 #1 0xb77b60e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #2 0xb6c4e3b5 in os_event_wait_low (event=0xa647558, reset_sig_count=0) at os/os0sync.c:399 # 2010-07-26T19:36:00 #3 0xb6c4be48 in os_aio_simulated_handle (global_segment=9, message1=0xa9e9538c, message2=0xa9e95388, type=0xa9e95384) at os/os0file.c:4199 # 2010-07-26T19:36:00 #4 0xb6c07385 in fil_aio_wait (segment=9) at fil/fil0fil.c:4439 # 2010-07-26T19:36:00 #5 0xb6c98668 in io_handler_thread (arg=0xb6cdc384) at srv/srv0start.c:475 # 2010-07-26T19:36:00 #6 0xb77b24ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #7 0xb76b75ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 # 2010-07-26T19:36:00 Thread 15 (process 21189): # 2010-07-26T19:36:00 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:36:00 #1 0xb76af8d1 in select () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 #2 0xb6c4efce in os_thread_sleep (tm=0) at os/os0thread.c:295 # 2010-07-26T19:36:00 #3 0xb6c93bac in srv_lock_timeout_thread (arg=0x0) at srv/srv0srv.c:2139 # 2010-07-26T19:36:00 #4 0xb77b24ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #5 0xb76b75ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 # 2010-07-26T19:36:00 Thread 14 (process 21184): # 2010-07-26T19:36:00 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:36:00 #1 0xb77b60e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #2 0xb6c4e3b5 in os_event_wait_low (event=0xa6473b8, reset_sig_count=0) at os/os0sync.c:399 # 2010-07-26T19:36:00 #3 0xb6c4be48 in os_aio_simulated_handle (global_segment=5, message1=0xabe9938c, message2=0xabe99388, type=0xabe99384) at os/os0file.c:4199 # 2010-07-26T19:36:00 #4 0xb6c07385 in fil_aio_wait (segment=5) at fil/fil0fil.c:4439 # 2010-07-26T19:36:00 #5 0xb6c98668 in io_handler_thread (arg=0xb6cdc374) at srv/srv0start.c:475 # 2010-07-26T19:36:00 #6 0xb77b24ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #7 0xb76b75ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 # 2010-07-26T19:36:00 Thread 13 (process 21182): # 2010-07-26T19:36:00 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:36:00 #1 0xb77b60e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #2 0xb6c4e3b5 in os_event_wait_low (event=0xa6472e8, reset_sig_count=0) at os/os0sync.c:399 # 2010-07-26T19:36:00 #3 0xb6c4be48 in os_aio_simulated_handle (global_segment=3, message1=0xace9b38c, message2=0xace9b388, type=0xace9b384) at os/os0file.c:4199 # 2010-07-26T19:36:00 #4 0xb6c07385 in fil_aio_wait (segment=3) at fil/fil0fil.c:4439 # 2010-07-26T19:36:00 #5 0xb6c98668 in io_handler_thread (arg=0xb6cdc36c) at srv/srv0start.c:475 # 2010-07-26T19:36:00 #6 0xb77b24ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #7 0xb76b75ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 # 2010-07-26T19:36:00 Thread 12 (process 21187): # 2010-07-26T19:36:00 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:36:00 #1 0xb77b60e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #2 0xb6c4e3b5 in os_event_wait_low (event=0xa6474f0, reset_sig_count=0) at os/os0sync.c:399 # 2010-07-26T19:36:00 #3 0xb6c4be48 in os_aio_simulated_handle (global_segment=8, message1=0xaa69638c, message2=0xaa696388, type=0xaa696384) at os/os0file.c:4199 # 2010-07-26T19:36:00 #4 0xb6c07385 in fil_aio_wait (segment=8) at fil/fil0fil.c:4439 # 2010-07-26T19:36:00 #5 0xb6c98668 in io_handler_thread (arg=0xb6cdc380) at srv/srv0start.c:475 # 2010-07-26T19:36:00 #6 0xb77b24ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #7 0xb76b75ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 # 2010-07-26T19:36:00 Thread 11 (process 21180): # 2010-07-26T19:36:00 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:36:00 #1 0xb77b60e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #2 0xb6c4e3b5 in os_event_wait_low (event=0xa647218, reset_sig_count=0) at os/os0sync.c:399 # 2010-07-26T19:36:00 #3 0xb6c4be48 in os_aio_simulated_handle (global_segment=1, message1=0xade9d38c, message2=0xade9d388, type=0xade9d384) at os/os0file.c:4199 # 2010-07-26T19:36:00 #4 0xb6c07385 in fil_aio_wait (segment=1) at fil/fil0fil.c:4439 # 2010-07-26T19:36:00 #5 0xb6c98668 in io_handler_thread (arg=0xb6cdc364) at srv/srv0start.c:475 # 2010-07-26T19:36:00 #6 0xb77b24ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #7 0xb76b75ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 # 2010-07-26T19:36:00 Thread 10 (process 21185): # 2010-07-26T19:36:00 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:36:00 #1 0xb77b60e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #2 0xb6c4e3b5 in os_event_wait_low (event=0xa647420, reset_sig_count=0) at os/os0sync.c:399 # 2010-07-26T19:36:00 #3 0xb6c4be48 in os_aio_simulated_handle (global_segment=6, message1=0xab69838c, message2=0xab698388, type=0xab698384) at os/os0file.c:4199 # 2010-07-26T19:36:00 #4 0xb6c07385 in fil_aio_wait (segment=6) at fil/fil0fil.c:4439 # 2010-07-26T19:36:00 #5 0xb6c98668 in io_handler_thread (arg=0xb6cdc378) at srv/srv0start.c:475 # 2010-07-26T19:36:00 #6 0xb77b24ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #7 0xb76b75ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 # 2010-07-26T19:36:00 Thread 9 (process 21183): # 2010-07-26T19:36:00 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:36:00 #1 0xb77b60e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #2 0xb6c4e3b5 in os_event_wait_low (event=0xa647350, reset_sig_count=0) at os/os0sync.c:399 # 2010-07-26T19:36:00 #3 0xb6c4be48 in os_aio_simulated_handle (global_segment=4, message1=0xac69a38c, message2=0xac69a388, type=0xac69a384) at os/os0file.c:4199 # 2010-07-26T19:36:00 #4 0xb6c07385 in fil_aio_wait (segment=4) at fil/fil0fil.c:4439 # 2010-07-26T19:36:00 #5 0xb6c98668 in io_handler_thread (arg=0xb6cdc370) at srv/srv0start.c:475 # 2010-07-26T19:36:00 #6 0xb77b24ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #7 0xb76b75ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 # 2010-07-26T19:36:00 Thread 8 (process 21179): # 2010-07-26T19:36:00 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:36:00 #1 0xb77b60e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #2 0xb6c4e3b5 in os_event_wait_low (event=0xa6471b0, reset_sig_count=0) at os/os0sync.c:399 # 2010-07-26T19:36:00 #3 0xb6c4be48 in os_aio_simulated_handle (global_segment=0, message1=0xb75d038c, message2=0xb75d0388, type=0xb75d0384) at os/os0file.c:4199 # 2010-07-26T19:36:00 #4 0xb6c07385 in fil_aio_wait (segment=0) at fil/fil0fil.c:4439 # 2010-07-26T19:36:00 #5 0xb6c98668 in io_handler_thread (arg=0xb6cdc360) at srv/srv0start.c:475 # 2010-07-26T19:36:00 #6 0xb77b24ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #7 0xb76b75ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 # 2010-07-26T19:36:00 Thread 7 (process 21181): # 2010-07-26T19:36:00 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:36:00 #1 0xb77b60e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #2 0xb6c4e3b5 in os_event_wait_low (event=0xa647280, reset_sig_count=0) at os/os0sync.c:399 # 2010-07-26T19:36:00 #3 0xb6c4be48 in os_aio_simulated_handle (global_segment=2, message1=0xad69c38c, message2=0xad69c388, type=0xad69c384) at os/os0file.c:4199 # 2010-07-26T19:36:00 #4 0xb6c07385 in fil_aio_wait (segment=2) at fil/fil0fil.c:4439 # 2010-07-26T19:36:00 #5 0xb6c98668 in io_handler_thread (arg=0xb6cdc368) at srv/srv0start.c:475 # 2010-07-26T19:36:00 #6 0xb77b24ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #7 0xb76b75ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 # 2010-07-26T19:36:00 Thread 6 (process 21177): # 2010-07-26T19:36:00 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:36:00 #1 0xb76af8d1 in select () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 #2 0x0820ae12 in handle_connections_sockets (arg=0x0) at mysqld.cc:5103 # 2010-07-26T19:36:00 #3 0x0820bad7 in main (argc=24576, argv=0x0) at mysqld.cc:4587 # 2010-07-26T19:36:00 # 2010-07-26T19:36:00 Thread 5 (process 21226): # 2010-07-26T19:36:00 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:36:00 #1 0xb77b90fb in read () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #2 0x081fab3f in my_real_read (net=0xa971728, complen=0xa72ab328) at net_serv.cc:816 # 2010-07-26T19:36:00 #3 0x081fb122 in my_net_read (net=0xa971728) at net_serv.cc:1011 # 2010-07-26T19:36:00 #4 0x0821fbeb in do_command (thd=0xa9716b0) at sql_parse.cc:824 # 2010-07-26T19:36:00 #5 0x082101e3 in handle_one_connection (arg=0xa9716b0) at sql_connect.cc:1136 # 2010-07-26T19:36:00 #6 0xb77b24ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #7 0xb76b75ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 # 2010-07-26T19:36:00 Thread 4 (process 21190): # 2010-07-26T19:36:00 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:36:00 #1 0xb76af8d1 in select () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 #2 0xb6c4efce in os_thread_sleep (tm=0) at os/os0thread.c:295 # 2010-07-26T19:36:00 #3 0xb6c93da1 in srv_error_monitor_thread (arg=0x0) at srv/srv0srv.c:2304 # 2010-07-26T19:36:00 #4 0xb77b24ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #5 0xb76b75ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 # 2010-07-26T19:36:00 Thread 3 (process 21191): # 2010-07-26T19:36:00 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:36:00 #1 0xb76af8d1 in select () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 #2 0xb6c4efce in os_thread_sleep (tm=0) at os/os0thread.c:295 # 2010-07-26T19:36:00 #3 0xb6c945bb in srv_monitor_thread (arg=0x0) at srv/srv0srv.c:1997 # 2010-07-26T19:36:00 #4 0xb77b24ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #5 0xb76b75ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 # 2010-07-26T19:36:00 Thread 2 (process 21193): # 2010-07-26T19:36:00 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:36:00 #1 0xb77ba300 in sigwait () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #2 0x08206014 in signal_hand (arg=0x0) at mysqld.cc:2807 # 2010-07-26T19:36:00 #3 0xb77b24ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #4 0xb76b75ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 # 2010-07-26T19:36:00 Thread 1 (process 21192): # 2010-07-26T19:36:00 #0 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:36:00 #1 0xb77b71c8 in pthread_kill () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #2 0x084e370b in my_write_core (sig=6) at stacktrace.c:329 # 2010-07-26T19:36:00 #3 0x08206670 in handle_segfault (sig=6) at mysqld.cc:2605 # 2010-07-26T19:36:00 #4 # 2010-07-26T19:36:00 #5 0xb77d7430 in __kernel_vsyscall () # 2010-07-26T19:36:00 #6 0xb75fe6d0 in raise () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 #7 0xb7600098 in abort () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 #8 0xb6c0db8c in fil_io (type=10, sync=1, space_id=0, zip_size=0, block_offset=813366143, byte_offset=0, len=16384, buf=0xaf13c000, message=0xae8fbc90) at fil/fil0fil.c:4306 # 2010-07-26T19:36:00 #9 0xb6bece87 in buf_read_page_low (err=0xa7c02618, sync=1, mode=132, space=0, zip_size=0, unzip=0, tablespace_version=1, offset=813367295) at buf/buf0rea.c:145 # 2010-07-26T19:36:00 #10 0xb6bed1af in buf_read_page (space=0, zip_size=0, offset=813367295) at buf/buf0rea.c:183 # 2010-07-26T19:36:00 #11 0xb6be46dd in buf_page_get_gen (space=0, zip_size=0, offset=813367295, rw_latch=2, guess=0x0, mode=10, file=0xb6cb8779 "btr/btr0cur.c", line=4313, mtr=0xa7c026f8) # 2010-07-26T19:36:00 at buf/buf0buf.c:2095 # 2010-07-26T19:36:00 #12 0xb6bd0d05 in btr_free_externally_stored_field (index=0xa94cab8, field_ref=0xaedd113c "", rec=0xaedd0e27 "\200", offsets=0xa9e71b8, page_zip=0x0, i=4, rb_ctx=RB_NONE, # 2010-07-26T19:36:00 local_mtr=0xa7c02c24) at btr/btr0cur.c:4312 # 2010-07-26T19:36:00 #13 0xb6bd6bdd in btr_cur_pessimistic_delete (err=0xa7c0320c, has_reserved_extents=0, cursor=0xa8e9cd0, rb_ctx=RB_NONE, mtr=0xa7c02c24) at btr/btr0cur.c:4414 # 2010-07-26T19:36:00 #14 0xb6c8115d in row_purge_remove_clust_if_poss_low (node=0xa8e9c90, mode=33) at row/row0purge.c:175 # 2010-07-26T19:36:00 #15 0xb6c818dd in row_purge_step (thr=0xa8e9c30) at row/row0purge.c:212 # 2010-07-26T19:36:00 #16 0xb6c6b11a in que_run_threads (thr=0xa8e9c30) at que/que0que.c:1248 # 2010-07-26T19:36:00 #17 0xb6c9e073 in trx_purge () at trx/trx0purge.c:1177 # 2010-07-26T19:36:00 #18 0xb6c952bd in srv_master_thread (arg=0x0) at srv/srv0srv.c:2601 # 2010-07-26T19:36:00 #19 0xb77b24ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-07-26T19:36:00 #20 0xb76b75ee in clone () from /lib/tls/i686/cmov/libc.so.6 # 2010-07-26T19:36:00 Test completed with failure status 101. # 2010-07-26T19:36:00 gentest.pl exited with exit status 101 2010-07-26T19:36:00 [21129] ./runall.pl will exit with exit status 101