[MDEV-12083] test failure innodb.log_file_name 'innodb' "Table './mtr/test_suppressions' is marked as crashed and should be repaired" Created: 2017-02-19  Updated: 2017-02-19  Resolved: 2017-02-19

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.2.5
Fix Version/s: 10.1.22, 10.2.5

Type: Bug Priority: Major
Reporter: Daniel Black Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Environment:

x86_64, ubuntu-16.04


Issue Links:
Blocks
blocks MDEV-7069 Fix buildbot failures in main server ... Stalled

 Description   

+ cmake /source -DCMAKE_BUILD_TYPE=Release -DWITH_PROTOBUF=system -DWITH_NDB_JAVA=NO -DCMAKE_C_COMPILER=gcc -DCMAKE_CXX_COMPILER=g++ '-DCMAKE_C_FLAGS_RELWITHDEBINFO=-m64 -O3 -g -mtune=native' '-DCMAKE_CXX_FLAGS_RELWITHDEBINFO=-m64 -O3 -g -mtune=native' '-DCMAKE_C_FLAGS=-m64 -O3 -g -mtune=native' '-DCMAKE_CXX_FLAGS=-m64 -O3 -g -mtune=native' -DWITH_SSL=system -DCMAKE_INSTALL_PREFIX=/mysql/mariadb-upstream-Release-10.2 -DCMAKE_C_COMPILER_LAUNCHER=ccache -DCMAKE_CXX_COMPILER_LAUNCHER=ccache -DWITHOUT_TOKUDB_STORAGE_ENGINE=1
-- Running cmake version 3.5.1
-- The C compiler identification is GNU 5.4.0
-- The CXX compiler identification is GNU 5.4.0
...
...
+ ./mtr --force --big-test --nowarnings '--skip-test=gis.(geometry_property_function_issimple|gis_bugs_crashes|spatial_utility_function_simplify|spatial_analysis_functions_buffer|spatial_op_testingfunc_mix)' --skip-test=parts.partition_alter2_1_myisam '--skip-test=tokudb_parts.*' '--skip-test=tokudb.(rows-32m.*)' --skip-test=connect.tbl --skip-test=rpl.rpl_parallel --skip-test=encryption.innodb_encryption-page-compression --skip-test=perfschema.socket_summary_by_event_name_func '--skip-test=main.mysql_client_test.*' --skip-test=spider/bg.spider_fixes --skip-test=encryption.innodb-encryption-disable
Logging: /source/mysql-test/mysql-test-run.pl  --force --big-test --nowarnings --skip-test=gis.(geometry_property_function_issimple|gis_bugs_crashes|spatial_utility_function_simplify|spatial_analysis_functions_buffer|spatial_op_testingfunc_mix) --skip-test=parts.partition_alter2_1_myisam --skip-test=tokudb_parts.* --skip-test=tokudb.(rows-32m.*) --skip-test=connect.tbl --skip-test=rpl.rpl_parallel --skip-test=encryption.innodb_encryption-page-compression --skip-test=perfschema.socket_summary_by_event_name_func --skip-test=main.mysql_client_test.* --skip-test=spider/bg.spider_fixes --skip-test=encryption.innodb-encryption-disable
vardir: /build/build/mysql-test/var
Removing old var directory...
Creating var directory '/build/build/mysql-test/var'...
 - symlinking 'var' to '/dev/shm/var_auto_EeWc'
Checking supported features...
MariaDB Version 10.2.5-MariaDB
 - SSL connections supported
Using suites: main-,archive-,binlog-,binlog_encryption-,csv-,encryption-,federated-,funcs_1-,funcs_2-,gcol-,handler-,heap-,innodb-,innodb_fts-,innodb_gis-,innodb_zip-,json-,maria-,multi_source-,optimizer_unfixed_bugs-,parts-,percona-,perfschema-,plugins-,roles-,rpl-,sys_vars-,unit-,vcol-,wsrep-,connect,mroonga/storage,mroonga/wrapper,oqgraph,sequence,spider,spider/bg,sql_discovery,metadata_lock_info,query_response_time,user_variables
Collecting tests...
Installing system database...
Using parallel: 12
...
...
innodb.innodb_stats_drop_locked 'innodb' w3 [ pass ]   2009
...
innodb.log_file_name 'innodb'            w3 [ fail ]
        Test ended at 2017-02-17 23:32:12
 
CURRENT_TEST: innodb.log_file_name
--- /source/mysql-test/suite/innodb/r/log_file_name.result	2017-02-17 23:18:02.613828985 +0000
+++ /source/mysql-test/suite/innodb/r/log_file_name.reject	2017-02-17 23:32:12.033514610 +0000
@@ -67,6 +67,10 @@
 ERROR HY000: Tablespace for table '`test`.`t0`' exists. Please DISCARD the tablespace before IMPORT
 CREATE TABLE t0(a INT PRIMARY KEY) ENGINE=InnoDB;
 DROP TABLE t0;
+Warnings:
+Error	145	Table './mtr/test_suppressions' is marked as crashed and should be repaired
+Error	1194	Table 'test_suppressions' is marked as crashed and should be repaired
+Error	1034	1 client is using or hasn't closed the table properly
 CREATE TABLE u1(a INT PRIMARY KEY) ENGINE=InnoDB;
 CREATE TABLE u2(a INT PRIMARY KEY) ENGINE=InnoDB;
 CREATE TABLE u3(a INT PRIMARY KEY) ENGINE=InnoDB;
 
mysqltest: Result length mismatch



 Comments   
Comment by Elena Stepanova [ 2017-02-19 ]

It should hopefully be fixed by this commit:
https://github.com/MariaDB/server/commit/1d725c81769015b2a2e3d13296b0046f0eeb8065

It didn't make it to 10.2.4.

Comment by Daniel Black [ 2017-02-19 ]

Nice. Thanks.

Generated at Thu Feb 08 07:54:59 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.