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

ER_GET_ERRNO upon online alter with concurrent DML on CONNECT table

    XMLWordPrintable

Details

    Description

      Note: Some Connect table types don't support the copy algorithm (MDEV-30909) and there are legacy failures with others (MDEV-30914, MDEV-30915, MDEV-30907); but ALTER like the one this report, on a DOS table type, seems to work when no concurrency is involved.

      --source include/have_debug_sync.inc
       
      install soname 'ha_connect';
       
      create table t (a int) engine=Connect table_type=DOS;
      insert into t values (1),(2);
      --send set debug_sync= 'now wait_for go_dml'
       
      --connect (con1,localhost,root,,)
      set debug_sync='alter_table_online_progress signal go_dml wait_for go_alter';
      --send alter table t add b int, algorithm=copy, lock=none
       
      --connection default
      --reap
      delete from t where a = 2;
      set debug_sync= 'now signal go_alter';
       
      --connection con1
      --reap
      select * from t;
       
      # Cleanup
      drop table t;
      uninstall soname 'ha_connect';
      

      bb-11.2-oalter b0484157ecd33e153e181d9ca4c055b82046ffea

      At line 19: query 'reap' failed: ER_GET_ERRNO (1030): Got error 174 "Fatal error during initialization of handler" from storage engine CONNECT
      

      Attachments

        Issue Links

          Activity

            People

              nikitamalyavin Nikita Malyavin
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.