mysql & logrotate not behaving post Etch dist-upgrade
I received this this morning:
From: Anacron <root@infidel.spots.ab.ca>
To: root@infidel.spots.ab.ca
Subject: Anacron job 'cron.daily' on infidel
Date: Fri, 21 Oct 2005 07:37:47 -0600
X-Bogosity: Ham, tests=bogofilter, spamicity=0.000000, version=0.96.2
/etc/cron.daily/mysql-server:
ERROR at line 1: Target log not found in binlog index
run-parts: /etc/cron.daily/mysql-server exited with return code 1
(0) infidel root /etc/mysql_ all /var/log/mysql
total 636
drwxr-s--- 2 mysql adm 4096 Oct 21 07:37 ./
drwxr-xr-x 11 root root 4096 Oct 21 07:37 ../
-rw-rw---- 1 mysql adm 2996 Oct 20 08:14 mysql-bin.000032
-rw-rw---- 1 mysql adm 214579 Oct 20 08:14 mysql-bin.000033
-rw-rw---- 1 mysql adm 206 Oct 20 08:14 mysql-bin.000034
-rw-rw---- 1 mysql adm 472 Oct 20 08:14 mysql-bin.000035
-rw-rw---- 1 mysql adm 629 Oct 20 08:14 mysql-bin.000036
-rw-rw---- 1 mysql adm 684 Oct 21 07:37 mysql-bin.000037
-rw-rw---- 1 mysql adm 4 Oct 21 07:37 mysql-bin.000038
-rw-rw---- 1 mysql adm 44 Oct 15 07:37 mysql-bin.025
-rw-rw---- 1 mysql adm 45498 Oct 16 07:35 mysql-bin.026
-rw-rw---- 1 mysql adm 132771 Oct 17 07:35 mysql-bin.027
-rw-rw---- 1 mysql adm 9392 Oct 18 07:35 mysql-bin.028
-rw-rw---- 1 mysql adm 2266 Oct 19 07:37 mysql-bin.029
-rw-rw---- 1 mysql adm 144334 Oct 20 07:35 mysql-bin.030
-rw-rw---- 1 mysql adm 4 Oct 20 07:35 mysql-bin.031
-rw-rw---- 1 mysql adm 427 Oct 21 07:37 mysql-bin.index
/etc/mysql/my.cnf:
# The following can be used as easy to replay backup logs or for replication.
#server-id = 1
log-bin = /var/log/mysql/mysql-bin.log
cat /etc/mysql/debian-log-rotate.conf
KEEP_BINARY_LOGS=7
/etc/cron.daily/mysql-server:
M="/usr/bin/mysql --defaults-file=/etc/mysql/debian.cnf"
# Retrieving list of file names. Can fail if no binary logs are in use.
if ! echo 'SHOW MASTER LOGS;' | $M --skip-column-names >$tmp 2>&1; then
if grep -q 'You are not using binary logging' $tmp; then
my_exit 0
else
echo "Unknown problem retrieving MySQL master log filenames in $0."
cat $tmp
my_exit 1
fi
fi
That "else" is the return code, but that's not the message it displays:
/etc/cron.daily/mysql-server:
ERROR at line 1: Target log not found in binlog index
--
Any technology distinguishable from magic is insufficiently advanced.
(*) http://www.spots.ab.ca/~keeling Linux Counter #80292
- - Spammers! http://www.spots.ab.ca/~keeling/autospam.html
http://www.ietf.org/rfc/rfc1855.txt democracy human rights Taiwan Independence
Reply to: