Start a new topic
Solved

ERROR: canceling autovacuum task

The server logs contain entries like the following:


2023-09-13 04:47:48.698 UTC [2198254] ERROR: canceling autovacuum task
2023-09-13 04:47:48.698 UTC [2198254] CONTEXT: while cleaning up index
"idx_user_ssh_authorized_keys_username" of relation
"public.user_ssh_authorized_keys"


is this a problem?

1 Comment

In general no, it is expected to happen. Basically what that error message means is that when Postgres was doing its automatic background table cleanup tasks, a query came in that couldn't run with the cleanup task concurrently, so Postgres canceled cleaning up to let the query run. Unfortunately Postgres logs it at an "error" level instead of an "info" or other less severe level.

Login or Signup to post a comment