edespino commented on code in PR #714: URL: https://github.com/apache/cloudberry/pull/714#discussion_r1849379976
########## src/test/regress/greenplum_schedule: ########## @@ -258,7 +258,7 @@ test: ao_locks test: freeze_aux_tables # cbdb parallel test -test: cbdb_parallel +ignore: cbdb_parallel Review Comment: @avamingli I have invited you to collaborate with me on my cloudbery project. This will allow you to review my test run where a github action reproduced the issue. The `cbdb_parallel` test is failing in the containers due to "No space left on device". Is this a result of running out of disk space or memory? You should be able to review the test logs here: https://github.com/edespino/cloudberry/actions/runs/11924771340 ``` diff -I HINT: -I CONTEXT: -I GP_IGNORE: -U3 /__w/cloudberry/cloudberry/src/test/regress/expected/cbdb_parallel.out /__w/cloudberry/cloudberry/src/test/regress/results/cbdb_parallel.out --- /__w/cloudberry/cloudberry/src/test/regress/expected/cbdb_parallel.out 2024-11-19 17:23:58.142198133 -0800 +++ /__w/cloudberry/cloudberry/src/test/regress/results/cbdb_parallel.out 2024-11-19 17:23:58.206197545 -0800 @@ -536,11 +536,8 @@ GP_IGNORE:(20 rows) select count(*) from ao1, ao2 where ao1.x = ao2.x; - count ---------- - 1080000 -(1 row) - +ERROR: could not resize shared memory segment "/PostgreSQL.2418892932" to 8388608 bytes: No space left on device +ERROR: current transaction is aborted, commands ignored until end of transaction block commit; -- -- test parallel with indices @@ -1563,45 +1560,13 @@ GP_IGNORE:(30 rows) select * from rt1 join (select count(*) as c, sum(t1.a) as a from t1 join t2 using(a)) t3 on t3.c = rt1.a; - a | b | c | a ----+---+---+--- -(0 rows) - +ERROR: could not resize shared memory segment "/PostgreSQL.4177304382" to 4194304 bytes: No space left on device set local enable_parallel = off; +ERROR: current transaction is aborted, commands ignored until end of transaction block explain(costs off, locus) select * from rt1 join (select count(*) as c, sum(t1.a) as a from t1 join t2 using(a)) t3 on t3.c = rt1.a; -QUERY PLAN -___________ - Hash Join - Locus: Entry - Hash Cond: (rt1.a = (count(*))) - -> Gather Motion 1:1 (slice1; segments: 1) - Locus: Entry - -> Seq Scan on rt1 - Locus: SegmentGeneral - -> Hash - Locus: Entry - -> Finalize Aggregate - Locus: Entry - -> Gather Motion 3:1 (slice2; segments: 3) - Locus: Entry - -> Partial Aggregate - Locus: Hashed - -> Hash Join - Locus: Hashed - Hash Cond: (t1.a = t2.a) - -> Seq Scan on t1 - Locus: Hashed - -> Hash - Locus: Hashed - -> Seq Scan on t2 - Locus: Hashed -GP_IGNORE:(25 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select * from rt1 join (select count(*) as c, sum(t1.a) as a from t1 join t2 using(a)) t3 on t3.c = rt1.a; - a | b | c | a ----+---+---+--- -(0 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block abort; -- -- Test final join path's parallel_workers should be same with join_locus whose @@ -2247,44 +2212,24 @@ GP_IGNORE:(10 rows) select sum(t1.c1) from t1 where c1 not in (select c2 from t2); - sum ------ - 1 -(1 row) - +ERROR: could not resize shared memory segment "/PostgreSQL.3791510102" to 8388608 bytes: No space left on device explain(costs off) select * from t1 where c1 not in (select c2 from t3_null); -QUERY PLAN -___________ - Gather Motion 6:1 (slice1; segments: 6) - -> Parallel Hash Left Anti Semi (Not-In) Join - Hash Cond: (t1.c1 = t3_null.c2) - -> Parallel Seq Scan on t1 - -> Parallel Hash - -> Broadcast Workers Motion 6:6 (slice2; segments: 6) - -> Parallel Seq Scan on t3_null -GP_IGNORE:(8 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select * from t1 where c1 not in (select c2 from t3_null); - c1 | c2 -----+---- -(0 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block -- non-parallel results. set local enable_parallel = off; +ERROR: current transaction is aborted, commands ignored until end of transaction block select sum(t1.c1) from t1 where c1 not in (select c2 from t2); - sum ------ - 1 -(1 row) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select * from t1 where c1 not in (select c2 from t3_null); - c1 | c2 -----+---- -(0 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block drop table t1; +ERROR: current transaction is aborted, commands ignored until end of transaction block drop table t2; +ERROR: current transaction is aborted, commands ignored until end of transaction block drop table t3_null; +ERROR: current transaction is aborted, commands ignored until end of transaction block end; -- -- End of Test Parallel-aware Hash Left Anti Semi (Not-In) Join. @@ -2551,19 +2496,15 @@ begin; set local max_parallel_workers_per_gather = 8; select * from refresh_compare(true, false); - parallel_is_better --------------------- - t -(1 row) - +ERROR: could not resize shared memory segment "/PostgreSQL.2096820432" to 8388608 bytes: No space left on device +CONTEXT: SQL statement "refresh materialized view matv" +PL/pgSQL function refresh_compare(boolean,boolean) line 30 at SQL statement select * from refresh_compare(false, false); - parallel_is_better --------------------- - t -(1 row) - +ERROR: current transaction is aborted, commands ignored until end of transaction block drop function refresh_compare; +ERROR: current transaction is aborted, commands ignored until end of transaction block reset max_parallel_workers_per_gather; +ERROR: current transaction is aborted, commands ignored until end of transaction block end; -- -- Parallel Create AO/AOCO Table AS ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
