greenplum 报错

happyzxs 2017-12-20 06:49:24
2017-12-20 17:08:18.769618 CST,"gpadmin","tdm_test",p12024,th1921230656,"192.168.12.94","11736",2017-12-20 17:08:00 CST,140020,con96,cmd5,seg-1,,dx162,x140020,sx1,"ERROR","08006","connection with gpfdist failed for gpfdist://192.168.12.94:8000//shsnc/dmp/software/gpload/multiple2_tablezxs_test31912050.dat. effective url: http://192.168.12.94:8000//shsnc/dmp/software/gpload/multiple2_tablezxs_test31912050.dat. error code = 104 (Connection reset by peer) (seg0 slice1 gpmaster:40000 pid=12061)",,,,,,"INSERT INTO ""public"".""zxs_test3"" (""e_id"",""e_name"",""e_date"",""e_address"",""e_tel"",""e_id_1"",""e_name_1"",""e_date_1"",""e_address_1"",""e_tel_1"") SELECT ""e_id"",""e_name"",""e_date"",""e_address"",""e_tel"",""e_id_1"",""e_name_1"",""e_date_1"",""e_address_1"",""e_tel_1"" FROM ext_gpload_16277980_e55e_11e7_aebd_005056816fdd",0,,"cdbdisp.c",1322,
2017-12-20 17:08:18.769770 CST,"gpadmin","tdm_test",p12024,th1921230656,"192.168.12.94","11736",2017-12-20 17:08:00 CST,140020,con96,cmd5,seg-1,,dx162,x140020,sx1,"LOG","00000","An exception was encountered during the execution of statement: INSERT INTO ""public"".""zxs_test3"" (""e_id"",""e_name"",""e_date"",""e_address"",""e_tel"",""e_id_1"",""e_name_1"",""e_date_1"",""e_address_1"",""e_tel_1"") SELECT ""e_id"",""e_name"",""e_date"",""e_address"",""e_tel"",""e_id_1"",""e_name_1"",""e_date_1"",""e_address_1"",""e_tel_1"" FROM ext_gpload_16277980_e55e_11e7_aebd_005056816fdd",,,,,,,0,,,,
...全文
1022 7 打赏 收藏 转发到动态 举报
写回复
用AI写文章
7 条回复
切换为时间正序
请发表友善的回复…
发表回复
Halo-Z 2019-06-01
  • 打赏
  • 举报
回复
尝试 把gpfdist超时限制放宽 用 -t 参数指定。网络不稳定或者负载过高都会导致超时
dsl279879634 2018-08-07
  • 打赏
  • 举报
回复
gpfdist的用法就按照官网文档就不会报错。
一方晴空 2018-06-20
  • 打赏
  • 举报
回复
一般08开头的错误都是连接异常,建议你看一下gp状态是否正常,是否有节点挂了或者假死状态,另外网络也需要你检查一下。如果检查完了,你多试几次导入,最后仍然不行,你重启一下试试。
一方晴空 2018-06-20
  • 打赏
  • 举报
回复
一般08开头的错误都是连接异常,建议你看一下gp状态是否正常,是否有节点挂了或者假死状态,另外网络也需要你检查一下。如果检查完了,你多试几次导入,最后仍然不行,你重启一下试试。
php17 2018-05-04
  • 打赏
  • 举报
回复
应该是gpfdist链接出错了,检查一下gpfdist进程
happyzxs 2017-12-20
  • 打赏
  • 举报
回复
哪位大神遇到过?如何解决?可以补给分

164

社区成员

发帖
与我相关
我的任务
社区描述
Greenplum相关内容分享专区
数据库数据库架构数据库开发 技术论坛(原bbs)
社区管理员
  • Greenplum社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