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

[Warning] "Versioned table ...: partition ... is full, add more HISTORY partitions" floods the error log

    XMLWordPrintable

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.3
    • 10.4
    • Versioned Tables
    • None

    Description

      2018-05-21 18:14:11 10 [Warning] mysqld: Versioned table `test`.`table2_int_autoinc`: partition `ver_p1` is full, add more HISTORY partitions
      2018-05-21 18:14:11 10 [Warning] mysqld: Versioned table `test`.`table0_int_autoinc`: partition `ver_p3` is full, add more HISTORY partitions
      2018-05-21 18:14:11 10 [Warning] mysqld: Versioned table `test`.`table0_int_autoinc`: partition `ver_p3` is full, add more HISTORY partitions
      2018-05-21 18:14:11 10 [Warning] mysqld: Versioned table `test`.`table0_int_autoinc`: partition `ver_p3` is full, add more HISTORY partitions
      2018-05-21 18:14:11 10 [Warning] mysqld: Versioned table `test`.`table0_int_autoinc`: partition `ver_p3` is full, add more HISTORY partitions
      2018-05-21 18:14:11 10 [Warning] mysqld: Versioned table `test`.`table0_int_autoinc`: partition `ver_p3` is full, add more HISTORY partitions
      2018-05-21 18:14:11 10 [Warning] mysqld: Versioned table `test`.`table0_int_autoinc`: partition `ver_p3` is full, add more HISTORY partitions
      2018-05-21 18:14:11 10 [Warning] mysqld: Versioned table `test`.`table2_int_autoinc`: partition `ver_p1` is full, add more HISTORY partitions
      

      The warning can be written many times per second, on a busy instance it might completely flood the log. It's good to warn about the problem, but it's not that important to create gigabytes of identical log record. We have some examples for certain records being throttled, I think this one should be as well.

      Attachments

        Activity

          People

            midenok Aleksey Midenkov
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.