ClearOS Bug Tracker


View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0001129ClearOSsystem-mysqlpublic2013-04-30 14:292014-06-23 10:43
Reporteruser2 
Assigned Touser2 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version6.4.0 
Target Version6.5.0 UpdatesFixed in Version6.5.0 Updates 
Summary0001129: System MySQL log does not rotate
DescriptionThe system MySQL log should be rotated!
TagsNo tags attached.
Attached Files

- Relationships

-  Notes
(0000837)
NickH (developer)
2013-05-01 05:07

system-mysql.log used to rotate in 5.2 but with a logrotate function a bit different from normal logrotate functions:
 
/var/log/system-mysql/mysqld.log {
     missingok
     create 0640 system-mysql system-mysql
     prerotate
     [ -e /var/lock/subsys/system-mysqld ] && /bin/kill -HUP `cat /var/run/system-mysqld/system-mysqld.pid 2> /dev/null ` || /bin/true
     endscript
     postrotate
     [ -e /var/lock/subsys/system-mysqld ] && /bin/kill -HUP `cat /var/run/system-mysqld/system-mysqld.pid 2> /dev/null ` || /bin/true
     endscript
 }
(0000839)
NickH (developer)
2013-05-01 13:40

Another possible way of doing this without prerotate and postrotate scripts (which I don't fully understand) is to use the copytruncate function instead but there is apparently a minor risk of data loss with this function.

- Issue History
Date Modified Username Field Change
2013-04-30 14:29 user2 New Issue
2013-04-30 14:29 user2 Issue generated from: 0000225
2013-04-30 14:29 user2 Assigned To => user2
2013-04-30 14:29 user2 Status new => confirmed
2013-05-01 05:07 NickH Note Added: 0000837
2013-05-01 13:40 NickH Note Added: 0000839
2013-07-29 13:57 user2 Target Version 6.4.0 Updates => 6.5.0 Beta 1
2013-08-20 13:18 user2 Target Version 6.5.0 Beta 1 => 6.5.0 Beta 2
2013-10-07 13:51 user2 Target Version 6.5.0 Beta 2 => 6.5.0 Beta 3
2013-11-21 19:11 user2 Target Version 6.5.0 Beta 3 => 6.5.0
2013-12-09 15:35 user2 Target Version 6.5.0 => 6.6.0 Beta 1
2014-05-08 08:09 user2 Target Version 6.6.0 Beta 1 => 6.6.0 Beta 2
2014-05-28 19:56 user2 Category app-system-database - System Database => system-mysql
2014-05-28 19:56 user2 Status confirmed => resolved
2014-05-28 19:56 user2 Fixed in Version => 6.6.0 Beta 2
2014-05-28 19:56 user2 Resolution open => fixed
2014-06-10 20:10 user2 Status resolved => closed
2014-06-23 10:43 user2 Fixed in Version 6.6.0 Beta 2 => 6.5.0 Updates
2014-06-23 10:43 user2 Target Version 6.6.0 Beta 2 => 6.5.0 Updates