Percona Server moved to https://jira.percona.com/projects/PS

Server crashes in add_identifier on concurrent ALTER TABLE and SHOW ENGINE INNODB STATUS

Bug #1017192 reported by Elena Stepanova on 2012-06-24

This bug affects 6 people

	Status	Importance	Assigned to	Milestone
MySQL Server	Unknown	Unknown	mysql-bugs #67974
Percona Server moved to https://jira.percona.com/projects/PS	Fix Released	Critical	Sergei Glushchenko	Percona Server moved to https://jira.percona.com/projects/PS 5.5.29-30.0
5.5	Fix Released	Critical	Sergei Glushchenko	Percona Server moved to https://jira.percona.com/projects/PS 5.5.29-30.0

Bug Description

Percona XtraDB 1.1.8-27.0 started

#3 <signal handler called>
#4 0x000000000066373a in add_identifier (thd=0x2854b30, to_p=0x7f6f26df5c6a "\337&o\177", end_p=0x7f6f26df5d40 "#sql-4d62_2#P#p0", name=0x7f6f26df5d4e "p0", name_len=4294967293) at sql/sql_table.cc:104
#5 0x000000000066433d in explain_filename (thd=0x2854b30, from=0x7f6f26df5d40 "#sql-4d62_2#P#p0", to=0x7f6f26df5c40 "`#sql-4d62_2#P#p0` /* Temporary Partition \337&o\177", to_length=256, explain_mode=EXPLAIN_PARTITIONS_AS_COMMENT) at sql/sql_table.cc:356
#6 0x00000000008c9ac0 in innobase_convert_identifier (buf=0x7f6f26df5ef7 "`t1` /* P", buflen=569, id=0x7f6f1c002b45 "#sql-4d62_2#P#p0", idlen=16, thd=0x2854b30, file_id=1) at storage/innobase/handler/ha_innodb.cc:2243
#7 0x00000000008c9df4 in innobase_convert_name (buf=0x7f6f26df5ef0 "`test`.`t1` /* P", buflen=576, id=0x7f6f1c002b40 "test/#sql-4d62_2#P#p0", idlen=21, thd=0x2854b30, table_id=1) at storage/innobase/handler/ha_innodb.cc:2329
#8 0x000000000095aeba in ut_print_namel (f=0x26d0260, trx=0x28f6798, table_id=1, name=0x7f6f1c002b40 "test/#sql-4d62_2#P#p0", namelen=21) at storage/innobase/ut/ut0ut.c:544
#9 0x000000000095ae30 in ut_print_name (f=0x26d0260, trx=0x28f6798, table_id=1, name=0x7f6f1c002b40 "test/#sql-4d62_2#P#p0") at storage/innobase/ut/ut0ut.c:520
#10 0x0000000000a1ecc8 in lock_table_print (file=0x26d0260, lock=0x28ee1c8) at storage/innobase/lock/lock0lock.c:4319
#11 0x0000000000a1faad in lock_print_info_all_transactions (file=0x26d0260) at storage/innobase/lock/lock0lock.c:4680
#12 0x00000000009233c5 in srv_printf_innodb_monitor (file=0x26d0260, nowait=0, trx_start=0x7f6f26df68d0, trx_end=0x7f6f26df68d8) at storage/innobase/srv/srv0srv.c:2243
#13 0x00000000008d7c4f in innodb_show_status (hton=0x2288840, thd=0x28f9830, stat_print=0x756c8f <stat_print(THD*, char const*, uint, char const*, uint, char const*, uint)>) at storage/innobase/handler/ha_innodb.cc:10347
#14 0x00000000008d86e9 in innobase_show_status (hton=0x2288840, thd=0x28f9830, stat_print=0x756c8f <stat_print(THD*, char const*, uint, char const*, uint, char const*, uint)>, stat_type=HA_ENGINE_STATUS) at storage/innobase/handler/ha_innodb.cc:10587
#15 0x0000000000756fde in ha_show_status (thd=0x28f9830, db_type=0x2288840, stat=HA_ENGINE_STATUS) at sql/handler.cc:5055
#16 0x00000000005e6873 in mysql_execute_command (thd=0x28f9830) at sql/sql_parse.cc:2479
#17 0x00000000005ef600 in mysql_parse (thd=0x28f9830, rawbuf=0x2904990 "SHOW ENGINE INNODB STATUS", length=25, parser_state=0x7f6f26df7ff0) at sql/sql_parse.cc:5809
#18 0x00000000005e34f0 in dispatch_command (command=COM_QUERY, thd=0x28f9830, packet=0x28fc961 "", packet_length=25) at sql/sql_parse.cc:1060
#19 0x00000000005e27d1 in do_command (thd=0x28f9830) at sql/sql_parse.cc:788
#20 0x00000000006c9024 in do_handle_one_connection (thd_arg=0x28f9830) at sql/sql_connect.cc:1441
#21 0x00000000006c8a0a in handle_one_connection (arg=0x28f9830) at sql/sql_connect.cc:1348
#22 0x0000000000aa5fa7 in pfs_spawn_thread (arg=0x2857e80) at storage/perfschema/pfs.cc:1015
#23 0x00007f6f2eea0efc in start_thread (arg=0x7f6f26df9700) at pthread_create.c:304
#24 0x00007f6f2e21359d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

bzr version-info
revision-id: <email address hidden>
date: 2012-06-21 14:36:22 +0200
build-date: 2012-06-24 20:18:16 +0400
revno: 270

# MTR test case:

--source include/have_partition.inc
--source include/have_innodb.inc

CREATE TABLE IF NOT EXISTS t1 (`a` INT) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1),(2),(3),(4);

--connect (con1,localhost,root,,)
--let $run = 100

while ($run)
{
        --connection default
        --send ALTER TABLE t1 PARTITION BY HASH (`a`) PARTITIONS 4
        --connection con1
        --let $show = 300
        while ($show)
        {
                SHOW ENGINE INNODB STATUS;
                --dec $show
        }
        --connection default
        --reap
        --dec $run
}

DROP TABLE t1;

# End of MTR test case

# If it does not work, try the RQG grammar
# cat 1.yy

query_init:
CREATE TABLE IF NOT EXISTS t1 (`a` INT) ENGINE=InnoDB
; INSERT INTO t1 VALUES (1),(2),(3),(4);

thread1:
SHOW ENGINE INNODB STATUS;

query:
ALTER TABLE t1 PARTITION BY HASH (`a`) PARTITIONS 4 ;

# End of RQG grammar
# run as

perl ./runall.pl \
--threads=2 \
--queries=100M \
--duration=300 \
--skip-gendata \
--grammar=1.yy \
--basedir=<your basedir>

Tags:

Related branches

lp:~sergei.glushchenko/percona-server/ps55-bug1017192

