Orphan Temp Table After PITR
| От | Selva manickaraja |
|---|---|
| Тема | Orphan Temp Table After PITR |
| Дата | |
| Msg-id | BANLkTimxxeE_6rt=+5X8VynGUX7rvr51VA@mail.gmail.com обсуждение исходный текст |
| Ответы |
PKs without indexes
(John P Weatherman <jweatherman91@alumni.wfu.edu>)
Re: Orphan Temp Table After PITR ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>) |
| Список | 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 по дате отправления: