Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9960

Binary log not rotating

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 5.5(EOL), 10.0(EOL)
    • 10.1.30
    • None
    • 10.1.15, 10.1.20, 10.1.22, 10.1.29

    Description

      There is an intermittent bug whereby the binary log does not rotate . The binary log size is set at 100MB yet there are times it does not rotate and exceeds 100MB .

      The binary log has sometimes grown to 60GB in size . Commands like FLUSH LOGS do not achieve rotation . When a binary log file becomes more than 10 days old, it is supposed to be deleted by the database server , this is not happening once hit by the bug .

      The Mariadb node has to be restarted to rotate the binary log once it grows above 100MB . Parameters like max-bin-log and expire-logs-days are configured correctly .

      max_binlog_size | 104857600
      expire_logs_days | 8

      Attachments

        1. configuration.txt
          12 kB
          John Burwell
        2. mysql-bin.001551
          300 kB
          John Burwell

        Issue Links

          Activity

            People

              Elkin Andrei Elkin
              tbanza TYNDALE BANZA
              Votes:
              2 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.