I re-added temporary table since https://bugs.launchpad.net/codership-mysql/+bug/1212247 has been fixed (since that was for temporary tables). Having temporary tables, produces the same deadlock

============================================================================================

Running with galera grammar (yy and zz attached).


# 2013-09-16T09:50:01 [20538] Copyright (c) 2010,2011 Oracle and/or its affiliates. All rights reserved. Use is subject to license terms.
# 2013-09-16T09:50:01 [20538] Please see http://forge.mysql.com/wiki/Category:RandomQueryGenerator for more information on this test framework.
# 2013-09-16T09:50:01 [20538] Starting 
# 2013-09-16T09:50:01 [20538] # runall-new.pl \ 
# 2013-09-16T09:50:01 [20538] # --basedir=/mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64 \ 
# 2013-09-16T09:50:01 [20538] # --galera=ms \ 
# 2013-09-16T09:50:01 [20538] # --reporter=Shutdown,Backtrace,ErrorLog,ErrorLogAlarm,Deadlock \ 
# 2013-09-16T09:50:01 [20538] # --grammar=conf/galera/galera_stress.yy \ 
# 2013-09-16T09:50:01 [20538] # --gendata=conf/galera/galera_stress.zz \ 
# 2013-09-16T09:50:01 [20538] # --threads=16 \ 
# 2013-09-16T09:50:01 [20538] # --queries=50000 \ 
# 2013-09-16T09:50:01 [20538] # --mysqld=--wsrep-provider=/mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64/lib/libgalera_smm.so \ 
# 2013-09-16T09:50:01 [20538] # --seed=time \ 
# 2013-09-16T09:50:01 [20538] # --mysqld=--innodb_flush_method=O_DIRECT
# 2013-09-16T09:50:01 [20538] master_port : 19300 slave_port : 19302 ports : 19300 19302 MTR_BUILD_THREAD : 930 
# 2013-09-16T09:50:02 [20538] /mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/pxcgen Revno: 915
# 2013-09-16T09:50:02 [20538] /mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/pxcgen Revision-Id: <email address hidden>
# 2013-09-16T09:50:02 [20538] /mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64 does not look like a bzr branch, cannot get revision info.
# 2013-09-16T09:50:02 [20538] Creating MySQL 5.5.33 database at /mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64/mysql-test/var/node0/data
# 2013-09-16T09:50:08 [20538] Creating MySQL 5.5.33 database at /mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64/mysql-test/var/node1/data
# 2013-09-16T09:50:20 [20538] MySQL Version:5.5.33
# 2013-09-16T09:50:20 [20538] Binary: /mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64/bin/mysqld
# 2013-09-16T09:50:20 [20538] Type: Release
# 2013-09-16T09:50:20 [20538] Datadir: /mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64/mysql-test/var/node0/data
# 2013-09-16T09:50:20 [20538] Tmpdir: /mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64/mysql-test/var/node0/tmp
# 2013-09-16T09:50:20 [20538] Corefile: /mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64/mysql-test/var/node0/data/core.
# 2013-09-16T09:50:20 [20538] Starting MySQL 5.5.33: "/mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64/bin/mysqld" "--no-defaults" "--basedir=/mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64" "--datadir=/mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64/mysql-test/var/node0/data" "--lc-messages-dir=/mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64/share" "--character-sets-dir=/mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64/share/charsets" "--tmpdir=/mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64/mysql-test/var/node0/tmp" "--core-file" "--max-allowed-packet=128Mb" "--port=19300" "--socket=/tmp/RQGmysql.19300.sock" "--pid-file=/mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64/mysql-test/var/node0/mysql.pid" "--general-log" "--general-log-file=/mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64/mysql-test/var/node0/mysql.log" --wsrep_sst_method=rsync --innodb_autoinc_lock_mode=2 --default-storage-engine=InnoDB --innodb_locks_unsafe_for_binlog=1 --binlog-format=row --wsrep_node_incoming_address=127.0.0.1 --wsrep_node_address=127.0.0.1 --wsrep_cluster_address='gcomm://?gmcast.listen_addr=tcp://127.0.0.1:4970&pc.ignore_sb=true' --wsrep_sst_receive_address=127.0.0.1:4973 --wsrep-provider=/mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64/lib/libgalera_smm.so --innodb_flush_method=O_DIRECT
# 2013-09-16T09:50:22 [20538] Cluster size after starting node 0: 1
# 2013-09-16T09:50:22 [20538] MySQL Version:5.5.33
# 2013-09-16T09:50:22 [20538] Binary: /mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64/bin/mysqld
# 2013-09-16T09:50:22 [20538] Type: Release
# 2013-09-16T09:50:22 [20538] Datadir: /mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64/mysql-test/var/node1/data
# 2013-09-16T09:50:22 [20538] Tmpdir: /mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64/mysql-test/var/node1/tmp
# 2013-09-16T09:50:22 [20538] Corefile: /mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64/mysql-test/var/node1/data/core.
# 2013-09-16T09:50:22 [20538] Starting MySQL 5.5.33: "/mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64/bin/mysqld" "--no-defaults" "--basedir=/mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64" "--datadir=/mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64/mysql-test/var/node1/data" "--lc-messages-dir=/mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64/share" "--character-sets-dir=/mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64/share/charsets" "--tmpdir=/mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64/mysql-test/var/node1/tmp" "--core-file" "--max-allowed-packet=128Mb" "--port=19301" "--socket=/tmp/RQGmysql.19301.sock" "--pid-file=/mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64/mysql-test/var/node1/mysql.pid" "--general-log" "--general-log-file=/mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64/mysql-test/var/node1/mysql.log" --wsrep_sst_method=rsync --innodb_autoinc_lock_mode=2 --default-storage-engine=InnoDB --innodb_locks_unsafe_for_binlog=1 --binlog-format=row --wsrep_node_incoming_address=127.0.0.1 --wsrep_node_address=127.0.0.1 --wsrep_cluster_address='gcomm://127.0.0.1:4970?gmcast.listen_addr=tcp://127.0.0.1:4971&pc.ignore_sb=true' --wsrep_sst_receive_address=127.0.0.1:4974 --wsrep-provider=/mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64/lib/libgalera_smm.so --innodb_flush_method=O_DIRECT
# 2013-09-16T09:50:29 [20538] Cluster size after starting node 1: 2
# 2013-09-16T09:50:29 [20538] Converting --seed=time to --seed=1379325029
# 2013-09-16T09:50:29 [20538] -------------------------------
# 2013-09-16T09:50:29 [20538] Configuration
# 2013-09-16T09:50:29 [20538]   debug_server => ['', '']
# 2013-09-16T09:50:29 [20538]   dsn => ['dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test']
# 2013-09-16T09:50:29 [20538]   duration => 3600
# 2013-09-16T09:50:29 [20538]   gendata => conf/galera/galera_stress.zz
# 2013-09-16T09:50:29 [20538]   generator => FromGrammar
# 2013-09-16T09:50:29 [20538]   grammar => conf/galera/galera_stress.yy
# 2013-09-16T09:50:29 [20538]   queries => 50000
# 2013-09-16T09:50:29 [20538]   reporters => ['Shutdown', 'Backtrace', 'ErrorLog', 'ErrorLogAlarm', 'Deadlock']
# 2013-09-16T09:50:29 [20538]   seed => 1379325029
# 2013-09-16T09:50:29 [20538]   servers => ['DBServer::MySQL::MySQLd=ARRAY(0x29a87d0)', 'DBServer::MySQL::MySQLd=ARRAY(0x2d84960)']
# 2013-09-16T09:50:29 [20538]   threads => 16
# 2013-09-16T09:50:29 [20538]   views => ['', '']
# 2013-09-16T09:50:29 [20538] # Creating MySQL table: test.table1_innodb_int; engine: innodb; rows: 1 .
# 2013-09-16T09:50:29 [20538] # Creating MySQL table: test.table1_innodb_int_autoinc; engine: innodb; rows: 1 .
# 2013-09-16T09:50:29 [20538] # Creating MySQL table: test.table1_innodb_key_pk_parts_2_int; engine: innodb; rows: 1 .
# 2013-09-16T09:50:29 [20538] # Creating MySQL table: test.table1_innodb_key_pk_parts_2_int_autoinc; engine: innodb; rows: 1 .
# 2013-09-16T09:50:29 [20538] # Creating MySQL table: test.table100_innodb_int; engine: innodb; rows: 100 .
# 2013-09-16T09:50:29 [20538] # Creating MySQL table: test.table100_innodb_int_autoinc; engine: innodb; rows: 100 .
# 2013-09-16T09:50:29 [20538] # Creating MySQL table: test.table100_innodb_key_pk_parts_2_int; engine: innodb; rows: 100 .
# 2013-09-16T09:50:29 [20538] # Creating MySQL table: test.table100_innodb_key_pk_parts_2_int_autoinc; engine: innodb; rows: 100 .
# 2013-09-16T09:50:30 [20538] # Creating MySQL table: test.table1000_innodb_int; engine: innodb; rows: 1000 .
# 2013-09-16T09:50:30 [20538] # Creating MySQL table: test.table1000_innodb_int_autoinc; engine: innodb; rows: 1000 .
# 2013-09-16T09:50:30 [20538] # Creating MySQL table: test.table1000_innodb_key_pk_parts_2_int; engine: innodb; rows: 1000 .
# 2013-09-16T09:50:30 [20538] # Creating MySQL table: test.table1000_innodb_key_pk_parts_2_int_autoinc; engine: innodb; rows: 1000 .
# 2013-09-16T09:50:30 [20538] Reporters: Shutdown, Backtrace, ErrorLog, ErrorLogAlarm, Deadlock
# 2013-09-16T09:50:45 [20538] Validators: ErrorMessageCorruption
# 2013-09-16T09:50:45 [20538] Caching schema metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test
# 2013-09-16T09:50:45 [20538] Starting 16 processes, 50000 queries each, duration 3600 seconds.
# 2013-09-16T09:50:45 [20538] GenTest::ErrorFilter(21004) started
# 2013-09-16T09:50:45 [21006] Loading Validator GenTest::Validator::ErrorMessageCorruption.
# 2013-09-16T09:50:46 [21004] Query: INSERT  INTO `table100_innodb_key_pk_parts_2_int_autoinc` (`pk`) VALUES (163) failed: 1062 Duplicate entry '%s' for key '%s'. Further errors of this kind will be suppressed.
# 2013-09-16T09:50:46 [21004] Query: ROLLBACK TO SAVEPOINT A failed: 1305 SAVEPOINT %s does not exist. Further errors of this kind will be suppressed.
# 2013-09-16T09:50:46 [21008] Loading Validator GenTest::Validator::ErrorMessageCorruption.
# 2013-09-16T09:50:46 [21004] Query: SELECT X. `pk` IS NULL FROM `table100_innodb_int` AS X LEFT JOIN `table1_innodb_int_autoinc` AS Y USING ( `col_int_key` ) WHERE X . `col_int_key` BETWEEN 64 AND 2062090240  LIMIT 8 failed: 1146 Table '%s' doesn't exist. Further errors of this kind will be suppressed.
# 2013-09-16T09:50:46 [21004] Query: INSERT IGNORE INTO `table100_innodb_int_autoinc` ( `pk` , `pk` ) VALUES ( 3 , 'w' ) , ( 206 , 'o' ) failed: 1110 Column '%s' specified twice. Further errors of this kind will be suppressed.
# 2013-09-16T09:50:46 [21010] Loading Validator GenTest::Validator::ErrorMessageCorruption.
# 2013-09-16T09:50:46 [21012] Loading Validator GenTest::Validator::ErrorMessageCorruption.
# 2013-09-16T09:50:46 [21004] Query: DROP TABLE IF EXISTS q  failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed.
# 2013-09-16T09:50:46 [21014] Loading Validator GenTest::Validator::ErrorMessageCorruption.
# 2013-09-16T09:50:46 [21004] Query:  DROP TABLE `table1_innodb_int_autoinc`  failed: 1051 Unknown table '%s'. Further errors of this kind will be suppressed.
# 2013-09-16T09:50:46 [21016] Loading Validator GenTest::Validator::ErrorMessageCorruption.
# 2013-09-16T09:50:46 [21006] Query:  CREATE TEMPORARY TABLE c LIKE `table1_innodb_key_pk_parts_2_int`  failed: 1562 Cannot create temporary table with partitions
# 2013-09-16T09:50:46 [21018] Loading Validator GenTest::Validator::ErrorMessageCorruption.
# 2013-09-16T09:50:46 [21016] Query:  CREATE TEMPORARY TABLE r LIKE `table100_innodb_key_pk_parts_2_int`  failed: 1562 Cannot create temporary table with partitions
# 2013-09-16T09:50:46 [21020] Loading Validator GenTest::Validator::ErrorMessageCorruption.
# 2013-09-16T09:50:46 [21022] Loading Validator GenTest::Validator::ErrorMessageCorruption.
# 2013-09-16T09:50:46 [21024] Loading Validator GenTest::Validator::ErrorMessageCorruption.
# 2013-09-16T09:50:46 [21014] Query:  CREATE TEMPORARY TABLE f LIKE `table1_innodb_key_pk_parts_2_int_autoinc`  failed: 1562 Cannot create temporary table with partitions
# 2013-09-16T09:50:47 [21026] Loading Validator GenTest::Validator::ErrorMessageCorruption.
# 2013-09-16T09:50:47 [21028] Loading Validator GenTest::Validator::ErrorMessageCorruption.
# 2013-09-16T09:50:47 [21004] Query:  ALTER TABLE c RENAME `table1_innodb_int_autoinc` failed: 1050 Table '%s' already exists. Further errors of this kind will be suppressed.
# 2013-09-16T09:50:47 [21030] Loading Validator GenTest::Validator::ErrorMessageCorruption.
# 2013-09-16T09:50:47 [21032] Loading Validator GenTest::Validator::ErrorMessageCorruption.
# 2013-09-16T09:50:47 [21034] Loading Validator GenTest::Validator::ErrorMessageCorruption.
# 2013-09-16T09:50:47 [21006] Query:  CREATE TEMPORARY TABLE t LIKE `table1000_innodb_key_pk_parts_2_int`  failed: 1562 Cannot create temporary table with partitions
# 2013-09-16T09:50:47 [21036] Loading Validator GenTest::Validator::ErrorMessageCorruption.
# 2013-09-16T09:50:47 [21005] Started periodic reporting process...
# 2013-09-16T09:50:47 [21005] ErrorLogAlarm Reporter will monitor the log file /mnt/workspace/PXC-5.5-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.5.33-23.7.6.489.Linux.x86_64/mysql-test/var/node0/data/../mysql.err
# 2013-09-16T09:50:47 [21014] Query:  CREATE TEMPORARY TABLE p LIKE `table100_innodb_key_pk_parts_2_int`  failed: 1562 Cannot create temporary table with partitions
# 2013-09-16T09:50:48 [21010] Query:  CREATE TEMPORARY TABLE g LIKE `table1000_innodb_key_pk_parts_2_int_autoinc`  failed: 1562 Cannot create temporary table with partitions
# 2013-09-16T09:50:48 [21004] Query: REPLACE INTO `table1_innodb_int` ( `col_int` ) SELECT `col_int_key` FROM `table1_innodb_int` AS X WHERE X . `col_int_key` < 216 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 5 failed: 1137 Can't reopen table: '%s'. Further errors of this kind will be suppressed.
# 2013-09-16T09:50:48 [21008] Query:  CREATE TEMPORARY TABLE h LIKE `table1000_innodb_key_pk_parts_2_int`  failed: 1562 Cannot create temporary table with partitions
# 2013-09-16T09:50:48 [21020] Query:  CREATE TEMPORARY TABLE b LIKE `table1000_innodb_key_pk_parts_2_int`  failed: 1562 Cannot create temporary table with partitions
# 2013-09-16T09:50:48 [21018] Query:  CREATE TEMPORARY TABLE z LIKE `table1000_innodb_key_pk_parts_2_int`  failed: 1562 Cannot create temporary table with partitions
# 2013-09-16T09:51:40 [21004] Query: UPDATE IGNORE `table100_innodb_int_autoinc` AS X SET `col_int_key` = 136445952 WHERE X . `col_char_12_key` < 4203741184 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 8 failed: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed.
# 2013-09-16T10:00:48 [21005] 6 stalled queries detected, declaring deadlock at DSN dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test.
# 2013-09-16T10:00:48 [21005] Executing SHOW PROCESSLIST:
$VAR1 = [
          [
            '1',
            'system user',
            '',
            undef,
            'Sleep',
            '627',
            'wsrep aborter idle',
            undef,
            '0',
            '0',
            '0'
          ],
          [
            '2',
            'system user',
            '',
            undef,
            'Sleep',
            '627',
            undef,
            undef,
            '0',
            '0',
            '0'
          ],
          [
            '3',
            'root',
            'localhost:57106',
            'mysql',
            'Sleep',
            '626',
            '',
            undef,
            '1',
            '1',
            '1'
          ],
          [
            '11',
            'root',
            'localhost:57121',
            'test',
            'Query',
            '548',
            'wsrep in pre-commit stage',
            'REPLACE INTO `table1000_innodb_int_autoinc` ( `col_int_key` ) VALUES ( 4035117056 )',
            '0',
            '0',
            '0'
          ],
          [
            '12',
            'root',
            'localhost:57122',
            'test',
            'Query',
            '599',
            'Waiting for table metadata lock',
            'DROP TABLE `table1_innodb_int`',
            '0',
            '0',
            '0'
          ],
          [
            '13',
            'root',
            'localhost:57123',
            'test',
            'Query',
            '599',
            'Preparing for TO isolation',
            'DROP TABLE IF EXISTS x',
            '0',
            '0',
            '0'
          ],
          [
            '14',
            'root',
            'localhost:57124',
            'test',
            'Query',
            '601',
            'Waiting for table metadata lock',
            'UPDATE  `table1_innodb_int` AS X SET `col_char_12_key` = 3903913984 WHERE X . `col_char_12_key` BETW',
            '0',
            '0',
            '0'
          ],
          [
            '15',
            'root',
            'localhost:57125',
            'test',
            'Query',
            '601',
            'Waiting for table metadata lock',
            'DELETE IGNORE FROM `table1_innodb_int` WHERE `col_char_12_key` = 556007424 ORDER BY `col_char_12`,`c',
            '0',
            '0',
            '0'
          ],
          [
            '16',
            'root',
            'localhost:57126',
            'test',
            'Query',
            '602',
            'Waiting for table metadata lock',
            'UPDATE IGNORE `table1_innodb_int` AS X SET `col_int` = 0  ORDER BY `col_char_12`,`col_char_12_key`,`',
            '0',
            '0',
            '0'
          ],
          [
            '17',
            'root',
            'localhost:57127',
            'test',
            'Query',
            '602',
            'Preparing for TO isolation',
            'ALTER TABLE l RENAME `table100_innodb_key_pk_parts_2_int`',
            '0',
            '0',
            '0'
          ],
          [
            '18',
            'root',
            'localhost:57128',
            'test',
            'Query',
            '601',
            'Preparing for TO isolation',
            'DROP TABLE IF EXISTS z',
            '0',
            '0',
            '0'
          ],
          [
            '19',
            'root',
            'localhost:57129',
            'test',
            'Query',
            '601',
            'Preparing for TO isolation',
            'DROP TABLE `table1_innodb_key_pk_parts_2_int_autoinc`',
            '0',
            '0',
            '0'
          ],
          [
            '20',
            'root',
            'localhost:57130',
            'test',
            'Query',
            '599',
            'Waiting for table metadata lock',
            'REPLACE INTO `table1_innodb_int` ( `col_int_key` ) VALUES ( \'j\' )',
            '0',
            '0',
            '0'
          ],
          [
            '21',
            'root',
            'localhost:57131',
            'test',
            'Query',
            '599',
            'Waiting for table metadata lock',
            'DELETE  FROM `table1_innodb_int` WHERE `col_char_12_key` = 1 ORDER BY `col_char_12`,`col_char_12_key',
            '0',
            '0',
            '0'
          ],
          [
            '22',
            'root',
            'localhost:57132',
            'test',
            'Query',
            '599',
            'Waiting for table metadata lock',
            'INSERT  INTO `table1_innodb_int` (`pk`) VALUES (44)',
            '0',
            '0',
            '0'
          ],
          [
            '23',
            'root',
            'localhost:57133',
            'test',
            'Query',
            '548',
            'Waiting for table metadata lock',
            'REPLACE INTO `table1_innodb_int` ( `pk` , `col_char_12` ) VALUES ( \'x\' , \'n\' ) , ( 5 , 202 )',
            '0',
            '0',
            '0'
          ],
          [
            '24',
            'root',
            'localhost:57134',
            'test',
            'Query',
            '600',
            'Waiting for table metadata lock',
            'CREATE  TABLE i LIKE `table1_innodb_int`',
            '0',
            '0',
            '0'
          ],
          [
            '25',
            'root',
            'localhost:57135',
            'test',
            'Query',
            '599',
            'wsrep in pre-commit stage',
            'INSERT IGNORE INTO `table100_innodb_int_autoinc` ( `col_char_12` , `col_char_12_key` ) VALUES ( 245 ',
            '0',
            '0',
            '0'
          ],
          [
            '26',
            'root',
            'localhost:57136',
            'test',
            'Query',
            '599',
            'wsrep in pre-commit stage',
            'DROP TABLE IF EXISTS t',
            '0',
            '0',
            '0'
          ],
          [
            '87',
            'root',
            'localhost:57197',
            'test',
            'Query',
            '0',
            'sleeping',
            'SHOW PROCESSLIST',
            '0',
            '0',
            '0'
          ]
        ];
