From derby-dev-return-89779-apmail-db-derby-dev-archive=db.apache.org@db.apache.org Tue Aug 9 15:28:12 2011 Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 68DEC7C8C for ; Tue, 9 Aug 2011 15:28:12 +0000 (UTC) Received: (qmail 48508 invoked by uid 500); 9 Aug 2011 15:28:12 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 48410 invoked by uid 500); 9 Aug 2011 15:28:11 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 48396 invoked by uid 99); 9 Aug 2011 15:28:11 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 09 Aug 2011 15:28:11 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [216.32.180.12] (HELO VA3EHSOBE002.bigfish.com) (216.32.180.12) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 09 Aug 2011 15:28:03 +0000 Received: from mail34-va3-R.bigfish.com (10.7.14.253) by VA3EHSOBE002.bigfish.com (10.7.40.22) with Microsoft SMTP Server id 14.1.225.22; Tue, 9 Aug 2011 15:27:41 +0000 Received: from mail34-va3 (localhost.localdomain [127.0.0.1]) by mail34-va3-R.bigfish.com (Postfix) with ESMTP id D4D304381E0 for ; Tue, 9 Aug 2011 15:27:40 +0000 (UTC) X-SpamScore: 0 X-BigFish: VPS0(zzc85fhzz1202hzz8275bh8275dhz2dh2a8h668h839h61h) X-Spam-TCS-SCL: 0:0 X-Forefront-Antispam-Report: CIP:74.62.37.82;KIP:(null);UIP:(null);IPVD:NLI;H:CPHUB1.canoga.com;RD:rrcs-74-62-37-82.west.biz.rr.com;EFVD:NLI Received: from mail34-va3 (localhost.localdomain [127.0.0.1]) by mail34-va3 (MessageSwitch) id 1312903596197019_15762; Tue, 9 Aug 2011 15:26:36 +0000 (UTC) Received: from VA3EHSMHS009.bigfish.com (unknown [10.7.14.246]) by mail34-va3.bigfish.com (Postfix) with ESMTP id EE8F687832B for ; Tue, 9 Aug 2011 15:24:54 +0000 (UTC) Received: from CPHUB1.canoga.com (74.62.37.82) by VA3EHSMHS009.bigfish.com (10.7.99.19) with Microsoft SMTP Server (TLS) id 14.1.225.22; Tue, 9 Aug 2011 15:24:12 +0000 Received: from CPHUB2.canoga.com (172.16.1.94) by CPHUB1.canoga.com (172.16.1.93) with Microsoft SMTP Server (TLS) id 8.2.213.0; Tue, 9 Aug 2011 08:24:48 -0700 Received: from vserver1.canoga.com ([169.254.2.6]) by CPHUB2.canoga.com ([172.16.1.94]) with mapi; Tue, 9 Aug 2011 08:24:47 -0700 From: "Bergquist, Brett" To: "derby-dev@db.apache.org" Date: Tue, 9 Aug 2011 08:24:10 -0700 Subject: Error when running SYSCS_UTIL.SYSCS_CHECK_TABLE Thread-Topic: Error when running SYSCS_UTIL.SYSCS_CHECK_TABLE Thread-Index: AcxWqGLjJR+MYiQHRki7TxmFmHC61Q== Message-ID: <97EB699F861AD841B5908C7CA9C956560160A03B5664@VSERVER1.canoga.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US X-TM-AS-Product-Ver: SMEX-8.0.0.1307-6.500.1024-18312.005 X-TM-AS-Result: No--12.194900-0.000000-31 X-TM-AS-User-Approved-Sender: Yes X-TM-AS-User-Blocked-Sender: No Content-Type: multipart/alternative; boundary="_000_97EB699F861AD841B5908C7CA9C956560160A03B5664VSERVER1can_" MIME-Version: 1.0 X-OriginatorOrg: canoga.com --_000_97EB699F861AD841B5908C7CA9C956560160A03B5664VSERVER1can_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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 foll= owing error: ERROR 38000: The exception 'java.lang.NullPointerException' was thrown whil= e evaluating an expression. ERROR XJ001: Java exception: ': java.lang.NullPointerException'. Note that this database is suspect to have corruption. The table I am tryi= ng 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 wi= th class loader sun.misc.Launcher$AppClassLoader@12360be0 Loaded from file:/opt/canoga/canogaview/glassfish/javadb/lib/derby.jar java.vendor=3DSun Microsystems Inc. java.runtime.version=3D1.6.0_21-b06 user.dir=3D/opt/canoga/canogaview/glassfish/javadb derby.system.home=3Dnull Database Class Loader started - derby.database.classpath=3D'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 dir= ectory /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)? --_000_97EB699F861AD841B5908C7CA9C956560160A03B5664VSERVER1can_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Database engine = is 10.8.1.2 (built from source with a patch for Restricted table support) a= nd 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 XJ= 001: Java exception: ': java.lang.NullPointerException'.

 

Note that this d= atabase 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 repor= ted.  Derby.log looks like:

&n= bsp;

----------------------------------------= ------------------------

Thu Sep 01 12:2= 1: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/jav= adb/lib/derby.jar

java.vendor=3DSun Micr= osystems Inc.

java.runtime.version=3D1.6= .0_21-b06

user.dir=3D/opt/canoga/canogav= iew/glassfish/javadb

derby.system.home= =3Dnull

Database Class Loader started - = derby.database.classpath=3D'CSEM.csemderby'

----------------------------------------------------------------

Thu Sep 01 14:27:50 EDT 2011: Shutting down De= rby engine

-----------------------------= -----------------------------------

Thu = Sep 01 14:27:50 EDT 2011:

Shutting dow= n instance a816c00e-0132-25cb-8e35-00003ceac520 on database directory /opt/= canoga/canogaview/glassfish/databases/csemdb with class loader sun.misc.Lau= ncher$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)?

 

 

= --_000_97EB699F861AD841B5908C7CA9C956560160A03B5664VSERVER1can_--