Hi all,
we are having a startup problem with Jetspeed 2.2.1 on AIX using DB2 as
Backend. The portal starts with 3 PAs and it seems that during
re-registration of the PAs we have a DB lock problem.
Does anybody experienced the same, can point us to the area to look at
or has a similar setup and can share some information?
I am attaching a stack strace and a screenshot of the database log.
Thanks in advance for any help!
Joachim
[07.06.11 13:46:04:207 CEST] 00000020 SystemErr R
org.springframework.dao.ConcurrencyFailureException: OJB operation; SQL []; DB2
SQL Error: SQLCODE=-911, SQLSTATE=40001, SQLERRMC=68, DRIVER=3.59.81; nested
exception is com.ibm.db2.jcc.am.SqlTransactionRollbackException: DB2 SQL Error:
SQLCODE=-911, SQLSTATE=40001, SQLERRMC=68, DRIVER=3.59.81
[07.06.11 13:46:04:208 CEST] 00000020 SystemErr R at
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:109)
[07.06.11 13:46:04:208 CEST] 00000020 SystemErr R at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
[07.06.11 13:46:04:208 CEST] 00000020 SystemErr R at
org.springframework.orm.ojb.OjbAccessor.convertJdbcAccessException(OjbAccessor.java:107)
[07.06.11 13:46:04:208 CEST] 00000020 SystemErr R at
org.springframework.orm.ojb.OjbAccessor.convertOjbAccessException(OjbAccessor.java:89)
[07.06.11 13:46:04:208 CEST] 00000020 SystemErr R at
org.springframework.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:141)
[07.06.11 13:46:04:208 CEST] 00000020 SystemErr R at
org.springframework.orm.ojb.PersistenceBrokerTemplate.getObjectByQuery(PersistenceBrokerTemplate.java:182)
[07.06.11 13:46:04:208 CEST] 00000020 SystemErr R at
org.apache.jetspeed.components.portletregistry.PersistenceBrokerPortletRegistry.getPortletDefinitionByUniqueName(PersistenceBrokerPortletRegistry.java:177)
[07.06.11 13:46:04:208 CEST] 00000020 SystemErr R at
org.apache.jetspeed.components.portletregistry.PersistenceBrokerPortletRegistry.getPortletDefinitionByUniqueName(PersistenceBrokerPortletRegistry.java:154)
[07.06.11 13:46:04:208 CEST] 00000020 SystemErr R at
org.apache.jetspeed.components.portletregistry.PersistenceBrokerPortletRegistry.notifyElementRemoved(PersistenceBrokerPortletRegistry.java:312)
[07.06.11 13:46:04:209 CEST] 00000020 SystemErr R at
org.apache.jetspeed.cache.impl.EhCacheDistributedImpl.notifyListeners(EhCacheDistributedImpl.java:215)
[07.06.11 13:46:04:209 CEST] 00000020 SystemErr R at
org.apache.jetspeed.cache.impl.EhCacheDistributedImpl.notifyElement(EhCacheDistributedImpl.java:254)
[07.06.11 13:46:04:209 CEST] 00000020 SystemErr R at
org.apache.jetspeed.cache.impl.EhCacheDistributedImpl.notifyElementRemoved(EhCacheDistributedImpl.java:281)
[07.06.11 13:46:04:209 CEST] 00000020 SystemErr R at
net.sf.ehcache.event.RegisteredEventListeners.notifyElementRemoved(RegisteredEventListeners.java:77)
[07.06.11 13:46:04:209 CEST] 00000020 SystemErr R at
net.sf.ehcache.Cache.remove(Cache.java:1550)
[07.06.11 13:46:04:209 CEST] 00000020 SystemErr R at
net.sf.ehcache.Cache.remove(Cache.java:1463)
[07.06.11 13:46:04:209 CEST] 00000020 SystemErr R at
net.sf.ehcache.Cache.remove(Cache.java:1421)
[07.06.11 13:46:04:209 CEST] 00000020 SystemErr R at
net.sf.ehcache.Cache.remove(Cache.java:1399)
[07.06.11 13:46:04:209 CEST] 00000020 SystemErr R at
org.apache.jetspeed.cache.impl.EhCacheDistributedImpl.remove(EhCacheDistributedImpl.java:123)
[07.06.11 13:46:04:209 CEST] 00000020 SystemErr R at
org.apache.jetspeed.cache.impl.EhCacheDistributedImpl.remove(EhCacheDistributedImpl.java:114)
[07.06.11 13:46:04:209 CEST] 00000020 SystemErr R at
org.apache.jetspeed.components.portletregistry.RegistryPortletCache.cacheRemove(RegistryPortletCache.java:134)
[07.06.11 13:46:04:209 CEST] 00000020 SystemErr R at
org.apache.jetspeed.components.portletregistry.RegistryPortletCache.remove(RegistryPortletCache.java:118)
[07.06.11 13:46:04:209 CEST] 00000020 SystemErr R at
org.apache.ojb.broker.cache.CacheDistributor$ObjectCacheInternalWrapper.remove(CacheDistributor.java:412)
[07.06.11 13:46:04:210 CEST] 00000020 SystemErr R at
org.apache.ojb.broker.cache.CacheDistributor.remove(CacheDistributor.java:121)
[07.06.11 13:46:04:210 CEST] 00000020 SystemErr R at
org.apache.ojb.broker.cache.MaterializationCache.remove(MaterializationCache.java:157)
[07.06.11 13:46:04:210 CEST] 00000020 SystemErr R at
org.apache.ojb.broker.core.PersistenceBrokerImpl.doDelete(PersistenceBrokerImpl.java:546)
[07.06.11 13:46:04:210 CEST] 00000020 SystemErr R at
org.apache.ojb.broker.core.PersistenceBrokerImpl.deleteCollections(PersistenceBrokerImpl.java:692)
[07.06.11 13:46:04:210 CEST] 00000020 SystemErr R at
org.apache.ojb.broker.core.PersistenceBrokerImpl.doDelete(PersistenceBrokerImpl.java:523)
[07.06.11 13:46:04:210 CEST] 00000020 SystemErr R at
org.apache.ojb.broker.core.PersistenceBrokerImpl.delete(PersistenceBrokerImpl.java:475)
[07.06.11 13:46:04:210 CEST] 00000020 SystemErr R at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.delete(DelegatingPersistenceBroker.java:170)
[07.06.11 13:46:04:210 CEST] 00000020 SystemErr R at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.delete(DelegatingPersistenceBroker.java:170)
[07.06.11 13:46:04:210 CEST] 00000020 SystemErr R at
org.springframework.orm.ojb.PersistenceBrokerTemplate$10.doInPersistenceBroker(PersistenceBrokerTemplate.java:252)
[07.06.11 13:46:04:210 CEST] 00000020 SystemErr R at
org.springframework.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:138)
[07.06.11 13:46:04:210 CEST] 00000020 SystemErr R at
org.springframework.orm.ojb.PersistenceBrokerTemplate.delete(PersistenceBrokerTemplate.java:250)
[07.06.11 13:46:04:210 CEST] 00000020 SystemErr R at
org.apache.jetspeed.components.portletregistry.PersistenceBrokerPortletRegistry.removeApplication(PersistenceBrokerPortletRegistry.java:207)
[07.06.11 13:46:04:210 CEST] 00000020 SystemErr R at
sun.reflect.GeneratedMethodAccessor80.invoke(Unknown Source)
[07.06.11 13:46:04:210 CEST] 00000020 SystemErr R at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[07.06.11 13:46:04:210 CEST] 00000020 SystemErr R at
java.lang.reflect.Method.invoke(Method.java:618)
[07.06.11 13:46:04:210 CEST] 00000020 SystemErr R at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
[07.06.11 13:46:04:210 CEST] 00000020 SystemErr R at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
[07.06.11 13:46:04:211 CEST] 00000020 SystemErr R at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
[07.06.11 13:46:04:211 CEST] 00000020 SystemErr R at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
[07.06.11 13:46:04:211 CEST] 00000020 SystemErr R at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
[07.06.11 13:46:04:211 CEST] 00000020 SystemErr R at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
[07.06.11 13:46:04:211 CEST] 00000020 SystemErr R at
$Proxy11.removeApplication(Unknown Source)
[07.06.11 13:46:04:211 CEST] 00000020 SystemErr R at
org.apache.jetspeed.tools.pamanager.PortletApplicationManager.unregisterPortletApplication(PortletApplicationManager.java:743)
[07.06.11 13:46:04:211 CEST] 00000020 SystemErr R at
org.apache.jetspeed.tools.pamanager.PortletApplicationManager.registerPortletApplication(PortletApplicationManager.java:424)
[07.06.11 13:46:04:211 CEST] 00000020 SystemErr R at
org.apache.jetspeed.tools.pamanager.PortletApplicationManager.attemptStartPA(PortletApplicationManager.java:530)
[07.06.11 13:46:04:211 CEST] 00000020 SystemErr R at
org.apache.jetspeed.tools.pamanager.PortletApplicationManager.tryStartPortletApplication(PortletApplicationManager.java:244)
[07.06.11 13:46:04:211 CEST] 00000020 SystemErr R at
sun.reflect.GeneratedMethodAccessor76.invoke(Unknown Source)
[07.06.11 13:46:04:211 CEST] 00000020 SystemErr R at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[07.06.11 13:46:04:211 CEST] 00000020 SystemErr R at
java.lang.reflect.Method.invoke(Method.java:618)
[07.06.11 13:46:04:211 CEST] 00000020 SystemErr R at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
[07.06.11 13:46:04:211 CEST] 00000020 SystemErr R at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
[07.06.11 13:46:04:211 CEST] 00000020 SystemErr R at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
[07.06.11 13:46:04:211 CEST] 00000020 SystemErr R at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
[07.06.11 13:46:04:212 CEST] 00000020 SystemErr R at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
[07.06.11 13:46:04:212 CEST] 00000020 SystemErr R at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
[07.06.11 13:46:04:212 CEST] 00000020 SystemErr R at
$Proxy14.tryStartPortletApplication(Unknown Source)
[07.06.11 13:46:04:212 CEST] 00000020 SystemErr R at
org.apache.jetspeed.tools.pamanager.PortletApplicationManager.retryStartPortletApplication(PortletApplicationManager.java:214)
[07.06.11 13:46:04:212 CEST] 00000020 SystemErr R at
org.apache.jetspeed.tools.pamanager.PortletApplicationManager.startPortletApplication(PortletApplicationManager.java:195)
[07.06.11 13:46:04:212 CEST] 00000020 SystemErr R at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[07.06.11 13:46:04:212 CEST] 00000020 SystemErr R at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
[07.06.11 13:46:04:212 CEST] 00000020 SystemErr R at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[07.06.11 13:46:04:212 CEST] 00000020 SystemErr R at
java.lang.reflect.Method.invoke(Method.java:618)
[07.06.11 13:46:04:212 CEST] 00000020 SystemErr R at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
[07.06.11 13:46:04:212 CEST] 00000020 SystemErr R at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
[07.06.11 13:46:04:212 CEST] 00000020 SystemErr R at
$Proxy14.startPortletApplication(Unknown Source)
[07.06.11 13:46:04:212 CEST] 00000020 SystemErr R at
org.apache.jetspeed.container.JetspeedContainerServlet.attemptStart(JetspeedContainerServlet.java:207)
[07.06.11 13:46:04:212 CEST] 00000020 SystemErr R at
org.apache.jetspeed.container.JetspeedContainerServlet$1.run(JetspeedContainerServlet.java:173)
[07.06.11 13:46:04:213 CEST] 00000020 SystemErr R at
java.util.TimerThread.mainLoop(Timer.java:537)
[07.06.11 13:46:04:213 CEST] 00000020 SystemErr R at
java.util.TimerThread.run(Timer.java:487)
[07.06.11 13:46:04:213 CEST] 00000020 SystemErr R Caused by:
com.ibm.db2.jcc.am.SqlTransactionRollbackException: DB2 SQL Error:
SQLCODE=-911, SQLSTATE=40001, SQLERRMC=68, DRIVER=3.59.81
at com.ibm.db2.jcc.am.dd.a(dd.java:663)
at com.ibm.db2.jcc.am.dd.a(dd.java:60)
at com.ibm.db2.jcc.am.dd.a(dd.java:127)
at com.ibm.db2.jcc.am.qm.b(qm.java:3900)
at com.ibm.db2.jcc.t4.db.h(db.java:281)
at com.ibm.db2.jcc.t4.db.a(db.java:242)
at com.ibm.db2.jcc.t4.db.c(db.java:31)
at com.ibm.db2.jcc.t4.r.a(r.java:32)
at com.ibm.db2.jcc.t4.j.Zb(j.java:259)
at com.ibm.db2.jcc.am.qm.X(qm.java:3692)
at com.ibm.db2.jcc.t4.d.f(d.java:1885)
at com.ibm.db2.jcc.am.gc.a(gc.java:200)
at com.ibm.db2.jcc.t4.d.a(d.java:111)
at com.ibm.db2.jcc.am.qm.c(qm.java:377)
at com.ibm.db2.jcc.am.qm.next(qm.java:304)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.next(WSJdbcResultSet.java:2509)
at
org.apache.ojb.broker.accesslayer.RsIterator.hasNext(RsIterator.java:230)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(PersistenceBrokerImpl.java:1634)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(DelegatingPersistenceBroker.java:307)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(DelegatingPersistenceBroker.java:307)
at
org.springframework.orm.ojb.PersistenceBrokerTemplate$2.doInPersistenceBroker(PersistenceBrokerTemplate.java:184)
at
org.springframework.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:138)
at
org.springframework.orm.ojb.PersistenceBrokerTemplate.getObjectByQuery(PersistenceBrokerTemplate.java:182)
at
org.apache.jetspeed.components.portletregistry.PersistenceBrokerPortletRegistry.getPortletDefinitionByUniqueName(PersistenceBrokerPortletRegistry.java:177)
at
org.apache.jetspeed.components.portletregistry.PersistenceBrokerPortletRegistry.getPortletDefinitionByUniqueName(PersistenceBrokerPortletRegistry.java:154)
at
org.apache.jetspeed.components.portletregistry.PersistenceBrokerPortletRegistry.notifyElementRemoved(PersistenceBrokerPortletRegistry.java:312)
at
org.apache.jetspeed.cache.impl.EhCacheDistributedImpl.notifyListeners(EhCacheDistributedImpl.java:215)
at
org.apache.jetspeed.cache.impl.EhCacheDistributedImpl.notifyElement(EhCacheDistributedImpl.java:254)
at
org.apache.jetspeed.cache.impl.EhCacheDistributedImpl.notifyElementRemoved(EhCacheDistributedImpl.java:281)
at
net.sf.ehcache.event.RegisteredEventListeners.notifyElementRemoved(RegisteredEventListeners.java:77)
at net.sf.ehcache.Cache.remove(Cache.java:1550)
at net.sf.ehcache.Cache.remove(Cache.java:1463)
at net.sf.ehcache.Cache.remove(Cache.java:1421)
at net.sf.ehcache.Cache.remove(Cache.java:1399)
at
org.apache.jetspeed.cache.impl.EhCacheDistributedImpl.remove(EhCacheDistributedImpl.java:123)
at
org.apache.jetspeed.cache.impl.EhCacheDistributedImpl.remove(EhCacheDistributedImpl.java:114)
at
org.apache.jetspeed.components.portletregistry.RegistryPortletCache.cacheRemove(RegistryPortletCache.java:134)
at
org.apache.jetspeed.components.portletregistry.RegistryPortletCache.remove(RegistryPortletCache.java:118)
at
org.apache.ojb.broker.cache.CacheDistributor$ObjectCacheInternalWrapper.remove(CacheDistributor.java:412)
at
org.apache.ojb.broker.cache.CacheDistributor.remove(CacheDistributor.java:121)
at
org.apache.ojb.broker.cache.MaterializationCache.remove(MaterializationCache.java:157)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.doDelete(PersistenceBrokerImpl.java:546)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.deleteCollections(PersistenceBrokerImpl.java:692)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.doDelete(PersistenceBrokerImpl.java:523)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.delete(PersistenceBrokerImpl.java:475)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.delete(DelegatingPersistenceBroker.java:170)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.delete(DelegatingPersistenceBroker.java:170)
at
org.springframework.orm.ojb.PersistenceBrokerTemplate$10.doInPersistenceBroker(PersistenceBrokerTemplate.java:252)
at
org.springframework.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:138)
at
org.springframework.orm.ojb.PersistenceBrokerTemplate.delete(PersistenceBrokerTemplate.java:250)
at
org.apache.jetspeed.components.portletregistry.PersistenceBrokerPortletRegistry.removeApplication(PersistenceBrokerPortletRegistry.java:207)
at sun.reflect.GeneratedMethodAccessor80.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy11.removeApplication(Unknown Source)
at
org.apache.jetspeed.tools.pamanager.PortletApplicationManager.unregisterPortletApplication(PortletApplicationManager.java:743)
at
org.apache.jetspeed.tools.pamanager.PortletApplicationManager.registerPortletApplication(PortletApplicationManager.java:424)
at
org.apache.jetspeed.tools.pamanager.PortletApplicationManager.attemptStartPA(PortletApplicationManager.java:530)
at
org.apache.jetspeed.tools.pamanager.PortletApplicationManager.tryStartPortletApplication(PortletApplicationManager.java:244)
at sun.reflect.GeneratedMethodAccessor76.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy14.tryStartPortletApplication(Unknown Source)
at
org.apache.jetspeed.tools.pamanager.PortletApplicationManager.retryStartPortletApplication(PortletApplicationManager.java:214)
at
org.apache.jetspeed.tools.pamanager.PortletApplicationManager.startPortletApplication(PortletApplicationManager.java:195)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
at $Proxy14.startPortletApplication(Unknown Source)
at
org.apache.jetspeed.container.JetspeedContainerServlet.attemptStart(JetspeedContainerServlet.java:207)
at
org.apache.jetspeed.container.JetspeedContainerServlet$1.run(JetspeedContainerServlet.java:173)
at java.util.TimerThread.mainLoop(Timer.java:537)
at java.util.TimerThread.run(Timer.java:487)
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscr...@portals.apache.org
For additional commands, e-mail: jetspeed-user-h...@portals.apache.org
