[MDEV-12475] test failure: index_merge_myisam Created: 2017-04-09  Updated: 2017-05-04  Resolved: 2017-05-04

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - MyISAM
Affects Version/s: 10.0.31
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Daniel Black Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: need_feedback, powerpc
Environment:

ppc64le, Debug, CC=at10.0



 Description   

10.0 at commit c51fc679f50cf202d11f159ae661e9f8026fab6d

cmake /source -DCMAKE_BUILD_TYPE=Debug -DWITH_PROTOBUF=system -DWITH_NDB_JAVA=NO -DCMAKE_C_COMPILER=/opt/at10.0/bin/gcc -DCMAKE_CXX_COMPILER=/opt/at10.0/bin/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-Debug-10.0 -DCMAKE_AR=/opt/at10.0/bin/ar -DCMAKE_C_COMPILER_LAUNCHER=ccache -DCMAKE_CXX_COMPILER_LAUNCHER=ccache -DWITHOUT_FEDERATED_STORAGE_ENGINE=1 -DWITHOUT_FEDERATEDX_STORAGE_ENGINE=1 -DWITHOUT_TOKUDB_STORAGE_ENGINE=1
...
./mtr '--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=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.create_or_replace.*'\''' '--skip-test='\''wsrep_info.plugin.*'\''' --skip-test=rpl.rpl_semi_sync --skip-test=binlog_encryption.rpl_semi_sync --skip-test=encryption.innodb-encryption-disable --skip-test=encryption.innodb_onlinealter_encryption '--skip-test='\''binlog_encryption.*'\''' --force --big-test --nowarnings
...
...
07:14:41 ];mtr: spent 0:02:47 on 3654 tests. 0:01:03 (1389 tests) leftmain.index_merge_myisam                  w79 [ fail ]
07:14:41         Test ended at 2017-04-09 21:14:41
07:14:41 
07:14:41 CURRENT_TEST: main.index_merge_myisam
07:14:41 --- /source/mysql-test/r/index_merge_myisam.result	2017-04-09 21:09:22.015154733 +0000
07:14:41 +++ /source/mysql-test/r/index_merge_myisam.reject	2017-04-09 21:14:41.159782263 +0000
07:14:41 @@ -521,8 +521,11 @@
07:14:41  4	5	0
07:14:41  4	filler	4
07:14:41  4	filler	4
07:14:41 +4	filler	4
07:14:41 +4	filler	4
07:14:41  4	qq	5
07:14:41  4	zz	4
07:14:41 +4	zz	4
07:14:41  5	qq	4
07:14:41  drop table t1, t2;
07:14:41  CREATE TABLE t1 (a varchar(8), b set('a','b','c','d','e','f','g','h'),
07:14:41 
07:14:41 mysqltest: Result length mismatch



 Comments   
Comment by Elena Stepanova [ 2017-05-01 ]

Is it reproducible or was it a one-time failure?
If it is reproducible, does it happen while running the test separately on the same build?

Comment by Daniel Black [ 2017-05-02 ]

Its quite reproducible on Type=Debug only with at10.0 (10.0-3 -gcc (GCC) 6.3.1 20170110 (Advance-Toolchain-at10.0) IBM AT 10 branch, based on subversion id 244285.) .

I tested this on gcc-5 (gcc (Ubuntu/IBM 5.4.0-6ubuntu1~16.04.4) 5.4.0 20160609) and gcc-6 (6.3.0-12ubuntu1.1) and this test doesn't fail. gcc7 (gcc-7 (Ubuntu 7-20170407-0ubuntu2) 7.0.1 20170407 (experimental) [trunk revision 246759] from https://launchpad.net/~ubuntu-toolchain-r/+archive/ubuntu/test) failed to build mariadb - gcc ran out of memory (memleak).

I've tested a non public build of AT (7.0.1 20170414 (Advance-Toolchain-at11.0-alpha1) and didn't have a problem with this test.

So I'm thinking there is a gcc/fault between these versions. I'll see what I can do to chase it down with the IBM toolchain folks.

Comment by Daniel Black [ 2017-05-04 ]

Tested with (not public) at10.0-4-rc1 (gcc (GCC) 6.3.1 20170405 (Advance-Toolchain-at10.0-rc1) IBM AT 10 branch, based on subversion id 246707) and this test failure doesn't occur.

closing as gcc/at bug.

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