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
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate