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