[MDEV-35452] Always failing spider tests on Debug Last-N builder with --view-protocol - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 11.6.2, 11.8.0, 10.5.28
Fix Version/s: N/A
Component/s: Storage Engine - Spider
Labels:
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

MDBF-822 Deploy debug-view in last-N-builders

Open

includes

MDEV-36307 group by handler missing constant fields when selecting from a view

Closed

MDEV-36324 The untested ha_spider::index_first_internal constructs broken queries

Closed

MDEV-36335 Tests calling the udf spider_copy_tables fail with --view-protocol

Closed

MDEV-36441 Spider tests fail with extra warnings about same server when run with --view-protocol

Closed

MDEV-36442 spider tests with --view-protocol fail with diff SELECT argument FROM mysql.general_log ...

Closed

MDEV-36452 Column name output in --view-protocol spider tests with udf and CASE

Closed

MDEV-36454 spider tests wrong count of spider_direct_aggregate when run with --view-protocol

Closed

MDEV-36476 Spider tests hanging with --view-protocol

Closed

MDEV-36477 Spider tests with view protocol fail with "Failed to drop view: 0: "

Closed

MDEV-36478 spider basic_sql tests with view protocol fail with mismatching found_rows() output

Closed

MDEV-36633 spider/bugfix.mdev_33434 fails with --view-protocol

Closed

is part of

MDEV-27691 make working view-protocol

Closed

(7 includes, 1 is part of)

Activity

People

Assignee:: Yuchen Pei

Reporter:: Varzaru Razvan-Liviu

Votes:: 1 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2024-11-20 09:40

Updated:: 2025-05-02 00:29

Resolved:: 2025-04-28 06:32

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server