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

Galera: Malformed packet, ER_SP_DOES_NOT_EXIST or ER_VIEW_INVALID on concurrent view creation and procedure call

    XMLWordPrintable

Details

    Description

      Provided test case usually finishes with error 2027 (Malformed packet), and sometimes with 1356 (ER_VIEW_INVALID) or 1305 (ER_SP_DOES_NOT_EXIST), all of which are unexpected.

      It doesn't happen if the test is executed with wsrep disabled.

      MTR test case:

      --sleep 2
       
      --source include/have_innodb.inc 
      --source include/have_binlog_format_row.inc
       
      SET GLOBAL lock_wait_timeout = 2;
      SET GLOBAL innodb_lock_wait_timeout = 1;
       
      CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=InnoDB;
      CREATE OR REPLACE VIEW v1 AS SELECT pk FROM t1;
      CREATE FUNCTION func1() RETURNS INTEGER RETURN 4;
      CREATE FUNCTION func2() RETURNS INTEGER RETURN 4;
      CREATE PROCEDURE proc1() SELECT func1() FROM v1; 
       
       
      --connect (con1,localhost,root,,test)
      --connect (con2,localhost,root,,test)
       
      --let $run = 100
       
      while ($run)
      {
        --connection con1
        --send
      	  CREATE OR REPLACE ALGORITHM = TEMPTABLE VIEW v1 AS SELECT func2() AS pk FROM t1;
        --connection con2
      	  CALL proc1();
        --connection con1
        --reap
        --dec $run
      }

      MTR command line:

      perl ./mtr --mysqld=--innodb_autoinc_lock_mode=2 --mysqld=--innodb_locks_unsafe_for_binlog=1  --mysqld=--wsrep-provider=/home/elenst/galera/libgalera_smm.so --mysqld=--wsrep-cluster-address=gcomm://  --nocheck-testcases main.malformed_packet 

      revision-id: elenst@montyprogram.com-20130302232248-uozp6ilf7kbyfrgj
      revno: 3388
      branch-nick: maria-5.5-galera

      Attachments

        Issue Links

          Activity

            People

              ramesh Ramesh Sivaraman
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.