[Bug 730904] New: mysqld.service not found
https://bugzilla.novell.com/show_bug.cgi?id=730904 https://bugzilla.novell.com/show_bug.cgi?id=730904#c0 Summary: mysqld.service not found Classification: openSUSE Product: openSUSE 12.1 Version: Final Platform: x86-64 OS/Version: Other Status: NEW Severity: Major Priority: P5 - None Component: Other AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: dominian@slackadelic.com QAContact: qa@suse.de Found By: --- Blocker: --- User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:8.0) Gecko/20100101 Firefox/8.0 Trying to start mysqld with rc.mysqld start or systemctl start mysqld.service results in mysqld not running saying file not found. destiny:~ # systemctl start mysqld.service Failed to issue method call: Unit mysqld.service failed to load: No such file or directory. See system logs and 'systemctl status mysqld.service' for details. destiny:~ # systemctl status mysqld.service mysqld.service Loaded: error (Reason: No such file or directory) Active: inactive (dead) Reproducible: Always Steps to Reproduce: 1. chkconfig mysqld on 2. try to start mysqld with rcmysqld start or systemctl start mysqld.service 3. failure Actual Results: Mysqld fails to start with mysqld.service not found Expected Results: mysqld starting and working -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=730904 https://bugzilla.novell.com/show_bug.cgi?id=730904#c1 Bruno Friedmann <bruno@ioda-net.ch> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |bruno@ioda-net.ch --- Comment #1 from Bruno Friedmann <bruno@ioda-net.ch> 2011-11-20 10:26:37 UTC --- Hi Matt. You could try this two step verify if mysql is enable at boot time chkconfig mysql should return mysql on Otherwise try to activate it chkconfig mysql on In case of failure (which could be linked to the fact that /etc/init.d/mysql wrongly try to start at runlevel 2 and could be fixed by removing 2 at default start. What systemctl enable mysql.service give you on a pure 12.1 without mysql enable systemctl status mysql.service mysql.service - LSB: Start the MySQL database server Loaded: loaded (/etc/init.d/mysql) Active: inactive (dead) CGroup: name=systemd:/system/mysql.service and on a computer with mysql needed at boot I've the following result systemctl status mysql.service mysql.service - LSB: Start the MySQL database server Loaded: loaded (/etc/init.d/mysql) Active: active (running) since Sun, 20 Nov 2011 10:31:59 +0100; 48min ago Process: 1727 ExecStart=/etc/init.d/mysql start (code=exited, status=0/SUCCESS) CGroup: name=systemd:/system/mysql.service ├ 1925 /bin/sh /usr/bin/mysqld_safe --mysqld=mysqld --user=mysql --pid-file=/var/run/mysql/mysqld.pid --socket=/var/run/mysql/mysql.sock --datadir... └ 2726 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysql/mysql... c-3po:~ # -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=730904 https://bugzilla.novell.com/show_bug.cgi?id=730904#c2 Matt Hayes <dominian@slackadelic.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dominian@slackadelic.com --- Comment #2 from Matt Hayes <dominian@slackadelic.com> 2011-11-20 21:01:53 UTC --- this was definitely a mistake of mine in the subject. its mysql.service of course, just a typo. Clean install of 12.1. So, chkconfig mysql on, then rcmysql start and it passes off to systemd. Well, then it would just 'sit' there and fail. I did run the mysql installation script to get the default DB situated before trying to start it. What I found was a permissions issue on /var/lib/mysql set to root:root with 700 perms. Just as a test I did: chown mysql.mysql /var/lib/mysql and then tried to start with rcmysql start and this time it fired up. Just to make sure I didn't mess something up, I did another install of openSUSE 12.1 in a VM and the exact same issue occurred. So not sure if *I* am doing something weird or in the incorrect order or if anyone else can confirm what I found. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=730904 https://bugzilla.novell.com/show_bug.cgi?id=730904#c3 Andreas Jaeger <aj@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- AssignedTo|bnc-team-screening@forge.pr |mhrusecky@suse.com |ovo.novell.com | --- Comment #3 from Andreas Jaeger <aj@suse.com> 2011-11-21 10:27:18 UTC --- Matt, so the error should be "/var/lib/mysql has wrong permissions"? Interestingly, there'S something broken here: rpm -qf /var/lib/mysql file /var/lib/mysql is not owned by any package -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=730904 https://bugzilla.novell.com/show_bug.cgi?id=730904#c4 --- Comment #4 from Bruno Friedmann <bruno@ioda-net.ch> 2011-11-21 12:00:08 UTC --- I didn't success to recreate the bug on a fresh 12.1 install + adding afterward the mysql-comunity-server package. Was installed correctly. but first start is not possible with systemctl start mysql.service. I've done it by /etc/init.d/mysql start then after I was able to pilot it by systemctl ... @AJ after installation /var/lib/mysql is not created by the rpm. it's created only at the first time the service is started. bug or feature ? -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=730904 https://bugzilla.novell.com/show_bug.cgi?id=730904#c5 --- Comment #5 from Matt Hayes <dominian@slackadelic.com> 2011-11-21 13:26:22 UTC --- That would explain why rpm -qf /var/lib/mysql isn't turning up anything. The package, as pointed out by Bruno, doesn't appear to create that directory on its own. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=730904 https://bugzilla.novell.com/show_bug.cgi?id=730904#c6 Borislav Mitev <morbid_viper@tkzs.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |morbid_viper@tkzs.org --- Comment #6 from Borislav Mitev <morbid_viper@tkzs.org> 2012-03-15 07:31:32 UTC --- I had the same bug and just last night I was able to solve it. The problem is somehow with the systemd's incapability to show a meaningful error message, e.g. witch file is missing. After a long googling in vain I came to 'systemctl dump' (searching for Unit mysql.service) and I discovered that 'the missing file' has something to do with the postfix. Well... it's still unclear the exact file missing, but 'insserv postfix' and 'rcpostfix restart' did the trick. After these two commands 'rcmysql start' works as it should be. I did this on four of my servers and the "workaround" worked all the time. PS: I'm using mariadb, rather then original mysql. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=730904 https://bugzilla.novell.com/show_bug.cgi?id=730904#c7 Vincent Untz <vuntz@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO CC| |vuntz@suse.com Component|Other |Other Version|Final |Factory InfoProvider| |fcrozat@suse.com Product|openSUSE 12.1 |openSUSE 12.2 OS/Version|Other |openSUSE 12.1 --- Comment #7 from Vincent Untz <vuntz@suse.com> 2012-06-13 17:46:53 UTC --- For the record, doing a "systemctl daemon-reload" after installing the mysql-community-server package solves this. So that's surely because something should be done in the %post script of the package. Although I'm surprised that we need to do this, as the mysql package doesn't know anything about systemd. Frédéric, is this expected? (moving to 12.2, as it still occurs there) -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=730904 https://bugzilla.novell.com/show_bug.cgi?id=730904#c Frederic Crozat <fcrozat@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW CC| |fcrozat@suse.com InfoProvider|fcrozat@suse.com | -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=730904 https://bugzilla.novell.com/show_bug.cgi?id=730904#c8 --- Comment #8 from Frederic Crozat <fcrozat@suse.com> 2012-06-18 12:46:29 UTC --- initially, I though it could be a duplicate of bnc#717162 but we can't fix it by updating rpm macros for initscripts, since mysql package doesn't use them. So I advice to add such call to %pre / %post / etc.. : [ -x /bin/systemctl ] && /bin/systemctl daemon-reload 2>&1 > /dev/null || : -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=730904 https://bugzilla.novell.com/show_bug.cgi?id=730904#c9 Michal Hrusecky <mhrusecky@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED --- Comment #9 from Michal Hrusecky <mhrusecky@suse.com> 2013-11-06 13:09:48 UTC --- Should be fixed in latest updates for maintained distributions. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
participants (1)
-
bugzilla_noreply＠novell.com