ryapandt commented on issue #1459:
URL: https://github.com/apache/cloudberry/issues/1459#issuecomment-3591363614
We have again encountered a similar issue, and the following logs may be
helpful.
```
2025-11-29 15:00:09.372516
CST,"gpadmin","postgres",p633510,th-1126913920,"172.18.1.47","61002",2025-11-29
15:00:05 CST,0,con8270,cmd993,seg-1,,,,sx1,"LOG","00000","serializable
isolation requested, falling back to repeatable read until serializable is
supported in Cloudberry",,,,,,"
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
-- distribute catalog table from coordinator, so that we can avoid
to gather
CREATE TEMPORARY TABLE _tmp_coordinator ON COMMIT DROP AS
SELECT gp_segment_id AS segid, loid,pageno FROM pg_largeobject
DISTRIBUTED BY (segid);
SELECT loid,pageno, total, array_agg(segid order by segid) as
segids
FROM (
SELECT segid, loid,pageno, count(*) as total
FROM (
select segid, loid,pageno FROM _tmp_coordinator
union all
select gp_segment_id as segid, loid,pageno FROM
gp_dist_random('pg_largeobject')
) all_segments
GROUP BY segid, loid,pageno
HAVING count(*) > 1
) rowresult
GROUP BY loid,pageno, total
",0,,"variable.c",569,
2025-11-29 15:00:11.838488
CST,"jyzsuser","pasobi",p631667,th-1126913920,"172.18.46.87","39686",2025-11-29
14:58:37 CST,0,con8226,cmd139,seg-1,,dx23142391,,sx1,"LOG","00000","DEADLOCK
HAZARD: Updating active_motion_id from 1 to 3",,,,,,"/* jyzsv2-DB:master*/
/* jyzsv2-schema:jyzs */
with showInvTemp as (
select case when position(b.userlevel::int::varchar in
property_value)>0 and position(coalesce(b.usernewrole,'null') in
property_value) <=0 then b.userlevel::int::varchar else '不可看库存' end as
if_show_inv
from ads_jyzs_globalconfigs a left join v_jyzs_empstaion b on
b.usergid = $1::int where property_name = 'if_show_inv' limit 1),
gprofit_disable_tmp as (
select case when position($2::varchar in property_value)>0
or position(coalesce(b.usernewrole,'null') in property_value)>0 then 'false'
else 'true' end d_gprofit_disable
from ads_jyzs_globalconfigs a left join v_jyzs_empstaion b
on b.usergid = $3::int where property_name='gp_show_groupid' limit 1
)
select * from gprofit_disable_tmp,showInvTemp",0,,"nodeMotion.c",143,
2025-11-29 15:00:22.201043
CST,"gpadmin","postgres",p633510,th-1126913920,"172.18.1.47","61002",2025-11-29
15:00:05 CST,0,con8270,cmd1014,seg-1,,,,sx1,"ERROR","XX000","Unexpected
internal error (assert.c:48) (seg11 slice1 172.18.1.49:6001 pid=2719241)
(assert.c:48)","FailedAssertion(""remote_typmod < remapper->typmodmapsize"",
File: ""tupleremap.c"", Line: 255)",,,,,"
SELECT oid,
case when coordinator is null then segids
when segids is null then array[coordinator.segid]
else coordinator.segid || segids end as segids
FROM
(
SELECT oid, array_agg(gp_segment_id order by gp_segment_id) as
segids
FROM gp_dist_random('pg_class') GROUP BY oid
) as seg
FULL OUTER JOIN
(
SELECT gp_segment_id as segid, oid FROM pg_class
) as coordinator
USING (oid)
WHERE coordinator.segid is null
OR segids is null
OR NOT segids @> (select array_agg(content::int4) from
gp_segment_configuration WHERE content >= 0)
",0,,"assert.c",48,"Stack trace:
1 0x7fddb62263d2 libpostgres.so errstart + 0x202
2 0x7fddb622c2f6 libpostgres.so ThrowErrorData + 0x16
3 0x7fddb62b7010 libpostgres.so CdbDispatchHandleError + 0x1b0
4 0x7fddb5e77fc3 libpostgres.so mppExecutorCleanup + 0x83
5 0x7fddb5e6455d libpostgres.so standard_ExecutorRun + 0x8cd
6 0x7fddb5e646a5 libpostgres.so ExecutorRun + 0xc5
7 0x7fddb60c197f libpostgres.so <symbol not found> + 0xb60c197f
8 0x7fddb60c374f libpostgres.so PortalRun + 0x1af
9 0x7fddb60bc6d0 libpostgres.so exec_simple_query + 0x1c0
10 0x7fddb60c10da libpostgres.so PostgresMain + 0x235a
11 0x7fddb6006112 libpostgres.so <symbol not found> + 0xb6006112
12 0x7fddb60071f1 libpostgres.so PostmasterMain + 0xe61
13 0x4027eb postgres main (main.c:200)
14 0x7fddb50717e5 libc.so.6 __libc_start_main + 0xe5
15 0x40298e postgres _start + 0x2e
"
2025-11-29 15:00:22.201105
CST,"gpadmin","postgres",p633510,th-1126913920,"172.18.1.47","61002",2025-11-29
15:00:05 CST,0,con8270,cmd1014,seg-1,,,,sx1,"LOG","00000","An exception was
encountered during the execution of statement:
SELECT oid,
case when coordinator is null then segids
when segids is null then array[coordinator.segid]
else coordinator.segid || segids end as segids
FROM
(
SELECT oid, array_agg(gp_segment_id order by gp_segment_id) as
segids
FROM gp_dist_random('pg_class') GROUP BY oid
) as seg
FULL OUTER JOIN
(
SELECT gp_segment_id as segid, oid FROM pg_class
) as coordinator
USING (oid)
WHERE coordinator.segid is null
OR segids is null
OR NOT segids @> (select array_agg(content::int4) from
gp_segment_configuration WHERE content >= 0)
",,,,,,"
SELECT oid,
case when coordinator is null then segids
when segids is null then array[coordinator.segid]
else coordinator.segid || segids end as segids
FROM
(
SELECT oid, array_agg(gp_segment_id order by gp_segment_id) as
segids
FROM gp_dist_random('pg_class') GROUP BY oid
) as seg
FULL OUTER JOIN
(
SELECT gp_segment_id as segid, oid FROM pg_class
) as coordinator
USING (oid)
WHERE coordinator.segid is null
OR segids is null
OR NOT segids @> (select array_agg(content::int4) from
gp_segment_configuration WHERE content >= 0)
",0,,"elog.c",2129,
2025-11-29 15:00:22.201857
CST,"gpadmin","postgres",p633510,th-1126913920,"172.18.1.47","61002",2025-11-29
15:00:05 CST,0,con8370,,seg-1,,,,sx1,"LOG","00000","The previous session was
reset because its gang was disconnected (session id = 8270). The new session id
= 8370",,,,,,,0,,"cdbgang.c",816,
2025-11-29 15:00:22.201891
CST,"gpadmin","postgres",p634555,th-1126913920,"[local]",,2025-11-29 15:00:09
CST,0,con8270,,seg-1,,,,,"LOG","00000","Process interrupt for 'query cancel
pending' (postgres.c:5636)",,,,,,,0,,"postgres.c",4216,
2025-11-29 15:00:22.211477
CST,"gpadmin","postgres",p633510,th-1126913920,"172.18.1.47","61002",2025-11-29
15:00:05 CST,0,con8370,cmd2,seg-1,,,,sx1,"LOG","00000","segment is in
reset/recovery mode (seg11 172.18.1.49:6001)",,,,,,"
SELECT adrelid,adnum,
case when coordinator is null then segids
when segids is null then array[coordinator.segid]
else coordinator.segid || segids end as segids
FROM
(
SELECT adrelid,adnum, array_agg(gp_segment_id order by
gp_segment_id) as segids
FROM gp_dist_random('pg_attrdef') GROUP BY adrelid,adnum
) as seg
FULL OUTER JOIN
(
SELECT gp_segment_id as segid, adrelid,adnum FROM pg_attrdef
) as coordinator
USING (adrelid,adnum)
WHERE coordinator.segid is null
OR segids is null
OR NOT segids @> (select array_agg(content::int4) from
gp_segment_configuration WHERE content >= 0)
",0,,"cdbgang_async.c",256,
```
--
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]
