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] org.yb.pgsql.TestPgRegressAnalyze.testPgRegressAnalyze- Unit test failure #23652

Closed
1 task done
shishir2001-yb opened this issue Aug 27, 2024 · 0 comments
Closed
1 task done
Assignees
Labels
area/ysql Yugabyte SQL (YSQL) kind/bug This issue is a bug priority/medium Medium priority issue status/awaiting-triage Issue awaiting triage

Comments

@shishir2001-yb
Copy link

shishir2001-yb commented Aug 27, 2024

Jira Link: DB-12563

Description

org.yb.pgsql.TestPgRegressAnalyze.testPgRegressAnalyze:

This test started failing in after this commit.Not sure with what error it has failed.

Analyze Trends

java.lang.AssertionError: pg_regress exited with error code: 1, failed tests: [yb_reset_analyze]

Issue Type

kind/bug

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

  • I confirm this issue does not contain any sensitive information.
@shishir2001-yb shishir2001-yb added area/ysql Yugabyte SQL (YSQL) status/awaiting-triage Issue awaiting triage labels Aug 27, 2024
@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue labels Aug 27, 2024
@shishir2001-yb shishir2001-yb assigned mtakahar and unassigned min-yb Aug 27, 2024
mtakahar added a commit that referenced this issue Sep 10, 2024
…failure on TSAN build

Summary:
* Split off yb_reset_analyze tests from TestPgRegressAnalyze.java and create the .java file of its own.
* Speed up some of the operations in `yb_reset_analyze_statistics.sql`:
  * Add `NONCONCURRENTLY` to `CREATE INDEX` statements for speed up.
  * Explicitly set `yb_enable_optimizer_statistics` and `yb_enable_base_scans_cost_model` to ON via `ALTER DATABASE` to make the optimizer's behavior more predictable with the tables analyzed and unanalyzed.
  * Rewrite the stats comparison query to be executed more efficiently by using FULL JOIN instead of EXCEPT/UNION ALL set operations.
* Use the `WITH (FORCE)` option for dropping the `reset_analyze_test` database to avoid intermittent "database xxx is being accessed by other users" error right after reconnected as another user or hitting the timeout during the `DROP DATABASE` command.
Jira: DB-12563

Test Plan:
  ./yb_build.sh --java-test 'org.yb.pgsql.TestPgRegressResetAnalyze'
  ./yb_build.sh --java-test 'org.yb.pgsql.TestPgRegressAnalyze'

Jenkins: build type: tsan
Jenkins: test regex: .*testPgRegress.*Analyze.*

Reviewers: tnayak

Reviewed By: tnayak

Subscribers: smishra, yql, svc_phabricator

Differential Revision: https://phorge.dev.yugabyte.com/D37582
jasonyb pushed a commit that referenced this issue Sep 12, 2024
Summary:
 f5ad1fb [#23855] Fixing the calculation of automatic refactoring count.
 eed826d [#22519] YSQL: Move ExplicitRowLockBuffer class into separate file
 99a27e6 [PLAT-14522] Taking yba-ctl backups with prometheus HTTPS
 e2a84b0 [PLAT-15044] Add preflight check for node addition in provider
 7e40d89 [#20769] XCluster: Dynamically apply cdc_wal_retention_time_secs for XCluster
 aa41478 [#23858] build: fix ./yb_build.sh release --gcc11
 bcf7f47 [PLAT-13910] Improve IAM credentials fetch logging and add retries
 303a202 [#23778] xCluster: Remove the capability to rename xCluster replication groups
 Excluded: 58fd26e [#23652] YSQL: Fix TestPgRegressAnalyze.java timeout / database drop failure on TSAN build
 31da65b [doc] yb_enable_bitmapscan flag (#23854)
 798db14 [#20335] DocDB: Use MonoClock for write query metric
 80779d8 [#23860] xCluster: Add automatic ddl mode proto fields
 afd763d Revert "Revert "[PLAT-14786] Add support to node_agent install to use bind ip and node_external_fqdn""
 e86951a [#23841] docdb: Disable stack trace tracking in TSAN builds
 d600608 [PLAT-15244] Fix schedule not getting updated on edit schedule API call
 3c0df09 [PLAT-15214][PLAT-15232]YBC version upgrade to 2.2.0.0-b6 and enable YBC verbose by default
 aa7372e [#23478] YSQL: fix connection manager session variable case sensitivity issue
 0d53558 [PLAT-14810][PLAT-14811][YBA CLI] Support adding and editing EIT configurations
 ffa537e [PLAT-10706][dr] Support retry-ability of failover and switchover
 Excluded: 5ae4558 [#23578] YSQL: Add HELP and TYPE to :13000/prometheus-metrics
 3aa7459 [PLAT-15016] Handle gflag_group changes for ENHANCED_PG_COMPATIBILITY group in 2024.1.3
 c89356c [PLAT-10592][YBA] Changes to support global tserver/master service in K8s
 7fc3b76 [#3893] YCQL: Align 2 system_schema.* tables with Cassandra
 da6274e [23646] Test Stability: Fix PgMiniTest.FollowerReads
 5fa6dc9 [PLAT-15180][Platform][UI][PITR]Create Restore Backup modal
 be0d1d1 [PLAT-15247][Platform][Backup]Create Backup scheduled policy List

Test Plan: Jenkins: rebase: pg15-cherrypicks

Reviewers: jason, tfoucher

Subscribers: yql

Differential Revision: https://phorge.dev.yugabyte.com/D37981
mtakahar added a commit that referenced this issue Sep 12, 2024
…va timeout / database drop failure on TSAN build

Summary:
Original commit: 58fd26e / D37582

- src/postgres/src/test/regress/expected/yb_reset_analyze.out:
  - conflict resolution: take changes from both branches:
    - YB master 58fd26e: ALTER DATABASE set the guc flags to enable CBO
    - YB pg15 602cb2d: grant access permission to the test users

Jira: DB-12563

Test Plan:
  ./yb_build.sh --java-test 'org.yb.pgsql.TestPgRegressResetAnalyze'
  ./yb_build.sh --java-test 'org.yb.pgsql.TestPgRegressAnalyze'

Jenkins: build type: tsan
Jenkins: test regex: .*testPgRegress.*Analyze.*

Reviewers: jason, tfoucher

Reviewed By: jason

Subscribers: svc_phabricator, yql, smishra

Differential Revision: https://phorge.dev.yugabyte.com/D37989
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/ysql Yugabyte SQL (YSQL) kind/bug This issue is a bug priority/medium Medium priority issue status/awaiting-triage Issue awaiting triage
Projects
None yet
Development

No branches or pull requests

4 participants