Percona server crashes on ALTER TABLE on temporary table
We have a 3.2TB big production server running SLES 11.1 and Mysql Server 5.1.54.
I created a backup with xtrabackup ( and cp, rsync, ... on other occasions ), and used this data to setup a new server on CentOS 6.2 with Percona server 5.5.21 ( and 5.1.61 later on to make sure it wasn't only related to 5.5, which it isnt, crashes on PS 5.1 as well. ).
Setting up a slave to the 'old' server from the CentOS server works like a charm, 25000 seconds worth of transactions completed just fine, and the PS 5.5 instance caught up with the master.
Then i wanted to create a temporary table, fill it with some data, and then needed to add a primary key to it. It crashed.
I have consistently been able to reproduce it on this data by doing:
mysql> use test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
mysql> create temporary table t1 (id int);
Query OK, 0 rows affected (1.97 sec)
mysql> alter table t1 engine=myisam;
ERROR 2013 (HY000): Lost connection to MySQL server during query
Tried both with engine=myisam and innodb.
I've resolved the stacktrace to this:
0x3188a0f4a0 _end + -2020000832
0x7f6b7b innobase_get_trx + 5419
0x51654a unireg_abort + 2858
0x50fa79 _start + 41
Full mysqld.err attached ( disregard the beginning of the file, that was before my backup was restored there ;) ).
Using a clean /var/lib/mysql doesn't trigger the crash, so it must be some kind of corruption in the live data..
|Laurynas Biveinis (laurynas-biveinis) wrote : Re: [Bug 978036] Re: Percona server crashes on ALTER TABLE on temporary table||#6|