Filesystems are ReiserFS

Filesystemio_options? Setall?






No mpio
Root disk is hardware RAID 1 primary partitions for OS and Oracle
binaries.
Data disk is hardware RAID 5 primary partition for Oracle data.
No fibre channel.
OS and Oracle are 32bit.

We can reproduce the bug by:
Enabling AIO in oracle,restart.
Dropping indexes on two tables.
Using SQL*Loader to append 10 to 20gig of data into two tables.
Creating indexes on the two tables.
Repeat daily for 7-10 days. Table data is deleted first in first out and
the tables together are roughly 250 gig in size.

Thus, I can rule out EXT3, MPIO, Raw disk, fibrechannel, and 64bits. You
can see my config is rather stock with no special tweaks etc. Yes, I
know this is a less than optimal hardware setup (surplus hardware). The
kernel is one provided by SuSE to test a fix for this specific AIO
problem.

After turning OFF AIO and adding io slaves, the machine has been running
perfectly for 64 days. Unfortunately, I cannot test the latest kernel as
the users would prefer to leave the machine as-is instead of having to
reboot every week.

Andy

> -----Original Message-----
> From: Alexei_Roudnev [mailto:Alexei_Roudnev@(protected)]
> Sent: Tuesday, January 09, 2007 6:53 PM
> To: michael.taylor@(protected);
> suse-oracle@(protected)
> Subject: Re: AW: [suse-oracle] Novell - it is VERY SERIOUS!
> Weshouldadviseagainst using SuSe and Oracle if
>
> Ok. So, who can reproduce the problem - can you try to rule-out (or
> rule-in, so to say):
>
> - ext3 (thry the same on reiserFS)
> - mpio (try to eliminate it, using /dev/sd* )
> - disk without partitions (if you use it, create partition 1
> and try it);
> - FibreChannel driver (hmm, may be, try to run it on local disk?)
> - x86_64 (or other particular) platform
>
> ??
>
snip

--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting


--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting