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".
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 |