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 C748F9D8F for ; Tue, 10 Apr 2012 15:15:43 +0000 (UTC) Received: (qmail 78983 invoked by uid 500); 10 Apr 2012 15:15:43 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 78950 invoked by uid 500); 10 Apr 2012 15:15:43 -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 78942 invoked by uid 99); 10 Apr 2012 15:15:43 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Apr 2012 15:15:43 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED,T_RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.116] (HELO hel.zones.apache.org) (140.211.11.116) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Apr 2012 15:15:40 +0000 Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116]) by hel.zones.apache.org (Postfix) with ESMTP id 59CAF363E75 for ; Tue, 10 Apr 2012 15:15:19 +0000 (UTC) Date: Tue, 10 Apr 2012 15:15:19 +0000 (UTC) From: "Mike Matrigali (Commented) (JIRA)" To: derby-dev@db.apache.org Message-ID: <769825003.7774.1334070919377.JavaMail.tomcat@hel.zones.apache.org> In-Reply-To: <1316791371.24245.1333731201903.JavaMail.tomcat@hel.zones.apache.org> Subject: [jira] [Commented] (DERBY-5685) java.lang.ArrayIndexOutOfBoundsException in BTreeForwardScan.fetchRows(BTreeForwardScan.java:235) on Z/Os MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/DERBY-5685?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13250722#comment-13250722 ] Mike Matrigali commented on DERBY-5685: --------------------------------------- adding link to one more source file of interest: http://svn.apache.org/viewvc/db/derby/code/branches/10.5/java/engine/org/apache/derby/impl/store/access/btree/OpenBTree.java?view=markup > java.lang.ArrayIndexOutOfBoundsException in BTreeForwardScan.fetchRows(BTreeForwardScan.java:235) on Z/Os > --------------------------------------------------------------------------------------------------------- > > Key: DERBY-5685 > URL: https://issues.apache.org/jira/browse/DERBY-5685 > Project: Derby > Issue Type: Bug > Components: Store > Affects Versions: 10.5.3.2 > Environment: - Apache Derby - 10.5.3.2 - (1083356) > z/OS 64 bit > java.vendor=IBM Corporation > java.runtime.version=pmz6460_26sr1fp1-20120309_01 (SR1 FP1) > java.fullversion=JRE 1.6.0 IBM J9 2.6 z/OS s390x-64 20120308_104898 (JIT enabled, AOT enabled) > J9VM - R26_Java626_SR1_FP1_20120308_1511_B104898 > JIT - r11_20111028_21230ifx5 > GC - R26_Java626_SR1_FP1_20120308_1511_B104898 > J9CL - 20120308_104898 > Reporter: Kathey Marsden > > On Z/os the following intermittent ArrayIndexOutOfBounds exception is being seen executing a query. > SELECT TASKID, VERSION,ROW_VERSION, TASKTYPE, TASKSUSPENDED, CANCELLED, NEXTFIRETIME, STARTBYINTERVAL, STARTBYTIME, VALIDFROMTIME, VALIDTOTIME, REPEATINTERVAL, MAXREPEATS, REPEATSLEFT, TASKINFO, NAME, AUTOPURGE, FAILUREACTION, MAXATTEMPTS, QOS, PARTITIONID, CREATETIME from RELEASE.WPS_SCDTASK where ((NEXTFIRETIME < ?) AND (REPEATSLEFT <> 0) AND (CANCELLED = 0) AND (TASKSUSPENDED in (0, 4, 8, 12)) AND (((PARTITIONID >= 5 AND PARTITIONID <= 4100) OR (PARTITIONID IN (1, 2, 3, 4))))) ORDER BY NEXTFIRETIME ASC with 1 parameters begin parameter #1: 1333683143093 :end parameter > java.lang.ArrayIndexOutOfBoundsException > at org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(BTreeForwardScan.java:235) > at org.apache.derby.impl.store.access.btree.BTreeScan.fetchNext(BTreeScan.java:1503) > at org.apache.derby.impl.sql.execute.TableScanResultSet.getNextRowCore(TableScanResultSet.java:577) > at org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.getNextRowCore(IndexRowToBaseRowResultSet.java:373) > at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(ProjectRestrictResultSet.java:268) > at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(BasicNoPutResultSetImpl.java:466) > at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(EmbedResultSet.java:428) > at org.apache.derby.impl.jdbc.EmbedResultSet.next(EmbedResultSet.java:372) > > After that every attempt to get a connection fails because just making the connection does some sort of query checking user credentials. > 2012-04-06 03:32:13.723 GMT Thread[Non-deferrable Alarm : 0,5,main] (XID = 176924), (SESSIONID = 12), (DATABASE = /WebSphere/1/AppServer/profiles/default/PortalServer/derby/wpsdb), (DRDAID = null), Cleanup action starting > java.lang.ArrayIndexOutOfBoundsException > at org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(BTreeForwardScan.java:235) > at org.apache.derby.impl.store.access.btree.BTreeScan.fetchNext(BTreeScan.java:1503) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getDescriptorViaIndexMinion(DataDictionaryImpl.java:8713) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getDescriptorViaIndex(DataDictionaryImpl.java:8637) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.locateSchemaRow(DataDictionaryImpl.java:1618) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getSchemaDescriptor(DataDictionaryImpl.java:1485) > at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.initDefaultSchemaDescriptor(GenericLanguageConnectionContext.java:376) > at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.initialize(GenericLanguageConnectionContext.java:352) > at org.apache.derby.impl.db.BasicDatabase.setupConnection(BasicDatabase.java:309) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.startTransaction(TransactionResourceImpl.java:188) > at org.apache.derby.impl.jdbc.EmbedConnection.checkUserIsNotARole(EmbedConnection.java:1179) > at org.apache.derby.impl.jdbc.EmbedConnection.checkUserCredentials(EmbedConnection.java:1143) > at org.apache.derby.impl.jdbc.EmbedConnection.(EmbedConnection.java:411) > at org.apache.derby.impl.jdbc.EmbedConnection30.(EmbedConnection30.java:73) > at org.apache.derby.impl.jdbc.EmbedConnection40.(EmbedConnection40.java:54) > at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Driver40.java:68) > at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:238) > at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(EmbeddedDataSource.java:479) > at org.apache.derby.jdbc.EmbedPooledConnection.openRealConnection(EmbedPooledConnection.java:169) > at org.apache.derby.jdbc.EmbedPooledConnection.(EmbedPooledConnection.java:110) > at org.apache.derby.jdbc.EmbedXAConnection.(EmbedXAConnection.java:53) > at org.apache.derby.jdbc.EmbedXAConnection40.(EmbedXAConnection40.java:58) > at org.apache.derby.jdbc.Driver40.getNewXAConnection(Driver40.java:189) > at org.apache.derby.jdbc.EmbeddedXADataSource.createXAConnection(EmbeddedXADataSource.java:233) > at org.apache.derby.jdbc.EmbeddedXADataSource.getXAConnection(EmbeddedXADataSource.java:103) > > I suspect this is a JIT issue, so this will probably be closed invalid once that is tracked down. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira