[Bug 937767] New: mysql-community-server-client: The mysql server keeps restarting every minute
http://bugzilla.suse.com/show_bug.cgi?id=937767 Bug ID: 937767 Summary: mysql-community-server-client: The mysql server keeps restarting every minute Classification: openSUSE Product: openSUSE 13.1 Version: Final Hardware: Other OS: Other Status: NEW Severity: Major Priority: P5 - None Component: Maintenance Assignee: kstreitova@suse.com Reporter: astieger@suse.com QA Contact: qa-bugs@suse.de CC: astieger@suse.com, jsegitz@novell.com, kstreitova@suse.com, o.nicolas@skynet.be Found By: --- Blocker: --- +++ This bug was initially created as a clone of Bug #934789 +++ (In reply to Olivier Nicolas from bug 934789 comment #24)
After updating to "mysql-community-server-client-5.6.25-7.4.1.i586" on "openSUSE 13.1 (Bottle) (i586)"
The mysql server keeps restarting every minute
Jul 9 19:00:11 blackened systemd[1]: Reloaded System Logging Service. Jul 9 19:00:57 blackened mysql-systemd-helper[337]: MySQL is still dead Jul 9 19:00:57 blackened systemd[1]: mysql.service: control process exited, code=exited status=1 Jul 9 19:00:57 blackened systemd[1]: Failed to start MySQL server. Jul 9 19:00:57 blackened systemd[1]: Unit mysql.service entered failed state. Jul 9 19:00:57 blackened mysql-systemd-helper[335]: 2015-07-09 19:00:57 351 [Note] /usr/sbin/mysqld: Normal shutdown Jul 9 19:00:57 blackened mysql-systemd-helper[335]: 2015-07-09 19:00:57 351 [Note] Giving 2 client threads a chance to die gracefully Jul 9 19:00:57 blackened mysql-systemd-helper[335]: 2015-07-09 19:00:57 351 [Note] Event Scheduler: Purging the queue. 0 events Jul 9 19:00:57 blackened mysql-systemd-helper[335]: 2015-07-09 19:00:57 351 [Note] Shutting down slave threads Jul 9 19:00:57 blackened systemd[1]: mysql.service holdoff time over, scheduling restart. Jul 9 19:00:57 blackened systemd[1]: Stopping MySQL server... Jul 9 19:00:57 blackened systemd[1]: Starting MySQL server... Jul 9 19:00:57 blackened mysql-systemd-helper[1042]: /usr/bin/my_print_defaults: unknown option '--mysqld' Jul 9 19:00:57 blackened mysql-systemd-helper[1051]: /usr/bin/my_print_defaults: unknown option '--mysqld' Jul 9 19:00:57 blackened mysql-systemd-helper[1059]: /usr/bin/my_print_defaults: unknown option '--mysqld' Jul 9 19:00:57 blackened mysql-systemd-helper[1060]: /usr/bin/my_print_defaults: unknown option '--mysqld' Jul 9 19:00:57 blackened mysql-systemd-helper[1060]: Waiting for MySQL to start
I had to modify the /usr/lib/mysql/mysql-systemd-helper to successfully start the mysql server
--- /usr/lib/mysql/mysql-systemd-helper.orig 2015-07-12 11:46:47.071715464 +0200 +++ /usr/lib/mysql/mysql-systemd-helper 2015-07-12 11:47:22.631715464 +0200 @@ -20,10 +20,10 @@
# Read options - important for multi setup if [[ -n "$INSTANCE" && "x$INSTANCE" != "xdefault" ]]; then - opts="$(/usr/bin/my_print_defaults --mysqld mysqld_multi "$INSTANCE")" + opts="$(/usr/bin/my_print_defaults mysqld mysqld_multi "$INSTANCE")" tmp_opts="$opts" else - opts="$(/usr/bin/my_print_defaults --mysqld)" + opts="$(/usr/bin/my_print_defaults mysqld)" tmp_opts="$opts" fi
-- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.suse.com/show_bug.cgi?id=937767
http://bugzilla.suse.com/show_bug.cgi?id=937767#c1
Andreas Stieger
http://bugzilla.suse.com/show_bug.cgi?id=937767
http://bugzilla.suse.com/show_bug.cgi?id=937767#c2
Martin Pluskal
http://bugzilla.suse.com/show_bug.cgi?id=937767
http://bugzilla.suse.com/show_bug.cgi?id=937767#c3
--- Comment #3 from Martin Pluskal
Hmm, # /usr/bin/my_print_defaults --mysqld mysqld_multi --innodb_file_format=Barracuda --innodb_file_per_table=ON --server-id=1 --sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES --mysqld=/usr/bin/mysqld_safe --mysqladmin=/usr/bin/mysqladmin --log=/var/log/mysqld_multi.log
Seems that syntax is correct
It is correct with mariadb, but wirh mysql-community server I get: # /usr/bin/my_print_defaults --mysqld mysqld_multi /usr/bin/my_print_defaults: unknown option '--mysqld' -- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.suse.com/show_bug.cgi?id=937767
http://bugzilla.suse.com/show_bug.cgi?id=937767#c4
--- Comment #4 from Martin Pluskal
http://bugzilla.suse.com/show_bug.cgi?id=937767
http://bugzilla.suse.com/show_bug.cgi?id=937767#c5
--- Comment #5 from Martin Pluskal
participants (1)
-
bugzilla_noreply@novell.com