[debian-mysql] Bug#1084293: Bug#1084293: mariadb: FTBFS: Failing test(s): main.timezone

Otto Kekäläinen otto at debian.org
Sun Oct 27 20:09:19 GMT 2024


Do you Faustin want to dive into why the timezone started to behave
differently recently in Debian?

Sergei and Daniel already looked at
https://jira.mariadb.org/browse/MDEV-35088, but you could help find
out what changed in Debian Sid recently.

On Tue, 8 Oct 2024 at 06:45, Otto Kekäläinen <otto at debian.org> wrote:
>
> Forwarded: https://jira.mariadb.org/browse/MDEV-35088
>
> Hi,
>
> I did notice this already a couple days ago. It is visible both in
> Debian CI and in Salsa CI. I don't know what changed in Debian (it is
> not a change in MariaDB), and I don't know if the MariaDB test should
> be adapted/updated to be more robust for whatever changed in Debian.
>
> Maybe Tuukka or Faustin can dive into it?
>
> On Mon, 7 Oct 2024 at 01:33, Santiago Vila <sanvila at debian.org> wrote:
> >
> > Package: src:mariadb
> > Version: 1:11.4.3-1
> > Severity: serious
> > Tags: ftbfs
> >
> > Dear maintainer:
> >
> > During a rebuild of all packages in unstable, your package failed to build:
> >
> > --------------------------------------------------------------------------------
> > [...]
> >   debian/rules binary
> > dh binary
> >     dh_update_autotools_config
> >     dh_autoreconf
> >     debian/rules override_dh_auto_configure
> > make[1]: Entering directory '/<<PKGBUILDDIR>>'
> > RULES.override_dh_auto_configure
> > dh_testdir
> > echo "server:Version=1:11.4.3-1" >> debian/substvars
> > # As packages does not have major version any more in package name there is no
> > # way as it not set by dpkg to use this on postinst script. Use sed to
> > # determine major version instead.
> > # @TODO: Rewrite this to use the new upstream /var/lib/mysql_upgrade_info file
> > # instead of the legacy /var/lib/debian-XX.X.flag file
> >
> > [... snipped ...]
> >
> > main.create_or_replace_permission        w2 [ pass ]      2
> > main.create_replace_tmp                  w2 [ pass ]      1
> > main.create_user                         w2 [ pass ]      6
> > main.create_utf8                         w2 [ pass ]      5
> > main.create_w_max_indexes_128            w2 [ skipped ]  Test needs mysqld built with --with-max-indexes=128
> > main.create_w_max_indexes_64             w2 [ pass ]     10
> > main.create_windows                      w2 [ skipped ]  Need windows
> > main.cte_cycle                           w2 [ pass ]      7
> > main.cte_grant                           w2 [ pass ]      7
> > main.cte_nonrecursive                    w2 [ pass ]     85
> > main.cte_nonrecursive_not_embedded       w2 [ pass ]      2
> > main.cte_recursive_not_embedded          w2 [ pass ]      3
> > main.ctype_ascii                         w2 [ pass ]      2
> > main.ctype_big5                          w2 [ pass ]    469
> > main.ctype_binary                        w2 [ pass ]    179
> > main.ctype_collate                       w2 [ pass ]     18
> > main.ctype_collate_column                w2 [ pass ]    978
> > main.ssl_timeout                         w1 [ pass ]  10040
> > main.stack-crash                         w1 [ pass ]      3
> > main.stat_tables_missing                 w1 [ pass ]      2
> > main.statement-expr                      w1 [ pass ]      3
> > main.statistics_close                    w1 [ pass ]      2
> > main.status2                             w1 [ pass ]      5
> > main.status_bug17954                     w1 [ pass ]      2
> > main.str_to_datetime_457                 w1 [ pass ]      1
> > main.strict_autoinc_1myisam              w1 [ pass ]      1
> > main.strict_autoinc_3heap                w1 [ pass ]      1
> > main.strings                             w1 [ pass ]      3
> > main.subselect3                          w1 [ pass ]    119
> > main.ctype_collate_context               w2 [ pass ]   1252
> > main.ctype_collate_database              w2 [ pass ]      8
> > main.subselect3_jcl6                     w1 [ pass ]    119
> > main.ctype_collate_implicit              w2 [ pass ]     11
> > main.ctype_collate_implicit_utf32        w2 [ pass ]      1
> > main.ctype_collate_table                 w2 [ pass ]      3
> > main.subselect_cache                     w1 [ pass ]    214
> > main.ctype_cp1250_ch                     w2 [ pass ]     29
> > main.subselect_exists2in_costmat         w1 [ pass ]     56
> > main.subselect_extra                     w1 [ pass ]     59
> > main.ctype_cp1251                        w2 [ pass ]    182
> > main.ctype_cp850                         w2 [ pass ]      7
> > main.subselect_extra_no_semijoin         w1 [ pass ]     69
> > main.ctype_cp866                         w2 [ pass ]
> > main.subselect_gis                       w1 [ pass ]      1
> > main.ctype_cp932                         w2 [ pass ]     27
> > main.subselect_mat_analyze_json          w1 [ pass ]      8
> > main.ctype_create                        w2 [ pass ]     13
> > main.subselect_mat_cost_bugs             w1 [ pass ]     35
> > main.ctype_dec8                          w2 [ pass ]      1
> > main.subselect_notembedded               w1 [ pass ]     25
> > main.ctype_errors                        w2 [ pass ]      3
> > main.subselect_nulls                     w1 [ pass ]      5
> > main.ctype_eucjpms                       w2 [ pass ]    662
> > main.subselect_sj                        w1 [ pass ]    897
> > main.subselect_sj_aria                   w1 [ pass ]      5
> > main.subselect_sj_nonmerged              w1 [ pass ]     12
> > main.ctype_euckr                         w2 [ pass ]    407
> > main.ctype_filename                      w2 [ pass ]     11
> > main.sum_distinct                        w1 [ pass ]     99
> > main.symlink                             w1 [ pass ]     94
> > main.symlink-aria-11902                  w1 [ skipped ]  debug_sync is not available
> > main.symlink-myisam-11902                w1 [ skipped ]  debug_sync is not available
> > main.synchronization                     w1 [ pass ]    118
> > main.ctype_gb2312                        w2 [ pass ]    470
> > main.system_mysql_db                     w1 [ pass ]      2
> > main.system_mysql_db_507                 w1 [ pass ]     10
> > main.system_mysql_db_refs                w1 [ pass ]      6
> > main.table_elim_debug                    w1 [ pass ]      2
> > main.table_keyinfo-6838                  w1 [ pass ]      3
> > main.table_options                       w1 [ pass ]     16
> > main.table_value_constr                  w1 [ pass ]     55
> > main.ctype_gbk                           w2 [ pass ]    506
> > main.ctype_gbk_export_import             w2 [ skipped ]  Need POSIX locale zh_CN.gbk
> > main.tablelock                           w1 [ pass ]      6
> > main.temp_table_frm                      w1 [ pass ]      5
> > main.ctype_hebrew                        w2 [ pass ]      1
> > main.temp_table_symlink                  w1 [ pass ]      6
> > main.temporal_literal                    w1 [ pass ]     16
> > main.temporal_scale_4283                 w1 [ pass ]      2
> > main.timeout                             w1 [ pass ]      6
> > worker[01] > Restart [mysqld.1 - pid: 1939152, winpid: 1939152] - different timezone
> > main.ctype_latin1                        w2 [ pass ]    466
> > main.ctype_latin1_de                     w2 [ pass ]     21
> > main.ctype_latin2                        w2 [ pass ]     15
> > main.ctype_latin2_ch                     w2 [ pass ]     27
> > main.timezone                            w1 [ fail ]
> >          Test ended at 2024-10-06 15:26:30
> >
> > CURRENT_TEST: main.timezone
> > --- /<<PKGBUILDDIR>>/mysql-test/main/timezone.result    2024-08-05 10:49:39.000000000 +0200
> > +++ /<<PKGBUILDDIR>>/mysql-test/main/timezone.reject    2024-10-06 17:26:30.597061757 +0200
> > @@ -1,6 +1,6 @@
> >   show variables like "system_time_zone";
> >   Variable_name Value
> > -system_time_zone       MET
> > +system_time_zone       CEST
> >   #
> >   # Test unix timestamp
> >   #
> > @@ -82,7 +82,7 @@
> >   SET @@time_zone= default;
> >   SELECT DATE_FORMAT('2009-11-01 22:23:00', '%z %Z') AS current_timezone;
> >   current_timezone
> > -+0100 MET
> > ++0100 CET
> >   SELECT DATE_FORMAT('2008-06-04 02:23:00', '%z %Z') AS current_timezone;
> >   current_timezone
> > -+0200 MEST
> > ++0200 CEST
> >
> > Result length mismatch
> >
> >   - saving '/<<PKGBUILDDIR>>/builddir/mysql-test/var/1/log/main.timezone/' to '/<<PKGBUILDDIR>>/builddir/mysql-test/var/log/main.timezone/'
> >
> > Retrying test main.timezone, attempt(2/3)...
> >
> > worker[01] > Restart  - not started
> > ***Warnings generated in error logs during shutdown after running tests: main.timezone
> >
> > 2024-10-06 17:26:30 4 [ERROR] mysql.time_zone_transition_type table is incorrectly defined or corrupted
> >
> > main.ctype_many                          w2 [ pass ]     27
> > main.ctype_mb                            w2 [ pass ]      4
> > worker[01] > Restart  - not started
> > main.timezone                            w1 [ retry-fail ]
> >          Test ended at 2024-10-06 15:26:31
> >
> > CURRENT_TEST: main.timezone
> > --- /<<PKGBUILDDIR>>/mysql-test/main/timezone.result    2024-08-05 10:49:39.000000000 +0200
> > +++ /<<PKGBUILDDIR>>/mysql-test/main/timezone.reject    2024-10-06 17:26:30.925062270 +0200
> > @@ -1,6 +1,6 @@
> >   show variables like "system_time_zone";
> >   Variable_name Value
> > -system_time_zone       MET
> > +system_time_zone       CEST
> >   #
> >   # Test unix timestamp
> >   #
> > @@ -82,7 +82,7 @@
> >   SET @@time_zone= default;
> >   SELECT DATE_FORMAT('2009-11-01 22:23:00', '%z %Z') AS current_timezone;
> >   current_timezone
> > -+0100 MET
> > ++0100 CET
> >   SELECT DATE_FORMAT('2008-06-04 02:23:00', '%z %Z') AS current_timezone;
> >   current_timezone
> > -+0200 MEST
> > ++0200 CEST
> >
> > Result length mismatch
> >
> >   - skipping '/<<PKGBUILDDIR>>/builddir/mysql-test/var/1/log/main.timezone/'
> >
> > Test main.timezone has failed 2 times, no more retries!
> >
> > ***Warnings generated in error logs during shutdown after running tests: main.timezone
> >
> > 2024-10-06 17:26:30 4 [ERROR] mysql.time_zone_transition_type table is incorrectly defined or corrupted
> >
> > worker[01] > Restart [mysqld.1 - pid: 1940878, winpid: 1940878] - different timezone
> > main.timezone2                           w1 [ pass ]     60
> > main.ctype_nopad_8bit                    w2 [ pass ]    377
> > main.ctype_recoding                      w2 [ pass ]     16
> > worker[01] > Restart [mysqld.1 - pid: 1940915, winpid: 1940915] - different timezone
> > main.timezone3                           w1 [ pass ]     28
> > main.ctype_sjis                          w2 [ pass ]    541
> > worker[01] > Restart [mysqld.1 - pid: 1940932, winpid: 1940932] - different timezone
> > main.timezone4                           w1 [ pass ]      1
> > main.ctype_swe7                          w2 [ pass ]    223
> > main.ctype_tis620                        w2 [ pass ]     60
> > main.timezone_grant                      w1 [ pass ]     36
> > main.tmp_table_count-7586                w1 [ pass ]      6
> > main.ctype_uca                           w2 [ pass ]    180
> > main.ctype_ucs                           w2 [ pass ]    297
> > main.ctype_ucs2_uca                      w2 [ pass ]    101
> > main.ctype_ujis                          w2 [ pass ]    607
> > main.trigger                             w1 [ pass ]   1320
> > main.trigger-compat                      w1 [ pass ]     30
> > main.trigger_no_defaults-11698           w1 [ pass ]      3
> > main.ctype_ujis_ucs2                     w2 [ pass ]    485
> > main.ctype_utf16                         w2 [ pass ]     84
> > main.ctype_utf16_uca                     w2 [ pass ]    119
> > main.ctype_utf16le                       w2 [ pass ]     89
> > main.ctype_utf32                         w2 [ pass ]     94
> > main.ctype_utf32_uca                     w2 [ pass ]    126
> > main.ctype_utf8_uca                      w2 [ pass ]    114
> > main.ctype_utf8mb4_heap                  w2 [ pass ]     76
> > main.ctype_utf8mb4_myisam                w2 [ pass ]    109
> > main.ctype_utf8mb4_uca                   w2 [ pass ]    128
> > main.trigger_notembedded                 w1 [ pass ]   2060
> > main.trigger_null-8605                   w1 [ pass ]     26
> > main.truncate                            w1 [ pass ]     10
> > main.truncate_coverage                   w1 [ skipped ]  debug_sync is not available
> > main.truncate_notembedded                w1 [ pass ]      2
> > main.type_binary                         w1 [ pass ]     23
> > main.type_bit                            w1 [ pass ]    111
> > main.type_char                           w1 [ pass ]      1
> > main.type_date                           w1 [ pass ]     66
> > main.type_date_round                     w1 [ pass ]     11
> > main.type_datetime                       w1 [ pass ]     87
> > main.type_datetime_round                 w1 [ pass ]     12
> > main.type_decimal                        w1 [ pass ]     59
> > main.type_enum                           w1 [ pass ]     93
> > main.type_float                          w1 [ pass ]     81
> > main.type_geometry_mix_int               w1 [ pass ]     21
> > main.type_hex_hybrid                     w1 [ pass ]      7
> > main.type_int                            w1 [ pass ]     98
> > main.type_interval                       w1 [ pass ]      1
> > main.type_json                           w1 [ pass ]     10
> > main.type_nchar                          w1 [ pass ]      3
> > main.type_newdecimal                     w1 [ pass ]    126
> > main.type_num                            w1 [ pass ]     62
> > main.ctype_utf8mb4_uca_allkeys1400       w2 [ pass ]   2661
> > main.type_ranges                         w1 [ pass ]     22
> > main.type_row                            w1 [ pass ]      3
> > main.type_set                            w1 [ pass ]     34
> > main.type_temporal_mariadb53             w1 [ pass ]      5
> > main.type_temporal_mysql56               w1 [ pass ]      2
> > main.type_time                           w1 [ pass ]    109
> > main.type_time_6065                      w1 [ pass ]     24
> > main.type_time_round                     w1 [ pass ]     18
> > main.ctype_utf8mb4_uca_allkeys400        w2 [ pass ]    709
> > main.type_timestamp                      w1 [ pass ]    108
> > main.type_timestamp_round                w1 [ pass ]     13
> > main.type_uint                           w1 [ pass ]     24
> > main.type_varchar_mysql41                w1 [ pass ]     13
> > main.type_year                           w1 [ pass ]     40
> > main.ctype_utf8mb4_uca_allkeys520        w2 [ pass ]   1170
> > main.custom_aggregate_functions          w2 [ pass ]     36
> > main.custom_aggregates_i_s               w2 [ pass ]      5
> > main.date_formats                        w2 [ pass ]      9
> > main.datetime_456                        w2 [ pass ]      1
> > main.udf                                 w1 [ pass ]   1341
> > main.udf_debug_sync                      w1 [ skipped ]  debug_sync is not available
> > main.ddl_i18n_koi8r                      w2 [ pass ]    701
> > main.ddl_i18n_utf8                       w2 [ pass ]    665
> > main.deadlock_ftwrl                      w2 [ skipped ]  debug_sync is not available
> > main.debug_sync                          w2 [ skipped ]  debug_sync is not available
> > main.default_debug                       w2 [ skipped ]  debug_sync is not available
> > main.default_session                     w2 [ pass ]      8
> > main.udf_notembedded                     w1 [ pass ]   1307
> > main.udf_query_cache                     w1 [ pass ]      2
> > main.update_ignore_216                   w1 [ pass ]      1
> > main.update_single_to_multi              w1 [ pass ]    738
> > main.default_storage_engine              w2 [ pass ]   1236
> > main.delayed                             w2 [ skipped ]  debug_sync is not available
> > main.delete                              w2 [ pass ]     39
> > main.delete_returning_grant              w2 [ pass ]      6
> > main.upgrade_MDEV-19650                  w1 [ pass ]    473
> > main.delete_single_to_multi              w2 [ pass ]    981
> > main.upgrade_MDEV-23102-1                w1 [ pass ]    905
> > main.delimiter_command_case_sensitivity  w2 [ pass ]     20
> > main.deprecated_features                 w2 [ pass ]
> > main.derived_opt                         w2 [ pass ]    585
> > main.upgrade_MDEV-23102-2                w1 [ pass ]    892
> > main.upgrade_geometrycolumn_procedure_definer w1 [ pass ]    422
> > main.dirty_close                         w2 [ pass ]   1012
> > main.upgrade_mdev_24363                  w1 [ pass ]    427
> > main.userstat-badlogin-4824              w1 [ pass ]      2
> > main.drop_combinations                   w2 [ pass ]     99
> > main.varbinary                           w1 [ pass ]     13
> > main.variables_community                 w1 [ pass ]      1
> > main.dyncol                              w2 [ pass ]     41
> > main.view_alias                          w1 [ pass ]     18
> > main.view_grant                          w1 [ pass ]    131
> > main.empty_server_name-8224              w2 [ pass ]   1204
> > main.empty_string_literal                w2 [ pass ]      5
> > main.empty_table                         w2 [ pass ]      5
> > main.empty_user_table                    w2 [ pass ]      7
> > main.except                              w2 [ pass ]      9
> > main.except_all                          w2 [ pass ]     10
> > main.execution_constants                 w2 [ pass ]     73
> > main.explain                             w2 [ pass ]    218
> > main.failed_auth_3909                    w2 [ pass ]   3006
> > main.features 'nm'                       w2 [ pass ]     10
> > main.fetch_first                         w2 [ pass ]     19
> > main.filesort_bad_i_s-7585               w2 [ pass ]     25
> > main.filesort_pack                       w2 [ pass ]      2
> > main.fix_priv_tables                     w2 [ pass ]    197
> > main.wait_timeout                        w1 [ pass ]   6040
> > main.warnings_engine_disabled            w1 [ pass ]      2
> > main.win_as_arg_to_aggregate_func        w1 [ pass ]      2
> > main.win_avg                             w1 [ pass ]      1
> > main.win_big                             w1 [ pass ]    104
> > main.win_big-mdev-10092                  w1 [ pass ]      5
> > main.win_big-mdev-11697                  w1 [ pass ]   1070
> > main.win_bit                             w1 [ pass ]      2
> > main.win_empty_over                      w1 [ pass ]      3
> > main.win_first_last_value                w1 [ pass ]      3
> > main.win_i_s                             w1 [ pass ]      2
> > main.win_insert_select                   w1 [ pass ]      3
> > main.win_lead_lag                        w1 [ pass ]      3
> > main.win_min_max                         w1 [ pass ]      6
> > main.win_nth_value                       w1 [ pass ]      1
> > main.win_ntile                           w1 [ pass ]      4
> > main.win_orderby                         w1 [ pass ]      3
> > main.win_percent_cume                    w1 [ pass ]      1
> > main.win_percentile                      w1 [ pass ]     12
> > main.win_rank                            w1 [ pass ]      2
> > main.win_std                             w1 [ pass ]      3
> > main.win_sum                             w1 [ pass ]      1
> > main.windows                             w1 [ skipped ]  Need windows
> > main.xa_sync                             w1 [ skipped ]  debug_sync is not available
> > main.xml                                 w1 [ pass ]     20
> > main.flush_logs_not_windows              w1 [ pass ]      3
> > main.flush_notembedded                   w1 [ pass ]      4
> > main.flush                               w2 [ pass ]   4866
> > main.frm_bad_row_type-7333               w2 [ pass ]      2
> > main.fulltext                            w2 [ pass ]     40
> > main.fulltext2                           w2 [ pass ]    107
> > main.fulltext3                           w2 [ pass ]      3
> > main.fulltext_cache                      w2 [ pass ]      2
> > main.fulltext_charsets                   w2 [ pass ]      1
> > main.fulltext_derived_4257               w2 [ pass ]
> > main.fulltext_derived_4316               w2 [ pass ]      1
> > main.fulltext_distinct                   w2 [ pass ]      2
> > main.fulltext_left_join                  w2 [ pass ]      7
> > main.fulltext_multi                      w2 [ pass ]      1
> > main.fulltext_order_by                   w2 [ pass ]      7
> > main.flush_ssl                           w1 [ pass ]   2438
> > main.fulltext_update                     w2 [ pass ]      1
> > main.func_bit                            w2 [ pass ]      7
> > main.func_compress                       w2 [ pass ]    454
> > main.func_concat                         w2 [ pass ]     12
> > main.func_crypt                          w2 [ pass ]     10
> > main.func_date_add                       w2 [ pass ]      7
> > main.func_default                        w2 [ pass ]     12
> > main.func_des_encrypt                    w2 [ pass ]      3
> > main.func_digest                         w2 [ pass ]     17
> > main.func_encrypt_nossl                  w2 [ skipped ]  Test requires: embedded server
> > main.func_encrypt_ucs2                   w2 [ pass ]      1
> > main.func_equal                          w2 [ pass ]      2
> > main.func_extract                        w2 [ pass ]     54
> > main.func_format                         w2 [ pass ]      3
> > main.func_group                          w2 [ pass ]    156
> > main.func_hybrid_type                    w2 [ pass ]    103
> > main.func_if                             w2 [ pass ]      9
> > main.func_in                             w2 [ pass ]    445
> > main.func_int                            w2 [ pass ]      2
> > main.func_isnull                         w2 [ pass ]      7
> > main.func_kdf 'new'                      w2 [ pass ]     19
> > main.func_like                           w2 [ pass ]     14
> > main.func_math                           w2 [ pass ]    166
> > main.func_op                             w2 [ pass ]      2
> > main.func_regexp                         w2 [ pass ]      8
> > main.func_regexp_pcre                    w2 [ pass ]     12
> > main.func_replace                        w2 [ pass ]      6
> > main.func_sapdb                          w2 [ pass ]      5
> > main.func_set                            w2 [ pass ]      6
> > main.func_sformat                        w2 [ pass ]     10
> > main.func_system                         w2 [ pass ]      5
> > main.func_test                           w2 [ pass ]     11
> > main.flush_table                         w1 [ pass ]   4009
> > main.fulltext_var                        w1 [ pass ]      2
> > main.func_time_hires                     w1 [ pass ]      6
> > main.func_time_round                     w1 [ pass ]     17
> > main.func_timestamp                      w1 [ pass ]      2
> > main.func_weight_string                  w1 [ pass ]      8
> > main.function_defaults                   w1 [ pass ]    141
> > main.function_defaults_notembedded       w1 [ skipped ]  debug_sync is not available
> > main.gcc296                              w1 [ pass ]      1
> > main.gis                                 w1 [ pass ]    188
> > main.gis-json                            w1 [ pass ]      2
> > main.gis-loaddata                        w1 [ pass ]      2
> > main.gis-precise                         w1 [ pass ]    756
> > main.gis-rt-precise                      w1 [ pass ]     15
> > main.gis-rtree                           w1 [ pass ]     67
> > main.gis_notembedded                     w1 [ pass ]      4
> > main.grant5                              w1 [ pass ]     24
> > main.grant_4332                          w1 [ pass ]     21
> > main.grant_binlog_replay                 w1 [ pass ]      1
> > main.grant_cache_no_prot                 w1 [ pass ]    714
> > main.grant_cache_ps_prot                 w1 [ skipped ]  Need ps-protocol
> > main.grant_explain_non_select            w1 [ pass ]      8
> > main.grant_kill                          w1 [ pass ]      4
> > main.grant_lowercase_fs                  w1 [ skipped ]  Test requires: 'case_insensitive_fs'
> > main.grant_master_admin                  w1 [ pass ]      1
> > main.grant_read_only                     w1 [ pass ]      3
> > main.grant_repair                        w1 [ pass ]      8
> > main.grant_server                        w1 [ pass ]      3
> > main.grant_slave_admin                   w1 [ pass ]      2
> > main.grant_slave_monitor                 w1 [ pass ]      2
> > main.grant_utf8_cli                      w1 [ pass ]     18
> > main.group_by_null                       w1 [ pass ]      1
> > main.handler_read_last                   w1 [ pass ]      2
> > main.having                              w1 [ pass ]     46
> > main.having_cond_pushdown                w1 [ pass ]     52
> > main.help                                w1 [ pass ]     26
> > main.implicit_char_to_num_conversion     w1 [ pass ]     10
> > main.in_datetime_241                     w1 [ pass ]      1
> > main.in_subq_cond_pushdown               w1 [ pass ]     34
> > main.index_intersect                     w1 [ pass ]     98
> > main.information_schema2                 w1 [ pass ]      3
> > main.information_schema_chmod            w1 [ pass ]      1
> > main.information_schema_columns          w1 [ pass ]      2
> > main.information_schema_linux            w1 [ skipped ]  Need Linux
> > main.information_schema_parameters       w1 [ pass ]     18
> > main.information_schema_prepare          w1 [ pass ]      1
> > main.information_schema_routines         w1 [ pass ]     19
> > main.information_schema_stats            w1 [ pass ]      6
> > main.init_file_set_password-7656         w1 [ pass ]   1206
> > worker[01] > Restart [mysqld.1 - pid: 1943374, winpid: 1943374] - running with different options '' != ''
> > main.insert                              w1 [ pass ]    228
> > main.insert_notembedded                  w1 [ pass ]      9
> > main.insert_returning_datatypes          w1 [ pass ]      1
> > main.func_time                           w2 [ pass ]   8111
> > main.insert_update_autoinc-7150          w2 [ pass ]
> > main.insert_select                       w1 [ pass ]    351
> > main.intersect                           w2 [ pass ]    792
> > main.invisible_field                     w2 [ pass ]     34
> > main.invisible_field_grant_system        w2 [ pass ]    204
> > main.item_types                          w2 [ pass ]      2
> > main.join                                w2 [ pass ]    162
> > main.join_crash                          w2 [ pass ]      4
> > main.join_nested                         w2 [ pass ]     65
> > main.join_nested_jcl6                    w2 [ pass ]     70
> > main.json_equals                         w2 [ pass ]      2
> > main.json_normalize                      w2 [ pass ]      4
> > main.insert_update                       w1 [ pass ]   2020
> > main.key_diff                            w2 [ pass ]      2
> > main.keywords                            w2 [ pass ]     38
> > main.kill                                w2 [ pass ]    623
> > main.kill_processlist-6619               w2 [ skipped ]  debug_sync is not available
> > main.kill_query-6728                     w2 [ pass ]      1
> > main.last_value                          w2 [ pass ]      1
> > main.limit                               w2 [ pass ]      7
> > main.limit_rows_examined                 w2 [ pass ]     32
> > main.load_timezones_with_alter_algorithm_inplace w2 [ pass ]     30
> > main.loaddata                            w2 [ pass ]     74
> > main.intersect_all                       w1 [ pass ]   1522
> > main.key_primary                         w1 [ pass ]      2
> > main.loadxml                             w2 [ pass ]   3068
> > main.lock_multi_bug38691                 w2 [ pass ]    505
> > main.lock_user                           w2 [ pass ]   1006
> > main.lock_view                           w2 [ pass ]     57
> > main.log_errchk                          w2 [ pass ]   1216
> > worker[02] > Restart [mysqld.1 - pid: 1943740, winpid: 1943740] - running with different options '' != ''
> > main.lock_multi                          w1 [ pass ]   7364
> > main.log_slow                            w2 [ pass ]   1355
> > main.long_unique_bugs_no_sp_protocol     w2 [ pass ]      5
> > main.long_unique_delayed                 w2 [ pass ]      2
> > main.long_unique_update                  w2 [ pass ]     12
> > main.long_unique_using_hash              w2 [ pass ]      2
> > main.lotofstack                          w2 [ pass ]    109
> > main.lock_multi_bug38499                 w1 [ pass ]   1035
> > main.long_host                           w1 [ skipped ]  debug_sync is not available
> > main.lowercase_fs_on                     w1 [ skipped ]  Test requires: 'case_insensitive_file_system'
> > main.lowercase_table5                    w1 [ pass ]     15
> > main.lowercase_fs_off                    w2 [ pass ]    677
> > main.mdev316                             w2 [ pass ]      1
> > main.mdev375                             w2 [ pass ]      3
> > main.mdev_14586                          w2 [ pass ]      3
> > main.mdev_19276                          w2 [ pass ]      7
> > main.max_password_errors                 w1 [ pass ]   3011
> > main.mdev19198                           w1 [ pass ]      1
> >
> > Only  1286  of 1285 completed.
> > --------------------------------------------------------------------------
> > The servers were restarted 227 times
> > Spent 638.881 of 423 seconds executing testcases
> >
> > Completed: Failed 2/1101 tests, 99.82% were successful.
> >
> > Failing test(s): main.timezone
> >
> > 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
> >
> > Errors/warnings were found in logfiles during server shutdown after running the
> > following sequence(s) of tests:
> >      main.timezone
> >      main.timezone
> > 178 tests were skipped, 68 by the test itself.
> >
> > mysql-test-run: *** ERROR: there were failing test cases
> > make[1]: *** [debian/rules:146: override_dh_auto_test] Error 1
> > make[1]: Leaving directory '/<<PKGBUILDDIR>>'
> > make: *** [debian/rules:232: binary] Error 2
> > dpkg-buildpackage: error: debian/rules binary subprocess returned exit status 2
> > --------------------------------------------------------------------------------
> >
> > The above is just how the build ends and not necessarily the most relevant part.
> > If required, the full build log is available here:
> >
> > https://people.debian.org/~sanvila/build-logs/202410/
> >
> > About the archive rebuild: The build was made on virtual machines from AWS,
> > using sbuild and a reduced chroot with only build-essential packages.
> >
> > If you could not reproduce the bug please contact me privately, as I
> > am willing to provide ssh access to a virtual machine where the bug is
> > fully reproducible.
> >
> > If this is really a bug in one of the build-depends, please use
> > reassign and affects, so that this is still visible in the BTS web
> > page for this package.



More information about the pkg-mysql-maint mailing list