Postgres database is not logging any messages after the reboot - Mailing list pgsql-admin

From Bhella Paramjeet-PFCW67
Subject Postgres database is not logging any messages after the reboot
Date
Msg-id C84662912D280D4AB5C50100A100F0C502D9CA64@ct11exm61.ds.mot.com
Whole thread Raw
Responses Re: Postgres database is not logging any messages after the reboot  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-admin
Hi

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


pgsql-admin by date:

Previous
From: Thomas Karcher
Date:
Subject: Consistent PITR backup
Next
From: "Bhella Paramjeet-PFCW67"
Date:
Subject: Re: Postgres database is not logging any messages after the reboot