LP #1104720: Ubuntu/Debian startup script and SIGHUP issue

Description

**Reported in Launchpad by Cafuego last update 24-03-2016 10:37:52

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.

Environment

None

Smart Checklist

Activity

Show:

lpjirasync January 12, 2018 at 10:45 AM

**Comment from Launchpad by: Valerii Kravchuk on: 27-05-2013 15:16:52

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.

lpjirasync January 12, 2018 at 10:45 AM

**Comment from Launchpad by: Raghavendra D Prabhu on: 10-05-2013 05:45:41

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

lpjirasync January 12, 2018 at 10:45 AM

**Comment from Launchpad by: Raghavendra D Prabhu on: 04-04-2013 17:38:04

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.

Done

Details

Assignee

Reporter

Components

Priority

Smart Checklist

Created January 12, 2018 at 10:45 AM
Updated December 25, 2018 at 5:26 PM
Resolved December 15, 2023 at 2:26 PM