Description of problem:
When having lot of objects in pg_largeobject operation Remove orphan large objects fails with did not complete after 700827 ms.
I had 606 distinct objects there out of which 600 were representing war files (10MB each).
It seems the operation finished eventually because second invocation took 2s and result was Query removed 0 orphan large objects.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. install JON3.3.7 with postgresql 9.x
2. deploy 300 different wars to EAP, size of each war should be 10MB
3. upgrade to JON 3.3.8
4. run Remove orphan large objects (rhq Postgres Server->rhq database->Operations)
Operations fails with did not complete after 700827 ms
But it seems the clean up job was finished eventually. All orphaned objects from pg_largeobject were removed.
Operation is successful
Closing as not a bug since it's possible to define operation timeout in UI.