Question
I see errors like this in the theia log: org.postgresql.util.PSQLException: ERROR: large object 443111 does not exist
Is there anything that I can or should do?
Answer
If you often delete images then it is suggested to run a vacuum job to clean up the stale lobs.
Windows Steps
- Open a Command Prompt as Administrator
- Navigate to DigitalHive\PostgreSQL\bin
- Run this command and enter the Digital Hive database password when prompted:
vacuumlo -v -U postgres digitalhive
Linux Steps
- Navigate to DigitalHive\PostgreSQL\bin
- Run this command and enter the Digital Hive database password when prompted:
vacuumlo -v -U postgres digitalhive