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

Transaction not registered for MariaDB 2PC, but transaction is active upon CREATE .. SELECT from OQGraph table

    XMLWordPrintable

Details

    Description

      --source include/have_innodb.inc
       
      INSTALL SONAME 'ha_oqgraph';
       
      CREATE TABLE oq_backing (
        origid INT UNSIGNED NOT NULL, 
        destid INT UNSIGNED NOT NULL,  
        PRIMARY KEY (origid, destid), 
        KEY (destid)
      ) ENGINE=InnoDB;
      CREATE TABLE oq (
        latch VARCHAR(32) NULL,
        origid BIGINT UNSIGNED NULL,
        destid BIGINT UNSIGNED NULL,
        weight DOUBLE NULL,
        seq BIGINT UNSIGNED NULL,
        linkid BIGINT UNSIGNED NULL,
        KEY (latch, origid, destid) USING HASH,
        KEY (latch, destid, origid) USING HASH
      ) ENGINE=OQGRAPH data_table='oq_backing' origid='origid' destid='destid';
       
      CREATE TABLE t (a INT);
      CREATE OR REPLACE TABLE t AS SELECT * FROM oq;
       
      # Cleanup
      DROP TABLE t, oq, oq_backing;
      UNINSTALL SONAME 'ha_oqgraph';
      

      10.4 64f44b22d9a3dab3d4c0b77addbcbdafde57b466

      2023-11-25 21:56:11 9 [ERROR] Transaction not registered for MariaDB 2PC, but transaction is active
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.