[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
Hi, is there any solution to this major issue (mysql serever not working in ubuntu 10.04) ? -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
** Changed in: mysql-dfsg-5.1 (Ubuntu Lucid) Assignee: Canonical Server Team (canonical-server) = Chuck Short (zulcss) -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
Targeting to 10.04.1 as mysql is a very popular server application. If a solution cannot be found in time, then it needs to be targeted to an SRU or 10.04.2. ** Changed in: mysql-dfsg-5.1 (Ubuntu Lucid) Status: New = Confirmed ** Changed in: mysql-dfsg-5.1 (Ubuntu Lucid) Importance: Undecided = Medium ** Changed in: mysql-dfsg-5.1 (Ubuntu Lucid) Milestone: None = ubuntu-10.04.1 ** Changed in: mysql-dfsg-5.1 (Ubuntu Lucid) Assignee: (unassigned) = Canonical Server Team (canonical-server) ** Changed in: mysql-dfsg-5.1 (Ubuntu Lucid) Importance: Medium = High ** Changed in: mysql-dfsg-5.1 (Ubuntu) Importance: Medium = High -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
Does ANYONE have a solution for: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' Can I install an old version or something? I MUST get this server up. Nothing will get it to run. -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
Re: [Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
On 7 July 2010 05:34, stininkey skunkenheimer jdie...@twonails.com wrote: Does ANYONE have a solution for: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' Can I install an old version or something? I MUST get this server up. Nothing will get it to run. Try to edit /etc/init/mysql.conf and change: exec /usr/sbin/mysqld to exec /usr/bin/mysqld_safe -- Artis Caune Everything should be made as simple as possible, but not simpler. -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
In my case it must have been webmin that's put something in the my.cnf file that it doesn't like. I'll have to find out what it doesn't like and file a separate bug against webmin, as the cause - but meanwhile I can confirm there is a bug with the startup script. It doesn't fail gracefully, just hangs. Is this bug in the equivalent Debian upstream? -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
Oh - the startup problem is disguised as a permissions problem, but actually it's because the db file is on an NTFS partition - so it's not webmin. But - a startup error would be nice...! -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
The bug doesn't exist in Debian since they don't use Upstart - OT, but IMHO it was way too early to introduce Upstart since it doesn't even provide the same level of functionality as SysV, but that's another story... The important thing when migrating though is not to make assumptions when changing the behaviour, as is what happened here. -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
Hit the same issue, when there was a typo in my.cnf, mysql-server is a stuck in an infinite post-start loop. -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
I will try to describe all what I have find on this problem which start with the upgrade from 8.04 to 10.04. First (I forgot how the problem began...), I remove mysql-server : $ sudo apt-get remove mysql-server --purge $ sudo apt-get autoremove $ sudo apt-get autoclean and I also remove the directories /etc/mysql, /var/lib/mysqld, /var/run/mysqld, /var/log/mysql reboot then reinstall of the package mysql-server. This install gives me the error (it's a translation) Unable to change the password for user 'root' of mysql. Then : $ sudo service mysql start start: Job failed to start If I copy the my.cnf which is missing, the service start gives me an infinite loop. But the line : $ sudo su - mysql service mysql start works. But if I try to connect : $ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) That's the main informations I have. -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
Not sure how I did it, but I succeeded in removing the password for root. I can now connect to the database. But if I try to change the root password of mysql using sudo dpkg-reconfigure mysql-server-5.1, I get : stop: Unknown instance: and another loop I can break with Ctrl+C. And the password is not changed. -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
just my 2 cents: The problem was (in my case) that at the time mysql upstart job is fired /var/run isn't mounted. There should be a tempfs in /var/run. Additional apparmor prevents mysql to put its sock under /var/run instead of /var/run/mysqld. How can I tell upstart to start after mounted-varrun.conf is run?! -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
@Mr. Bug - I think you've got other problems if /var/run is not mounted by the time mysql starts. And mysql is already set to start after all local filesystems. -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
How about the attached upstart job? ** Attachment added: mysql.conf http://launchpadlibrarian.net/49996397/mysql.conf ** Attachment removed: mysql.conf http://launchpadlibrarian.net/49996397/mysql.conf -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
Sorry, slight modification ** Attachment added: mysql.conf http://launchpadlibrarian.net/49996491/mysql.conf -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
@Chuck - preliminary testing seems to indicate that the upstart job in your package will allow mysql to enter started status even when it does not start successfully. I'll try look at creating something a little cleaner in the next couple of days. -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
Please note that the cause of the problem is that /etc/init/mysql.conf
is trying to start mysqld as user root. If you start as user mysql
everything works fine.
The infinte loop described above in
while ! /usr/bin/mysqladmin --defaults-file=$HOME/debian.cnf ping
do
sleep 1
done
is caused by mysqld not running and therefore /usr/bin/mysqladmin
--defaults-file=$HOME/debian.cnf ping
failing.
With no proper timeout this causes an infinte loop.
So you have to apply the following 2 fixes to /etc/init/mysql.conf:
1) to make msqld work:
exec sudo -u mysql /usr/sbin/mysqld # - important execute as use
mysql
2) to make sure the loop times out:
count=0
while [ $count -lt 10 ] ! /usr/bin/mysqladmin
--defaults-file=/etc/mysql/debian.cnf ping 2/dev/null
do
echo waiting for mysqld: ${count}s ...
sleep 1
count=`expr $count + 1`
done
if [ $count -eq 10 ]
then
echo timeout.
else
exec $HOME/debian-start
fi
--
infinite loop in /etc/init/mysql.conf if mysqld is not running.
https://bugs.launchpad.net/bugs/551130
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu.
--
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at:
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
When using EBS snashots on EC2, debian-sys-maint is different on new servers, so it stuck forever. Also init/mysql.conf use: exec /usr/sbin/mysqld and I see error when running it like that: 100528 11:00:25 [ERROR] Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 100528 11:00:25 [ERROR] Aborting 100528 11:00:25 [Note] /usr/sbin/mysqld: Shutdown complete should'n it use mysqld_safe instead ? This works for me: exec /usr/bin/mysqld_safe post-start script for i in 1 2 3 4 5 6 7 8 9 10 11 12 13 14; do /usr/bin/mysqladmin --defaults-file=$HOME/debian.cnf ping exec $HOME/debian-start sleep 1 done end script -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
I'm experiencing the same hang. But it also hangs on stop/restart when there is an error in the my.cnf. This is really annoying.. -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
I updated to version 5.1.41-3ubuntu12.1 yesterday and my problems with mysql hanging on start up have gone away. -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
@Sam Barker - you must have inadvertently fixed whatever error was causing the /usr/bin/mysqladmin --defaults-file=$HOME/debian.cnf ping command to fail. Try breaking your my.cnf as others have suggested, and you'll see the infinite loop still exists. ** Tags added: regression-release -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
I'll take that back. Its failing again after a reboot. After I get the hung instance stopped sudo dpkg-reconfigure mysql- server-5.1 fixes the problem until reboot. -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
Nominating for Lucid per zul's request ** Also affects: mysql-dfsg-5.1 (Ubuntu Lucid) Importance: Undecided Status: New -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
For those who are having problems with this can you try the version in my ppa when it builds: https://edge.launchpad.net/~zulcss/+archive/server-bug-fixes thanks chuck -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
Infinite loop is bad - kills my HA clusters if there's an error, as the service cannot be migrated away from the node with the issue. Certainly propose re-instating the limit, as this is a regression. -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
Re: [Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
On Wed, May 05, 2010 at 03:17:12PM -, Joe Holloway wrote: As a side note, I've now completely lost my /etc/init/mysql.conf file and can't seem to get it back through the package manager regardless of purging/reinstalling packages. That concerns me a bit, but I can't pinpoint the behavior well enough to log a separate bug at this point. Make sure you're *purging* the package that ships /etc/init/mysql.conf. -- Mathias Gug Ubuntu Developer http://www.ubuntu.com -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
In the old /etc/init.d/mysql script, there was a similar check status loop, but it only spun 14 times before exiting. If there were a problem with your server, you'd only block for max of ~14 seconds while trying to ping the server before breaking out. for i in 1 2 3 4 5 6 7 8 9 10 11 12 13 14; do sleep 1 if mysqld_status check_alive nowarn ; then break; fi ... done ... In the new `upstart` script /etc/init/mysql.conf, the analogous status check was changed to a while ! ... loop which means the script will spin forever when your server has a problem? while ! /usr/bin/mysqladmin --defaults-file=$HOME/debian.cnf ping do sleep 1 done It seems that there are a few common errors that are easily resolvable, for example Can't connect to MySQL server through socket '/var/run/mysqld/mysqld.sock' error or issues with the debian-sys- maint user that some of us have from time-to-time, but there appears to be a chicken/egg scenario here caused by this infinite loop. As a side note, I've now completely lost my /etc/init/mysql.conf file and can't seem to get it back through the package manager regardless of purging/reinstalling packages. That concerns me a bit, but I can't pinpoint the behavior well enough to log a separate bug at this point. -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
This affects me as well. in /etc/mysql/conf.d there was a symlink to /home/user/my.cnf[mysql] -begin my.cnf default-character-set = utf8 [mysqld] default-character-set = utf8 character-set-server = utf8 character_set_database = utf8 -begin my.cnf After I removed the symlink I was able to start/restart mysql. -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
I have the same problem in a clean install of 10.04 (iso downloaded today). I believe I had the same problem when I did an upgrade of 9.10 to 10.04 yesterday - I had to kill the install of mysql-server which had hung, but I've done the complete install today. Synaptic hangs on start mysql and the install can't complete. Same thing if I uninstall the half installed version, and when I reinstall again. -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: 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. ** Changed in: mysql-dfsg-5.1 (Ubuntu) Status: New = Incomplete ** Changed in: mysql-dfsg-5.1 (Ubuntu) Importance: Undecided = Medium -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
Comparing old and new I don't think there were any changes, although there is a 'log' entry that might not have been original. I do not recall seeing any prompt on this but it's possible that I missed it - the upgrade from 8.04 to 10.0.0.4 was a long process, and a lot of it ran overnight while I was elsewhere. But if the dialog would have required me to click 'OK' or whatever then I don't think that happened. I can attach a copy of my old my.cnf if you want it. Perhaps this is a minor issue, but two things could be done differently: * since 'skip_bdb' is deprecated precisely because it's no longer needed, this should at most generate a warning when mysql starts up. It's odd to me that mysql should abort because of a configuration option that is agreeing with it. But I suppose that is really up to the mysql folks. * IMHO the initctl mysql.conf file (or any automated script) should not have a potential infinite loop like this, especially with no output to tell what is happening. Perhaps this could try to start a certain number of times, then report whatever error messages are coming from mysqladmin and/or mysqld to syslog or dmesg or whatever. Then at least there would be some error output. To get fancy, you could have a double retry loop, spitting out a warning every time the outer loop goes round. In any case it's just a bad idea to sit and spin forever with no output. I think this is the real 'bug'. -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
Could paste a diff between your old hardy my.cnf file and the lucid one? -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 551130] Re: infinite loop in /etc/init/mysql.conf if mysqld is not running.
Here 'tis. my.cnf is a copy of my.cnf.pkg-dist and my.cnf.old is my old one. I should say that it is possible that I was asked about whether to keep the old one or install the new one, and I might have said keep the old one. I just don't recall. $ diff my.cnf my.cnf.old 29a30,40 default-collation=latin1_general_ci #Enter a name for the query log file. Otherwise a default name will be used. #log=/var/log/mysql_query.log #Logs will be rotated after expire-log-days days expire_logs_days=30 42a54 pid-file = /var/run/mysqld/mysqld.pid 47a60 language = /usr/share/mysql/english 58,62c71,72 thread_stack = 192K thread_cache_size = 8 # This replaces the startup script and checks MyISAM tables if needed # the first time they are touched myisam-recover = BACKUP --- thread_stack = 128K thread_cache_size = 8 69c79 query_cache_limit = 1M --- query_cache_limit = 1M 76,81c86,89 # As of 5.1 you can enable the log at runtime! #general_log_file= /var/log/mysql/mysql.log #general_log = 1 log_error= /var/log/mysql/error.log --- log = /var/log/mysql/mysql.log # # Error logging goes to syslog. This is a Debian improvement :) # 96a105,109 # * BerkeleyDB # # Using BerkeleyDB is now discouraged as its support will cease in 5.1.12. skip-bdb # 100a114,115 # You might want to disable InnoDB to shrink the mysqld process by circa 100MB. #skip-innodb 126a142,153 # * NDB Cluster # # See /usr/share/doc/mysql-server-*/README.Debian for more information. # # The following configuration is read by the NDB Data Nodes (ndbd processes) # not from the NDB Management Nodes (ndb_mgmd processes). # # [MYSQL_CLUSTER] # ndb-connectstring=127.0.0.1 # 128c155 # The files must end with '.cnf', otherwise they'll be ignored. --- # The files must end with '.cnf', otherwise they'll be ignored. 130a158 -- infinite loop in /etc/init/mysql.conf if mysqld is not running. https://bugs.launchpad.net/bugs/551130 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
