crash with signal 11 on create table .. as
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;
*******
Table: Warenkorb_Master
Create Table: CREATE TABLE `Warenkorb_Master` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`Warenkorb_
`Warenkorb_
`Warenkorb_
PRIMARY KEY (`id`),
KEY `Warenkorb_webpage` (`Warenkorb_
KEY `Warenkorb_
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=
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/
/usr/sbin/
/lib/x86_
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/lib/x86_
/lib/x86_
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://
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/
There is a related bug for CTAS - lp:1162421, it needs to be checked if the fix for it fixes this as well.