db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jessie Lee <jessie_...@bmc.com>
Subject Re: Page could not be read from disk
Date Wed, 11 Apr 2007 20:31:21 GMT
Mike Matrigali <mikem_app@...> writes:

> 
> 
> Jessie Lee wrote:
> > Hi, Steve & Bryan,
> > 
> > Bryan Pendleton <bpendleton <at> ...> writes:
> > 
> > 
> >>>thrown executing the JAVA method java.io.RandomAccessFile.readFully 
> >>>caused by the end of the file (EOF) being reached unexpectedly. It would

> >>>be good to check your disk and system logs for reports of Disk or I/O 
> >>>problems.
> >>
> > 
> > I copied the whole database to the other machine and ran the same query 
that 
> > caused the exception - got the same exception.  So, looks like it's not 
> > hardware problem.
> This is good information, but does not necessarily mean not a hardware 
> problem.
> Unfortunately these problems can be caused by hardware errors in the 
> past causing a persistent problem on disk, leaving the db in a bad 
> state.  Once it is in the bad state the problem most likely persists --
> even when copied to another machine.  This is definitely the case with
> bad checksum errors.
> 
> Providing a listing of the database directory, with names and sizes of 
> the files my provide some more info (ie. ls -l on unix).  Also what
> OS/JVM are you using.  The page number is short of the magic 2 gig 
> number assuming 32k page size, but is getting close.  We have seen
> some JVM bugs and OS limitations with respect to files of 2 gig or
> bigger.
> 
I am running derby inside JBoss using Windows 2003 server.  Here's the list of 
data.

Thanks,
Jessie

