Wednesday, April 19, 2023

Few debugging TigerGraph DB issues

1) Extract and iterating through the log files.

support_collection_2013-10-04_101128 % tail -3 ./m*/gsql.log


2) Query details.

Get query id from restpp info and grep for id then check return result for completion.

 

3) Query in hung state

Understand if they are reading/writing from any other file location and if they have any permission issues.

Check for: grep "Runtime Error: Cannot open file" in gpe.log


4) Abort query

Search for "abort" in gpe logs for any queries aborted.


5) Expired token

Search the keyword "token expired" in the restpp*.INFO 

Search for "Caused by NewConnectionError"


6) Token generation failed

When queries are running, not able to generate new token to another graph.

verify by "gsql lock"


7) License limitation reached

grun gse "grep -i 'graph limit violated' $(gadmin config get System.LogRoot --file ~/.tg.cfg)/gse/log.INFO"


***