Home > database >  Greenplum error
Greenplum error

Time:09-21

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,,,,

CodePudding user response:

What a great god met? How to solve? Can supply points

CodePudding user response:

Should be an error in the gpfdist link, check the gpfdist process

CodePudding user response:

General 08 errors at the top are connection exception, suggest you look at the gp condition is normal, whether there is a node hang up or suspended animation, the network also need you to check, if check out, you try a few times more import, finally still doesn't work, you try to restart the,

CodePudding user response:

General 08 errors at the top are connection exception, suggest you look at the gp condition is normal, whether there is a node hang up or suspended animation, the network also need you to check, if check out, you try a few times more import, finally still doesn't work, you try to restart the,

CodePudding user response:

Gpfdist usage is according to the website of the document is not an error,

CodePudding user response:

Try gpfdist timeout limits specified using the -t parameters, network is not steady or the load is too high will lead to the timeout
  • Related