Merged into lp:percona-server/5.5 at revision 408

Stewart Smith (community): Approve on 2013-01-08

Stewart Smith (stewart) on 2012-06-25

Changed in percona-server:
importance:	Undecided → High

Revision history for this message

Roel Van de Paar (roel11) wrote on 2012-08-19:

See bug#1036506 which is a possible duplicate

Revision history for this message

Roel Van de Paar (roel11) wrote on 2012-08-20:

See bug 1036506 which is a possible duplicate

Stewart Smith (stewart) on 2012-08-24

Changed in percona-server:
status:	New → In Progress
importance:	High → Critical
assignee:	nobody → Stewart Smith (stewart)
milestone:	none → 5.5.27-28.1

Revision history for this message

nathan hruby (nhruby-2) wrote on 2012-09-02:

I don't get this on 5.5.24, but those packages seem to have evaporated form the Percona RPM repos. Can they be put back at least until the problem can be fixed?

Revision history for this message

nathan hruby (nhruby-2) wrote on 2012-09-02:

Hi,

So in 5.5.27 we just experienced a deadlock with ALTER TABLE on regular, non-partitioned tables. This caused SHOW INNODB STATUS and SHOW GLOBAL STATUS as well as any access to the database that contained the ALTER'ed table to simple freeze forever. Would this bug be a cause of that, or shoudl I submit a new bug?

We do not experience this on 5.5.24 using identical hardware and similar OS builds.

-n

Revision history for this message

Laurynas Biveinis (laurynas-biveinis) wrote on 2012-09-03:

Nathan -

Please have a look at bug 1040735, if it matches your symptoms.

Revision history for this message

yinfeng (yinfeng-zwx) wrote on 2012-09-03:

I can't reproduce this bug on Percona Server 5.5.18 we are using now .

Can anyone confirm if this bug affects 5.5.18?

Revision history for this message

Laurynas Biveinis (laurynas-biveinis) wrote on 2012-09-03:

According to https://mariadb.atlassian.net/browse/MDEV-364, it is not reproducible on 5.5.24. Presumably 5.5.18 is also fine.

Laurynas Biveinis (laurynas-biveinis) on 2012-09-03

no longer affects:

maria

Revision history for this message

Roel Van de Paar (roel11) wrote on 2012-10-08:

Bug #1036506 still crashes. Un-duplicated that one.

Revision history for this message

Valerii Kravchuk (valerii-kravchuk) wrote on 2012-12-07:

I tried both mtr test case and RQG grammar on upstream 5.5.28 many times and I am not able to repeat the crash there (even though source code in sql/sql_table.cc looks the same as original, non-patched one. Going to try on other Linux version and hardware later.

Revision history for this message

Valerii Kravchuk (valerii-kravchuk) wrote on 2012-12-07:

#10

Older Percona server versions (like 5.5.27) are easy to crash this way with RQG:

...
121207 20:58:46 [Note] /home/openxs/dbs/p5.5/bin/mysqld: ready for connections.
Version: '5.5.27-log' socket: '/home/openxs/dbs/p5.5/mysql-test/var/tmp/master.sock' port: 19300 Source distribution
17:59:23 UTC - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.
Please help us make Percona Server better by reporting any
bugs at http://bugs.percona.com/

key_buffer_size=1048576
read_buffer_size=131072
max_used_connections=3
max_threads=151
thread_count=3
connection_count=3
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 60853 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x33af570
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 = 7fdf781a3e58 thread_stack 0x40000
/home/openxs/dbs/p5.5/bin/mysqld(my_print_stacktrace+0x2e)[0x7643be]
/home/openxs/dbs/p5.5/bin/mysqld(handle_fatal_signal+0x41a)[0x6592fa]
/lib64/libpthread.so.0(+0xf500)[0x7fdf7aba2500]
/home/openxs/dbs/p5.5/bin/mysqld[0x5bfc33]
/home/openxs/dbs/p5.5/bin/mysqld(_Z16explain_filenameP3THDPKcPcj26enum_explain_filename_mode+0x363)[0x5c0143]
/home/openxs/dbs/p5.5/bin/mysqld[0x7ab507]
/home/openxs/dbs/p5.5/bin/mysqld[0x7abca9]
/home/openxs/dbs/p5.5/bin/mysqld[0x806461]
/home/openxs/dbs/p5.5/bin/mysqld[0x88102e]
/home/openxs/dbs/p5.5/bin/mysqld[0x881c8b]
/home/openxs/dbs/p5.5/bin/mysqld[0x7e401e]
/home/openxs/dbs/p5.5/bin/mysqld[0x7b2b65]
/home/openxs/dbs/p5.5/bin/mysqld(_Z14ha_show_statusP3THDP10handlerton12ha_stat_type+0x333)[0x65f823]
/home/openxs/dbs/p5.5/bin/mysqld(_Z21mysql_execute_commandP3THD+0x22f7)[0x56e207]
/home/openxs/dbs/p5.5/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x33b)[0x5705ab]
/home/openxs/dbs/p5.5/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x1419)[0x572199]
/home/openxs/dbs/p5.5/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x1a6)[0x601fa6]
/home/openxs/dbs/p5.5/bin/mysqld(handle_one_connection+0x4a)[0x60200a]
/lib64/libpthread.so.0(+0x7851)[0x7fdf7ab9a851]
/lib64/libc.so.6(clone+0x6d)[0x7fdf79b0511d]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7fdf540048e0): SHOW ENGINE INNODB STATUS
Connection ID (thread ID): 5
...

Oracle's 5.6.8-rc passed without crashes in the same environment.

Older Percona server versions (like 5.5.27) are easy to crash this way with RQG:

...
121207 20:58:46 [Note] /home/openxs/dbs/p5.5/bin/mysqld: ready for connections.
Version: '5.5.27-log'  socket: '/home/openxs/dbs/p5.5/mysql-test/var/tmp/master.sock'  port: 19300  Source distribution
17:59:23 UTC - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.
Please help us make Percona Server better by reporting any
bugs at http://bugs.percona.com/

key_buffer_size=1048576
read_buffer_size=131072
max_used_connections=3
max_threads=151
thread_count=3
connection_count=3
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 60853 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7fdf540048e0): SHOW ENGINE INNODB STATUS
Connection ID (thread ID): 5
...

Oracle's 5.6.8-rc passed without crashes in the same environment.

Revision history for this message

Sergei Glushchenko (sergei.glushchenko) wrote on 2012-12-20:

#11

