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

spider/bugfix.mdev_20100, spider/bugfix.mdev_20502, spider/bugfix.mdev_26544, spider/bugfix.mdev_26582, spider/bugfix.mdev_27184, spider/bugfix.mdev_27239, spider/bugfix.mdev_27240, spider/bugfix.mdev_29484 fail

    XMLWordPrintable

Details

    Description

      looks like wrong privileges for test user

      logs example https://mdbe-ci-repo.mariadb.net/bb-logs/MariaDBServerCommunityProduction/11.1.1/rhel_7_gcp/mtr-psproto-test/22924/

      spider/bugfix.mdev_26544                 w7 [ fail ]
              Test ended at 2023-08-10 20:52:58
       
      CURRENT_TEST: spider/bugfix.mdev_26544
      mysqltest: At line 22: query 'INSERT INTO tbl_a (a) VALUES (0)' failed with wrong errno ER_DBACCESS_DENIED_ERROR (1044): 'Access denied for user ''@'localhost' to database 'auto_test_remote'', instead of ER_CONNECT_TO_FOREIGN_DATA_SOURCE (1429)...
       
      The result from queries just before the failure was:
      #
      # MDEV-26544 Assertion `part_share->auto_inc_initialized' failed in ha_partition::get_auto_increment on INSERT
      #
      for master_1
      for child2
      for child3
      connection master_1;
      CREATE DATABASE auto_test_remote;
      USE auto_test_remote;
      CREATE TABLE `tbl_a` (
      `a` INT AUTO_INCREMENT, KEY(`a`)
      ) ENGINE=Spider DEFAULT CHARSET=utf8
      PARTITION BY LIST COLUMNS (`a`) (
      PARTITION `pt1` DEFAULT
      );
      INSERT INTO tbl_a (a) VALUES (0);
       
      Warnings from just before the error:
      Error 1044 Access denied for user ''@'localhost' to database 'auto_test_remote' 
      Error 1044 Access denied for user ''@'localhost' to database 'auto_test_remote'
       
       - saving '/var/tmp/mtr/7/log/spider/bugfix.mdev_26544/' to '/var/tmp/mtr/log/bugfix.mdev_26544/'
       
      Retrying test spider/bugfix.mdev_26544, attempt(2/3)...
       
      worker[7] > Restart  - not started
      spider/bugfix.mdev_26539                 w3 [ pass ]    328
      worker[3] > Restart [mysqld.1.1 - pid: 19807, winpid: 19807] - using different config file
      worker[3] > Restart [mysqld.2.1 - pid: 19813, winpid: 19813] - using different config file
      spider/bugfix.mdev_26582                 w1 [ fail ]
              Test ended at 2023-08-10 20:52:58
       
      CURRENT_TEST: spider/bugfix.mdev_26582
      mysqltest: At line 17: query 'INSERT INTO t VALUES (0)' failed with wrong errno ER_SPECIFIC_ACCESS_DENIED_ERROR (1227): 'Access denied; you need (at least one of) the SUPER privilege(s) for this operation', instead of ER_CONNECT_TO_FOREIGN_DATA_SOURCE (1429)...
       
      The result from queries just before the failure was:
      #
      # MDEV-26582 SIGSEGV in spider_db_bulk_insert and spider_db_connect and spider_db_before_query, and hang in "End of update loop" / "Reset for next command" query states
      #
      CREATE DATABASE IF NOT EXISTS auto_test_local;
      USE auto_test_local;
      CREATE TABLE t (i CHAR) ENGINE=SPIDER;
      INSERT INTO t VALUES (0);
       
      Warnings from just before the error:
      Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation
       
       - skipping '/var/tmp/mtr/1/log/spider/bugfix.mdev_26582/'
       
      Retrying test spider/bugfix.mdev_26582, attempt(2/3)...
       
      worker[1] > Restart  - not started
      spider/bugfix.mdev_27184                 w4 [ fail ]
              Test ended at 2023-08-10 20:52:59
       
      CURRENT_TEST: spider/bugfix.mdev_27184
      mysqltest: At line 21: query 'INSERT INTO tbl_a VALUES
      (0xF5A7),(0xF5A8),(0xF5A9),(0xF5AA),(0xF5AB),(0xF5AC),(0xF5AD),(0xF5AE),
      (0xF5A7),(0xF5A8),(0xF5A9),(0xF5AA),(0xF5AB),(0xF5AC),(0xF5AD),(0xF5AE)' failed with wrong errno ER_SPECIFIC_ACCESS_DENIED_ERROR (1227): 'Access denied; you need (at least one of) the SUPER privilege(s) for this operation', instead of ER_CONNECT_TO_FOREIGN_DATA_SOURCE (1429)...
       
      The result from queries just before the failure was:
      #
      # MDEV-27184 Assertion `(old_top == initial_top (av) && old_size == 0) ||
      # ((unsigned long) (old_size) >= MINSIZE && prev_inuse (old_top) &&
      # ((unsigned long) old_end & (pagesize - 1)) == 0)' failed,
      # Assertion `str.alloced_length() >= str.length() + data_len' failed
      #
      for master_1
      for child2
      for child3
      connection master_1;
      CREATE DATABASE auto_test_remote;
      USE auto_test_remote;
      CREATE TABLE tbl_a (a FLOAT) ENGINE=SPIDER;
      INSERT INTO tbl_a VALUES
      (0xF5A7),(0xF5A8),(0xF5A9),(0xF5AA),(0xF5AB),(0xF5AC),(0xF5AD),(0xF5AE),
      (0xF5A7),(0xF5A8),(0xF5A9),(0xF5AA),(0xF5AB),(0xF5AC),(0xF5AD),(0xF5AE);
       
      Warnings from just before the error:
      Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation
       
       - skipping '/var/tmp/mtr/4/log/spider/bugfix.mdev_27184/'
       
      Retrying test spider/bugfix.mdev_27184, attempt(2/3)...
       
      worker[4] > Restart  - not started
      spider/bugfix.mdev_27239                 w6 [ fail ]
              Test ended at 2023-08-10 20:52:59
       
      CURRENT_TEST: spider/bugfix.mdev_27239
      --- /usr/share/mariadb-test/plugin/spider/spider/bugfix/r/mdev_27239.result	2023-06-05 20:45:45.000000000 +0200
      +++ /usr/share/mariadb-test/plugin/spider/spider/bugfix/r/mdev_27239.reject	2023-08-10 20:52:58.961422042 +0200
      @@ -9,10 +9,8 @@
       CREATE TABLE tbl_a (a INT) ENGINE=SPIDER;
       FLUSH TABLE tbl_a WITH READ LOCK;
       Warnings:
      -Error	1429	Unable to connect to foreign data source: localhost
      -Error	1429	Unable to connect to foreign data source: localhost
      -Error	1429	Unable to connect to foreign data source: localhost
      -Error	1429	Unable to connect to foreign data source: localhost
      +Error	1044	Access denied for user ''@'localhost' to database 'auto_test_local'
      +Error	1044	Access denied for user ''@'localhost' to database 'auto_test_local'
       BEGIN;
       DROP DATABASE auto_test_local;
       for master_1
       
      mysqltest: Result length mismatch
       
       - skipping '/var/tmp/mtr/6/log/spider/bugfix.mdev_27239/'
       
      Retrying test spider/bugfix.mdev_27239, attempt(2/3)...
       
      worker[6] > Restart  - not started
      spider/bugfix.mdev_26544                 w7 [ retry-fail ]
              Test ended at 2023-08-10 20:52:59
       
      CURRENT_TEST: spider/bugfix.mdev_26544
      mysqltest: At line 22: query 'INSERT INTO tbl_a (a) VALUES (0)' failed with wrong errno ER_DBACCESS_DENIED_ERROR (1044): 'Access denied for user ''@'localhost' to database 'auto_test_remote'', instead of ER_CONNECT_TO_FOREIGN_DATA_SOURCE (1429)...
       
      The result from queries just before the failure was:
      #
      # MDEV-26544 Assertion `part_share->auto_inc_initialized' failed in ha_partition::get_auto_increment on INSERT
      #
      for master_1
      for child2
      for child3
      connection master_1;
      CREATE DATABASE auto_test_remote;
      USE auto_test_remote;
      CREATE TABLE `tbl_a` (
      `a` INT AUTO_INCREMENT, KEY(`a`)
      ) ENGINE=Spider DEFAULT CHARSET=utf8
      PARTITION BY LIST COLUMNS (`a`) (
      PARTITION `pt1` DEFAULT
      );
      INSERT INTO tbl_a (a) VALUES (0);
       
      Warnings from just before the error:
      Error 1044 Access denied for user ''@'localhost' to database 'auto_test_remote' 
      Error 1044 Access denied for user ''@'localhost' to database 'auto_test_remote'
       
       - skipping '/var/tmp/mtr/7/log/spider/bugfix.mdev_26544/'
       
      Test spider/bugfix.mdev_26544 has failed 2 times, no more retries!
       
      worker[7] > Restart  - using different config file
      spider/bugfix.mdev_27240                 w2 [ fail ]
              Test ended at 2023-08-10 20:52:59
       
      CURRENT_TEST: spider/bugfix.mdev_27240
      mysqltest: At line 18: query 'LOCK TABLE tbl_a READ' failed with wrong errno ER_SPECIFIC_ACCESS_DENIED_ERROR (1227): 'Access denied; you need (at least one of) the SUPER privilege(s) for this operation', instead of ER_CONNECT_TO_FOREIGN_DATA_SOURCE (1429)...
       
      The result from queries just before the failure was:
      for master_1
      for child2
      for child3
      CREATE DATABASE auto_test_local;
      USE auto_test_local;
      CREATE TABLE tbl_a (a INT KEY) ENGINE=SPIDER;
      SELECT a.z FROM tbl_a AS a,tbl_a b WHERE a.z=b.z;
      ERROR 42S22: Unknown column 'a.z' in 'field list'
      ALTER TABLE tbl_a CHANGE c c INT;
      ERROR 42S22: Unknown column 'c' in 'tbl_a'
      LOCK TABLE tbl_a READ;
       
      Warnings from just before the error:
      Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation 
      Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation 
      Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation 
      Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation
       
       - skipping '/var/tmp/mtr/2/log/spider/bugfix.mdev_27240/'
       
      Retrying test spider/bugfix.mdev_27240, attempt(2/3)...
       
      worker[2] > Restart  - not started
      ***Warnings generated in error logs during shutdown after running tests: spider/bugfix.mdev_27240
       
      2023-08-10 20:52:59 6 [Warning] WSREP: handlerton rollback failed, thd 6 565 conf 0 SQL LOCK TABLE tbl_a READ
       
      spider/bugfix.mdev_26582                 w1 [ retry-fail ]
              Test ended at 2023-08-10 20:53:02
       
      CURRENT_TEST: spider/bugfix.mdev_26582
      mysqltest: At line 17: query 'INSERT INTO t VALUES (0)' failed with wrong errno ER_SPECIFIC_ACCESS_DENIED_ERROR (1227): 'Access denied; you need (at least one of) the SUPER privilege(s) for this operation', instead of ER_CONNECT_TO_FOREIGN_DATA_SOURCE (1429)...
       
      The result from queries just before the failure was:
      #
      # MDEV-26582 SIGSEGV in spider_db_bulk_insert and spider_db_connect and spider_db_before_query, and hang in "End of update loop" / "Reset for next command" query states
      #
      CREATE DATABASE IF NOT EXISTS auto_test_local;
      USE auto_test_local;
      CREATE TABLE t (i CHAR) ENGINE=SPIDER;
      INSERT INTO t VALUES (0);
       
      Warnings from just before the error:
      Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation
       
       - skipping '/var/tmp/mtr/1/log/spider/bugfix.mdev_26582/'
       
      Test spider/bugfix.mdev_26582 has failed 2 times, no more retries!
       
      worker[1] > Restart  - using different config file
      spider/bugfix.mdev_28854                 w8 [ pass ]    160
      worker[8] > Restart [mysqld.1.1 - pid: 20362, winpid: 20362] - using different config file
      worker[8] > Restart [mysqld.2.1 - pid: 20386, winpid: 20386] - using different config file
      spider/bugfix.mdev_28996                 w5 [ pass ]    460
      worker[5] > Restart [mysqld.1.1 - pid: 20388, winpid: 20388] - using different config file
      worker[5] > Restart [mysqld.2.1 - pid: 20399, winpid: 20399] - using different config file
      spider/bugfix.mdev_27184                 w4 [ retry-fail ]
              Test ended at 2023-08-10 20:53:03
       
      CURRENT_TEST: spider/bugfix.mdev_27184
      mysqltest: At line 21: query 'INSERT INTO tbl_a VALUES
      (0xF5A7),(0xF5A8),(0xF5A9),(0xF5AA),(0xF5AB),(0xF5AC),(0xF5AD),(0xF5AE),
      (0xF5A7),(0xF5A8),(0xF5A9),(0xF5AA),(0xF5AB),(0xF5AC),(0xF5AD),(0xF5AE)' failed with wrong errno ER_SPECIFIC_ACCESS_DENIED_ERROR (1227): 'Access denied; you need (at least one of) the SUPER privilege(s) for this operation', instead of ER_CONNECT_TO_FOREIGN_DATA_SOURCE (1429)...
       
      The result from queries just before the failure was:
      #
      # MDEV-27184 Assertion `(old_top == initial_top (av) && old_size == 0) ||
      # ((unsigned long) (old_size) >= MINSIZE && prev_inuse (old_top) &&
      # ((unsigned long) old_end & (pagesize - 1)) == 0)' failed,
      # Assertion `str.alloced_length() >= str.length() + data_len' failed
      #
      for master_1
      for child2
      for child3
      connection master_1;
      CREATE DATABASE auto_test_remote;
      USE auto_test_remote;
      CREATE TABLE tbl_a (a FLOAT) ENGINE=SPIDER;
      INSERT INTO tbl_a VALUES
      (0xF5A7),(0xF5A8),(0xF5A9),(0xF5AA),(0xF5AB),(0xF5AC),(0xF5AD),(0xF5AE),
      (0xF5A7),(0xF5A8),(0xF5A9),(0xF5AA),(0xF5AB),(0xF5AC),(0xF5AD),(0xF5AE);
       
      Warnings from just before the error:
      Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation
       
       - skipping '/var/tmp/mtr/4/log/spider/bugfix.mdev_27184/'
       
      Test spider/bugfix.mdev_27184 has failed 2 times, no more retries!
       
      worker[4] > Restart  - using different config file
      spider/bugfix.mdev_27239                 w6 [ retry-fail ]
              Test ended at 2023-08-10 20:53:03
       
      CURRENT_TEST: spider/bugfix.mdev_27239
      --- /usr/share/mariadb-test/plugin/spider/spider/bugfix/r/mdev_27239.result	2023-06-05 20:45:45.000000000 +0200
      +++ /usr/share/mariadb-test/plugin/spider/spider/bugfix/r/mdev_27239.reject	2023-08-10 20:53:03.133709092 +0200
      @@ -9,10 +9,8 @@
       CREATE TABLE tbl_a (a INT) ENGINE=SPIDER;
       FLUSH TABLE tbl_a WITH READ LOCK;
       Warnings:
      -Error	1429	Unable to connect to foreign data source: localhost
      -Error	1429	Unable to connect to foreign data source: localhost
      -Error	1429	Unable to connect to foreign data source: localhost
      -Error	1429	Unable to connect to foreign data source: localhost
      +Error	1044	Access denied for user ''@'localhost' to database 'auto_test_local'
      +Error	1044	Access denied for user ''@'localhost' to database 'auto_test_local'
       BEGIN;
       DROP DATABASE auto_test_local;
       for master_1
       
      mysqltest: Result length mismatch
       
       - skipping '/var/tmp/mtr/6/log/spider/bugfix.mdev_27239/'
       
      Test spider/bugfix.mdev_27239 has failed 2 times, no more retries!
       
      spider/bugfix.mdev_29008                 w3 [ pass ]    295
      worker[6] > Restart  - using different config file
      worker[3] > Restart [mysqld.1.1 - pid: 20445, winpid: 20445] - using different config file
      worker[3] > Restart [mysqld.2.1 - pid: 20488, winpid: 20488] - using different config file
      spider/bugfix.mdev_29011                 w7 [ pass ]    283
      worker[7] > Restart [mysqld.1.1 - pid: 20496, winpid: 20496] - using different config file
      worker[7] > Restart [mysqld.2.1 - pid: 20502, winpid: 20502] - using different config file
      spider/bugfix.mdev_27240                 w2 [ retry-fail ]
              Test ended at 2023-08-10 20:53:03
       
      CURRENT_TEST: spider/bugfix.mdev_27240
      mysqltest: At line 18: query 'LOCK TABLE tbl_a READ' failed with wrong errno ER_SPECIFIC_ACCESS_DENIED_ERROR (1227): 'Access denied; you need (at least one of) the SUPER privilege(s) for this operation', instead of ER_CONNECT_TO_FOREIGN_DATA_SOURCE (1429)...
       
      The result from queries just before the failure was:
      for master_1
      for child2
      for child3
      CREATE DATABASE auto_test_local;
      USE auto_test_local;
      CREATE TABLE tbl_a (a INT KEY) ENGINE=SPIDER;
      SELECT a.z FROM tbl_a AS a,tbl_a b WHERE a.z=b.z;
      ERROR 42S22: Unknown column 'a.z' in 'field list'
      ALTER TABLE tbl_a CHANGE c c INT;
      ERROR 42S22: Unknown column 'c' in 'tbl_a'
      LOCK TABLE tbl_a READ;
       
      Warnings from just before the error:
      Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation 
      Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation 
      Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation 
      Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation
       
       - skipping '/var/tmp/mtr/2/log/spider/bugfix.mdev_27240/'
       
      Test spider/bugfix.mdev_27240 has failed 2 times, no more retries!
       
      worker[2] > Restart  - using different config file
      ***Warnings generated in error logs during shutdown after running tests: spider/bugfix.mdev_27240
       
      2023-08-10 20:53:03 6 [Warning] WSREP: handlerton rollback failed, thd 6 646 conf 0 SQL LOCK TABLE tbl_a READ
       
      spider/bugfix.mdev_29484                 w1 [ fail ]
              Test ended at 2023-08-10 20:53:04
       
      CURRENT_TEST: spider/bugfix.mdev_29484
      mysqltest: At line 32: query 'LOCK TABLES tbl_b READ, tbl_a READ' failed with wrong errno ER_SPECIFIC_ACCESS_DENIED_ERROR (1227): 'Access denied; you need (at least one of) the SUPER privilege(s) for this operation', instead of ER_CONNECT_TO_FOREIGN_DATA_SOURCE (1429)...
       
      The result from queries just before the failure was:
      < snip >
      child2_2
      child2_3
      for child3
      connection child2_1;
      CREATE DATABASE auto_test_remote;
      USE auto_test_remote;
      CREATE TABLE tbl_a (
      a INT
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
      connection master_1;
      CREATE DATABASE auto_test_local;
      USE auto_test_local;
      CREATE TABLE tbl_a (
      a INT
      ) ENGINE=Spider DEFAULT CHARSET=utf8 COMMENT='table "tbl_a", srv "s_2_1"';
      CREATE TABLE tbl_b (
      a INT
      ) ENGINE=Spider DEFAULT CHARSET=utf8;
      LOCK TABLES tbl_a WRITE;
      LOCK TABLES tbl_b READ, tbl_a READ;
       
      More results from queries before failure can be found in /var/tmp/mtr/1/log/mdev_29484.log
       
      Warnings from just before the error:
      Error 1044 Access denied for user ''@'localhost' to database 'auto_test_local' 
      Error 1044 Access denied for user ''@'localhost' to database 'auto_test_local' 
      Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation 
      Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation 
      Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation 
      Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation
       
       - skipping '/var/tmp/mtr/1/log/spider/bugfix.mdev_29484/'
       
      Retrying test spider/bugfix.mdev_29484, attempt(2/3)...
       
      worker[1] > Restart  - not started
      worker[1] > Restart  - not started
      ***Warnings generated in error logs during shutdown after running tests: spider/bugfix.mdev_29484
       
      2023-08-10 20:53:04 6 [Warning] WSREP: handlerton rollback failed, thd 6 584 conf 0 SQL LOCK TABLES tbl_b READ, tbl_a READ
       
      spider/bugfix.mdev_29562                 w8 [ pass ]    299
      worker[8] > Restart [mysqld.1.1 - pid: 20922, winpid: 20922] - using different config file
      worker[8] > Restart [mysqld.2.1 - pid: 20938, winpid: 20938] - using different config file
      spider/bugfix.mdev_29653                 w4 [ pass ]    337
      worker[4] > Restart [mysqld.1.1 - pid: 20959, winpid: 20959] - using different config file
      worker[4] > Restart [mysqld.2.1 - pid: 21008, winpid: 21008] - using different config file
      spider/bugfix.mdev_30191                 w6 [ pass ]    290
      worker[6] > Restart [mysqld.1.1 - pid: 20992, winpid: 20992] - using different config file
      worker[6] > Restart [mysqld.2.1 - pid: 21015, winpid: 21015] - using different config file
      spider/bugfix.mdev_29644                 w5 [ pass ]    640
      worker[5] > Restart [mysqld.1.1 - pid: 21033, winpid: 21033] - using different config file
      worker[5] > Restart [mysqld.2.1 - pid: 21065, winpid: 21065] - using different config file
      spider/bugfix.quick_mode_2               w2 [ pass ]    706
      worker[2] > Restart [mysqld.1.1 - pid: 21014, winpid: 21014] - using different config file
      worker[2] > Restart [mysqld.2.1 - pid: 21023, winpid: 21023] - using different config file
      worker[2] > Restart [mysqld.2.2 - pid: 21037, winpid: 21037] - using different config file
      spider/bugfix.quick_mode_0               w3 [ pass ]    658
      worker[3] > Restart [mysqld.1.1 - pid: 21082, winpid: 21082] - using different config file
      worker[3] > Restart [mysqld.2.1 - pid: 21099, winpid: 21099] - using different config file
      worker[3] > Restart [mysqld.2.2 - pid: 21110, winpid: 21110] - using different config file
      spider/bugfix.mdev_29484                 w1 [ retry-fail ]
              Test ended at 2023-08-10 20:53:14
       
      CURRENT_TEST: spider/bugfix.mdev_29484
      mysqltest: At line 32: query 'LOCK TABLES tbl_b READ, tbl_a READ' failed with wrong errno ER_SPECIFIC_ACCESS_DENIED_ERROR (1227): 'Access denied; you need (at least one of) the SUPER privilege(s) for this operation', instead of ER_CONNECT_TO_FOREIGN_DATA_SOURCE (1429)...
       
      The result from queries just before the failure was:
      < snip >
      child2_2
      child2_3
      for child3
      connection child2_1;
      CREATE DATABASE auto_test_remote;
      USE auto_test_remote;
      CREATE TABLE tbl_a (
      a INT
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
      connection master_1;
      CREATE DATABASE auto_test_local;
      USE auto_test_local;
      CREATE TABLE tbl_a (
      a INT
      ) ENGINE=Spider DEFAULT CHARSET=utf8 COMMENT='table "tbl_a", srv "s_2_1"';
      CREATE TABLE tbl_b (
      a INT
      ) ENGINE=Spider DEFAULT CHARSET=utf8;
      LOCK TABLES tbl_a WRITE;
      LOCK TABLES tbl_b READ, tbl_a READ;
       
      More results from queries before failure can be found in /var/tmp/mtr/1/log/mdev_29484.log
       
      Warnings from just before the error:
      Error 1044 Access denied for user ''@'localhost' to database 'auto_test_local' 
      Error 1044 Access denied for user ''@'localhost' to database 'auto_test_local' 
      Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation 
      Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation 
      Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation 
      Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation
       
       - skipping '/var/tmp/mtr/1/log/spider/bugfix.mdev_29484/'
       
      Test spider/bugfix.mdev_29484 has failed 2 times, no more retries!
       
      spider/bugfix.quick_mode_1               w7 [ pass ]    716
      worker[1] > Restart  - using different config file
      worker[1] > Restart  - using different config file
      worker[7] > Restart [mysqld.1.1 - pid: 21088, winpid: 21088] - using different config file
      worker[7] > Restart [mysqld.2.1 - pid: 21095, winpid: 21095] - using different config file
      worker[7] > Restart [mysqld.2.2 - pid: 21104, winpid: 21104] - using different config file
      ***Warnings generated in error logs during shutdown after running tests: spider/bugfix.mdev_29484
       
      2023-08-10 20:53:13 6 [Warning] WSREP: handlerton rollback failed, thd 6 729 conf 0 SQL LOCK TABLES tbl_b READ, tbl_a READ
      

      Attachments

        Issue Links

          Activity

            People

              ycp Yuchen Pei
              tturenko Timofey Turenko
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.