Orphan Temp Table After PITR

From: Selva manickaraja <mavles78(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Orphan Temp Table After PITR
Date: 2011-04-19 08:40:42
Message-ID: BANLkTimxxeE_6rt=+5X8VynGUX7rvr51VA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dear All,

We encountered this for the 3rd time after completing a PITR.

The database starts up as usual and we could carry out the read and write
transactions. After a while the following errors start appearing in the log.
So we tried running vacuumdb with options All,Freeze,Analyze to see if that
can clear the logs. That is why we get the entries "checkpoints are
occurring too frequently (11 seconds apart)" and so on. However during and
after the vacuumdb is completed the "orphan temp table" entry keeps on
printing in the log. Anyone has any idea why this is happening?

2011-04-19 12:12:31 MYT LOG: connection received: host=[local]
2011-04-19 12:12:31 MYT LOG: connection authorized: user=postgres
database=np
2011-04-19 12:12:46 MYT LOG: checkpoints are occurring too frequently (11
seconds apart)
2011-04-19 12:12:46 MYT HINT: Consider increasing the configuration
parameter "checkpoint_segments".
2011-04-19 12:12:48 MYT LOG: checkpoints are occurring too frequently (2
seconds apart)
2011-04-19 12:12:48 MYT HINT: Consider increasing the configuration
parameter "checkpoint_segments".
2011-04-19 12:12:49 MYT LOG: checkpoints are occurring too frequently (1
second apart)
2011-04-19 12:12:49 MYT HINT: Consider increasing the configuration
parameter "checkpoint_segments".
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_108"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_19"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_35"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_18"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_21"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_6"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_42"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_12"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_30"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_17"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_8"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_44"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_46"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_25"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_5"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_22"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_120"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_36"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_47"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_13"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_14"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_15"."tmp_swsv" in database "np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_69"."session_id" in database "np"
2011-04-19 12:13:05 MYT LOG: checkpoints are occurring too frequently (16
seconds apart)
2011-04-19 12:13:05 MYT HINT: Consider increasing the configuration
parameter "checkpoint_segments".

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message H S 2011-04-19 08:53:32 Re: "postgres" is needed by initdb but was not found
Previous Message Gerhard Hintermayer 2011-04-19 08:09:04 Re: Streaming replication: rsync to switchover