Network Management

Collector SQLite queues purge

How to clear Collector SQLite queues

First published date

11/18/2021 12:50 PM

Last published date

4/22/2025 4:51 PM

Overview

While checking the size of the queues for the Collector service in the following folder: 
  • %ProgramData%\SolarWinds\Collector\Queues\
There are queues (*.db) that are not on default values (16 KB).

Product section

Orion Platform

Cause

  • SQL Server is not able to keep up with the SolarWinds Server and the polled information is starting to be stored in local storage. 
  • SQL Server is not accessible

Resolution

The issue initially needs to be resolved on the SQL Server side. Following the resolution of the issue relating to SQL Server the queues can be purged by following these steps: 

Option 1

If any issue occurs, there is a way how to easily purge problematic queues.

  1. RDP to the SolarWinds server
  2. Stop SolarWinds Collector service (e.g. in SolarWinds Platform Service Manager)
  3. Open File Explorer and navigate to folder C:\ProgramData\SolarWinds\Collector\Queues
  4. Delete problematic queue - file is named by the queue name (e.g. *.db)
  5. Start SolarWinds Collector service (e.g. in SolarWinds Platform Service Manager) so it will recreate the queue from scratch

Option 2

  1. RDP to the SolarWinds server 
  2. Open PowerShell as Administrator 
  3. Execute the following: 
    # Scripts are not supported under any SolarWinds support program or service.
# Scripts are provided AS IS without warranty of any kind. SolarWinds further
# disclaims all warranties including, without limitation, any implied warranties
# of merchantability or of fitness for a particular purpose. The risk arising
# out of the use or performance of the scripts and documentation stays with you.
# In no event shall SolarWinds or anyone else involved in the creation,
# production, or delivery of the scripts be liable for any damages whatsoever
# (including, without limitation, damages for loss of business profits, business
# interruption, loss of business information, or other pecuniary loss) arising
# out of the use of or inability to use the scripts or documentation.

Get-Service -DisplayName "SolarWinds Collector Service" | Select-Object -Property Name | Stop-Service -Force
Get-ChildItem C:\ProgramData\SolarWinds\Collector\Queues\*.db | where-object {$_.length -gt 16384} | rename-item -newname {$_.Name + ".old"} -Force
Get-Service -DisplayName "SolarWinds Collector Service" | Select-Object -Property Name | Set-Service -StartupType Automatic -Status Running
Get-ChildItem C:\ProgramData\SolarWinds\Collector\Queues\*.old | Remove-Item -Force