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"
***