Hi,
As suggested I enabled debugging on Camel JPA component. Now I am able to
see problem. My question here is why it is applying exclusive lock as part
of slection
2014-07-06 18:58:33,759 INFO [org.apache.camel.component.jpa.JpaComponent]
(ServerService Thread Pool -- 122) Using EntityManagerFactory configured:
org.springframework.orm.jpa.LocalEntityManagerFactoryBean@44ef36
2014-07-06 18:58:33,760 INFO [org.apache.camel.component.jpa.JpaComponent]
(ServerService Thread Pool -- 122) Using TransactionManager configured on
this component: org.springframework.orm.jpa.JpaTransactionManager@1b4ef80
2014-07-06 18:58:33,875 DEBUG [org.apache.camel.component.jpa.JpaConsumer]
(ServerService Thread Pool -- 122) Starting consumer:
Consumer[jpa://com.test.persistence.entity.StatusCodeMappings?consumer.delay=50000&consumer.namedQuery=StatusCodeMappings.findAll]
2014-07-06 18:58:33,907 DEBUG
[com.nielsen.engineering.mediaworks.example.jee6.lib.bean.OpsConsoleBridgeMappings]
(ServerService Thread Pool -- 122) Loading mappings....
2014-07-06 18:58:33,908 DEBUG
[com.nielsen.engineering.mediaworks.example.jee6.lib.persistence.OpsConsoleServiceDaoImpl]
(ServerService Thread Pool -- 122) getting the Job code mappings list
2014-07-06 18:58:33,927 DEBUG
[com.nielsen.engineering.mediaworks.example.jee6.lib.persistence.OpsConsoleServiceDaoImpl]
(ServerService Thread Pool -- 122) getting the parameter code mappings list
2014-07-06 18:58:33,928 DEBUG
[com.nielsen.engineering.mediaworks.example.jee6.lib.persistence.OpsConsoleServiceDaoImpl]
(ServerService Thread Pool -- 122) getting the status code mappings list
2014-07-06 18:58:34,928 DEBUG [org.apache.camel.component.jpa.JpaConsumer]
(Camel (OpsCamelContext) thread #10 -
jpa://com.test.persistence.entity.StatusCodeMappings) Acquiring exclusive
lock on entity: StatusCodeMappings [statusCodeId=101,
alertName=GRMDataLoadingRate, severity=1, statusCode=8]
2014-07-06 18:58:34,929 DEBUG [org.apache.camel.component.jpa.JpaConsumer]
(Camel (OpsCamelContext) thread #10 -
jpa://com.test.persistence.entity.StatusCodeMappings) Failed to achieve lock
on entity: StatusCodeMappings [statusCodeId=101,
alertName=GRMDataLoadingRate, severity=1, statusCode=8]. Reason:
javax.persistence.PersistenceException: org.hibernate.HibernateException:
[OPTIMISTIC_FORCE_INCREMENT] not supported for non-versioned entities
[com.test.persistence.entity.StatusCodeMappings]:
javax.persistence.PersistenceException: org.hibernate.HibernateException:
[OPTIMISTIC_FORCE_INCREMENT] not supported for non-versioned entities
[com.test.persistence.entity.StatusCodeMappings]
at
org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
[hibernate-entitymanager-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1]
at
org.hibernate.ejb.AbstractEntityManagerImpl.lock(AbstractEntityManagerImpl.java:1120)
[hibernate-entitymanager-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1]
at
org.hibernate.ejb.AbstractEntityManagerImpl.lock(AbstractEntityManagerImpl.java:1103)
[hibernate-entitymanager-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1]
at sun.reflect.GeneratedMethodAccessor100.invoke(Unknown Source)
[:1.7.0_51]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.7.0_51]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_51]
at
org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:365)
[spring-orm-3.0.7.RELEASE.jar:3.0.7.RELEASE]
at com.sun.proxy.$Proxy271.lock(Unknown Source)
at
org.apache.camel.component.jpa.JpaConsumer.lockEntity(JpaConsumer.java:285)
[camel-jpa-2.12.2.jar:2.12.2]
at
org.apache.camel.component.jpa.JpaConsumer.processBatch(JpaConsumer.java:157)
[camel-jpa-2.12.2.jar:2.12.2]
at
org.apache.camel.component.jpa.JpaConsumer$1.doInTransaction(JpaConsumer.java:104)
[camel-jpa-2.12.2.jar:2.12.2]
at
org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
[spring-tx-3.0.7.RELEASE.jar:3.0.7.RELEASE]
at org.apache.camel.component.jpa.JpaConsumer.poll(JpaConsumer.java:80)
[camel-jpa-2.12.2.jar:2.12.2]
at
org.apache.camel.impl.ScheduledPollConsumer.doRun(ScheduledPollConsumer.java:187)
[camel-core-2.12.2.jar:2.12.2]
at
org.apache.camel.impl.ScheduledPollConsumer.run(ScheduledPollConsumer.java:114)
[camel-core-2.12.2.jar:2.12.2]
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
[rt.jar:1.7.0_51]
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304)
[rt.jar:1.7.0_51]
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178)
[rt.jar:1.7.0_51]
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
[rt.jar:1.7.0_51]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[rt.jar:1.7.0_51]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[rt.jar:1.7.0_51]
at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]
Caused by: org.hibernate.HibernateException: [OPTIMISTIC_FORCE_INCREMENT]
not supported for non-versioned entities
[com.test.persistence.entity.StatusCodeMappings]
at
org.hibernate.dialect.lock.OptimisticForceIncrementLockingStrategy.lock(OptimisticForceIncrementLockingStrategy.java:66)
[hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1]
at
org.hibernate.persister.entity.AbstractEntityPersister.lock(AbstractEntityPersister.java:1944)
[hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1]
at
org.hibernate.event.internal.AbstractLockUpgradeEventListener.upgradeLock(AbstractLockUpgradeEventListener.java:99)
[hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1]
at
org.hibernate.event.internal.DefaultLockEventListener.onLock(DefaultLockEventListener.java:85)
[hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1]
at org.hibernate.internal.SessionImpl.fireLock(SessionImpl.java:818)
[hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1]
at org.hibernate.internal.SessionImpl.fireLock(SessionImpl.java:811)
[hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1]
at org.hibernate.internal.SessionImpl.access$1800(SessionImpl.java:175)
[hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1]
at
org.hibernate.internal.SessionImpl$LockRequestImpl.lock(SessionImpl.java:2416)
[hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1]
at
org.hibernate.ejb.AbstractEntityManagerImpl.lock(AbstractEntityManagerImpl.java:1117)
[hibernate-entitymanager-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1]
... 20 more
2014-07-06 18:58:34,933 DEBUG [org.apache.camel.component.jpa.JpaConsumer]
(Camel (OpsCamelContext) thread #10 -
jpa://com.test.persistence.entity.StatusCodeMappings) Acquiring exclusive
lock on entity: StatusCodeMappings [statusCodeId=102,
alertName=GRMDataLoadingRate, severity=2, statusCode=8]
2014-07-06 18:58:34,933 DEBUG [org.apache.camel.component.jpa.JpaConsumer]
(Camel (OpsCamelContext) thread #10 -
jpa://com.test.persistence.entity.StatusCodeMappings) Failed to achieve lock
on entity: StatusCodeMappings [statusCodeId=102,
alertName=GRMDataLoadingRate, severity=2, statusCode=8]. Reason:
javax.persistence.PersistenceException: org.hibernate.HibernateException:
[OPTIMISTIC_FORCE_INCREMENT] not supported for non-versioned entities
[com.test.persistence.entity.StatusCodeMappings]:
javax.persistence.PersistenceException: org.hibernate.HibernateException:
[OPTIMISTIC_FORCE_INCREMENT] not supported for non-versioned entities
[com.test.persistence.entity.StatusCodeMappings]
at
org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
[hibernate-entitymanager-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1]
at
org.hibernate.ejb.AbstractEntityManagerImpl.lock(AbstractEntityManagerImpl.java:1120)
[hibernate-entitymanager-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1]
at
org.hibernate.ejb.AbstractEntityManagerImpl.lock(AbstractEntityManagerImpl.java:1103)
[hibernate-entitymanager-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1]
at sun.reflect.GeneratedMethodAccessor100.invoke(Unknown Source)
[:1.7.0_51]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.7.0_51]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_51]
at
org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:365)
[spring-orm-3.0.7.RELEASE.jar:3.0.7.RELEASE]
at com.sun.proxy.$Proxy271.lock(Unknown Source)
at
org.apache.camel.component.jpa.JpaConsumer.lockEntity(JpaConsumer.java:285)
[camel-jpa-2.12.2.jar:2.12.2]
at
org.apache.camel.component.jpa.JpaConsumer.processBatch(JpaConsumer.java:157)
[camel-jpa-2.12.2.jar:2.12.2]
at
org.apache.camel.component.jpa.JpaConsumer$1.doInTransaction(JpaConsumer.java:104)
[camel-jpa-2.12.2.jar:2.12.2]
at
org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
[spring-tx-3.0.7.RELEASE.jar:3.0.7.RELEASE]
at org.apache.camel.component.jpa.JpaConsumer.poll(JpaConsumer.java:80)
[camel-jpa-2.12.2.jar:2.12.2]
at
org.apache.camel.impl.ScheduledPollConsumer.doRun(ScheduledPollConsumer.java:187)
[camel-core-2.12.2.jar:2.12.2]
at
org.apache.camel.impl.ScheduledPollConsumer.run(ScheduledPollConsumer.java:114)
[camel-core-2.12.2.jar:2.12.2]
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
[rt.jar:1.7.0_51]
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304)
[rt.jar:1.7.0_51]
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178)
[rt.jar:1.7.0_51]
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
[rt.jar:1.7.0_51]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[rt.jar:1.7.0_51]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[rt.jar:1.7.0_51]
at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]
Caused by: org.hibernate.HibernateException: [OPTIMISTIC_FORCE_INCREMENT]
not supported for non-versioned entities
[com.test.persistence.entity.StatusCodeMappings]
at
org.hibernate.dialect.lock.OptimisticForceIncrementLockingStrategy.lock(OptimisticForceIncrementLockingStrategy.java:66)
[hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1]
at
org.hibernate.persister.entity.AbstractEntityPersister.lock(AbstractEntityPersister.java:1944)
[hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1]
at
org.hibernate.event.internal.AbstractLockUpgradeEventListener.upgradeLock(AbstractLockUpgradeEventListener.java:99)
[hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1]
at
org.hibernate.event.internal.DefaultLockEventListener.onLock(DefaultLockEventListener.java:85)
[hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1]
at org.hibernate.internal.SessionImpl.fireLock(SessionImpl.java:818)
[hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1]
at org.hibernate.internal.SessionImpl.fireLock(SessionImpl.java:811)
[hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1]
at org.hibernate.internal.SessionImpl.access$1800(SessionImpl.java:175)
[hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1]
at
org.hibernate.internal.SessionImpl$LockRequestImpl.lock(SessionImpl.java:2416)
[hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1]
at
org.hibernate.ejb.AbstractEntityManagerImpl.lock(AbstractEntityManagerImpl.java:1117)
[hibernate-entitymanager-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1]
... 20 more
--
View this message in context:
http://camel.465427.n5.nabble.com/Camel-JPA-endpoint-consumer-problem-tp5753332p5753425.html
Sent from the Camel - Users mailing list archive at Nabble.com.
