Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 49918 invoked from network); 14 Mar 2011 18:33:39 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 14 Mar 2011 18:33:39 -0000 Received: (qmail 81129 invoked by uid 500); 14 Mar 2011 18:33:39 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 81108 invoked by uid 500); 14 Mar 2011 18:33:39 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 81101 invoked by uid 99); 14 Mar 2011 18:33:39 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 14 Mar 2011 18:33:39 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [66.111.4.29] (HELO out5.smtp.messagingengine.com) (66.111.4.29) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 14 Mar 2011 18:33:32 +0000 Received: from compute3.internal (compute3.nyi.mail.srv.osa [10.202.2.43]) by gateway1.messagingengine.com (Postfix) with ESMTP id 5ED3420C17 for ; Mon, 14 Mar 2011 14:33:11 -0400 (EDT) Received: from web1.messagingengine.com ([10.202.2.211]) by compute3.internal (MEProxy); Mon, 14 Mar 2011 14:33:11 -0400 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=messagingengine.com; h=message-id:from:to:mime-version:content-transfer-encoding:content-type:subject:reply-to:date; s=smtpout; bh=BYT3deXc/QJf9s8aSImIRyB3bic=; b=fdumdj5g/EQ+agHOOVEjJ2edz91bNf0mH8JYHQF+i4gXIibqd0uCr4HSacJnzT8C3Bppa8ZfMqn2legIXC6GKFNpBRrMf9/1m91m8AMcwNPd/ixLGLEYG71h2y8dV/AcIS4QHf41Jm2SLsv4t+rl3YdGhM25FGhcRE+auivm4RM= Received: by web1.messagingengine.com (Postfix, from userid 99) id 3E2A35C0F09; Mon, 14 Mar 2011 14:33:11 -0400 (EDT) Message-Id: <1300127591.22683.1429656365@webmail.messagingengine.com> X-Sasl-Enc: MzOENpHIbaOXZG4+ktDlfIxEm0utkMCoFjsBvOdIvwt8 1300127591 From: "Phil Bradley" To: derby-user@db.apache.org MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: multipart/mixed; boundary="_----------=_1300127591226830" X-Mailer: MessagingEngine.com Webmail Interface Subject: ERROR XSAI2: The conglomerate (180,512) requested does not exist. Reply-To: philb@tower.ie Date: Mon, 14 Mar 2011 18:33:11 +0000 X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. --_----------=_1300127591226830 MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="us-ascii" Date: Mon, 14 Mar 2011 14:33:11 -0400 X-Mailer: MessagingEngine.com Webmail Interface Hi, I have a Java application using derby 10.4 in embedded mode which has been in production for approximately 1 year. About 2 months ago, I added a function to run SYSCS_COMPRESS_ TABLE on a nightly basis (this may or may not be related to the issue below). A few days ago, the client reported the following error on application startup: ERROR XSAI2: The conglomerate (180,512) requested does not exist. I now have a copy of the database and when I connect via ij, I receive the same error (completely reproducibly). I am attaching this output for reference. Note that the application uses derby 10.4 while I used the 10.5 libraries to make the connection; the observed behaviour is the same however. As regards the production issue, the client simply removed (copied actually) the problematic database and reinitialised the application so my goal is to understand (if possible) the cause of this and to identify possible work arounds. Is there anything I can do that might help resolve why this error is occurring? Is there additional logging that I can enable that might give more visibility on what is actually happening? Thanks and regards, Phil --_----------=_1300127591226830 MIME-Version: 1.0 Content-Disposition: attachment; filename="derbyoutput.txt" Content-Id: Content-Transfer-Encoding: base64 Content-Type: text/plain; name="derbyoutput.txt" X-Mailer: MIME::Lite 3.027 (F2.77; A2.06; B3.08; Q3.08) Date: Mon, 14 Mar 2011 14:33:11 -0400 QzpccGhpbGJcaWo+amF2YSAtY3AgZGVyYnljbGllbnQuamFyO2RlcmJ5Lmph cjtkZXJieXRvb2xzLmphciAtRGpkYmMuZHJpdmVycz1vcmcuYXBhY2hlLmRl cmJ5LmpkYmMuRW1iZWRkZWRkcml2ZXIgICANCi1EaWouZGF0YWJhc2U9amRi YzpkZXJieTpDOlxteWRiO2NyZWF0ZT10cnVlO3VzZXI9U0E7cGFzc3dvcmQ9 U0EgLURpai5leGNlcHRpb25UcmFjZT10cnVlIG9yZy5hcGFjaGUuZGVyYnku dG9vbHMuaWoNCmlqIHZlcnNpb24gMTAuNQ0KV0FSTklORyAwMUowMTogRGF0 YWJhc2UgJ0M6XG15ZGInIG5vdCBjcmVhdGVkLCBjb25uZWN0aW9uIG1hZGUg dG8gZXhpc3RpbmcgZGF0YWJhc2UgaW5zdGVhZC4NCkNPTk5FQ1RJT04wKiAt ICBqZGJjOmRlcmJ5OkM6XG15ZGINCiogPSBjdXJyZW50IGNvbm5lY3Rpb24N CmlqPiBzZWxlY3QgKiBmcm9tIGp2c2xtYXA7DQpFUlJPUiBYU0FJMjogVGhl IGNvbmdsb21lcmF0ZSAoMTgwLDUxMikgcmVxdWVzdGVkIGRvZXMgbm90IGV4 aXN0Lg0KamF2YS5zcWwuU1FMRXhjZXB0aW9uOiBUaGUgY29uZ2xvbWVyYXRl ICgxODAsNTEyKSByZXF1ZXN0ZWQgZG9lcyBub3QgZXhpc3QuDQogICAgICAg IGF0IG9yZy5hcGFjaGUuZGVyYnkuaW1wbC5qZGJjLlNRTEV4Y2VwdGlvbkZh Y3Rvcnk0MC5nZXRTUUxFeGNlcHRpb24oVW5rbm93biBTb3VyY2UpDQogICAg ICAgIGF0IG9yZy5hcGFjaGUuZGVyYnkuaW1wbC5qZGJjLlV0aWwuZ2VuZXJh dGVDc1NRTEV4Y2VwdGlvbihVbmtub3duIFNvdXJjZSkNCiAgICAgICAgYXQg b3JnLmFwYWNoZS5kZXJieS5pbXBsLmpkYmMuVHJhbnNhY3Rpb25SZXNvdXJj ZUltcGwud3JhcEluU1FMRXhjZXB0aW9uKFVua25vd24gU291cmNlKQ0KICAg ICAgICBhdCBvcmcuYXBhY2hlLmRlcmJ5LmltcGwuamRiYy5UcmFuc2FjdGlv blJlc291cmNlSW1wbC5oYW5kbGVFeGNlcHRpb24oVW5rbm93biBTb3VyY2Up DQogICAgICAgIGF0IG9yZy5hcGFjaGUuZGVyYnkuaW1wbC5qZGJjLkVtYmVk Q29ubmVjdGlvbi5oYW5kbGVFeGNlcHRpb24oVW5rbm93biBTb3VyY2UpDQog ICAgICAgIGF0IG9yZy5hcGFjaGUuZGVyYnkuaW1wbC5qZGJjLkNvbm5lY3Rp b25DaGlsZC5oYW5kbGVFeGNlcHRpb24oVW5rbm93biBTb3VyY2UpDQogICAg ICAgIGF0IG9yZy5hcGFjaGUuZGVyYnkuaW1wbC5qZGJjLkVtYmVkU3RhdGVt ZW50LmV4ZWN1dGUoVW5rbm93biBTb3VyY2UpDQogICAgICAgIGF0IG9yZy5h cGFjaGUuZGVyYnkuaW1wbC5qZGJjLkVtYmVkU3RhdGVtZW50LmV4ZWN1dGUo VW5rbm93biBTb3VyY2UpDQogICAgICAgIGF0IG9yZy5hcGFjaGUuZGVyYnku aW1wbC50b29scy5pai5pai5leGVjdXRlSW1tZWRpYXRlKFVua25vd24gU291 cmNlKQ0KICAgICAgICBhdCBvcmcuYXBhY2hlLmRlcmJ5LmltcGwudG9vbHMu aWoudXRpbE1haW4uZG9DYXRjaChVbmtub3duIFNvdXJjZSkNCiAgICAgICAg YXQgb3JnLmFwYWNoZS5kZXJieS5pbXBsLnRvb2xzLmlqLnV0aWxNYWluLnJ1 blNjcmlwdEd1dHMoVW5rbm93biBTb3VyY2UpDQogICAgICAgIGF0IG9yZy5h cGFjaGUuZGVyYnkuaW1wbC50b29scy5pai51dGlsTWFpbi5nbyhVbmtub3du IFNvdXJjZSkNCiAgICAgICAgYXQgb3JnLmFwYWNoZS5kZXJieS5pbXBsLnRv b2xzLmlqLk1haW4uZ28oVW5rbm93biBTb3VyY2UpDQogICAgICAgIGF0IG9y Zy5hcGFjaGUuZGVyYnkuaW1wbC50b29scy5pai5NYWluLm1haW5Db3JlKFVu a25vd24gU291cmNlKQ0KICAgICAgICBhdCBvcmcuYXBhY2hlLmRlcmJ5Lmlt cGwudG9vbHMuaWouTWFpbi5tYWluKFVua25vd24gU291cmNlKQ0KICAgICAg ICBhdCBvcmcuYXBhY2hlLmRlcmJ5LnRvb2xzLmlqLm1haW4oVW5rbm93biBT b3VyY2UpDQpDYXVzZWQgYnk6IGphdmEuc3FsLlNRTEV4Y2VwdGlvbjogVGhl IGNvbmdsb21lcmF0ZSAoMTgwLDUxMikgcmVxdWVzdGVkIGRvZXMgbm90IGV4 aXN0Lg0KICAgICAgICBhdCBvcmcuYXBhY2hlLmRlcmJ5LmltcGwuamRiYy5T UUxFeGNlcHRpb25GYWN0b3J5LmdldFNRTEV4Y2VwdGlvbihVbmtub3duIFNv dXJjZSkNCiAgICAgICAgYXQgb3JnLmFwYWNoZS5kZXJieS5pbXBsLmpkYmMu U1FMRXhjZXB0aW9uRmFjdG9yeTQwLndyYXBBcmdzRm9yVHJhbnNwb3J0QWNy b3NzRFJEQShVbmtub3duIFNvdXJjZSkNCiAgICAgICAgLi4uIDE2IG1vcmUN CkNhdXNlZCBieTogRVJST1IgWFNBSTI6IFRoZSBjb25nbG9tZXJhdGUgKDE4 MCw1MTIpIHJlcXVlc3RlZCBkb2VzIG5vdCBleGlzdC4NCiAgICAgICAgYXQg b3JnLmFwYWNoZS5kZXJieS5pYXBpLmVycm9yLlN0YW5kYXJkRXhjZXB0aW9u Lm5ld0V4Y2VwdGlvbihVbmtub3duIFNvdXJjZSkNCiAgICAgICAgYXQgb3Jn LmFwYWNoZS5kZXJieS5pbXBsLnN0b3JlLmFjY2Vzcy5oZWFwLkhlYXBDb25n bG9tZXJhdGVGYWN0b3J5LnJlYWRDb25nbG9tZXJhdGUoVW5rbm93biBTb3Vy Y2UpDQogICAgICAgIGF0IG9yZy5hcGFjaGUuZGVyYnkuaW1wbC5zdG9yZS5h Y2Nlc3MuUkFNQWNjZXNzTWFuYWdlci5jb25nbG9tQ2FjaGVGaW5kKFVua25v d24gU291cmNlKQ0KICAgICAgICBhdCBvcmcuYXBhY2hlLmRlcmJ5LmltcGwu c3RvcmUuYWNjZXNzLlJBTVRyYW5zYWN0aW9uLmZpbmRFeGlzdGluZ0Nvbmds b21lcmF0ZShVbmtub3duIFNvdXJjZSkNCiAgICAgICAgYXQgb3JnLmFwYWNo ZS5kZXJieS5pbXBsLnN0b3JlLmFjY2Vzcy5SQU1UcmFuc2FjdGlvbi5vcGVu U3RvcmVDb3N0KFVua25vd24gU291cmNlKQ0KICAgICAgICBhdCBvcmcuYXBh Y2hlLmRlcmJ5LmltcGwuc3FsLmNvbXBpbGUuQ29tcGlsZXJDb250ZXh0SW1w bC5nZXRTdG9yZUNvc3RDb250cm9sbGVyKFVua25vd24gU291cmNlKQ0KICAg ICAgICBhdCBvcmcuYXBhY2hlLmRlcmJ5LmltcGwuc3FsLmNvbXBpbGUuRnJv bUJhc2VUYWJsZS5nZXRTdG9yZUNvc3RDb250cm9sbGVyKFVua25vd24gU291 cmNlKQ0KICAgICAgICBhdCBvcmcuYXBhY2hlLmRlcmJ5LmltcGwuc3FsLmNv bXBpbGUuRnJvbUJhc2VUYWJsZS5lc3RpbWF0ZUNvc3QoVW5rbm93biBTb3Vy Y2UpDQogICAgICAgIGF0IG9yZy5hcGFjaGUuZGVyYnkuaW1wbC5zcWwuY29t cGlsZS5PcHRpbWl6ZXJJbXBsLmVzdGltYXRlVG90YWxDb3N0KFVua25vd24g U291cmNlKQ0KICAgICAgICBhdCBvcmcuYXBhY2hlLmRlcmJ5LmltcGwuc3Fs LmNvbXBpbGUuT3B0aW1pemVySW1wbC5jb3N0QmFzZWRDb3N0T3B0aW1pemFi bGUoVW5rbm93biBTb3VyY2UpDQogICAgICAgIGF0IG9yZy5hcGFjaGUuZGVy YnkuaW1wbC5zcWwuY29tcGlsZS5PcHRpbWl6ZXJJbXBsLmNvc3RPcHRpbWl6 YWJsZShVbmtub3duIFNvdXJjZSkNCiAgICAgICAgYXQgb3JnLmFwYWNoZS5k ZXJieS5pbXBsLnNxbC5jb21waWxlLkZyb21CYXNlVGFibGUub3B0aW1pemVJ dChVbmtub3duIFNvdXJjZSkNCiAgICAgICAgYXQgb3JnLmFwYWNoZS5kZXJi eS5pbXBsLnNxbC5jb21waWxlLlByb2plY3RSZXN0cmljdE5vZGUub3B0aW1p emVJdChVbmtub3duIFNvdXJjZSkNCiAgICAgICAgYXQgb3JnLmFwYWNoZS5k ZXJieS5pbXBsLnNxbC5jb21waWxlLk9wdGltaXplckltcGwuY29zdFBlcm11 dGF0aW9uKFVua25vd24gU291cmNlKQ0KICAgICAgICBhdCBvcmcuYXBhY2hl LmRlcmJ5LmltcGwuc3FsLmNvbXBpbGUuU2VsZWN0Tm9kZS5vcHRpbWl6ZShV bmtub3duIFNvdXJjZSkNCiAgICAgICAgYXQgb3JnLmFwYWNoZS5kZXJieS5p bXBsLnNxbC5jb21waWxlLkRNTFN0YXRlbWVudE5vZGUub3B0aW1pemVTdGF0 ZW1lbnQoVW5rbm93biBTb3VyY2UpDQogICAgICAgIGF0IG9yZy5hcGFjaGUu ZGVyYnkuaW1wbC5zcWwuY29tcGlsZS5DdXJzb3JOb2RlLm9wdGltaXplU3Rh dGVtZW50KFVua25vd24gU291cmNlKQ0KICAgICAgICBhdCBvcmcuYXBhY2hl LmRlcmJ5LmltcGwuc3FsLkdlbmVyaWNTdGF0ZW1lbnQucHJlcE1pbmlvbihV bmtub3duIFNvdXJjZSkNCiAgICAgICAgYXQgb3JnLmFwYWNoZS5kZXJieS5p bXBsLnNxbC5HZW5lcmljU3RhdGVtZW50LnByZXBhcmUoVW5rbm93biBTb3Vy Y2UpDQogICAgICAgIGF0IG9yZy5hcGFjaGUuZGVyYnkuaW1wbC5zcWwuY29u bi5HZW5lcmljTGFuZ3VhZ2VDb25uZWN0aW9uQ29udGV4dC5wcmVwYXJlSW50 ZXJuYWxTdGF0ZW1lbnQoVW5rbm93biBTb3VyY2UpDQogICAgICAgIC4uLiAx MCBtb3JlDQppaj4= --_----------=_1300127591226830--