https://bugzilla.novell.com/show_bug.cgi?id=856797 https://bugzilla.novell.com/show_bug.cgi?id=856797#c0 Summary: MySQL fails to start on a clean install Classification: openSUSE Product: openSUSE 13.1 Version: Final Platform: i686 OS/Version: openSUSE 13.1 Status: NEW Severity: Normal Priority: P5 - None Component: Basesystem AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: lutchy.horace@outlook.com QAContact: qa-bugs@suse.de Found By: --- Blocker: --- User-Agent: Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36 OPR/18.0.1284.68 This issue was a pita to resolve. For whatever reason, MySQL would not start. pdc-s2:/etc/init.d # rcmysql start redirecting to systemctl start mysql Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details. pdc-s2:/etc/init.d # rcmysql status Checking for service MySQL: unused mysql.service - LSB: Start the MySQL database server Loaded: loaded (/etc/init.d/mysql) Active: failed (Result: exit-code) since Tue 2013-12-24 19:14:36 EST; 3s ago Process: 7339 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE) Dec 24 19:14:06 pdc-s2 mysql[7339]: Starting service MySQL /usr/bin/mysqld_safe Dec 24 19:14:36 pdc-s2 mysql[7339]: warning: /var/lib/mysql/mysqld.sock didn't appear within 30 seconds Dec 24 19:14:36 pdc-s2 mysql[7339]: chmod: cannot access '/var/run/mysql/mysqld.pid': No such file or directory Dec 24 19:14:36 pdc-s2 mysql[7339]: ..failed Dec 24 19:14:36 pdc-s2 systemd[1]: mysql.service: control process exited, code=exited status=1 Dec 24 19:14:36 pdc-s2 systemd[1]: Failed to start LSB: Start the MySQL database server. Dec 24 19:14:36 pdc-s2 systemd[1]: Unit mysql.service entered failed state. Now according to this bug report: bugzilla.novell.com/show_bug.cgi?id=626297 (https://bugzilla.novell.com/show_bug.cgi?id=626297#c) suggests I should take look at /var/log/mysql/mysqld.log but unfortunately: pdc-s2:/etc/init.d # ll /var/log/mysql/mysqld.log ls: cannot access /var/log/mysql/mysqld.log: No such file or directory I reviewed my.cnf, SySv init script and a few echo statements later (hours later rather), I was still unable to get MySQL to start. I noticed /var/lib/mysql/mysql/ was empty and probably that was the issue. I removed /var/lib/mysql/mysql and have the SySv init script recreate it in hopes it would rectify it, no go. Then I stumbled on /var/lib/mysql/pdc-s2.err, the holy grail. I found this error: 131224 18:24:43 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid ended 131224 18:29:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2013-12-24 18:29:20 0 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072 2013-12-24 18:29:20 0 [ERROR] /usr/sbin/mysqld: ambiguous option '--log=/var/log/mysql/mysqld-query.log' (log-bin, log_slave_updates) 2013-12-24 18:29:20 0 [ERROR] Aborting A little bit of Google fu, I found this: http://serverfault.com/questions/397324/mysql-5-6-wont-start-on-os-x-ambiguo... According to this post: "The "ambiguous option" error message should have pointed you in the right direction... The --log option has been long deprecated, use the --general-log option instead" Reproducible: Always Steps to Reproduce: 1. zypper in mysql-community-server 2. rcmysql start 3. Actual Results: 131224 18:24:43 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid ended 131224 18:29:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2013-12-24 18:29:20 0 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072 2013-12-24 18:29:20 0 [ERROR] /usr/sbin/mysqld: ambiguous option '--log=/var/log/mysql/mysqld-query.log' (log-bin, log_slave_updates) 2013-12-24 18:29:20 0 [ERROR] Aborting Expected Results: Start succesffuly -- 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.