From derby-dev-return-92118-apmail-db-derby-dev-archive=db.apache.org@db.apache.org Tue Dec 6 13:56:27 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 36A689723 for ; Tue, 6 Dec 2011 13:56:27 +0000 (UTC) Received: (qmail 55436 invoked by uid 500); 6 Dec 2011 13:56:27 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 55398 invoked by uid 500); 6 Dec 2011 13:56:27 -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 55391 invoked by uid 99); 6 Dec 2011 13:56:26 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 06 Dec 2011 13:56:26 +0000 X-ASF-Spam-Status: No, hits=-0.1 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [65.55.88.13] (HELO TX2EHSOBE005.bigfish.com) (65.55.88.13) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 06 Dec 2011 13:56:17 +0000 Received: from mail24-tx2-R.bigfish.com (10.9.14.247) by TX2EHSOBE005.bigfish.com (10.9.40.25) with Microsoft SMTP Server id 14.1.225.23; Tue, 6 Dec 2011 13:55:55 +0000 Received: from mail24-tx2 (localhost [127.0.0.1]) by mail24-tx2-R.bigfish.com (Postfix) with ESMTP id 16D2D6001EF for ; Tue, 6 Dec 2011 13:55:55 +0000 (UTC) X-SpamScore: 0 X-BigFish: VPS0(zzc85fhzz1202hzz8275bh8275dhz2dh2a8h668h839h66h) X-Spam-TCS-SCL: 5:0 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 mail24-tx2 (localhost.localdomain [127.0.0.1]) by mail24-tx2 (MessageSwitch) id 1323179754749463_15844; Tue, 6 Dec 2011 13:55:54 +0000 (UTC) Received: from TX2EHSMHS006.bigfish.com (unknown [10.9.14.244]) by mail24-tx2.bigfish.com (Postfix) with ESMTP id AED3A40046 for ; Tue, 6 Dec 2011 13:55:54 +0000 (UTC) Received: from CPHUB1.canoga.com (74.62.37.82) by TX2EHSMHS006.bigfish.com (10.9.99.106) with Microsoft SMTP Server (TLS) id 14.1.225.22; Tue, 6 Dec 2011 13:55:53 +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, 6 Dec 2011 05:56:46 -0800 Received: from vserver1.canoga.com ([169.254.2.87]) by CPHUB2.canoga.com ([172.16.1.94]) with mapi; Tue, 6 Dec 2011 05:56:45 -0800 From: "Bergquist, Brett" To: "derby-dev@db.apache.org" Date: Tue, 6 Dec 2011 05:55:45 -0800 Subject: how can I force a rollback of an XA transaction Thread-Topic: how can I force a rollback of an XA transaction Thread-Index: Acy0HsBYXptcwthuSO6ZxKBtwfw16w== Message-ID: <97EB699F861AD841B5908C7CA9C9565601CC37389C5C@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-18562.005 X-TM-AS-Result: No--12.459700-0.000000-31 X-TM-AS-User-Approved-Sender: Yes X-TM-AS-User-Blocked-Sender: No Content-Type: multipart/alternative; boundary="_000_97EB699F861AD841B5908C7CA9C9565601CC37389C5CVSERVER1can_" MIME-Version: 1.0 X-OriginatorOrg: canoga.com X-Virus-Checked: Checked by ClamAV on apache.org --_000_97EB699F861AD841B5908C7CA9C9565601CC37389C5CVSERVER1can_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable The JVM that derby was running in crashed with a SEGV. There application s= erver also went down. When I brought both up, the database shows two XA tr= ansactions in the PREPARE state (looking at syscs_diag.transaction_table) b= ut the application server has no reference to these transactions to force a= rollback. Files in the database "log" directory are being created, with 3= 862 being the current count. I need a way to get this to be cleaned up. It would be best if this could = be done with the database online as I don't have days to wait for the datab= ase to come up. Any help will be greatly appreciated. Brett --_000_97EB699F861AD841B5908C7CA9C9565601CC37389C5CVSERVER1can_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

The JVM that der= by was running in crashed with a SEGV.  There application server also = went down.  When I brought both up, the database shows two XA transact= ions in the PREPARE state (looking at syscs_diag.transaction_table) but the= application server has no reference to these transactions to force a rollb= ack.  Files in the database “log” directory are being crea= ted, with 3862 being the current count. 

 

I need a way to get this t= o be cleaned up.  It would be best if this could be done with the data= base online as I don’t have days to wait for the database to come up.=

 

Any help will be greatly appreciated.

 

Brett

= --_000_97EB699F861AD841B5908C7CA9C9565601CC37389C5CVSERVER1can_--