New task #5754 in mysql: mysql error log

[Flyspray - The bug killer!]

Project: PLD 2.x (Ac)

  Reported by: Elan Ruusamäe (glen)
      Package: mysql
      Version: 5.0.18-2
      Summary: mysql error log
  
  http://dev.mysql.com/doc/refman/5.0/en/error-log.html

we could have with log-error option errorfile rotation but the problem
is that it appends .err.
ie with: log-error  = /var/log/mysql/err
it uses:

09:27:30 root[pts/1]@wintersunset log/mysql# lsof -c mysqld|grep log
mysqld  32191 mysql    1u  REG        3,7      1289  5219800
/var/log/mysql/err.err

ideas? (i think rotation should be restored, as the logfile could grow
too big)

it isn't rotated by logrotate, because i disabled it earlier, because
just moving file away is not rotating
the file was removed and mysqld was not forced to reopen it --- really
bad:

revision 1.13
date: 2005/03/30 06:22:29;  author: glen;  state: Exp;  lines: +1 -1
- DO NOT logrotate /var/log/mysql/err!
 or if you do please assure it's afterwards readable too!
 mysqld mysql    2w  REG        8,5        146  6291594
/var/log/archiv/mysql/err.1 (deleted)

so there i see two ways to use the option: just use mysql(d).err
or patch source not to use .err suffix ;)

but i prefer less patches to upstream

besides not sure how to handle upgrades
maybe should make the option from commandline rather in config file

For more further see:
http://bugs.pld-linux.org/index.php?do=details&id=5754

------------------------------------------------------------------------
THIS IS AN AUTOMATICALLY GENERATED MESSAGE, DO NOT REPLY