Both bugs (#1036506, #1017192) are abount crashing explain_filename when input filename looks like "#sql-1979_11#P#p0". This is introduced in upstream revision 0.16394.68. Percona Server 5.1 is not affected. MariaDB released fix for it in revision 3413.1.78

Revision history for this message

Alexey Kopytov (akopytov) wrote on 2012-12-20:

#12

Then we should have an upstream bug report. So we need to verify it against upstream 5.5. Currently we only have a report that it's not reproducible with upstream 5.6.8-rc.

Revision history for this message

Roel Van de Paar (roel11) wrote on 2012-12-21:

#13

Ref note #2 on bug 1036506 re: testing against upstream for that bug.

Revision history for this message

Sergei Glushchenko (sergei.glushchenko) wrote on 2012-12-21:

#14

Download full text (28.9 KiB)

I'm able to reproduce on mysql 5.5 trunk by just injecting call

ut_print_name(stderr, trx, TRUE, table->name);

at the start of row_create_table_for_mysql.

[sergei@centos6 mysql-test]$ cat ../../mysql-test/t/crash.test
--source include/have_partition.inc
--source include/have_innodb.inc

CREATE TABLE IF NOT EXISTS t1 (`a` INT) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1),(2),(3),(4);

--connect (con1,localhost,root,,)

ALTER TABLE t1 PARTITION BY HASH (`a`) PARTITIONS 4;

DROP TABLE t1;

[sergei@centos6 mysql-test]$ ./mtr crash.test
Logging: /home/sergei/percona/upstream/55-et-crash/mysql-test/mysql-test-run.pl crash.test
MySQL Version 5.5.28
Checking supported features...
- skipping ndbcluster
- skipping SSL, mysqld not compiled with SSL
Collecting tests...
vardir: /home/sergei/percona/upstream/55-et-crash/build/mysql-test/var
Checking leftover processes...
Removing old var directory...
Creating var directory '/home/sergei/percona/upstream/55-et-crash/build/mysql-test/var'...
Installing system database...
Using server port 51161

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

TEST RESULT TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
CREATE TABLE IF NOT EXISTS t1 (`a` INT) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1),(2),(3),(4);
main.crash [ fail ]
Test ended at 2012-12-21 23:57:44

CURRENT_TEST: main.crash
mysqltest: At line 9: query 'ALTER TABLE t1 PARTITION BY HASH (`a`) PARTITIONS 4' failed: 2013: Lost connection to MySQL server during query

Server [mysqld.1 - pid: 61076, winpid: 61076, exit: 256] failed during test run
Server log from this test:
----------SERVER LOG START-----------
121221 19:57:37 InnoDB: The InnoDB memory heap is disabled
121221 19:57:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins
121221 19:57:37 InnoDB: Compressed tables use zlib 1.2.3
121221 19:57:37 InnoDB: Using Linux native AIO
121221 19:57:37 InnoDB: Initializing buffer pool, size = 8.0M
121221 19:57:37 InnoDB: Completed initialization of buffer pool
121221 19:57:37 InnoDB: highest supported file format is Barracuda.
121221 19:57:37 InnoDB: Waiting for the background threads to start
121221 19:57:38 InnoDB: 1.1.8 started; log sequence number 1595675
121221 19:57:38 [Warning] /home/sergei/percona/upstream/55-et-crash/build/sql/mysqld: unknown variable 'loose-debug-sync-timeout=300'
121221 19:57:38 [Note] Server hostname (bind-address): '0.0.0.0'; port: 13000
121221 19:57:38 [Note] - '0.0.0.0' resolves to '0.0.0.0';
121221 19:57:38 [Note] Server socket created on IP: '0.0.0.0'.
121221 19:57:38 [Note] Event Scheduler: Loaded 0 events
121221 19:57:38 [Note] /home/sergei/percona/upstream/55-et-crash/build/sql/mysqld: ready for connections.
Version: '5.5.28-log' socket: '/home/sergei/percona/upstream/55-et-crash/build/mysql-test/var/tmp/mysqld.1.sock' port: 13000 Source distribution
`test`.`t1`16:57:39 UTC - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the librari...

I'm able to reproduce on mysql 5.5 trunk by just injecting call

ut_print_name(stderr, trx, TRUE, table->name);

at the start of row_create_table_for_mysql.

[sergei@centos6 mysql-test]$ cat ../../mysql-test/t/crash.test 
--source include/have_partition.inc
--source include/have_innodb.inc

CREATE TABLE IF NOT EXISTS t1 (`a` INT) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1),(2),(3),(4);

--connect (con1,localhost,root,,)

ALTER TABLE t1 PARTITION BY HASH (`a`) PARTITIONS 4;

DROP TABLE t1;

[sergei@centos6 mysql-test]$ ./mtr crash.test
Logging: /home/sergei/percona/upstream/55-et-crash/mysql-test/mysql-test-run.pl  crash.test
MySQL Version 5.5.28
Checking supported features...
 - skipping ndbcluster
 - skipping SSL, mysqld not compiled with SSL
Collecting tests...
vardir: /home/sergei/percona/upstream/55-et-crash/build/mysql-test/var
Checking leftover processes...
Removing old var directory...
Creating var directory '/home/sergei/percona/upstream/55-et-crash/build/mysql-test/var'...
Installing system database...
Using server port 51161

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

TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------

CURRENT_TEST: main.crash
mysqltest: At line 9: query 'ALTER TABLE t1 PARTITION BY HASH (`a`) PARTITIONS 4' failed: 2013: Lost connection to MySQL server during query

Server [mysqld.1 - pid: 61076, winpid: 61076, exit: 256] failed during test run
Server log from this test:
----------SERVER LOG START-----------
121221 19:57:37 InnoDB: The InnoDB memory heap is disabled
121221 19:57:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins
121221 19:57:37 InnoDB: Compressed tables use zlib 1.2.3
121221 19:57:37 InnoDB: Using Linux native AIO
121221 19:57:37 InnoDB: Initializing buffer pool, size = 8.0M
121221 19:57:37 InnoDB: Completed initialization of buffer pool
121221 19:57:37 InnoDB: highest supported file format is Barracuda.
121221 19:57:37  InnoDB: Waiting for the background threads to start
121221 19:57:38 InnoDB: 1.1.8 started; log sequence number 1595675
121221 19:57:38 [Warning] /home/sergei/percona/upstream/55-et-crash/build/sql/mysqld: unknown variable 'loose-debug-sync-timeout=300'
121221 19:57:38 [Note] Server hostname (bind-address): '0.0.0.0'; port: 13000
121221 19:57:38 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
121221 19:57:38 [Note] Server socket created on IP: '0.0.0.0'.
121221 19:57:38 [Note] Event Scheduler: Loaded 0 events
121221 19:57:38 [Note] /home/sergei/percona/upstream/55-et-crash/build/sql/mysqld: ready for connections.
Version: '5.5.28-log'  socket: '/home/sergei/percona/upstream/55-et-crash/build/mysql-test/var/tmp/mysqld.1.sock'  port: 13000  Source distribution
`test`.`t1`16:57:39 UTC - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed, 
something is definitely wrong and this may fail.

