Details
-
Type:
Bug
-
Status: Resolved
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: Link Score Report
-
Fix Version/s: Link Score Report
-
Component/s: Linking Report
-
Labels:None
-
Environment:
All (found in dev)
Description
Large request of approx 4000+ scanned pages encounter a transaction rollback likely due to the length of time required to read all of the report metrics out of the database. This needs to be broken into smaller transactions.
======================================
2010-08-19 17:34:15,851 INFO [com.thesearchagency.service.linkscore.util.manager.LinkScoreReportManager] (WorkManager(2)-19) writing of report (4749)complete.
2010-08-19 17:34:15,851 INFO [com.thesearchagency.service.linkscore.util.manager.LinkScoreReportManager] (WorkManager(2)-19) CSV Report Path :: /usr/local/jboss-5.1.0.GA/server/default/deploy/ROOT.war/users/226/linkscore_reports/4749.csv
2010-08-19 17:34:15,851 INFO [com.thesearchagency.service.linkscore.util.manager.LinkScoreReportManager] (WorkManager(2)-19) CSV Report URL :: http://dev-jboss5.ri.thesearchagency.com:8080/users/226/linkscore_reports/4749.csv
2010-08-19 17:34:15,853 INFO [com.thesearchagency.service.linkscore.util.ServiceLocator] (WorkManager(2)-19) Inside getLinkScoreReportDS() method...
2010-08-19 17:34:15,897 WARN [com.arjuna.ats.arjuna.logging.arjLoggerI18N] (WorkManager(2)-19) [com.arjuna.ats.arjuna.coordinator.BasicAction_40] - Abort called on already aborted atomic action 7f000001:ae18:4c6d8b89:3b808a
2010-08-19 17:34:15,902 ERROR [STDERR] (WorkManager(2)-19) javax.ejb.EJBTransactionRolledbackException: Transaction rolled back
2010-08-19 17:34:15,904 ERROR [STDERR] (WorkManager(2)-19) at org.jboss.ejb3.tx.Ejb3TxPolicy.handleEndTransactionException(Ejb3TxPolicy.java:54)
2010-08-19 17:34:15,904 ERROR [STDERR] (WorkManager(2)-19) at org.jboss.aspects.tx.TxPolicy.endTransaction(TxPolicy.java:175)
2010-08-19 17:34:15,904 ERROR [STDERR] (WorkManager(2)-19) at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:87)
2010-08-19 17:34:15,904 ERROR [STDERR] (WorkManager(2)-19) at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:190)
2010-08-19 17:34:15,904 ERROR [STDERR] (WorkManager(2)-19) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
2010-08-19 17:34:15,904 ERROR [STDERR] (WorkManager(2)-19) at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
2010-08-19 17:34:15,904 ERROR [STDERR] (WorkManager(2)-19) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
2010-08-19 17:34:15,904 ERROR [STDERR] (WorkManager(2)-19) at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)
2010-08-19 17:34:15,904 ERROR [STDERR] (WorkManager(2)-19) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
2010-08-19 17:34:15,904 ERROR [STDERR] (WorkManager(2)-19) at org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(Ejb3AuthenticationInterceptorv2.java:186)
2010-08-19 17:34:15,904 ERROR [STDERR] (WorkManager(2)-19) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
2010-08-19 17:34:15,904 ERROR [STDERR] (WorkManager(2)-19) at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:41)
2010-08-19 17:34:15,904 ERROR [STDERR] (WorkManager(2)-19) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
2010-08-19 17:34:15,904 ERROR [STDERR] (WorkManager(2)-19) at org.jboss.ejb3.BlockContainerShutdownInterceptor.invoke(BlockContainerShutdownInterceptor.java:67)
2010-08-19 17:34:15,904 ERROR [STDERR] (WorkManager(2)-19) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
2010-08-19 17:34:15,905 ERROR [STDERR] (WorkManager(2)-19) at org.jboss.aspects.currentinvocation.CurrentInvocationInterceptor.invoke(CurrentInvocationInterceptor.java:67)
2010-08-19 17:34:15,905 ERROR [STDERR] (WorkManager(2)-19) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
2010-08-19 17:34:15,905 ERROR [STDERR] (WorkManager(2)-19) at org.jboss.ejb3.session.SessionSpecContainer.invoke(SessionSpecContainer.java:176)
2010-08-19 17:34:15,905 ERROR [STDERR] (WorkManager(2)-19) at org.jboss.ejb3.session.SessionSpecContainer.invoke(SessionSpecContainer.java:216)
2010-08-19 17:34:15,905 ERROR [STDERR] (WorkManager(2)-19) at org.jboss.ejb3.proxy.impl.handler.session.SessionProxyInvocationHandlerBase.invoke(SessionProxyInvocationHandlerBase.java:207)
2010-08-19 17:34:15,905 ERROR [STDERR] (WorkManager(2)-19) at org.jboss.ejb3.proxy.impl.handler.session.SessionProxyInvocationHandlerBase.invoke(SessionProxyInvocationHandlerBase.java:164)
2010-08-19 17:34:15,905 ERROR [STDERR] (WorkManager(2)-19) at $Proxy660.writeCSVReport(Unknown Source)
2010-08-19 17:34:15,905 ERROR [STDERR] (WorkManager(2)-19) at com.thesearchagency.service.linkscore.mdb.LinkScoreWorkerListener.handleStatusUpdate(LinkScoreWorkerListener.java:107)
2010-08-19 17:34:15,905 ERROR [STDERR] (WorkManager(2)-19) at com.thesearchagency.service.linkscore.mdb.LinkScoreWorkerListener.onMessage(LinkScoreWorkerListener.java:73)
2010-08-19 17:34:15,905 ERROR [STDERR] (WorkManager(2)-19) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
