Issue15

Title PostgreSQL exceptions after time
Priority bug Status resolved
Superseder Nosy List admin
Assigned To
Keywords Plugin - PostgreSQL

Created on 2016-02-22.08:09:50 by admin, last changed by admin.

Messages
msg56 (view) Author: admin Date: 2016-02-22.08:09:50
[BitBucket user: Toshko Andreev]
[BitBucket date: 2016-02-22.07:09:50]

I've been running Orthanc with the PostgreSQL plugins for some time now and it appears that after about 10 hours of inactivity an exception occurs with Postgre:

```
#!Log
E0220 03:20:51.562601 PluginsManager.cpp:163] Exception in database back-end: Error in PostgreSQL: server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.


E0220 06:51:03.924868 PluginsManager.cpp:163] Exception in database back-end: Error in PostgreSQL: no connection to the server
```

Orthanc at that point becomes broken and cannot work until you restart the service (Windows 7 x64).
msg57 (view) Author: admin Date: 2016-02-24.10:44:27
[BitBucket user: Sébastien Jodogne]
[BitBucket date: 2016-02-24.09:44:27]

This issue was discussed on the mailing list: https://groups.google.com/d/msg/orthanc-users/RQOqFB-zDmc/qqSJoVzqBAAJ

This timeout problem can be solved by enabling keep alive (e.g. to 120 seconds) in the configuration of the PostgreSQL server: http://dba.stackexchange.com/questions/97534/is-there-a-timeout-option-for-remote-access-to-postgresql-database
History
Date User Action Args
2026-07-29 15:51:18admincreate