Comment 14 for bug 916205

Revision history for this message
Valerii Kravchuk (valerii-kravchuk) wrote :

I can not reproduce the crash with debug build of current Percona Server 5.6.15:

openxs@ao756:~/bzr/randgen$ perl runall.pl --queries=10M --duration=300 --mysqld=--loose-innodb-flush-log-at-trx-commit=0 --threads=2 --grammar=/tmp/assert.yy --gendata=/tmp/assert.zz --engine=InnoDB --basedir=/home/openxs/dbs/p5.6 --vardir=/tmp/p5.6debug
# 2014-02-03T17:58:35 Copyright (c) 2008,2011 Oracle and/or its affiliates. All rights reserved. Use is subject to license terms.
# 2014-02-03T17:58:35 Please see http://forge.mysql.com/wiki/Category:RandomQueryGenerator for more information on this test framework.
# 2014-02-03T17:58:35 Starting: runall.pl --queries=10M --duration=300 --mysqld=--loose-innodb-flush-log-at-trx-commit=0 --threads=2 --grammar=/tmp/assert.yy --gendata=/tmp/assert.zz --engine=InnoDB --basedir=/home/openxs/dbs/p5.6 --vardir=/tmp/p5.6debug
# 2014-02-03T17:58:35 master_port : 19300 slave_port : 19302 master_ports : 19300 19302 MTR_BUILD_THREAD : 930
# 2014-02-03T17:58:35 /home/openxs/bzr/randgen Revno: 948
# 2014-02-03T17:58:35 /home/openxs/bzr/randgen Revision-Id: <email address hidden>
# 2014-02-03T17:58:36 /home/openxs/dbs/p5.6 does not look like a bzr branch, cannot get revision info.
# 2014-02-03T17:58:36 Running perl mysql-test-run.pl --start-and-exit --mysqld=--innodb --skip-ndb --mysqld=--core-file --mysqld=--loose-new --mysqld=--default-storage-engine=InnoDB --mysqld=--sql-mode=no_engine_substitution --mysqld=--relay-log=slave-relay-bin --mysqld=--loose-innodb --mysqld=--secure-file-priv= --mysqld=--max-allowed-packet=16Mb --mysqld=--loose-innodb-status-file=1 --mysqld=--master-retry-count=65535 --mysqld=--loose-debug-assert-if-crashed-table --mysqld=--loose-debug-assert-on-error --mysqld=--skip-name-resolve --vardir=/tmp/p5.6debug --master_port=19300 --mysqld="--loose-innodb-flush-log-at-trx-commit=0" 1st 2>&1 .
=======================================================
  WARNING: Using mysql-test-run.pl version 1!
=======================================================
Logging: lib/v1/mysql-test-run.pl --start-and-exit --mysqld=--innodb --skip-ndb --mysqld=--core-file --mysqld=--loose-new --mysqld=--default-storage-engine=InnoDB --mysqld=--sql-mode=no_engine_substitution --mysqld=--relay-log=slave-relay-bin --mysqld=--loose-innodb --mysqld=--secure-file-priv= --mysqld=--max-allowed-packet=16Mb --mysqld=--loose-innodb-status-file=1 --mysqld=--master-retry-count=65535 --mysqld=--loose-debug-assert-if-crashed-table --mysqld=--loose-debug-assert-on-error --mysqld=--skip-name-resolve --vardir=/tmp/p5.6debug --master_port=19300 --mysqld=--loose-innodb-flush-log-at-trx-commit=0 1st
2014-02-03 17:58:36 20011 [Note] Plugin 'FEDERATED' is disabled.
2014-02-03 17:58:36 20011 [Note] Binlog end
2014-02-03 17:58:36 20011 [Note] Shutting down plugin 'CSV'
2014-02-03 17:58:36 20011 [Note] Shutting down plugin 'MyISAM'
MySQL Version 5.6.15
Using dynamic switching of binlog format
Using default engine 'InnoDB'
Skipping ndbcluster
Setting mysqld to support SSL connections
Binaries are debug compiled
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
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Removing Stale Files
Creating Directories
Installing Master Database
=======================================================

TEST RESULT TIME (ms)
-------------------------------------------------------

Servers started, exiting
# 2014-02-03T17:58:47 Starting: gentest.pl --gendata=/tmp/assert.zz --engine=InnoDB --threads=2 --queries=10M --duration=300 --dsn=dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test --grammar=/tmp/assert.yy
# 2014-02-03T17:58:47 -------------------------------
# 2014-02-03T17:58:47 Configuration
# 2014-02-03T17:58:47 debug_server => ['']
# 2014-02-03T17:58:47 dsn => ['dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test']
# 2014-02-03T17:58:47 duration => 300
# 2014-02-03T17:58:47 engine => InnoDB
# 2014-02-03T17:58:47 gendata => /tmp/assert.zz
# 2014-02-03T17:58:47 generator => FromGrammar
# 2014-02-03T17:58:47 grammar => /tmp/assert.yy
# 2014-02-03T17:58:47 queries => 10000000
# 2014-02-03T17:58:47 reporters => ['']
# 2014-02-03T17:58:47 seed => 1
# 2014-02-03T17:58:47 threads => 2
# 2014-02-03T17:58:47 transformers => ['']
# 2014-02-03T17:58:47 validators => ['']
# 2014-02-03T17:58:47 views => ['', '']
# 2014-02-03T17:58:47 # Creating MySQL table: test.table10_innodb_key_pk_parts_2_int_autoinc; engine: innodb; rows: 10 .
# 2014-02-03T17:58:48 # Creating MySQL table: test.table100_innodb_key_pk_parts_2_int_autoinc; engine: innodb; rows: 100 .
# 2014-02-03T17:58:48 Reporters: ErrorLog, Backtrace
# 2014-02-03T17:58:49 Validators: ErrorMessageCorruption
# 2014-02-03T17:58:49 Caching schema metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test
# 2014-02-03T17:58:49 Starting 2 processes, 10000000 queries each, duration 300 seconds.
# 2014-02-03T17:58:49 GenTest::ErrorFilter(20089) started
# 2014-02-03T17:58:49 Loading Validator GenTest::Validator::ErrorMessageCorruption.
# 2014-02-03T17:58:49 Loading Validator GenTest::Validator::ErrorMessageCorruption.
# 2014-02-03T17:58:49 Started periodic reporting process...
# 2014-02-03T18:03:49 Child worker process completed successfully.
# 2014-02-03T18:03:49 Child worker process completed successfully.
# 2014-02-03T18:03:50 Killing periodic reporting process with pid 20090...
# 2014-02-03T18:03:50 Kill GenTest::ErrorFilter(20089)
# 2014-02-03T18:03:50 Test completed successfully.
# 2014-02-03T18:03:50 gentest.pl exited with exit status STATUS_OK (0)
2014-02-03T18:03:50 [19999] runall.pl will exit with exit status STATUS_OK (0)