Your message dated Fri, 25 May 2012 12:17:10 +0000
with message-id <[email protected]>
and subject line Bug#673257: fixed in automysqlbackup 2.6+debian.2-1
has caused the Debian Bug report #673257,
regarding automysqlbackup: Error 1142 after upgrade to MySQL 5.5
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
673257: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=673257
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: automysqlbackup
Version: 2.6+debian-2
Severity: normal
Since upgrade to mysql-server-5.5 (and mysql-client-5.5 and so on), I started
getting mails from cron each morning at 07:35 when automysqlbackup is run:
> Subject: ERRORS REPORTED: MySQL Backup error Log for d-f05 -
>
> mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user 'debian-
sys-maint'@'localhost' for table 'cond_instances' when using LOCK TABLES
, but all backups seem to be OK.
This is directly followed by a mail
> Subject: MySQL Backup Log for d-f05 - 2012-05-17_07h35m
which contains backup information on all local affected databases.
automysqlbackup used to be completely quiet (MAILCONTENT=quiet), so this mail
is also new.
I set MAILCONTENT=stdout and ran `sudo /usr/sbin/automysqlbackup` in a terminal
and got first the log of all backed up databases, followed by
###### WARNING ######
Errors reported during AutoMySQLBackup execution.. Backup failed
Error log below..
mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user 'debian-
sys-maint'@'localhost' for table 'cond_instances' when using LOCK TABLES
, but as before, all backups seem to be OK.
---
This is probably not interesting for this issue, but I include it since it was
something I noticed at the same time:
For some reason only ~half of the databases got a status message such as:
Daily Backup of Database ( pureftpd )
Rotating last weeks Backup...
removed
`/var/lib/automysqlbackup/daily/pureftpd/pureftpd_2012-05-10_07h35m.torsdag.sql.gz'
, whereas the other half missed the last "removed" line. I guess this is an
entirely other issue, where there is some second precision offset on the
timestamps from last weeks backup that makes the script think of them as either
6d23h59m59s or 7d00h00m00s old. This is not a problem in itself, just a
curiosity.
-- System Information:
Debian Release: wheezy/sid
APT prefers unstable
APT policy: (500, 'unstable'), (1, 'experimental')
Architecture: i386 (i686)
Kernel: Linux 3.2.0-2-686-pae (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=sv_SE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages automysqlbackup depends on:
ii mysql-client 5.5.23-2
ii mysql-client-5.5 [mysql-client] 5.5.23-2
Versions of packages automysqlbackup recommends:
ii mutt 1.5.21-5+b1
automysqlbackup suggests no packages.
-- no debconf information
--- End Message ---
--- Begin Message ---
Source: automysqlbackup
Source-Version: 2.6+debian.2-1
We believe that the bug you reported is fixed in the latest version of
automysqlbackup, which is due to be installed in the Debian FTP archive:
automysqlbackup_2.6+debian.2-1.debian.tar.gz
to main/a/automysqlbackup/automysqlbackup_2.6+debian.2-1.debian.tar.gz
automysqlbackup_2.6+debian.2-1.dsc
to main/a/automysqlbackup/automysqlbackup_2.6+debian.2-1.dsc
automysqlbackup_2.6+debian.2-1_all.deb
to main/a/automysqlbackup/automysqlbackup_2.6+debian.2-1_all.deb
automysqlbackup_2.6+debian.2.orig.tar.gz
to main/a/automysqlbackup/automysqlbackup_2.6+debian.2.orig.tar.gz
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to [email protected],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Thomas Goirand <[email protected]> (supplier of updated automysqlbackup package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [email protected])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160
Format: 1.8
Date: Fri, 25 May 2012 11:42:27 +0000
Source: automysqlbackup
Binary: automysqlbackup
Architecture: source all
Version: 2.6+debian.2-1
Distribution: unstable
Urgency: low
Maintainer: Thomas Goirand <[email protected]>
Changed-By: Thomas Goirand <[email protected]>
Description:
automysqlbackup - daily, weekly and monthly backup for your MySQL database
Closes: 631218 673257
Changes:
automysqlbackup (2.6+debian.2-1) unstable; urgency=low
.
* Doesn't backup the performance_schema and information_schema databases by
default anymore (Closes: #673257).
* Bumps Standard-Version: to 3.9.3 (no change required).
* Added an option to backup routines with --routines (Closes: #631218).
Checksums-Sha1:
3e6ca081abcb5ddf57455d4e7dcfaa830029a656 1321
automysqlbackup_2.6+debian.2-1.dsc
883d90437a7c40d2911775e7143f4d2ce0eea962 8395
automysqlbackup_2.6+debian.2.orig.tar.gz
837fe424c6341934633a6e0d29dc7ab0a1f37063 5741
automysqlbackup_2.6+debian.2-1.debian.tar.gz
23a60a48ebfe2bae41b5a154745fbc3652734c1f 14590
automysqlbackup_2.6+debian.2-1_all.deb
Checksums-Sha256:
e70ed9dc0952dff13008ac57c9d0833be0bf581ffe4c84d74da2cb62ae98dbc6 1321
automysqlbackup_2.6+debian.2-1.dsc
60d1cc61947cda2f7d4edeaafbac862603512d092e64afb8a6283f36e0fbadb9 8395
automysqlbackup_2.6+debian.2.orig.tar.gz
4473e4c3189b899fd4ba4456050a9d353c4be37f030b568b61fd93f5f8aa20df 5741
automysqlbackup_2.6+debian.2-1.debian.tar.gz
b2e29ef3d44d7ca4f6241d2c3b38a21b6b1a28aebb5e243c4bbb0715b17e5676 14590
automysqlbackup_2.6+debian.2-1_all.deb
Files:
c5d6ac4e56bce61ccfed1b28688cb0fe 1321 admin extra
automysqlbackup_2.6+debian.2-1.dsc
1c71a22389bc09e8340e1c69892f1a2b 8395 admin extra
automysqlbackup_2.6+debian.2.orig.tar.gz
1613a0fa267d9ac517a6cb07f1b6a9e4 5741 admin extra
automysqlbackup_2.6+debian.2-1.debian.tar.gz
102225e1d23427dff56c541514659417 14590 admin extra
automysqlbackup_2.6+debian.2-1_all.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
iEYEAREDAAYFAk+/dFAACgkQl4M9yZjvmkl8xACfZqPkH4jV489cUrnGiHLyTJVj
CXoAnAg2rEBuBtCCrDZBndXflA0ctcUH
=V2cB
-----END PGP SIGNATURE-----
--- End Message ---
