Orphan Temp Table After PITR - Mailing list pgsql-admin
| From | Selva manickaraja |
|---|---|
| Subject | Orphan Temp Table After PITR |
| Date | |
| Msg-id | BANLkTimxxeE_6rt=+5X8VynGUX7rvr51VA@mail.gmail.com Whole thread Raw |
| Responses |
PKs without indexes
Re: Orphan Temp Table After PITR |
| List | 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".
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".
pgsql-admin by date: