Batch update return unexpected row count from update [0];actual row count:0

Message Boards

pradip choudhari, modified 4 Years ago.

Batch update return unexpected row count from update [0];actual row count:0

Junior Member Posts: 59 Join Date: 5/10/19 Recent Posts

While working with Model Listener , we are deleting custom entities if exist , having 25+ entities mappings in Our database.But after all operation done , we getting
"org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1" .
Records are deleting from custom entities but at the end of the all operation complete, this exception raises.

Olaf Kock, modified 4 Years ago.

RE: Batch update return unexpected row count from update [0];actual row cou

Liferay Legend Posts: 6403 Join Date: 9/23/08 Recent Posts

pradip choudhari:

While working with Model Listener , we are deleting custom entities if exist , having 25+ entities mappings in Our database.But after all operation done , we getting
"org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1" .
Records are deleting from custom entities but at the end of the all operation complete, this exception raises.

And your question is?
It can't be about your code, because then you'd have given some information as to what you do, and where the issue arises.
Did you google this error message? I find a couple of good generic tips to deal with this condition within the first hits, e.g. on stackoverflow. Read all the answers and comments.
If you still need help, we'll need more information than "I did something"

pradip choudhari, modified 4 Years ago.

RE: Batch update return unexpected row count from update [0];actual row cou

Junior Member Posts: 59 Join Date: 5/10/19 Recent Posts

Hello Olaf Thanks for quick reply ,
I am describing again issue here.. While working with ModelListner , when I am deleting any Organisation then I am removing its records from custom entity also.For that we used dynamic queries those all working fine . and records also deleted correctly from custom entity .But all execution done that time I am getting always
org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
even , I used
CacheRegistryUtil.clear(); // - to clear all the Database caches
WebCachePoolUtil.clear() ;//- clearing cache in Single VM
to clear the cache .
but exception always get only after all lines execution completely, not in middle also.

Olaf Kock, modified 4 Years ago.

RE: Batch update return unexpected row count from update [0];actual row cou

Liferay Legend Posts: 6403 Join Date: 9/23/08 Recent Posts

pradip choudhari:

Hello Olaf Thanks for quick reply ,
I am describing again issue here..

Have you tried this?
The first hit I get is this, with loads of answers and comments. Not knowing any of your code, the first comment on the (currently) second listed question looks promising

I had this problem when I removed a child from a parent-child relationship, saved the parent (which deletes the child) and then tried to also delete the child manually

Of course, I have no clue if this is your problem. To help fixing code problems, we'd need actual code.

pradip choudhari, modified 4 Years ago.

RE: Batch update return unexpected row count from update [0];actual row cou

Junior Member Posts: 59 Join Date: 5/10/19 Recent Posts

Hello Olaf 
that time when I executed code in multithreading to get better performance then its working fine , code not raising any exception. 
but when i removed multithreaded concepts from the code , then again I got the exception ..eventhough I put all my code like its executed in multithreaded environment , but that not worked.. 
so , now I am using that code with multithreading , but still I not get better solution  
why its not working in normal way ??

Olaf Kock, modified 4 Years ago.

RE: Batch update return unexpected row count from update [0];actual row cou

Liferay Legend Posts: 6403 Join Date: 9/23/08 Recent Posts

pradip choudhari:

why its not working in normal way ??

Let me repeat:

To help fixing code problems, we'd need actual code.

All code in Liferay runs multithreaded, so in general these updates work very well. We'll need to see code in order to help.
One guess: Do you store any data in member variables of your portlet? Show code...

pradip choudhari, modified 4 Years ago.

RE: Batch update return unexpected row count from update [0];actual row cou

Junior Member Posts: 59 Join Date: 5/10/19 Recent Posts

Thanks for quick reply Olaf
I attached code in below file

Olaf Kock, modified 4 Years ago.

RE: Batch update return unexpected row count from update [0];actual row cou

Liferay Legend Posts: 6403 Join Date: 9/23/08 Recent Posts

pradip choudhari:

I attached code in below file

Ok, somewhere in these 866 lines you get an exception... guess how you could help with the analysis... (hint: Let us know where (exactly) the exception occurs)

However, I'm seeing long methods that start multiple threads to do additional work. I won't expect those threads to be within the same transaction context as the original ModelListener. In fact, I'd expect them to be explicitly without any context.

My recommendation would be to eliminate the threads (as a first test, so that you're doing everything in the same context). If that works, you probably don't want to keep long operations running within the ModelListener, so you want them elsewhere. One way is to fire a message on the MessageBus. This way you can handle the operations outside of your ModelListener, but still allow Liferay to provide a proper context for the transactions.

If that doesn't help: Nobody here will be able to run that long code, I'd recommend to make it a minimal example that reproduces your observation - e.g. remove everything that doesn't influence the result. Maybe, during the creation of this minimal example, you'll realize that a particular section, when removed, will change the outcome: In this case you may have found the culprit yourself.

Towfik Alrazihi, modified 3 Years ago.

RE: Batch update return unexpected row count from update [0];actual row cou

New Member Posts: 9 Join Date: 4/5/18 Recent Posts

I am facing the same issue when importing blogs back to liferay

[JDBCExceptionReporter:234] Duplicate entry '20123--' for key 'blogsentry.IX_DB780A20'

2020-11-03 11:53:40.604 ERROR [liferay/background_task-1][AbstractBatcher:73] Exception executing batch:

org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1

at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:85)

at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:70)

at org.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java:90)

at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)

at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)

