What to Do If te-agent Stops Running Due to a VACUUM Error
Last updated
Last updated
The ThousandEyes Enterprise Agent stores results of tests in a local database. When the agent checks in with the ThousandEyes collector, the contents of the database are uploaded to the collector, and the database is purged. In certain circumstances, the local copy of the database can become corrupted, due in large part to disk I/O errors associated with the filesystem storing the database. This phenomenon is documented at https://www.sqlite.org/howtocorrupt.html.
When database corruption occurs the Agent will stop, and an error message will be seen in /var/log/te-agent.log, similar to the following:
As a result, the local database will be stopped and the Agent will be unable to operate. The Agent's status will be shown as "Offline" in the Agent Settings page, with a last contacted date of whenever the first VACUUM error occurred.
In order to resolve this, follow the instructions below, per the type of Enterprise Agent (Linux package or Virtual Appliance).
As root, stop the te-agent process, then go to the /var/lib/te-agent/ directory and remove the te-agent.sqlite file, then restart the te-agent process:
Ubuntu 18.04 and 20.04, Red Hat Enterprise Linux 7 and 8, CentOS 7:
Alternative method when package "initscripts" (RHEL 7, CentOS 7) is installed:
Log into the Virtual Appliance web console and click on the Advanced Settings tab. Click the Clear Result Cache button and confirm.
If steps described above do not resolve the issue or if the issue keeps reoccurring, please contact ThousandEyes Customer Engineering team using chat or support@thousandeyes.com email address.