Database Verification Reference (SQL)

Use these queries to confirm the internal state of a workflow's progress and object indexing within the SFArchive database.

1. Verify Volume Status 

Check specific volume metadata (capacity, status, group) using its Volume ID (vid).

SELECT * FROM SFArchive.nxn_volumes WHERE vid=1462;

2. Verify Object in Workflow Mirror Table

Confirm if a specific file has been indexed by Workflow ID 3 and verify its MD5 checksum.

SELECT * FROM SFArchive.nxn_mirror_3 WHERE checksum='9e4e882a36c76a724cca65c358565a7f';

Note: Per the manual, nxn_mirror_<N> is dynamically created by the engine for each workflow.

3. Verify Object in Main Archive

Check if the file has moved from the "Mirror" state into the permanent Objects table (meaning it is now part of the searchable archive).

SELECT * FROM SFArchive.nxn_objects WHERE filename='OAK13082125P02_2025-08-22_175048.mhl';

4. Inspect Full Workflow Progress

View all entries currently being processed or held in the Workflow 3 build table.

SELECT * FROM SFArchive.nxn_mirror_3;

? Technical Context (Aligned with Manual)

  • Mirror Tables (nxn_mirror_#): These are temporary staging tables. If a file appears here but not in nxn_objects, the Scan is still in progress or the Queue has not yet launched the archive job.
  • Checksums: The NxWorkflowEngine performs MD5 checksums on discovered objects. If the checksum in nxn_mirror_3 matches a known object, the engine will report that the item "exists in the current build table" and skip re-archiving.
  • Database Name: The production schema is SFArchive.

?️ Workflow Monitoring SOP (Step 7: SQL Validation)

When to use: Use these steps if the logs are moving slowly and you want to see exactly how many rows have been processed so far.

  1. Log into MySQL - MySQL Workbenh
  2. Check Scan Count:
    SELECT count(*) FROM nxn_mirror_3;
    Run this twice with a 5-minute gap. If the count is increasing, the scan is actively finding new objects.
  3. Verify Specific File:
    Use the filename or checksum queries above to ensure a critical file has been "seen" by the engine.