crash with signal 11 on create table .. as

[KHP]

Versions:

/usr/sbin/mysqld Ver 5.5.29-55 for Linux on x86_64 (Percona XtraDB Cluster (GPL), wsrep_23.7.2.r3843)
Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

Linux node-01 3.2.0-36-generic #57-Ubuntu SMP Tue Jan 8 21:44:52 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux

Ubuntu 12.04 / x64

Cluster Node(s) crash on CREATE TABLE ... AS Statement:

CREATE TABLE IF NOT EXISTS `Warenkorb_31` AS (SELECT * FROM Warenkorb_Master WHERE 1=2);

with Warenkorb_Master as
mysql> show create table Warenkorb_Master \G;
*************************** 1. row ***************************
       Table: Warenkorb_Master
Create Table: CREATE TABLE `Warenkorb_Master` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Warenkorb_webpage` varchar(255) COLLATE latin1_general_cs NOT NULL,
  `Warenkorb_created_date` varchar(19) COLLATE latin1_general_cs NOT NULL,
  `Warenkorb_order_number` varchar(9) COLLATE latin1_general_cs NOT NULL,
  PRIMARY KEY (`id`),
  KEY `Warenkorb_webpage` (`Warenkorb_webpage`),
  KEY `Warenkorb_order_number` (`Warenkorb_order_number`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs
1 row in set (0.00 sec)

And leaving me with the following information in the mysql.err:

Thread pointer: 0x26e46f0
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 = 7faa585d9e70 thread_stack 0x40000
/usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x7d357e]
/usr/sbin/mysqld(handle_fatal_signal+0x484)[0x6aa084]
/lib/x86_64-linux-gnu/libpthread.so.0(+0xfcb0)[0x7faa6b8d3cb0]
/usr/sbin/mysqld(my_b_safe_tell+0x12)[0x7be922]
/usr/sbin/mysqld(_ZN9Log_event12write_headerEP11st_io_cachem+0x128)[0x74abc8]
/usr/sbin/mysqld(_ZN15Query_log_event5writeEP11st_io_cache+0x29a)[0x74b9ba]
/usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG5writeEP9Log_event+0x5b6)[0x73e9a6]
/usr/sbin/mysqld(_ZN3THD12binlog_queryENS_22enum_binlog_query_typeEPKcmbbbi+0xef)[0x58355f]
/usr/sbin/mysqld(_ZN13select_insert8send_eofEv+0x16c)[0x58e36c]
/usr/sbin/mysqld(_ZN13select_create8send_eofEv+0xf)[0x58e5cf]
/usr/sbin/mysqld(_ZN4JOIN4execEv+0x1bb)[0x5e7fab]
/usr/sbin/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x133)[0x5ea153]
/usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x1d5)[0x5eabc5]
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x68b8)[0x5ab888]
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x30c)[0x5acb0c]
/usr/sbin/mysqld[0x5ad440]
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x1a80)[0x5afba0]
/usr/sbin/mysqld(_Z10do_commandP3THD+0x169)[0x5afff9]
/usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x157)[0x64ad57]
/usr/sbin/mysqld(handle_one_connection+0x51)[0x64af01]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x7e9a)[0x7faa6b8cbe9a]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7faa6b5f8cbd]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7faa24004c40): is an invalid pointer
Connection ID (thread ID): 93
Status: NOT_KILLED

You may download the Percona Server operations manual by visiting
http://www.percona.com/software/percona-server/. You may find information
in the manual which will help you identify the cause of the crash.
130215 13:44:15 mysqld_safe Number of processes running now: 0
130215 13:44:15 mysqld_safe WSREP: not restarting wsrep node automatically
130215 13:44:15 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

[Raghavendra D Prabhu (raghavendra-prabhu)]

There is a related bug for CTAS - lp:1162421, it needs to be checked if the fix for it fixes this as well.

[Teemu Ollakka (teemu-ollakka)]

This looks just like lp:1160854, was binlog_format in this case STATEMENT/MIXED or ROW?

[Raghavendra D Prabhu (raghavendra-prabhu)]

@KHP

Can you provide pt-mysql-summary of this node? (to answer previous comment and any upcoming ones).

[Davide Bozzelli (buzzz)]

binlog_format is ROW

[Krunal Bauskar (krunal-bauskar)]

TC is passing with PXC-trunk so the issue seems got fixed by fixes we recently did to CTAS area.
Will close the bug.

mysql> CREATE TABLE `Warenkorb_Master` (
    -> `id` int(11) NOT NULL AUTO_INCREMENT,
    -> `Warenkorb_webpage` varchar(255) COLLATE latin1_general_cs NOT NULL,
    -> `Warenkorb_created_date` varchar(19) COLLATE latin1_general_cs NOT NULL,
    -> `Warenkorb_order_number` varchar(9) COLLATE latin1_general_cs NOT NULL,
    -> PRIMARY KEY (`id`),
    -> KEY `Warenkorb_webpage` (`Warenkorb_webpage`),
    -> KEY `Warenkorb_order_number` (`Warenkorb_order_number`)
    -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs;
Query OK, 0 rows affected (0.05 sec)

mysql> CREATE TABLE IF NOT EXISTS `Warenkorb_31` AS (SELECT * FROM Warenkorb_Master WHERE 1=2);
Query OK, 0 rows affected (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> select * from Warenkorb_31;
Empty set (0.00 sec)

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-952