[jira] [Created] (CLOUDSTACK-5860) Bin-logs are not deleted even after the expire_logs_days interval.

["Kiran Koneti (JIRA)" <ji...@apache.org>]

Kiran Koneti created CLOUDSTACK-5860:
----------------------------------------

             Summary: Bin-logs are not deleted even after the expire_logs_days interval.
                 Key: CLOUDSTACK-5860
                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-5860
             Project: CloudStack
          Issue Type: Bug
      Security Level: Public (Anyone can view this level - this is the default.)
          Components: Management Server
    Affects Versions: 4.3.0
            Reporter: Kiran Koneti
            Priority: Critical
             Fix For: 4.3.0


In the /etc/my.cnf file added two parameters expire_logs_days=1
max_binlog_size=150M ,which means that the bin-logs which are rotated should be deleted after one day and the log should be rotated only after the max size is exceeded.the logs are not rotated until it has reached the limit but the previous logs which are rotated are not deleted.

The below are the file details in the "/var/lib/mysql"
 ls -ltr
total 172628
drwx------. 2 mysql mysql     4096 Oct 23 18:11 test
drwx------. 2 mysql mysql     4096 Oct 23 18:11 mysql
drwx------. 2 mysql mysql     4096 Nov 18 17:32 kiran
drwx------. 2 mysql mysql     4096 Nov 18 17:32 swathi
-rw-rw----. 1 mysql mysql 39105494 Jan 10 16:20 mysql-bin.000036
-rw-rw----. 1 mysql mysql      125 Jan 10 16:28 mysql-bin.000037
-rw-rw----. 1 mysql mysql       57 Jan 10 16:32 mysql-bin.index
srwxrwxrwx. 1 mysql mysql        0 Jan 10 16:32 mysql.sock
-rw-rw----. 1 mysql mysql      156 Jan 10 16:32 mysqld-relay-bin.000015
-rw-rw----. 1 mysql mysql       52 Jan 10 16:32 mysqld-relay-bin.index
drwx------. 2 mysql mysql     4096 Jan 10 16:37 cloudbridge
drwx------. 2 mysql mysql     4096 Jan 10 16:38 cloud_usage
drwx------. 2 mysql mysql    12288 Jan 10 16:38 cloud
-rw-rw----. 1 mysql mysql  5242880 Jan 13 12:14 ib_logfile1
-rw-rw----. 1 mysql mysql  1160427 Jan 13 16:09 mysql-bin.000038
-rw-rw----. 1 mysql mysql 35651584 Jan 13 16:09 ibdata1
-rw-rw----. 1 mysql mysql 90288777 Jan 13 16:09 mysqld-relay-bin.000016
-rw-rw----. 1 mysql mysql       76 Jan 13 16:09 master.info
-rw-rw----. 1 mysql mysql  5242880 Jan 13 16:09 ib_logfile0
-rw-rw----. 1 mysql mysql       63 Jan 13 16:09 relay-log.info

Here we can clearly see the   " mysql-bin.000036" and  "mysql-bin.000037" which were rotated on 10th Jan is not removed till 13th Jan.



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)