Article ID: 6622, created on Aug 18, 2009, last review on Aug 12, 2014

  • Applies to:
  • Virtuozzo containers for Linux 4.0
  • Virtuozzo containers for Windows 4.0

Symptoms

Parallels Infrastructure Manager (PIM) stores events, resource logs, and operation logs in a database inside the service container. If the Master node in PIM is a Windows Microsoft SQL server, Desktop Engine (MSDE) is used as a database store inside the service container. MySQL is used if the Master node in PIM is a Linux server.

MSDE has a limitation that does not allow you more than 2 GB of the database. PIM data may grow beyond the limit, however. If this occurs, it is recommended to clear the database of old events, resource logs, and operation logs.

Resolution

This article provides scripts that clear the database of old records on the Master node of the PIM infrastructure.

If the Master node is a Windows 2003 server, use the attached win_w2k3_remove_old_logs.cmd script.
If the Master node is a Windows 2008 server, use the attached win_w2k8_remove_old_logs.cmd script.
Note that the script has a hardcoded DAYS_TO_LEAVE variable (number of days for which DB entries are left). The value is changed directly in the script file.

If the Master node is a Linux server, use the attached lin_remove_old_logs.sh script. The Linux script accepts the DAYS_TO_LEAVE value as a command line parameter.

Additional Information

For PVA 4.5 and 4.6, refer to this article:
111273 How to delete old events, resource logs, and operation logs from PVA Management Node database

Attachments

28d0f7cc091e3b9304fa556c03f9a940 d02f9caf3e11b191a38179103495106f 965b49118115a610e93635d21c5694a8 35c16f1fded8e42577cb3df16429c57a e8e50b42231236b82df27684e7ec0beb 2897d76d56d2010f4e3a28f864d69223

Email subscription for changes to this article
Save as PDF