Author: Tom_Wyszomierski
Last Modified Date: 7/30/2014
Description:This article reviews the Error: "vacuumdb: vacuuming of database "cemdb" failed: ERROR: canceling statement due to statement timeout", when running the Vacuum command on a Postgres database(s).Solution:When the vacuumdb command runs, it connects to the database and then executes a VACUUM statement. If that statement processes longer than the configured statement timeout value for that database, then the command is canceled, and the above error is logged. To avoid this error, try the following:
Search the Entire CA APM Knowledge Base