key_buffer_size=1048576
read_buffer_size=131072
max_used_connections=2
max_threads=151
thread_count=2
connection_count=2
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 60729 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x249ab80
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 = 7ff24c5a9e48 thread_stack 0x40000
/home/sergei/percona/upstream/55-et-crash/build/sql/mysqld(my_print_stacktrace+0x2e)[0x7565de]
/home/sergei/percona/upstream/55-et-crash/build/sql/mysqld(handle_fatal_signal+0x41a)[0x64d49a]
/lib64/libpthread.so.0[0x385700f500]
/home/sergei/percona/upstream/55-et-crash/build/sql/mysqld[0x5b76f3]
/home/sergei/percona/upstream/55-et-crash/build/sql/mysqld(_Z16explain_filenameP3THDPKcPcj26enum_explain_filename_mode+0x363)[0x5b7c03]
/home/sergei/percona/upstream/55-et-crash/build/sql/mysqld[0x75f98e]
/home/sergei/percona/upstream/55-et-crash/build/sql/mysqld[0x760129]
/home/sergei/percona/upstream/55-et-crash/build/sql/mysqld[0x7b0fb1]
/home/sergei/percona/upstream/55-et-crash/build/sql/mysqld[0x77d363]
/home/sergei/percona/upstream/55-et-crash/build/sql/mysqld[0x762c91]
/home/sergei/percona/upstream/55-et-crash/build/sql/mysqld(_ZN12ha_partition17del_ren_cre_tableEPKcS1_P5TABLEP24st_ha_create_information+0x30d)[0x8b59fd]
/home/sergei/percona/upstream/55-et-crash/build/sql/mysqld(_ZN12ha_partition6createEPKcP5TABLEP24st_ha_create_information+0x3f)[0x8b5aaf]
/home/sergei/percona/upstream/55-et-crash/build/sql/mysqld(_Z15ha_create_tableP3THDPKcS2_S2_P24st_ha_create_informationb+0x153)[0x652b03]
/home/sergei/percona/upstream/55-et-crash/build/sql/mysqld(_Z16rea_create_tableP3THDPKcS2_S2_P24st_ha_create_informationR4ListI12Create_fieldEjP6st_keyP7handler+0x1df)[0x5e370f]
/home/sergei/percona/upstream/55-et-crash/build/sql/mysqld(_Z26mysql_create_table_no_lockP3THDPKcS2_P24st_ha_create_informationP10Alter_infobjPb+0x88e)[0x5bd48e]
/home/sergei/percona/upstream/55-et-crash/build/sql/mysqld(_Z17mysql_alter_tableP3THDPcS1_P24st_ha_create_informationP10TABLE_LISTP10Alter_infojP8st_orderb+0xffa)[0x5c003a]
/home/sergei/percona/upstream/55-et-crash/build/sql/mysqld(_ZN21Alter_table_statement7executeEP3THD+0x4b3)[0x73b9d3]
/home/sergei/percona/upstream/55-et-crash/build/sql/mysqld(_Z21mysql_execute_commandP3THD+0xfc7)[0x567e77]
/home/sergei/percona/upstream/55-et-crash/build/sql/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x189)[0x56b369]
/home/sergei/percona/upstream/55-et-crash/build/sql/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x11e3)[0x56cca3]
/home/sergei/percona/upstream/55-et-crash/build/sql/mysqld(_Z24do_handle_one_connectionP3THD+0x176)[0x5f7a76]
/home/sergei/percona/upstream/55-et-crash/build/sql/mysqld(handle_one_connection+0x4a)[0x5f7ada]
/home/sergei/percona/upstream/55-et-crash/build/sql/mysqld(pfs_spawn_thread+0x54)[0x866df4]
/lib64/libpthread.so.0[0x3857007851]
/lib64/libc.so.6(clone+0x6d)[0x38568e811d]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7ff230004b80): ALTER TABLE t1 PARTITION BY HASH (`a`) PARTITIONS 4
Connection ID (thread ID): 3
Status: NOT_KILLED

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
Writing a core file
----------SERVER LOG END-------------

- saving '/home/sergei/percona/upstream/55-et-crash/build/mysql-test/var/log/main.crash/' to '/home/sergei/percona/upstream/55-et-crash/build/mysql-test/var/log/main.crash/'
 - found 'core.61077' (0/5)

Trying 'dbx' to get a backtrace