at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)

at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185)

at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)

at com.liferay.portal.dao.orm.hibernate.event.NestableFlushEventListener.onFlush(NestableFlushEventListener.java:61)

at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)

at com.liferay.portal.spring.hibernate.PortletTransactionManager$TransactionStatusWrapper.reset(PortletTransactionManager.java:260)

at com.liferay.portal.spring.hibernate.PortletTransactionManager.rollback(PortletTransactionManager.java:145)

at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._rollback(DefaultTransactionExecutor.java:151)

at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._execute(DefaultTransactionExecutor.java:131)

at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:51)

at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:62)

at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)

at com.liferay.portal.service.ServiceContextAdvice.invoke(ServiceContextAdvice.java:60)

at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)

at com.liferay.portal.kernel.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:65)

at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)

at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49)

at com.sun.proxy.$Proxy1174.addEntry(Unknown Source)

at com.liferay.blogs.internal.exportimport.data.handler.BlogsEntryStagedModelDataHandler.doImportStagedModel(BlogsEntryStagedModelDataHandler.java:255)

at com.liferay.blogs.internal.exportimport.data.handler.BlogsEntryStagedModelDataHandler.doImportStagedModel(BlogsEntryStagedModelDataHandler.java:62)

at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.importStagedModel(BaseStagedModelDataHandler.java:392)

at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:456)

at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:442)

at com.liferay.blogs.web.internal.exportimport.data.handler.BlogsAdminPortletDataHandler.doImportData(BlogsAdminPortletDataHandler.java:165)

at com.liferay.exportimport.kernel.lar.BasePortletDataHandler.importData(BasePortletDataHandler.java:385)

at com.liferay.exportimport.internal.controller.PortletImportControllerImpl.importPortletData(PortletImportControllerImpl.java:414)

at com.liferay.exportimport.internal.controller.PortletImportControllerImpl.importPortletData(PortletImportControllerImpl.java:345)

at com.liferay.site.internal.exportimport.data.handler.StagedGroupStagedModelDataHandler.importSitePortlets(StagedGroupStagedModelDataHandler.java:603)

at com.liferay.site.internal.exportimport.data.handler.StagedGroupStagedModelDataHandler.doImportStagedModel(StagedGroupStagedModelDataHandler.java:323)

at com.liferay.site.internal.exportimport.data.handler.StagedGroupStagedModelDataHandler.doImportStagedModel(StagedGroupStagedModelDataHandler.java:78)

at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.importStagedModel(BaseStagedModelDataHandler.java:392)

at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:456)

at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:442)

at com.liferay.exportimport.internal.controller.LayoutImportController.doImportFile(LayoutImportController.java:568)

at com.liferay.exportimport.internal.controller.LayoutImportController.importFile(LayoutImportController.java:219)

at com.liferay.portlet.exportimport.service.impl.ExportImportLocalServiceImpl.importLayouts(ExportImportLocalServiceImpl.java:219)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50)

at com.liferay.portal.spring.transaction.TransactionInterceptor.lambda$invoke$0(TransactionInterceptor.java:64)

at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._execute(DefaultTransactionExecutor.java:128)

at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:51)

at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:62)

at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)

at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49)

at com.sun.proxy.$Proxy246.importLayouts(Unknown Source)

at com.liferay.exportimport.kernel.service.ExportImportLocalServiceUtil.importLayouts(ExportImportLocalServiceUtil.java:121)

at com.liferay.exportimport.internal.background.task.LayoutImportBackgroundTaskExecutor$LayoutImportCallable.call(LayoutImportBackgroundTaskExecutor.java:128)

at com.liferay.exportimport.internal.background.task.LayoutImportBackgroundTaskExecutor$LayoutImportCallable.call(LayoutImportBackgroundTaskExecutor.java:114)

at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._execute(DefaultTransactionExecutor.java:128)

at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:51)

at com.liferay.portal.spring.transaction.TransactionInvokerImpl.invoke(TransactionInvokerImpl.java:39)

at com.liferay.portal.kernel.transaction.TransactionInvokerUtil.invoke(TransactionInvokerUtil.java:28)

at com.liferay.exportimport.internal.background.task.LayoutImportBackgroundTaskExecutor.execute(LayoutImportBackgroundTaskExecutor.java:85)

at com.liferay.portal.background.task.internal.SerialBackgroundTaskExecutor.execute(SerialBackgroundTaskExecutor.java:62)

at com.liferay.portal.kernel.backgroundtask.DelegatingBackgroundTaskExecutor.execute(DelegatingBackgroundTaskExecutor.java:41)

at com.liferay.portal.background.task.internal.ThreadLocalAwareBackgroundTaskExecutor.execute(ThreadLocalAwareBackgroundTaskExecutor.java:72)

at com.liferay.portal.background.task.internal.messaging.BackgroundTaskMessageListener.doReceive(BackgroundTaskMessageListener.java:132)

at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:26)

at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:74)

at com.liferay.portal.kernel.messaging.ParallelDestination$1.run(ParallelDestination.java:52)

at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask._runTask(ThreadPoolExecutor.java:752)

at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask.run(ThreadPoolExecutor.java:664)

at java.lang.Thread.run(Thread.java:748)

2020-11-03 11:53:41.039 ERROR [liferay/background_task-1][BackgroundTaskMessageListener:173] Unable to execute background task

com.liferay.exportimport.kernel.lar.PortletDataException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1

at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.importStagedModel(BaseStagedModelDataHandler.java:433)