2011-11-21 21:52:06 |
Devin Vance |
bug |
|
|
added bug |
2011-11-22 10:03:29 |
Florian Haas |
cluster-agents (Ubuntu): status |
New |
Fix Committed |
|
2011-11-22 19:22:36 |
Adam Gandelman |
cluster-agents (Ubuntu): status |
Fix Committed |
Confirmed |
|
2011-11-22 19:22:36 |
Adam Gandelman |
cluster-agents (Ubuntu): assignee |
|
Adam Gandelman (gandelman-a) |
|
2011-11-22 19:22:47 |
Adam Gandelman |
cluster-agents (Ubuntu): status |
Confirmed |
In Progress |
|
2011-11-22 19:48:22 |
Launchpad Janitor |
branch linked |
|
lp:~gandelman-a/ubuntu/lucid/cluster-agents/lp893352 |
|
2011-11-22 19:51:31 |
Andres Rodriguez |
nominated for series |
|
Ubuntu Hardy |
|
2011-11-22 19:51:31 |
Andres Rodriguez |
bug task added |
|
cluster-agents (Ubuntu Hardy) |
|
2011-11-22 19:51:38 |
Andres Rodriguez |
nominated for series |
|
Ubuntu Lucid |
|
2011-11-22 19:51:38 |
Andres Rodriguez |
bug task added |
|
cluster-agents (Ubuntu Lucid) |
|
2011-11-22 19:51:45 |
Andres Rodriguez |
cluster-agents (Ubuntu Hardy): status |
New |
Incomplete |
|
2011-11-22 19:51:50 |
Andres Rodriguez |
cluster-agents (Ubuntu Hardy): status |
Incomplete |
Invalid |
|
2011-11-22 19:55:19 |
Adam Gandelman |
cluster-agents (Ubuntu Lucid): status |
New |
In Progress |
|
2011-11-22 19:55:19 |
Adam Gandelman |
cluster-agents (Ubuntu Lucid): assignee |
|
Adam Gandelman (gandelman-a) |
|
2011-11-22 20:53:21 |
Adam Gandelman |
description |
Due to ubuntu putting /var/run on a tempory fs the /var/run/mysqld directory is removed upon a reboot. Mysql will fail to start via the crm after next boot as it cannot access or find the the needed /var/run/mysqld directory.
This directory is created in the OCF script in the mysql_start() function , but for some reason not until after the script checks for the directory and write permissions, logs an error, and exits. (Line 345)
I have fixed it by merely moving the if statement which test -w the pid_dir to after the if statements which create the pid_dir (line 350) |
Due to ubuntu putting /var/run on a tempory fs the /var/run/mysqld directory is removed upon a reboot. Mysql will fail to start via the crm after next boot as it cannot access or find the the needed /var/run/mysqld directory.
This directory is created in the OCF script in the mysql_start() function , but for some reason not until after the script checks for the directory and write permissions, logs an error, and exits. (Line 345)
I have fixed it by merely moving the if statement which test -w the pid_dir to after the if statements which create the pid_dir (line 350)
SRU Justification:
[Impact]
/var/run/mysqld directory is typically created by pre-start in the mysql upstart job prior to starting the service every boot, as /var/run is tempfs and its contents ephemeral. Users of the Linux HA stack typically hand over control of specific services to the cluster managed by OCF scripts. The OCF script to manage mysql should take the same steps the required directories are present. A bug exists in the version of the mysql OCF script shipped in 1:1.0.3-2ubuntu1 which prevents the required directories from being created if they do not exist. If the clustered service is configured to use /var/run/mysqld (the ubuntu default for certain files), the cluster will fail to start mysql after a reboot. As most users of the cluster agent anticipate a *highly* available service, graceful system reboots should not result in an unavailable service.
[Development Fix]
As Florian Hass pointed out, this has been fixed upstream over a year ago and is not present in the current development release (precise, package renamed resource agents 1:3.9.2-5ubuntu1)
[Stable Fix]
A trivial fix at https://github.com/ClusterLabs/resource-agents/commit/a1801207e0602d9b975f336569b562c195a6eb8a solves the issue and is easily backported.
[Test Case]
See http://paste.ubuntu.com/746339/ for a minimal test case which involves configuration of a 1-node heartbeat/pacemaker cluster.
[Regression Potential]
Minimal chance of regression. Change simply ensures mysql directories exist before they are checked for write permissions. The change only affects the mysql OCF agent, all others are untouched. |
|
2011-11-22 20:57:18 |
Adam Gandelman |
bug |
|
|
added subscriber Ubuntu Stable Release Updates Team |
2011-11-22 20:57:28 |
Adam Gandelman |
bug |
|
|
added subscriber Adam Gandelman |
2011-11-22 20:58:16 |
Adam Gandelman |
cluster-agents (Ubuntu Lucid): assignee |
Adam Gandelman (gandelman-a) |
|
|
2011-12-02 12:45:29 |
James Page |
cluster-agents (Ubuntu Lucid): importance |
Undecided |
Medium |
|
2011-12-02 12:45:32 |
James Page |
cluster-agents (Ubuntu): importance |
Undecided |
Medium |
|
2011-12-02 12:45:54 |
James Page |
bug |
|
|
added subscriber James Page |
2011-12-05 21:21:57 |
Andres Rodriguez |
nominated for series |
|
Ubuntu Natty |
|
2011-12-05 21:21:57 |
Andres Rodriguez |
bug task added |
|
cluster-agents (Ubuntu Natty) |
|
2011-12-05 21:22:04 |
Andres Rodriguez |
cluster-agents (Ubuntu Natty): status |
New |
Fix Released |
|
2011-12-05 21:22:47 |
Andres Rodriguez |
nominated for series |
|
Ubuntu Precise |
|
2011-12-05 21:22:47 |
Andres Rodriguez |
bug task added |
|
cluster-agents (Ubuntu Precise) |
|
2011-12-05 21:22:54 |
Andres Rodriguez |
cluster-agents (Ubuntu Precise): status |
In Progress |
Fix Released |
|
2011-12-14 00:55:50 |
Clint Byrum |
cluster-agents (Ubuntu Lucid): status |
In Progress |
Fix Committed |
|
2011-12-14 00:55:55 |
Clint Byrum |
bug |
|
|
added subscriber SRU Verification |
2011-12-14 00:56:00 |
Clint Byrum |
tags |
|
verification-needed |
|
2011-12-14 01:14:26 |
Launchpad Janitor |
branch linked |
|
lp:ubuntu/lucid-proposed/cluster-agents |
|
2012-11-14 23:51:58 |
Andres Rodriguez |
tags |
verification-needed |
verification-done |
|
2012-11-15 16:26:02 |
Brian Murray |
removed subscriber Ubuntu Stable Release Updates Team |
|
|
|
2012-11-15 16:26:12 |
Launchpad Janitor |
cluster-agents (Ubuntu Lucid): status |
Fix Committed |
Fix Released |
|