search

ohdsi-studies / PioneerWatchfulWaiting

This study is part of the joint PIONEER - EHDEN - OHDSI studyathon in March 2021, and aims to advance understanding of clinical management and outcomes of watchful waiting in prostate cancer.
Apache License 2.0
7 stars 18 forks source link

Java error in runStudy #99

Closed bdemeulder closed 2 years ago

bdemeulder commented 2 years ago

In Open Claims data, Steven got this issue (data is in AWS redshift)

He did not cancel the request, the code loses the connection somehow:

image

MaximMoinat commented 2 years ago

@bdemeulder Did he manage to reproduce the problem? Any clues what might cause a drop in connection? (e.g. other services running against the database, routine restart of the server, etc.)

bdemeulder commented 2 years ago

@MaximMoinat, Steven says he tried to run it a couple of times and got the same issue. He says that he did not cancel the request but that the code loses the connection.

ahijazy commented 2 years ago

There is a similar issue on stackexchange, it seems that there is a QueryTimeout in latest JDBC driver, setQueryTimeout() should be called with non-zero value.

Here is the link to the stackexchange page: https://stackoverflow.com/questions/13114101/postgresql-error-canceling-statement-due-to-user-request