tuhaihe commented on PR #731:
URL: https://github.com/apache/cloudberry/pull/731#issuecomment-2535241359
The latest `make installcheck` command:
```
========================
4 of 659 tests failed.
========================
```
The differences that caused some tests to fail can be viewed in the
file "/home/gpadmin/cloudberry/src/test/regress/regression.diffs". The diffs
are the following:
```
diff -I HINT: -I CONTEXT: -I GP_IGNORE: -U3
/home/gpadmin/cloudberry/src/test/regress/expected/explain_optimizer.out
/home/gpadmin/cloudberry/src/test/regress/results/explain.out
--- /home/gpadmin/cloudberry/src/test/regress/expected/explain_optimizer.out
2024-12-11 00:06:32.043419735 -0800
+++ /home/gpadmin/cloudberry/src/test/regress/results/explain.out
2024-12-11 00:06:32.068420210 -0800
@@ -395,7 +395,6 @@
}, +
"Settings": { +
"Optimizer": "Pivotal Optimizer (GPORCA)", +
- "optimizer": "on", +
"enable_parallel": "off", +
"parallel_setup_cost": "0", +
"parallel_tuple_cost": "0", +
diff -I HINT: -I CONTEXT: -I GP_IGNORE: -U3
/home/gpadmin/cloudberry/src/test/regress/expected/gpcopy_encoding.out
/home/gpadmin/cloudberry/src/test/regress/results/gpcopy_encoding.out
--- /home/gpadmin/cloudberry/src/test/regress/expected/gpcopy_encoding.out
2024-12-11 00:12:53.291486702 -0800
+++ /home/gpadmin/cloudberry/src/test/regress/results/gpcopy_encoding.out
2024-12-11 00:12:53.293486751 -0800
@@ -21,7 +21,7 @@
copy enctest to '/tmp/enctest_utf_to_latin1-1' encoding 'latin1';
set client_encoding='latin1';
copy enctest to stdout;
-�
+�
copy enctest to '/tmp/enctest_utf_to_latin1-2';
-- Connect to 'latin1' database, and load back the files we just created.
-- This is to check that they were created correctly, and that the ENCODING
diff -I HINT: -I CONTEXT: -I GP_IGNORE: -U3
/home/gpadmin/cloudberry/src/test/regress/expected/dispatch_encoding.out
/home/gpadmin/cloudberry/src/test/regress/results/dispatch_encoding.out
--- /home/gpadmin/cloudberry/src/test/regress/expected/dispatch_encoding.out
2024-12-11 00:15:14.095364710 -0800
+++ /home/gpadmin/cloudberry/src/test/regress/results/dispatch_encoding.out
2024-12-11 00:15:14.097364748 -0800
@@ -55,14 +55,16 @@
select raise_error(t) from enctest;
ERROR: raise_error called on "funny char Ä"
+CONTEXT: PL/pgSQL function raise_error(text) line 3 at RAISE
-- now do it again with latin1
set client_encoding='latin1';
select raise_notice(t) from enctest;
-NOTICE: raise_notice called on "funny char �"
+NOTICE: raise_notice called on "funny char �"
raise_notice
--------------
(1 row)
select raise_error(t) from enctest;
-ERROR: raise_error called on "funny char �"
+ERROR: raise_error called on "funny char �"
+CONTEXT: PL/pgSQL function raise_error(text) line 3 at RAISE
diff -I HINT: -I CONTEXT: -I GP_IGNORE: -U3
/home/gpadmin/cloudberry/src/test/regress/expected/cbdb_parallel.out
/home/gpadmin/cloudberry/src/test/regress/results/cbdb_parallel.out
--- /home/gpadmin/cloudberry/src/test/regress/expected/cbdb_parallel.out
2024-12-11 00:40:32.554101669 -0800
+++ /home/gpadmin/cloudberry/src/test/regress/results/cbdb_parallel.out
2024-12-11 00:40:32.628103091 -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.3871811390" 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.288487486" 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.3126407118" 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.
@@ -2545,19 +2490,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.1207446260" 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]
