Mike Matrigali <[EMAIL PROTECTED]> 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
> >
> >
> >
> >
> >
> >
>
>
