avamingli opened a new issue, #1229:
URL: https://github.com/apache/cloudberry/issues/1229
### Apache Cloudberry version
_No response_
### What happened
```sql
regression=# explain(costs off) SELECT AVG(a) as a FROM dml_union_r UNION
SELECT AVG(b) as a FROM dml_union_s;
FATAL: Unexpected internal error (assert.c:48)
DETAIL: FailedAssertion("parallel_workers > 0", File: "prepunion.c", Line:
713)
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
psql (14.4, server 14.4)
```
```gdb
#0 __pthread_kill_implementation (no_tid=0, signo=6,
threadid=140460418992512)
at ./nptl/pthread_kill.c:44
#1 __pthread_kill_internal (signo=6, threadid=140460418992512) at
./nptl/pthread_kill.c:78
#2 __GI___pthread_kill (threadid=140460418992512, signo=signo@entry=6) at
./nptl/pthread_kill.c:89
#3 0x00007fbf801e7476 in __GI_raise (sig=sig@entry=6) at
../sysdeps/posix/raise.c:26
#4 0x00007fbf801cd7f3 in __GI_abort () at ./stdlib/abort.c:79
#5 0x0000556fb880ad9e in ExceptionalCondition (conditionName=0x556fb8f11bc7
"parallel_workers > 0",
errorType=0x556fb8f118c6 "FailedAssertion", fileName=0x556fb8f11984
"prepunion.c", lineNumber=713)
at assert.c:48
#6 0x0000556fb84a41b9 in generate_union_paths (op=0x556fbf3fbc88,
root=0x556fbf4e96c0,
refnames_tlist=0x556fbf2f2a00, pTargetList=0x7ffda173d4d0) at
prepunion.c:713
#7 0x0000556fb84a347d in recurse_set_operations (setOp=0x556fbf3fbc88,
root=0x556fbf4e96c0,
colTypes=0x556fbf43d4e0, colCollations=0x556fbf43d590, junkOK=true,
flag=-1,
refnames_tlist=0x556fbf2f2a00, pTargetList=0x7ffda173d4d0,
pNumGroups=0x0) at prepunion.c:366
#8 0x0000556fb84a2e9d in plan_set_operations (root=0x556fbf4e96c0) at
prepunion.c:180
#9 0x0000556fb84759ef in grouping_planner (root=0x556fbf4e96c0,
tuple_fraction=0) at planner.c:1687
#10 0x0000556fb84752f5 in subquery_planner (glob=0x556fbf3f3560,
parse=0x556fbf3fb930, parent_root=0x0,
hasRecursion=false, tuple_fraction=0, config=0x556fbf4e9648) at
planner.c:1360
#11 0x0000556fb8473441 in standard_planner (parse=0x556fbf3fb930,
query_string=0x556fbf1c1de0 "explain(costs off) SELECT AVG(a) as a FROM
dml_union_r UNION SELECT AVG(b) as a FROM dml_union_s;", cursorOptions=2048,
boundParams=0x0) at planner.c:576
#12 0x0000556fb8472d22 in planner (parse=0x556fbf1c3668,
query_string=0x556fbf1c1de0 "explain(costs off) SELECT AVG(a) as a FROM
dml_union_r UNION SELECT AVG(b) as a FROM dml_union_s;", cursorOptions=2048,
boundParams=0x0) at planner.c:339
#13 0x0000556fb860685a in pg_plan_query (querytree=0x556fbf1c3668,
query_string=0x556fbf1c1de0 "explain(costs off) SELECT AVG(a) as a FROM
dml_union_r UNION SELECT AVG(b) as a FROM dml_union_s;", cursorOptions=2048,
boundParams=0x0) at postgres.c:995
```
### What you think should happen instead
_No response_
### How to reproduce
```sql
explain(costs off) SELECT AVG(a) as a FROM dml_union_r UNION SELECT AVG(b)
as a FROM dml_union_s;
```
run in parallel mode, and enable-debug
### Operating System
all
### Anything else
_No response_
### Are you willing to submit PR?
- [ ] Yes, I am willing to submit a PR!
### Code of Conduct
- [x] I agree to follow this project's [Code of
Conduct](https://github.com/apache/cloudberry/blob/main/CODE_OF_CONDUCT.md).
--
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]