Trying 'gdb' to get a backtrace
Core generated by '/home/sergei/percona/upstream/55-et-crash/build/sql/mysqld'
Output from gdb follows. The first stack trace is from the failing thread.
The following stack traces are from all threads (so the failing one is
duplicated).
--------------------------
Missing separate debuginfo for 
Try: yum --disablerepo='*' --enablerepo='*-debug*' install /usr/lib/debug/.build-id/98/5a5bb5fc57c6305be25c76f45d8feff775cc57
[New Thread 61100]
[New Thread 61077]
[New Thread 61079]
[New Thread 61080]
[New Thread 61081]
[New Thread 61082]
[New Thread 61083]
[New Thread 61084]
[New Thread 61086]
[New Thread 61087]
[New Thread 61088]
[New Thread 61089]
[New Thread 61091]
[New Thread 61099]
[Thread debugging using libthread_db enabled]
Core was generated by `/home/sergei/percona/upstream/55-et-crash/build/sql/mysqld --defaults-group-suf'.
Program terminated with signal 11, Segmentation fault.
#0  0x000000385700c69c in pthread_kill () from /lib64/libpthread.so.0
#0  0x000000385700c69c in pthread_kill () from /lib64/libpthread.so.0
#1  0x000000000064d452 in handle_fatal_signal (sig=11) at /home/sergei/percona/upstream/55-et-crash/sql/signal_handler.cc:247
#2  <signal handler called>
#3  add_identifier (thd=0x249ab80, to_p=0x7ff24c5a224a "\001\060\362\177", end_p=0x7ff24c5a2320 "#sql-ee95_3#P#p0", name=0x7ff24c5a232e "p0", name_len=4294967293) at /home/sergei/percona/upstream/55-et-crash/sql/sql_table.cc:104
#4  0x00000000005b7c03 in explain_filename (thd=0x249ab80, from=<value optimized out>, to=0x7ff24c5a2220 "`#sql-ee95_3#P#p0` /* Temporary Partition \001\060\362\177", to_length=256, explain_mode=EXPLAIN_PARTITIONS_AS_COMMENT) at /home/sergei/percona/upstream/55-et-crash/sql/sql_table.cc:356
#5  0x000000000075f98e in innobase_convert_identifier (buf=0x7ff24c5a2497 "", buflen=569, id=0x7ff230007c45 "#sql-ee95_3#P#p0", idlen=16, thd=0x249ab80, file_id=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/handler/ha_innodb.cc:1997
#6  0x0000000000760129 in innobase_convert_name (buf=0x7ff24c5a2490 "`test`.", buflen=<value optimized out>, id=<value optimized out>, idlen=21, thd=0x249ab80, table_id=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/handler/ha_innodb.cc:2083
#7  0x00000000007b0fb1 in ut_print_namel (f=0x3856b8d860, trx=<value optimized out>, table_id=<value optimized out>, name=<value optimized out>, namelen=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/ut/ut0ut.c:552
#8  0x000000000077d363 in row_create_table_for_mysql (table=0x7ff230020cb8, trx=0x7ff230020318) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/row/row0mysql.c:1881
#9  0x0000000000762c91 in create_table_def (this=<value optimized out>, name=<value optimized out>, form=0x7ff24c5a3700, create_info=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/handler/ha_innodb.cc:6639
#10 ha_innobase::create (this=<value optimized out>, name=<value optimized out>, form=0x7ff24c5a3700, create_info=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/handler/ha_innodb.cc:7242
#11 0x00000000008b59fd in ha_partition::del_ren_cre_table (this=0x7ff230017ed0, from=0x7ff24c5a34c0 "./test/#sql-ee95_3", to=0x0, table_arg=0x7ff24c5a3700, create_info=0x7ff24c5a77c0) at /home/sergei/percona/upstream/55-et-crash/sql/ha_partition.cc:1977
#12 0x00000000008b5aaf in ha_partition::create (this=0x7ff230017ed0, name=<value optimized out>, table_arg=0x7ff24c5a3700, create_info=0x7ff24c5a77c0) at /home/sergei/percona/upstream/55-et-crash/sql/ha_partition.cc:596
#13 0x0000000000652b03 in ha_create_table (thd=0x249ab80, path=<value optimized out>, db=0x7ff2300051c0 "test", table_name=0x7ff24c5a70d0 "#sql-ee95_3", create_info=<value optimized out>, update_create_info=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/sql/handler.cc:3784
#14 0x00000000005e370f in rea_create_table (thd=0x249ab80, path=0x7ff24c5a5460 "./test/#sql-ee95_3", db=0x7ff2300051c0 "test", table_name=0x7ff24c5a70d0 "#sql-ee95_3", create_info=0x7ff24c5a77c0, create_fields=<value optimized out>, keys=0, key_info=0x7ff2300062e8, file=0x7ff230005f98) at /home/sergei/percona/upstream/55-et-crash/sql/unireg.cc:528
#15 0x00000000005bd48e in mysql_create_table_no_lock (thd=0x249ab80, db=0x7ff2300051c0 "test", table_name=0x7ff24c5a70d0 "#sql-ee95_3", create_info=0x7ff24c5a77c0, alter_info=0x7ff24c5a78a0, internal_tmp_table=true, select_field_count=0, is_trans=0x0) at /home/sergei/percona/upstream/55-et-crash/sql/sql_table.cc:4292
#16 0x00000000005c003a in mysql_alter_table (thd=<value optimized out>, new_db=<value optimized out>, new_name=0x7ff230004c60 "t1", create_info=0x7ff24c5a77c0, table_list=0x7ff200000001, alter_info=<value optimized out>, order_num=0, order=0x0, ignore=false) at /home/sergei/percona/upstream/55-et-crash/sql/sql_table.cc:6430
#17 0x000000000073b9d3 in Alter_table_statement::execute (this=<value optimized out>, thd=0x249ab80) at /home/sergei/percona/upstream/55-et-crash/sql/sql_alter.cc:106
#18 0x0000000000567e77 in mysql_execute_command (thd=0x249ab80) at /home/sergei/percona/upstream/55-et-crash/sql/sql_parse.cc:4431
#19 0x000000000056b369 in mysql_parse (thd=0x249ab80, rawbuf=<value optimized out>, length=51, parser_state=0x7ff24c5a9980) at /home/sergei/percona/upstream/55-et-crash/sql/sql_parse.cc:5627
#20 0x000000000056cca3 in dispatch_command (command=COM_QUERY, thd=0x249ab80, packet=<value optimized out>, packet_length=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/sql/sql_parse.cc:1037
#21 0x00000000005f7a76 in do_handle_one_connection (thd_arg=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/sql/sql_connect.cc:840
#22 0x00000000005f7ada in handle_one_connection (arg=0x249ab80) at /home/sergei/percona/upstream/55-et-crash/sql/sql_connect.cc:759
#23 0x0000000000866df4 in pfs_spawn_thread (arg=0x2431dd0) at /home/sergei/percona/upstream/55-et-crash/storage/perfschema/pfs.cc:1015
#24 0x0000003857007851 in start_thread () from /lib64/libpthread.so.0
#25 0x00000038568e811d in clone () from /lib64/libc.so.6

Thread 14 (Thread 0x7ff24c5eb700 (LWP 61099)):
#0  0x000000385700e54d in read () from /lib64/libpthread.so.0
#1  0x000000000050776b in my_real_read (net=0x24146d0, complen=0x7ff24c5eadc8) at /home/sergei/percona/upstream/55-et-crash/sql/net_serv.cc:831
#2  0x0000000000507b55 in my_net_read (net=0x24146d0) at /home/sergei/percona/upstream/55-et-crash/sql/net_serv.cc:1028
#3  0x000000000056d207 in do_command (thd=0x24144e0) at /home/sergei/percona/upstream/55-et-crash/sql/sql_parse.cc:719
#4  0x00000000005f7a76 in do_handle_one_connection (thd_arg=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/sql/sql_connect.cc:840
#5  0x00000000005f7ada in handle_one_connection (arg=0x24144e0) at /home/sergei/percona/upstream/55-et-crash/sql/sql_connect.cc:759
#6  0x0000000000866df4 in pfs_spawn_thread (arg=0x2431dd0) at /home/sergei/percona/upstream/55-et-crash/storage/perfschema/pfs.cc:1015
#7  0x0000003857007851 in start_thread () from /lib64/libpthread.so.0
#8  0x00000038568e811d in clone () from /lib64/libc.so.6

Thread 13 (Thread 0x7ff24c62c700 (LWP 61091)):
#0  0x000000385700f2a5 in sigwait () from /lib64/libpthread.so.0
#1  0x000000000050071b in signal_hand (arg=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/sql/mysqld.cc:2698
#2  0x0000000000866df4 in pfs_spawn_thread (arg=0x1f63100) at /home/sergei/percona/upstream/55-et-crash/storage/perfschema/pfs.cc:1015
#3  0x0000003857007851 in start_thread () from /lib64/libpthread.so.0
#4  0x00000038568e811d in clone () from /lib64/libc.so.6

