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

Inconsistent warning, only with CONNECT

    XMLWordPrintable

Details

    Description

      MariaDB [xxx]> LOCK TABLE m WRITE;
      Query OK, 0 rows affected (0.00 sec)
       
      MariaDB [xxx]> START TRANSACTION;
      Query OK, 0 rows affected (0.00 sec)
       
      MariaDB [xxx]> LOCK TABLE t WRITE;
      Query OK, 0 rows affected (0.00 sec)
       
      MariaDB [xxx]> START TRANSACTION;
      Query OK, 0 rows affected, 1 warning (0.00 sec)
       
      Warning (Code 1105): external_lock: unexpected command 59

      The table `m` is MyISAM but, as far as I can tell, no warning occurs with other storage engines. The table `t` is CONNECT, which seems to be the only engine that issues a warning.

      I report this behavior because you probably want to be aware about inconsistencies between engines. But, to be honest, I prefer CONNECT's behavior: when a trx starts, table locks are lost, and this is something I want to know. I hope that a more informative warning will be issued, no matter which engine I am using.

      Attachments

        Activity

          People

            bertrandop Olivier Bertrand
            f_razzoli Federico Razzoli
            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.