<GSQL101> Error on "RUN LOADING JOB"

GSQL
#1

Hello,
I just started to study Tigergraph.

I installed Tigergraph and now trying the Tigergraph Doc .

I defined the graph schema, made a graph “social” well.
But when i’m trying to RUN a Loading job, it doesn’t work.
It just stop, and no data load on vertex or edge. :frowning:

Any idea of what is the problem here ?

Oh, I created the sample dataset on /home/tigergraph/sample, and i typed correct.
And I tried load person data on Graph studio, it worked.

Here is the url of <GSQL - Load Data>
:paperclip: Load Data - TigerGraph Documentation

#2

Can you review the logs for your load job? Gadmin log will show the path to the RESTPP logs and there will be a folder with the name of your graph- social.

Often if the list of fields in you load statement doesn’t match what’s in the source file, the job will fail.

1 Like
#3

Hi Song

Can you provide your loading job, how you’re running it (via GSQL, or a remote connector like pyTigerGraph), and a copy and paste of the error message if there is one.

If you’re not getting any response then I would look into making sure that the data file is being picked up, if the error message is giving you a number of edges or vertices that failed to load, then it’s most likely a file or loading job formatting problem and I’ll be able to assist once you provide the GSQL of your loading job.

#4

Hello Dan,
I executed these via GSQL, used same GSQL from the TigerGraph DOCS.

USE GRAPH social
BEGIN
CREATE LOADING JOB load_social FOR GRAPH social {
   DEFINE FILENAME file1="/home/tigergraph/person.csv";
   DEFINE FILENAME file2="/home/tigergraph/friendship.csv";

   LOAD file1 TO VERTEX person VALUES ($"name", $"name", $"age", $"gender", $"state") USING header="true", separator=",";
   LOAD file2 TO EDGE friendship VALUES ($0, $1, $2) USING header="true", separator=",";
}
END

I got error message like below.

image
image894×101 34.9 KB

(I tried some modified GSQL and all error messages were same.)

I don’t know what the problem here is. :frowning: :sob:

#5

@song It looks like your loading job is:
image

and then you are running this:
image

Can you try:
RUN LOADING JOB load_social

#6

Hi, @Jon_Herke

I executed some modified queries, I tried RUN LOADING JOB with same job name.
And this morning, I try again GSQL of Doc, the same error occurred.
▼ The error message

m1 RESTPP got error with message "HTTP/1.1 404 Not Found", abort the current loading job on all machines.
Try to abort loading job 'social.load_social.file.m1.1646955163357', it may take a while ...
[ABORT_SUCCESS] No active Loading Job to abort.
Failed to run loading job load_social
But some data may have been loaded before being aborted. Please check the information if there is '[SUMMARY]'.

In admin.error file,

E0311 08:27:11.007961 25371 gdict.cpp:840] ReadDictToContent, can not list node: /__services/GSQL/_config/_User/1/codegen, rc: kNotFound
E0311 08:27:11.007997 25371 gsql_service.cpp:285] DownloadCatalog error while reading: 1/codegen, rc : kNotFound
E0311 08:32:20.512028 25371 gdict.cpp:840] ReadDictToContent, can not list node: /__services/GSQL/_config/_User/1/codegen, rc: kNotFound
E0311 08:32:20.512065 25371 gsql_service.cpp:285] DownloadCatalog error while reading: 1/codegen, rc : kNotFound

In admin.info file,

E0311 08:32:20.512028 25371 gdict.cpp:840] ReadDictToContent, can not list node: /__services/GSQL/_config/_User/1/codegen, rc: kNotFound
E0311 08:32:20.512065 25371 gsql_service.cpp:285] DownloadCatalog error while reading: 1/codegen, rc : kNotFound
I0311 08:32:20.808606 26977 gsql_service.cpp:541] Reload restpp with timeout: 59999
I0311 08:32:30.069087 26977 gsql_service.cpp:541] Reload restpp with timeout: 59999
I0311 08:32:30.318688 26977 gsql_service.cpp:541] Reload restpp with timeout: 59998

And in retpp/ERROR.20220311 …

E0311 08:32:21.239746  1711 gconfig_general.cpp:328] Graph social failed to get end points. List endpoints files failed. rc:kNotFound
E0311 08:32:21.247205  1711 gconfig_general.cpp:328] Graph social failed to get end points. List endpoints files failed. rc:kNotFound
E0311 08:32:30.240068  1711 gconfig_general.cpp:328] Graph social failed to get end points. List endpoints files failed. rc:kNotFound
E0311 08:32:30.247344  1711 gconfig_general.cpp:328] Graph social failed to get end points. List endpoints files failed. rc:kNotFound
E0311 08:32:31.240181  1711 gconfig_general.cpp:328] Graph social failed to get end points. List endpoints files failed. rc:kNotFound
E0311 08:32:31.247900  1711 gconfig_general.cpp:328] Graph social failed to get end points. List endpoints files failed. rc:kNotFound

oh, and my person.csv and friendship.csv are located in /home/tigergraph/ too.