Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[YSQL] flaky test PgIndexBackfillTest.CreateIndexSimultaneously #21824

Open
1 task done
jasonyb opened this issue Apr 4, 2024 · 0 comments
Open
1 task done

[YSQL] flaky test PgIndexBackfillTest.CreateIndexSimultaneously #21824

jasonyb opened this issue Apr 4, 2024 · 0 comments
Labels
area/ysql Yugabyte SQL (YSQL) help wanted We welcome your contributions for this issue! kind/failing-test Tests and testing infra priority/medium Medium priority issue status/awaiting-triage Issue awaiting triage

Comments

@jasonyb
Copy link
Contributor

jasonyb commented Apr 4, 2024

Jira Link: DB-10724

Description

According to (internal link) https://detective.dev.yugabyte.com/stability/test?branch=master&class=PgIndexBackfillTest&name=CreateIndexSimultaneously&num_fails=300, it appears this test started failing with the following message around 10/27/2021 04:38:

../../src/yb/yql/pgwrapper/pg_index_backfill-test.cc:627
Value of: std::find_if( std::begin(allowed_msgs), std::end(allowed_msgs), [&msg] (const std::string allowed_msg) { return msg.find(allowed_msg) != std::string::npos; }) != std::end(allowed_msgs)
  Actual: false
Expected: true
Network error (yb/yql/pgwrapper/libpq_utils.cc:219): Execute of 'CREATE INDEX iii ON ttt (i)' failed: 7, message: ERROR:  Operation expired: Transaction 246ab4cf-2617-48c4-b156-a23982d92675 expired or aborted by a conflict: 40001
 (pgsql error 40001)

This issue still exists today. Possible cause is commit 888c0d6, but I don't have much confidence in that. Fix seems to be adding "expired or aborted by conflict" to the list of allowed messages, as is done for a different test in the same file.

Issue Type

kind/failing-test

Warning: Please confirm that this issue does not contain any sensitive information

  • I confirm this issue does not contain any sensitive information.
@jasonyb jasonyb added help wanted We welcome your contributions for this issue! area/ysql Yugabyte SQL (YSQL) status/awaiting-triage Issue awaiting triage labels Apr 4, 2024
@yugabyte-ci yugabyte-ci added kind/failing-test Tests and testing infra priority/medium Medium priority issue labels Apr 4, 2024
jasonyb pushed a commit that referenced this issue Apr 23, 2024
Summary:
According to issue #21824, this test is flaky on master.  It is also
flaky on pg15.  Remove it from pg15_tests/passing_tests.tsv.

Test Plan: Jenkins: skip

Reviewers: aagrawal, tfoucher

Reviewed By: tfoucher

Subscribers: yql

Differential Revision: https://phorge.dev.yugabyte.com/D34437
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/ysql Yugabyte SQL (YSQL) help wanted We welcome your contributions for this issue! kind/failing-test Tests and testing infra priority/medium Medium priority issue status/awaiting-triage Issue awaiting triage
Projects
None yet
Development

No branches or pull requests

2 participants