Activity log for bug #893352

Date Who What changed Old value New value Message
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