From derby-dev-return-93804-apmail-db-derby-dev-archive=db.apache.org@db.apache.org Tue Feb 28 22:10:47 2012 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 C628C9745 for ; Tue, 28 Feb 2012 22:10:47 +0000 (UTC) Received: (qmail 27414 invoked by uid 500); 28 Feb 2012 22:10:46 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 27302 invoked by uid 500); 28 Feb 2012 22:10:46 -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 27172 invoked by uid 99); 28 Feb 2012 22:10:46 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 28 Feb 2012 22:10:46 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [216.32.181.186] (HELO ch1outboundpool.messaging.microsoft.com) (216.32.181.186) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 28 Feb 2012 22:10:22 +0000 Received: from mail144-ch1-R.bigfish.com (10.43.68.245) by CH1EHSOBE004.bigfish.com (10.43.70.54) with Microsoft SMTP Server id 14.1.225.23; Tue, 28 Feb 2012 22:10:01 +0000 Received: from mail144-ch1 (localhost [127.0.0.1]) by mail144-ch1-R.bigfish.com (Postfix) with ESMTP id 415E360077 for ; Tue, 28 Feb 2012 22:10:01 +0000 (UTC) X-SpamScore: -1 X-BigFish: VPS-1(zzbb2dIc85fhzz1202hzz8275bh8275dhz2dh2a8h668h839h) X-Forefront-Antispam-Report: CIP:74.62.37.82;KIP:(null);UIP:(null);IPV:NLI;H:CPHUB1.canoga.com;RD:rrcs-74-62-37-82.west.biz.rr.com;EFVD:NLI Received: from mail144-ch1 (localhost.localdomain [127.0.0.1]) by mail144-ch1 (MessageSwitch) id 1330466998566123_8855; Tue, 28 Feb 2012 22:09:58 +0000 (UTC) Received: from CH1EHSMHS004.bigfish.com (snatpool2.int.messaging.microsoft.com [10.43.68.237]) by mail144-ch1.bigfish.com (Postfix) with ESMTP id 7E6D7360047 for ; Tue, 28 Feb 2012 22:09:58 +0000 (UTC) Received: from CPHUB1.canoga.com (74.62.37.82) by CH1EHSMHS004.bigfish.com (10.43.70.4) with Microsoft SMTP Server (TLS) id 14.1.225.23; Tue, 28 Feb 2012 22:09:57 +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, 28 Feb 2012 14:10:56 -0800 Received: from vserver1.canoga.com ([169.254.2.24]) by CPHUB2.canoga.com ([172.16.1.94]) with mapi; Tue, 28 Feb 2012 14:10:55 -0800 From: "Bergquist, Brett" To: "derby-dev@db.apache.org" Date: Tue, 28 Feb 2012 14:09:51 -0800 Subject: Had Derby 10.8.2.2 fail today and need some thoughts Thread-Topic: Had Derby 10.8.2.2 fail today and need some thoughts Thread-Index: Acz2ZbEhyK9Y60sFTWq5minkB/wW7Q== Message-ID: <97EB699F861AD841B5908C7CA9C9565602065A079A4D@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-18740.005 X-TM-AS-Result: No--17.399700-0.000000-31 X-TM-AS-User-Approved-Sender: Yes X-TM-AS-User-Blocked-Sender: No Content-Type: multipart/alternative; boundary="_000_97EB699F861AD841B5908C7CA9C9565602065A079A4DVSERVER1can_" MIME-Version: 1.0 X-OriginatorOrg: canoga.com X-Virus-Checked: Checked by ClamAV on apache.org --_000_97EB699F861AD841B5908C7CA9C9565602065A079A4DVSERVER1can_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Our customer called and said the server was not working. Before restartin= g, I retrieved the derby.log and it seems strange because this was right at= the top of the log: ---------------------------------------------------------------- Tue Feb 28 15:33:58 EST 2012: Shutting down Derby engine ---------------------------------------------------------------- Tue Feb 28 15:37:28 EST 2012 Thread[DRDAConnThread_245,5,main] (XID =3D 148= 2003981), (SESSIONID =3D 133257672), (DATABASE =3D csemdb), (DRDAID =3D ???= ?????.??-4471791624540787385{335696}), Cleanup action starting Tue Feb 28 15:37:28 EST 2012 Thread[DRDAConnThread_245,5,main] (XID =3D 148= 2003981), (SESSIONID =3D 133257672), (DATABASE =3D csemdb), (DRDAID =3D ???= ?????.??-4471791624540787385{335696}), Failed Statement is: null java.lang.NullPointerException Cleanup action completed The strange part is "Shutting down Derby engine" is the first thing in the = log. The server was up and running since 2/16/2012 with no problems with = about 60M transactions processed, a backup performed each night, etc. An= d then this. So any thoughts on how the derby.log could be recreated and have this as th= e first thing in the log? I am thinking maybe an OutOfMemory condition bu= t all traces of whatever when wrong are gone, so I am trying to work backwa= rds and see how the derby.log could be created with this as the first thing= in the log. Thanks for any help! Brett --_000_97EB699F861AD841B5908C7CA9C9565602065A079A4DVSERVER1can_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Our customer cal= led and said the server was not working.   Before restarting, I r= etrieved the derby.log and it seems strange because this was right at the t= op of the log:

 

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

Tue Feb 28 15:33:58 EST 2012: Shutting down Derby eng= ine

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

Tue Feb 28 15:37:28 EST 2012 Thr= ead[DRDAConnThread_245,5,main] (XID =3D 1482003981), (SESSIONID =3D 1332576= 72), (DATABASE =3D csemdb), (DRDAID =3D ????????.??-4471791624540787385{335= 696}), Cleanup action starting

Tue Feb 28 15:37:28 EST 2012 Thread[DRDAConnThread_245,5,= main] (XID =3D 1482003981), (SESSIONID =3D 133257672), (DATABASE =3D csemdb= ), (DRDAID =3D ????????.??-4471791624540787385{335696}), Failed Statement i= s: null

java.= lang.NullPointerException

Cleanup action completed

 

The strange part is “Shutting= down Derby engine” is the first thing in the log.   The se= rver was up and running since 2/16/2012 with no problems with about 60M tra= nsactions processed, a backup performed each night, etc.    = And then this.

 

So any thoughts on how the derby.log could be recreated an= d have this as the first thing in the log?   I am thinking maybe = an OutOfMemory condition but all traces of whatever when wrong are gone, so= I am trying to work backwards and see how the derby.log could be created w= ith this as the first thing in the log.

=  

Thanks for any help!

 

Brett=

 

 

= --_000_97EB699F861AD841B5908C7CA9C9565602065A079A4DVSERVER1can_--