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 445839C51 for ; Thu, 16 Feb 2012 20:37:24 +0000 (UTC) Received: (qmail 62071 invoked by uid 500); 16 Feb 2012 20:37:24 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 62049 invoked by uid 500); 16 Feb 2012 20:37:24 -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 62042 invoked by uid 99); 16 Feb 2012 20:37:24 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 16 Feb 2012 20:37:24 +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; Thu, 16 Feb 2012 20:37:19 +0000 Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116]) by hel.zones.apache.org (Postfix) with ESMTP id 8A45C1BBEE4 for ; Thu, 16 Feb 2012 20:36:59 +0000 (UTC) Date: Thu, 16 Feb 2012 20:36:59 +0000 (UTC) From: "Mike Matrigali (Reopened) (JIRA)" To: derby-dev@db.apache.org Message-ID: <1933164545.47818.1329424619567.JavaMail.tomcat@hel.zones.apache.org> In-Reply-To: <1205147286.44879.1316492888939.JavaMail.tomcat@hel.zones.apache.org> Subject: [jira] [Reopened] (DERBY-5423) ERROR X0Y84: Too much contention on sequence NSTESTTAB in ns system test 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-5423?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mike Matrigali reopened DERBY-5423: ----------------------------------- > ERROR X0Y84: Too much contention on sequence NSTESTTAB in ns system test > ------------------------------------------------------------------------- > > Key: DERBY-5423 > URL: https://issues.apache.org/jira/browse/DERBY-5423 > Project: Derby > Issue Type: Bug > Components: SQL > Affects Versions: 10.8.2.2 > Environment: Windows XP, with ibm 1.6 SR9 FP1 > Reporter: Myrna van Lunteren > > The nstest system test showed the following error in the test run with 10.8.2.1 (not seen with earlier versions, incl. 10.8.1.2): > ----------------------------- > ==========> Tester2Thread 45 THREAD starting <====== > Tester2Thread 45 is getting a connection to the database... > -->Thread Tester2Thread 45 starting with url jdbc:derby:nstestdb;create=true;bootPassword=12345678 <-- > Connection number: 52 > java.sql.SQLException: Too much contention on sequence NSTESTTAB. > at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) > at org.apache.derbyTesting.system.nstest.utils.DbUtil.add_one_row(DbUtil.java:201) > at org.apache.derbyTesting.system.nstest.tester.TesterObject.doIUDOperation(TesterObject.java:148) > at org.apache.derbyTesting.system.nstest.tester.Tester2.startTesting(Tester2.java:109) > at org.apache.derbyTesting.system.nstest.NsTest.run(NsTest.java:555) > Caused by: java.sql.SQLException: Too much contention on sequence NSTESTTAB. > at java.lang.Throwable.(Throwable.java:67) > at java.sql.SQLException.(SQLException.java:101) > at org.apache.derby.impl.jdbc.EmbedSQLException.(Unknown Source) > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) > ... 13 more > Caused by: ERROR X0Y84: Too much contention on sequence NSTESTTAB. > at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) > at org.apache.derby.impl.sql.catalog.SequenceUpdater.getCurrentValueAndAdvance(Unknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getCurrentValueAndAdvance(Unknown Source) > at org.apache.derby.impl.sql.execute.InsertResultSet.getSetAutoincrementValue(Unknown Source) > at org.apache.derby.impl.sql.execute.BaseActivation.getSetAutoincrementValue(Unknown Source) > at org.apache.derby.exe.ac7a858e18x0132x6516x81e1x0000003123480.e0(Unknown Source) > at org.apache.derby.impl.services.reflect.DirectCall.invoke(Unknown Source) > at org.apache.derby.impl.sql.execute.RowResultSet.getNextRowCore(Unknown Source) > at org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown Source) > at org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown Source) > at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source) > at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) > at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) > ... 7 more > --------------------------------- > After that, it happens again: > -------------------------------- > Exception when preparing or executing insert prepared stmt > java.sql.SQLException: Too much contention on sequence NSTESTTAB. > Tester2Thread 25 dbUtil ----> During executing/preparing insert stmt in dbUtil, exception thrown was : java.sql.SQLException: Too much contention on sequence NSTESTTAB. > java.sql.SQLException: Too much contention on sequence NSTESTTAB. > at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) > at org.apache.derbyTesting.system.nstest.utils.DbUtil.add_one_row(DbUtil.java:201) > at org.apache.derbyTesting.system.nstest.tester.TesterObject.doIUDOperation(TesterObject.java:148) > at org.apache.derbyTesting.system.nstest.tester.Tester2.startTesting(Tester2.java:109) > at org.apache.derbyTesting.system.nstest.NsTest.run(NsTest.java:555) > Caused by: java.sql.SQLException: Too much contention on sequence NSTESTTAB. > at java.lang.Throwable.(Throwable.java:67) > at java.sql.SQLException.(SQLException.java:101) > at org.apache.derby.impl.jdbc.EmbedSQLException.(Unknown Source) > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) > ... 13 more > Caused by: ERROR X0Y84: Too much contention on sequence NSTESTTAB. > at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) > at org.apache.derby.impl.sql.catalog.SequenceUpdater.getCurrentValueAndAdvance(Unknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getCurrentValueAndAdvance(Unknown Source) > at org.apache.derby.impl.sql.execute.InsertResultSet.getSetAutoincrementValue(Unknown Source) > at org.apache.derby.impl.sql.execute.BaseActivation.getSetAutoincrementValue(Unknown Source) > at org.apache.derby.exe.ac7a858e18x0132x6516x81e1x0000003123480.e0(Unknown Source) > at org.apache.derby.impl.services.reflect.DirectCall.invoke(Unknown Source) > at org.apache.derby.impl.sql.execute.RowResultSet.getNextRowCore(Unknown Source) > at org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown Source) > at org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown Source) > at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source) > at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) > at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) > ... 7 more > -------------------------- > And more often. -- 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