Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 0F6031337BD0 for ; Tue, 19 Apr 2011 05:41:01 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 63655-07 for ; Tue, 19 Apr 2011 08:40:43 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gy0-f174.google.com (mail-gy0-f174.google.com [209.85.160.174]) by mail.postgresql.org (Postfix) with ESMTP id E10961337B68 for ; Tue, 19 Apr 2011 05:40:42 -0300 (ADT) Received: by gyd10 with SMTP id 10so1647824gyd.19 for ; Tue, 19 Apr 2011 01:40:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:date:message-id:subject:from:to :content-type; bh=ZGzW16ZpptfwsCnDZZphcCfi1TQLHw6ZxqW/F0zdXTg=; b=skxNlh+H0CO6nB+gKVGeCW501uOxFNYerwqc6yYc9jUNRmUZcnENeaSO5UwhDoR5hz smeqVUEBSfWBHVm0pgfbWYsMuo4iu6r/6JcG83GvOmAEHMi/Y8paYCsqzdhP+hytqQo4 aYxA1vbHY+1GrLTRKIRaH3RbhXef16GGlA1Io= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=mV60foSt3UEkyLv8Mt8mNa1e5F3KiXdwShzsLnymmw2uax4OZZxcc4tzQ8Hj2HQAK1 6+idHjqjylOhNG9nh2r+dWoNcPjPJfPRolwoUmhJueCVVrtzPFNvErAxzNhfog4EyZwG ym4My6VqLfB3PI+UciJuttaNkwqf3Ki+Z0Mk0= MIME-Version: 1.0 Received: by 10.236.183.233 with SMTP id q69mr1036279yhm.402.1303202442334; Tue, 19 Apr 2011 01:40:42 -0700 (PDT) Received: by 10.236.105.235 with HTTP; Tue, 19 Apr 2011 01:40:42 -0700 (PDT) Date: Tue, 19 Apr 2011 16:40:42 +0800 Message-ID: Subject: Orphan Temp Table After PITR From: Selva manickaraja To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=20cf305b1224a5522204a141767b X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.334 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_ENVFROM_END_DIGIT=1.553, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RFC_ABUSE_POST=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201104/162 X-Sequence-Number: 37343 --20cf305b1224a5522204a141767b Content-Type: text/plain; charset=ISO-8859-1 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". --20cf305b1224a5522204a141767b Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Dear All,

We encountered this for th= e 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 f= ollowing errors start appearing in the log. So we tried running vacuumdb wi= th options All,Freeze,Analyze to see if that can clear the logs. That is wh= y we get the entries "
checkpoin= ts are occurring too frequently (11 seconds apart)" and so on. However= during and after the vacuumdb is completed the "orphan temp table&quo= t; entry keeps on printing in= the log. Anyone has any idea why this is happening?

2011-04-19 12:12:31 MYT LOG:=A0 connect= ion=20 received: host=3D[local]
2011-04-19 12:12:31 MYT LOG:=A0 connection=20 authorized: user=3Dpostgres database=3Dnp
2011-04-19 12:12:46 MYT LOG:= =A0=20 checkpoints are occurring too frequently (11 seconds apart)
2011-04-19= =20 12:12:46 MYT HINT:=A0 Consider increasing the configuration parameter=20 "checkpoint_segments".
2011-04-19 12:12:48 MYT LOG:=A0 checkpo= ints are=20 occurring too frequently (2 seconds apart)
2011-04-19 12:12:48 MYT=20 HINT:=A0 Consider increasing the configuration parameter=20 "checkpoint_segments".
2011-04-19 12:12:49 MYT LOG:=A0 checkpo= ints are=20 occurring too frequently (1 second apart)
2011-04-19 12:12:49 MYT HINT:= =A0=20 Consider increasing the configuration parameter=20 "checkpoint_segments".
2011-04-19 12:12:59 MYT LOG:=A0 autovac= uum: found=20 orphan temp table "pg_temp_108"."session_id" in databas= e "np"
2011-04-19=20 12:12:59 MYT LOG:=A0 autovacuum: found orphan temp table=20 "pg_temp_19"."session_id" in database "np"2011-04-19 12:12:59 MYT LOG:=A0=20 autovacuum: found orphan temp table "pg_temp_35"."session_id= " in database=20 "np"
2011-04-19 12:12:59 MYT LOG:=A0 autovacuum: found orphan = temp table=20 "pg_temp_18"."session_id" in database "np"2011-04-19 12:12:59 MYT LOG:=A0=20 autovacuum: found orphan temp table "pg_temp_21"."session_id= " in database=20 "np"
2011-04-19 12:12:59 MYT LOG:=A0 autovacuum: found orphan = temp table=20 "pg_temp_6"."session_id" in database "np"
= 2011-04-19 12:12:59 MYT LOG:=A0=20 autovacuum: found orphan temp table "pg_temp_42"."session_id= " in database=20 "np"
2011-04-19 12:12:59 MYT LOG:=A0 autovacuum: found orphan = temp table=20 "pg_temp_12"."session_id" in database "np"2011-04-19 12:12:59 MYT LOG:=A0=20 autovacuum: found orphan temp table "pg_temp_30"."session_id= " in database=20 "np"
2011-04-19 12:12:59 MYT LOG:=A0 autovacuum: found orphan = temp table=20 "pg_temp_17"."session_id" in database "np"2011-04-19 12:12:59 MYT LOG:=A0=20 autovacuum: found orphan temp table "pg_temp_8"."session_id&= quot; in database=20 "np"
2011-04-19 12:12:59 MYT LOG:=A0 autovacuum: found orphan = temp table=20 "pg_temp_44"."session_id" in database "np"2011-04-19 12:12:59 MYT LOG:=A0=20 autovacuum: found orphan temp table "pg_temp_46"."session_id= " in database=20 "np"
2011-04-19 12:12:59 MYT LOG:=A0 autovacuum: found orphan = temp table=20 "pg_temp_25"."session_id" in database "np"2011-04-19 12:12:59 MYT LOG:=A0=20 autovacuum: found orphan temp table "pg_temp_5"."session_id&= quot; in database=20 "np"
2011-04-19 12:12:59 MYT LOG:=A0 autovacuum: found orphan = temp table=20 "pg_temp_22"."session_id" in database "np"2011-04-19 12:12:59 MYT LOG:=A0=20 autovacuum: found orphan temp table "pg_temp_120"."session_i= d" in database=20 "np"
2011-04-19 12:12:59 MYT LOG:=A0 autovacuum: found orphan = temp table=20 "pg_temp_36"."session_id" in database "np"2011-04-19 12:12:59 MYT LOG:=A0=20 autovacuum: found orphan temp table "pg_temp_47"."session_id= " in database=20 "np"
2011-04-19 12:12:59 MYT LOG:=A0 autovacuum: found orphan = temp table=20 "pg_temp_13"."session_id" in database "np"2011-04-19 12:12:59 MYT LOG:=A0=20 autovacuum: found orphan temp table "pg_temp_14"."session_id= " in database=20 "np"
2011-04-19 12:12:59 MYT LOG:=A0 autovacuum: found orphan = temp table=20 "pg_temp_15"."tmp_swsv" in database "np"
2= 011-04-19 12:12:59 MYT LOG:=A0=20 autovacuum: found orphan temp table "pg_temp_69"."session_id= " in database=20 "np"
2011-04-19 12:13:05 MYT LOG:=A0 checkpoints are occurring= too=20 frequently (16 seconds apart)
2011-04-19 12:13:05 MYT HINT:=A0 Consider= =20 increasing the configuration parameter=20 "checkpoint_segments".
--20cf305b1224a5522204a141767b--