Mailinglist Archive: opensuse (818 mails)

< Previous Next >
Re: [opensuse] mysql and logrotate
On Fri, 6 Jul 2012 05:27:35 -0400
Carl Hartung <opensuse@xxxxxxxxxxxxx> 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@xxxxxxxxxxxx
To contact the owner, e-mail: opensuse+owner@xxxxxxxxxxxx

< Previous Next >
Follow Ups
References