A database is a system file, this means that any issue with writing to disk can cause a database corruption. When the GSX Analyzer database becomes corrupt, you may notice specific error messages when logging into GSX Analyzer, or when managing the database via GSX Analyzer Manager.
This article shows how to identify and repair a corrupt GSX Analyzer database.
GSX Analyzer
Symptoms
- An error has occurred when verifying login : GetWSCheckLogin: I/O error for file "GsxAnalyzer".
- ERROR: Backup Error : Exception of type 'FirebirdSql.Data.Common.IscException' was thrown.
How to Solve the Issue
Possible causes of database corruption include, but are not limited to:
- Hard reboot of a server.
- Aging server hardware.
- Limited server resources.
- Database file copy or access while the Firebird Server is running.
- Third party database write locks in place.
- Low disk space during database maintenance such as compact.
To fix the GSX Analyzer database we need to:
- Stop the GSX Analyzer Agent and restart the Firebird Server services.
- Run the GSX Analyzer Database Repair Utility.
- Compact the GSX Analyzer Database.
Stop the GSX Analyzer Agent and restart the Firebird Server Services:
- Launch Services.msc to open the Windows Services Manager.
- Stop the GSX Analyzer Agent service:
- Restart the Firebird Server Service:
Run the GSX Analyzer Database Repair Utility
- Open a Windows Elevated Command Prompt.
- Run one of the following commands depending on the Firebird bit version:
Change the <GSX Analyzer install path> entry to match your actual GSX Analyzer install path, e.g.: "C:\GSX Analyzer\Config\Analyzer.fdb".
For 64-bit Firebird, use:
- C:\Program Files\Firebird\Firebird_2_0\bin\gfix -mend -full -ignore -user SYSDBA -password "masterkey" localhost:"<GSX Analyzer install path>\Config\Analyzer.fdb"
For 32-bit Firebird, use:
- C:\Program Files (x86)\Firebird\Firebird_2_0\bin\gfix -mend -full -ignore -user SYSDBA -password "masterkey" localhost:"<GSX Analyzer install path>\Config\Analyzer.fdb"
In this example, GSX Analyzer is installed on drive D: of a 32-bit operating system:
Compact the GSX Analyzer Database
- From the Start menu, navigate to All Programs > GSX > GSX Analyzer Administrative Tools > GSX Analyzer Manager.
- Select Database.
- Select Compact Database.
- Once the compaction is complete, click Yes to confirm the database deletion:
- Close the GSX Analyzer Manager.
- Start the GSX Analyzer Agent from Services.msc.
- Launch GSX Analyzer and log in to verify that everything is now working as expected: