X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id D3CF011F6791; Fri, 14 Apr 2006 07:19:53 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0 X-Spam-Level: X-Spam-Status: No, score=0 required=5 tests=[none] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id Rkl8ntSUdsQQ; Fri, 14 Apr 2006 07:19:47 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from matrix.gatewaynet.com (host2.dynacom.ondsl.gr [62.103.35.210]) by postgresql.org (Postfix) with ESMTP id 8D0F011F678D; Fri, 14 Apr 2006 07:19:49 -0300 (ADT) Received: from matrix.gatewaynet.com (localhost.localdomain [127.0.0.1]) by matrix.gatewaynet.com (8.12.8/8.12.8) with ESMTP id k3EBRfOp028840; Fri, 14 Apr 2006 14:27:41 +0300 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.8/8.12.8/Submit) with ESMTP id k3EBRfuR028836; Fri, 14 Apr 2006 14:27:41 +0300 Date: Fri, 14 Apr 2006 14:27:41 +0300 (EEST) From: Achilleus Mantzios To: pgsql-admin@postgresql.org, Subject: Re: Kernel 2.4->2.6 upgrade results in PANIC: could not locate a In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=ISO-8859-7 Content-Transfer-Encoding: 8BIT X-Archive-Number: 200604/124 X-Sequence-Number: 21293 Problem solved. The sysadmins yesterday forgot to mention to me that they didnt mount correctly all the file systems (including the one of pg_xlog). Sorry for the noise :-) O Achilleus Mantzios έγραψε στις Apr 14, 2006 : > > Hi, we have happily been running postgresql 7.4.x (currently 7.4.12) on a > debian linux with kernel 2.4.x for some years without any issues. > Yesterday after switching to 2.6.16 we experienced the following problem > upon pgsql startup: > > LOG: could not open file "/var/lib/pgsql/data/pg_xlog/0000006900000091" > (log file 1 05, segment 145): No such file or directory > LOG: invalid primary checkpoint record > LOG: could not open file "/var/lib/pgsql/data/pg_xlog/0000006900000091" > (log file 1 05, segment 145): No such file or directory > LOG: invalid secondary checkpoint record > PANIC: could not locate a valid checkpoint record > LOG: startup process (PID 414) was terminated by signal 6 > LOG: aborting startup due to startup process failure > > After reverting back to kernel 2.4, postgresql started up hapilly again. > > Any ideas? > -- -Achilleus