[JBoss JIRA] (JBTM-1426) ORA-01000: maximum open cursors exceeded during oracle JDBC object store test
by Tom Jenkinson (JIRA)
[ https://issues.jboss.org/browse/JBTM-1426?page=com.atlassian.jira.plugin.... ]
Tom Jenkinson updated JBTM-1426:
--------------------------------
Remaining Estimate: 0 minutes (was: 2 hours)
> ORA-01000: maximum open cursors exceeded during oracle JDBC object store test
> -----------------------------------------------------------------------------
>
> Key: JBTM-1426
> URL: https://issues.jboss.org/browse/JBTM-1426
> Project: JBoss Transaction Manager
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Testing, Transaction Core
> Reporter: Gytis Trikleris
> Assignee: Tom Jenkinson
> Fix For: 4.17.4, 5.0.0.M2
>
> Time Spent: 2 hours
> Remaining Estimate: 0 minutes
>
> See: http://172.17.131.2/job/jbossts-EAP61-jdbcobjectstore/31
> {noformat}
> starting command: /usr/local/jdk1.6.0_37/bin/java -classpath dist/narayana-full-4.17.4.Final-SNAPSHOT/etc/:dist/narayana-full-4.17.4.Final-SNAPSHOT/lib/*:dist/narayana-full-4.17.4.Final-SNAPSHOT/lib/ext/*:dist/narayana-full-4.17.4.Final-SNAPSHOT/jacorb/lib/*:dist/narayana-full-4.17.4.Final-SNAPSHOT/jacorb/etc/:ext/fscontext.jar:ext/providerutil.jar:ext/jboss-profiler-jvmti.jar:ext/jboss-logging-spi.jar:tests/build/classes/:dbdrivers/selected_dbdriver/*:dbdrivers/DB2_v9.7/db2jcc.jar:dbdrivers/jConnect-6_0/classes/jconn3.jar:dbdrivers/mssql2005_sqljdbc_2.0/enu/sqljdbc4.jar:dbdrivers/mysql-connector-java-5.1.8-bin.jar:dbdrivers/oracle_10_2_0_4/ojdbc14.jar:dbdrivers/postgresql-8.3-605.jdbc4.jar:../build/extlib/emma.jar:../build/extlib/netty.jar -Dqa.debug=true -Djava.naming.provider.url=file:///tmp -Djava.naming.factory.initial=com.sun.jndi.fscontext.RefFSContextFactory -Dperformanceprofilestore.dir=config/perf_profiles/ -Djdbcprofilestore.dir=config/jdbc_profiles -Dmemorytestprofilestore.dir=config/memory_profiles/ -Dots.server.bindname=value_1 -DCoordinatorEnvironmentBean.maintainHeuristics=NO -DRecoveryEnvironmentBean.recoveryBackoffPeriod=5 -DCoreEnvironmentBean.timeoutFactor=2 -DCoordinatorEnvironmentBean.defaultTimeout=240 -Demma.coverage.out.file=./testoutput/txcore_lockrecord/LockRecord_Thread_Test028b/client_0-coverage.ec -DportOffsetId=1 -DObjectStoreBaseDir=/home/hudson/workspace/jbossts-EAP61-jdbcobjectstore/qa/testoutput/txcore_lockrecord/LockRecord_Thread_Test028b/client_0 -DRecoveryEnvironmentBean.recoveryListener=true -DObjectStoreEnvironmentBean.objectStoreType=com.arjuna.ats.internal.arjuna.objectstore.jdbc.JDBCStore -DObjectStoreEnvironmentBean.jdbcAccess=com.arjuna.ats.internal.arjuna.objectstore.jdbc.accessors.DynamicDataSourceJDBCAccess;ClassName=oracle.jdbc.pool.OracleDataSource;DriverType=thin;ServerName=tywin.buildnet.ncl.jboss.com;NetworkProtocol=tcp;DatabaseName=orcl;PortNumber=1521;User=dtf11;Password=dtf11 -DObjectStoreEnvironmentBean.tablePrefix=Action -DObjectStoreEnvironmentBean.stateStore.objectStoreType=com.arjuna.ats.internal.arjuna.objectstore.jdbc.JDBCStore -DObjectStoreEnvironmentBean.stateStore.jdbcAccess=com.arjuna.ats.internal.arjuna.objectstore.jdbc.accessors.DynamicDataSourceJDBCAccess;ClassName=oracle.jdbc.pool.OracleDataSource;DriverType=thin;ServerName=tywin.buildnet.ncl.jboss.com;NetworkProtocol=tcp;DatabaseName=orcl;PortNumber=1521;User=dtf11;Password=dtf11 -DObjectStoreEnvironmentBean.stateStore.tablePrefix=stateStore -DObjectStoreEnvironmentBean.communicationStore.objectStoreType=com.arjuna.ats.internal.arjuna.objectstore.jdbc.JDBCStore -DObjectStoreEnvironmentBean.communicationStore.jdbcAccess=com.arjuna.ats.internal.arjuna.objectstore.jdbc.accessors.DynamicDataSourceJDBCAccess;ClassName=oracle.jdbc.pool.OracleDataSource;DriverType=thin;ServerName=tywin.buildnet.ncl.jboss.com;NetworkProtocol=tcp;DatabaseName=orcl;PortNumber=1521;User=dtf11;Password=dtf11 -DObjectStoreEnvironmentBean.communicationStore.tablePrefix=Communication org.jboss.jbossts.qa.ArjunaCore.LockManager.client.WorkerClient003 -newlock 10 10 2
> 2013-01-11 06:42:48,696 err: log4j:WARN No appenders could be found for logger (org.jboss.logging).
> 2013-01-11 06:42:48,696 err: log4j:WARN Please initialize the log4j system properly.
> 2013-01-11 06:42:49,683 err: trying to get lock for 1000th time
> 2013-01-11 06:42:49,700 err: trying to get lock for 1000th time
> 2013-01-11 06:42:49,703 err: trying to get lock for 1000th time
> 2013-01-11 06:42:49,705 err: trying to get lock for 1000th time
> 2013-01-11 06:42:49,707 err: trying to get lock for 1000th time
> 2013-01-11 06:42:49,709 err: trying to get lock for 1000th time
> 2013-01-11 06:42:49,711 err: trying to get lock for 1000th time
> 2013-01-11 06:42:49,717 err: trying to get lock for 1000th time
> 2013-01-11 06:42:49,719 err: trying to get lock for 1000th time
> 2013-01-11 06:42:49,721 err: trying to get lock for 1000th time
> 2013-01-11 06:42:52,690 out: 2013-01-11 06:42:52,689 [Thread-1] WARN com.arjuna.ats.arjuna - ARJUNA012258: JDBCImple:write_state caught exception
> 2013-01-11 06:42:52,691 out: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
> 2013-01-11 06:42:52,691 out: ORA-01000: maximum open cursors exceeded
> 2013-01-11 06:42:52,691 out: ORA-00604: error occurred at recursive SQL level 1
> 2013-01-11 06:42:52,691 out: ORA-01000: maximum open cursors exceeded
> 2013-01-11 06:42:52,691 out: ORA-01000: maximum open cursors exceeded
> 2013-01-11 06:42:52,691 out:
> 2013-01-11 06:42:52,691 out: at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
> 2013-01-11 06:42:52,691 out: at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> 2013-01-11 06:42:52,691 out: at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> 2013-01-11 06:42:52,691 out: at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
> 2013-01-11 06:42:52,691 out: at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
> 2013-01-11 06:42:52,691 out: at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)
> 2013-01-11 06:42:52,691 out: at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
> 2013-01-11 06:42:52,691 out: at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
> 2013-01-11 06:42:52,691 out: at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3454)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.internal.arjuna.objectstore.jdbc.JDBCImple_driver.commit_state(JDBCImple_driver.java:104)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.internal.arjuna.objectstore.jdbc.JDBCStore.commit_state(JDBCStore.java:124)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.internal.arjuna.abstractrecords.PersistenceRecord.topLevelCommit(PersistenceRecord.java:171)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.arjuna.coordinator.BasicAction.doCommit(BasicAction.java:2733)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.arjuna.coordinator.BasicAction.doCommit(BasicAction.java:2649)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.arjuna.coordinator.BasicAction.phase2Commit(BasicAction.java:1814)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.arjuna.coordinator.BasicAction.End(BasicAction.java:1505)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:98)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:162)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:147)
> 2013-01-11 06:42:52,691 out: at org.jboss.jbossts.qa.ArjunaCore.LockManager.client.Worker003.run(Worker003.java:65)
> ....
> {noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 2 months
[JBoss JIRA] (JBTM-1426) ORA-01000: maximum open cursors exceeded during oracle JDBC object store test
by Tom Jenkinson (JIRA)
[ https://issues.jboss.org/browse/JBTM-1426?page=com.atlassian.jira.plugin.... ]
Tom Jenkinson logged work on JBTM-1426:
---------------------------------------
Author: Tom Jenkinson
Created on: 11/Jan/13 7:06 AM
Start Date: 11/Jan/13 7:06 AM
Worklog Time Spent: 2 hours
Issue Time Tracking
-------------------
Remaining Estimate: 2 hours
Time Spent: 2 hours
Worklog Id: (was: 12428332)
> ORA-01000: maximum open cursors exceeded during oracle JDBC object store test
> -----------------------------------------------------------------------------
>
> Key: JBTM-1426
> URL: https://issues.jboss.org/browse/JBTM-1426
> Project: JBoss Transaction Manager
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Testing, Transaction Core
> Reporter: Gytis Trikleris
> Assignee: Tom Jenkinson
> Fix For: 4.17.4, 5.0.0.M2
>
> Time Spent: 2 hours
> Remaining Estimate: 2 hours
>
> See: http://172.17.131.2/job/jbossts-EAP61-jdbcobjectstore/31
> {noformat}
> starting command: /usr/local/jdk1.6.0_37/bin/java -classpath dist/narayana-full-4.17.4.Final-SNAPSHOT/etc/:dist/narayana-full-4.17.4.Final-SNAPSHOT/lib/*:dist/narayana-full-4.17.4.Final-SNAPSHOT/lib/ext/*:dist/narayana-full-4.17.4.Final-SNAPSHOT/jacorb/lib/*:dist/narayana-full-4.17.4.Final-SNAPSHOT/jacorb/etc/:ext/fscontext.jar:ext/providerutil.jar:ext/jboss-profiler-jvmti.jar:ext/jboss-logging-spi.jar:tests/build/classes/:dbdrivers/selected_dbdriver/*:dbdrivers/DB2_v9.7/db2jcc.jar:dbdrivers/jConnect-6_0/classes/jconn3.jar:dbdrivers/mssql2005_sqljdbc_2.0/enu/sqljdbc4.jar:dbdrivers/mysql-connector-java-5.1.8-bin.jar:dbdrivers/oracle_10_2_0_4/ojdbc14.jar:dbdrivers/postgresql-8.3-605.jdbc4.jar:../build/extlib/emma.jar:../build/extlib/netty.jar -Dqa.debug=true -Djava.naming.provider.url=file:///tmp -Djava.naming.factory.initial=com.sun.jndi.fscontext.RefFSContextFactory -Dperformanceprofilestore.dir=config/perf_profiles/ -Djdbcprofilestore.dir=config/jdbc_profiles -Dmemorytestprofilestore.dir=config/memory_profiles/ -Dots.server.bindname=value_1 -DCoordinatorEnvironmentBean.maintainHeuristics=NO -DRecoveryEnvironmentBean.recoveryBackoffPeriod=5 -DCoreEnvironmentBean.timeoutFactor=2 -DCoordinatorEnvironmentBean.defaultTimeout=240 -Demma.coverage.out.file=./testoutput/txcore_lockrecord/LockRecord_Thread_Test028b/client_0-coverage.ec -DportOffsetId=1 -DObjectStoreBaseDir=/home/hudson/workspace/jbossts-EAP61-jdbcobjectstore/qa/testoutput/txcore_lockrecord/LockRecord_Thread_Test028b/client_0 -DRecoveryEnvironmentBean.recoveryListener=true -DObjectStoreEnvironmentBean.objectStoreType=com.arjuna.ats.internal.arjuna.objectstore.jdbc.JDBCStore -DObjectStoreEnvironmentBean.jdbcAccess=com.arjuna.ats.internal.arjuna.objectstore.jdbc.accessors.DynamicDataSourceJDBCAccess;ClassName=oracle.jdbc.pool.OracleDataSource;DriverType=thin;ServerName=tywin.buildnet.ncl.jboss.com;NetworkProtocol=tcp;DatabaseName=orcl;PortNumber=1521;User=dtf11;Password=dtf11 -DObjectStoreEnvironmentBean.tablePrefix=Action -DObjectStoreEnvironmentBean.stateStore.objectStoreType=com.arjuna.ats.internal.arjuna.objectstore.jdbc.JDBCStore -DObjectStoreEnvironmentBean.stateStore.jdbcAccess=com.arjuna.ats.internal.arjuna.objectstore.jdbc.accessors.DynamicDataSourceJDBCAccess;ClassName=oracle.jdbc.pool.OracleDataSource;DriverType=thin;ServerName=tywin.buildnet.ncl.jboss.com;NetworkProtocol=tcp;DatabaseName=orcl;PortNumber=1521;User=dtf11;Password=dtf11 -DObjectStoreEnvironmentBean.stateStore.tablePrefix=stateStore -DObjectStoreEnvironmentBean.communicationStore.objectStoreType=com.arjuna.ats.internal.arjuna.objectstore.jdbc.JDBCStore -DObjectStoreEnvironmentBean.communicationStore.jdbcAccess=com.arjuna.ats.internal.arjuna.objectstore.jdbc.accessors.DynamicDataSourceJDBCAccess;ClassName=oracle.jdbc.pool.OracleDataSource;DriverType=thin;ServerName=tywin.buildnet.ncl.jboss.com;NetworkProtocol=tcp;DatabaseName=orcl;PortNumber=1521;User=dtf11;Password=dtf11 -DObjectStoreEnvironmentBean.communicationStore.tablePrefix=Communication org.jboss.jbossts.qa.ArjunaCore.LockManager.client.WorkerClient003 -newlock 10 10 2
> 2013-01-11 06:42:48,696 err: log4j:WARN No appenders could be found for logger (org.jboss.logging).
> 2013-01-11 06:42:48,696 err: log4j:WARN Please initialize the log4j system properly.
> 2013-01-11 06:42:49,683 err: trying to get lock for 1000th time
> 2013-01-11 06:42:49,700 err: trying to get lock for 1000th time
> 2013-01-11 06:42:49,703 err: trying to get lock for 1000th time
> 2013-01-11 06:42:49,705 err: trying to get lock for 1000th time
> 2013-01-11 06:42:49,707 err: trying to get lock for 1000th time
> 2013-01-11 06:42:49,709 err: trying to get lock for 1000th time
> 2013-01-11 06:42:49,711 err: trying to get lock for 1000th time
> 2013-01-11 06:42:49,717 err: trying to get lock for 1000th time
> 2013-01-11 06:42:49,719 err: trying to get lock for 1000th time
> 2013-01-11 06:42:49,721 err: trying to get lock for 1000th time
> 2013-01-11 06:42:52,690 out: 2013-01-11 06:42:52,689 [Thread-1] WARN com.arjuna.ats.arjuna - ARJUNA012258: JDBCImple:write_state caught exception
> 2013-01-11 06:42:52,691 out: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
> 2013-01-11 06:42:52,691 out: ORA-01000: maximum open cursors exceeded
> 2013-01-11 06:42:52,691 out: ORA-00604: error occurred at recursive SQL level 1
> 2013-01-11 06:42:52,691 out: ORA-01000: maximum open cursors exceeded
> 2013-01-11 06:42:52,691 out: ORA-01000: maximum open cursors exceeded
> 2013-01-11 06:42:52,691 out:
> 2013-01-11 06:42:52,691 out: at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
> 2013-01-11 06:42:52,691 out: at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> 2013-01-11 06:42:52,691 out: at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> 2013-01-11 06:42:52,691 out: at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
> 2013-01-11 06:42:52,691 out: at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
> 2013-01-11 06:42:52,691 out: at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)
> 2013-01-11 06:42:52,691 out: at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
> 2013-01-11 06:42:52,691 out: at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
> 2013-01-11 06:42:52,691 out: at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3454)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.internal.arjuna.objectstore.jdbc.JDBCImple_driver.commit_state(JDBCImple_driver.java:104)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.internal.arjuna.objectstore.jdbc.JDBCStore.commit_state(JDBCStore.java:124)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.internal.arjuna.abstractrecords.PersistenceRecord.topLevelCommit(PersistenceRecord.java:171)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.arjuna.coordinator.BasicAction.doCommit(BasicAction.java:2733)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.arjuna.coordinator.BasicAction.doCommit(BasicAction.java:2649)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.arjuna.coordinator.BasicAction.phase2Commit(BasicAction.java:1814)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.arjuna.coordinator.BasicAction.End(BasicAction.java:1505)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:98)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:162)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:147)
> 2013-01-11 06:42:52,691 out: at org.jboss.jbossts.qa.ArjunaCore.LockManager.client.Worker003.run(Worker003.java:65)
> ....
> {noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 2 months
[JBoss JIRA] (JBTM-1374) JDBC Object Store Deadlock potential with MySQL
by Tom Jenkinson (JIRA)
[ https://issues.jboss.org/browse/JBTM-1374?page=com.atlassian.jira.plugin.... ]
Tom Jenkinson updated JBTM-1374:
--------------------------------
Status: Resolved (was: Pull Request Sent)
Fix Version/s: 5.0.0.M2
(was: 5.0.0.Final)
Resolution: Done
> JDBC Object Store Deadlock potential with MySQL
> -----------------------------------------------
>
> Key: JBTM-1374
> URL: https://issues.jboss.org/browse/JBTM-1374
> Project: JBoss Transaction Manager
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Testing
> Reporter: Gytis Trikleris
> Assignee: Tom Jenkinson
> Fix For: 4.17.4, 5.0.0.M2
>
> Attachments: LockRecord_Thread_Test036a.zip
>
>
> org.jboss.jbossts.qa.junit.testgroup.TestGroup_txcore_lockrecord test failed on jbossts-branch417-EAP61-java6-jdbcobjectstore
> See: http://172.17.131.2/job/jbossts-branch417-EAP61-java6-jdbcobjectstore/20/
> Failed tests:
> org.jboss.jbossts.qa.junit.testgroup.TestGroup_txcore_lockrecord
> performing command: /usr/local/jdk1.6.0_37/bin/java -classpath dist/narayana-full-4.17.4.Final-SNAPSHOT/etc/:dist/narayana-full-4.17.4.Final-SNAPSHOT/lib/*:dist/narayana-full-4.17.4.Final-SNAPSHOT/lib/ext/*:dist/narayana-full-4.17.4.Final-SNAPSHOT/jacorb/lib/*:dist/narayana-full-4.17.4.Final-SNAPSHOT/jacorb/etc/:ext/fscontext.jar:ext/providerutil.jar:ext/jboss-profiler-jvmti.jar:ext/jboss-logging-spi.jar:tests/build/classes/:dbdrivers/selected_dbdriver/*:dbdrivers/DB2_v9.7/db2jcc.jar:dbdrivers/jConnect-6_0/classes/jconn3.jar:dbdrivers/mssql2005_sqljdbc_2.0/enu/sqljdbc4.jar:dbdrivers/mysql-connector-java-5.1.8-bin.jar:dbdrivers/oracle_10_2_0_4/ojdbc14.jar:dbdrivers/postgresql-8.3-605.jdbc4.jar:../build/extlib/emma.jar:../build/extlib/netty.jar -Dqa.debug=true -Djava.naming.provider.url=file:///tmp -Djava.naming.factory.initial=com.sun.jndi.fscontext.RefFSContextFactory -Dperformanceprofilestore.dir=config/perf_profiles/ -Djdbcprofilestore.dir=config/jdbc_profiles -Dmemorytestprofilestore.dir=config/memory_profiles/ -Dots.server.bindname=value_1 -DCoordinatorEnvironmentBean.maintainHeuristics=NO -DRecoveryEnvironmentBean.recoveryBackoffPeriod=5 -DCoreEnvironmentBean.timeoutFactor=2 -DCoordinatorEnvironmentBean.defaultTimeout=240 -Demma.coverage.out.file=./testoutput/txcore_lockrecord/LockRecord_Thread_Test036a/emptyObjectStore-coverage.ec -DportOffsetId=0 -DObjectStoreBaseDir=/home/hudson/workspace/jbossts-branch417-EAP61-java6-jdbcobjectstore/qa/testoutput/txcore_lockrecord/LockRecord_Thread_Test036a/emptyObjectStore -DRecoveryEnvironmentBean.recoveryListener=true -DObjectStoreEnvironmentBean.objectStoreType=com.arjuna.ats.internal.arjuna.objectstore.jdbc.JDBCStore -DObjectStoreEnvironmentBean.jdbcAccess=com.arjuna.ats.internal.arjuna.objectstore.jdbc.accessors.DynamicDataSourceJDBCAccess;ClassName=com.mysql.jdbc.jdbc2.optional.MysqlDataSource;DatabaseName=jbossts;ServerName=tywin.buildnet.ncl.jboss.com;PortNumber=3306;User=dtf11;Password=dtf11 -DObjectStoreEnvironmentBean.tablePrefix=Action -DObjectStoreEnvironmentBean.stateStore.objectStoreType=com.arjuna.ats.internal.arjuna.objectstore.jdbc.JDBCStore -DObjectStoreEnvironmentBean.stateStore.jdbcAccess=com.arjuna.ats.internal.arjuna.objectstore.jdbc.accessors.DynamicDataSourceJDBCAccess;ClassName=com.mysql.jdbc.jdbc2.optional.MysqlDataSource;DatabaseName=jbossts;ServerName=tywin.buildnet.ncl.jboss.com;PortNumber=3306;User=dtf11;Password=dtf11 -DObjectStoreEnvironmentBean.stateStore.tablePrefix=stateStore -DObjectStoreEnvironmentBean.communicationStore.objectStoreType=com.arjuna.ats.internal.arjuna.objectstore.jdbc.JDBCStore -DObjectStoreEnvironmentBean.communicationStore.jdbcAccess=com.arjuna.ats.internal.arjuna.objectstore.jdbc.accessors.DynamicDataSourceJDBCAccess;ClassName=com.mysql.jdbc.jdbc2.optional.MysqlDataSource;DatabaseName=jbossts;ServerName=tywin.buildnet.ncl.jboss.com;PortNumber=3306;User=dtf11;Password=dtf11 -DObjectStoreEnvironmentBean.communicationStore.tablePrefix=Communication org.jboss.jbossts.qa.Utils.EmptyObjectStore
> starting command: /usr/local/jdk1.6.0_37/bin/java -classpath dist/narayana-full-4.17.4.Final-SNAPSHOT/etc/:dist/narayana-full-4.17.4.Final-SNAPSHOT/lib/*:dist/narayana-full-4.17.4.Final-SNAPSHOT/lib/ext/*:dist/narayana-full-4.17.4.Final-SNAPSHOT/jacorb/lib/*:dist/narayana-full-4.17.4.Final-SNAPSHOT/jacorb/etc/:ext/fscontext.jar:ext/providerutil.jar:ext/jboss-profiler-jvmti.jar:ext/jboss-logging-spi.jar:tests/build/classes/:dbdrivers/selected_dbdriver/*:dbdrivers/DB2_v9.7/db2jcc.jar:dbdrivers/jConnect-6_0/classes/jconn3.jar:dbdrivers/mssql2005_sqljdbc_2.0/enu/sqljdbc4.jar:dbdrivers/mysql-connector-java-5.1.8-bin.jar:dbdrivers/oracle_10_2_0_4/ojdbc14.jar:dbdrivers/postgresql-8.3-605.jdbc4.jar:../build/extlib/emma.jar:../build/extlib/netty.jar -Dqa.debug=true -Djava.naming.provider.url=file:///tmp -Djava.naming.factory.initial=com.sun.jndi.fscontext.RefFSContextFactory -Dperformanceprofilestore.dir=config/perf_profiles/ -Djdbcprofilestore.dir=config/jdbc_profiles -Dmemorytestprofilestore.dir=config/memory_profiles/ -Dots.server.bindname=value_1 -DCoordinatorEnvironmentBean.maintainHeuristics=NO -DRecoveryEnvironmentBean.recoveryBackoffPeriod=5 -DCoreEnvironmentBean.timeoutFactor=2 -DCoordinatorEnvironmentBean.defaultTimeout=240 -Demma.coverage.out.file=./testoutput/txcore_lockrecord/LockRecord_Thread_Test036a/client_0-coverage.ec -DportOffsetId=1 -DObjectStoreBaseDir=/home/hudson/workspace/jbossts-branch417-EAP61-java6-jdbcobjectstore/qa/testoutput/txcore_lockrecord/LockRecord_Thread_Test036a/client_0 -DRecoveryEnvironmentBean.recoveryListener=true -DObjectStoreEnvironmentBean.objectStoreType=com.arjuna.ats.internal.arjuna.objectstore.jdbc.JDBCStore -DObjectStoreEnvironmentBean.jdbcAccess=com.arjuna.ats.internal.arjuna.objectstore.jdbc.accessors.DynamicDataSourceJDBCAccess;ClassName=com.mysql.jdbc.jdbc2.optional.MysqlDataSource;DatabaseName=jbossts;ServerName=tywin.buildnet.ncl.jboss.com;PortNumber=3306;User=dtf11;Password=dtf11 -DObjectStoreEnvironmentBean.tablePrefix=Action -DObjectStoreEnvironmentBean.stateStore.objectStoreType=com.arjuna.ats.internal.arjuna.objectstore.jdbc.JDBCStore -DObjectStoreEnvironmentBean.stateStore.jdbcAccess=com.arjuna.ats.internal.arjuna.objectstore.jdbc.accessors.DynamicDataSourceJDBCAccess;ClassName=com.mysql.jdbc.jdbc2.optional.MysqlDataSource;DatabaseName=jbossts;ServerName=tywin.buildnet.ncl.jboss.com;PortNumber=3306;User=dtf11;Password=dtf11 -DObjectStoreEnvironmentBean.stateStore.tablePrefix=stateStore -DObjectStoreEnvironmentBean.communicationStore.objectStoreType=com.arjuna.ats.internal.arjuna.objectstore.jdbc.JDBCStore -DObjectStoreEnvironmentBean.communicationStore.jdbcAccess=com.arjuna.ats.internal.arjuna.objectstore.jdbc.accessors.DynamicDataSourceJDBCAccess;ClassName=com.mysql.jdbc.jdbc2.optional.MysqlDataSource;DatabaseName=jbossts;ServerName=tywin.buildnet.ncl.jboss.com;PortNumber=3306;User=dtf11;Password=dtf11 -DObjectStoreEnvironmentBean.communicationStore.tablePrefix=Communication org.jboss.jbossts.qa.ArjunaCore.LockManager.client.WorkerClient003 10 10 10
> performing command: /usr/local/jdk1.6.0_37/bin/java -classpath dist/narayana-full-4.17.4.Final-SNAPSHOT/etc/:dist/narayana-full-4.17.4.Final-SNAPSHOT/lib/*:dist/narayana-full-4.17.4.Final-SNAPSHOT/lib/ext/*:dist/narayana-full-4.17.4.Final-SNAPSHOT/jacorb/lib/*:dist/narayana-full-4.17.4.Final-SNAPSHOT/jacorb/etc/:ext/fscontext.jar:ext/providerutil.jar:ext/jboss-profiler-jvmti.jar:ext/jboss-logging-spi.jar:tests/build/classes/:dbdrivers/selected_dbdriver/*:dbdrivers/DB2_v9.7/db2jcc.jar:dbdrivers/jConnect-6_0/classes/jconn3.jar:dbdrivers/mssql2005_sqljdbc_2.0/enu/sqljdbc4.jar:dbdrivers/mysql-connector-java-5.1.8-bin.jar:dbdrivers/oracle_10_2_0_4/ojdbc14.jar:dbdrivers/postgresql-8.3-605.jdbc4.jar:../build/extlib/emma.jar:../build/extlib/netty.jar -Dqa.debug=true -Djava.naming.provider.url=file:///tmp -Djava.naming.factory.initial=com.sun.jndi.fscontext.RefFSContextFactory -Dperformanceprofilestore.dir=config/perf_profiles/ -Djdbcprofilestore.dir=config/jdbc_profiles -Dmemorytestprofilestore.dir=config/memory_profiles/ -Dots.server.bindname=value_1 -DCoordinatorEnvironmentBean.maintainHeuristics=NO -DRecoveryEnvironmentBean.recoveryBackoffPeriod=5 -DCoreEnvironmentBean.timeoutFactor=2 -DCoordinatorEnvironmentBean.defaultTimeout=240 -Demma.coverage.out.file=./testoutput/txcore_lockrecord/LockRecord_Thread_Test036a/emptyObjectStore-coverage.ec -DportOffsetId=2 -DObjectStoreBaseDir=/home/hudson/workspace/jbossts-branch417-EAP61-java6-jdbcobjectstore/qa/testoutput/txcore_lockrecord/LockRecord_Thread_Test036a/emptyObjectStore -DRecoveryEnvironmentBean.recoveryListener=true -DObjectStoreEnvironmentBean.objectStoreType=com.arjuna.ats.internal.arjuna.objectstore.jdbc.JDBCStore -DObjectStoreEnvironmentBean.jdbcAccess=com.arjuna.ats.internal.arjuna.objectstore.jdbc.accessors.DynamicDataSourceJDBCAccess;ClassName=com.mysql.jdbc.jdbc2.optional.MysqlDataSource;DatabaseName=jbossts;ServerName=tywin.buildnet.ncl.jboss.com;PortNumber=3306;User=dtf11;Password=dtf11 -DObjectStoreEnvironmentBean.tablePrefix=Action -DObjectStoreEnvironmentBean.stateStore.objectStoreType=com.arjuna.ats.internal.arjuna.objectstore.jdbc.JDBCStore -DObjectStoreEnvironmentBean.stateStore.jdbcAccess=com.arjuna.ats.internal.arjuna.objectstore.jdbc.accessors.DynamicDataSourceJDBCAccess;ClassName=com.mysql.jdbc.jdbc2.optional.MysqlDataSource;DatabaseName=jbossts;ServerName=tywin.buildnet.ncl.jboss.com;PortNumber=3306;User=dtf11;Password=dtf11 -DObjectStoreEnvironmentBean.stateStore.tablePrefix=stateStore -DObjectStoreEnvironmentBean.communicationStore.objectStoreType=com.arjuna.ats.internal.arjuna.objectstore.jdbc.JDBCStore -DObjectStoreEnvironmentBean.communicationStore.jdbcAccess=com.arjuna.ats.internal.arjuna.objectstore.jdbc.accessors.DynamicDataSourceJDBCAccess;ClassName=com.mysql.jdbc.jdbc2.optional.MysqlDataSource;DatabaseName=jbossts;ServerName=tywin.buildnet.ncl.jboss.com;PortNumber=3306;User=dtf11;Password=dtf11 -DObjectStoreEnvironmentBean.communicationStore.tablePrefix=Communication org.jboss.jbossts.qa.Utils.EmptyObjectStore
> Testcase: LockRecord_Thread_Test036a took 22.69 sec
> FAILED
> task client_0 printed Failed.
> junit.framework.AssertionFailedError: task client_0 printed Failed.
> at org.jboss.jbossts.qa.junit.TaskImpl$TaskReaderThread.checkPassFail(TaskImpl.java:671)
> at org.jboss.jbossts.qa.junit.TaskImpl.waitFor(TaskImpl.java:430)
> at org.jboss.jbossts.qa.junit.TestGroupBase.startAndWaitForClient(TestGroupBase.java:127)
> at org.jboss.jbossts.qa.junit.testgroup.TestGroup_txcore_lockrecord.LockRecord_Thread_Test036a(TestGroup_txcore_lockrecord.java:467)
> at org.jboss.jbossts.qa.junit.QATestNameRule$1.evaluate(QATestNameRule.java:89)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 2 months
[JBoss JIRA] (JBTM-1426) ORA-01000: maximum open cursors exceeded during oracle JDBC object store test
by Tom Jenkinson (JIRA)
[ https://issues.jboss.org/browse/JBTM-1426?page=com.atlassian.jira.plugin.... ]
Tom Jenkinson updated JBTM-1426:
--------------------------------
Status: Pull Request Sent (was: Open)
Git Pull Request: https://github.com/jbosstm/narayana/pull/196
> ORA-01000: maximum open cursors exceeded during oracle JDBC object store test
> -----------------------------------------------------------------------------
>
> Key: JBTM-1426
> URL: https://issues.jboss.org/browse/JBTM-1426
> Project: JBoss Transaction Manager
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Testing, Transaction Core
> Reporter: Gytis Trikleris
> Assignee: Tom Jenkinson
> Fix For: 4.17.4, 5.0.0.M2
>
>
> See: http://172.17.131.2/job/jbossts-EAP61-jdbcobjectstore/31
> {noformat}
> starting command: /usr/local/jdk1.6.0_37/bin/java -classpath dist/narayana-full-4.17.4.Final-SNAPSHOT/etc/:dist/narayana-full-4.17.4.Final-SNAPSHOT/lib/*:dist/narayana-full-4.17.4.Final-SNAPSHOT/lib/ext/*:dist/narayana-full-4.17.4.Final-SNAPSHOT/jacorb/lib/*:dist/narayana-full-4.17.4.Final-SNAPSHOT/jacorb/etc/:ext/fscontext.jar:ext/providerutil.jar:ext/jboss-profiler-jvmti.jar:ext/jboss-logging-spi.jar:tests/build/classes/:dbdrivers/selected_dbdriver/*:dbdrivers/DB2_v9.7/db2jcc.jar:dbdrivers/jConnect-6_0/classes/jconn3.jar:dbdrivers/mssql2005_sqljdbc_2.0/enu/sqljdbc4.jar:dbdrivers/mysql-connector-java-5.1.8-bin.jar:dbdrivers/oracle_10_2_0_4/ojdbc14.jar:dbdrivers/postgresql-8.3-605.jdbc4.jar:../build/extlib/emma.jar:../build/extlib/netty.jar -Dqa.debug=true -Djava.naming.provider.url=file:///tmp -Djava.naming.factory.initial=com.sun.jndi.fscontext.RefFSContextFactory -Dperformanceprofilestore.dir=config/perf_profiles/ -Djdbcprofilestore.dir=config/jdbc_profiles -Dmemorytestprofilestore.dir=config/memory_profiles/ -Dots.server.bindname=value_1 -DCoordinatorEnvironmentBean.maintainHeuristics=NO -DRecoveryEnvironmentBean.recoveryBackoffPeriod=5 -DCoreEnvironmentBean.timeoutFactor=2 -DCoordinatorEnvironmentBean.defaultTimeout=240 -Demma.coverage.out.file=./testoutput/txcore_lockrecord/LockRecord_Thread_Test028b/client_0-coverage.ec -DportOffsetId=1 -DObjectStoreBaseDir=/home/hudson/workspace/jbossts-EAP61-jdbcobjectstore/qa/testoutput/txcore_lockrecord/LockRecord_Thread_Test028b/client_0 -DRecoveryEnvironmentBean.recoveryListener=true -DObjectStoreEnvironmentBean.objectStoreType=com.arjuna.ats.internal.arjuna.objectstore.jdbc.JDBCStore -DObjectStoreEnvironmentBean.jdbcAccess=com.arjuna.ats.internal.arjuna.objectstore.jdbc.accessors.DynamicDataSourceJDBCAccess;ClassName=oracle.jdbc.pool.OracleDataSource;DriverType=thin;ServerName=tywin.buildnet.ncl.jboss.com;NetworkProtocol=tcp;DatabaseName=orcl;PortNumber=1521;User=dtf11;Password=dtf11 -DObjectStoreEnvironmentBean.tablePrefix=Action -DObjectStoreEnvironmentBean.stateStore.objectStoreType=com.arjuna.ats.internal.arjuna.objectstore.jdbc.JDBCStore -DObjectStoreEnvironmentBean.stateStore.jdbcAccess=com.arjuna.ats.internal.arjuna.objectstore.jdbc.accessors.DynamicDataSourceJDBCAccess;ClassName=oracle.jdbc.pool.OracleDataSource;DriverType=thin;ServerName=tywin.buildnet.ncl.jboss.com;NetworkProtocol=tcp;DatabaseName=orcl;PortNumber=1521;User=dtf11;Password=dtf11 -DObjectStoreEnvironmentBean.stateStore.tablePrefix=stateStore -DObjectStoreEnvironmentBean.communicationStore.objectStoreType=com.arjuna.ats.internal.arjuna.objectstore.jdbc.JDBCStore -DObjectStoreEnvironmentBean.communicationStore.jdbcAccess=com.arjuna.ats.internal.arjuna.objectstore.jdbc.accessors.DynamicDataSourceJDBCAccess;ClassName=oracle.jdbc.pool.OracleDataSource;DriverType=thin;ServerName=tywin.buildnet.ncl.jboss.com;NetworkProtocol=tcp;DatabaseName=orcl;PortNumber=1521;User=dtf11;Password=dtf11 -DObjectStoreEnvironmentBean.communicationStore.tablePrefix=Communication org.jboss.jbossts.qa.ArjunaCore.LockManager.client.WorkerClient003 -newlock 10 10 2
> 2013-01-11 06:42:48,696 err: log4j:WARN No appenders could be found for logger (org.jboss.logging).
> 2013-01-11 06:42:48,696 err: log4j:WARN Please initialize the log4j system properly.
> 2013-01-11 06:42:49,683 err: trying to get lock for 1000th time
> 2013-01-11 06:42:49,700 err: trying to get lock for 1000th time
> 2013-01-11 06:42:49,703 err: trying to get lock for 1000th time
> 2013-01-11 06:42:49,705 err: trying to get lock for 1000th time
> 2013-01-11 06:42:49,707 err: trying to get lock for 1000th time
> 2013-01-11 06:42:49,709 err: trying to get lock for 1000th time
> 2013-01-11 06:42:49,711 err: trying to get lock for 1000th time
> 2013-01-11 06:42:49,717 err: trying to get lock for 1000th time
> 2013-01-11 06:42:49,719 err: trying to get lock for 1000th time
> 2013-01-11 06:42:49,721 err: trying to get lock for 1000th time
> 2013-01-11 06:42:52,690 out: 2013-01-11 06:42:52,689 [Thread-1] WARN com.arjuna.ats.arjuna - ARJUNA012258: JDBCImple:write_state caught exception
> 2013-01-11 06:42:52,691 out: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
> 2013-01-11 06:42:52,691 out: ORA-01000: maximum open cursors exceeded
> 2013-01-11 06:42:52,691 out: ORA-00604: error occurred at recursive SQL level 1
> 2013-01-11 06:42:52,691 out: ORA-01000: maximum open cursors exceeded
> 2013-01-11 06:42:52,691 out: ORA-01000: maximum open cursors exceeded
> 2013-01-11 06:42:52,691 out:
> 2013-01-11 06:42:52,691 out: at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
> 2013-01-11 06:42:52,691 out: at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> 2013-01-11 06:42:52,691 out: at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> 2013-01-11 06:42:52,691 out: at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
> 2013-01-11 06:42:52,691 out: at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
> 2013-01-11 06:42:52,691 out: at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)
> 2013-01-11 06:42:52,691 out: at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
> 2013-01-11 06:42:52,691 out: at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
> 2013-01-11 06:42:52,691 out: at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3454)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.internal.arjuna.objectstore.jdbc.JDBCImple_driver.commit_state(JDBCImple_driver.java:104)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.internal.arjuna.objectstore.jdbc.JDBCStore.commit_state(JDBCStore.java:124)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.internal.arjuna.abstractrecords.PersistenceRecord.topLevelCommit(PersistenceRecord.java:171)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.arjuna.coordinator.BasicAction.doCommit(BasicAction.java:2733)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.arjuna.coordinator.BasicAction.doCommit(BasicAction.java:2649)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.arjuna.coordinator.BasicAction.phase2Commit(BasicAction.java:1814)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.arjuna.coordinator.BasicAction.End(BasicAction.java:1505)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:98)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:162)
> 2013-01-11 06:42:52,691 out: at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:147)
> 2013-01-11 06:42:52,691 out: at org.jboss.jbossts.qa.ArjunaCore.LockManager.client.Worker003.run(Worker003.java:65)
> ....
> {noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 2 months