Troubleshooting QuerySurge Database Disk Issues

Versions: 8.0+

Disk Usage Notifications

QuerySurge monitors your disk usage, and if any monitor exceeds a notification threshold (see this Knowledge Base article for details), a pop-up notification will be displayed to all users. (If configured, an email notification may also be sent by QuerySurge.) Your pop-up will look like:

If you receive pop-up notifications such as this while logged into QuerySurge, you may be in danger of data loss. Do not ignore these notifications.

What to do if you receive an alert

If you receive an alert, it is time for disk management, without delay. A QuerySurge Admin user will need to remove results data from the QuerySurge database to recover disk space for ongoing work. See this Knowledge Base article on options for managing your disk usage.

IMPORTANT! When you start receiving an alert, do not delay disk management procedures. You may be less than a single action or execution away from a full disk.

If you fill up your disk

If you run out of disk space on your database disk, your QuerySurge instance will most likely become unstable, and it may stop functioning. Depending on circumstances, you may lose data, possibly irrecoverably. Do not try to resolve this issue yourself; get in touch with QuerySurge support for a resolution.

CRITICAL! If this situation occurs, stop using QuerySurge immediately. Do not attempt to restart QuerySurge services. Do not attempt to run executions or other tasks.

CRITICAL! Under no circumstances should you move or delete any files in your QuerySurge install directory or in QuerySurge's database directory. Any actions that you take on your own may result in irrecoverable data loss.

Backup your Database

Your only insurance against irrecoverable data loss from an outage of any sort is a regular database backup procedure. We recommend a nightly backup, however you should check with your organization on backup policies, options for automated backup, etc.

CRITICAL! Without a regular backup procedure, you risk irrecoverable data loss in an outage. See this Knowledge Base article on QuerySurge backup procedures.