Cannot getting Non-SelectPath ID because the Input Path of the Select Path is NULL

David_P_1

How does one fix this error?

 

 

2015-10-06 17:15:15.369 Init Session:0x7f84d8011400-a0000000004342 [Session] <INFO> [Query] TX:a0000000004342(usw1-db-vertica1.in-75823:0x39ff7) COPY tran FROM '/data/out.csv' DIRECT DELIMITER ';';

2015-10-06 17:15:15.372 Init Session:0x7f84d8011400-a0000000004342 <LOG> @v_gis_node0001: 00000/5771: Cannot getting Non-SelectPath ID because the Input Path of the Select Path is NULL

Rahul_Choudhary

Hi

 

I wanted to know first does this copy statement in actual failed or did it load the data successfully? 

 

Also just to brief you the error message (Cannot getting Non-SelectPath ID because the Input Path of the Select Path is NULL) you are getting is erroneous and unneccessary which doesn't signify anything and will be removed in the next major release.

 

 

Regards

Rahul Choudhary

David_P_1

Vertica Analytic Database v7.1.2-0

 

Copy statement fails, no data is loaded.

 

Directory /data/vertica/gis/v_gis_node0001_catalog/CopyErrorLogs is empty

 

[root@ v_gis_node0001_catalog]# tail vertica.log

2015-10-07 08:06:11.508 Init Session:0x7f84d8011580 <INFO> @v_gis_node0001: 00000/2372: Cannot commit; no transaction in progress
2015-10-07 08:06:11.945 Init Session:0x7f84d8011580 [Session] <INFO> [PQuery] TX:0 COPY public.tran FROM local STDIN DELIMITER '|' NULL 'null' DIRECT returnrejected
2015-10-07 08:06:11.962 Init Session:0x7f84d8011580 [Session] <INFO> [Query] TX:0 COPY public.tran FROM local STDIN DELIMITER '|' NULL 'null' DIRECT returnrejected
2015-10-07 08:06:11.962 Init Session:0x7f84d8011580-a0000000005140 [Txn] <INFO> Begin Txn: a0000000005140 'COPY public.tran FROM local STDIN DELIMITER '|' NULL 'null' DIRECT returnrejected'
2015-10-07 08:06:11.987 Init Session:0x7f84d8011580-a0000000005140 <LOG> @v_gis_node0001: 00000/5771: Cannot getting Non-SelectPath ID because the Input Path of the Select Path is NULL
2015-10-07 08:06:12.035 Init Session:0x7f84d8011580-a0000000005140 [Txn] <INFO> Starting Commit: Txn: a0000000005140 'COPY public.tran FROM local STDIN DELIMITER '|' NULL 'null' DIRECT returnrejected'
2015-10-07 08:06:12.035 Init Session:0x7f84d8011580 [Txn] <INFO> Commit Complete: Txn: a0000000005140 at epoch 0x66
2015-10-07 08:06:12.036 Init Session:0x7f84d8011580 [EE] <INFO> [Bulkload] DIRECT copy targeting tran from pipe committed at epoch 102.
2015-10-07 08:06:12.063 Init Session:0x7f84d8011580 <LOG> @v_gis_node0001: 08006/5167: Unexpected EOF on client connection
2015-10-07 08:06:12.063 Init Session:0x7f84d8011580 <LOG> @v_gis_node0001: 00000/4719: Session ended; closing connection (connCnt 3)