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

galera regression Maximum writeset size exceeded, After update from 10.11.11 to 10.11.14

    XMLWordPrintable

Details

    • Not for Release Notes

    Description

      After updating MariaDB from 10.11.11 to 10.11.14, the cron job that is reseting auto increment ID failed with bash message: ERROR 1105 (HY000) at line 25: Maximum writeset size exceeded

      The table is in size

      +----------+
      | count(*) |
      +----------+
      |  6264980 |
      +----------+
      

      this is from DB :

      show variables like '%wsrep_max_ws%';
      +-------------------+------------+
      | Variable_name     | Value      |
      +-------------------+------------+
      | wsrep_max_ws_rows | 0          |
      | wsrep_max_ws_size | 2147483647 |
      +-------------------+------------+
      

      Error in the mariadb.log:

       [ERROR] WSREP: Maximum writeset size exceeded by 11294497
               at /home/buildbot/buildbot/build/galera/src/write_set_ng.hpp:check_size():700
      

      Attachments

        Activity

          People

            janlindstrom Jan Lindström
            shexphobos Xesh
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.