db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Øystein Grøvlen <Oystein.Grov...@Sun.COM>
Subject Re: SQLSTATE: XSDG0Page Page(7,Container(0, 848)) could not be read from disk.
Date Thu, 12 Oct 2006 11:39:46 GMT
David Sitsky wrote:

>> Some causes in the past are:
>> o DERBY-700
>> o DERBY-1838
>> o using durability=test mode
>> o running on hardware that doesn't actually sync disk when asked
>> o running separate jvm's on 2 machines accessing the same db across a
>>   networked file system.
> 
> This is running on windows, we never set durability=test, so I highly 
> suspect the last point must have occurred at this site.

How about the second to last point?  Most windows machines by default is 
set up to cache writes in the disk controller.  If the machine goes down 
in an uncrontrolled manner, disk writes may get lost.  Could this have 
happened?

To be safe, one needs to turn off the disk caching.

--
Øystein

Mime
View raw message