Ubuntu/Debian startup script and SIGHUP issue

Bug #1104720 reported by Cafuego on 2013-01-25
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona Server
Status tracked in 5.7
5.1
Medium
Unassigned
5.5
Medium
Unassigned
5.6
Medium
Unassigned
5.7
Medium
Unassigned
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC
Fix Released
Medium
Raghavendra D Prabhu

Bug Description

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.

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.

tags: added: init-script sighup
summary: - Ubuntu startup script causes fails (& loops)
+ Ubuntu startup script and SIGHUP issue
Changed in percona-xtradb-cluster:
milestone: none → 5.5.30-24.8
status: New → Triaged
assignee: nobody → Raghavendra D Prabhu (raghavendra-prabhu)
importance: Undecided → Medium

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

Changed in percona-xtradb-cluster:
status: Triaged → Fix Committed
summary: - Ubuntu startup script and SIGHUP issue
+ Ubuntu/Debian startup script and SIGHUP issue

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.

tags: added: pkg
Changed in percona-xtradb-cluster:
status: Fix Committed → Fix Released

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

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.