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(EOL)
    • 10.6
    • 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

        Issue Links

          Activity

            People

              midenok Aleksey Midenkov
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 0d
                  0d
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 10m
                  10m

                  Git Integration

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