Thread 12 (Thread 0x7ff2407fe700 (LWP 61089)):
#0  0x00000038568e0d03 in select () from /lib64/libc.so.6
#1  0x00000000008356ab in os_thread_sleep (tm=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/os/os0thread.c:259
#2  0x000000000078fdc5 in srv_master_thread (arg=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/srv/srv0srv.c:2805
#3  0x0000003857007851 in start_thread () from /lib64/libpthread.so.0
#4  0x00000038568e811d in clone () from /lib64/libc.so.6

Thread 11 (Thread 0x7ff2411ff700 (LWP 61088)):
#0  0x000000385700b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x00000000008350a3 in os_cond_wait_timed (event=0x21df760, time_in_usec=5000000, reset_sig_count=1) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/os/os0sync.c:171
#2  os_event_wait_time_low (event=0x21df760, time_in_usec=5000000, reset_sig_count=1) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/os/os0sync.c:716
#3  0x00000000007914db in srv_monitor_thread (arg=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/srv/srv0srv.c:2137
#4  0x0000003857007851 in start_thread () from /lib64/libpthread.so.0
#5  0x00000038568e811d in clone () from /lib64/libc.so.6

Thread 10 (Thread 0x7ff241c00700 (LWP 61087)):
#0  0x000000385700b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x00000000008350a3 in os_cond_wait_timed (event=0x21df660, time_in_usec=1000000, reset_sig_count=1) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/os/os0sync.c:171
#2  os_event_wait_time_low (event=0x21df660, time_in_usec=1000000, reset_sig_count=1) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/os/os0sync.c:716
#3  0x000000000078e4bb in srv_error_monitor_thread (arg=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/srv/srv0srv.c:2470
#4  0x0000003857007851 in start_thread () from /lib64/libpthread.so.0
#5  0x00000038568e811d in clone () from /lib64/libc.so.6

Thread 9 (Thread 0x7ff242601700 (LWP 61086)):
#0  0x000000385700b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x00000000008350a3 in os_cond_wait_timed (event=0x21df6e0, time_in_usec=1000000, reset_sig_count=1) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/os/os0sync.c:171
#2  os_event_wait_time_low (event=0x21df6e0, time_in_usec=1000000, reset_sig_count=1) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/os/os0sync.c:716
#3  0x000000000078e8a0 in srv_lock_timeout_thread (arg=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/srv/srv0srv.c:2287
#4  0x0000003857007851 in start_thread () from /lib64/libpthread.so.0
#5  0x00000038568e811d in clone () from /lib64/libc.so.6

Thread 8 (Thread 0x7ff243e2c700 (LWP 61084)):
#0  0x0000003856400614 in ?? () from /lib64/libaio.so.1
#1  0x0000000000831d97 in os_aio_linux_collect (global_seg=5, message1=0x7ff243e2be78, message2=0x7ff243e2be70, type=0x7ff243e2be68) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/os/os0file.c:4526
#2  os_aio_linux_handle (global_seg=5, message1=0x7ff243e2be78, message2=0x7ff243e2be70, type=0x7ff243e2be68) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/os/os0file.c:4670
#3  0x00000000007f62f6 in fil_aio_wait (segment=5) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/fil/fil0fil.c:4563
#4  0x0000000000792148 in io_handler_thread (arg=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/srv/srv0start.c:482
#5  0x0000003857007851 in start_thread () from /lib64/libpthread.so.0
#6  0x00000038568e811d in clone () from /lib64/libc.so.6

Thread 7 (Thread 0x7ff24482d700 (LWP 61083)):
#0  0x0000003856400614 in ?? () from /lib64/libaio.so.1
#1  0x0000000000831d97 in os_aio_linux_collect (global_seg=4, message1=0x7ff24482ce78, message2=0x7ff24482ce70, type=0x7ff24482ce68) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/os/os0file.c:4526
#2  os_aio_linux_handle (global_seg=4, message1=0x7ff24482ce78, message2=0x7ff24482ce70, type=0x7ff24482ce68) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/os/os0file.c:4670
#3  0x00000000007f62f6 in fil_aio_wait (segment=4) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/fil/fil0fil.c:4563
#4  0x0000000000792148 in io_handler_thread (arg=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/srv/srv0start.c:482
#5  0x0000003857007851 in start_thread () from /lib64/libpthread.so.0
#6  0x00000038568e811d in clone () from /lib64/libc.so.6

Thread 6 (Thread 0x7ff24522e700 (LWP 61082)):
#0  0x0000003856400614 in ?? () from /lib64/libaio.so.1
#1  0x0000000000831d97 in os_aio_linux_collect (global_seg=3, message1=0x7ff24522de78, message2=0x7ff24522de70, type=0x7ff24522de68) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/os/os0file.c:4526
#2  os_aio_linux_handle (global_seg=3, message1=0x7ff24522de78, message2=0x7ff24522de70, type=0x7ff24522de68) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/os/os0file.c:4670
#3  0x00000000007f62f6 in fil_aio_wait (segment=3) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/fil/fil0fil.c:4563
#4  0x0000000000792148 in io_handler_thread (arg=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/srv/srv0start.c:482
#5  0x0000003857007851 in start_thread () from /lib64/libpthread.so.0
#6  0x00000038568e811d in clone () from /lib64/libc.so.6

Thread 5 (Thread 0x7ff245c2f700 (LWP 61081)):
#0  0x0000003856400614 in ?? () from /lib64/libaio.so.1
#1  0x0000000000831d97 in os_aio_linux_collect (global_seg=2, message1=0x7ff245c2ee78, message2=0x7ff245c2ee70, type=0x7ff245c2ee68) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/os/os0file.c:4526
#2  os_aio_linux_handle (global_seg=2, message1=0x7ff245c2ee78, message2=0x7ff245c2ee70, type=0x7ff245c2ee68) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/os/os0file.c:4670
#3  0x00000000007f62f6 in fil_aio_wait (segment=2) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/fil/fil0fil.c:4563
#4  0x0000000000792148 in io_handler_thread (arg=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/srv/srv0start.c:482
#5  0x0000003857007851 in start_thread () from /lib64/libpthread.so.0
#6  0x00000038568e811d in clone () from /lib64/libc.so.6

Thread 4 (Thread 0x7ff246630700 (LWP 61080)):
#0  0x0000003856400614 in ?? () from /lib64/libaio.so.1
#1  0x0000000000831d97 in os_aio_linux_collect (global_seg=1, message1=0x7ff24662fe78, message2=0x7ff24662fe70, type=0x7ff24662fe68) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/os/os0file.c:4526
#2  os_aio_linux_handle (global_seg=1, message1=0x7ff24662fe78, message2=0x7ff24662fe70, type=0x7ff24662fe68) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/os/os0file.c:4670
#3  0x00000000007f62f6 in fil_aio_wait (segment=1) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/fil/fil0fil.c:4563
#4  0x0000000000792148 in io_handler_thread (arg=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/srv/srv0start.c:482
#5  0x0000003857007851 in start_thread () from /lib64/libpthread.so.0
#6  0x00000038568e811d in clone () from /lib64/libc.so.6

