autovaccum task got cancelled

From: Gary Fu <gfu(at)sigmaspace(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: autovaccum task got cancelled
Date: 2013-10-31 18:51:42
Message-ID: 5272A6BE.6070700@sigmaspace.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I'm running an application (with programs in Perl) through pgpool 3.1
with replication mode to two postgresql db servers (version 9.0.13).
Recently, I noticed that the following messages repeatedly showed in
postgres log files. As far as I know, the application programs do not
make any specific lock on the 'file' table. I'm not sure if it is
caused by the pgpool or something else.

Thanks for any help in advance.
Gary

2013-10-31 17:58:56 UTCDETAIL: Process 8580 waits for
ShareRowExclusiveLock on relation 11959608 of database 596746.
2013-10-31 17:58:56 UTCSTATEMENT: LOCK TABLE "file" IN SHARE ROW
EXCLUSIVE MODE
2013-10-31 17:58:56 UTCERROR: canceling autovacuum task
2013-10-31 17:58:56 UTCCONTEXT: automatic vacuum of table
"sd3ops1.public.file"
2013-10-31 18:01:30 UTCLOG: sending cancel to blocking autovacuum PID 8614
2013-10-31 18:01:30 UTCDETAIL: Process 8677 waits for
ShareRowExclusiveLock on relation 11959608 of database 596746.
2013-10-31 18:01:30 UTCSTATEMENT: LOCK TABLE "file" IN SHARE ROW
EXCLUSIVE MODE
2013-10-31 18:01:30 UTCERROR: canceling autovacuum task
2013-10-31 18:01:30 UTCCONTEXT: automatic vacuum of table
"sd3ops1.public.file"
2013-10-31 18:01:49 UTCLOG: could not receive data from client:
Connection reset by peer
2013-10-31 18:01:49 UTCLOG: unexpected EOF within message length word
2013-10-31 18:02:04 UTCLOG: sending cancel to blocking autovacuum PID 8753
2013-10-31 18:02:04 UTCDETAIL: Process 8777 waits for
ShareRowExclusiveLock on relation 11959608 of database 596746.
2013-10-31 18:02:04 UTCSTATEMENT: LOCK TABLE "file" IN SHARE ROW
EXCLUSIVE MODE
2013-10-31 18:02:04 UTCERROR: canceling autovacuum task
2013-10-31 18:02:04 UTCCONTEXT: automatic vacuum of table
"sd3ops1.public.file"
2013-10-31 18:03:09 UTCLOG: sending cancel to blocking autovacuum PID 8782
2013-10-31 18:03:09 UTCDETAIL: Process 8806 waits for
ShareRowExclusiveLock on relation 11959608 of database 596746.
2013-10-31 18:03:09 UTCSTATEMENT: LOCK TABLE "file" IN SHARE ROW
EXCLUSIVE MODE
2013-10-31 18:03:09 UTCERROR: canceling autovacuum task
2013-10-31 18:03:09 UTCCONTEXT: automatic vacuum of table
"sd3ops1.public.file"
2013-10-31 18:04:04 UTCLOG: sending cancel to blocking autovacuum PID 8810
2013-10-31 18:04:04 UTCDETAIL: Process 8395 waits for
ShareRowExclusiveLock on relation 11959608 of database 596746.
2013-10-31 18:04:04 UTCSTATEMENT: LOCK TABLE "file" IN SHARE ROW
EXCLUSIVE MODE

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2013-10-31 18:53:24 postgresql-9.3.1-1-windows-x64.exe does not install correctly for me
Previous Message Adrian Klaver 2013-10-31 18:22:29 Re: Table with Field Serial - Problem