Re: Linux filesystem turns read-only when creating tablespaces (Oracle 10g) ?

hipo <fjrdrc_at_gmail.com> wrote:
> Here's the messages file regarding to the error:
>
> Oct 18 15:37:03 ttoracle kernel: journal_bmap: journal block not found
> at offset 1036 on hdb1
> Oct 18 15:37:03 ttoracle kernel: Aborting journal on device hdb1.
> Oct 18 15:37:03 ttoracle kernel: ext3_abort called.
> Oct 18 15:37:03 ttoracle kernel: EXT3-fs error (device hdb1):
> ext3_journal_start_sb: Detected aborted journal
> Oct 18 15:37:03 ttoracle kernel: Remounting filesystem read-only
> Oct 18 15:37:12 ttoracle kernel: __journal_remove_journal_head: freeing
> b_committed_data
> Oct 18 15:37:12 ttoracle kernel: __journal_remove_journal_head: freeing
> b_frozen_data
> Oct 18 15:37:12 ttoracle kernel: __journal_remove_journal_head: freeing
> b_committed_data
> Oct 18 15:37:12 ttoracle kernel: __journal_remove_journal_head: freeing
> b_frozen_data
>
>
> And, yes, I can write a file after restarting the system, and the disk
> seems to be ok again.... but I can't still create the more than 2
> Gbytes tablespace.

That looks bad.

What I would do is

1. run a fsck on the unmounted file system and see if it finds any problems.

If that doesn't do the trick,

b) try with a more recent kernel version in the hope that if your

   problem is due to a kernel bug, it has been fixed in the meantime.

Of course it could also be that your disk is dying. In that case the fix would be simple: try another disk.

Yours,
Laurenz Albe Received on Wed Oct 19 2005 - 03:12:49 CDT