gpcopy error write:...
 
通知
清除全部

gpcopy error write: connection reset by peer


lianghc
帖子: 10
Topic starter
青梅新星
已加入: 3年 前

数据量大了之后,就会失败,报错说连接断开。有没有朋友遇到。

错误如下,点击可看到图片:

2 回复
lianghc
帖子: 10
Topic starter
青梅新星
已加入: 3年 前

2020120908 gpcopy-Starting copy 2.3.0...
2020120908 gpcopy-Copy appname: gpcopy_202012091953_toMU7k9vKSSaCdgCi75T7P
2020120908 gpcopy-'gpcopy' --dest-host '172.28.25.201' --dest-port '5432' --dest-user 'gpadmin' --full --jobs '1' --no-distribution-check --source-host '172.28.25.204' --source-port '5432' --source-user 'gpadmin' --truncate --validate 'count'
2020120908 gpcopy-Initializing gpcopy
2020120908 gpcopy-pg_dump (PostgreSQL) 8.3.23
2020120908 gpcopy-pg_dumpall (PostgreSQL) 8.3.23
2020120908 gpcopy-Source Cluster PostgreSQL GetVersion is: 8.3.23
2020120908 gpcopy-Copying all the metadata
2020120909 gpcopy-database "yjbdw" already exists
2020120910 gpcopy-Start copying database "yjbdw"
2020120910 gpcopy-[Worker 0] Start copying table "yjbdw"."public"."dict_column_all" => "yjbdw"."public"."dict_column_all"
2020120942 gpcopy-[Worker 0] send error: pq: Error from segment 0: ERROR: command error message: Error: write tcp 172.28.25.205:24683->172.28.25.202 write: connection reset by peer
github.com/pivotal/gpcopy/gpcopy/sqlconn.ExecQuery
/tmp/build/22a7ec05/gpcopy/gpcopy/sqlconn/conn.go:589
github.com/pivotal/gpcopy/gpcopy/sqlconn.(*connection).ExecAndStopAfterCanceled
/tmp/build/22a7ec05/gpcopy/gpcopy/sqlconn/conn.go:654
github.com/pivotal/gpcopy/gpcopy/sqlconn.(*gpcopyHelper).send
/tmp/build/22a7ec05/gpcopy/gpcopy/sqlconn/send_receive.go:141
github.com/pivotal/gpcopy/gpcopy/sqlconn.(*gpcopyHelper).StartTransfer.func2
/tmp/build/22a7ec05/gpcopy/gpcopy/sqlconn/send_receive.go:114
golang.org/x/sync/errgroup.(*Group).Go.func1
/tmp/build/22a7ec05/go/pkg/mod/golang.org/x/[email protected]/errgroup/errgroup.go:57
runtime.goexit
/usr/local/go/src/runtime/asm_amd64.s:1373
2020120942 gpcopy-[Worker 0] receive error: context canceled
Query has been canceled. INSERT INTO "public"."dict_column_all" SELECT * FROM gpcopy_ext_83322e59a01e4692a85af01d041f5dfa
github.com/pivotal/gpcopy/gpcopy/sqlconn.ExecQuery
/tmp/build/22a7ec05/gpcopy/gpcopy/sqlconn/conn.go:594
github.com/pivotal/gpcopy/gpcopy/sqlconn.(*connection).ExecAndStopAfterCanceled
/tmp/build/22a7ec05/gpcopy/gpcopy/sqlconn/conn.go:654
github.com/pivotal/gpcopy/gpcopy/sqlconn.(*gpcopyHelper).receive
/tmp/build/22a7ec05/gpcopy/gpcopy/sqlconn/send_receive.go:157
github.com/pivotal/gpcopy/gpcopy/sqlconn.(*gpcopyHelper).StartTransfer.func1
/tmp/build/22a7ec05/gpcopy/gpcopy/sqlconn/send_receive.go:107
golang.org/x/sync/errgroup.(*Group).Go.func1
/tmp/build/22a7ec05/go/pkg/mod/golang.org/x/[email protected]/errgroup/errgroup.go:57
runtime.goexit
/usr/local/go/src/runtime/asm_amd64.s:1373
github.com/pivotal/gpcopy/gpcopy/sqlconn.ExecQuery
/tmp/build/22a7ec05/gpcopy/gpcopy/sqlconn/conn.go:594
github.com/pivotal/gpcopy/gpcopy/sqlconn.(*connection).ExecAndStopAfterCanceled
/tmp/build/22a7ec05/gpcopy/gpcopy/sqlconn/conn.go:654
github.com/pivotal/gpcopy/gpcopy/sqlconn.(*gpcopyHelper).receive
/tmp/build/22a7ec05/gpcopy/gpcopy/sqlconn/send_receive.go:157
github.com/pivotal/gpcopy/gpcopy/sqlconn.(*gpcopyHelper).StartTransfer.func1
/tmp/build/22a7ec05/gpcopy/gpcopy/sqlconn/send_receive.go:107
golang.org/x/sync/errgroup.(*Group).Go.func1
/tmp/build/22a7ec05/go/pkg/mod/golang.org/x/[email protected]/errgroup/errgroup.go:57
runtime.goexit
/usr/local/go/src/runtime/asm_amd64.s:1373
2020120914 gpcopy-[Worker 0] Start copying table "yjbdw"."public"."ad_cust_creditover_ana1" => "yjbdw"."public"."ad_cust_creditover_ana1"
2020120914 gpcopy-[Worker 0] Finished task 16391_DL_P_DA_V_ with error:
pq: Error from segment 0: ERROR: command error message: Error: write tcp 172.28.25.205:24683->172.28.25.202 write: connection reset by peer
2020120914 gpcopy-[Worker 0] [Progress: (0/1) DBs, (1/5) tables done] Failed to copy table "yjbdw"."public"."dict_column_all" => "yjbdw"."public"."dict_column_all"

回复
小青梅
帖子: 50
Admin
青梅闲客
已加入: 3年 前

gpcopy是什么版本呢?是不是在虚拟机上跑的?

回复
Close Bitnami banner