Package: mysql-server-5.0
Version: 5.0.13rc-1
Severity: normal

I turned off binary logging on my MySQL instance by commenting out
log-bin in my.cnf. The next day the daily cron job failed like this:

  /etc/cron.daily/mysql-server:
  ERROR 1381 (HY000) at line 1: You are not using binary logging

This sounds just like bug 332280, which is now fixed, but I'm running
5.0.13-x which is supposed to have fixed this bug.

I dug into the script a bit and I think the problem is that the test
for whether binary logging works isn't quite right. In particular,
this command:

  echo 'SHOW MASTER LOGS;'|  mysql --skip-column-names | cut -f1 >/tmp/foo 2>&1;

returns exit code 0 on my machine, so the test in cron.daily is
failing. I am getting the expected output
  ERROR 1381 (HY000) at line 1: You are not using binary logging
although strangely it's showing up in my console, not the temp file.

PS: thank you for maintaing mysql for Debian!

-- System Information:
Debian Release: testing/unstable
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.4.27-2-k7
Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1)

Versions of packages mysql-server-5.0 depends on:
ii  adduser          3.77                    Add and remove users and groups
ii  debconf [debconf 1.4.59                  Debian configuration management sy
ii  libc6            2.3.5-6                 GNU C Library: Shared libraries an
ii  libdbi-perl      1.48-2                  Perl5 database interface by Tim Bu
ii  libgcc1          1:4.0.2-2               GCC support library
ii  libmysqlclient15 5.0.13rc-1              mysql database client library
ii  libncurses5      5.4-9                   Shared libraries for terminal hand
ii  libreadline5     5.0-11                  GNU readline and history libraries
ii  libstdc++6       4.0.2-2                 The GNU Standard C++ Library v3
ii  libwrap0         7.6.dbs-8               Wietse Venema's TCP wrappers libra
ii  mailx            1:8.1.2-0.20050715cvs-1 A simple mail user agent
ii  mysql-client-5.0 5.0.13rc-1              mysql database client binaries
ii  mysql-common     5.0.13rc-1              mysql database common files (e.g. 
ii  passwd           1:4.0.13-1              change and administer password and
ii  perl             5.8.7-7                 Larry Wall's Practical Extraction 
ii  psmisc           21.8-1                  Utilities that use the proc filesy
ii  zlib1g           1:1.2.3-4               compression library - runtime

mysql-server-5.0 recommends no packages.

-- debconf information excluded


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Reply via email to