← Back to team overview

maria-discuss team mailing list archive

10.2.9: failing innodb tests

 

that looks not good

innodb.table_flags '32k,innodb'          w1 [ fail ]
        Test ended at 2017-09-29 14:17:44

CURRENT_TEST: innodb.table_flags
/usr/bin/mysqltest: Error on delete of '/usr/share/mysql-test/var/1/tmp/table_flags/ibtmp1' (Errcode: 2 "No such file or directory") --- /usr/share/mysql-test/suite/innodb/r/table_flags,32k.result~ 2017-09-26 17:07:32.071814438 +0200 +++ /usr/share/mysql-test/suite/innodb/r/table_flags,32k.reject 2017-09-29 14:17:44.692570878 +0200
@@ -176,7 +176,6 @@
 SELECT * FROM tp;
 a
 DROP TABLE tr,tc,td,tz,tp;
-ib_buffer_pool
 ib_logfile0
 ib_logfile1
 ibdata1

mysqltest: Result length mismatch

- saving '/usr/share/mysql-test/var/1/log/innodb.table_flags-32k,innodb/' to '/usr/share/mysql-test/var/log/innodb.table_flags-32k,innodb/' ***Warnings generated in error logs during shutdown after running tests: innodb.table_flags

2017-09-29 14:17:39 139655137466688 [ERROR] InnoDB: Table `test`.`tc` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=129 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:17:39 139655137466688 [ERROR] InnoDB: Refusing to load './test/td.ibd' (id=3, flags=0x1a1); dictionary contains id=3, flags=0x101a1 2017-09-29 14:17:39 139655137466688 [ERROR] InnoDB: Operating system error number 2 in a file operation. 2017-09-29 14:17:39 139655137466688 [ERROR] InnoDB: The error means the system cannot find the path specified. 2017-09-29 14:17:39 139655137466688 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them. 2017-09-29 14:17:39 139655137466688 [Warning] InnoDB: Ignoring tablespace for `test`.`td` because it could not be opened. 2017-09-29 14:17:39 139655137466688 [ERROR] InnoDB: Table `test`.`tp` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=289 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:17:39 139655137466688 [ERROR] InnoDB: Table `test`.`tr` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=65 SYS_TABLES.MIX_LEN=4294967295 2017-09-29 14:17:39 139655137466688 [ERROR] InnoDB: Table `test`.`tz` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=12321 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:17:39 139654955267840 [ERROR] InnoDB: Table `test`.`tr` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=65 SYS_TABLES.MIX_LEN=4294967295 2017-09-29 14:17:39 139654955267840 [ERROR] InnoDB: Table `test`.`tc` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=129 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:17:39 139654955267840 [ERROR] InnoDB: Refusing to load './test/td.ibd' (id=3, flags=0x1a1); dictionary contains id=3, flags=0x101a1 2017-09-29 14:17:39 139654955267840 [ERROR] InnoDB: Operating system error number 2 in a file operation. 2017-09-29 14:17:39 139654955267840 [ERROR] InnoDB: The error means the system cannot find the path specified. 2017-09-29 14:17:39 139654955267840 [ERROR] InnoDB: Table `test`.`tz` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=12321 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:17:39 139654955267840 [ERROR] InnoDB: Table `test`.`tp` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=289 SYS_TABLES.N_COLS=2147483649

innodb.table_flags '64k,innodb'          w4 [ fail ]
        Test ended at 2017-09-29 14:17:46

CURRENT_TEST: innodb.table_flags
/usr/bin/mysqltest: Error on delete of '/usr/share/mysql-test/var/4/tmp/table_flags/ibtmp1' (Errcode: 2 "No such file or directory") --- /usr/share/mysql-test/suite/innodb/r/table_flags,64k.result~ 2017-09-26 17:07:29.435940019 +0200 +++ /usr/share/mysql-test/suite/innodb/r/table_flags,64k.reject 2017-09-29 14:17:46.209498842 +0200
@@ -176,7 +176,6 @@
 SELECT * FROM tp;
 a
 DROP TABLE tr,tc,td,tz,tp;
-ib_buffer_pool
 ib_logfile0
 ib_logfile1
 ibdata1

mysqltest: Result length mismatch

- saving '/usr/share/mysql-test/var/4/log/innodb.table_flags-64k,innodb/' to '/usr/share/mysql-test/var/log/innodb.table_flags-64k,innodb/' ***Warnings generated in error logs during shutdown after running tests: innodb.table_flags

