I had a delay in querying Stardog and Postgres of about a half hour (had to take a call). Things were working. After the delay ... Studio (even after restart) is returning the error ... 000012: Unable to execute virtual graph query. SQL string: SELECT "xx", "yy", "zz" FROM "schema"."tableName" WH…

Dropped connection from Postgres DB requires Stardog Server restart

arwesterinen (Andrea Westerinen) July 7, 2020, 7:46pm 4

To close this out .... We resolved this by setting Postgres' testOnBorrow and testWhileIdle TRUE, and setting timeBetweenEvictionRunsMillis to 2000.

Andrea

2 Likes

Reconnection does not retry to remote Virtual Graph

Topic		Replies	Views
Server stops querying downstream databases (Docker Stardog to Azure MySQL DB) Bug	3	302	August 9, 2021
Something went wrong error message in StarDog Studio after 60 seconds Bug	3	514	February 11, 2019
Query timeout when running the query Support	5	340	January 25, 2022
Any reason for a Postgres timeout after 1min? Support	5	405	July 22, 2020
Received query error with Postgres VG Bug	2	488	July 18, 2020