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 ...

    • What's New in the 2024.2 Digital Hive Release

      This articles details the new product features, enhancements, and resolved issues, that were included as part of the Digital Hive 2024.2 release. New Features & Enhancements Control Center - Search tab Search is a very powerful use case within ...