2017-09-29 14:17:40 139995643373888 [ERROR] InnoDB: Table `test`.`tc` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=129 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:17:40 139995643373888 [ERROR] InnoDB: Refusing to load './test/td.ibd' (id=3, flags=0x1e1); dictionary contains id=3, flags=0x101e1 2017-09-29 14:17:40 139995643373888 [ERROR] InnoDB: Operating system error number 2 in a file operation. 2017-09-29 14:17:40 139995643373888 [ERROR] InnoDB: The error means the system cannot find the path specified. 2017-09-29 14:17:40 139995643373888 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them. 2017-09-29 14:17:40 139995643373888 [Warning] InnoDB: Ignoring tablespace for `test`.`td` because it could not be opened. 2017-09-29 14:17:40 139995643373888 [ERROR] InnoDB: Table `test`.`tp` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=289 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:17:40 139995643373888 [ERROR] InnoDB: Table `test`.`tr` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=65 SYS_TABLES.MIX_LEN=4294967295 2017-09-29 14:17:40 139995643373888 [ERROR] InnoDB: Table `test`.`tz` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=12321 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:17:41 139995554035456 [ERROR] InnoDB: Table `test`.`tr` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=65 SYS_TABLES.MIX_LEN=4294967295 2017-09-29 14:17:41 139995554035456 [ERROR] InnoDB: Table `test`.`tc` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=129 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:17:41 139995554035456 [ERROR] InnoDB: Refusing to load './test/td.ibd' (id=3, flags=0x1e1); dictionary contains id=3, flags=0x101e1 2017-09-29 14:17:41 139995554035456 [ERROR] InnoDB: Operating system error number 2 in a file operation. 2017-09-29 14:17:41 139995554035456 [ERROR] InnoDB: The error means the system cannot find the path specified. 2017-09-29 14:17:41 139995554035456 [ERROR] InnoDB: Table `test`.`tz` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=12321 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:17:41 139995554035456 [ERROR] InnoDB: Table `test`.`tp` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=289 SYS_TABLES.N_COLS=2147483649

innodb.table_flags '4k,innodb'           w2 [ fail ]
        Test ended at 2017-09-29 14:18:19

CURRENT_TEST: innodb.table_flags
/usr/bin/mysqltest: Error on delete of '/usr/share/mysql-test/var/2/tmp/table_flags/ibtmp1' (Errcode: 2 "No such file or directory") --- /usr/share/mysql-test/suite/innodb/r/table_flags,4k.result~ 2017-09-26 17:08:10.304992901 +0200 +++ /usr/share/mysql-test/suite/innodb/r/table_flags,4k.reject 2017-09-29 14:18:18.954943828 +0200
@@ -174,7 +174,6 @@
 SELECT * FROM tp;
 a
 DROP TABLE tr,tc,td,tz,tp;
-ib_buffer_pool
 ib_logfile0
 ib_logfile1
 ibdata1

mysqltest: Result length mismatch

- saving '/usr/share/mysql-test/var/2/log/innodb.table_flags-4k,innodb/' to '/usr/share/mysql-test/var/log/innodb.table_flags-4k,innodb/' ***Warnings generated in error logs during shutdown after running tests: innodb.table_flags

2017-09-29 14:18:13 140291687692608 [ERROR] InnoDB: Table `test`.`tc` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=129 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:18:13 140291687692608 [ERROR] InnoDB: Refusing to load './test/td.ibd' (id=3, flags=0xe1); dictionary contains id=3, flags=0x100e1 2017-09-29 14:18:13 140291687692608 [ERROR] InnoDB: Operating system error number 2 in a file operation. 2017-09-29 14:18:13 140291687692608 [ERROR] InnoDB: The error means the system cannot find the path specified. 2017-09-29 14:18:13 140291687692608 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them. 2017-09-29 14:18:13 140291687692608 [Warning] InnoDB: Ignoring tablespace for `test`.`td` because it could not be opened. 2017-09-29 14:18:13 140291687692608 [ERROR] InnoDB: Table `test`.`tp` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=289 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:18:13 140291687692608 [ERROR] InnoDB: Table `test`.`tr` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=65 SYS_TABLES.MIX_LEN=4294967295 2017-09-29 14:18:13 140291687692608 [ERROR] InnoDB: Table `test`.`tz` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=12323 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:18:13 140291589162752 [ERROR] InnoDB: Table `test`.`tr` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=65 SYS_TABLES.MIX_LEN=4294967295 2017-09-29 14:18:13 140291589162752 [ERROR] InnoDB: Table `test`.`tc` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=129 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:18:13 140291589162752 [ERROR] InnoDB: Refusing to load './test/td.ibd' (id=3, flags=0xe1); dictionary contains id=3, flags=0x100e1 2017-09-29 14:18:13 140291589162752 [ERROR] InnoDB: Operating system error number 2 in a file operation. 2017-09-29 14:18:13 140291589162752 [ERROR] InnoDB: The error means the system cannot find the path specified. 2017-09-29 14:18:13 140291589162752 [ERROR] InnoDB: Table `test`.`tz` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=12323 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:18:13 140291589162752 [ERROR] InnoDB: Table `test`.`tp` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=289 SYS_TABLES.N_COLS=2147483649

