adnanhamdussalam commented on issue #1708:
URL: https://github.com/apache/cloudberry/issues/1708#issuecomment-4343396518
Hi @my-ship-it,
PFB the update:
The Cloudberry version (`SELECT version();`).
---- SELECT version();
version
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 14.4 (Apache Cloudberry 2.1.0-incubating build bdf90c5518f) on
x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.5.0 20240719 (Red Hat 11.5.0-11),
64-bit compiled on Mar 4 2026 23:25:31
The definition of `concat_my` (`\df+ concat_my`). If it's a custom C
function, could you try swapping it for `concat_ws(',', h1.agent_skilling,
h2.agent_skilling)` once and see if the crash still happens? That alone would
tell us a lot.
-- it is concat_ws being used as function
Does it fail every time, or only on certain data sizes? Does a smaller
window (say 7 days instead of 90) still reproduce it?
-- it is in progresss will update in a while
Values for `statement_mem`, `max_statement_mem`,
`gp_workfile_limit_per_segment`, and which resource group this is running under.
gpconfig -s statement_mem
Values on all segments are consistent
GUC : statement_mem
Coordinator value: 256MB
Segment value: 256MB
gpconfig -s max_statement_mem
Values on all segments are consistent
GUC : max_statement_mem
Coordinator value: 10GB
Segment value: 10GB
gpconfig -s gp_workfile_limit_per_segment
Values on all segments are consistent
GUC : gp_workfile_limit_per_segment
Coordinator value: 0
Segment value: 0
Segment logs around the time it failed:
Found these errors from segment that is causing issue:
ERROR","25M01","canceling MPP operation"
"LOG","00000","Process interrupt for 'query cancel pending' (execScan.c:42)",
"LOG","00000","An exception was encountered during the execution of
statement:
`dmesg -T | grep -iE 'killed process|out of memory'` :
No output on coordinator and segment nodes
--
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]
