|
| Here's what happens.
1. A backup is perfomed on iSeries using BRMS (with save while active set to *NO)
2. The scheduler runs and wants to access a file (SCHACTIVE for instance) that is being backed up, and therefore locked.
3. The scheduler throws an Exception (m.ibm.db2.jdbc.app.DB2DBException: Row or object SCHACTIVE in MYLIBRAY type *FILE in use)
4. Even after the backup is done, and the file is not locked, the scheduler continues to throw exceptions until the instance/server is restarted.:
[5/5/05 9:55:00:896 CDT] d2c2212c ConnectO A CONM6014I: Received exception (RollbackException) in method (enlist). Issuing new exception (TransactionAbortedException). The original exception's stack trace was: javax.transaction.RollbackException
java/lang/Throwable.<init>()V+4 (Throwable.java:73)
java/lang/Exception.<init>()V+1 (Exception.java:24)
com/ibm/ejs/jts/jta/TransactionImpl.registerSynchronization(Ljavax/transaction/Synchronization;)V+0 (TransactionImpl.java:971)
com/ibm/ejs/jts/jta/JTSXA.registerSynchronization(Lcom/ibm/ejs/jts/jts/UOWCoordinator;Ljavax/transaction/Synchronization;)V+0 (JTSXA.java:1081)
com/ibm/ejs/cm/pool/ConnectO.enlist(Lcom/ibm/ejs/jts/jts/UOWCoordinator;Z)V+0 (ConnectO.java:606)
com/ibm/ejs/cm/pool/ConnectO.allocate(Lcom/ibm/ejs/jts/jts/UOWCoordinator;)Z+0 (ConnectO.java:1262)
com/ibm/ejs/cm/pool/ConnectionPool.allocateConnForTransaction(Lcom/ibm/ejs/cm/pool/ConnectO;Lcom/ibm/ejs/jts/jts/UOWCoordinator;)V+0 (ConnectionPool.java:996)
com/ibm/ejs/cm/pool/ConnectionPool.findConnectionForTx(Lcom/ibm/ejs/jts/jts/UOWCoordinator;Ljava/lang/String;Ljava/lang/String;)Lcom/ibm/ejs/cm/pool/ConnectO;+0 (ConnectionPool.java:901)
com/ibm/ejs/cm/pool/ConnectionPool.allocateConnection(Ljava/lang/String;Ljava/lang/String;)Lcom/ibm/ejs/cm/pool/ConnectO;+0 (ConnectionPool.java:821)
com/ibm/ejs/cm/pool/ConnectionPool.getConnection(Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;+0 (ConnectionPool.java:368)
com/ibm/ejs/cm/DataSourceImpl$1.run()Ljava/lang/Object;+0 (DataSourceImpl.java:151)
com/ibm/ejs/cm/DataSourceImpl.getConnection(Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;+0 (DataSourceImpl.java:130)
com/ibm/ejs/cm/DataSourceImpl.getConnection()Ljava/sql/Connection;+0 (DataSourceImpl.java:113)
com/ibm/commerce/scheduler/SchedulerDataAccessObject.getDataSourceConnection()Ljava/sql/Connection;+0 (SchedulerDataAccessObject.java:212)
com/ibm/commerce/scheduler/SchedulerCheckForWork.processWaitingJobs()V+0 (SchedulerCheckForWork.java:139)
com/ibm/commerce/scheduler/SchedulerCheckForWork.process()V+0 (SchedulerCheckForWork.java:104)
com/ibm/commerce/scheduler/SchedulerSecurityPriviledgedAction.run()Ljava/lang/Object;+0 (SchedulerSecurityPriviledgedAction.java:58)
com/ibm/commerce/scheduler/SchedulerCheckForWork.run()V+0 (SchedulerCheckForWork.java:88)
[5/5/05 9:55:00:964 CDT] d2c2212c CommerceSrvr E com.ibm.commerce.scheduler.SchedulerCheckForWork processWaitingJobs() (unexpected error) CMN0409E: The following error occurred during processing: com.ibm.ejs.cm.exception.TransactionAbortedException: JTS/
JTA transaction has been aborted.com.ibm.ejs.cm.exception.TransactionAbortedException: JTS/JTA transaction has been aborted
java/lang/Throwable.<init>(Ljava/lang/String;)V+4 (Throwable.java:85)
java/lang/Exception.<init>(Ljava/lang/String;)V+1 (Exception.java:33)
java/sql/SQLException.<init>(Ljava/lang/String;)V+1 (SQLException.java:73)
com/ibm/websphere/ce/cm/PortableSQLException.<init>(Ljava/lang/String;)V+0 (PortableSQLException.java:50)
com/ibm/ejs/cm/portability/PortableSQLException.<init>(Ljava/lang/String;)V+0 (PortableSQLException.java:46)
com/ibm/ejs/cm/exception/TransactionAbortedException.<init>()V+0 (TransactionAbortedException.java:8)
com/ibm/ejs/cm/pool/ConnectO.enlist(Lcom/ibm/ejs/jts/jts/UOWCoordinator;Z)V+0 (ConnectO.java:606)
com/ibm/ejs/cm/pool/ConnectO.allocate(Lcom/ibm/ejs/jts/jts/UOWCoordinator;)Z+0 (ConnectO.java:1262)
com/ibm/ejs/cm/pool/ConnectionPool.allocateConnForTransaction(Lcom/ibm/ejs/cm/pool/ConnectO;Lcom/ibm/ejs/jts/jts/UOWCoordinator;)V+0 (ConnectionPool.java:996)
com/ibm/ejs/cm/pool/ConnectionPool.findConnectionForTx(Lcom/ibm/ejs/jts/jts/UOWCoordinator;Ljava/lang/String;Ljava/lang/String;)Lcom/ibm/ejs/cm/pool/ConnectO;+0 (ConnectionPool.java:901)
com/ibm/ejs/cm/pool/ConnectionPool.allocateConnection(Ljava/lang/String;Ljava/lang/String;)Lcom/ibm/ejs/cm/pool/ConnectO;+0 (ConnectionPool.java:821)
com/ibm/ejs/cm/pool/ConnectionPool.getConnection(Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;+0 (ConnectionPool.java:368)
com/ibm/ejs/cm/DataSourceImpl$1.run()Ljava/lang/Object;+0 (DataSourceImpl.java:151)
com/ibm/ejs/cm/DataSourceImpl.getConnection(Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;+0 (DataSourceImpl.java:130)
com/ibm/ejs/cm/DataSourceImpl.getConnection()Ljava/sql/Connection;+0 (DataSourceImpl.java:113)
com/ibm/commerce/scheduler/SchedulerDataAccessObject.getDataSourceConnection()Ljava/sql/Connection;+0 (SchedulerDataAccessObject.java:212)
com/ibm/commerce/scheduler/SchedulerCheckForWork.processWaitingJobs()V+0 (SchedulerCheckForWork.java:139)
com/ibm/commerce/scheduler/SchedulerCheckForWork.process()V+0 (SchedulerCheckForWork.java:104)
com/ibm/commerce/scheduler/SchedulerSecurityPriviledgedAction.run()Ljava/lang/Object;+0 (SchedulerSecurityPriviledgedAction.java:58)
com/ibm/commerce/scheduler/SchedulerCheckForWork.run()V+0 (SchedulerCheckForWork.java:88)
|
|