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

mariabackup fails with 'try increasing innodb_log_file_size'

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 11.4.4
    • 11.4
    • Backup
    • None

    Description

      The backups would fail with this error despite multiple increases to the innodb_log_file_size.

      [00] 2025-03-03 18:10:25 Was only able to copy log from 63677889668553 to 63680238996661, not 63682682984728; try increasing innodb_log_file_size
      mariabackup: Stopping log copying thread.[00] 2025-03-03 18:10:25 Retrying read of log at LSN=63680238996661
      

      Eventually, after increasing the innodb_log_file_size to 30G, the backups began working.

      This is the backup command used:

      mariabackup --backup --kill-long-queries-timeout=300 --kill-long-query-type=SELECT --open-files-limit=100000 --user=backup --password=x xxxxxxxxxxxxxxxxxx --socket=/run/mysqld/mysqld.sock --parallel=4 --extra-lsndir=/tmp --stream=xbstream --slave-info --ftwrl-wait-timeout=30 --ftwrl-wait-threshold=999999 --target-dir=/backup//2025-03-03/mariabackup
      

      Attachments

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              bwillits Bill Willits
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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