Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.5.28, 11.6.2, 11.8.0
-
None
Description
--view-protocol MTR tests were added for the last-N-failed debug builder in BuildBot since 19.11.2024
https://mariadb.zulipchat.com/#narrow/channel/236699-Buildbot/topic/BuildBot.20Production.20deployment.20.7C.2019.2E11.2E2024
It was observed that spider tests always fail on the debug-view step, below are a couple of revisions where spider test fails were observed.
Build: https://buildbot.mariadb.org/#/builders/728/builds/1860 |
Branch: "bb-10.5-bar-MDEV-21029" |
MariaDB Version: mariadb-10.5.28 |
Build Type: Debug
|
Test Type: --view-protocol
|
|
|
Failing test(s):
|
spider/bugfix.mdev_31645
|
spider/regression/e1121.load_data_local_ignore_ddi1
|
spider/regression/e112122.load_data_part_ddi0
|
spider/regression/e112122.load_data_part_local_ddi1
|
|
|
--------------------------------------------------------------------------------------------
|
--------------------------------------------------------------------------------------------
|
|
|
Build: https://buildbot.mariadb.org/#/builders/728/builds/1858 |
Branch: "refs/pull/3485/merge" |
MariaDB Version: mariadb-10.5.28 |
Build Type: Debug
|
Test Type: --view-protocol
|
|
|
Failing test(s):
|
spider/bugfix.mdev_31645
|
spider/regression/e1121.load_data_local_ignore_ddi1
|
spider/regression/e112122.load_data_part_ddi0
|
spider/regression/e112122.load_data_part_local_ddi1
|
|
|
--------------------------------------------------------------------------------------------
|
--------------------------------------------------------------------------------------------
|
|
|
Build: https://buildbot.mariadb.org/#/builders/728/builds/1839 |
Branch: "refs/pull/3641/merge" |
MariaDB Version: mariadb-11.8.0 |
Build Type: Debug
|
Test Type: --view-protocol
|
|
|
Failing test(s):
|
spider/bg.basic_sql
|
spider/bugfix.perfschema
|
spider/bugfix.index
|
spider/bugfix.mdev_31338
|
spider/bugfix.direct_sql_with_comma_pwd
|
spider/bg.ha spider/bugfix.checksum_table_with_quick_mode_3
|
spider/bugfix.cp932_column
|
spider/bugfix.direct_sql_with_tmp_table
|
spider/bugfix.delete_with_float_column_mysql
|
spider/bugfix.delete_with_float_column_default
|
spider/bugfix.delete_with_float_column_mariadb
|
spider/bugfix.mdev_19866
|
spider/bugfix.group_by_order_by_limit
|
spider/bugfix.mdev_20100
|
spider/bugfix.insert_select
|
spider/bugfix.mdev_21884
|
spider/bugfix.mdev_20502
|
spider/bugfix.mdev_26345
|
spider/bg.ha_part
|
|
|
--------------------------------------------------------------------------------------------
|
--------------------------------------------------------------------------------------------
|
|
|
Build: https://buildbot.mariadb.org/#/builders/728/builds/1835 |
Branch: bb-11.7-check-table |
MariaDB Version: mariadb-11.6.2 |
Build Type: Debug
|
Test Type: --view-protocol
|
|
|
Failing test(s):
|
spider/bg.basic_sql
|
spider/bugfix.perfschema
|
spider/bugfix.index
|
spider/bugfix.mdev_31338
|
spider/bugfix.direct_sql_with_comma_pwd
|
spider/bg.ha spider/bugfix.checksum_table_with_quick_mode_3
|
spider/bugfix.cp932_column
|
spider/bugfix.direct_sql_with_tmp_table
|
spider/bugfix.mdev_20502 spider/bugfix.insert_select
|
spider/bugfix.delete_with_float_column_default
|
spider/bugfix.delete_with_float_column_mariadb
|
spider/bugfix.delete_with_float_column_mysql
|
spider/bugfix.mdev_19866 spider/bugfix.mdev_20100
|
spider/bugfix.group_by_order_by_limit
|
spider/bugfix.mdev_21884 spider/bg.ha_part
|
spider/bugfix.quick_mode_0
|
|
Attachments
Issue Links
- blocks
-
-
- Open
-
- includes
-
-
- Closed
-
-
-
- Stalled
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Stalled
-
-
-
- Stalled
-
-
-
- Stalled
-
-
-
- Stalled
-
- is part of
-
MDEV-27691
make working view-protocol
-
- Closed
-
Activity
danblack has pushed a revert of debug-view in last-n builders https://github.com/MariaDB/buildbot/pull/623
So this issue is now used to track fixing spider view-protocol testing failures.
Coincidentally, testing with --cursor-protocol passes all spider tests in 10.5, with or without --disable_view_protocol
All failures have their corresponding issues created as part of this issue. Most (currently 7) of them are pushed or under review, covering the majority of the failures. The remaining (currently 4) issues deal with (currently 9) remaining failing tests.
Ran the whole spider suite at 10.5 32962ea2532ee78bc99d8da950348ba01d38a23b - about half failed:
Logging: /home/ycp/source/mariadb-server/10.5/src/mysql-test/mysql-test-run.pl --suite spider,spider/*,spider/*/* --skip-test=spider/oracle.*|spider/temp.*|.*/t\..* --parallel=6 --big-test --force --max-test-fail=0 --view-protocol...Completed: Failed 109/223 tests, 51.12% were successful.Failing test(s): spider/bugfix.mdev_31338 spider/bg.basic_sql spider/bugfix.mdev_33434 spider/bugfix.checksum_table_with_quick_mode_3 spider/bugfix.cp932_column spider/bugfix.mdev_26345 spider/bugfix.direct_sql_with_comma_pwd spider/bugfix.delete_with_float_column_mariadb spider/bg.ha spider/bugfix.delete_with_float_column_mysql spider/bugfix.direct_sql_with_tmp_table spider/bugfix.insert_select spider/bg.ha_part spider/bugfix.group_by_order_by_limit spider/bugfix.mdev_19866 spider/bugfix.mdev_20502 spider/bugfix.mdev_34003 spider/bugfix.mdev_20100 spider/bugfix.mdev_21884 spider/bugfix.mdev_29002 spider/bugfix.mdev_29163 spider/bugfix.mdev_27172 spider/bugfix.mdev_29008 spider/bugfix.quick_mode_0 spider/bugfix.quick_mode_2 spider/bugfix.quick_mode_1 spider/bugfix.return_found_rows_update spider/bugfix.quick_mode_3 spider/bugfix.select_by_null spider/bugfix.select_with_backquote spider/bugfix.return_found_rows_insert spider/bugfix.slave_trx_isolation spider/bugfix.sql_mode_mariadb spider/bugfix.sql_mode_mysql spider/bugfix.udf_mysql_func_early spider/bugfix.udf_mysql_func_early_init_file spider/bugfix.wrapper_mariadb spider/feature.pushdown_case spider/bugfix.strict_group_by spider/feature.checksum_table_parallel_no_opt spider/feature.checksum_table_parallel_extended spider/bugfix.xa_cmd spider/feature.checksum_table_parallel_quick spider.auto_increment spider/handler.basic_sql spider.direct_right_join spider.direct_right_join_nullable spider.partition_fulltext spider.direct_right_left_join_nullable spider.basic_sql spider.partition_join_pushdown_for_single_partition spider.direct_right_left_right_join_nullable spider.checksum_table_with_quick_mode_3 spider.pushdown_not_like spider.quick_mode_0 spider/handler.ha spider.direct_join spider.quick_mode_1 spider/handler.ha_part spider.ha spider.quick_mode_2 spider.direct_join_using spider.ha_part spider.quick_mode_3 spider.direct_left_join spider.partition_cond_push spider.slave_trx_isolation spider.direct_left_join_nullable spider/regression/e1121.load_data_local_ddi0 spider/regression/e1121.direct_join_by_pkey_key spider.direct_left_right_join_nullable spider/regression/e1121.load_data_local_ddi1 spider.timestamp spider/regression/e1121.direct_join_by_pkey_pkey spider/regression/e1121.load_data_local_ignore_ddi0 spider/regression/e1121.load_data_ddi0 spider.direct_left_right_left_join_nullable spider.udf_pushdown spider/regression/e1121.load_data_local_ignore_ddi1 spider/regression/e1121.load_data_ddi1 spider/regression/e1121.load_data_local_replace_ddi1 spider/regression/e1121.load_data_local_replace_ddi0 spider/regression/e1121.load_data_ignore_ddi0 spider/regression/e1121.load_data_replace_ddi0 spider/regression/e112122.group_by_order_by_limit_ok spider/regression/e112122.load_data_part_ignore_ddi1 spider/regression/e1121.load_data_ignore_ddi1 spider/regression/e1121.load_data_replace_ddi1 spider/regression/e112122.load_data_part_local_ignore_ddi0 spider/regression/e112122.load_data_part_ddi0 spider/regression/e112122.load_data_part_local_ddi0 spider/regression/e112122.load_data_part_local_replace_ddi1 spider/regression/e112122.load_data_part_replace_ddi0 spider/regression/e112122.load_data_part_local_ddi1 spider/regression/e112122.load_data_part_ddi1 spider/regression/e112122.load_data_part_local_ignore_ddi1 spider/regression/e112122.load_data_part_ignore_ddi0 spider/regression/e112122.load_data_part_replace_ddi1 spider/regression/e112122.load_data_part_local_replace_ddi0 spider/bugfix.mdev_29502 spider/bugfix.mdev_29962 spider/bugfix.mdev_30392 spider/bugfix.mdev_30408 spider/bugfix.mdev_30727 spider/bugfix.mdev_31645 spider/bugfix.mdev_34659 spider/bugfix.subquery spider/bugfix.mdev_34555 spider/bugfix.mdev_29352