lss602726449 commented on issue #1459:
URL: https://github.com/apache/cloudberry/issues/1459#issuecomment-3770874840
I have execute the command gpcheckcat but without error. I also execute sql
but found no error message in segment. I test in main branch. which version
cbdb you use and how to reproduce the error? @koleos1741-74
```
[gpadmin@hashdata cloudberrydb]$ gpcheckcat -p 7000
Truncated batch size to number of primaries: 4
Connected as user 'gpadmin' to database 'template1', port '7000', gpdb
version '3.0'
-------------------------------------------------------------------
Batch size: 4
Performing test 'unique_index_violation'
Total runtime for test 'unique_index_violation': 0:00:01.68
Performing test 'duplicate'
Total runtime for test 'duplicate': 0:00:05.27
Performing test 'missing_extraneous'
Total runtime for test 'missing_extraneous': 0:00:01.19
Performing test 'inconsistent'
Total runtime for test 'inconsistent': 0:00:05.44
Performing test 'foreign_key'
Total runtime for test 'foreign_key': 0:00:02.16
Performing test 'pgclass'
Total runtime for test 'pgclass': 0:00:00.04
Performing test 'namespace'
Total runtime for test 'namespace': 0:00:00.01
Performing test 'distribution_policy'
Total runtime for test 'distribution_policy': 0:00:00.02
Performing test 'dependency'
Total runtime for test 'dependency': 0:00:00.47
Performing test 'part_integrity'
Total runtime for test 'part_integrity': 0:00:00.07
Performing test 'orphaned_toast_tables'
Total runtime for test 'orphaned_toast_tables': 0:00:00.08
Performing test 'aoseg_table'
Total runtime for test 'aoseg_table': 0:00:00.01
SUMMARY REPORT: PASSED
===================================================================
Completed 12 test(s) on database 'template1' at 2026-01-20 11:27:44 with
elapsed time 0:00:16
Found no catalog issue
```
```
[gpadmin@hashdata cloudberrydb]$ psql postgres -p 7000
psql (14.4, server 14.4)
Type "help" for help.
postgres=# SELECT
classid,objid,objsubid,refclassid,refobjid,refobjsubid,deptype,
case when coordinator is null then segids
when segids is null then array[coordinator.segid]
else coordinator.segid || segids end as segids
FROM
(
SELECT
classid,objid,objsubid,refclassid,refobjid,refobjsubid,deptype,
array_agg(gp_segment_id order by gp_segment_id) as segids
FROM gp_dist_random('pg_depend') WHERE classid != 2603 GROUP BY
classid,objid,objsubid,refclassid,refobjid,refobjsubid,deptype
) as seg
FULL OUTER JOIN
(
SELECT gp_segment_id as segid,
classid,objid,objsubid,refclassid,refobjid,refobjsubid,deptype FROM pg_depend
WHERE classid != 2603
) as coordinator
USING
(classid,objid,objsubid,refclassid,refobjid,refobjsubid,deptype)
WHERE coordinator.segid is null
OR segids is null
OR NOT segids @> (select array_agg(content::int4) from
gp_segment_configuration WHERE content >= 0)
;
classid | objid | objsubid | refclassid | refobjid | refobjsubid | deptype
| segids
---------+-------+----------+------------+----------+-------------+---------+--------
(0 rows)
postgres=# select version();
version
-----------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------
-------------------------------------------------
PostgreSQL 14.4 (Apache Cloudberry 3.0.0-devel+dev.2219.gc80e93d4d57 build
dev) on x86_6
4-pc-linux-gnu, compiled by gcc (GCC) 10.2.1 20210130 (Red Hat 10.2.1-11),
64-bit compile
d on Jan 19 2026 16:11:59 (with assert checking)
(1 row)
```
--
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]
