"PANIC","XX000","ERRORDATA_STACK_SIZE exceeded

[fsmiledream]

CST,0,con13188,cmd3,seg11,slice4,,,sx1,"PANIC","XX000","ERRORDATA_STACK_SIZE exceeded (elog.c:1679)",,,,,,,0,,"elog.c",1679,"Stack trace:
1 0xbfec27 postgres errstart + 0x267
2 0x6b2ce3 postgres + 0x6b2ce3
3 0xc02866 postgres + 0xc02866
4 0x733904 postgres AbortCurrentTransaction + 0x24
5 0xa96c80 postgres PostgresMain + 0x300
6 0x6b1a63 postgres + 0x6b1a63
7 0xa1c636 postgres PostmasterMain + 0x10a6
8 0x6b5911 postgres main + 0x421
9 0x7fd3ea70ee75 libc.so.6 __libc_start_main + 0xf5
10 0x6c17bc postgres + 0x6c17bc
after error occurred，some segments down

[github-actions]

Hey, @fsmiledream welcome!🎊 Thanks for taking the time to point this out.🙌

[my-ship-it]

@fsmiledream Thanks for submitting it. Please provide original reproducible SQL.

[fsmiledream]

4-11-27 06:26:33.895780 CST,"dsg","ods_thifly",p58339,th-2126640960,"10.58.184.21","60603",2024-11-27 01:00:16 CST,0,con270910,cmd5,seg0,slice4,dx19390930,,sx1,"ERROR","58M01","Interconnect Error: Unexpected Motion Node Id: 3 (size 10). This means a motion node that wasn't setup is requesting interconnect resources.",,,,,,"with tmp as (
select optins_no, mdtrt_sn, (case when max(db_org_info.org_name) is null then optins_no else max(db_org_info.org_name) end) as org_name
from fixmedins_nurscare_oprt_rcd_c left join db_org_info on fixmedins_nurscare_oprt_rcd_c.optins_no = db_org_info.org_code
where fixmedins_nurscare_oprt_rcd_c.""updt_time"" >= '2024-11-26 00:00:00' and fixmedins_nurscare_oprt_rcd_c.""updt_time"" <'2024-11-27 00:00:00'
group by optins_no, mdtrt_sn
)
SELECT fixmedins_nurscare_oprt_rcd_c.""dept_code"" AS ""dept_code"", fixmedins_nurscare_oprt_rcd_c.""mdtrt_id"" AS ""mdtrt_sn"", fixmedins_nurscare_oprt_rcd_c.""mdtrt_id"" AS ""mdtrt_id"", fixmedins_nurscare_oprt_rcd_c.""psn_no"" AS ""psn_no"", fixmedins_nurscare_oprt_rcd_c.""dept_name"" AS ""dept_name""
, fixmedins_nurscare_oprt_rcd_c.""wardarea_name"" AS ""wardarea_name"", fixmedins_nurscare_oprt_rcd_c.""bedno"" AS ""bedno"", fixmedins_nurscare_oprt_rcd_c.""diag_code"" AS ""diag_code"", fixmedins_nurscare_oprt_rcd_c.""adm_time"" AS ""adm_time"", fixmedins_nurscare_oprt_rcd_c.""act_ipt_days"" ",0,,"ic_tcp.c",2041,

[gfphoenix78]

@fsmiledream Thank you for your feedback. Could you provide more details about the issue?

1. What version(branch or even commit) do you use?
2. Which OS do you use?
3. Could you reproduce this issue?
4. Is there a core dump file?
   These details is helpful to find out the root cause and fix the issue.