Return-Path: X-Original-To: apmail-db-derby-user-archive@www.apache.org Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 727C6716B for ; Fri, 30 Sep 2011 14:38:52 +0000 (UTC) Received: (qmail 22663 invoked by uid 500); 30 Sep 2011 14:38:51 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 22001 invoked by uid 500); 30 Sep 2011 14:38:50 -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 21849 invoked by uid 99); 30 Sep 2011 14:38:50 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 Sep 2011 14:38:50 +0000 X-ASF-Spam-Status: No, hits=-0.6 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,FREEMAIL_FROM,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of fury123@gmail.com designates 209.85.213.172 as permitted sender) Received: from [209.85.213.172] (HELO mail-yx0-f172.google.com) (209.85.213.172) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 Sep 2011 14:38:42 +0000 Received: by yxt33 with SMTP id 33so2036540yxt.31 for ; Fri, 30 Sep 2011 07:38:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; bh=x7r7XFfyy4V1m6t5tr4kz9Cf8mZhoXKjzlYsPUKbDpY=; b=chQZ27j97iutyxlpkrfKRDq8eslB/RSyN27NBqfiJ86/xtUv2ZPBEb9KlVRhbwKi54 zUHa6RsDd39Z1xzT4ADC+PoQzLIgqd2fds2gWYKBS7i7tM89I5PKxNplh099qwdi0tvi YWUuv2cax5+coJSlgj06kJf+UFCgg53pvPvoA= MIME-Version: 1.0 Received: by 10.236.182.135 with SMTP id o7mr13935157yhm.34.1317393501535; Fri, 30 Sep 2011 07:38:21 -0700 (PDT) Received: by 10.236.43.129 with HTTP; Fri, 30 Sep 2011 07:38:21 -0700 (PDT) Date: Fri, 30 Sep 2011 16:38:21 +0200 Message-ID: Subject: Problem with a derby database - connection closed and ArrayIndexOutOfBoundsExeption From: rob To: Derby Discussion Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Checked: Checked by ClamAV on apache.org Hi, I have a derby database i use it in embeeded mode with datanucleus JDO, it was at version 10.5 and i have updated it to version 10.8, i used it for a while with no problems but now, with no reason, it becomes unusable with datanucleus. I am able to connect to it with a client like squirrel sql, run query on it etc, but using it with for example SchemaTool from datanucleus gives me an exception about the connection closed. SchemaTool is used to create/update the schema in the database and these are parts of the logs from running SchemaTool: 15:52:36.875 [main] DEBUG D.Connection - Connection "connection is closed" is already closed java.sql.SQLNonTransientConnectionException: No current connection. Caused by: java.sql.SQLException: No current connection. I have enabled in derby.properties : derby.stream.error.logSeverityLevel=0 derby.language.logStatementText=true and looking on derby.log i see several ArrayIndexOutOfBoundsExeption. I have to say that if i take the original copy of the database at version 10.5 and i update it to 10.8 i can use it with no problems with datanucleus, i don't understand what happened in this case. In my opinion it's not the update the cause but i don't know what is wrong with it and if there is some way to fix it. I have others databases 10.8(created with version 10.8) with the same schema of this that runs with datanucleus with no problems. I write below some of the exceptions from derby.log, the problem seems on the SYS.getIndexInfo. Thanks for the help Fri Sep 30 16:24:45 CEST 2011 Thread[main,5,main] (XID = 3784650), (SESSIONID = 5), (DATABASE = db/rilevdata), (DRDAID = null), Begin compiling prepared statement: EXECUTE STATEMENT SYS."getIndexInfo" :End prepared statement Fri Sep 30 16:24:45 CEST 2011 Thread[main,5,main] (XID = 3784650), (SESSIONID = 5), (DATABASE = db/rilevdata), (DRDAID = null), End compiling prepared statement: EXECUTE STATEMENT SYS."getIndexInfo" :End prepared statement Fri Sep 30 16:24:45 CEST 2011 Thread[main,5,main] (XID = 3784650), (SESSIONID = 5), (DATABASE = db/rilevdata), (DRDAID = null), Cleanup action starting Fri Sep 30 16:24:45 CEST 2011 Thread[main,5,main] (XID = 3784650), (SESSIONID = 5), (DATABASE = db/rilevdata), (DRDAID = null), Failed Statement is: null java.lang.ArrayIndexOutOfBoundsException: 0 Fri Sep 30 16:24:46 CEST 2011 Thread[main,5,main] (XID = 3784729), (SESSIONID = 7), (DATABASE = db/rilevdata), (DRDAID = null), Executing prepared statement: EXECUTE STATEMENT SYS."getTables" :End prepared statement with 7 parameters begin parameter #1: % :end parameter begin parameter #2: % :end parameter begin parameter #3: FASCE_LISTA :end parameter begin parameter #4: T :end parameter begin parameter #5: V :end parameter begin parameter #6: A :end parameter begin parameter #7: S :end parameter Fri Sep 30 16:24:46 CEST 2011 Thread[main,5,main] (XID = 3784729), (SESSIONID = 7), (DATABASE = db/rilevdata), (DRDAID = null), Cleanup action starting Fri Sep 30 16:24:46 CEST 2011 Thread[main,5,main] (XID = 3784729), (SESSIONID = 7), (DATABASE = db/rilevdata), (DRDAID = null), Failed Statement is: null with 7 parameters begin parameter #1: % :end parameter begin parameter #2: % :end parameter begin parameter #3: FASCE_LISTA :end parameter begin parameter #4: T :end parameter begin parameter #5: V :end parameter begin parameter #6: A :end parameter begin parameter #7: S :end parameter java.lang.ArrayIndexOutOfBoundsException: 0 Fri Sep 30 16:24:46 CEST 2011 Thread[main,5,main] (XID = 3784807), (SESSIONID = 9), (DATABASE = db/rilevdata), (DRDAID = null), Executing prepared statement: EXECUTE STATEMENT SYS."getTables" :End prepared statement with 7 parameters begin parameter #1: % :end parameter begin parameter #2: % :end parameter begin parameter #3: FASCE_LISTA :end parameter begin parameter #4: T :end parameter begin parameter #5: V :end parameter begin parameter #6: A :end parameter begin parameter #7: S :end parameter Fri Sep 30 16:24:46 CEST 2011 Thread[main,5,main] (XID = 3784807), (SESSIONID = 9), (DATABASE = db/rilevdata), (DRDAID = null), Cleanup action starting Fri Sep 30 16:24:46 CEST 2011 Thread[main,5,main] (XID = 3784807), (SESSIONID = 9), (DATABASE = db/rilevdata), (DRDAID = null), Failed Statement is: null with 7 parameters begin parameter #1: % :end parameter begin parameter #2: % :end parameter begin parameter #3: FASCE_LISTA :end parameter begin parameter #4: T :end parameter begin parameter #5: V :end parameter begin parameter #6: A :end parameter begin parameter #7: S :end parameter java.lang.ArrayIndexOutOfBoundsException: 0 Fri Sep 30 16:24:48 CEST 2011 Thread[main,5,main] (XID = 3784883), (SESSIONID = 1), (DATABASE = db/rilevdata), (DRDAID = null), Begin compiling prepared statement: EXECUTE STATEMENT SYS."getIndexInfo" :End prepared statement Fri Sep 30 16:24:48 CEST 2011 Thread[main,5,main] (XID = 3784883), (SESSIONID = 1), (DATABASE = db/rilevdata), (DRDAID = null), End compiling prepared statement: EXECUTE STATEMENT SYS."getIndexInfo" :End prepared statement Fri Sep 30 16:24:48 CEST 2011 Thread[main,5,main] (XID = 3784883), (SESSIONID = 1), (DATABASE = db/rilevdata), (DRDAID = null), Cleanup action starting Fri Sep 30 16:24:48 CEST 2011 Thread[main,5,main] (XID = 3784883), (SESSIONID = 1), (DATABASE = db/rilevdata), (DRDAID = null), Failed Statement is: null java.lang.ArrayIndexOutOfBoundsException: 0 Fri Sep 30 16:24:49 CEST 2011 Thread[main,5,main] (XID = 3785084), (SESSIONID = 3), (DATABASE = db/rilevdata), (DRDAID = null), Begin compiling prepared statement: EXECUTE STATEMENT SYS."getIndexInfo" :End prepared statement Fri Sep 30 16:24:49 CEST 2011 Thread[main,5,main] (XID = 3785084), (SESSIONID = 3), (DATABASE = db/rilevdata), (DRDAID = null), End compiling prepared statement: EXECUTE STATEMENT SYS."getIndexInfo" :End prepared statement Fri Sep 30 16:24:49 CEST 2011 Thread[main,5,main] (XID = 3785084), (SESSIONID = 3), (DATABASE = db/rilevdata), (DRDAID = null), Cleanup action starting Fri Sep 30 16:24:49 CEST 2011 Thread[main,5,main] (XID = 3785084), (SESSIONID = 3), (DATABASE = db/rilevdata), (DRDAID = null), Failed Statement is: null java.lang.ArrayIndexOutOfBoundsException: 0 Fri Sep 30 16:24:50 CEST 2011 Thread[main,5,main] (XID = 3785284), (SESSIONID = 11), (DATABASE = db/rilevdata), (DRDAID = null), Begin compiling prepared statement: EXECUTE STATEMENT SYS."getIndexInfo" :End prepared statement Fri Sep 30 16:24:50 CEST 2011 Thread[main,5,main] (XID = 3785284), (SESSIONID = 11), (DATABASE = db/rilevdata), (DRDAID = null), End compiling prepared statement: EXECUTE STATEMENT SYS."getIndexInfo" :End prepared statement Fri Sep 30 16:24:50 CEST 2011 Thread[main,5,main] (XID = 3785284), (SESSIONID = 11), (DATABASE = db/rilevdata), (DRDAID = null), Cleanup action starting Fri Sep 30 16:24:50 CEST 2011 Thread[main,5,main] (XID = 3785284), (SESSIONID = 11), (DATABASE = db/rilevdata), (DRDAID = null), Failed Statement is: null java.lang.ArrayIndexOutOfBoundsException: 0