Thread 3 (Thread 0x7ff24df76700 (LWP 61079)):
#0  0x0000003856400614 in ?? () from /lib64/libaio.so.1
#1  0x0000000000831d97 in os_aio_linux_collect (global_seg=0, message1=0x7ff24df75e78, message2=0x7ff24df75e70, type=0x7ff24df75e68) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/os/os0file.c:4526
#2  os_aio_linux_handle (global_seg=0, message1=0x7ff24df75e78, message2=0x7ff24df75e70, type=0x7ff24df75e68) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/os/os0file.c:4670
#3  0x00000000007f62f6 in fil_aio_wait (segment=0) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/fil/fil0fil.c:4563
#4  0x0000000000792148 in io_handler_thread (arg=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/srv/srv0start.c:482
#5  0x0000003857007851 in start_thread () from /lib64/libpthread.so.0
#6  0x00000038568e811d in clone () from /lib64/libc.so.6

Thread 2 (Thread 0x7ff24df78720 (LWP 61077)):
#0  0x00000038568dea63 in poll () from /lib64/libc.so.6
#1  0x0000000000501516 in handle_connections_sockets () at /home/sergei/percona/upstream/55-et-crash/sql/mysqld.cc:5163
#2  0x0000000000505e1f in mysqld_main (argc=46, argv=0x1ef3970) at /home/sergei/percona/upstream/55-et-crash/sql/mysqld.cc:4611
#3  0x000000385681ecdd in __libc_start_main () from /lib64/libc.so.6
#4  0x00000000004fd6bd in _start ()

Thread 1 (Thread 0x7ff24c5aa700 (LWP 61100)):
#0  0x000000385700c69c in pthread_kill () from /lib64/libpthread.so.0
#1  0x000000000064d452 in handle_fatal_signal (sig=11) at /home/sergei/percona/upstream/55-et-crash/sql/signal_handler.cc:247
#2  <signal handler called>
#3  add_identifier (thd=0x249ab80, to_p=0x7ff24c5a224a "\001\060\362\177", end_p=0x7ff24c5a2320 "#sql-ee95_3#P#p0", name=0x7ff24c5a232e "p0", name_len=4294967293) at /home/sergei/percona/upstream/55-et-crash/sql/sql_table.cc:104
#4  0x00000000005b7c03 in explain_filename (thd=0x249ab80, from=<value optimized out>, to=0x7ff24c5a2220 "`#sql-ee95_3#P#p0` /* Temporary Partition \001\060\362\177", to_length=256, explain_mode=EXPLAIN_PARTITIONS_AS_COMMENT) at /home/sergei/percona/upstream/55-et-crash/sql/sql_table.cc:356
#5  0x000000000075f98e in innobase_convert_identifier (buf=0x7ff24c5a2497 "", buflen=569, id=0x7ff230007c45 "#sql-ee95_3#P#p0", idlen=16, thd=0x249ab80, file_id=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/handler/ha_innodb.cc:1997
#6  0x0000000000760129 in innobase_convert_name (buf=0x7ff24c5a2490 "`test`.", buflen=<value optimized out>, id=<value optimized out>, idlen=21, thd=0x249ab80, table_id=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/handler/ha_innodb.cc:2083
#7  0x00000000007b0fb1 in ut_print_namel (f=0x3856b8d860, trx=<value optimized out>, table_id=<value optimized out>, name=<value optimized out>, namelen=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/ut/ut0ut.c:552
#8  0x000000000077d363 in row_create_table_for_mysql (table=0x7ff230020cb8, trx=0x7ff230020318) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/row/row0mysql.c:1881
#9  0x0000000000762c91 in create_table_def (this=<value optimized out>, name=<value optimized out>, form=0x7ff24c5a3700, create_info=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/handler/ha_innodb.cc:6639
#10 ha_innobase::create (this=<value optimized out>, name=<value optimized out>, form=0x7ff24c5a3700, create_info=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/storage/innobase/handler/ha_innodb.cc:7242
#11 0x00000000008b59fd in ha_partition::del_ren_cre_table (this=0x7ff230017ed0, from=0x7ff24c5a34c0 "./test/#sql-ee95_3", to=0x0, table_arg=0x7ff24c5a3700, create_info=0x7ff24c5a77c0) at /home/sergei/percona/upstream/55-et-crash/sql/ha_partition.cc:1977
#12 0x00000000008b5aaf in ha_partition::create (this=0x7ff230017ed0, name=<value optimized out>, table_arg=0x7ff24c5a3700, create_info=0x7ff24c5a77c0) at /home/sergei/percona/upstream/55-et-crash/sql/ha_partition.cc:596
#13 0x0000000000652b03 in ha_create_table (thd=0x249ab80, path=<value optimized out>, db=0x7ff2300051c0 "test", table_name=0x7ff24c5a70d0 "#sql-ee95_3", create_info=<value optimized out>, update_create_info=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/sql/handler.cc:3784
#14 0x00000000005e370f in rea_create_table (thd=0x249ab80, path=0x7ff24c5a5460 "./test/#sql-ee95_3", db=0x7ff2300051c0 "test", table_name=0x7ff24c5a70d0 "#sql-ee95_3", create_info=0x7ff24c5a77c0, create_fields=<value optimized out>, keys=0, key_info=0x7ff2300062e8, file=0x7ff230005f98) at /home/sergei/percona/upstream/55-et-crash/sql/unireg.cc:528
#15 0x00000000005bd48e in mysql_create_table_no_lock (thd=0x249ab80, db=0x7ff2300051c0 "test", table_name=0x7ff24c5a70d0 "#sql-ee95_3", create_info=0x7ff24c5a77c0, alter_info=0x7ff24c5a78a0, internal_tmp_table=true, select_field_count=0, is_trans=0x0) at /home/sergei/percona/upstream/55-et-crash/sql/sql_table.cc:4292
#16 0x00000000005c003a in mysql_alter_table (thd=<value optimized out>, new_db=<value optimized out>, new_name=0x7ff230004c60 "t1", create_info=0x7ff24c5a77c0, table_list=0x7ff200000001, alter_info=<value optimized out>, order_num=0, order=0x0, ignore=false) at /home/sergei/percona/upstream/55-et-crash/sql/sql_table.cc:6430
#17 0x000000000073b9d3 in Alter_table_statement::execute (this=<value optimized out>, thd=0x249ab80) at /home/sergei/percona/upstream/55-et-crash/sql/sql_alter.cc:106
#18 0x0000000000567e77 in mysql_execute_command (thd=0x249ab80) at /home/sergei/percona/upstream/55-et-crash/sql/sql_parse.cc:4431
#19 0x000000000056b369 in mysql_parse (thd=0x249ab80, rawbuf=<value optimized out>, length=51, parser_state=0x7ff24c5a9980) at /home/sergei/percona/upstream/55-et-crash/sql/sql_parse.cc:5627
#20 0x000000000056cca3 in dispatch_command (command=COM_QUERY, thd=0x249ab80, packet=<value optimized out>, packet_length=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/sql/sql_parse.cc:1037
#21 0x00000000005f7a76 in do_handle_one_connection (thd_arg=<value optimized out>) at /home/sergei/percona/upstream/55-et-crash/sql/sql_connect.cc:840
#22 0x00000000005f7ada in handle_one_connection (arg=0x249ab80) at /home/sergei/percona/upstream/55-et-crash/sql/sql_connect.cc:759
#23 0x0000000000866df4 in pfs_spawn_thread (arg=0x2431dd0) at /home/sergei/percona/upstream/55-et-crash/storage/perfschema/pfs.cc:1015
#24 0x0000003857007851 in start_thread () from /lib64/libpthread.so.0
#25 0x00000038568e811d in clone () from /lib64/libc.so.6

