[Bug 768832] New: mysqldump 5.5.25 displays general_log table error and has non-zero exit-code
https://bugzilla.novell.com/show_bug.cgi?id=768832 https://bugzilla.novell.com/show_bug.cgi?id=768832#c0 Summary: mysqldump 5.5.25 displays general_log table error and has non-zero exit-code Classification: openSUSE Product: openSUSE 12.1 Version: Final Platform: x86-64 OS/Version: openSUSE 12.1 Status: NEW Severity: Normal Priority: P5 - None Component: Maintenance AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: walter.haidinger@gmx.at QAContact: qa-bugs@suse.de Found By: --- Blocker: --- User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:13.0) Gecko/20100101 Firefox/13.0 mysqldump from the mysql-community-server-client-5.5.25-3.9.2 package displays an error when run and exits with a non-zero exit-code (2): Error: Couldn't read status information for table general_log () mysqldump: Couldn't execute 'show create table `general_log`': Table 'mysql.general_log' doesn't exist (1146) Previous version from mysql-community-server-client-5.5.23-3.6.1 package does not show an error. Please note that the dump is still created (seems ok, haven't verified this in detail). The error message and non-zero exit-code break any backup scripts relying on zero exit-code or mysqldump being quiet upon success. There is already an upstream bug-report too: http://bugs.mysql.com/bug.php?id=65670 Reproducible: Always Steps to Reproduce: 1. become mysql superuser, e.g. 'su - mysql' 2. mysqldump --all-databases --lock-all-tables > dump.sql Actual Results: mysqldump exit-code: 2 Error: Couldn't read status information for table general_log () mysqldump: Couldn't execute 'show create table `general_log`': Table 'mysql.general_log' doesn't exist (1146) Expected Results: No error, exit-code: 0 http://bugs.mysql.com/bug.php?id=65670 -- 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=768832 https://bugzilla.novell.com/show_bug.cgi?id=768832#c kk zhang <kkzhang@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |kkzhang@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=768832 https://bugzilla.novell.com/show_bug.cgi?id=768832#c1 Bruno Friedmann <bruno@ioda-net.ch> changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|P5 - None |P3 - Medium CC| |bruno@ioda-net.ch --- Comment #1 from Bruno Friedmann <bruno@ioda-net.ch> 2012-07-03 15:39:13 UTC --- It's worse than expected ... I've just found that none of my backup has work since that update. as root (system & mysql) /usr/bin/mysqladmin flush-logs /usr/bin/mysqladmin: refresh failed; error: 'Unknown error' and for example a backup mysqldump -u root -C espn --routines --order-by-primary --flush-logs --extended-insert --delayed-insert --comments -- MySQL dump 10.13 Distrib 5.5.25, for Linux (x86_64) -- -- Host: localhost Database: espn -- ------------------------------------------------------ -- Server version 5.5.25-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; mysqldump: Got error: 1105: Unknown error when doing refresh It seems that also the log rotate script is impacted ... I'm up rising the level, cause if your script doesn't check the ret of mysql command, then you get truncated backup ... Feel free to resetup it at level 5 -- 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=768832 https://bugzilla.novell.com/show_bug.cgi?id=768832#c2 --- Comment #2 from Walter Haidinger <walter.haidinger@gmx.at> 2012-11-14 10:54:49 UTC --- FYI: Apparently fixed in 12.2 and mysql-community-server-client-5.5.25a-1.2.1.x86_64. Works for me again after upgrading. -- 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=768832 https://bugzilla.novell.com/show_bug.cgi?id=768832#c3 --- Comment #3 from Walter Haidinger <walter.haidinger@gmx.at> 2013-06-05 12:21:52 UTC --- Fixed upstream in mysql 5.5.33, 5.6.13, 5.7.2. Upstream bug is closed. See http://bugs.mysql.com/bug.php?id=65670 -- 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=768832 https://bugzilla.novell.com/show_bug.cgi?id=768832#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 08:04:15 UTC --- Fixed for 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=768832 https://bugzilla.novell.com/show_bug.cgi?id=768832#c Swamp Workflow Management <swamp@suse.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status Whiteboard| |obs:running:1914:moderate -- 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=768832 https://bugzilla.novell.com/show_bug.cgi?id=768832#c9 --- Comment #9 from Swamp Workflow Management <swamp@suse.de> 2013-08-14 01:06:11 UTC --- openSUSE-SU-2013:1335-1: An update that contains security fixes can now be installed. Category: security (moderate) Bug References: 747811,768832,780019,789263,791863,803040,830086 CVE References: Sources used: openSUSE 12.3 (src): mariadb-5.5.32-1.4.2, mysql-community-server-5.5.32-1.4.2 openSUSE 12.2 (src): mariadb-5.5.32-1.8.2, mysql-community-server-5.5.32-1.8.2 -- 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=768832 https://bugzilla.novell.com/show_bug.cgi?id=768832#c Swamp Workflow Management <swamp@suse.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status Whiteboard|obs:running:1914:moderate |obs:running:1914:moderate | |maint:running:53652: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=768832 https://bugzilla.novell.com/show_bug.cgi?id=768832#c10 --- Comment #10 from Bernhard Wiedemann <bwiedemann@suse.com> 2013-08-26 12:00:16 CEST --- This is an autogenerated message for OBS integration: This bug (768832) was mentioned in https://build.opensuse.org/request/show/196365 Evergreen:11.2 / 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=768832 https://bugzilla.novell.com/show_bug.cgi?id=768832#c11 Swamp Workflow Management <swamp@suse.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status Whiteboard|obs:running:1914:moderate |obs:running:1914:moderate |maint:running:53652:importa |maint:running:53652:importa |nt |nt | |maint:released:sle11-sp3:54 | |090 --- Comment #11 from Swamp Workflow Management <swamp@suse.de> 2013-08-29 18:56:01 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 (i386, 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.
https://bugzilla.novell.com/show_bug.cgi?id=768832 https://bugzilla.novell.com/show_bug.cgi?id=768832#c Swamp Workflow Management <swamp@suse.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status Whiteboard|obs:running:1914:moderate |obs:running:1914:moderate |maint:running:53652:importa |maint:running:53652:importa |nt |nt |maint:released:sle11-sp3:54 |maint:released:sle11-sp3:54 |090 |090 | |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=768832 https://bugzilla.novell.com/show_bug.cgi?id=768832#c12 --- Comment #12 from Swamp Workflow Management <swamp@suse.de> 2013-09-08 16:04:19 UTC --- openSUSE-SU-2013:1410-1: An update that contains security fixes can now be installed. Category: security (moderate) Bug References: 768832,830086 CVE References: Sources used: openSUSE 11.4 (src): mysql-community-server-5.1.71-62.1 -- 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=768832 https://bugzilla.novell.com/show_bug.cgi?id=768832#c13 --- Comment #13 from Swamp Workflow Management <swamp@suse.de> 2013-09-08 16:05:38 UTC --- openSUSE-SU-2013:1412-1: An update that fixes one vulnerability is now available. Category: security (moderate) Bug References: 768832 CVE References: CVE-2012-5611 Sources used: openSUSE 11.4 (src): mariadb-5.1.67-46.1 -- 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=768832 https://bugzilla.novell.com/show_bug.cgi?id=768832#c14 --- Comment #14 from Bernhard Wiedemann <bwiedemann@suse.com> 2013-09-11 08:00:45 CEST --- This is an autogenerated message for OBS integration: This bug (768832) was mentioned in https://build.opensuse.org/request/show/198408 Evergreen:11.2 / 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=768832 https://bugzilla.novell.com/show_bug.cgi?id=768832#c15 Swamp Workflow Management <swamp@suse.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status Whiteboard|obs:running:1914:moderate |obs:running:1914:moderate |maint:running:53652:importa |maint:running:53652:importa |nt |nt |maint:released:sle11-sp3:54 |maint:released:sle11-sp3:54 |090 |090 |maint:running:54320:importa |maint:running:54320:importa |nt |nt | |maint:released:sle11-sp3:54 | |511 --- Comment #15 from Swamp Workflow Management <swamp@suse.de> 2013-10-07 16:54:47 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.
https://bugzilla.novell.com/show_bug.cgi?id=768832 https://bugzilla.novell.com/show_bug.cgi?id=768832#c Swamp Workflow Management <swamp@suse.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status Whiteboard|obs:running:1914:moderate |obs:running:1914:moderate |maint:running:53652:importa |maint:running:53652:importa |nt |nt |maint:released:sle11-sp3:54 |maint:released:sle11-sp3:54 |090 |090 |maint:running:54320:importa |maint:released:sle11-sp3:54 |nt |511 |maint:released:sle11-sp3:54 | |511 | -- 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.
http://bugzilla.novell.com/show_bug.cgi?id=768832 Swamp Workflow Management <swamp@suse.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Whiteboard|obs:running:1914:moderate |maint:running:53652:importa |maint:running:53652:importa |nt |nt |maint:released:sle11-sp3:54 |maint:released:sle11-sp3:54 |090 |090 |maint:released:sle11-sp3:54 |maint:released:sle11-sp3:54 |511 |511 | -- You are receiving this mail because: You are on the CC list for the bug.
participants (1)
-
bugzilla_noreply＠novell.com