Ubuntu/Debian startup script and SIGHUP issue

[Cafuego]

I just updated my local Percona 5.5 server install to Percona XtraDB Cluster 5.5 (without problems) on Ubuntu Precise.

On a newly provisioned Precise VM, I installed Percona XtraDB Cluster 5.5 and found that the init script kept looping on a failed query:

"...corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT '"

I remembered I'd come across that problem before and found https://bugs.launchpad.net/ourdelta/+bug/484120

The single line change to `debian-start' to trap SIGHUP that Kristian Nielsen made in https://code.launchpad.net/~knielsen/ourdelta/bug_484127_484120_2 resolves the problem when I apply it locally and causes Percona XtraDB Cluster 5.5 to install and start properly.

[Raghavendra D Prabhu (raghavendra-prabhu)]

Adding Percona Server (PS) since it seems to be a bug with PS too.

https://bazaar.launchpad.net/~knielsen/ourdelta/bug_484127_484120_2/revision/68 seems to be the revision.

[Raghavendra D Prabhu (raghavendra-prabhu)]

A related issue here -- http://bugs.mysql.com/bug.php?id=62311 but not related to mysql_upgrade issue here.

[Valerii Kravchuk (valerii-kravchuk)]

Looks like http://bazaar.launchpad.net/~percona-core/percona-server/5.6/view/head:/build/debian/additions/debian-start (and files for versions 5.1 and 5.5) should be patched the same way as in recent Percona XtraDB Cluster code.

[Shahriyar Rzayev (rzayev-sehriyar)]

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

[Shahriyar Rzayev (rzayev-sehriyar)]

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