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

Expiring and purging binlogs not working

    XMLWordPrintable

Details

    Description

      After upgrading to 11.4 we noticed that binlogs don't expire any more. I tried with a fresh setup on a test system, same result.

      The server was configured with the following settings:

      # mariadbd --print-defaults
      mariadbd would have been started with the following arguments:
      --socket=/run/mysqld/mysqld.sock --pid-file=/run/mysqld/mysqld.pid --basedir=/usr --bind-address=127.0.0.1 --server-id=1 --log_bin=/var/log/mysql/mysql-bin.log --max_binlog_size=1M --binlog_expire_logs_seconds=60 --character-set-server=utf8mb4 --character-set-collations=utf8mb4=uca1400_ai_ci
      

      To create some content for the binary logs I used sysbench

      mariadb -e "CREATE DATABASE test;"
      sysbench oltp_common --db-driver=mysql --table-size=100000 --mysql-user=root --mysql-db=test prepare
      sysbench oltp_read_write --db-driver=mysql --table-size=100000 --mysql-user=root --mysql-db=test --threads=1 --report-interval=1 run
      

      • The log shows nothing except the normal startup lines
      • With version 11.3, binlog files are removed automatically after ~1 minute. With 11.4 they stay
      • Manually purging binary logs via "PURGE BINARY LOGS TO 'mysql-bin.000010';" works as expected in 11.3 but has no effect in 11.4 (also no error message)

      Any suggestions to work around this bug are also welcome as the logs are filling the disk on the affected systems.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              Delbrueck Christoph
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.