db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bergquist, Brett" <BBergqu...@canoga.com>
Subject RE: Error when running SYSCS_UTIL.SYSCS_CHECK_TABLE
Date Tue, 09 Aug 2011 16:56:33 GMT
I will try it with the sane jars tonight.  I am able to export all of the data in the table
using the SYSCS_UTIL.SYSCS_EXPORT_TABLE procedure.  I am also running SYSCS_UTIL.SYSCS_CHECK_TABLE
on all of the other tables right now to see if it just this one.

-----Original Message-----
From: Rick Hillegas [mailto:rick.hillegas@oracle.com] 
Sent: Tuesday, August 09, 2011 11:58 AM
To: derby-dev@db.apache.org
Subject: Re: Error when running SYSCS_UTIL.SYSCS_CHECK_TABLE

Hi Brett,

Is there anything in derby.log? If you run with the debug/sane jars, I 
would expect that derby.log would hold a complete stack trace with line 
numbers.

Thanks,
-Rick

On 8/9/11 8:24 AM, Bergquist, Brett wrote:
>
> Database engine is 10.8.1.2 (built from source with a patch for 
> Restricted table support) and I am running this in embedded mode.  Am 
> getting the following error:
>
> ERROR 38000: The exception 'java.lang.NullPointerException' was thrown 
> while evaluating an expression.
>
> ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
>
> Note that this database is suspect to have corruption.  The table I am 
> trying to check has 74M rows in it and this runs for about 15 hours 
> before this gets reported.  Derby.log looks like:
>
> ----------------------------------------------------------------
>
> Thu Sep 01 12:21:29 EDT 2011:
>
> Booting Derby version The Apache Software Foundation - Apache Derby - 
> 10.8.1.2 - (678001): instance a816c00e-0132-25cb-8e35-00003ceac520
>
> on database directory 
> /opt/canoga/canogaview/glassfish/databases/csemdb  with class loader 
> sun.misc.Launcher$AppClassLoader@12360be0
>
> Loaded from file:/opt/canoga/canogaview/glassfish/javadb/lib/derby.jar
>
> java.vendor=Sun Microsystems Inc.
>
> java.runtime.version=1.6.0_21-b06
>
> user.dir=/opt/canoga/canogaview/glassfish/javadb
>
> derby.system.home=null
>
> Database Class Loader started - derby.database.classpath='CSEM.csemderby'
>
> ----------------------------------------------------------------
>
> Thu Sep 01 14:27:50 EDT 2011: Shutting down Derby engine
>
> ----------------------------------------------------------------
>
> Thu Sep 01 14:27:50 EDT 2011:
>
> Shutting down instance a816c00e-0132-25cb-8e35-00003ceac520 on 
> database directory /opt/canoga/canogaview/glassfish/databases/csemdb 
> with class loader sun.misc.Launcher$AppClassLoader@12360be0
>
> Is there anything I can turn on that would get better diagnostics of 
> where the problem is  (where the NPE is being reported)?
>




Mime
View raw message