mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2026-03-04 15:38:41 +01:00
Code Issues Projects Releases Packages Wiki Activity
mariadb/mysql-test/suite/sysschema/r
History
Exact
Kristian Nielsen 53468695ad MDEV-38776 [ERROR] Slave worker thread retried transaction 10 time(s) in vain, giving up 
Partially revert this commit:

commit 6a1cb449fe
Author: Sergei Golubchik <serg@mariadb.org>
Date:   Mon Jan 18 18:02:16 2021 +0100

    cleanup: remove slave background thread, use handle_manager thread instead

This restores running the parallel replication deadlock killing in its own
dedicated thread, not in the manager thread shared with other unrelated
processing.

When a parallel replication conflict is detected, multiple threads can be
waiting for each other, potentially in a loop. It is critical for
correctness (as well as performance) that the blocking thread is killed
immediately to allow other threads to continue. If one of the threads being
blocked was the manager thread itself in some unrelated job, the kill could
end up being blocked indefinitely, causing replication to hang, usually
eventually timing out on innodb_lock_wait_timeout and failing replication
with an error like:

[ERROR] Slave worker thread retried transaction 10 time(s) in vain, giving up

Signed-off-by: Kristian Nielsen <knielsen@knielsen-hq.org>
2026-02-09 02:11:23 +01:00
..
all_sys_objects_exist.result MDEV-24486 Rename the view sys.table_privileges to sys.privileges_by_table_by_level 2023-12-08 19:29:02 +03:00
fn_extract_schema_from_file_name.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
fn_extract_table_from_file_name.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
fn_format_bytes.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
fn_format_path.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
fn_format_statement.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
fn_format_time.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
fn_list_add.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
fn_list_drop.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
fn_ps_is_account_enabled.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
fn_ps_is_consumer_enabled.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
fn_ps_is_instrument_default_enabled.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
fn_ps_is_instrument_default_timed.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
fn_ps_is_thread_instrumented.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
fn_ps_thread_account.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
fn_ps_thread_id.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
fn_ps_thread_trx_info.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
fn_quote_identifier.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
fn_sys_get_config.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
mysqldump.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
optimizer_switch.result Merge branch '11.2' into 11.3 2023-11-14 18:33:03 +01:00
pr_create_synonym_db.result MDEV-28343: sys.create_synonym_db fails with ER_VIEW_SELECT_TMPTABLE when schema contains temporary tables 2023-08-11 19:36:21 +02:00
pr_diagnostics.result MDEV-32104 remove deprecated features 2023-09-30 14:43:12 +02:00
pr_execute_prepared_stmt.result Merge 10.5 into 10.6 2022-09-20 16:53:20 +03:00
pr_ps_setup_reset_to_default.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
pr_ps_setup_show_disabled.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
pr_ps_setup_show_disabled_consumers.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
pr_ps_setup_show_disabled_instruments.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
pr_ps_setup_show_enabled.result MDEV-38776 [ERROR] Slave worker thread retried transaction 10 time(s) in vain, giving up 2026-02-09 02:11:23 +01:00
pr_ps_setup_show_enabled_consumers.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
pr_ps_setup_show_enabled_instruments.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
pr_ps_trace_statement_digest.result Merge 10.5 into 10.6 2022-09-20 16:53:20 +03:00
pr_statement_performance_analyzer.result Added test cases for preceding test 2023-02-03 00:00:35 +03:00
pr_table_exists.result MDEV-12459 Patch sysschema 2023-08-11 19:36:21 +02:00
t_sys_config.result MDEV-26925 add test that there are no triggers in sys schema. 2021-12-16 19:16:04 +01:00
v_host_summary.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_host_summary_by_file_io.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_host_summary_by_file_io_type.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_host_summary_by_stages.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_host_summary_by_statement_latency.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_host_summary_by_statement_type.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_innodb_buffer_stats_by_schema.result MDEV-37083: Fixed type mismatch in sys views 2025-07-25 17:02:59 +05:30
v_innodb_buffer_stats_by_table.result MDEV-37083: Fixed type mismatch in sys views 2025-07-25 17:02:59 +05:30
v_innodb_lock_waits.result 10.6 tests for MDEV-26507 Assertion `tmp != ((long long) 0x8000000000000000LL)' failed in TIME_from_longlong_datetime_packed 2022-04-10 14:46:24 +04:00
v_io_by_thread_by_latency.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_io_global_by_file_by_bytes.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
v_io_global_by_file_by_latency.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_io_global_by_wait_by_bytes.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_io_global_by_wait_by_latency.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_latest_file_io.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_memory_by_host_by_current_bytes.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
v_memory_by_thread_by_current_bytes.result MDEV-24312 master_host has 60 character limit, increase to 255 bytes 2021-04-20 16:36:56 +02:00
v_memory_by_user_by_current_bytes.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
v_memory_global_by_current_bytes.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
v_memory_global_total.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
v_metrics.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
v_privileges_by_table_by_level.result MDEV-24486 Rename the view sys.table_privileges to sys.privileges_by_table_by_level 2023-12-08 19:29:02 +03:00
v_processlist.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_ps_check_lost_instrumentation.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
v_ps_digest_95th_percentile_by_avg_us.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
v_ps_digest_avg_latency_distribution.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
v_ps_schema_table_statistics_io.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
v_schema_auto_increment_columns.result Merge branch '10.5' into 10.6 2022-02-03 17:01:31 +01:00
v_schema_index_statistics.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_schema_object_overview.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
v_schema_redundant_indexes.result Added test cases for preceding test 2023-02-03 00:00:35 +03:00
v_schema_table_lock_waits.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
v_schema_table_statistics.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_schema_table_statistics_with_buffer.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_schema_tables_with_full_table_scans.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_schema_unused_indexes.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
v_session.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_session_ssl_status.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
v_statement_analysis.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_statements_with_errors_or_warnings.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00
v_statements_with_full_table_scans.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_statements_with_runtimes_in_95th_percentile.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_statements_with_sorting.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_statements_with_temp_tables.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_user_summary.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_user_summary_by_file_io.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_user_summary_by_file_io_type.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_user_summary_by_stages.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_user_summary_by_statement_latency.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_user_summary_by_statement_type.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_version.result MDEV-24486 Add table_privileges view to the sys schema 2023-12-05 11:42:47 +03:00
v_wait_classes_global_by_avg_latency.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_wait_classes_global_by_latency.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_waits_by_host_by_latency.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_waits_by_user_by_latency.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
v_waits_global_by_latency.result MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
version_functions.result MDEV-9077 - sysschema test suite. 2021-03-18 08:02:48 +01:00