--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 24 seconds executing testcases

Completed: Failed 1/1 tests, 0.00% were successful.

Failing test(s): main.crash

The log files in var/log may give you some hint of what went wrong.

If you want to report this error, please read first the documentation
at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html

mysql-test-run: *** ERROR: there were failing test cases

Revision history for this message

Alexey Kopytov (akopytov) wrote on 2012-12-25:

#15

Sergei, can you file an upstream bug then, and link it from this one?

Revision history for this message

Roel Van de Paar (roel11) wrote on 2013-01-16:

#16

Bug status for added clarity:

Upstream bug is not repeatable (see comment '[27 Dec 2012 23:20] Sveta Smirnova' @ upstream bug), but remains verified as logic is valid.

So, ftm, this bug is repeatable in PS only.

For this, a [ported] PS fix @ https://code.launchpad.net/~sergei.glushchenko/percona-server/ps55-bug1017192

Revision history for this message

Laurynas Biveinis (laurynas-biveinis) wrote on 2013-06-07:

#17

Since the upstream bug is closed, let's track the upstream fix here (revnos for Oracle 5.6 tree):

    ------------------------------------------------------------
    revno: 5010.1.6
    committer: Tor Didriksen <email address hidden>
    branch nick: 5.6-review
    timestamp: Thu 2013-04-11 13:53:51 +0200
    message:
      Bug#16051728 SERVER CRASHES IN ADD_IDENTIFIER ON CONCURRENT ALTER TABLE

Post push fix: do not include mytap header,
the declarations there may break other code.

Also: CHECK_CXX_COMPILER_FLAG rather than CHECK_C_COMPILER_FLAG for -Wno-null-dereference
------------------------------------------------------------
revno: 4936
committer: Tor Didriksen <email address hidden>
branch nick: 5.6
timestamp: Thu 2013-03-21 18:26:13 +0100
message:
Bug#16051728 SERVER CRASHES IN ADD_IDENTIFIER ON CONCURRENT ALTER TABLE

Post push fix: the unit test broke merge_large_tests-t
since it redefined some global settings.

  Also: no underscores in test names or test case names.
    ------------------------------------------------------------
    revno: 2875.437.26
    committer: Annamalai Gurusami <email address hidden>
    branch nick: mysql-5.5
    timestamp: Thu 2013-03-21 11:40:43 +0530
    message:
      Bug #16051728 SERVER CRASHES IN ADD_IDENTIFIER ON CONCURRENT ALTER TABLE AND
      SHOW ENGINE INNOD

Problem:

      The purpose of explain_filename() is to provide useful additional
      information regarding the partitions given the filename. This function
      was returning an error when it was not able to parse the given filename.
      For example, within InnoDB, temporary files are created with #sql-
      prefix. But this function was not able to parse it correctly.

Solution:

      It is not an error, if explain_filename() could not parse the given
      filename. If there is no partition information to explain, then silently
      return from the function.

rb#1940 approved by mattiasj

Since the upstream bug is closed, let's track the upstream fix here (revnos for Oracle 5.6 tree):

------------------------------------------------------------
    revno: 5010.1.6
    committer: Tor Didriksen <tor.didriksen@oracle.com>
    branch nick: 5.6-review
    timestamp: Thu 2013-04-11 13:53:51 +0200
    message:
      Bug#16051728 SERVER CRASHES IN ADD_IDENTIFIER ON CONCURRENT ALTER TABLE
      
      Post push fix: do not include mytap header,
      the declarations there may break other code.
      
      Also: CHECK_CXX_COMPILER_FLAG rather than CHECK_C_COMPILER_FLAG for -Wno-null-dereference
------------------------------------------------------------
revno: 4936
committer: Tor Didriksen <tor.didriksen@oracle.com>
branch nick: 5.6
timestamp: Thu 2013-03-21 18:26:13 +0100
message:
  Bug#16051728 SERVER CRASHES IN ADD_IDENTIFIER ON CONCURRENT ALTER TABLE
  
  Post push fix: the unit test broke merge_large_tests-t
  since it redefined some global settings.
  
  Also: no underscores in test names or test case names.
    ------------------------------------------------------------
    revno: 2875.437.26
    committer: Annamalai Gurusami <annamalai.gurusami@oracle.com>
    branch nick: mysql-5.5
    timestamp: Thu 2013-03-21 11:40:43 +0530
    message:
      Bug #16051728 SERVER CRASHES IN ADD_IDENTIFIER ON CONCURRENT ALTER TABLE AND
      SHOW ENGINE INNOD
      
      Problem:
      
      The purpose of explain_filename() is to provide useful additional
      information regarding the partitions given the filename.  This function
      was returning an error when it was not able to parse the given filename.
      For example, within InnoDB, temporary files are created with #sql-
      prefix.  But this function was not able to parse it correctly.
      
      Solution:
      
      It is not an error, if explain_filename() could not parse the given
      filename.  If there is no partition information to explain, then silently
      return from the function.
      
      rb#1940 approved by mattiasj

Laurynas Biveinis (laurynas-biveinis) on 2017-08-01

tags:

added: upstream

Revision history for this message

Shahriyar Rzayev (rzayev-sehriyar) wrote on 2018-01-25:

#18

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

Report a bug

This report contains Public information

Everyone can see this information.

Duplicates of this bug

You are

Subscribing...

Edit bug mail

Other bug subscribers

Remote bug watches

mysql-bugs #67974 Edit

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