sys_vars.innodb_file_per_table_basic 'innodb' w2 [ pass ]      4
innodb.index_tree_operation 'innodb'     w1 [ pass ]     19
innodb.innodb_bug60049 'innodb'          w3 [ pass ]   2522
innodb.create_isl_with_direct 'innodb'   w2 [ pass ]      8
innodb.innodb_force_pk 'innodb'          w2 [ pass ]     13
innodb.101_compatibility '8k,innodb'     w4 [ pass ]   4519
main.flush_block_commit_notembedded 'innodb' w3 [ pass ]   2061
binlog.binlog_checksum 'innodb,row'      w2 [ pass ]    834
main.mysql_upgrade 'innodb' w3 [ skipped ] Test requires partitioning
innodb.alter_missing_tablespace '8k,innodb' w4 [ pass ]   2518
innodb.innodb_bug14147491 'innodb'       w1 [ pass ]   4107
innodb.innodb_autoinc_lock_mode_zero 'innodb' w3 [ pass ]     12
innodb.innodb-mdev-7408 'innodb'         w1 [ pass ]      6
innodb.innodb_bug42101-nonzero 'innodb'  w3 [ pass ]      5
innodb.innodb-alter-nullable '8k,innodb' w4 [ pass ]     52
innodb.innodb_information_schema_buffer 'innodb' w1 [ pass ]     25
innodb.innodb-alter-table '8k,innodb'    w4 [ pass ]    523
binlog.binlog_commit_wait 'innodb,row'   w2 [ pass ]   5275
binlog.binlog_dmls_on_tmp_tables_readonly 'innodb,row' w2 [ pass ]     11
innodb.innodb_bug39438 'innodb'          w3 [ pass ]      8
main.bug46760 'innodb'                   w1 [ pass ]     12
main.row-checksum-old 'innodb'           w3 [ pass ]     16
innodb.innodb_trx_weight 'innodb'        w1 [ pass ]     40
innodb.innodb-alter 'innodb'             w3 [ pass ]    245
main.row-checksum 'innodb'               w1 [ pass ]     10
innodb.temporary_table_optimization 'innodb' w3 [ pass ]     47
innodb.data_types 'innodb'               w1 [ pass ]      5
innodb.innodb-index-online-norebuild 'innodb' w3 [ pass ]      8
innodb.innodb-stats-modified-counter 'innodb' w1 [ pass ]      8
innodb.table_flags '8k,innodb'           w4 [ fail ]
        Test ended at 2017-09-29 14:18:40

CURRENT_TEST: innodb.table_flags
/usr/bin/mysqltest: Error on delete of '/usr/share/mysql-test/var/4/tmp/table_flags/ibtmp1' (Errcode: 2 "No such file or directory") --- /usr/share/mysql-test/suite/innodb/r/table_flags,8k.result~ 2017-09-26 17:08:28.249137992 +0200 +++ /usr/share/mysql-test/suite/innodb/r/table_flags,8k.reject 2017-09-29 14:18:40.460922576 +0200
@@ -174,7 +174,6 @@
 SELECT * FROM tp;
 a
 DROP TABLE tr,tc,td,tz,tp;
-ib_buffer_pool
 ib_logfile0
 ib_logfile1
 ibdata1

mysqltest: Result length mismatch

- saving '/usr/share/mysql-test/var/4/log/innodb.table_flags-8k,innodb/' to '/usr/share/mysql-test/var/log/innodb.table_flags-8k,innodb/' ***Warnings generated in error logs during shutdown after running tests: innodb.table_flags

