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

CREATE SEQUENCE ... WITH ... INCREMENT BY 1 fails with Galera enabled

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.5.22, 10.6.16
    • N/A
    • Galera
    • Galera 26.4.16
      Galera 26.4.14

    Description

      CREATE SEQUENCE CHANGE_EVENTS_SID_SEQ START WITH 1577836800000000 INCREMENT BY 1;
      ERROR 1235 (42000): This version of MariaDB doesn't yet support 'In Galera if you use CACHE you should set INCREMENT BY 0 to behave correctly in a cluster'

      It also failed with other MariaDB releases using Galera starting. (Works without Galera enabled)

      version = 10.6.16-11-MariaDB-enterprise-log
      version = 10.5.22-16-MariaDB-enterprise-log

      wsrep_provider_version = 26.4.14-1(ra480e94)
      wsrep_provider_version = 26.4.16

      wsrep_patch_version = wsrep_26.22

      Workaround it by adding the NOCACHE option per example below:

      CREATE SEQUENCE CHANGE_EVENTS_SID_SEQ START WITH 1577836800000000 INCREMENT BY 1 NOCACHE;
      Query OK, 0 rows affected (1.417 sec)

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              martin.reinhardt@mariadb.com Martin Reinhardt
              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.