Details

    • Type: Technical task
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: 10.2
    • Fix Version/s: N/A
    • Component/s: Tests
    • Labels:
      None

      Description

      Tests that fail now in bb-10.2-alice branch from innodb suite:
      create-index-debug.test, innodb-multiple-tablespaces.test, partition.test, alter_table_stage_progress.test, blob-crash.test, create_table.test, flush-hang.test, help_verbose.test, index-online-norebuild.test, innodb-lock-inherit-read_commited.test, innodb-status-output.test, innodb-truncate-debug.test, innodb_wl6470_debug.test, partition-upgrade.test, alter_foreign_crash.test, alter_kill.test, attachable_trx.test, blob_page_reserve.test, deadlock_detect.test, default_row_format_16k.test, file_format_defaults.test, high_prio_trx_1.test, high_prio_trx_2.test, high_prio_trx_3.test, high_prio_trx_4.test, high_prio_trx_5.test, high_prio_trx_6.test, high_prio_trx_7.test, high_prio_trx_commit_crash.test, high_prio_trx_debug.test, high_prio_trx_fk.test, high_prio_trx_rpl.test, import_update_stats.test, innodb-2byte-collation.test, innodb-alter-tempfile.test, innodb-autoinc.test, innodb-import-partition-rpl.test, innodb-import-partition.test, innodb-index-online-fk.test, innodb-index.test, innodb-wl5980-discard.test, innodb-wl5980-linux.test, innodb-wl6045-1.test, innodb-wl6045-linux.test, innodb-wl6445-1.test, innodb-wl6445-2.test, innodb_buffer_pool_load.test, innodb_bug-13628249.test, innodb_bug14147491.test, innodb_bug56143.test, innodb_bug70867.test, innodb_deadlock_with_autoinc.test, innodb_file_limit_check.test, innodb_i_s_innodb_locks.test, innodb_misc1.test, innodb_page_size_func.test, innodb_rename_index.test, innodb_rename_index_err.test, innodb_replace.test, innodb_stats_sample_pages.test, innodb_wl6469_1.test, innodb_wl6560_debug.test, innodb_wl6915_debug.test, log_file_size_checkpoint.test, log_file_size_1.test, monitor_restart.test, mysqldump_max_recordsize.test, optimizer_temporary_table.test, readonly.test, records_in_range.test, stored_fk.test, strict_checksum.test, sys_tablestats.test, undo.test, update-cascade.test, update_time.test
      I disabled them for now, to fix one by one.

      innodb_file_limit_check MDEV-14325
      alter_foreign_crash [ fail ] test hangs

      CURRENT_TEST: innodb.alter_foreign_crash
      --- /home/alice/aliska/10.2/mysql-test/suite/innodb/r/alter_foreign_crash.result        2017-11-07 15:35:20.098291082 +0100
      +++ /home/alice/aliska/10.2/mysql-test/suite/innodb/r/alter_foreign_crash.reject        2017-11-08 00:41:05.673259913 +0100
      @@ -14,12 +14,16 @@
       ALTER TABLE child ROW_FORMAT=DYNAMIC, ALGORITHM=COPY;
       connection default;
       SET DEBUG_SYNC='now WAIT_FOR s1';
      +Warnings:
      +Warning        1639    debug sync point wait timed out
       SET DEBUG_SYNC='now SIGNAL s2 WAIT_FOR s1';
      +Warnings:
      +Warning        1639    debug sync point wait timed out
      +disconnect con1;
       show tables;
       Tables_in_bug
      +child
       parent
       alter table parent row_format=dynamic;
      -Warnings:
      -Warning        1088    InnoDB: Could not add foreign key constraints.
       drop table parent;
       drop database bug;
      mysqltest: Result length mismatch
      

      alter_kill [ fail ]

      CURRENT_TEST: innodb.alter_kill
      mysqltest: At line 57: query 'SELECT COUNT(*) FROM bug16720368' failed: 1932: Table 'test.bug16720368' doesn't exist in engine
       
      The result from queries just before the failure was:
      #
      # Bug#16720368 INNODB CRASHES ON BROKEN #SQL*.IBD FILE AT STARTUP
      #
      SET GLOBAL innodb_file_per_table=1;
      CREATE TABLE bug16720368_1 (a INT PRIMARY KEY) ENGINE=InnoDB;
      connect  con1,localhost,root;
      CREATE TABLE bug16720368 (a INT PRIMARY KEY, b INT) ENGINE=InnoDB;
      INSERT INTO bug16720368 (a) VALUES (1),(2),(3),(4),(5),(6),(7),(8);
      connection default;
      # Cleanly shutdown mysqld
      disconnect con1;
      # Corrupt FIL_PAGE_OFFSET in bug16720368.ibd,
      # and update the checksum to the "don't care" value.
      # Restart mysqld
      # This will succeed after a clean shutdown, due to
      # fil_open_single_table_tablespace(check_space_id=FALSE).
      SELECT COUNT(*) FROM bug16720368;
      

      • alter_table_stage_progress [ fail ] disabled for now, fix
      • attachable_trx [ fail ]

        CURRENT_TEST: innodb.attachable_trx
        mysqltest: At line 46: query 'SELECT * FROM t1' failed: 1205: Lock wait timeout exceeded; try restarting transaction
         
        The result from queries just before the failure was:
        < snip >
         
        # Start transaction.
        SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
        START TRANSACTION;
        # Insert a new row into t1.
        INSERT INTO t1(b) VALUES ('ddd');
        SELECT * FROM t1;
        a	b
        1	aaa
        2	bbb
        3	ccc
        4	ddd
         
        # [another connection]
        connect  con1,localhost,root,,;
         
        SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
        START TRANSACTION;
        SET @@global.debug_dbug = '+d,use_attachable_trx';
        SELECT * FROM t1;
         

      • blob-crash [ fail ] disabled / no --innodb-force-recovery-crash option in Mariadb
      • blob_page_reserve [ fail ] resluts mismatch mdev 13626

        CURRENT_TEST: innodb.blob_page_reserve
        --- /home/alice/aliska/10.2/mysql-test/suite/innodb/r/blob_page_reserve.result	2017-06-22 16:13:19.000000000 +0200
        +++ /home/alice/aliska/10.2/mysql-test/suite/innodb/r/blob_page_reserve.reject	2017-11-08 13:38:02.392439356 +0100
        @@ -6,7 +6,7 @@
         select name, clust_index_size from information_schema.innodb_sys_tablestats
         where name = 'test/t1';
         name	clust_index_size
        -test/t1	0
        +test/t1	1
         # If the page size is 16K, an uncompressed blob page can hold
         # data of 16330 bytes.  Insert 64 pages of data (64 * 16330 =
         # 1045120 bytes) so that 1 extent will be reserved and used.
        @@ -22,14 +22,14 @@
         select name, clust_index_size from information_schema.innodb_sys_tablestats
         where name = 'test/t1';
         name	clust_index_size
        -test/t1	289
        +test/t1	1
         # This will reserve 1 extent.
         insert into t1 values (3, repeat('%', 1045119), repeat('~', 1045119));
         set global innodb_buf_flush_list_now = 1;
         select name, clust_index_size from information_schema.innodb_sys_tablestats
         where name = 'test/t1';
         name	clust_index_size
        -test/t1	289
        +test/t1	1
         drop table t1;
         set global innodb_compression_level=0;
         create table t2 (f1 int primary key, f2 longblob, f3 longblob) engine=innodb
        @@ -37,7 +37,7 @@
         select name, clust_index_size from information_schema.innodb_sys_tablestats
         where name = 'test/t2';
         name	clust_index_size
        -test/t2	0
        +test/t2	1
         # For KBS=1, the payload is 986 bytes.  The extent will contain
         # 1048576/1024 = 1024 pages. So total bytes is 1024 * 986 = 1009664.
         # This will reserve 1 extent.
        @@ -53,14 +53,14 @@
         select name, clust_index_size from information_schema.innodb_sys_tablestats
         where name = 'test/t2';
         name	clust_index_size
        -test/t2	4129
        +test/t2	1
         # This will reserve 1 extent.
         insert into t2 values (3, repeat('%', 1009663), repeat('~', 1009663));
         set global innodb_buf_flush_list_now = 1;
         select name, clust_index_size from information_schema.innodb_sys_tablestats
         where name = 'test/t2';
         name	clust_index_size
        -test/t2	4129
        +test/t2	1
         drop table t2;
         set global innodb_compression_level=3;
         create table t3 (f1 int primary key, f2 longblob, f3 longblob) engine=innodb
        @@ -68,7 +68,7 @@
         select name, clust_index_size from information_schema.innodb_sys_tablestats
         where name = 'test/t3';
         name	clust_index_size
        -test/t3	0
        +test/t3	1
         # For KBS=1, the payload is 986 bytes.  The extent will contain
         # 1048576/1024 = 1024 pages. So total bytes is 4 * 1024 * 986 = 4038656.
         # This will reserve <= 4 extent.
        @@ -84,13 +84,13 @@
         select name, clust_index_size from information_schema.innodb_sys_tablestats
         where name = 'test/t3';
         name	clust_index_size
        -test/t3	97
        +test/t3	1
         # This will reserve <= 4 extent
         insert into t3 values (3, repeat('%', 4038657), repeat('~', 4038657));
         set global innodb_buf_flush_list_now = 1;
         select name, clust_index_size from information_schema.innodb_sys_tablestats
         where name = 'test/t3';
         name	clust_index_size
        -test/t3	97
        +test/t3	1
         drop table t3;
         set global innodb_compression_level=default;
         
        mysqltest: Result length mismatch
         

      • create_table [ fail ] disabled for now, fix
      • deadlock_detect [ fail ] 1205: Lock wait timeout exceeded; try restarting transaction

         
        CURRENT_TEST: innodb.deadlock_detect  
        mysqltest: At line 43: query 'reap;' failed: 1205: Lock wait timeout exceeded; try restarting transaction
         
        The result from queries just before the failure was:
        < snip >
        id	INT,
        PRIMARY KEY(id)
        ) ENGINE=InnoDB;
        INSERT INTO t1 VALUES(1), (2), (3);
        BEGIN;
        SELECT * FROM t1 WHERE id = 1 FOR UPDATE;
        id
        1
        connect  con1,localhost,root,,;
        BEGIN;
        SELECT * FROM t1 WHERE id = 2 FOR UPDATE;
        id
        2
        SELECT * FROM t1 WHERE id = 1 FOR UPDATE;
        connection default;
        SELECT * FROM t1 WHERE id = 2 FOR UPDATE;
        connection con1;
        ERROR HY000: Lock wait timeout exceeded; try restarting transaction
        ROLLBACK;
        connection default;
         
        More results from queries before failure can be found in /home/alice/aliska/10.2/mysql-test/var/log/deadlock_detect.log
        

      • flush-hang [ fail ] fix, no GLOBAL INNODB_PURGE_STOP_NOW variable
      • help_verbose [ fail ] fix
      • high_prio_trx_1 [ fail ] 1205: Lock wait timeout exceeded; try restarting transaction

         
        CURRENT_TEST: innodb.high_prio_trx_1
        mysqltest: At line 26: query 'UPDATE t1 SET c1=2 WHERE c1=0' failed: 1205: Lock wait timeout exceeded; try restarting transaction
         
        The result from queries just before the failure was:
        < snip >
        connect con1,localhost,root,,test;
        connect con2,localhost,root,,test;
         
        # On connection 1
        connection con1;
        START TRANSACTION;
        UPDATE t1 SET c1=1 WHERE c1=0;
         
        # On connection 2
        connection con2;
        include/start_transaction_high_prio.inc
        START TRANSACTION /* HIGH PRIORITY */;
        UPDATE t1 SET c1=2 WHERE c1=0;
         
        More results from queries before failure can be found in /home/alice/aliska/10.2/mysql-test/var/4/log/high_prio_trx_1.log
         
         - skipping '/home/alice/aliska/10.2/mysql-test/var/4/log/innodb.high_prio_trx_1-innodb/'
         

      • high_prio_trx_2 [ fail ] the same high_prio_trx_1
      • high_prio_trx_3 [ fail ] the same high_prio_trx_1
      • high_prio_trx_4 [ fail ] the same high_prio_trx_1
      • high_prio_trx_5 [ fail ]
        CURRENT_TEST: innodb.high_prio_trx_5

        mysqltest: At line 59: query 'reap' failed: 1205: Lock wait timeout exceeded; try restarting transaction
         
        The result from queries just before the failure was:
        < snip >
        START TRANSACTION;
        UPDATE t1 SET c1=2 WHERE c1=0 AND c2=0;
         
        # On connection 3
        connection con3;
        include/start_transaction_high_prio.inc
        START TRANSACTION /* HIGH PRIORITY */;
        SET @con2_id = <con2_id>;
        SET DEBUG_SYNC='rec_lock_add_to_waitq SIGNAL signal1 WAIT_FOR waiting1';
        UPDATE t1 SET c1=3 WHERE c1=0;;
         
        # On connection 1
        connection con1;
        SET DEBUG_SYNC='now WAIT_FOR signal1';
        SET DEBUG_SYNC='now SIGNAL waiting1';
        COMMIT;
        disconnect con1;
         
        # On connection 3
        connection con3;
         

        high_prio_trx_6 ---debug -internal check
        high_prio_trx_7 [ fail ] the same high_prio_trx_1

         
        innodb.high_prio_trx_7 'innodb'          w4 [ fail ]
                Test ended at 2017-11-08 00:48:22
         
        CURRENT_TEST: innodb.high_prio_trx_7
        mysqltest: At line 351: query 'UPDATE t1 SET c1=10 WHERE c1=0' failed: 1205: Lock wait timeout exceeded; try restarting transaction
         
        The result from queries just before the failure was:
        < snip >
        4
        50
        DROP TABLES t1;
        disconnect con1;
        disconnect con2;
        disconnect con3;
        disconnect con4;
        disconnect con5;
        # Scenario:6
        # Mark XA transaction as high prio.
        CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
        INSERT INTO t1 VALUES (0),(1);
        connect con1,localhost,root,,test;
        connect con2,localhost,root,,test;
        connection con2;
        START TRANSACTION;
        UPDATE t1 SET c1=11 WHERE c1=0;
        connection con1;
        XA START 'xa_high_prio' /* HIGH PRIORITY */ ;
        UPDATE t1 SET c1=10 WHERE c1=0;
         
        More results from queries before failure can be found in /home/alice/aliska/10.2/mysql-test/var/4/log/high_prio_trx_7.log
        

      • high_prio_trx_commit_crash [ fail ] 1205: Lock wait timeout exceeded; try restarting transaction
      • high_prio_trx_debug [ fail ] the same high_prio_trx_1
      • high_prio_trx_fk [ fail ] the same high_prio_trx_1
      • high_prio_trx_rpl 'innodb,mix' [ fail ] the same high_prio_trx_1
      • import_update_stats [ fail ] failed

         
        innodb.import_update_stats 'innodb'      w4 [ fail ]
                Test ended at 2017-11-08 00:56:02
         
        CURRENT_TEST: innodb.import_update_stats
        Undefined subroutine &main::ib_backup_tablespaces called at /home/alice/aliska/10.2/mysql-test/var/4/tmpACSTUQ line 2.
        mysqltest: At line 32: command "perl" failed with error: 2  my_errno: 0  errno: 0
         
        The result from queries just before the failure was:
        < snip >
        ) ENGINE = InnoDB;
        CREATE INDEX idx1 ON t1(col_1);
        CREATE INDEX idx2 ON t1(col_2);
        SHOW INDEXES FROM t1;
        Table   Non_unique      Key_name        Seq_in_index    Column_name     Collation       Cardinality     Sub_part        Packed  NullIndex_type  Comment Index_comment
        t1      1       idx1    1       col_1   A       0       NULL    NULL    YES     BTREE           
        t1      1       idx2    1       col_2   A       0       NULL    NULL    YES     BTREE           
        INSERT INTO t1  VALUES ("col1_00001", "col2_00001"), ("col1_00002", "col2_00002");
        SHOW INDEXES FROM t1;
        Table   Non_unique      Key_name        Seq_in_index    Column_name     Collation       Cardinality     Sub_part        Packed  NullIndex_type  Comment Index_comment
        t1      1       idx1    1       col_1   A       2       NULL    NULL    YES     BTREE           
        t1      1       idx2    1       col_2   A       2       NULL    NULL    YES     BTREE           
        ANALYZE TABLE t1;
        Table   Op      Msg_type        Msg_text
        test.t1 analyze status  OK
        SHOW INDEXES FROM t1;
        Table   Non_unique      Key_name        Seq_in_index    Column_name     Collation       Cardinality     Sub_part        Packed  NullIndex_type  Comment Index_comment
        t1      1       idx1    1       col_1   A       2       NULL    NULL    YES     BTREE           
        t1      1       idx2    1       col_2   A       2       NULL    NULL    YES     BTREE           
        FLUSH TABLES t1 FOR EXPORT;
         
        More results from queries before failure can be found in /home/alice/aliska/10.2/mysql-test/var/4/log/import_update_stats.log
        

        index-online-norebuild [ fail ] disabled as no STORAGE DISK,...
        innodb-import-partition ALTER TABLE t1 DISCARD TABLESPACE' 1031: Storage engine InnoDB of the table `test`.`t1` doesn't have this option

        innodb.innodb-import-partition 'innodb'  [ fail ]
                Test ended at 2017-11-08 15:33:07
         
        CURRENT_TEST: innodb.innodb-import-partition
        mysqltest: In included file "./suite/innodb/include/innodb_import.inc": 
        included from /home/alice/aliska/10.2/mysql-test/suite/innodb/t/innodb-import-partition.test at line 11:
        At line 52: query 'ALTER TABLE t1 DISCARD TABLESPACE' failed: 1031: Storage engine InnoDB of the table `test`.`t1` doesn't have this option
         
        The result from queries just before the failure was:
        < snip >
        INSERT INTO t1 VALUES (1),(123),(331);
        SELECT c1 FROM t1;
        c1
        123
        1
        331
        FLUSH TABLES t1 FOR EXPORT;
        SELECT * FROM t1 ORDER BY c1;
        c1
        1
        123
        331
        backup: t1#P#p0
        backup: t1#P#p1
        backup: t1#P#p2
        UNLOCK TABLES;
        DROP TABLE t1;
        CREATE TABLE t1 (c1 INT) ENGINE = InnoDB
        PARTITION BY HASH(c1) PARTITIONS 3;
        ALTER TABLE t1 DISCARD TABLESPACE;
         
        More results from queries before failure can be found in /home/alice/aliska/10.2/mysql-test/var/log/innodb-import-partition.log
        

      • innodb-import-partition-rpl 'innodb,mix' [ fail ] same as innodb-import-partition

         
        innodb.innodb-import-partition-rpl 'innodb,mix' w2 [ fail ]
                Test ended at 2017-11-08 01:06:13
         
        CURRENT_TEST: innodb.innodb-import-partition-rpl
        mysqltest: At line 53: query 'ALTER TABLE t1 DISCARD TABLESPACE' failed: 1031: Storage engine InnoDB of the table `test`.`t1` doesn't have this option
         
        The result from queries just before the failure was:
        < snip >
        backup: t2#P#p0
        backup: t2#P#p1
        # On slave
        connection slave;
        # check table created on slave
        SELECT * FROM t1;
        i
        111
        321
        1
        SELECT * FROM t2;
        i
        0
        1
        2
        # On master
        # DISCARD TABLESPACE on master.It will be also discarded from slave.
        connection master;
        UNLOCK TABLES;
        ALTER TABLE t1 DISCARD TABLESPACE;
        

        innodb-index [ fail ]

         
         CURRENT_TEST: innodb.innodb-index
        --- /home/alice/aliska/10.2/mysql-test/suite/innodb/r/innodb-index.result	2017-10-27 11:03:38.208532000 +0200
        +++ /home/alice/aliska/10.2/mysql-test/suite/innodb/r/innodb-index.reject	2017-11-08 15:35:16.024683105 +0100
        @@ -1370,6 +1370,7 @@
         SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE
         subsystem = 'ddl' and count_reset > 0;
         name	count_reset
        +ddl_sort_file_alter_table	2
         SET GLOBAL innodb_monitor_reset = module_ddl;
         # No sort files used for dropping secondary index
         alter table t1 drop primary key, add primary key(f1,f5),drop index i;
        @@ -1416,6 +1417,7 @@
         SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE
         subsystem = 'ddl' and count_reset > 0;
         name	count_reset
        +ddl_sort_file_alter_table	2
         SET GLOBAL innodb_monitor_reset = module_ddl;
         # Must sort
         # Change PK(f1,f3) to (existing_column,f1)
        @@ -1437,6 +1439,7 @@
         SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE
         subsystem = 'ddl' and count_reset > 0;
         name	count_reset
        +ddl_sort_file_alter_table	2
         SET GLOBAL innodb_monitor_reset = module_ddl;
         # Skip sort for PK.
         # Change PK(f5n,f6n,f4,f1) to
        @@ -1449,6 +1452,7 @@
         SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE
         subsystem = 'ddl' and count_reset > 0;
         name	count_reset
        +ddl_sort_file_alter_table	2
         SET GLOBAL innodb_monitor_reset = module_ddl;
         SET GLOBAL innodb_monitor_disable = module_ddl;
         select count(*) from t1;
        @@ -1462,7 +1466,7 @@
         # WHEN SKIPPING SORT FOR CLUSTER INDEX
         SELECT @@innodb_sort_buffer_size;
         @@innodb_sort_buffer_size
        -1048576
        +65536
         create table t1(f1 int auto_increment not null,
         f2 char(200) not null, f3 char(200) not null,
         f4 char(200) not null,primary key(f1,f2,f3,f4));
         
        mysqltest: Result length mismatch
        

        innodb-index-online-fk [ fail ] l.494 MDEV-14335
        innodb-lock-inherit-read_commited [ fail ] no GLOBAL INNODB_PURGE_STOP_NOW variable, fix
        innodb-multiple-tablespaces [ fail ] tablespaces
        innodb-status-output [ fail ] fix

         
        CURRENT_TEST: innodb.innodb-status-output
        /home/alice/aliska/10.2/client/mysqltest: Error on delete of '/home/alice/aliska/10.2/mysql-test/var/4/tmp/innodb-status-output.err' (Errcode: 2 "No such file or directory")
        

        innodb-system-table-view '16k,innodb' [ fail ] ---fix

      innodb-truncate-debug [ fail ] no GLOBAL INNODB_PURGE_STOP_NOW variable, fix
      innodb-wl5980-discard [ fail ] fix, ///failing assertion: old_path in row0merge.cc line 4190
      innodb-wl6045-1 [ fail ]

       
       CURRENT_TEST: innodb.innodb-wl6045-1
      mysqltest: In included file "./include/wait_until_disconnected.inc": 
      included from /home/alice/aliska/10.2/mysql-test/suite/innodb/t/innodb-wl6045-1.test at line 86:
      At line 21: Server failed to dissapear
       
      The result from queries just before the failure was:
      < snip >
      call mtr.add_suppression("\\[ERROR\\] InnoDB: Database page corruption on disk or a failed");
      SET GLOBAL innodb_file_per_table=on;
      [1]: Test is to corrupt the ibd file, & do repair for (innodb|crc32|none) checksum through innochecksum tool
      # Create and populate the table to be corrupted
      CREATE TABLE t1 (a INT AUTO_INCREMENT PRIMARY KEY, b TEXT) ROW_FORMAT=COMPACT ENGINE=InnoDB;
      INSERT INTO t1 (b) VALUES ('corrupt me');
      INSERT INTO t1 (b) VALUES ('corrupt me');
      # Shutdown the server
      # Corrupt the t1 table
      Munged a string.
      Munged a string.
      # Backup the corrupted t1.ibd for reuse for further testing.
      # Write file to make mysql-test-run.pl start up the server again
      # Write file to make mysql-test-run.pl expect the "crash", but don't
      # start it until it's told to
      # The below SELECT query will crash the server because some pages
      # on the disk are corrupted
      SELECT * FROM t1;
      Got one of the listed errors
       

      innodb-wl6045-linux [ fail ] fix COMPRESSION=...
      innodb-wl6445-1 [ fail ] ? bug

      CURRENT_TEST: innodb.innodb-wl6445-1
      mysqltest: At line 404: query 'INSERT INTO testdb_wl6445.t4 VALUES (1),(2),(3),(4),(5),(6)' succeeded - should have failed with errno 1036...
       
      The result from queries just before the failure was:
      < snip >
      1	aaaaaaaaaaaaaaaaaaaa
      2	bbbbbbbbbbbbbbbbbbbb
      3	cccccccccccccccccccc
      SELECT t2_i,LEFT(t2_j,20) FROM t2 ORDER BY t2_i;
      t2_i	LEFT(t2_j,20)
      1	aaaaaaaaaaaaaaaaaaaa
      2	bbbbbbbbbbbbbbbbbbbb
      3	cccccccccccccccccccc
      CALL proc1(@a);
      SELECT @a;
      @a
      3
      CALL proc2(2,'test2');
      ERROR HY000: Table 't3' is read only
      SELECT * FROM t3;
      i	j
      1	test1
      CREATE TEMPORARY TABLE temp_1 ( i INT ) ENGINE = Innodb;
      ERROR HY000: Can't create table `testdb_wl6445`.`temp_1` (errno: 165 "Table is read only")
      INSERT INTO testdb_wl6445.t4 VALUES (1),(2),(3),(4),(5),(6);
       

      innodb-wl6445-2 [ fail ] hangs
      innodb_bug-13628249 [ fail ] has warning

       
      innodb.innodb_bug-13628249 'innodb'      [ fail ]  Found warnings/errors in server log file!
              Test ended at 2017-11-09 14:04:54
      line
      2017-11-09 14:04:51 140687830927104 [Warning] InnoDB: Allocated tablespace ID 4 for test/t1, old maximum was 0
      ^ Found warnings in /home/alice/aliska/10.2/mysql-test/var/log/mysqld.1.err
      ok
      

      innodb_bug14147491 [ fail ] fix

       
      innodb.innodb_bug14147491 'innodb'       [ fail ]
              Test ended at 2017-11-09 14:37:09
       
      CURRENT_TEST: innodb.innodb_bug14147491
      /home/alice/aliska/10.2/client/mysqltest: Error on rename of '/home/alice/aliska/10.2/mysql-test/var/mysqld.1/data//test/t1.ibd.backup' to '/home/alice/aliska/10.2/mysql-test/var/mysqld.1/data//test/t1.ibd' (Errcode: 2 "No such file or directory")
      mysqltest: At line 97: command "move_file" failed with error: 1  my_errno: 2  errno: 2
       
      The result from queries just before the failure was:
      < snip >
      INSERT INTO t1 (b) VALUES ('corrupt me');
      INSERT INTO t1 (b) VALUES ('corrupt me');
      # Corrupt the table
      Munged a string.
      Munged a string.
      # Now t1 is corrupted but we should not crash
      SELECT * FROM t1;
      Got one of the listed errors
      INSERT INTO t1(b) VALUES('abcdef');
      Got one of the listed errors
      UPDATE t1 set b = 'deadbeef' where a = 1;
      Got one of the listed errors
      set debug_dbug = '+d,innodb_page_corruption_retries';
      # Write file to make mysql-test-run.pl expect the "crash", but don't
      # start it until it's told to
      # The below SELECT query will crash the server because some pages
      # on the disk are corrupted
      SELECT * FROM t1;
      ERROR 42S02: Table 'test.t1' doesn't exist in engine
      # Restore the original t1.ibd
      

      innodb_bug56143 [ fail ]

       
      CURRENT_TEST: innodb.innodb_bug56143
      mysqltest: In included file "./suite/innodb/include/check_pfs_mem_other_is_zero.inc": 
      included from /home/alice/aliska/10.2/mysql-test/suite/innodb/t/innodb_bug56143.test at line 590:
      At line 12: query 'SELECT count_alloc FROM performance_schema.memory_summary_global_by_event_name
      WHERE event_name = 'memory/innodb/other'' failed: 1146: Table 'performance_schema.memory_summary_global_by_event_name' doesn't exist
      

      innodb_bug70867 [ fail ] failed

      innodb.innodb_bug70867 'innodb'          w2 [ fail ]  timeout after 900 seconds
              Test ended at 2017-11-08 00:46:35
       
      Test case timeout after 900 seconds
       
      == /home/alice/aliska/10.2/mysql-test/var/2/log/innodb_bug70867.log == 
       
       == /home/alice/aliska/10.2/mysql-test/var/2/tmp/analyze-timeout-mysqld.1.err ==
      mysqltest: Could not open connection 'default': 2013 Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 104
       

      innodb_i_s_innodb_locks [ fail ] /result mismatch//

      CURRENT_TEST: innodb.innodb_i_s_innodb_locks
      Binary files /home/alice/aliska/10.2/mysql-test/suite/innodb/r/innodb_i_s_innodb_locks.result and /home/alice/aliska/10.2/mysql-test/suite/innodb/r/innodb_i_s_innodb_locks.reject differ
       
      The two files differ but it was not possible to execute 'diff' in
      order to show only the difference. Instead the whole content of the
      two files was shown for you to diff manually.
       
      To get a better report you should install 'diff' on your system, which you
      for example can get from http://www.gnu.org/software/diffutils/diffutils.html
       
       --- /home/alice/aliska/10.2/mysql-test/suite/innodb/r/innodb_i_s_innodb_locks.result >>>
      SET GLOBAL innodb_lock_wait_timeout=600;
      DROP TABLE IF EXISTS t_min, t_max;
      CREATE TABLE t_min (
      c01 TINYINT,
      c02 TINYINT UNSIGNED,
      c03 SMALLINT,
      c04 SMALLINT UNSIGNED,
      c05 MEDIUMINT,
      c06 MEDIUMINT UNSIGNED,
      c07 INT,
      c08 INT UNSIGNED,
      c09 BIGINT,
      c10 BIGINT UNSIGNED,
      PRIMARY KEY(c01, c02, c03, c04, c05, c06, c07, c08, c09, c10)
      ) ENGINE=INNODB;;
      INSERT INTO t_min VALUES
      (-128, 0,
      -32768, 0,
      -8388608, 0,
      -2147483648, 0,
      -9223372036854775808, 0);
      CREATE TABLE t_max (
      c01 TINYINT,
      c02 TINYINT UNSIGNED,
      c03 SMALLINT,
      c04 SMALLINT UNSIGNED,
      c05 MEDIUMINT,
      c06 MEDIUMINT UNSIGNED,
      c07 INT,
      c08 INT UNSIGNED,
      c09 BIGINT,
      c10 BIGINT UNSIGNED,
      PRIMARY KEY(c01, c02, c03, c04, c05, c06, c07, c08, c09, c10)
      ) ENGINE=INNODB;;
      INSERT INTO t_max VALUES
      (127, 255,
      32767, 65535,
      8388607, 16777215,
      2147483647, 4294967295,
      9223372036854775807, 18446744073709551615);
      CREATE TABLE ```t'\"_str` (
      c1 VARCHAR(32),
      c2 VARCHAR(32),
      c3 VARCHAR(32),
      c4 VARCHAR(32),
      c5 VARCHAR(32),
      c6 VARCHAR(32),
      c7 VARCHAR(32),
      PRIMARY KEY(c1, c2, c3, c4, c5, c6, c7)
      ) ENGINE=INNODB;
      INSERT INTO ```t'\"_str` VALUES
      ('1', 'abc', '''abc', 'abc''', 'a''bc', 'a''bc''', '''abc''''');
      INSERT INTO ```t'\"_str` VALUES
      ('2', 'abc', '"abc', 'abc"', 'a"bc', 'a"bc"', '"abc""');
      INSERT INTO ```t'\"_str` VALUES
      ('3', 'abc', '\\abc', 'abc\\', 'a\\bc', 'a\\bc\\', '\\abc\\\\');
      INSERT INTO ```t'\"_str` VALUES
      ('4', 'abc', 0x00616263, 0x61626300, 0x61006263, 0x6100626300, 0x610062630000);
      SET autocommit=0;
      SELECT * FROM t_min FOR UPDATE;
      c01	c02	c03	c04	c05	c06	c07	c08	c09	c10
      -128	0	-32768	0	-8388608	0	-2147483648	0	-9223372036854775808	0
      SELECT * FROM t_max FOR UPDATE;
      c01	c02	c03	c04	c05	c06	c07	c08	c09	c10
      127	255	32767	65535	8388607	16777215	2147483647	4294967295	9223372036854775807	18446744073709551615
      SELECT * FROM ```t'\"_str` FOR UPDATE;
      c1	c2	c3	c4	c5	c6	c7
      1	abc	'abc	abc'	a'bc	a'bc'	'abc''
      2	abc	"abc	abc"	a"bc	a"bc"	"abc""
      3	abc	\abc	abc\	a\bc	a\bc\	\abc\\
      4	abc	<<<
       --- /home/alice/aliska/10.2/mysql-test/suite/innodb/r/innodb_i_s_innodb_locks.result >>>
      SET GLOBAL innodb_lock_wait_timeout=600;
      DROP TABLE IF EXISTS t_min, t_max;
      CREATE TABLE t_min (
      c01 TINYINT,
      c02 TINYINT UNSIGNED,
      c03 SMALLINT,
      c04 SMALLINT UNSIGNED,
      c05 MEDIUMINT,
      c06 MEDIUMINT UNSIGNED,
      c07 INT,
      c08 INT UNSIGNED,
      c09 BIGINT,
      c10 BIGINT UNSIGNED,
      PRIMARY KEY(c01, c02, c03, c04, c05, c06, c07, c08, c09, c10)
      ) ENGINE=INNODB;;
      INSERT INTO t_min VALUES
      (-128, 0,
      -32768, 0,
      -8388608, 0,
      -2147483648, 0,
      -9223372036854775808, 0);
      CREATE TABLE t_max (
      c01 TINYINT,
      c02 TINYINT UNSIGNED,
      c03 SMALLINT,
      c04 SMALLINT UNSIGNED,
      c05 MEDIUMINT,
      c06 MEDIUMINT UNSIGNED,
      c07 INT,
      c08 INT UNSIGNED,
      c09 BIGINT,
      c10 BIGINT UNSIGNED,
      PRIMARY KEY(c01, c02, c03, c04, c05, c06, c07, c08, c09, c10)
      ) ENGINE=INNODB;;
      INSERT INTO t_max VALUES
      (127, 255,
      32767, 65535,
      8388607, 16777215,
      2147483647, 4294967295,
      9223372036854775807, 18446744073709551615);
      CREATE TABLE ```t'\"_str` (
      c1 VARCHAR(32),
      c2 VARCHAR(32),
      c3 VARCHAR(32),
      c4 VARCHAR(32),
      c5 VARCHAR(32),
      c6 VARCHAR(32),
      c7 VARCHAR(32),
      PRIMARY KEY(c1, c2, c3, c4, c5, c6, c7)
      ) ENGINE=INNODB;
      INSERT INTO ```t'\"_str` VALUES
      ('1', 'abc', '''abc', 'abc''', 'a''bc', 'a''bc''', '''abc''''');
      INSERT INTO ```t'\"_str` VALUES
      ('2', 'abc', '"abc', 'abc"', 'a"bc', 'a"bc"', '"abc""');
      INSERT INTO ```t'\"_str` VALUES
      ('3', 'abc', '\\abc', 'abc\\', 'a\\bc', 'a\\bc\\', '\\abc\\\\');
      INSERT INTO ```t'\"_str` VALUES
      ('4', 'abc', 0x00616263, 0x61626300, 0x61006263, 0x6100626300, 0x610062630000);
      connect  con_lock,localhost,root,,;
      connect  con_min_trylock,localhost,root,,;
      connect  con_max_trylock,localhost,root,,;
      connect  con_str_insert_supremum,localhost,root,,;
      connect  con_str_lock_row1,localhost,root,,;
      connect  con_str_lock_row2,localhost,root,,;
      connect  con_str_lock_row3,localhost,root,,;
      connect  con_str_lock_row4,localhost,root,,;
      connect  con_verify_innodb_locks,localhost,root,,;
      connection con_lock;
      SET autocommit=0;
      SELECT * FROM t_min FOR UPDATE;
      c01	c02	c03	c04	c05	c06	c07	c08	c09	c10
      -128	0	-32768	0	-8388608	0	-2147483648	0	-9223372036854775808	0
      SELECT * FROM t_max FOR UPDATE;
      c01	c02	c03	c04	c05	c06	c07	c08	c09	c10
      127	255	32767	65535	8388607	16777215	2147483647	4294967295	9223372036854775807	18446744073709551615
      SELECT * FROM ```t'\"_str` FOR UPDATE;
      c1	c2	c3	c4	c5	c6	c7
      1	abc	'abc	abc'	a'bc	a'bc'	'abc''
      2	abc	"abc	abc"	a"bc	a"bc"	"abc""
      3	abc	\abc	abc\	a\bc	a\bc\	\abc\\
      4	abc	
      mysqltest: Result length mismatch
       
       

      innodb_page_size_func [ fail ] timeout after 900 seconds

       
       innodb.innodb_page_size_func 'innodb'    w2 [ fail ]  timeout after 900 seconds
              Test ended at 2017-11-08 01:02:11
       
      Test case timeout after 900 seconds
       
      == /home/alice/aliska/10.2/mysql-test/var/2/log/innodb_page_size_func.log == 
      # 0. Check and generate prerequites
      # 1. Try to restart the server with some other legal innodb page size value.
      #    It must fail because we had a different value before.
      # 1.1 The value assigned is a number.
       
       == /home/alice/aliska/10.2/mysql-test/var/2/tmp/analyze-timeout-mysqld.1.err ==
      mysqltest: Could not open connection 'default': 2013 Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 104
       
       
       - skipping '/home/alice/aliska/10.2/mysql-test/var/2/log/innodb.innodb_page_size_func-innodb/'
      ***Warnings generated in error logs during shutdown after running tests: innodb.innodb_page_size_func innodb.innodb_information_schema innodb.innodb_notembedded innodb.innodb_i_s_innodb_trx innodb.innodb_multi_update innodb.innodb_io_pf
       
      Attempting backtrace. You can use the following information to find out
      

      innodb_rename_index [ fail ] fix, ALTER TABLE t RENAME INDEX i1 TO GEN_CLUST_INDEX
      innodb_rename_index_err [ fail ] fix//
      innodb_replace [ fail ] result mismatch

       
      CURRENT_TEST: innodb.innodb_replace
      --- /home/alice/aliska/10.2/mysql-test/suite/innodb/r/innodb_replace.result	2017-11-06 15:47:28.342176721 +0100
      +++ /home/alice/aliska/10.2/mysql-test/suite/innodb/r/innodb_replace.reject	2017-11-09 14:57:27.155464879 +0100
      @@ -80,7 +80,13 @@
       SET DEBUG_SYNC='now SIGNAL select5';
       connection con1;
       Warnings:
      +Note	1265	Data truncated for column 'a' at row 1
      +Note	1265	Data truncated for column 'b' at row 1
      +Note	1265	Data truncated for column 'a' at row 2
      +Note	1265	Data truncated for column 'b' at row 2
       Warning	1062	Duplicate entry '3' for key 'PRIMARY'
      +Note	1265	Data truncated for column 'a' at row 3
      +Note	1265	Data truncated for column 'b' at row 3
       connection default;
       a	b
       3	24
      @@ -98,6 +104,13 @@
       connection con2;
       SET DEBUG_SYNC='now SIGNAL select6';
       connection con1;
      +Warnings:
      +Note	1265	Data truncated for column 'a' at row 1
      +Note	1265	Data truncated for column 'b' at row 1
      +Note	1265	Data truncated for column 'a' at row 2
      +Note	1265	Data truncated for column 'b' at row 2
      +Note	1265	Data truncated for column 'a' at row 3
      +Note	1265	Data truncated for column 'b' at row 3
       connection default;
       a	b
       1	2
       
      mysqltest: Result length mismatch
      
      

      innodb_stats_sample_pages [ fail ] results mismatch

       
      innodb.innodb_stats_sample_pages 'innodb' [ fail ]
              Test ended at 2017-11-09 12:26:46
       
      CURRENT_TEST: innodb.innodb_stats_sample_pages
      --- /home/alice/aliska/10.2/mysql-test/suite/innodb/r/innodb_stats_sample_pages.result	2017-06-22 16:13:19.000000000 +0200
      +++ /home/alice/aliska/10.2/mysql-test/suite/innodb/r/innodb_stats_sample_pages.reject	2017-11-09 12:26:45.853826443 +0100
      @@ -10,11 +10,9 @@
       SELECT stat_name, stat_value FROM mysql.innodb_index_stats
       WHERE table_name='test_ps_sample_pages_used' AND stat_name='n_leaf_pages';
       stat_name	stat_value
      -n_leaf_pages	37
       SELECT sample_size FROM mysql.innodb_index_stats
       WHERE table_name='test_ps_sample_pages_used' AND stat_name='n_diff_pfx01';
       sample_size
      -17
       ALTER TABLE test_ps_sample_pages_used STATS_SAMPLE_PAGES=14;
       ANALYZE TABLE test_ps_sample_pages_used;
       Table	Op	Msg_type	Msg_text
      @@ -22,6 +20,5 @@
       SELECT sample_size FROM mysql.innodb_index_stats
       WHERE table_name='test_ps_sample_pages_used' AND stat_name='n_diff_pfx01';
       sample_size
      -14
       DROP TABLE test_ps_sample_pages_used;
       SET GLOBAL innodb_stats_persistent_sample_pages=default;
       
      mysqltest: Result length mismatch
      

      innodb_wl6469_1 [ fail ]

       
      CURRENT_TEST: innodb.innodb_wl6469_1
      mysqltest: At line 35: query 'create procedure populate_t1(IN rows INT)
      begin
      declare i int default 1;
      while (i <= rows) DO
      insert into t1 values (i, 'a', 'b');
      set i = i + 1;
      end while;
      end' failed: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows INT)
      begin
      declare i int default 1;
      while (i <= rows) DO
      insert into t1 val' at line 1
       
      The result from queries just before the failure was:
      set global innodb_file_per_table = 0;
      DROP TABLE IF EXISTS t1,t2;
      select @@global.innodb_change_buffering;
      @@global.innodb_change_buffering
      all
      create temporary table t1
      (keyc int, c1 char(100), c2 char(100),
      primary key(keyc)) engine = innodb;
      create index idx on t1(keyc, c1(20));
      create procedure populate_t1(IN rows INT)
      begin
      declare i int default 1;
      while (i <= rows) DO
      insert into t1 values (i, 'a', 'b');
      set i = i + 1;
      end while;
      end|
      

      innodb_wl6470_debug [ fail ] no GLOBAL INNODB_PURGE_STOP_NOW variable, fix

      innodb_wl6560_debug [ fail ] fix

      CURRENT_TEST: innodb.innodb_wl6560_debug
      mysqltest: At line 61: command "$MYSQLD_CMD $crash=100" failed with wrong error: 7
       
      The result from queries just before the failure was:
      call mtr.add_suppression("\\[ERROR\\] InnoDB: table .* does not exist "
                               "in the InnoDB internal");
      set global innodb_file_per_table = off;
      "testing creation of tablepsace by enabling error path"
      # files in MYSQL_DATA_DIR
      ibtmp1
      "Temp-tablespace removed on shutdown"
      # files in MYSQL_DATA_DIR
      --innodb-force-recovery-crash=100
      "Next stmt will crash server"
       
       - skipping '/home/alice/aliska/10.2/mysql-test/var/4/log/innodb.innodb_wl6560_debug-innodb/'
      ***Warnings generated in error logs during shutdown after running tests: innodb.innodb_wl6560_debug
       
      2017-11-08  0:56:44 140042316126016 [ERROR] /home/alice/aliska/10.2/sql/mysqld: unknown variable 'innodb-force-recovery-crash=100'
      2017-11-08  0:56:44 140042316126016 [ERROR] Aborting
      
      

      innodb_wl6915_debug [ fail ]

       
      CURRENT_TEST: innodb.innodb_wl6915_debug
      mysqltest: At line 99: query 'commit' succeeded - should have failed with errno 2013...
       
      The result from queries just before the failure was:
      < snip >
      declare i int default 1;
      while (i <= 50) DO
      insert into t1 values (i, 'a', 'b');
      insert into t2 values (i, 'a', 'b');
      set i = i + 1;
      end while;
      end|
      call populate_t1_t2;
      begin;
      call populate_t1_t2();
      update t1 set a = a + 1;
      update t2 set a = a + 1;
      select count(*) from t1;
      count(*)
      100
      select count(*) from t2;
      count(*)
      100
      SET SESSION DEBUG_DBUG="+d,ib_trx_crash_during_commit";
      commit;
       

      log_file_size_checkpoint [ fail ]

      CURRENT_TEST: innodb.log_file_size_checkpoint
      mysqltest: The test didn't produce any output 

      monitor_restart [ fail ]
      innodb.monitor_restart 'innodb' [ fail ]

       
      CURRENT_TEST: innodb.monitor_restart
      --- /home/alice/aliska/10.2/mysql-test/suite/innodb/r/monitor_restart.result	2017-11-03 10:12:54.153108965 +0100
      +++ /home/alice/aliska/10.2/mysql-test/suite/innodb/r/monitor_restart.reject	2017-11-09 15:17:16.362541317 +0100
      @@ -11,4 +11,5 @@
       1	abc
       2	def
       3	ghi
      +"Unexpected count: 0"
       DROP TABLE t1;
      mysqltest: Result length mismatch
      

      optimizer_temporary_table [ fail ] fix
      partition [ fail ] disabled,
      partition-upgrade [ fail ] no UPGARDE PARTITIONING --if no use, then delete also include files//
      readonly [ fail ] fix
      records_in_range [ fail ] results mismatch, fix
      stored_fk [ fail ] fix
      innodb.stored_fk 'innodb' [ fail ]

       
      CURRENT_TEST: innodb.stored_fk
      mysqltest: At line 10: query 'create table t2(f1 int not null, f2 int as (f1) virtual,
      foreign key(f1) references t1(f1) on update cascade)engine=innodb' failed: 1005: Can't create table `test`.`t2` (errno: 150 "Foreign key constraint is incorrectly formed")
       
      The result from queries just before the failure was:
      # Create statement with FK on base column of stored column
      create table t1(f1 int, f2 int as(f1) stored,
      foreign key(f1) references t2(f1) on delete cascade)engine=innodb;
      ERROR HY000: Can't create table `test`.`t1` (errno: 150 "Foreign key constraint is incorrectly formed")
      # adding new stored column during alter table copy operation.
      create table t1(f1 int primary key);
      create table t2(f1 int not null, f2 int as (f1) virtual,
      foreign key(f1) references t1(f1) on update cascade)engine=innodb;
      

      strict_checksum [ fail ] fix
      sys_tablestats [ fail ] hang
      tablespace_per_table_windows ---fix, skipped
      trx_id_future [skipped no debug
      undo [ fail ]

      CURRENT_TEST: innodb.undo
      mysqltest: At line 19: query 'UPDATE t0 SET a=substr(a,9999),b=substr(b,9999),c=substr(c,9999),
      d=substr(d,9999),e=substr(e,9999),f=substr(f,9999)' succeeded - should have failed with errno 1713...
       
      The result from queries just before the failure was:
      Warnings:
      Note	1071	Specified key was too long; max key length is 1000 bytes
      Note	1071	Specified key was too long; max key length is 1000 bytes
      Note	1071	Specified key was too long; max key length is 1000 bytes
      Note	1071	Specified key was too long; max key length is 1000 bytes
      Note	1071	Specified key was too long; max key length is 1000 bytes
      Note	1071	Specified key was too long; max key length is 1000 bytes
      BEGIN;
      INSERT INTO t0 VALUES(
      repeat('a',10000),repeat('b',10000),repeat('c',10000),
      repeat('d',10000),repeat('e',10000),repeat('f',10000));
      UPDATE t0 SET a=substr(a,9999),b=substr(b,9999),c=substr(c,9999),
      d=substr(d,9999),e=substr(e,9999),f=substr(f,9999);
       

      update-cascade [ fail ]

       CURRENT_TEST: innodb.update-cascade
       --- /home/alice/aliska/10.2/mysql-test/suite/innodb/r/update-cascade.result	2017-11-07 15:46:56.746985988 +0100
       +++ /home/alice/aliska/10.2/mysql-test/suite/innodb/r/update-cascade.reject	2017-11-09 14:18:17.673017645 +0100
       @@ -58,7 +58,7 @@
        10	--------------------
        select f1, f2 from t2;
        f1	f2
       -1	10
       +1	2
        drop table t2, t1;
        set debug_sync = reset;
        #
       @@ -120,7 +120,7 @@
        1	28
        select f1, f2 from t2;
        f1	f2
       -1	28
       +1	91
        drop table t2, t1;
        set debug_sync = reset;
        #
       @@ -210,7 +210,7 @@
        10	%%%%%%%%%%%%%%%%%%%%
        select f1, right(f2, 20) as p2 from t3;
        f1	p2
       -10	++++++++++++++++++++
       +2	++++++++++++++++++++
        commit;
        drop table t3, t2, t1;
        set debug_sync = reset;
       @@ -306,7 +306,7 @@
        2	28
        select f1, f2 from t3;
        f1	f2
       -2	28
       +2	91
        commit;
        drop table t3, t2, t1;
        set debug_sync = reset;
       mysqltest: Result length mismatch
       

      buffer_pool_load //need to be rewritten line 179
      deadlock_with_autoinc ---deadlock ---subtask in mdev 13626
      default_row_format_16k

      CURRENT_TEST: innodb.default_row_format_16k
      mysqltest: At line 69: query 'CREATE TABLE t1(a VARCHAR(2000), PRIMARY KEY (a), KEY k1(a(2000)))' failed: 1071: Specified key was too long; max key length is 1000 bytes
       
      The result from queries just before the failure was:
      < snip >
      CREATE TABLE t1 (a VARCHAR(3070) , b TEXT,
      PRIMARY KEY(a(400)), KEY k1(a)) ENGINE=INNODB ROW_FORMAT=DYNAMIC;
      DROP TABLE t1;
      CREATE TABLE t1 (a VARCHAR(3000) , b TEXT, c INT, d TEXT,
      PRIMARY KEY(a, b(3), c), KEY k1(a, b(25))) ENGINE=INNODB ROW_FORMAT=DYNAMIC;
      DROP TABLE t1;
      CREATE TABLE t1 (a INT , b TEXT,
      PRIMARY KEY(a, b(3)), KEY k1(a)) ENGINE=INNODB ROW_FORMAT=DYNAMIC;
      DROP TABLE t1;
      CREATE TABLE t1(a CHAR(10), KEY(a(5)));
      DROP TABLE t1;
      CREATE TABLE t1(a CHAR(255), KEY(a(200)));
      DROP TABLE t1;
      CREATE TABLE t1(a CHAR(255), KEY(a));
      DROP TABLE t1;
      CREATE TABLE t1(a VARCHAR(4000), KEY(a(2000)));
      Warnings:
      Warning	1071	Specified key was too long; max key length is 1000 bytes
      DROP TABLE t1;
      CREATE TABLE t1(a VARCHAR(2000), PRIMARY KEY (a), KEY k1(a(2000)));
       
      More results from queries before failure can be found in /home/alice/aliska/10.2/mysql-test/var/log/default_row_format_16k.log
      

      file_format_defaults //fix — bug?

      innodb.file_format_defaults 'innodb'     [ fail ]
              Test ended at 2017-11-10 16:28:59
       
      CURRENT_TEST: innodb.file_format_defaults
      mysqltest: At line 21: query 'CREATE TABLE tab0 (c1 VARCHAR(65530), KEY(c1(3073))) ENGINE=InnoDB ROW_FORMAT=COMPRESSED' succeeded - should have failed with errno 1071...
       
      The result from queries just before the failure was:
      SELECT @@innodb_strict_mode;
      @@innodb_strict_mode
      1
      SELECT @@innodb_file_per_table;
      @@innodb_file_per_table
      1
      SET GLOBAL innodb_large_prefix=ON;
      Warnings:
      Warning	131	Using innodb_large_prefix is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
      CREATE TABLE tab0 (c1 VARCHAR(65530), KEY(c1(3073))) ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
      

      misc1 --fix

      CURRENT_TEST: innodb.innodb_misc1
      mysqltest: At line 874: query 'reap' failed with wrong errno 1205: 'Lock wait timeout exceeded; try restarting transaction', instead of 1746...
       
      The result from queries just before the failure was:
      < snip >
      set autocommit = 0;
      SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
      create table t10(a int not null, b int, primary key(a)) engine=innodb select * from t2 for update;
      connection b;
      ERROR HY000: Lock wait timeout exceeded; try restarting transaction
      connection c;
      ERROR HY000: Lock wait timeout exceeded; try restarting transaction
      connection d;
      ERROR HY000: Lock wait timeout exceeded; try restarting transaction
      connection e;
      ERROR HY000: Lock wait timeout exceeded; try restarting transaction
      connection f;
      ERROR HY000: Lock wait timeout exceeded; try restarting transaction
      connection g;
      ERROR HY000: Lock wait timeout exceeded; try restarting transaction
      connection h;
      ERROR HY000: Lock wait timeout exceeded; try restarting transaction
      connection i;
      ERROR HY000: Lock wait timeout exceeded; try restarting transaction
      connection j;
      More results from queries before failure can be found in /home/alice/aliska/10.2/mysql-test/var/log/innodb_misc1.log
      

      mysqldump_max_recordsize [fail] the same as innodb_buffer_pool_load. rewrite: --exec $NEW_CMD
      update_time [ fail ]

       
      CURRENT_TEST: innodb.update_time
      mysqltest: At line 74: query 'XA COMMIT 'xatrx'' failed: 1397: XAER_NOTA: Unknown XID
       
      The result from queries just before the failure was:
      < snip >
      WHERE table_name = '`test`.`t`';
      COUNT(*)
      0
      SELECT COUNT(*) FROM information_schema.tables WHERE table_name = 't'
      AND update_time IS NOT NULL;
      COUNT(*)
      1
      DROP TABLE big;
      # Test the behavior after restart with a prepared XA transaction
      XA START 'xatrx';
      INSERT INTO t VALUES (5);
      XA END 'xatrx';
      XA PREPARE 'xatrx';
      CONNECT  con1,localhost,root,,;
      connection con1;
      call mtr.add_suppression("Found 1 prepared XA transactions");
      SELECT update_time FROM information_schema.tables WHERE table_name = 't';
      update_time
      NULL
      XA COMMIT 'xatrx';
      

      innodb-wl5980-linux [ fail ] //have to be fixed
      innodb.innodb-autoinc 'innodb' [ fail ] Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed

           
      CURRENT_TEST: innodb.innodb-autoinc
      mysqltest: At line 691: query 'INSERT INTO t1 VALUES ()' failed with wrong errno 2013: 'Lost connection to MySQL server during query', instead of 1467...
       
      The result from queries just before the failure was:
      < snip >
        `c2` int(11) DEFAULT NULL,
        PRIMARY KEY (`c1`)
      ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
      REPLACE INTO t1 (c2 ) VALUES (0);
      SELECT * FROM t1;
      c1	c2
      -290783232	NULL
      1	NULL
      2	NULL
      3	0
      DROP TABLE t1;
      CREATE TABLE t1 (c1 DOUBLE NOT NULL PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB
      AUTO_INCREMENT=10000000000000000000;
      SHOW CREATE TABLE t1;
      Table	Create Table
      t1	CREATE TABLE `t1` (
        `c1` double NOT NULL AUTO_INCREMENT,
        PRIMARY KEY (`c1`)
      ) ENGINE=InnoDB AUTO_INCREMENT=10000000000000000000 DEFAULT CHARSET=latin1
      INSERT INTO t1 VALUES ();
      

      innodb.innodb-2byte-collation 'innodb' [ fail ]

      CURRENT_TEST: innodb.innodb-2byte-collation
      mysqltest: At line 22: query 'create table 2byte_collation (c1 char(1) character set ucs2 collate ucs2_vn_ci)
      engine = InnoDB' failed: 1273: Unknown collation: 'ucs2_vn_ci'
       
      The result from queries just before the failure was:
      < snip >
      cp932_japanese_nopad_ci	cp932	1119		Yes	1
      cp932_nopad_bin	cp932	1120		Yes	1
      eucjpms_japanese_nopad_ci	eucjpms	1121		Yes	1
      eucjpms_nopad_bin	eucjpms	1122		Yes	1
      utf16_unicode_nopad_ci	utf16	1125		Yes	8
      utf16_unicode_520_nopad_ci	utf16	1147		Yes	8
      ucs2_unicode_nopad_ci	ucs2	1152		Yes	8
      ucs2_unicode_520_nopad_ci	ucs2	1174		Yes	8
      utf32_unicode_nopad_ci	utf32	1184		Yes	8
      utf32_unicode_520_nopad_ci	utf32	1206		Yes	8
      utf8_unicode_nopad_ci	utf8	1216		Yes	8
      utf8_unicode_520_nopad_ci	utf8	1238		Yes	8
      utf8mb4_unicode_nopad_ci	utf8mb4	1248		Yes	8
      utf8mb4_unicode_520_nopad_ci	utf8mb4	1270		Yes	8
      show collation like '%test%';
      Collation	Charset	Id	Default	Compiled	Sortlen
      show collation like 'ucs2_vn_ci';
      Collation	Charset	Id	Default	Compiled	Sortlen
      create table 2byte_collation (c1 char(1) character set ucs2 collate ucs2_vn_ci)
      engine = InnoDB;
      

        Attachments

          Activity

            People

            Assignee:
            marko Marko Mäkelä
            Reporter:
            alice Alice Sherepa
            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.