I was able to upgrade and run the Housekeeper on one of my populated development instances with a 208 studies on it. It did not take that long really, like maybe 90 minutes with a 5 second throttle delay.
For the most part that seems to have worked, but with a few warnings and errors, e.g.
W0312 07:48:56.842954 PluginsManager.cpp:157] Housekeeper: your storage might still contain some dicom-as-json files -> will perform housekeeping
W0312 07:48:56.842974 PluginsManager.cpp:157] Housekeeper: Study main dicom tags have changed, -> will perform housekeeping
W0312 07:48:56.842983 PluginsManager.cpp:157] Housekeeper: Series main dicom tags have changed, -> will perform housekeeping
W0312 07:48:56.842990 PluginsManager.cpp:157] Housekeeper: Instance main dicom tags have changed, -> will perform housekeeping
W0312 07:48:56.842997 PluginsManager.cpp:157] Housekeeper: the DB configuration has changed since last run, will reprocess the whole DB !
W0312 07:48:57.132879 ServerToolbox.cpp:259] Reconstructing resource c88c15f5-6c2eddaf-7fc3cf72-149b63e5-d3553f9e
W0312 07:49:05.379419 ServerToolbox.cpp:259] Reconstructing resource 4376185a-280d89fd-0848ec74-fc4769fa-1d0ed6c7
W0312 07:49:13.092274 ServerToolbox.cpp:259] Reconstructing resource 4ae8d3ad-749abf08-6c30b089-c3a7c09b-5be8d54f
W0312 07:49:37.649298 ServerToolbox.cpp:259] Reconstructing resource 3c961f6f-3fc282fb-5261da2a-1d8196ac-efacde45
W0312 07:49:42.950616 ServerToolbox.cpp:259] Reconstructing resource f94ee238-3ca423bf-9ffdff8b-ea26a8f5-6db5631f
W0312 07:49:49.467824 ServerToolbox.cpp:259] Reconstructing resource c8cf78c5-c6cee467-27a2b379-16d88500-a5162b82
W0312 07:49:54.668209 ServerToolbox.cpp:259] Reconstructing resource ac56a206-39789ffc-ec096792-ac465dac-0e3c416a
E0312 07:50:37.068147 PluginsManager.cpp:153] PostgreSQL error: ERROR: could not serialize access due to read/write dependencies among transactionsDETAIL: Reason code: Canceled on identification as a pivot, during commit attempt.
HINT: The transaction might succeed if retried.E0312 07:50:37.072046 ServerContext.cpp:290] Cannot serialize the jobs engine: Error with the database engine
W0312 07:50:39.153579 ServerToolbox.cpp:259] Reconstructing resource 9dd82f92-c9e9c114-452c23ea-adce9e1b-5f740dd9
. . .
W0312 08:35:06.985734 ServerContext.cpp:2438] W002: study has been stored with another version of Main Dicom Tags list, you should POST to /studies/035d979a-b747accf-5c6062c1-bf8fb5e0-e857b2a4/reconstruct to update the list of tags saved in DB. Some MainDicomTags might be missing from this answer.
W0312 08:35:06.996774 ServerContext.cpp:2438] W002: study has been stored with another version of Main Dicom Tags list, you should POST to /studies/046dc1bf-8952cdfd-50a7d6df-a846ea9b-c40714bf/reconstruct to update the list of tags saved in DB. Some MainDicomTags might be missing from this answer.
..
W0312 08:43:28.383196 ServerToolbox.cpp:259] Reconstructing resource f55579a9-f511738e-254c1142-dde9981d-88e6be33
W0312 08:43:33.717292 ServerToolbox.cpp:259] Reconstructing resource 74170bd9-44bcf3f4-836302b5-14950e5e-74c70ace
W0312 08:43:49.013968 ServerToolbox.cpp:259] Reconstructing resource bc17714d-4ffebb59-6b2e623a-132bb248-75ea8226
W0312 08:43:56.782957 ServerToolbox.cpp:259] Reconstructing resource e0099f12-302dce0c-5882e930-ab12a514-919efdd2
W0312 08:44:34.507525 PluginsManager.cpp:157] Housekeeper: finished processing all changes
I will have to run through the studies and view them also with the Stone Viewer, but it seems like everything updated and there does not appear to be an issue in the Stone Viewer with PDF's.
"StorageAccessOnFind" : "Never",
I suspect that maybe that was related to "SOPClassUID" now being available in the DB ?
Just wondering if I need to worry about the erros and warnings that I got. There are quite a few with the you should POST to /studies/ ..., but I'm wondering if that is being done automatically now because I have the most recent version of Orthanc now, 1.11.3, and that supposed does a reconstruction after a modification ?
Stephen D. Scotti, MD