LP #1126207: crash with signal 11 on create table .. as
Description
Environment
Activity
**Comment from Launchpad by: Krunal Bauskar on: 17-11-2015 04:05:27
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)
**Comment from Launchpad by: Davide Bozzelli on: 29-05-2014 18:52:23
binlog_format is ROW
**Comment from Launchpad by: Raghavendra D Prabhu on: 10-06-2013 12:19:00
@KHP
Can you provide pt-mysql-summary of this node? (to answer previous comment and any upcoming ones).
**Comment from Launchpad by: Teemu Ollakka on: 03-04-2013 18:08:38
This looks just like lp:1160854, was binlog_format in this case STATEMENT/MIXED or ROW?
**Comment from Launchpad by: Raghavendra D Prabhu on: 03-04-2013 17:48:22
There is a related bug for CTAS - lp:1162421, it needs to be checked if the fix for it fixes this as well.
**Reported in Launchpad by KHP last update 17-11-2015 04:05:43
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