Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id DA6339066D3 for ; Thu, 7 Jun 2012 15:02:00 -0300 (ADT) Received: from snt0-omc1-s13.snt0.hotmail.com ([65.55.90.24]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Sch1s-0005Ju-CY for pgsql-admin@postgresql.org; Thu, 07 Jun 2012 18:01:59 +0000 Received: from SNT139-W52 ([65.55.90.8]) by snt0-omc1-s13.snt0.hotmail.com with Microsoft SMTPSVC(6.0.3790.4675); Thu, 7 Jun 2012 11:01:38 -0700 Message-ID: Content-Type: multipart/alternative; boundary="_805e6c29-d697-4bca-b96c-fb2b14448812_" X-Originating-IP: [10.13.194.10] From: Fabricio To: Subject: could not rename temporary statistics file "pg_stat_tmp/pgstat.tmp" to "pg_stat_tmp/pgstat.stat": No such file or directory Date: Thu, 7 Jun 2012 11:01:37 -0700 Importance: Normal In-Reply-To: References: MIME-Version: 1.0 X-OriginalArrivalTime: 07 Jun 2012 18:01:38.0538 (UTC) FILETIME=[95CB04A0:01CD44D7] X-Pg-Spam-Score: -1.7 (-) X-Archive-Number: 201206/22 X-Sequence-Number: 39613 --_805e6c29-d697-4bca-b96c-fb2b14448812_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi. I have this problem: I have PostgreSQL 9.1.3 and the last night crash it. This was the first error after an autovacuum (the night before last): <2012-06-06 00:59:07 MDT 814 4fceffbb.32e=20 >LOG: autovacuum: found orphan temp table=20 "(null)"."tmpmuestadistica" in database=20 "dbRX" <2012-06-06 01:05:26 MDT 1854 4fc7d1eb.73e=20 >LOG: could not rename temporary statistics file=20 "pg_stat_tmp/pgstat.tmp" to "pg_stat_tmp/pgstat.stat": No such file or=20 directory <2012-06-06 01:05:28 MDT 1383 4fcf0136.567 >ERROR: tuple concurrently u= pdated <2012-06-06 01:05:28 MDT 1383 4fcf0136.567 >CONTEXT: automatic vacuum o= f table "global.pg_catalog.pg_attrdef" <2012-06-06 01:06:09 MDT 1851 4fc7d1eb.73b >ERROR: xlog flush request=20 4/E29EE490 is not satisfied --- flushed only to 3/13527A10 <2012-06-06 01:06:09 MDT 1851 4fc7d1eb.73b >CONTEXT: writing block 0 of= relation base/311360/12244_vm <2012-06-06 01:06:10 MDT 1851 4fc7d1eb.73b >ERROR: xlog flush request=20 4/E29EE490 is not satisfied --- flushed only to 3/13527A10 <2012-06-06 01:06:10 MDT 1851 4fc7d1eb.73b >CONTEXT: writing block 0 of= relation base/311360/12244_vm <2012-06-06 01:06:10 MDT 1851 4fc7d1eb.73b >WARNING: could not write bl= ock 0 of base/311360/12244_vm <2012-06-06 01:06:10 MDT 1851 4fc7d1eb.73b >DETAIL: Multiple failures -= -- write error might be permanent. Last night it was terminated by signal 6.=20 <2012-06-07 01:36:44 MDT 2509 4fd05a0c.9cd >LOG: startup process (PID 2= 525) was terminated by signal 6: Aborted <2012-06-07 01:36:44 MDT 2509 4fd05a0c.9cd >LOG: aborting startup due t= o startup process failure <2012-06-07 01:37:37 MDT 2680 4fd05a41.a78 >LOG: database system shutdown was interrupted=3B last known up at 2012-06-07 01:29:40 MDT <2012-06-07 01:37:37 MDT 2680 4fd05a41.a78 >LOG: could not open file "pg_xlog/000000010000000300000013" (log file 3=2C segment 19): No such file or directory <2012-06-07 01:37:37 MDT 2680 4fd05a41.a78 >LOG: invalid primary checkp= oint record And the only option was pg_resetxlog. After this a lot of querys showed me this error: =20 <2012-06-07 09:24:22 MDT 1306 4fd0c7a6.51a >ERROR: missing chunk number= 0 for toast value 393330 in pg_toast_2619 <2012-06-07 09:24:31 MDT 1306 4fd0c7a6.51a >ERROR: missing chunk number= 0 for toast value 393332 in pg_toast_2619 I lost some databases. I restarted the cluster again with initdb and then I restored the database= s that I could backup (for the other I restored an old backup)=20 no space or permissions problem. No filesystem or disk error. Can you help me to know what happened? Thanks and regards... = --_805e6c29-d697-4bca-b96c-fb2b14448812_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi.

I have this problem:

I have PostgreSQL 9.1.3 and the last= night crash it.

This = was the first error after an autovacuum (the night before last):

<=3B2012-06= -06 00:59:07 MDT =3B =3B =3B 814 4fceffbb.32e=20 >=3BLOG: =3B autovacuum: found orphan temp table=20 "(null)"."tmpmuestadistica" in database=20 "dbRX"
<=3B2012-06-06 01:05:26 MDT =3B =3B =3B 1854 4fc7d1= eb.73e=20 >=3BLOG: =3B could not rename temporary statistics file=20 "pg_stat_tmp/pgstat.tmp" to "pg_stat_tmp/pgstat.stat": No such file or=20 directory
<=3B2012-06-06 01:05:28 MDT =3B =3B =3B 1383 4fc= f0136.567 >=3BERROR: =3B tuple concurrently updated
<=3B2012-06-= 06 01:05:28 MDT =3B =3B =3B 1383 4fcf0136.567 >=3BCONTEXT:&nb= sp=3B automatic vacuum of table "global.pg_catalog.pg_attrdef"
<=3B201= 2-06-06 01:06:09 MDT =3B =3B =3B 1851 4fc7d1eb.73b >=3BERROR: = =3B xlog flush request=20 4/E29EE490 is not satisfied --- flushed only to 3/13527A10
<=3B2012-06= -06 01:06:09 MDT =3B =3B =3B 1851 4fc7d1eb.73b >=3BCONTEXT:&n= bsp=3B writing block 0 of relation base/311360/12244_vm
<=3B2012-06-06 01:06:10 MDT =3B =3B =3B 1851 4fc7d1eb.73b >=3BERROR: = =3B xlog flush request=20 4/E29EE490 is not satisfied --- flushed only to 3/13527A10
<=3B2012-06= -06 01:06:10 MDT =3B =3B =3B 1851 4fc7d1eb.73b >=3BCONTEXT:&n= bsp=3B writing block 0 of relation base/311360/12244_vm
<=3B2012-06-06= 01:06:10 MDT =3B =3B =3B 1851 4fc7d1eb.73b >=3BWARNING: = =3B could not write block 0 of base/311360/12244_vm
<=3B2012-06-06 01:= 06:10 MDT =3B =3B =3B 1851 4fc7d1eb.73b >=3BDETAIL: =3B M= ultiple failures --- write error might be permanent.


Last night = it was terminated by signal 6.

<=3B2012-06-07 01:36:44 MDT=  =3B =3B =3B 2509 4fd05a0c.9cd >=3BLOG: =3B startup proce= ss (PID 2525) was terminated by signal 6: Aborted
<=3B2012-06-07 01:36= :44 MDT =3B =3B =3B 2509 4fd05a0c.9cd >=3BLOG: =3B aborti= ng startup due to startup process failure
<=3B2012-06-07 01:37:37 MDT =3B =3B =3B 2680 4fd05a41.a78 >=3BLOG: =3B d= atabase system shutdown was interrupted=3B last known up at 2012-06-07 01:29:40 MDT
<=3B2012-0= 6-07 01:37:37 MDT =3B =3B =3B 2680 4fd05a41.a78 >=3BLOG: =3B c= ould not open file "pg_xlog/000000010000000300000013" (log file 3=2C segment 19): No such file or directory
<=3B2012-06-07 01:37:37 MDT =3B =3B =3B = 2680 4fd05a41.a78 >=3BLOG: =3B invalid primary checkpoint record
<= br>And the only option was pg_res= etxlog.

After this a lot of querys showed me this error: =3B <=3B2012-06-07 09:24:22 MDT 1306 4fd0c7a6.51a >=3BERROR: missing c= hunk number 0 for toast value 393330 in pg_toast_2619
<=3B2012-06-07 0= 9:24:31 MDT 1306 4fd0c7a6.51a >=3BERROR: missing chunk number 0 for t= oast value 393332 in pg_toast_2619

I lost some databases.
=
I restarted the cluster again with initdb and then I restored =3B t= he databases that I could backup (for the other I restored an old backup) <= br>
no space or = permissions problem. No filesystem or disk error.

Can = you help me to know what happened?

Thanks and regard= s...


= --_805e6c29-d697-4bca-b96c-fb2b14448812_--