Purpose:

You receive the error, “database or disk is full vacuum” on the following Database Access Failed window:

Or the More Info window:

Resolution:

There are two options to resolution:

1. Check and free up disk space on the PDQ Console machine.

2. Run the vacuum command via the SQLite console. To do so, see the instructions below:

Run the vacuum command from the SQLite console

Warning | Precaución | Auchtung | Mise en garde | Attenzione

Modifying the SQLite database in an incorrect manner may result in unintended consequences up to and including irrecoverable data loss; a corrupt database requiring the complete uninstall and reinstall of the program; and existential dread associated with being alone in an uncaring, meaningless and indifferent universe. It is strongly recommended you stop the PDQ Inventory service and make a backup of the the .db* files located in %programdata%\Admin Arsenal\PDQ Inventory before accessing the SQLite console.

1. Open a command prompt and enter the following:

sqlite3 "%ProgramData%\Admin Arsenal\PDQ Inventory\Database.db"

You should see something like this:

2. Type in the following command at the sqlite> prompt (make sure to include the semicolon):

vacuum;

Once the vacuum command has been run, you will be returned to the sqlite> prompt. You can now close the SQLite console.

3. [OPTIONAL] As an alternative to running vacuum, you can also optimize the database using the following command from a command prompt,

pdqinventory optimizedatabase

IMPORTANT: If pdqinventory.exe is not in your path, you can locate the executable in drive:\Program Files (x86)\Admin Arsenal\PDQ Inventory\ or on 32-bit OSs, drive:\Program Files\Admin Arsenal\PDQ Inventory\.

Thanks to Charley, our QA nuclear scientist, for needling out this issue.

See Also:

Not Enough Space on the Disk

PDQ Inventory is Running Slowly -Some Tips to Speed it Up

SQLite Commands