[Bug 1406813] Re: Piping ALTER TABLE commands throuh mysql client corrupts INNODB tables

[Larry Irwin]

Having issue with 5.5 when scripting updates to table structures.
In many cases, adding a new column will result in the xxx.ibd file left in place and three #sqlxxxxx files.
And it is too much trouble to go through the innodb recovery process - so I re-load the database(s).
I will create repeatable script and submit.
It does not occur on mysql 5.1 nor 5.0 on any of the 70+ servers I work on.
Only  on version 5.5 am I having this problem - and only when scripted to cycle through multiple database instances updating all their structures.


** Changed in: mysql-5.5 (Ubuntu)
       Status: New => Invalid

** Converted to question:
   https://answers.launchpad.net/ubuntu/+source/mysql-5.5/+question/259948

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-5.5 in Ubuntu.
https://bugs.launchpad.net/bugs/1406813

Title:
  Piping ALTER TABLE commands throuh mysql  client corrupts INNODB
  tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.5/+bug/1406813/+subscriptions