Bug 923649

Summary:	dev-db/mysql-8.0.36 fails tests: Too many tests(10) failed! Terminating...
Product:	Gentoo Linux	Reporter:	matoro <matoro_gentoo>
Component:	Current packages	Assignee:	Gentoo Linux MySQL bugs team <mysql-bugs>
Status:	IN_PROGRESS ---
Severity:	normal	CC:	matoro_gentoo, parona
Priority:	Normal	Keywords:	PullRequest
Version:	unspecified
Hardware:	All
OS:	Linux
See Also:	https://github.com/gentoo/gentoo/pull/35002 https://bugs.gentoo.org/show_bug.cgi?id=919815
Whiteboard:
Package list:		Runtime testing required:	---
Attachments:	build.log and emerge --info tarball of failed test logs build.log and emerge --info

Description matoro archtester

2024-02-03 01:15:19 UTC

Have appropriate USE=perl and ulimit -n 16500 set.  Dies at 27% progress.

[ 16%] clone.remote_dml_replace                 w6  [ fail ]
[ 18%] rpl.rpl_semi_sync_alias 'row'            w2  [ fail ]
[ 20%] federated.federated_server               w3  [ fail ]  timeout after 900 seconds
[ 21%] rpl.rpl_innodb_bug28430 'mix'            w4  [ fail ]  timeout after 900 seconds
[ 21%] rpl.rpl_parallel 'mix'                   w8  [ fail ]  timeout after 900 seconds
[ 23%] rpl.rpl_priv_checks_user_start_info 'row' w1  [ fail ]
[ 23%] rpl.rpl_innodb_bug28430 'row'            w4  [ fail ]  timeout after 900 seconds
[ 23%] rpl.rpl_parallel 'row'                   w3  [ fail ]  timeout after 900 seconds
[ 25%] rpl.rpl_parallel_ddl_myisam 'stmt'       w4  [ fail ]
[ 27%] rpl.rpl_parallel 'stmt'                  w3  [ fail ]  timeout after 900 seconds

Too many failed: Failed 10/427 tests, 97.66% were successful.
 
Failing test(s): rpl.rpl_innodb_bug28430 rpl.rpl_parallel_ddl_myisam clone.remote_dml_replace federated.federated_server rpl.rpl_semi_sync_alias rpl.rpl_priv_checks_user_start_info rpl.rpl_parallel

The log files in var/log may give you some hint of what went wrong.
 
If you want to report this error, please read first the documentation
at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html
 
1811 tests were skipped, 21 by the test itself.
 
Too many tests(10) failed! Terminating...
safe_process[64421]: Child process: 64422, killed by signal: 9
safe_process[64496]: Child process: 64497, killed by signal: 9
mysql-test-run: *** ERROR: Test suite aborted

Reproducible: Always

Comment 1 Sam James archtester

2024-02-03 01:16:09 UTC

We should set whatever env var forces it to keep going.

Comment 2 Sam James archtester

2024-02-03 01:16:37 UTC

And disable or crank timeouts high.

Comment 3 matoro archtester

2024-02-03 01:16:48 UTC

Created attachment 884075 [details]
build.log and emerge --info

Comment 4 matoro archtester

2024-02-03 01:24:50 UTC

Created attachment 884076 [details]
tarball of failed test logs

Comment 5 Larry the Git Cow gentoo-dev

2024-04-24 18:18:06 UTC

The bug has been referenced in the following commit(s):

https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=e77068420194bc44cab11a3be2ddfdf0020833e0

commit e77068420194bc44cab11a3be2ddfdf0020833e0
Author:     Alfred Wingate <parona@protonmail.com>
AuthorDate: 2024-01-25 06:02:56 +0000
Commit:     Sam James <sam@gentoo.org>
CommitDate: 2024-04-24 18:17:23 +0000

    dev-db/mysql: add 8.0.36
    
    - --max-test-fail=0 and 40h suite timeout so that tests dont bail out early.
    
    Bug: https://bugs.gentoo.org/922808
    Bug: https://bugs.gentoo.org/923649
    Signed-off-by: Alfred Wingate <parona@protonmail.com>
    Closes: https://github.com/gentoo/gentoo/pull/35002
    Signed-off-by: Sam James <sam@gentoo.org>

 dev-db/mysql/Manifest                              |    2 +
 .../mysql/files/mysql-8.0.36-boost-clang-fix.patch |   76 ++
 dev-db/mysql/mysql-8.0.36.ebuild                   | 1271 ++++++++++++++++++++
 3 files changed, 1349 insertions(+)

Comment 6 matoro archtester

2024-06-08 15:51:53 UTC

Created attachment 895384 [details]
build.log and emerge --info

Here's the results from 8.0.36.

Completed: Failed 31/5249 tests, 99.41% were successful.
 
Failing test(s): rpl.rpl_mysql_upgrade sysschema.pr_ps_setup_show_enabled rpl.rpl_channel_creation_under_replica_load rpl.rpl_parallel_ddl_myisam clone.remote_dml_ssl_certificate rpl.rpl_priv_checks_user_start_info binlog_nogtid.binlog_unsafe perfschema.idx_threads clone.local_dml_auto_tune rpl.rpl_connection_compression main.lock_backup_ddl rpl_gtid.rpl_gtid_stm_drop_table innodb.mysqld_core_dump_without_buffer_pool rpl_nogtid.rpl_typeconv rpl.rpl_rewrite_db_per_channel_filter rpl.rpl_semi_sync_turn_on_off_optimize_for_static_plugin_config innodb.instant_ddl_upgrade_rollback clone.remote_dml_auto_tune main.mysql_client_test rpl_nogtid.rpl_row_event_max_size rpl.rpl_parallel_ddl_innodb query_rewrite_plugins.logging_general_raw rpl_gtid.rpl_gtid_row_event_max_size perfschema.threads_mysql innodb.mysqld_core_dump_without_buffer_pool_dynamic innodb.mysqld_core_dump_without_buffer_pool_with_resizing rpl_gtid.mysqldump_bug33630199 rpl.rpl_innodb_bug28430 rpl.rpl_eventlog_psi_memory

Comment 7 Sam James archtester

2024-09-17 22:01:33 UTC

Please try .37 (and give full logs for it).

Comment 8 matoro archtester

2024-09-18 16:39:37 UTC

(In reply to Sam James from comment #7)
> Please try .37 (and give full logs for it).

I get a success on .37 on amd64!

Comment 9 Sam James archtester

2024-09-18 16:42:18 UTC

yay!!!!