[SRU] infinite loop in /etc/init/mysql.conf if mysqld is not running.
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql-dfsg-5.1 (Ubuntu) |
Fix Released
|
High
|
Chuck Short | ||
Lucid |
Fix Released
|
High
|
Chuck Short | ||
Maverick |
Fix Released
|
High
|
Chuck Short |
Bug Description
Please see bug no. 551097 (under Upstart) for more details. This bug occurred when moving from 8.04 to Lucid (10.0.0.4) beta.
The file /etc/init/
In my case this was leaving mysql-server in a state between not-installed and installed, which caused the entire Software Update system to screech to a halt. Every time I tried to run any update process it would hang indefinitely on the 'stop mysql' and 'start mysql' processes. I had to kill each of those in turn, so that dpkg could finish. /usr/sbin/mysqld did not yet exist.
To fix it, I finally ran the individual lines of the pre-start section. When I ran the install line, /usr/sbin/mysqld appeared. When I ran /usr/sbin/mysqld that failed because of complaints about certain lines in the old my.cnf file. I backed that up and copied my.cnf.dpkg-dist to my.cnf and mysqld could then start. Once I had mysqld runnable I was able to run mysqladmin, start mysql, stop mysql and so forth without further problems and now dpkg succeeds.
So there are really two problems:
1) the infinite loop should be handled differently, and the errors in attempting to install and run mysqld should be visible somewhere so people can figure out what's wrong;
2) 'start mysql' should have some error output;
3) there are evidently some incompatibilities between the my.cnf from 8.04 and from 10.0.0.4.
here is the error message when running /usr/sbin/mysqld from the command line. AFAIK the old configuration is the default from 8.04
# /usr/sbin/mysqld
100329 14:58:46 [Warning] The syntax '--log' is deprecated and will be removed in MySQL 7.0. Please use '--general_
100329 14:58:46 [Note] Plugin 'FEDERATED' is disabled.
100329 14:58:46 InnoDB: Started; log sequence number 0 3776469
100329 14:58:46 [ERROR] /usr/sbin/mysqld: unknown option '--skip-bdb'
100329 14:58:46 [ERROR] Aborting
100329 14:58:46 InnoDB: Starting shutdown...
100329 14:58:47 InnoDB: Shutdown completed; log sequence number 0 3776469
100329 14:58:47 [Note] /usr/sbin/mysqld: Shutdown complete
Changed in mysql-dfsg-5.1 (Ubuntu): | |
status: | Incomplete → Confirmed |
Changed in mysql-dfsg-5.1 (Ubuntu Lucid): | |
importance: | Medium → High |
Changed in mysql-dfsg-5.1 (Ubuntu): | |
importance: | Medium → High |
Changed in mysql-dfsg-5.1 (Ubuntu Lucid): | |
assignee: | Canonical Server Team (canonical-server) → Chuck Short (zulcss) |
summary: |
- infinite loop in /etc/init/mysql.conf if mysqld is not running. + [SRU] infinite loop in /etc/init/mysql.conf if mysqld is not running. |
The skip-bdb option is no longer supported in mysql 5.1.
Was the original hardy my.cnf file modified before the upgrade? If so dpkg should have prompted you to review the changes between between the locally modified hardy version and the new maintainer lucid version of my.cnf.