adnanhamdussalam opened a new issue, #1422:
URL: https://github.com/apache/cloudberry/issues/1422
Hi,
I am facing pg_partition_rule catalog issue while using the cbcopy:
cbcopy --source-host 10.10.10.52 --source-port 5432 --source-user gpadmin1
--dest-host 10.10.10.1 --dest-user gpadmin1 --dest-port 5432 --data-port-range
20000-21000 --copy-jobs 4 --on-segment-threshold -1 --dest-table-file
desttabfile --include-table-file tabfile --truncate --verbose
20251030:05:50:41 cbcopy:gpadmin:timbr-cb01:449074-[INFO]:-Establishing 1
source db management connection(s)...
20251030:05:50:41 cbcopy:gpadmin:timbr-cb01:449074-[INFO]:-Initialized
database version - Full Version: PostgreSQL 9.4.26 (Greenplum Database 6.26.3
build commit:6eeb38781a1816e42a610af0137c45657bcf6960 Open Source) on
x86_64-unknown-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat
8.5.0-20), 64-bit compiled on Feb 15 2024 06:30:02, Database Type: Greenplum
Database, Semantic Version:
6.26.3
20251030:05:50:41 cbcopy:gpadmin:timbr-cb01:449074-[INFO]:-Establishing 4
dest db management connection(s)...
20251030:05:50:41 cbcopy:gpadmin:timbr-cb01:449074-[INFO]:-Initialized
database version - Full Version: PostgreSQL 14.4 (Apache Cloudberry
2.0.0-incubating build 1) on x86_64-pc-linux-gnu, compiled
by gcc (GCC) 11.5.0 20240719 (Red Hat 11.5.0-5.0.1), 64-bit compiled on Aug
28 2025 15:25:48, Database Type: Unknown Database, Semantic Version: 0.0.0
20251030:05:50:41 cbcopy:gpadmin:timbr-cb01:449074-[INFO]:-Establishing 1
source db (gpafiniti) metadata connection(s)...
20251030:05:50:41 cbcopy:gpadmin:timbr-cb01:449074-[INFO]:-Initialized
database version - Full Version: PostgreSQL 9.4.26 (Greenplum Database 6.26.3
build commit:6eeb38781a1816e42a610af0137c45657bcf6960 Open Source) on
x86_64-unknown-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat
8.5.0-20), 64-bit compiled on Feb 15 2024 06:30:02, Database Type: Greenplum
Database, Semantic Version:
6.26.3
20251030:05:50:41 cbcopy:gpadmin:timbr-cb01:449074-[INFO]:-Establishing 2
dest db (gpafiniti) metadata connection(s)...
20251030:05:50:41 cbcopy:gpadmin:timbr-cb01:449074-[INFO]:-Initialized
database version - Full Version: PostgreSQL 14.4 (Apache Cloudberry
2.0.0-incubating build 1) on x86_64-pc-linux-gnu, compiled
by gcc (GCC) 11.5.0 20240719 (Red Hat 11.5.0-5.0.1), 64-bit compiled on Aug
28 2025 15:25:48, Database Type: Unknown Database, Semantic Version: 0.0.0
20251030:05:50:41 cbcopy:gpadmin:timbr-cb01:449074-[INFO]:-Establishing 4
dest db (gpafiniti) data connection(s)...
20251030:05:50:41 cbcopy:gpadmin:timbr-cb01:449074-[INFO]:-Initialized
database version - Full Version: PostgreSQL 14.4 (Apache Cloudberry
2.0.0-incubating build 1) on x86_64-pc-linux-gnu, compiled
by gcc (GCC) 11.5.0 20240719 (Red Hat 11.5.0-5.0.1), 64-bit compiled on Aug
28 2025 15:25:48, Database Type: Unknown Database, Semantic Version: 0.0.0
20251030:05:50:42 cbcopy:gpadmin:timbr-cb01:449074-[INFO]:-Establishing 4
source db (gpafiniti) data connection(s)...
20251030:05:50:42 cbcopy:gpadmin:timbr-cb01:449074-[INFO]:-Initialized
database version - Full Version: PostgreSQL 9.4.26 (Greenplum Database 6.26.3
build commit:6eeb38781a1816e42a610af0137c45657bcf6960 Open Source) on
x86_64-unknown-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat
8.5.0-20), 64-bit compiled on Feb 15 2024 06:30:02, Database Type: Greenplum
Database, Semantic Version:
6.26.3
20251030:05:50:42 cbcopy:gpadmin:timbr-cb01:449074-[INFO]:-Retrieving user
tables on source database "gpafiniti"...
20251030:05:50:42 cbcopy:gpadmin:timbr-cb01:449074-[INFO]:-Finished
retrieving user tables
20251030:05:50:42 cbcopy:gpadmin:timbr-cb01:449074-[INFO]:-Retrieving
partition table on source database "gpafiniti"...
20251030:05:50:42 cbcopy:gpadmin:timbr-cb01:449074-[INFO]:-Finished
retrieving partition tables
20251030:05:50:42 cbcopy:gpadmin:timbr-cb01:449074-[INFO]:-Retrieving user
tables on destination database "gpafiniti"...
20251030:05:50:42 cbcopy:gpadmin:timbr-cb01:449074-[CRITICAL]:-ERROR:
relation "pg_partition_rule" does not exist (SQLSTATE 42P01)
github.com/greenplum-db/gp-common-go-libs/gplog.FatalOnError
/home/gpadmin/go/pkg/mod/github.com/greenplum-db/[email protected]/gplog/gplog.go:436
github.com/cloudberrydb/cbcopy/copy.(*QueryWrapper).GetUserTables
/home/gpadmin/cbcopy/copy/copy_query_wrapper.go:178
github.com/cloudberrydb/cbcopy/copy.(*Application).doCopy
/home/gpadmin/cbcopy/copy/copy.go:291
github.com/cloudberrydb/cbcopy/copy.(*Application).Run
/home/gpadmin/cbcopy/copy/copy.go:405
main.main.func1
/home/gpadmin/cbcopy/cbcopy.go:22
github.com/spf13/cobra.(*Command).execute
/home/gpadmin/go/pkg/mod/github.com/spf13/[email protected]/command.go:920
github.com/spf13/cobra.(*Command).ExecuteC
/home/gpadmin/go/pkg/mod/github.com/spf13/[email protected]/command.go:1044
github.com/spf13/cobra.(*Command).Execute
/home/gpadmin/go/pkg/mod/github.com/spf13/[email protected]/command.go:968
main.main
/home/gpadmin/cbcopy/cbcopy.go:27
runtime.main
/usr/local/go/src/runtime/proc.go:272
runtime.goexit
/usr/local/go/src/runtime/asm_amd64.s:1700
20251030:05:50:42 cbcopy:gpadmin:timbr-cb01:449074-[DEBUG]:-Beginning cleanup
20251030:05:50:42 cbcopy:gpadmin:timbr-cb01:449074-[DEBUG]:-Cleanup complete
--
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]