04/11/2007  02:42 PM    <DIR>          .
04/11/2007  02:42 PM    <DIR>          ..
04/02/2007  02:01 PM             8,192 c10.dat
03/19/2007  02:02 PM             8,192 c1000.dat
04/02/2007  01:26 PM           135,168 c1001.dat
03/19/2007  02:02 PM            24,576 c101.dat
04/02/2007  02:51 PM         7,802,880 c1010.dat
03/19/2007  02:02 PM             8,192 c1011.dat
04/02/2007  02:51 PM         5,935,104 c1021.dat
04/02/2007  02:51 PM         2,002,944 c1031.dat
04/02/2007  01:26 PM           102,400 c1040.dat
04/02/2007  01:26 PM             8,192 c1051.dat
04/02/2007  01:26 PM             8,192 c1061.dat
04/02/2007  01:26 PM             8,192 c1071.dat
04/02/2007  02:51 PM         9,244,672 c1080.dat
04/02/2007  02:51 PM           102,400 c1091.dat
04/02/2007  02:51 PM           102,400 c10a1.dat
04/02/2007  02:51 PM        14,077,952 c10b0.dat
03/19/2007  02:02 PM             8,192 c10b1.dat
03/19/2007  02:02 PM             8,192 c10c0.dat
04/02/2007  02:51 PM         1,921,024 c10c1.dat
04/02/2007  02:51 PM         7,233,536 c10d1.dat
04/02/2007  02:51 PM         2,940,928 c10e1.dat
03/19/2007  02:02 PM             8,192 c10f0.dat
03/19/2007  02:02 PM             8,192 c10f1.dat
03/19/2007  02:02 PM             8,192 c1100.dat
03/19/2007  02:02 PM             8,192 c1101.dat
03/19/2007  02:02 PM            24,576 c111.dat
03/19/2007  02:02 PM             8,192 c1111.dat
03/19/2007  02:02 PM             8,192 c1121.dat
03/19/2007  02:02 PM             8,192 c1131.dat
03/19/2007  02:02 PM             8,192 c1140.dat
03/19/2007  02:02 PM             8,192 c1141.dat
04/02/2007  01:26 PM         1,216,512 c1150.dat
03/19/2007  02:02 PM             8,192 c1151.dat
04/02/2007  01:26 PM           659,456 c1161.dat
04/02/2007  01:26 PM           299,008 c1171.dat
03/19/2007  02:02 PM             8,192 c1180.dat
04/02/2007  01:26 PM           299,008 c1181.dat
03/30/2007  12:00 PM            69,632 c1190.dat
03/19/2007  02:02 PM             8,192 c1191.dat
03/30/2007  12:00 PM             8,192 c11a1.dat
03/19/2007  02:02 PM             8,192 c11b0.dat
03/30/2007  12:00 PM             8,192 c11b1.dat
04/02/2007  01:26 PM            24,576 c11c1.dat
04/02/2007  02:51 PM           925,696 c11d1.dat
03/19/2007  02:02 PM             8,192 c11e1.dat
04/02/2007  01:26 PM           847,872 c11f1.dat
03/30/2007  12:46 PM             8,192 c1201.dat
03/19/2007  02:02 PM            20,480 c121.dat
03/19/2007  02:02 PM            16,384 c130.dat
03/19/2007  02:02 PM            16,384 c141.dat
03/19/2007  02:02 PM            12,288 c150.dat
03/19/2007  02:02 PM             8,192 c161.dat
03/19/2007  02:02 PM             8,192 c171.dat
03/19/2007  02:02 PM            24,576 c180.dat
03/19/2007  02:02 PM             8,192 c191.dat
03/19/2007  02:02 PM             8,192 c1a1.dat
03/19/2007  02:02 PM             8,192 c1b1.dat
03/19/2007  02:02 PM             8,192 c1c0.dat
03/19/2007  02:02 PM             8,192 c1d1.dat
03/19/2007  02:02 PM             8,192 c1e0.dat
03/19/2007  02:02 PM             8,192 c1f1.dat
03/19/2007  02:02 PM           102,400 c20.dat
03/19/2007  02:02 PM            16,384 c200.dat
03/19/2007  02:02 PM             8,192 c211.dat
03/19/2007  02:02 PM             8,192 c221.dat
04/02/2007  02:01 PM            86,016 c230.dat
03/19/2007  02:02 PM             8,192 c241.dat
03/19/2007  02:02 PM            12,288 c251.dat
03/19/2007  02:02 PM             8,192 c260.dat
03/19/2007  02:02 PM             8,192 c271.dat
03/19/2007  02:02 PM             8,192 c281.dat
03/19/2007  02:02 PM             8,192 c290.dat
03/19/2007  02:02 PM             8,192 c2a1.dat
03/19/2007  02:02 PM             8,192 c2b1.dat
03/19/2007  02:02 PM             8,192 c2c1.dat
03/19/2007  02:02 PM             8,192 c2d0.dat
03/19/2007  02:02 PM             8,192 c2e1.dat
03/19/2007  02:02 PM             8,192 c2f0.dat
03/19/2007  02:02 PM             8,192 c300.dat
03/19/2007  02:02 PM            28,672 c31.dat
03/19/2007  02:02 PM             8,192 c311.dat
04/02/2007  02:51 PM           167,936 c320.dat
03/29/2007  01:28 AM             8,192 c331.dat
03/23/2007  12:21 PM             8,192 c341.dat
03/19/2007  02:02 PM             8,192 c350.dat
03/19/2007  02:02 PM             8,192 c361.dat
03/19/2007  02:02 PM             8,192 c371.dat
03/29/2007  12:06 AM         1,343,488 c380.dat
03/29/2007  12:06 AM             8,192 c391.dat
03/23/2007  12:21 PM             8,192 c3a1.dat
03/19/2007  02:02 PM            65,536 c3b0.dat
03/23/2007  12:21 PM             8,192 c3b1.dat
03/23/2007  01:32 PM             8,192 c3c1.dat
03/19/2007  02:02 PM             8,192 c3d0.dat
03/19/2007  02:02 PM             8,192 c3d1.dat
03/19/2007  02:02 PM             8,192 c3e1.dat
03/19/2007  02:02 PM             8,192 c3f1.dat
03/27/2007  08:41 AM             8,192 c400.dat
03/19/2007  02:02 PM            69,632 c41.dat
03/27/2007  08:41 AM             8,192 c411.dat
03/27/2007  08:41 AM             8,192 c421.dat
03/27/2007  08:41 AM             8,192 c431.dat
03/19/2007  02:02 PM             8,192 c440.dat
03/19/2007  02:02 PM             8,192 c451.dat
03/27/2007  08:41 AM            16,384 c460.dat
03/19/2007  02:02 PM             8,192 c461.dat
03/19/2007  02:02 PM             8,192 c470.dat
03/27/2007  08:41 AM             8,192 c471.dat
03/27/2007  08:41 AM             8,192 c481.dat
03/27/2007  08:41 AM             8,192 c491.dat
03/27/2007  08:41 AM            69,632 c4a0.dat
03/19/2007  02:02 PM             8,192 c4a1.dat
03/19/2007  02:02 PM             8,192 c4b0.dat
03/27/2007  08:41 AM            32,768 c4b1.dat
03/27/2007  08:41 AM            24,576 c4c1.dat
03/27/2007  08:41 AM            24,576 c4d0.dat
03/19/2007  02:02 PM             8,192 c4d1.dat
03/19/2007  02:02 PM             8,192 c4e0.dat
03/27/2007  08:41 AM            16,384 c4e1.dat
03/27/2007  08:41 AM            16,384 c4f1.dat
03/30/2007  12:46 PM           102,400 c500.dat
03/19/2007  02:02 PM             8,192 c501.dat
03/19/2007  02:02 PM            36,864 c51.dat
03/30/2007  12:46 PM             8,192 c511.dat
03/30/2007  12:46 PM            24,576 c521.dat
03/19/2007  02:02 PM             8,192 c530.dat
03/19/2007  02:02 PM             8,192 c531.dat
03/19/2007  02:02 PM             8,192 c540.dat
03/19/2007  02:02 PM             8,192 c541.dat
03/19/2007  02:02 PM             8,192 c551.dat
04/02/2007  02:51 PM           102,400 c560.dat
03/19/2007  02:02 PM             8,192 c561.dat
03/30/2007  12:46 PM             8,192 c571.dat
03/19/2007  02:02 PM             8,192 c580.dat
03/30/2007  12:46 PM            24,576 c581.dat
04/02/2007  02:51 PM            20,480 c591.dat
03/30/2007  12:46 PM             8,192 c5a1.dat
03/19/2007  02:02 PM             8,192 c5b0.dat
03/30/2007  12:46 PM            16,384 c5b1.dat
03/19/2007  02:02 PM             8,192 c5c0.dat
03/19/2007  02:02 PM             8,192 c5c1.dat
03/19/2007  02:02 PM             8,192 c5d1.dat
03/19/2007  02:02 PM             8,192 c5e1.dat
04/02/2007  01:58 PM           200,704 c5f0.dat
03/19/2007  02:02 PM            16,384 c60.dat
04/02/2007  01:58 PM            36,864 c601.dat
04/02/2007  01:58 PM            28,672 c611.dat
04/02/2007  01:58 PM            28,672 c621.dat
03/30/2007  12:00 PM            69,632 c630.dat
03/30/2007  12:00 PM            16,384 c641.dat
03/30/2007  12:00 PM             8,192 c651.dat
03/19/2007  02:02 PM             8,192 c660.dat
03/30/2007  12:00 PM             8,192 c661.dat
04/02/2007  02:51 PM           266,240 c670.dat
03/19/2007  02:02 PM             8,192 c671.dat
03/19/2007  02:02 PM             8,192 c680.dat
04/02/2007  02:51 PM           102,400 c681.dat
04/02/2007  02:51 PM            69,632 c691.dat
04/02/2007  02:51 PM            36,864 c6a1.dat
03/23/2007  08:03 AM             8,192 c6b0.dat
03/23/2007  08:03 AM             8,192 c6c1.dat
03/19/2007  02:02 PM             8,192 c6d1.dat
03/19/2007  02:02 PM             8,192 c6e1.dat
03/19/2007  02:02 PM             8,192 c6f0.dat
03/19/2007  02:02 PM             8,192 c701.dat
03/19/2007  02:02 PM            16,384 c71.dat
03/19/2007  02:02 PM             8,192 c711.dat
03/19/2007  02:02 PM             8,192 c720.dat
03/19/2007  02:02 PM             8,192 c721.dat
03/19/2007  02:02 PM            16,384 c730.dat
03/19/2007  02:02 PM             8,192 c731.dat
03/19/2007  02:02 PM             8,192 c741.dat
03/19/2007  02:02 PM            20,480 c751.dat
03/19/2007  02:02 PM            65,536 c760.dat
03/19/2007  02:02 PM             8,192 c761.dat
04/02/2007  02:51 PM           233,472 c770.dat
03/19/2007  02:02 PM            69,632 c781.dat
03/19/2007  02:02 PM           135,168 c791.dat
03/19/2007  02:02 PM            69,632 c7a1.dat
03/19/2007  02:02 PM            24,576 c7b0.dat
03/19/2007  02:02 PM             8,192 c7c1.dat
03/19/2007  02:02 PM            16,384 c7d1.dat
03/19/2007  02:02 PM             8,192 c7e1.dat
03/19/2007  02:02 PM             8,192 c7f0.dat
03/19/2007  02:02 PM             8,192 c801.dat
03/19/2007  02:02 PM            16,384 c81.dat
03/19/2007  02:02 PM             8,192 c811.dat
03/19/2007  02:02 PM             8,192 c821.dat
03/19/2007  02:02 PM            69,632 c830.dat
03/19/2007  02:02 PM            24,576 c841.dat
03/19/2007  02:02 PM            69,632 c851.dat
03/19/2007  02:02 PM            24,576 c861.dat
03/19/2007  02:02 PM            65,536 c870.dat
03/19/2007  02:02 PM             8,192 c881.dat
03/19/2007  02:02 PM             8,192 c891.dat
03/19/2007  02:02 PM             8,192 c8a1.dat
03/19/2007  02:02 PM             8,192 c8b0.dat
03/19/2007  02:02 PM             8,192 c8c1.dat
03/19/2007  02:02 PM             8,192 c8d0.dat
03/19/2007  02:02 PM             8,192 c8d1.dat
03/19/2007  02:02 PM             8,192 c8e1.dat
03/19/2007  02:02 PM             8,192 c8f0.dat
03/19/2007  02:02 PM             8,192 c8f1.dat
04/02/2007  02:51 PM           102,400 c90.dat
03/19/2007  02:02 PM             8,192 c901.dat
03/19/2007  02:02 PM             8,192 c910.dat
03/19/2007  02:02 PM             8,192 c911.dat
03/19/2007  02:02 PM             8,192 c921.dat
03/19/2007  02:02 PM             8,192 c930.dat
03/19/2007  02:02 PM             8,192 c931.dat
03/19/2007  02:02 PM             8,192 c940.dat
03/19/2007  02:02 PM             8,192 c941.dat
03/19/2007  02:02 PM             8,192 c951.dat
03/19/2007  02:02 PM             8,192 c961.dat
03/19/2007  02:02 PM             8,192 c970.dat
03/19/2007  02:02 PM             8,192 c971.dat
03/19/2007  02:02 PM             8,192 c980.dat
03/19/2007  02:02 PM             8,192 c991.dat
03/19/2007  02:02 PM             8,192 c9a0.dat
03/19/2007  02:02 PM             8,192 c9a1.dat
03/19/2007  02:02 PM             8,192 c9b1.dat
03/19/2007  02:02 PM             8,192 c9c0.dat
03/19/2007  02:02 PM             8,192 c9c1.dat
03/19/2007  02:02 PM             8,192 c9d1.dat
03/19/2007  02:02 PM             8,192 c9e0.dat
03/19/2007  02:02 PM             8,192 c9e1.dat
03/19/2007  02:02 PM             8,192 c9f1.dat
04/02/2007  02:22 PM             8,192 ca00.dat
03/19/2007  02:02 PM           102,400 ca1.dat
03/19/2007  02:02 PM             8,192 ca11.dat
03/19/2007  02:02 PM             8,192 ca20.dat
03/19/2007  02:02 PM             8,192 ca21.dat
03/19/2007  02:02 PM             8,192 ca31.dat
03/19/2007  02:02 PM             8,192 ca40.dat
03/19/2007  02:02 PM             8,192 ca51.dat
03/19/2007  02:02 PM             8,192 ca60.dat
03/19/2007  02:02 PM             8,192 ca61.dat
03/19/2007  02:02 PM             8,192 ca71.dat
03/19/2007  02:02 PM             8,192 ca80.dat
03/19/2007  02:02 PM             8,192 ca91.dat
03/19/2007  02:02 PM             8,192 caa0.dat
03/19/2007  02:02 PM             8,192 caa1.dat
03/19/2007  02:02 PM             8,192 cab1.dat
03/20/2007  02:46 PM             8,192 cac0.dat
03/19/2007  02:02 PM             8,192 cad0.dat
03/19/2007  02:02 PM             8,192 cad1.dat
03/19/2007  02:02 PM             8,192 cae0.dat
03/19/2007  02:02 PM             8,192 cae1.dat
03/19/2007  02:02 PM             8,192 caf1.dat
03/19/2007  02:02 PM             8,192 cb00.dat
03/19/2007  02:02 PM            32,768 cb1.dat
03/19/2007  02:02 PM             8,192 cb11.dat
03/19/2007  02:02 PM             8,192 cb21.dat
03/19/2007  02:02 PM             8,192 cb31.dat
03/19/2007  02:02 PM             8,192 cb40.dat
03/19/2007  02:02 PM             8,192 cb41.dat
03/19/2007  02:02 PM        34,111,488 cb50.dat
03/19/2007  02:02 PM             8,192 cb51.dat
04/02/2007  02:01 PM             8,192 cb60.dat
03/19/2007  02:02 PM             8,192 cb61.dat
03/19/2007  02:02 PM             8,192 cb71.dat
03/19/2007  02:02 PM             8,192 cb81.dat
04/02/2007  02:02 PM             8,192 cb90.dat
03/19/2007  02:02 PM             8,192 cb91.dat
03/23/2007  01:32 PM             8,192 cba1.dat
03/23/2007  01:32 PM             8,192 cbb1.dat
04/02/2007  02:02 PM             8,192 cbc0.dat
03/19/2007  02:02 PM             8,192 cbc1.dat
03/19/2007  02:02 PM             8,192 cbd1.dat
03/19/2007  02:02 PM             8,192 cbe1.dat
04/02/2007  02:02 PM             8,192 cbf0.dat
03/19/2007  02:02 PM             8,192 cbf1.dat
03/19/2007  02:02 PM             8,192 cc0.dat
03/19/2007  02:02 PM             8,192 cc01.dat
03/19/2007  02:02 PM             8,192 cc11.dat
04/02/2007  02:01 PM             8,192 cc20.dat
03/19/2007  02:02 PM             8,192 cc21.dat
03/23/2007  01:32 PM             8,192 cc31.dat
03/19/2007  02:02 PM             8,192 cc40.dat
03/23/2007  01:32 PM             8,192 cc41.dat
04/02/2007  02:01 PM             8,192 cc50.dat
03/19/2007  02:02 PM             8,192 cc51.dat
03/19/2007  02:02 PM             8,192 cc61.dat
03/19/2007  02:02 PM             8,192 cc70.dat
03/19/2007  02:02 PM             8,192 cc71.dat
04/02/2007  02:02 PM             8,192 cc80.dat
03/19/2007  02:02 PM             8,192 cc81.dat
03/19/2007  02:02 PM             8,192 cc91.dat
03/19/2007  02:02 PM             8,192 cca0.dat
03/19/2007  02:02 PM             8,192 cca1.dat
04/02/2007  02:51 PM         3,739,648 ccb0.dat
03/19/2007  02:02 PM             8,192 ccb1.dat
03/19/2007  02:02 PM             8,192 ccc0.dat
04/02/2007  02:51 PM           626,688 ccc1.dat
04/02/2007  02:51 PM         1,675,264 ccd1.dat
04/02/2007  02:51 PM           167,936 cce0.dat
04/02/2007  01:26 PM           102,400 ccf1.dat
04/02/2007  01:18 PM            20,480 cd01.dat
03/19/2007  02:02 PM             8,192 cd1.dat
03/19/2007  02:02 PM             8,192 cd10.dat
04/02/2007  01:18 PM            32,768 cd11.dat
04/02/2007  01:26 PM            24,576 cd21.dat
04/02/2007  01:26 PM            20,480 cd31.dat
04/02/2007  02:51 PM         5,214,208 cd40.dat
04/02/2007  02:51 PM           790,528 cd51.dat
04/02/2007  02:51 PM           954,368 cd61.dat
03/19/2007  02:02 PM             8,192 cd70.dat
04/02/2007  02:51 PM           659,456 cd71.dat
04/02/2007  02:51 PM           692,224 cd81.dat
04/02/2007  02:51 PM           823,296 cd91.dat
04/02/2007  01:26 PM           233,472 cda0.dat
04/02/2007  01:26 PM           102,400 cdb1.dat
04/02/2007  01:26 PM            16,384 cdc1.dat
03/19/2007  02:02 PM             8,192 cdd0.dat
04/02/2007  01:26 PM            16,384 cdd1.dat
04/02/2007  01:18 PM            16,384 cde1.dat
04/02/2007  01:18 PM           102,400 cdf1.dat
04/02/2007  02:51 PM       294,973,440 ce00.dat
03/19/2007  02:04 PM             8,192 ce01.dat
03/19/2007  02:04 PM             8,192 ce1.dat
04/02/2007  01:26 PM           790,528 ce11.dat
04/02/2007  01:26 PM           757,760 ce21.dat
04/02/2007  01:26 PM           724,992 ce31.dat
04/02/2007  01:26 PM           724,992 ce41.dat
04/02/2007  01:26 PM           692,224 ce51.dat
03/19/2007  02:04 PM             8,192 ce60.dat
03/19/2007  02:04 PM             8,192 ce61.dat
03/19/2007  02:04 PM             8,192 ce71.dat
03/19/2007  02:04 PM             8,192 ce81.dat
03/19/2007  02:04 PM             8,192 ce91.dat
03/19/2007  02:04 PM             8,192 cea1.dat
03/19/2007  02:04 PM             8,192 ceb1.dat
03/19/2007  02:04 PM             8,192 cec0.dat
03/19/2007  02:04 PM             8,192 cec1.dat
03/19/2007  02:04 PM             8,192 ced1.dat
03/19/2007  02:04 PM             8,192 cee1.dat
03/19/2007  02:04 PM             8,192 cef1.dat
03/19/2007  02:04 PM            32,768 cf0.dat
03/19/2007  02:04 PM             8,192 cf01.dat
03/19/2007  02:04 PM             8,192 cf11.dat
04/02/2007  02:51 PM         5,214,208 cf20.dat
03/19/2007  02:04 PM             8,192 cf21.dat
04/02/2007  02:51 PM           200,704 cf31.dat
04/02/2007  02:51 PM           200,704 cf41.dat
04/02/2007  02:51 PM           200,704 cf51.dat
03/19/2007  02:04 PM             8,192 cf60.dat
04/02/2007  02:51 PM           167,936 cf61.dat
03/19/2007  02:04 PM             8,192 cf70.dat
04/02/2007  02:51 PM           167,936 cf71.dat
04/02/2007  09:46 AM            32,768 cf80.dat
03/19/2007  02:04 PM             8,192 cf81.dat
03/19/2007  02:04 PM             8,192 cf90.dat
04/02/2007  09:46 AM             8,192 cf91.dat
04/02/2007  09:46 AM             8,192 cfa1.dat
04/02/2007  09:46 AM           692,224 cfb0.dat
03/19/2007  02:04 PM             8,192 cfb1.dat
04/02/2007  09:46 AM           102,400 cfc1.dat
03/19/2007  02:04 PM             8,192 cfd0.dat
04/02/2007  09:46 AM            69,632 cfd1.dat
04/02/2007  01:26 PM           266,240 cfe0.dat
03/19/2007  02:04 PM             8,192 cfe1.dat
04/02/2007  01:26 PM           233,472 cff1.dat
04/11/2007  02:42 PM    <DIR>          Folder Settings
             362 File(s)    418,914,304 bytes
               3 Dir(s)   3,374,772,224 bytes free
> > 
> > 
> > 
> >>Perhaps also check to see if your disk filled up. It seems that Derby
> >>may think that the file is longer (larger) than it actually is, which
> >>is why Derby is encountering the EndOfFile unexpectedly.
> >>
> >>Perhaps your disk filled up at some point, and caused Derby to crash,
> >>and then something went wrong after that such that the file was not
> >>recovered properly?
> >>
> > 
> > 
> > Is it possible that at some point derby log or data can't be flushed into 
the 
> > data / log file and caused the crash?  We saw one error on the other 
machine 
> > which mentioned that "log can't be flushed into log" (or something like 
that).
> > 
> > 
> >>thanks,
> >>
> >>bryan
> >>
> >>
> > 
> > Thanks,
> > Jessie
> > 
> > 
> > 
> > 
> > 
> > 
> 
> 





Mime
View raw message