You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudberry.apache.org by av...@apache.org on 2024/12/26 07:23:32 UTC
(cloudberry) branch main updated: Add xmin, xmax in test cases for troubleshooting flakiness.
This is an automated email from the ASF dual-hosted git repository.
avamingli pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/cloudberry.git
The following commit(s) were added to refs/heads/main by this push:
new 31fe0c159a Add xmin, xmax in test cases for troubleshooting flakiness.
31fe0c159a is described below
commit 31fe0c159ab970ac2e86c729ff61f048b1204f32
Author: Zhang Mingli <av...@gmail.com>
AuthorDate: Mon Dec 23 16:49:09 2024 +0800
Add xmin, xmax in test cases for troubleshooting flakiness.
Add xmin, xmax to the relevant test cases to help identify
potential transaction-related differences that may be causing
intermittent test failures. This change is a preliminary step to
investigate the flaky behavior observed over the past few weeks.
The output will be helpful address any underlying issues.
Authored-by: Zhang Mingli avamingli@gmail.com
---
src/test/regress/expected/bfv_meta_track.out | 70 +++++++++++++++-------------
src/test/regress/sql/bfv_meta_track.sql | 28 ++++++-----
2 files changed, 54 insertions(+), 44 deletions(-)
diff --git a/src/test/regress/expected/bfv_meta_track.out b/src/test/regress/expected/bfv_meta_track.out
index df4e58d8a4..8a68d45d1b 100644
--- a/src/test/regress/expected/bfv_meta_track.out
+++ b/src/test/regress/expected/bfv_meta_track.out
@@ -2,14 +2,17 @@
--CBDB GITHUB ISSUE:
--https://github.com/cloudberrydb/cloudberrydb/issues/504
--
+-- start_ignore
+drop schema if exists bfv_meta_track;
+-- end_ignore
create schema bfv_meta_track;
set search_path to bfv_meta_track;
-select count(*) from pg_stat_last_operation join
+select staactionname, stasubtype, nspname from pg_stat_last_operation join
pg_namespace on pg_namespace.oid = pg_stat_last_operation.objid
where pg_namespace.nspname = 'bfv_meta_track';
- count
--------
- 1
+ staactionname | stasubtype | nspname
+---------------+------------+----------------
+ CREATE | SCHEMA | bfv_meta_track
(1 row)
-- test drop popicy
@@ -17,44 +20,45 @@ create table t1(a int);
NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Cloudberry Database data distribution key for this table.
HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew.
create policy p1 on t1 using (a % 2 = 0);
-select count(*) from pg_stat_last_operation a join pg_policy b on b.oid = a.objid where b.polname = 'p1' and b.polrelid ='t1'::regclass::oid;
- count
--------
- 1
+select staactionname, stasubtype from pg_stat_last_operation a join pg_policy b on b.oid = a.objid where b.polname = 'p1' and b.polrelid ='t1'::regclass::oid;
+ staactionname | stasubtype
+---------------+------------
+ CREATE | POLICY
(1 row)
+-- start_ignore
+select a.xmin as pg_stat_last_operation_xmin, a.xmax as pg_stat_last_operation_xmax,
+ b.xmin as pg_policy_xmin, b.xmax as pg_policy_xmax,
+ staactionname, stasubtype from pg_stat_last_operation a join pg_policy b on b.oid = a.objid
+ where b.polname = 'p1' and b.polrelid ='t1'::regclass::oid;
+
+select xmin, xmax, relname from pg_class where oid in (select objid from (select objid, staactionname, stasubtype from pg_stat_last_operation a join pg_policy b on b.oid = a.objid where b.polname = 'p1' and b.polrelid ='t1'::regclass::oid ) a) ;
+
+-- end_ignore
+select relname from pg_class where oid in (select objid from (select objid, staactionname, stasubtype from pg_stat_last_operation a join pg_policy b on b.oid = a.objid where b.polname = 'p1' and b.polrelid ='t1'::regclass::oid ) a) ;
+ relname
+---------
+(0 rows)
+
drop policy p1 on t1;
-select count(*) from pg_stat_last_operation a join pg_policy b on b.oid = a.objid where b.polname = 'p1' and b.polrelid ='t1'::regclass::oid;
- count
--------
- 0
-(1 row)
+select staactionname, stasubtype from pg_stat_last_operation a join pg_policy b on b.oid = a.objid where b.polname = 'p1' and b.polrelid ='t1'::regclass::oid;
+ staactionname | stasubtype
+---------------+------------
+(0 rows)
--test drop publication
-- start_ignore
create publication pub1;
-- end_ignore
-select count(*) from pg_stat_last_operation a join pg_publication b on b.oid = a.objid where b.pubname = 'pub1';
- count
--------
- 1
+select staactionname, stasubtype from pg_stat_last_operation a join pg_publication b on b.oid = a.objid where b.pubname = 'pub1';
+ staactionname | stasubtype
+---------------+-------------
+ CREATE | PUBLICATION
(1 row)
drop publication pub1;
-select count(*) from pg_stat_last_operation a join pg_publication b on b.oid = a.objid where b.pubname = 'pub1';
- count
--------
- 0
-(1 row)
-
-drop schema bfv_meta_track cascade;
-NOTICE: drop cascades to table t1
--- test drop schema
-select count(*) from pg_stat_last_operation join
- pg_namespace on pg_namespace.oid = pg_stat_last_operation.objid
- where pg_namespace.nspname = 'bfv_meta_track';
- count
--------
- 0
-(1 row)
+select staactionname, stasubtype from pg_stat_last_operation a join pg_publication b on b.oid = a.objid where b.pubname = 'pub1';
+ staactionname | stasubtype
+---------------+------------
+(0 rows)
diff --git a/src/test/regress/sql/bfv_meta_track.sql b/src/test/regress/sql/bfv_meta_track.sql
index 83f08c26b1..89a51428aa 100644
--- a/src/test/regress/sql/bfv_meta_track.sql
+++ b/src/test/regress/sql/bfv_meta_track.sql
@@ -3,29 +3,35 @@
--https://github.com/cloudberrydb/cloudberrydb/issues/504
--
+-- start_ignore
+drop schema if exists bfv_meta_track;
+-- end_ignore
create schema bfv_meta_track;
set search_path to bfv_meta_track;
-select count(*) from pg_stat_last_operation join
+select staactionname, stasubtype, nspname from pg_stat_last_operation join
pg_namespace on pg_namespace.oid = pg_stat_last_operation.objid
where pg_namespace.nspname = 'bfv_meta_track';
-- test drop popicy
create table t1(a int);
create policy p1 on t1 using (a % 2 = 0);
-select count(*) from pg_stat_last_operation a join pg_policy b on b.oid = a.objid where b.polname = 'p1' and b.polrelid ='t1'::regclass::oid;
+select staactionname, stasubtype from pg_stat_last_operation a join pg_policy b on b.oid = a.objid where b.polname = 'p1' and b.polrelid ='t1'::regclass::oid;
+-- start_ignore
+select a.xmin as pg_stat_last_operation_xmin, a.xmax as pg_stat_last_operation_xmax,
+ b.xmin as pg_policy_xmin, b.xmax as pg_policy_xmax,
+ staactionname, stasubtype from pg_stat_last_operation a join pg_policy b on b.oid = a.objid
+ where b.polname = 'p1' and b.polrelid ='t1'::regclass::oid;
+select xmin, xmax, relname from pg_class where oid in (select objid from (select objid, staactionname, stasubtype from pg_stat_last_operation a join pg_policy b on b.oid = a.objid where b.polname = 'p1' and b.polrelid ='t1'::regclass::oid ) a) ;
+-- end_ignore
+select relname from pg_class where oid in (select objid from (select objid, staactionname, stasubtype from pg_stat_last_operation a join pg_policy b on b.oid = a.objid where b.polname = 'p1' and b.polrelid ='t1'::regclass::oid ) a) ;
+
drop policy p1 on t1;
-select count(*) from pg_stat_last_operation a join pg_policy b on b.oid = a.objid where b.polname = 'p1' and b.polrelid ='t1'::regclass::oid;
+select staactionname, stasubtype from pg_stat_last_operation a join pg_policy b on b.oid = a.objid where b.polname = 'p1' and b.polrelid ='t1'::regclass::oid;
--test drop publication
-- start_ignore
create publication pub1;
-- end_ignore
-select count(*) from pg_stat_last_operation a join pg_publication b on b.oid = a.objid where b.pubname = 'pub1';
+select staactionname, stasubtype from pg_stat_last_operation a join pg_publication b on b.oid = a.objid where b.pubname = 'pub1';
drop publication pub1;
-select count(*) from pg_stat_last_operation a join pg_publication b on b.oid = a.objid where b.pubname = 'pub1';
-
-drop schema bfv_meta_track cascade;
--- test drop schema
-select count(*) from pg_stat_last_operation join
- pg_namespace on pg_namespace.oid = pg_stat_last_operation.objid
- where pg_namespace.nspname = 'bfv_meta_track';
\ No newline at end of file
+select staactionname, stasubtype from pg_stat_last_operation a join pg_publication b on b.oid = a.objid where b.pubname = 'pub1';
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: commits-help@cloudberry.apache.org