Tag: Steps to Moving Database

Categories
Knowledge Support Support exacqVision Server Categories Uncategorized

Moving Eventpi.DB file to New Drive

*** INTERNAL USE ***

Description 

We have found that event links based on triggers from AI Object Classification events flood the eventPI database resulting in the OS drive being filled in a short amount of time. Periodic unexpected crashes, system reboots and increased memory usage have resulted. This happens when the amount of AI metadata captured in the eventPI database exceeds the available free space on the drive.

Product 

  • exacqVision Server [All versions]

Prerequisites

  1. Follow Best Practice recommendations as outlined in Analytic Metadata Best Practices
  2. If your license allows, update the exacqVision Server and Client instances to 23.09 or higher to take advantage of the Maximum Days to Keep Bounding Box Metadata control. Try this solution prior to moving the eventpi.db.
    Maximum Days to Keep Bounding Box Metadata Explained
  3. Moving the eventpi.db should be considered an extreme final effort reserved for those that insist on long term retention of large amounts of metadata.
  4. When moving eventpi.db, you should only do so onto a newly installed NVMe or SSD drive designed for frequent writes. We strongly advise selecting drives with specs of 2500 TBW (Terabytes Written) or higher. Systems without available NVMe slots, such as the 4U A-Series, will need to rely on Internal NAND SSD.
    • Recommended WD Red options:
      • NVMe – WDS200T1R0C
      • NVMe – WDS400T1R0C
      • SATA SSD – WDS400T1R0A

WARNING: We DO NOT recommend by any means, moving the database onto a video recording drive.

Solution

NOTE: If your license allows, update the exacqVision Server and Client instances to 23.09 or higher to take advantage of the Maximum Days to Keep Bounding Box Metadata control. Try this solution prior to moving the eventpi.db.
Maximum Days to Keep Bounding Box Metadata Explained

Move the eventpi.db database according to the following procedure:

  1. Stop Server Service
  2. Go to C: > Program Files > exacqVision > Server > eventpi (there is a Database File and XML Document named “eventpi”; you want Database File)
  3. Copy eventpi.db to new Volume location
  4. Modify eventpi.xml ‘DatabaseName’ attribute to new db path (If no “DatabaseName” attribute inside the <Events…> node then add it to the Events node
  5. Restart Server Service
  6. Conduct a search to make sure its working,
  7. Monitor/View new eventpi.db size and make sure it is growing
  8. The eventpi.db in the original location can now be removed

eventpi.db File

eventpi.xml (Modify Database Name)

Related Articles

AESW-5987