crash with signal 11 on create table .. as

Bug #1126207 reported by KHP
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
New
Undecided
Unassigned
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC
Fix Committed
High
Unassigned

Bug Description

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

Tags: ctas
Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

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

Revision history for this message
Teemu Ollakka (teemu-ollakka) wrote :

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

Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

@KHP

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

Changed in percona-xtradb-cluster:
status: New → Incomplete
tags: added: ctas
Revision history for this message
Davide Bozzelli (buzzz) wrote :

binlog_format is ROW

Revision history for this message
Davide Bozzelli (buzzz) wrote :
Revision history for this message
Krunal Bauskar (krunal-bauskar) wrote :

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)

Changed in percona-xtradb-cluster:
status: Incomplete → Fix Committed
importance: Undecided → High
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Bug attachments

Remote bug watches

Bug watches keep track of this bug in other bug trackers.