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

sequence.simple fails on replay

    XMLWordPrintable

Details

    • Unexpected results
    • Q3/2026 Server Maintenance

    Description

      sequence.simple fails on replay

        explain select * from seq_15_to_1_step_12345;
      -id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	SIMPLE	seq_15_to_1_step_12345	ALL	NULL	NULL	NULL	NULL	1	
      +ReplayTest: Query error: CREATE TABLE `seq_15_to_1_step_12345` (
      +  `seq` bigint(20) unsigned NOT NULL,
      +  PRIMARY KEY (`seq`)
      +) ENGINE=SEQUENCE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci: Table 'seq_15_to_1_step_12345' already exists
      

      MTR testcase to repro issue: (Say example.test)

      --source include/have_sequence.inc
      --source include/have_innodb.inc
      explain select * from seq_15_to_1_step_12345;
      

      How to repro

      ./mtr example.test  --record
      ./mtr example.test  --replay-server
      

      Attachments

        Issue Links

          Activity

            People

              bsrikanth Srikanth Bondalapati
              mariadb-pavithrapandith Pavithra Pandith
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 1d Original Estimate - 1d
                  1d
                  Remaining:
                  Time Spent - 5h 5m Remaining Estimate - 3h
                  3h
                  Logged:
                  Time Spent - 5h 5m Remaining Estimate - 3h
                  5h 5m

                  Git Integration

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