MySQL Bugs: #53422: Many tests fail on AIX with mysql-advanced-gpl-5.1.46-aix5.3-powerpc

Bug #53422	Many tests fail on AIX with mysql-advanced-gpl-5.1.46-aix5.3-powerpc
Submitted:	5 May 2010 6:58	Modified:	24 Aug 2011 13:25
Reporter:	Sveta Smirnova	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	Tests: Server	Severity:	S3 (Non-critical)
Version:	5.1.46	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
If use package mysql-advanced-gpl-5.1.46-aix5.3-powerpc following tests fail:

binlog.binlog_row_mix_innodb_myisam
binlog.binlog_stm_mix_innodb_myisam
binlog.binlog_old_versions
binlog.binlog_stm_ctype_cp932
binlog.binlog_stm_drop_tmp_tbl
binlog.binlog_stm_blackhole
binlog.binlog_stm_ctype_ucs
binlog.binlog_stm_insert_select
binlog.binlog_stm_unsafe_warning
binlog.binlog_tmp_table
main.create_select_tmp
main.archive
main.ctype_gbk_binlog
main.mysqlbinlog2
main.outfile_loaddata
main.query_cache
main.user_var-binlog
main.mysqlbinlog
main.mysqlbinlog-cp932
main.ctype_cp932_binlog_stm
main.mysqltest
rpl.rpl_binlog_grant
rpl.rpl_innodb_mixed_ddl
rpl.rpl_innodb_mixed_dml
rpl.rpl_loaddata
rpl.rpl_loaddata_concurrent
rpl.rpl_trigger
rpl.rpl_loaddata_map
rpl.rpl_cross_version
rpl.rpl000013
rpl.rpl_drop_temp
rpl.rpl_filter_tables_not_exist
rpl.rpl_loaddata_s
rpl.rpl_mixed_ddl_dml
rpl.rpl_nondeterministic_functions
rpl.rpl_rbr_to_sbr
rpl.rpl_rewrt_db
rpl.rpl_stm_EE_err2
rpl.rpl_stm_auto_increment_bug33029
rpl.rpl_stm_conflicts
rpl.rpl_stm_flsh_tbls
rpl.rpl_stm_insert_delayed
rpl.rpl_stm_log
rpl.rpl_stm_max_relay_size
rpl.rpl_stm_multi_query
rpl.rpl_stm_no_op
rpl.rpl_stm_reset_slave
rpl.rpl_stm_until
rpl.rpl_temp_table
rpl.rpl_trunc_temp
rpl.rpl_variables_stm
rpl.rpl_rotate_logs

Most errors like:

mysqltest: Exit with failure! Call 'exit' in script to return with sucess

or

mysqltest: At line 7: Could not open './suite/innodb/include/have_innodb_plugin.inc' for reading, errno: 2

How to repeat:
./mysql-test-run.pl  --force --max-test-fail=0

Full test log

Attachment: issue47128.log (application/octet-stream, text), 487.88 KiB.

This latform is covered in the release test and tests have passed. See http://clustra.norway.sun.com/~bteam/status/mysql-5.1.46sp1/builds.html

Sveta, I suspect that you used tar to extract the archive. I could reproduce this with a package I extracted with tar, but not with one that I extracted with gnutar. 

Can you confirm that you used AIX tar and not GNU tar? If so, is this something that changed with 5.1.46 and worked before?

The log from the test run clearly indicates that lots of the .result files as well as some include files are missing.

Yes, I used AIX tar.

Based on the above text, I propose to close that as "Not a bug".

It is a well-known fact that some implementations of "tar" have problems with the long names used in our packages, and that GNU "tar" is the safe option.

Joerg,

since our manual contains a note about tar I don't mind. Although it was a bit confusing when found.

See above comments:

The only safe option is to use GNU tar, as other implementations have too many problems with long names (for individual path components, or from deep nesting).

This is documented:
   "The standard tar provided with some operating systems is not
    able to unpack the long file names in the MySQL distribution.
    You should download and install GNU tar, or if available,
    use a preinstalled version of GNU tar."
http://dev.mysql.com/doc/refman/5.1/en/binary-installation.html

Closing this as "Not a bug".