Package: src:mariadb; Maintainer for src:mariadb is Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>;
Reported by: Santiago Vila <sanvila@debian.org>
Date: Mon, 7 Oct 2024 08:33:48 UTC
Severity: normal
Tags: ftbfs, patch
Found in version mariadb/1:11.4.3-1
Reply or subscribe to this bug.
View this report as an mbox folder, status mbox, maintainer mbox
Report forwarded
to debian-bugs-dist@lists.debian.org, sanvila@debian.org, Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>:
Bug#1084293; Package src:mariadb.
(Mon, 07 Oct 2024 08:33:49 GMT) (full text, mbox, link).
Acknowledgement sent
to Santiago Vila <sanvila@debian.org>:
New Bug report received and forwarded. Copy sent to sanvila@debian.org, Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>.
(Mon, 07 Oct 2024 08:33:49 GMT) (full text, mbox, link).
Message #5 received at submit@bugs.debian.org (full text, mbox, reply):
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.
Thanks.
Information forwarded
to debian-bugs-dist@lists.debian.org, Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>:
Bug#1084293; Package src:mariadb.
(Tue, 08 Oct 2024 05:45:02 GMT) (full text, mbox, link).
Acknowledgement sent
to Otto Kekäläinen <otto@debian.org>:
Extra info received and forwarded to list. Copy sent to Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>.
(Tue, 08 Oct 2024 05:45:02 GMT) (full text, mbox, link).
Message #10 received at 1084293@bugs.debian.org (full text, mbox, reply):
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@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.
>
> Thanks.
>
> _______________________________________________
> pkg-mysql-maint mailing list
> pkg-mysql-maint@alioth-lists.debian.net
> https://alioth-lists.debian.net/cgi-bin/mailman/listinfo/pkg-mysql-maint
Information forwarded
to debian-bugs-dist@lists.debian.org, Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>:
Bug#1084293; Package src:mariadb.
(Fri, 11 Oct 2024 12:27:03 GMT) (full text, mbox, link).
Acknowledgement sent
to "Rebecca N. Palmer" <rebecca_palmer@zoho.com>:
Extra info received and forwarded to list. Copy sent to Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>.
(Fri, 11 Oct 2024 12:27:03 GMT) (full text, mbox, link).
Message #15 received at 1084293@bugs.debian.org (full text, mbox, reply):
These bugs look like they are caused by the tzdata short names ('EST'
etc) being changed into aliases (and hence no longer perfectly
constant-offset) and moved to tzdata-legacy, but I haven't looked
closely enough to be sure. See #1084190 for more.
Information forwarded
to debian-bugs-dist@lists.debian.org, Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>:
Bug#1084293; Package src:mariadb.
(Sun, 27 Oct 2024 20:12:01 GMT) (full text, mbox, link).
Acknowledgement sent
to Otto Kekäläinen <otto@debian.org>:
Extra info received and forwarded to list. Copy sent to Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>.
(Sun, 27 Oct 2024 20:12:01 GMT) (full text, mbox, link).
Message #20 received at 1084293@bugs.debian.org (full text, mbox, reply):
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@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@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.
Information forwarded
to debian-bugs-dist@lists.debian.org, Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>:
Bug#1084293; Package src:mariadb.
(Sun, 27 Oct 2024 21:03:02 GMT) (full text, mbox, link).
Acknowledgement sent
to Santiago Vila <sanvila@debian.org>:
Extra info received and forwarded to list. Copy sent to Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>.
(Sun, 27 Oct 2024 21:03:02 GMT) (full text, mbox, link).
Message #25 received at 1084293@bugs.debian.org (full text, mbox, reply):
El 27/10/24 a las 21:09, Otto Kekäläinen escribió:
> 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.
Hi. The relevant changes are in the tzdata package.
This is from the changelog:
* Upstream obsoleted the System V names CET, CST6CDT, EET, EST*, HST, MET,
MST*, PST8PDT, and WET. They are symlinks now. Move those zones to
tzdata-legacy and update /etc/localtime on package update to the new names.
Please use Etc/GMT* in case you want to avoid DST changes.
If you are lucky, an additional build-depends on tzdata-legacy might fix
some tests which broke. However, if those zones are considered obsolete,
you might want to consider obsoleting the matching test as well.
Hope this helps.
[ Disclaimer: I'm just a casual observer of packages which FTBFS ]
Thanks.
Information forwarded
to debian-bugs-dist@lists.debian.org, Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>:
Bug#1084293; Package src:mariadb.
(Sun, 27 Oct 2024 21:09:01 GMT) (full text, mbox, link).
Acknowledgement sent
to Otto Kekäläinen <otto@debian.org>:
Extra info received and forwarded to list. Copy sent to Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>.
(Sun, 27 Oct 2024 21:09:01 GMT) (full text, mbox, link).
Message #30 received at 1084293@bugs.debian.org (full text, mbox, reply):
On Sun, 27 Oct 2024 at 20:58, Santiago Vila <sanvila@debian.org> wrote: > > El 27/10/24 a las 21:09, Otto Kekäläinen escribió: > > 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. > > Hi. The relevant changes are in the tzdata package. > This is from the changelog: > > * Upstream obsoleted the System V names CET, CST6CDT, EET, EST*, HST, MET, > MST*, PST8PDT, and WET. They are symlinks now. Move those zones to > tzdata-legacy and update /etc/localtime on package update to the new names. > Please use Etc/GMT* in case you want to avoid DST changes. > > If you are lucky, an additional build-depends on tzdata-legacy might fix > some tests which broke. However, if those zones are considered obsolete, > you might want to consider obsoleting the matching test as well. > > Hope this helps. > > [ Disclaimer: I'm just a casual observer of packages which FTBFS ] Thanks Santiago for pulling up the changelog from tzdata. However, this still does not make sense as the time zones CET, MET (and EET for example) are still widely used and there are no replacements advertised on Wikipedia on IANA or other sites I checked.
Information forwarded
to debian-bugs-dist@lists.debian.org, Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>:
Bug#1084293; Package src:mariadb.
(Sun, 27 Oct 2024 21:21:01 GMT) (full text, mbox, link).
Acknowledgement sent
to Santiago Vila <sanvila@debian.org>:
Extra info received and forwarded to list. Copy sent to Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>.
(Sun, 27 Oct 2024 21:21:01 GMT) (full text, mbox, link).
Message #35 received at 1084293@bugs.debian.org (full text, mbox, reply):
El 27/10/24 a las 22:07, Otto Kekäläinen escribió: >> If you are lucky, an additional build-depends on tzdata-legacy might fix >> some tests which broke. However, if those zones are considered obsolete, >> you might want to consider obsoleting the matching test as well. >> >> Hope this helps. >> >> [ Disclaimer: I'm just a casual observer of packages which FTBFS ] > > Thanks Santiago for pulling up the changelog from tzdata. However, > this still does not make sense as the time zones CET, MET (and EET for > example) are still widely used and there are no replacements > advertised on Wikipedia on IANA or other sites I checked. That's why I included a disclaimer in my answer :-) What I meant: I'm no expert on tzdata issues, it just seemed that you missed that the breakage was triggered by tzdata changes. I suggest asking the tzdata maintainers, or maybe reading this report first, where the effects of this tzdata change are discussed: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1084190 Thanks.
Information forwarded
to debian-bugs-dist@lists.debian.org, Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>:
Bug#1084293; Package src:mariadb.
(Sun, 03 Nov 2024 07:24:02 GMT) (full text, mbox, link).
Acknowledgement sent
to Otto Kekäläinen <otto@debian.org>:
Extra info received and forwarded to list. Copy sent to Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>.
(Sun, 03 Nov 2024 07:24:02 GMT) (full text, mbox, link).
Message #40 received at 1084293@bugs.debian.org (full text, mbox, reply):
For the record, this issue is no longer visible on amd64 autopkgtests at https://salsa.debian.org/mariadb-team/mariadb-server/-/pipelines/756431 nor at https://ci.debian.net/packages/m/mariadb/, only armhf and that probably only because the arch is dropping jobs and no rerunning the test despite the explicit request I submitted yesterday.
Information forwarded
to debian-bugs-dist@lists.debian.org, Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>:
Bug#1084293; Package src:mariadb.
(Sat, 09 Nov 2024 17:03:02 GMT) (full text, mbox, link).
Acknowledgement sent
to "Rebecca N. Palmer" <rebecca_palmer@zoho.com>:
Extra info received and forwarded to list. Copy sent to Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>.
(Sat, 09 Nov 2024 17:03:02 GMT) (full text, mbox, link).
Message #45 received at 1084293@bugs.debian.org (full text, mbox, reply):
The newer runs don't fail because this test is skipped. The messages suggest that it fails if MET and CET are aliases of Europe/Brussels and hence both print as CET (as they are in tzdata 2024b-1 and -2, and in -3 with tzdata-legacy) but is skipped if MET isn't installed at all (tzdata 2024b-3 without tzdata-legacy). Hence, this bug is no longer RC. Actually fixing it would plausibly mean using TZ=Europe/Brussels and expecting it to print as CET.
Information forwarded
to debian-bugs-dist@lists.debian.org, Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>:
Bug#1084293; Package src:mariadb.
(Sat, 09 Nov 2024 17:42:01 GMT) (full text, mbox, link).
Acknowledgement sent
to Santiago Vila <sanvila@debian.org>:
Extra info received and forwarded to list. Copy sent to Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>.
(Sat, 09 Nov 2024 17:42:02 GMT) (full text, mbox, link).
Message #50 received at 1084293@bugs.debian.org (full text, mbox, reply):
severity 1084293 normal thanks Downgrading because (as pointed out by Rebecca) this currently does not seem to happen. I'm curious to know if this will really never happen again or maybe it will happen during six months in a year (or some weird time-related condition), in the last case I would still consider it to be RC. Thanks.
Severity set to 'normal' from 'serious'
Request was from Santiago Vila <sanvila@debian.org>
to control@bugs.debian.org.
(Sat, 09 Nov 2024 17:42:02 GMT) (full text, mbox, link).
Information forwarded
to debian-bugs-dist@lists.debian.org, Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>:
Bug#1084293; Package src:mariadb.
(Sat, 09 Nov 2024 17:48:01 GMT) (full text, mbox, link).
Acknowledgement sent
to Santiago Vila <sanvila@debian.org>:
Extra info received and forwarded to list. Copy sent to Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>.
(Sat, 09 Nov 2024 17:48:02 GMT) (full text, mbox, link).
Message #57 received at 1084293@bugs.debian.org (full text, mbox, reply):
Rebecca wrote: > The newer runs don't fail because this test is skipped. The messages > suggest that it fails if MET and CET are aliases of Europe/Brussels and > hence both print as CET (as they are in tzdata 2024b-1 and -2, and in -3 > with tzdata-legacy) but is skipped if MET isn't installed at all (tzdata > 2024b-3 without tzdata-legacy). Note: If it's the case that this package with additional packages installed (not in the build-depends) would ftbfs, then we would have a case for build-conflicts. (But build-conflicts are ugly and it's better to find a way so that the package builds ok regardless of the extra package being present or not). Thanks.
Information forwarded
to debian-bugs-dist@lists.debian.org, Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>:
Bug#1084293; Package src:mariadb.
(Sat, 09 Nov 2024 21:42:01 GMT) (full text, mbox, link).
Acknowledgement sent
to "Rebecca N. Palmer" <rebecca_palmer@zoho.com>:
Extra info received and forwarded to list. Copy sent to Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>.
(Sat, 09 Nov 2024 21:42:01 GMT) (full text, mbox, link).
Message #62 received at 1084293@bugs.debian.org (full text, mbox, reply):
[Message part 1 (text/plain, inline)]
Control: tags -1 patch
I don't think this is related to the time of build; I don't expect it to
start failing again unless the MET timezone alias starts being installed
again (i.e. something adds a tzdata-legacy dependency or the aliases get
moved back to tzdata).
However, it appears to be easy to actually fix, so I suggest we do so.
Warning: this patch has not been tested.
Description: Stop using MET timezone name
From tzdata 2024b-1, MET is an alias for Europe/Brussels (printed as
CET, failing this test); from 2024b-3, it is moved to tzdata-legacy.
Author: Rebecca N. Palmer <rebecca_palmer@zoho.com>
Bug-Debian: https://bugs.debian.org/1084293
--- mariadb-11.4.3.orig/mysql-test/main/timezone-master.opt
+++ mariadb-11.4.3/mysql-test/main/timezone-master.opt
@@ -1 +1 @@
---timezone=MET
+--timezone=Europe/Brussels
--- mariadb-11.4.3.orig/mysql-test/main/timezone.result
+++ mariadb-11.4.3/mysql-test/main/timezone.result
@@ -1,6 +1,6 @@
show variables like "system_time_zone";
Variable_name Value
-system_time_zone MET
+system_time_zone CET
#
# Test unix timestamp
#
@@ -82,7 +82,7 @@ alter table mysql.time_zone_transition_t
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
--- mariadb-11.4.3.orig/mysql-test/main/timezone.test
+++ mariadb-11.4.3/mysql-test/main/timezone.test
@@ -1,6 +1,6 @@
#
# Test of SYSTEM time zone handling ( for my_system_gmt_sec()).
-# This script must be run with TZ=MET
+# This script must be run with a CET timezone e.g. TZ=Europe/Brussels
-- require include/have_met_timezone.require
disable_query_log;
@@ -8,7 +8,7 @@ select FROM_UNIXTIME(24*3600);
enable_query_log;
# The following is because of daylight saving time
---replace_result MEST MET
+--replace_result CEST CET
show variables like "system_time_zone";
--echo #
[1084293-no-timezone-alias.patch (text/x-diff, attachment)]
Added tag(s) patch.
Request was from "Rebecca N. Palmer" <rebecca_palmer@zoho.com>
to 1084293-submit@bugs.debian.org.
(Sat, 09 Nov 2024 21:42:01 GMT) (full text, mbox, link).
Information forwarded
to debian-bugs-dist@lists.debian.org, Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>:
Bug#1084293; Package src:mariadb.
(Sun, 10 Nov 2024 02:33:01 GMT) (full text, mbox, link).
Acknowledgement sent
to Otto Kekäläinen <otto@debian.org>:
Extra info received and forwarded to list. Copy sent to Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>.
(Sun, 10 Nov 2024 02:33:01 GMT) (full text, mbox, link).
Message #69 received at 1084293@bugs.debian.org (full text, mbox, reply):
Hi! Thanks for the patch Rebecca. Would you like to submit it directly upstream in https://jira.mariadb.org/browse/MDEV-35088 or at github.com/mariadb/server?
Send a report that this bug log contains spam.
Debbugs is free software and licensed under the terms of the GNU Public License version 2. The current version can be obtained from https://bugs.debian.org/debbugs-source/.
Copyright © 1999 Darren O. Benham, 1997,2003 nCipher Corporation Ltd, 1994-97 Ian Jackson, 2005-2017 Don Armstrong, and many other contributors.