Hi
I am using orthanc with osimis docker images + postgres. When I enable housekeeping plugin, I encounter following error and orthanc crash:
=> PluginsManager.cpp:153] PostgreSQL error: ERROR: current transaction is aborted, commands ignored until end of transaction block
orthanc.log (54.4 KB)
orthanc.json (2.17 KB)
I just ran the HouseKeeper recently also and got a number of errors and / or warnings, but not that one, and I think mine succeeded because of my postgres settings.
My thread for that is here: https://groups.google.com/g/orthanc-users/c/FkrANLO-Ebw
You might want to check this page about the postgres plug-in config:
https://book.orthanc-server.com/plugins/postgresql.html, particularly these:
“MaximumConnectionRetries” : 10, // New in release 3.0
“ConnectionRetryInterval” : 5, // New in release 3.0
“IndexConnectionsCount” : 1 // New in release 4.0
since it may be that your retries, etc. might be set to something different.
Otherwise, might be something more problematic: e.g. https://stackoverflow.com/questions/10399727/psqlexception-current-transaction-is-aborted-commands-ignored-until-end-of-tra
Stephen D. Scotti, M.D.
I increased “ConnectionRetryInterval” time and also set “CheckRevision” to “true” but didn’t help. I do not think it a concurrency problem. As mentioned here, it is caused by continuing on a failed transaction.
I am using Postgres 14 and orthanc 1.11.3.
With housekeeping disabled, calling /tools/reconstruct (“ReconstructFiles”: false) returns 200. But calling reconstruct with (“ReconstructFiles”: true) fails with no error.
I removed database files and imported dicom files again on new instance of orthanc but error repeated.
Hi Masood,
Could you provide us with a complete standalone sample that would allow us to reproduce the issue ?
Typically, a docker-compose setup would be perfect with a few sample images (anonymized).
Best regards,
Alain.