2017-09-29 14:18:35 139736414353728 [ERROR] InnoDB: Table `test`.`tc` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=129 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:18:35 139736414353728 [ERROR] InnoDB: Refusing to load './test/td.ibd' (id=3, flags=0x121); dictionary contains id=3, flags=0x10121 2017-09-29 14:18:35 139736414353728 [ERROR] InnoDB: Operating system error number 2 in a file operation. 2017-09-29 14:18:35 139736414353728 [ERROR] InnoDB: The error means the system cannot find the path specified. 2017-09-29 14:18:35 139736414353728 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them. 2017-09-29 14:18:35 139736414353728 [Warning] InnoDB: Ignoring tablespace for `test`.`td` because it could not be opened. 2017-09-29 14:18:35 139736414353728 [ERROR] InnoDB: Table `test`.`tp` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=289 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:18:35 139736414353728 [ERROR] InnoDB: Table `test`.`tr` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=65 SYS_TABLES.MIX_LEN=4294967295 2017-09-29 14:18:35 139736414353728 [ERROR] InnoDB: Table `test`.`tz` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=12323 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:18:35 139736317077248 [ERROR] InnoDB: Table `test`.`tr` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=65 SYS_TABLES.MIX_LEN=4294967295 2017-09-29 14:18:35 139736317077248 [ERROR] InnoDB: Table `test`.`tc` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=129 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:18:35 139736317077248 [ERROR] InnoDB: Refusing to load './test/td.ibd' (id=3, flags=0x121); dictionary contains id=3, flags=0x10121 2017-09-29 14:18:35 139736317077248 [ERROR] InnoDB: Operating system error number 2 in a file operation. 2017-09-29 14:18:35 139736317077248 [ERROR] InnoDB: The error means the system cannot find the path specified. 2017-09-29 14:18:35 139736317077248 [ERROR] InnoDB: Table `test`.`tz` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=12323 SYS_TABLES.N_COLS=2147483649 2017-09-29 14:18:35 139736317077248 [ERROR] InnoDB: Table `test`.`tp` in InnoDB data dictionary contains invalid flags. SYS_TABLES.TYPE=289 SYS_TABLES.N_COLS=2147483649

innodb.innodb_information_schema_tables 'innodb' w3 [ pass ]     17
innodb.innodb-trim 'innodb'              w1 [ pass ]   1101
innodb.innodb-autoinc-56228 'innodb'     w1 [ pass ]      4
innodb.innodb_mysql_rbk 'innodb'         w3 [ pass ]   3885
binlog.binlog_implicit_commit 'innodb,row' w2 [ pass ]  16518
binlog.binlog_innodb 'innodb,row'        w2 [ pass ]   2708
innodb.innodb-lock-schedule-algorithm 'innodb' w4 [ pass ]  10193
main.commit_1innodb 'innodb'             w2 [ fail ]
        Test ended at 2017-09-29 14:18:51

CURRENT_TEST: main.commit_1innodb
--- /usr/share/mysql-test/r/commit_1innodb.result 2017-09-25 08:33:24.000000000 +0200 +++ /usr/share/mysql-test/r/commit_1innodb.reject 2017-09-29 14:18:51.351405429 +0200
@@ -710,12 +710,12 @@
 #
 drop temporary table t2;
 call p_verify_status_increment(1, 0, 1, 0);
-SUCCESS
-
+ERROR
+Expected commit increment: 1 actual: 0
 commit;
 call p_verify_status_increment(1, 0, 1, 0);
-SUCCESS
-
+ERROR
+Expected commit increment: 1 actual: 0
 # 26. Verify that SET AUTOCOMMIT issues an implicit commit
 #
 insert t1 set a=3;
@@ -831,8 +831,8 @@
 Note   1050    Table 't2' already exists
 # Sic: first commits the statement, and then the transaction.
 call p_verify_status_increment(0, 0, 0, 0);
-SUCCESS
-
+ERROR
+Expected commit increment: 0 actual: 2
 create table t3 select a from t2;
 call p_verify_status_increment(2, 0, 4, 4);
 SUCCESS

mysqltest: Result length mismatch

- saving '/usr/share/mysql-test/var/2/log/main.commit_1innodb-innodb/' to '/usr/share/mysql-test/var/log/main.commit_1innodb-innodb/'