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
Retry Logic when working with a Postgres Virtual Graph Bug	0	1224	April 29, 2020
Virtual Graph Connection and Logging Support	6	478	May 14, 2020
Reconnection does not retry to remote Virtual Graph Support	4	286	February 15, 2022
Stardog in Linux Support	3	583	May 8, 2018
Server stops querying downstream databases (Docker Stardog to Azure MySQL DB) Bug	3	351	August 9, 2021