Transaction error when running housekeeping

[Masood Movahedi]

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

[Stephen Douglas Scotti]

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.

[Masood Movahedi]

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.

[Alain Mazy]

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.

--
You received this message because you are subscribed to the Google Groups "Orthanc Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to orthanc-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/orthanc-users/0b792223-a553-468e-9f0d-a6d39258dd0en%40googlegroups.com.