[Bug 1366073] [NEW] Combination of CREATE, RENAME, and ALTER TABLE statements on related tables causes crash

[Launchpad Bug Tracker]

You have been subscribed to a public bug:

Recently set up a new database server with percona-server-server-5.6
version 5.6.20. After installing the database I ran our migration
scripts to configure the database, which failed part way through saying
it had lost connection to the database.

After some investigation we found that percona was crashing during the
migration due to one of the alter table statements, generating the
attached stacktrace.

Trying the same process against the previous release, 5.6.19, worked as
expected with the migration script completing and the server remaining
available.

Attempted to create a simple example of what the migration script was
doing but the bug seems to vary based on how many tables are needed to
be created renamed / altered before the server will crash. Wrapping the
rename or alteration in a transaction seems to increase the likelihood
of the server crashing. It is still possible to crash the server without
transactions but not as reliably, sometimes requiring the example to be
run multiple times in quick succession before the server would crash.

The bug is definitely related to related tables (with foreign keys) been
renamed and their related columns being renamed, as doing one without
the other does not result in a crash, however many times you try in
quick succession.

Attached is a script that will generate some tables that relate to a
further table, and then attempt to rename the base table followed by
renaming the related columns in the other tables.  After some playing
around I was able to get the server to reliably crash with 20 related
tables, with it sometimes crashing with as low as 11 related tables.
This is against a fresh install of percona-server-server-5.6 version
5.6.20 with no modification to config.

** Affects: mysql-5.6 (Ubuntu)
     Importance: Undecided
         Status: New

** Affects: percona-server
     Importance: Undecided
         Status: New

** Affects: percona-server/5.1
     Importance: Undecided
         Status: New

** Affects: percona-server/5.5
     Importance: Undecided
         Status: New

** Affects: percona-server/5.6
     Importance: Undecided
         Status: New

-- 
Combination of CREATE, RENAME, and ALTER TABLE statements on related tables causes crash
https://bugs.launchpad.net/bugs/1366073
You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.6 in Ubuntu.