[Bug 792332] New: msqldump --flush-log & mysqladmin flush-log fail
https://bugzilla.novell.com/show_bug.cgi?id=792332 https://bugzilla.novell.com/show_bug.cgi?id=792332#c0 Summary: msqldump --flush-log & mysqladmin flush-log fail Classification: openSUSE Product: openSUSE 12.2 Version: Final Platform: x86-64 OS/Version: openSUSE 12.2 Status: NEW Severity: Critical Priority: P5 - None Component: Basesystem AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: Curt.Blank@curtronics.com QAContact: qa-bugs@suse.de Found By: --- Blocker: --- User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:16.0) Gecko/20100101 Firefox/16.0 msqldump --flush-log & mysqladmin flush-log fail When mysqldump fails the dump i.e. backup of the DB fails, that is unacceptable Reproducible: Always Steps to Reproduce: 1.issue msqldump --flush-log or mysqladmin flush 2. 3. Actual Results: issue msqldump --flush-log or mysqladmin flush fail and if using mysqldump to do a backup of the DB no backup is created which is unacceptable. Expected Results: I expect the logs to be flushed when using the flush-log option and I expect mysqldump to complete successfully. The problem appears to be in the supplied /etc/my.cnf file. err-log needs to be defined in the [safe_mysqld] section, i.e. [safe_mysqld] log-error = /var/log/mysql/mysqld.log err-log = /var/log/mysql/mysqld.err socket = /var/run/mysql/mysql.sock Pretty bad oversight IMO -- 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=792332 https://bugzilla.novell.com/show_bug.cgi?id=792332#c Curtis J Blank <Curt.Blank@curtronics.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|P5 - None |P1 - Urgent CC| |Curt.Blank@curtronics.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=792332 https://bugzilla.novell.com/show_bug.cgi?id=792332#c1 --- Comment #1 from Curtis J Blank <Curt.Blank@curtronics.com> 2012-12-02 18:51:08 UTC --- Might also be the cause of Bug 763150. -- 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=792332 https://bugzilla.novell.com/show_bug.cgi?id=792332#c Jiaying ren <jren@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jren@suse.com AssignedTo|bnc-team-screening@forge.pr |mhrusecky@suse.com |ovo.novell.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=792332 https://bugzilla.novell.com/show_bug.cgi?id=792332#c2 --- Comment #2 from Curtis J Blank <Curt.Blank@curtronics.com> 2012-12-15 19:45:24 UTC --- This problem has surfaced again, msqldump --flush-log or mysqladmin flush-logs is throwing the err # mysqladmin flush-logs mysqladmin: refresh failed; error: 'Unknown error' -- 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=792332 https://bugzilla.novell.com/show_bug.cgi?id=792332#c3 --- Comment #3 from Curtis J Blank <Curt.Blank@curtronics.com> 2012-12-15 20:01:31 UTC --- Ok, I think I found the fix the /var/log/mysql directory also needs to be owned by mysql not just the log files in it. drwxrwx--- 2 mysql mysql 4096 Dec 15 00:00 /var/log/mysql It works again after I chown the directory to mysql:mysql from root:root -- 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=792332 https://bugzilla.novell.com/show_bug.cgi?id=792332#c4 Archie Cobbs <archie@dellroad.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |archie@dellroad.org --- Comment #4 from Archie Cobbs <archie@dellroad.org> 2013-05-13 13:37:28 UTC --- See also https://bugzilla.novell.com/show_bug.cgi?id=763150 May have the same underlying cause. -- 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=792332 https://bugzilla.novell.com/show_bug.cgi?id=792332#c5 Michal Hrusecky <mhrusecky@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |carlos.e.r@opensuse.org --- Comment #5 from Michal Hrusecky <mhrusecky@suse.com> 2013-07-26 11:20:00 UTC --- *** Bug 763150 has been marked as a duplicate of this bug. *** http://bugzilla.novell.com/show_bug.cgi?id=763150 -- 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=792332 https://bugzilla.novell.com/show_bug.cgi?id=792332#c6 --- Comment #6 from Michal Hrusecky <mhrusecky@suse.com> 2013-07-26 11:20:14 UTC --- *** Bug 789263 has been marked as a duplicate of this bug. *** http://bugzilla.novell.com/show_bug.cgi?id=789263 -- 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=792332 https://bugzilla.novell.com/show_bug.cgi?id=792332#c7 Michal Hrusecky <mhrusecky@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED --- Comment #7 from Michal Hrusecky <mhrusecky@suse.com> 2013-07-29 07:39:08 UTC --- Fixed for the Factory, will get into stable releases with next update. -- 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=792332 https://bugzilla.novell.com/show_bug.cgi?id=792332#c Swamp Workflow Management <swamp@suse.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status Whiteboard| |maint:running:54320:importa | |nt -- 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=792332 https://bugzilla.novell.com/show_bug.cgi?id=792332#c9 Swamp Workflow Management <swamp@suse.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status Whiteboard|maint:running:54320:importa |maint:running:54320:importa |nt |nt | |maint:released:sle11-sp3:54 | |511 --- Comment #9 from Swamp Workflow Management <swamp@suse.de> 2013-10-07 16:55:27 UTC --- Update released for: libmysql55client18, libmysql55client18-32bit, libmysql55client18-x86, libmysql55client_r18, libmysql55client_r18-32bit, libmysql55client_r18-x86, libmysqlclient-devel, libmysqlclient15, libmysqlclient15-32bit, libmysqlclient15-x86, libmysqlclient_r15, libmysqlclient_r15-32bit, libmysqlclient_r15-x86, mysql, mysql-Max, mysql-bench, mysql-client, mysql-debug, mysql-debug-version, mysql-debuginfo, mysql-debugsource, mysql-test, mysql-tools Products: SLE-DEBUGINFO 11-SP3 (i386, ia64, ppc64, s390x, x86_64) SLE-DESKTOP 11-SP3 (i386, x86_64) SLE-SDK 11-SP3 (ia64, ppc64, s390x, x86_64) SLE-SERVER 11-SP3 (i386, ia64, ppc64, s390x, x86_64) SLES4VMWARE 11-SP3 (i386, x86_64) -- 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