Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 441C89FC44F for ; Fri, 19 Oct 2007 08:09:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 41858-02 for ; Fri, 19 Oct 2007 08:09:43 -0300 (ADT) X-Greylist: delayed 01:01:51.676432 by SQLgrey-1.7.5 Received: from kiwi.previdencia.gov.br (kiwi.previdencia.gov.br [200.152.32.154]) by postgresql.org (Postfix) with SMTP id 7FA799FC49C for ; Fri, 19 Oct 2007 08:09:42 -0300 (ADT) Received: from (192.168.136.160) by kiwi.previdencia.gov.br via smtp id 0d28_e3d4a128_7e2b_11dc_8075_0002b3ec9b74; Fri, 19 Oct 2007 08:13:24 -0200 Received: from mail pickup service by kiwi.previdencia.social with Microsoft SMTPSVC; Thu, 18 Oct 2007 17:19:58 -0300 Message-ID: <1645d4840003b59c@previdencia.gov.br> Received: from postgresql.org ([200.46.204.71]) by previdencia.gov.br ([192.168.136.160]) with ESMTP (TREND IMSS SMTP Service 7.0) id 1645d4840003b59c for ; Thu, 11 Oct 2007 08:25:13 -0300 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 126139FB87C for ; Thu, 11 Oct 2007 08:24:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 84041-06-5 for ; Thu, 11 Oct 2007 08:24:04 -0300 (ADT) Received: from postgresql.org (postgresql.org [200.46.204.71]) by postgresql.org (Postfix) with ESMTP id 8FCDF9FB88F for ; Thu, 11 Oct 2007 08:24:10 -0300 (ADT) Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 038DD9FB512 for ; Wed, 10 Oct 2007 15:07:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 69015-04 for ; Wed, 10 Oct 2007 15:07:22 -0300 (ADT) X-Greylist: delayed 00:06:39.24239 by SQLgrey-1.7.5 Received: from mail153.messagelabs.com (mail153.messagelabs.com [216.82.253.51]) by postgresql.org (Postfix) with SMTP id E21799FB504 for ; Wed, 10 Oct 2007 15:07:28 -0300 (ADT) X-VirusChecked: Checked X-Env-Sender: PBhella@Motorola.com X-Msg-Ref: server-10.tower-153.messagelabs.com!1192039244!2732136!1 X-StarScan-Version: 5.5.12.14.2; banners=-,-,- X-Originating-IP: [144.189.100.103] Received: (qmail 17582 invoked from network); 10 Oct 2007 18:00:44 -0000 Received: from motgate3.mot.com (HELO motgate3.mot.com) (144.189.100.103) by server-10.tower-153.messagelabs.com with SMTP; 10 Oct 2007 18:00:44 -0000 Received: from az33exr03.mot.com (az33exr03.mot.com [10.64.251.233]) by motgate3.mot.com (8.12.11/Motorola) with ESMTP id l9AI0hBm027718 for ; Wed, 10 Oct 2007 11:00:43 -0700 (MST) Received: from az10vts01 (az10vts01.mot.com [10.64.251.242]) by az33exr03.mot.com (8.13.1/Vontu) with SMTP id l9AI0gXb029783 for ; Wed, 10 Oct 2007 13:00:43 -0500 (CDT) Received: from ct11exm61.ds.mot.com (CT11EXM61.am.mot.com [10.177.8.45]) by az33exr03.mot.com (8.13.1/8.13.0) with ESMTP id l9AI0daa029668 for ; Wed, 10 Oct 2007 13:00:40 -0500 (CDT) X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: Postgres database is not logging any messages after the reboot Date: Wed, 10 Oct 2007 13:43:29 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Postgres database is not logging any messages after the reboot Thread-Index: AcgLZRGj9PfaMjX2Sui619WwfAxGog== From: "Bhella Paramjeet-PFCW67" To: Cc: "Subbiah Stalin-XCGF84" X-CFilter-Loop: Reflected X-Virus-Scanned: Maia Mailguard 1.0.1 X-Mailing-List: pgsql-admin Precedence: bulk X-OriginalArrivalTime: 18 Oct 2007 20:19:58.0187 (UTC) FILETIME=[410073B0:01C811C4] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/190 X-Sequence-Number: 27104 Hi=20 The server that hosts our production postgres databases had to be rebooted last night as the file systems got remounted as read only. After the reboot we re-started the databases but now nothing is getting logged into the pglogs. Can you please assist us in figuring out the problem and help resolve it. Below listed are the error messages in the /var/log/messages file due to which we had to reboot the server. This is a linux x86-64 server. Your prompt response will be highly appreciated. Oct 10 06:45:02 sandbox kernel: EXT3-fs error (device sdb1): ext3_free_blocks_sb: bit already cleared for b lock 3931168 Oct 10 06:45:02 sandbox kernel: Aborting journal on device sdb1. Oct 10 06:45:02 sandbox kernel: EXT3-fs error (device sdb1): ext3_free_blocks_sb: bit already cleared for b lock 3931169 Oct 10 06:45:02 sandbox kernel: EXT3-fs error (device sdb1): ext3_free_blocks_sb: bit already cleared for b lock 3931170 Oct 10 06:45:02 sandbox kernel: EXT3-fs error (device sdb1): ext3_free_blocks_sb: bit already cleared for b lock 3931171 Oct 10 06:45:02 sandbox kernel: ext3_abort called. Oct 10 06:45:02 sandbox kernel: EXT3-fs error (device sdb1): ext3_journal_start_sb: Detected aborted journa l Oct 10 06:45:02 sandbox kernel: Remounting filesystem read-only Oct 10 06:45:02 sandbox kernel: EXT3-fs error (device sdb1) in ext3_free_blocks_sb: Journal has aborted Oct 10 06:45:02 sandbox last message repeated 70 times Oct 10 06:45:02 sandbox kernel: EXT3-fs error (device sdb1) in ext3_reserve_inode_write: Journal has aborte d Oct 10 06:45:02 sandbox kernel: EXT3-fs error (device sdb1) in ext3_truncate: Journal has aborted Oct 10 06:45:02 sandbox kernel: EXT3-fs error (device sdb1) in ext3_reserve_inode_write: Journal has aborte d Oct 10 06:45:02 sandbox kernel: EXT3-fs error (device sdb1) in ext3_orphan_del: Journal has aborted Oct 10 06:45:02 sandbox kernel: EXT3-fs error (device sdb1) in ext3_reserve_inode_write: Journal has aborte d Oct 10 06:45:02 sandbox kernel: EXT3-fs error (device sdb1) in ext3_delete_inode: Journal has aborted Oct 10 06:45:02 sandbox kernel: __journal_remove_journal_head: freeing b_committed_data Thanks Paramjeet Bhella =20 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate