Export solution hangs - Recursive queries

Symptoms

The export solution feature hangs and the page keeps loading

Error Messages

Export via gsql CLI will show some graphs exported and then hang at a specific graph

GSQL >  export graph all to "/app/tigergraph/tigergraph/backup/example"
Exporting Data
Exporting global graph
Exporting graph Customer
Exporting graph Identity
Exporting graph TEMP
Exporting graph TEST

Cause

The error is caused when a query calls itself e.g.

create query A(){
  ...
  A();
  ...
}

Resolution

A fix for this has been added to 3.7, 3.8, and 3.9. Upgrading will resolve this issue.

Workaround

You will need to identify the query/queries that call itself.

Review the gsql logs to find out the graph with the issue.

I@20220930 13:13:07.807 tigergraph|127.0.0.1:20446|00000000027 (DatabaseImportExport.java:504) Check data file exist: /app/tigergraph/tigergraph/backup/example/graph_Customer/SalesOrder.csv
I@20220930 13:13:07.807 tigergraph|127.0.0.1:20446|00000000027 (DatabaseImportExport.java:504) Check data file exist: /app/tigergraph/tigergraph/backup/example/graph_Customer/SalesOrderProduct.csv
I@20220930 13:13:07.807 tigergraph|127.0.0.1:20446|00000000027 (DatabaseImportExport.java:504) Check data file exist: /app/tigergraph/tigergraph/backup/example/graph_Customer/ordered_product.csv

From the logs, we can see that there is an issue with the graph graph_Customer Review the queries from this graph to find one that calls itself. Drop the query and reinstall it after the export