On Fri, 6 Jul 2012 05:27:35 -0400 Carl Hartung <opensuse@cehartung.com> wrote:

Hi All,

Referencing these:

https://bugzilla.novell.com/show_bug.cgi?id=763150

http://lists.opensuse.org/opensuse/2012-05/msg00694.html

Finally got around to this here and noticed the following:

~ #> cat /etc/logrotate.d/mysql

# This logname can be set in /etc/my.cnf # by setting the variable "err-log" # in the [safe_mysqld] section as follows: # # [safe_mysqld] # err-log=/var/log/mysqld.log - - - - - 8< snip >8 - - - - -

~ #> cat /etc/my.cnf

- - - - - 8< snip >8 - - - - - # The safe_mysqld script [safe_mysqld] log-error = /var/log/mysql/mysqld.log socket = /var/run/mysql/mysql.sock - - - - - 8< snip >8 - - - - -

Is the problem a transposition of the variable 'err-log' in /etc/my.cnf with the the mysql flag '--log-error'?

Just following up on my own post. Early yesterday, I changed the line in /etc/my.cnf from: log-error = /var/log/mysql/mysqld.log to: err-log = /var/log/mysql/mysqld.log and I've just discovered a newly compressed log file accompanied by a long string of uncompressed log files. The uncompressed files have corresponding error entries in /etc/warn, per the previously referenced bug report. Looks like a typo (variable name transposed with a cli argument) was inserted during an update sometime after May 14: -rw-rw---- 1 mysql mysql 389 May 13 20:29 mysqld.log-20120514.bz2 -rw-rw---- 1 mysql mysql 1414 May 18 11:44 mysqld.log-20120515 -rw-rw---- 1 mysql mysql 739 May 20 20:14 mysqld.log-20120519 -rw-rw---- 1 mysql mysql 794 May 22 09:21 mysqld.log-20120521 -rw-rw---- 1 mysql mysql 739 May 26 14:03 mysqld.log-20120523 -rw-rw---- 1 mysql mysql 658 May 28 08:23 mysqld.log-20120527 -rw-rw---- 1 mysql mysql 658 May 31 09:24 mysqld.log-20120529 -rw-rw---- 1 mysql mysql 794 Jun 4 06:32 mysqld.log-20120601 -rw-rw---- 1 mysql mysql 739 Jun 7 21:10 mysqld.log-20120605 -rw-rw---- 1 mysql mysql 794 Jun 9 09:49 mysqld.log-20120608 -rw-rw---- 1 mysql mysql 739 Jun 10 06:44 mysqld.log-20120610 -rw-rw---- 1 mysql mysql 794 Jun 15 08:27 mysqld.log-20120611 -rw-rw---- 1 mysql mysql 739 Jun 17 06:55 mysqld.log-20120616 -rw-rw---- 1 mysql mysql 794 Jun 21 05:04 mysqld.log-20120618 -rw-rw---- 1 mysql mysql 739 Jun 23 17:49 mysqld.log-20120622 -rw-rw---- 1 mysql mysql 658 Jun 25 16:26 mysqld.log-20120624 -rw-rw---- 1 mysql mysql 794 Jul 1 03:56 mysqld.log-20120626 -rw-rw---- 1 mysql mysql 1994 Jul 4 08:41 mysqld.log-20120702 -rw-rw---- 1 mysql mysql 794 Jul 6 05:04 mysqld.log-20120705 -rw-rw---- 1 mysql mysql 104 Jul 6 05:04 mysqld.log-20120707.bz2 regards, Carl -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org