Cleaning up Stale Lobs

Cleaning up Stale Lobs

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

  1. Open a Command Prompt as Administrator
  2. Navigate to DigitalHive\PostgreSQL\bin
  3. Run this command and enter the Digital Hive database password when prompted:
    vacuumlo -v -U postgres digitalhive

Linux Steps

  1. Navigate to DigitalHive\PostgreSQL\bin
  2. Run this command and enter the Digital Hive database password when prompted:
    vacuumlo -v -U postgres digitalhive


    • Related Articles

    • Backing up the Digital Hive Content Store

      Question Is there a way to backup the Digital Hive content store? Answer Digital Hive uses PostgreSQL as the application content store. As part of the Digital Hive platform, a daily process executes that creates an archive of the entire content ...