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



-- 
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org

Reply via email to