maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #04818
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/'
