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,,,,
uj5u.com熱心網友回復：
哪位大神遇到過？如何解決？可以補給分uj5u.com熱心網友回復：
應該是gpfdist鏈接出錯了，檢查一下gpfdist行程uj5u.com熱心網友回復：
一般08開頭的錯誤都是連接例外，建議你看一下gp狀態是否正常，是否有節點掛了或者假死狀態，另外網路也需要你檢查一下。如果檢查完了，你多試幾次匯入，最后仍然不行，你重啟一下試試。uj5u.com熱心網友回復：
一般08開頭的錯誤都是連接例外，建議你看一下gp狀態是否正常，是否有節點掛了或者假死狀態，另外網路也需要你檢查一下。如果檢查完了，你多試幾次匯入，最后仍然不行，你重啟一下試試。uj5u.com熱心網友回復：
gpfdist的用法就按照官網檔案就不會報錯。uj5u.com熱心網友回復：
嘗試 把gpfdist超時限制放寬 用 -t 引數指定。網路不穩定或者負載過高都會導致超時轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/59333.html
標籤：Greenplum