# 2013-09-16T10:00:48 [21005] Executing SHOW ENGINE INNODB STATUS:
$VAR1 = [
          [
            'InnoDB',
            '',
            '
=====================================
130916 10:00:48 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 17 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 34 1_second, 34 sleeps, 3 10_second, 7 background, 7 flush
srv_master_thread log flush and writes: 145
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 340, signal count 807
Mutex spin waits 6998, rounds 20631, OS waits 211
RW-shared spins 176, rounds 1294, OS waits 26
RW-excl spins 313, rounds 4298, OS waits 77
Spin rounds per wait: 2.95 mutex, 7.35 RW-shared, 13.73 RW-excl
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
I/O thread 9 state: waiting for completed aio requests (write thread)
Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
 ibuf aio reads: 0, log i/o\'s: 0, sync i/o\'s: 0
Pending flushes (fsync) log: 0; buffer pool: 0
156 OS file reads, 3032 OS file writes, 1670 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2, 0 merges
merged operations:
 insert 0, delete mark 0, delete 0
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 276671, node heap has 3 buffer(s)
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 10006145
Log flushed up to   10006145
Last checkpoint at  10006145
Max checkpoint age    7782360
Checkpoint age target 7539162
Modified age          0
Checkpoint age        0
0 pending log writes, 0 pending chkp writes
1642 log i/o\'s done, 0.00 log i/o\'s/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 137822208; in additional pool allocated 0
Total memory allocated by read views 3256
Internal hash tables (constant factor + variable factor)
    Adaptive hash index 2266736 	(2213368 + 53368)
    Page hash           139112 (buffer pool 0 only)
    Dictionary cache    756863 	(554768 + 202095)
    File system         83536 	(82672 + 864)
    Lock system         340136 	(332872 + 7264)
    Recovery system     0 	(0 + 0)
Dictionary memory allocated 202095
Buffer pool size        8191
Buffer pool size, bytes 134201344
Free buffers            7646
Database pages          542
Old database pages      209
Modified db pages       0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 145, created 397, written 1366
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 542, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
4 transactions active inside InnoDB
4 out of 1000 descriptors used
---OLDEST VIEW---
Normal read view
Read view low limit trx n:o D96
Read view up limit trx id D73
Read view low limit trx id D96
Read view individually stored trx ids:
Read view trx id D95
Read view trx id D94
Read view trx id D8F
Read view trx id D73
-----------------
Main thread process no. 20857, id 139941428160256, state: flushing log
Number of rows inserted 31891, updated 1104, deleted 404, read 201692
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
------------------------
LATEST DETECTED DEADLOCK
------------------------
130916  9:50:49
*** (1) TRANSACTION:
TRANSACTION D4C, ACTIVE 0 sec starting index read
mysql tables in use 2, locked 2
LOCK WAIT 2 lock struct(s), heap size 376, 1 row lock(s)
MySQL thread id 17, OS thread handle 0x7f46ccd1e700, query id 5229 localhost 127.0.0.1 root init
UPDATE IGNORE `table100_innodb_int_autoinc` AS X SET `col_int` = 232 WHERE X . `col_char_12_key` BETWEEN 3 AND 7 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 8
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 0 page no 643 n bits 72 index `PRIMARY` of table `test`.`table100_innodb_int_autoinc` /* Partition `p0` */ trx id D4C lock_mode X locks rec but not gap waiting
*** (2) TRANSACTION:
TRANSACTION D39, ACTIVE 0 sec inserting
mysql tables in use 2, locked 2
7 lock struct(s), heap size 1248, 3 row lock(s), undo log entries 1
MySQL thread id 13, OS thread handle 0x7f46cce22700, query id 5202 localhost 127.0.0.1 root update
REPLACE INTO `table100_innodb_int_autoinc` ( `pk` , `col_int` ) VALUES ( 66 , 4 ) , ( 5 , 7 )
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 0 page no 643 n bits 72 index `PRIMARY` of table `test`.`table100_innodb_int_autoinc` /* Partition `p0` */ trx id D39 lock mode S locks rec but not gap
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 0 page no 643 n bits 72 index `PRIMARY` of table `test`.`table100_innodb_int_autoinc` /* Partition `p0` */ trx id D39 lock_mode X locks rec but not gap waiting
*** WE ROLL BACK TRANSACTION (1)
------------
TRANSACTIONS
------------
Trx id counter D96
Purge done for trx\'s n:o < D8F undo n:o < 0
History list length 663
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 87, OS thread handle 0x7f46cca94700, query id 5658 localhost 127.0.0.1 root sleeping
SHOW ENGINE INNODB STATUS
---TRANSACTION D7F, not started
MySQL thread id 24, OS thread handle 0x7f46ccb57700, query id 5435 localhost 127.0.0.1 root Waiting for table metadata lock
CREATE  TABLE i LIKE `table1_innodb_int`
---TRANSACTION D90, not started
MySQL thread id 23, OS thread handle 0x7f46ccb98700, query id 5488 localhost 127.0.0.1 root Waiting for table metadata lock
REPLACE INTO `table1_innodb_int` ( `pk` , `col_char_12` ) VALUES ( \'x\' , \'n\' ) , ( 5 , 202 )
---TRANSACTION D93, not started
MySQL thread id 22, OS thread handle 0x7f46ccbd9700, query id 5460 localhost 127.0.0.1 root Waiting for table metadata lock
INSERT  INTO `table1_innodb_int` (`pk`) VALUES (44)
---TRANSACTION D71, not started
MySQL thread id 21, OS thread handle 0x7f46ccc1a700, query id 5398 localhost 127.0.0.1 root Waiting for table metadata lock
DELETE  FROM `table1_innodb_int` WHERE `col_char_12_key` = 1 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1
---TRANSACTION D8B, not started
MySQL thread id 20, OS thread handle 0x7f46ccc5b700, query id 5454 localhost 127.0.0.1 root Waiting for table metadata lock
REPLACE INTO `table1_innodb_int` ( `col_int_key` ) VALUES ( \'j\' )
---TRANSACTION D63, not started
MySQL thread id 19, OS thread handle 0x7f46ccc9c700, query id 5467 localhost 127.0.0.1 root Preparing for TO isolation
DROP TABLE `table1_innodb_key_pk_parts_2_int_autoinc`
---TRANSACTION D72, not started
MySQL thread id 18, OS thread handle 0x7f46cccdd700, query id 5416 localhost 127.0.0.1 root Preparing for TO isolation
DROP TABLE IF EXISTS z
---TRANSACTION D6D, not started
MySQL thread id 17, OS thread handle 0x7f46ccd1e700, query id 5465 localhost 127.0.0.1 root Preparing for TO isolation
ALTER TABLE l RENAME `table100_innodb_key_pk_parts_2_int`
---TRANSACTION D8A, not started
MySQL thread id 16, OS thread handle 0x7f46ccd5f700, query id 5412 localhost 127.0.0.1 root Waiting for table metadata lock
UPDATE IGNORE `table1_innodb_int` AS X SET `col_int` = 0  ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 5
---TRANSACTION D6B, not started
MySQL thread id 15, OS thread handle 0x7f46ccda0700, query id 5380 localhost 127.0.0.1 root Waiting for table metadata lock
DELETE IGNORE FROM `table1_innodb_int` WHERE `col_char_12_key` = 556007424 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1
---TRANSACTION D39, not started
MySQL thread id 13, OS thread handle 0x7f46cce22700, query id 5471 localhost 127.0.0.1 root Preparing for TO isolation
DROP TABLE IF EXISTS x
---TRANSACTION D79, not started
MySQL thread id 12, OS thread handle 0x7f46cce63700, query id 5374 localhost 127.0.0.1 root Waiting for table metadata lock
DROP TABLE `table1_innodb_int`
---TRANSACTION D95, ACTIVE 548 sec
mysql tables in use 2, locked 2
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 11, OS thread handle 0x7f46ccea4700, query id 5491 localhost 127.0.0.1 root wsrep in pre-commit stage
REPLACE INTO `table1000_innodb_int_autoinc` ( `col_int_key` ) VALUES ( 4035117056 )
TABLE LOCK table `test`.`table1000_innodb_int_autoinc` /* Partition `p1` */ trx id D95 lock mode IX
---TRANSACTION D94, ACTIVE 599 sec
2 lock struct(s), heap size 376, 1 row lock(s)
MySQL thread id 14, OS thread handle 0x7f46ccde1700, query id 5492 localhost 127.0.0.1 root Waiting for table metadata lock
UPDATE  `table1_innodb_int` AS X SET `col_char_12_key` = 3903913984 WHERE X . `col_char_12_key` BETWEEN 142 AND 3817144320 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 6
TABLE LOCK table `test`.`table100_innodb_key_pk_parts_2_int_autoinc` /* Partition `p0` */ trx id D94 lock mode IX
RECORD LOCKS space id 0 page no 644 n bits 128 index `PRIMARY` of table `test`.`table100_innodb_key_pk_parts_2_int_autoinc` /* Partition `p0` */ trx id D94 lock_mode X locks rec but not gap
---TRANSACTION D8F, ACTIVE 599 sec
mysql tables in use 2, locked 2
3 lock struct(s), heap size 376, 2 row lock(s), undo log entries 1
MySQL thread id 25, OS thread handle 0x7f46ccb16700, query id 5446 localhost 127.0.0.1 root wsrep in pre-commit stage
INSERT IGNORE INTO `table100_innodb_int_autoinc` ( `col_char_12` , `col_char_12_key` ) VALUES ( 245 , 5 ) , ( 376635392 , \'f\' )
TABLE LOCK table `test`.`table100_innodb_int_autoinc` /* Partition `p1` */ trx id D8F lock mode IX
RECORD LOCKS space id 0 page no 664 n bits 72 index `PRIMARY` of table `test`.`table100_innodb_int_autoinc` /* Partition `p1` */ trx id D8F lock mode S locks rec but not gap
RECORD LOCKS space id 0 page no 664 n bits 80 index `PRIMARY` of table `test`.`table100_innodb_int_autoinc` /* Partition `p1` */ trx id D8F lock_mode X locks rec but not gap
---TRANSACTION D73, ACTIVE 599 sec
8 lock struct(s), heap size 1248, 3 row lock(s), undo log entries 1
MySQL thread id 26, OS thread handle 0x7f46ccad5700, query id 5438 localhost 127.0.0.1 root wsrep in pre-commit stage
DROP TABLE IF EXISTS t
TABLE LOCK table `test`.`table100_innodb_key_pk_parts_2_int_autoinc` /* Partition `p1` */ trx id D73 lock mode IX
RECORD LOCKS space id 0 page no 667 n bits 72 index `PRIMARY` of table `test`.`table100_innodb_key_pk_parts_2_int_autoinc` /* Partition `p1` */ trx id D73 lock mode S locks rec but not gap
TABLE LOCK table `test`.`table100_innodb_int_autoinc` /* Partition `p0` */ trx id D73 lock mode IX
TABLE LOCK table `test`.`table100_innodb_int_autoinc` /* Partition `p1` */ trx id D73 lock mode IX
TABLE LOCK table `test`.`table100_innodb_key_pk_parts_2_int_autoinc` /* Partition `p0` */ trx id D73 lock mode IX
RECORD LOCKS space id 0 page no 644 n bits 128 index `PRIMARY` of table `test`.`table100_innodb_key_pk_parts_2_int_autoinc` /* Partition `p0` */ trx id D73 lock_mode X locks rec but not gap
RECORD LOCKS space id 0 page no 644 n bits 128 index `PRIMARY` of table `test`.`table100_innodb_key_pk_parts_2_int_autoinc` /* Partition `p0` */ trx id D73 lock_mode X locks rec but not gap
RECORD LOCKS space id 0 page no 667 n bits 72 index `PRIMARY` of table `test`.`table100_innodb_key_pk_parts_2_int_autoinc` /* Partition `p1` */ trx id D73 lock_mode X locks rec but not gap
----------------------------
END OF INNODB MONITOR OUTPUT
============================
'
          ]
        ];


================================================================================================

Full log: http://jenkins.percona.com/job/PXC-5.5-mrandgen/BTYPE=release,Host=centos6-64/89/consoleText 



For reference: 

The difference with earlier yy file:

=== modified file 'conf/galera/galera_stress.yy'
--- conf/galera/galera_stress.yy        2013-08-30 10:06:49 +0000
+++ conf/galera/galera_stress.yy        2013-09-16 07:59:25 +0000
@@ -110,11 +110,11 @@


 drop_create_table:
-       DROP TABLE IF EXISTS _letter[invariant] ; CREATE TABLE _letter[invariant] LIKE _table[invariant] ; INSERT INTO _letter[invariant] SELECT * FROM _table[invariant] |
-       DROP TABLE IF EXISTS _letter[invariant] ; CREATE TABLE _letter[invariant] LIKE _table[invariant] ; INSERT INTO _letter[invariant] SELECT * FROM _table[invariant] ; DROP TABLE _table[invariant] ; ALTER TABLE _letter[invariant] RENAME _table[invariant] ;
+       DROP TABLE IF EXISTS _letter[invariant] ; CREATE temp TABLE _letter[invariant] LIKE _table[invariant] ; INSERT INTO _letter[invariant] SELECT * FROM _table[invariant] |
+       DROP TABLE IF EXISTS _letter[invariant] ; CREATE temp TABLE _letter[invariant] LIKE _table[invariant] ; INSERT INTO _letter[invariant] SELECT * FROM _table[invariant] ; DROP TABLE _table[invariant] ; ALTER TABLE _letter[invariant] RENAME _table[invariant] ;

-#temp:
-       #| | | | | | TEMPORARY;
+temp:
+       | | | | | | TEMPORARY;

 where_delete:
        |