July 2020 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-14093) Optimize inserted key contains

by Leuteris Katiforis (JIRA)

Leuteris Katiforis ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5b06ac3... ) *commented* on HHH-14093 ( https://hibernate.atlassian.net/browse/HHH-14093?atlOrigin=eyJpIjoiNGFmYW... ) Re: Optimize inserted key contains ( https://hibernate.atlassian.net/browse/HHH-14093?atlOrigin=eyJpIjoiNGFmYW... ) I've refactored StatefulPersistenceContext#registerInsertedKey and StatefulPersistenceContext#wasInsertedDuringTransaction to use HashSet instead of ArrayList. Pull Request: https://github.com/hibernate/hibernate-orm/pull/3456 ( https://hibernate.atlassian.net/browse/HHH-14093#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14093#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100133- sha1:bf400b0 )

3 years, 11 months

1
0
0 / 0

[JIRA] (HHH-13926) StaleStateException should (optionally) not leak statements in the logs

by Mickaël TRICOT (JIRA)

3 years, 11 months

1
0
0 / 0

[JIRA] (HHH-13926) StaleStateException should (optionally) not leak statements in the logs

by Mickaël TRICOT (JIRA)

Mickaël TRICOT ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-13926 ( https://hibernate.atlassian.net/browse/HHH-13926?atlOrigin=eyJpIjoiY2MyYm... ) Re: StaleStateException should (optionally) not leak statements in the logs ( https://hibernate.atlassian.net/browse/HHH-13926?atlOrigin=eyJpIjoiY2MyYm... ) Hello Sanne, The problem in my case is that we handle nominative health data and we can’t have them in the applications logs. Here is an example stacktrace: 13:52:46.834 [ForkJoinPool.commonPool-worker-3] ERROR o.h.e.j.batch.internal.BatchingBatch - HHH000315: Exception executing batch [org.hibernate.StaleStateException: Batch update returned unexpected row count from update [1]; actual row count: 0; expected: 1; statement executed: HikariProxyPreparedStatement@1522577332 wrapping update patient set city='Gotham', country='US', line='Manoir Wayne', postal_code='12000', birth_date='1964-03-12 +00', email='batman(a)goth.com', family_name_official='Wayne', family_name_usual=NULL, first_name='Bruce', gender='male', last_crm_update='2020-04-03 13:52:21.638307+00', last_modified='2020-04-03 13:42:06.158879+00', phone='06 01 01 01 05', version=2 where id='749863f8-f148-4f3b-90eb-35841a26e12f'::uuid and version=1], SQL: update patient set city=?, country=?, line=?, postal_code=?, birth_date=?, email=?, family_name_official=?, family_name_usual=?, first_name=?, gender=?, last_crm_update=?, last_modified=?, phone=?, version=? where id=? and version=? 13:52:46.847 [ForkJoinPool.commonPool-worker-3] ERROR c.s.s.backend.infra.job.JobDecorator - Job failed: AutoUpdateCrmAppointments [1] org.springframework.orm.ObjectOptimisticLockingFailureException: Batch update returned unexpected row count from update [1]; actual row count: 0; expected: 1; statement executed: HikariProxyPreparedStatement@1522577332 wrapping update patient set city='Gotham', country='US', line='Manoir Wayne', postal_code='12000', birth_date='1964-03-12 +00', email='batman(a)goth.com', family_name_official='Wayne', family_name_usual=NULL, first_name='Bruce', gender='male', last_crm_update='2020-04-03 13:52:21.638307+00', last_modified='2020-04-03 13:42:06.158879+00', phone='06 01 01 01 05', version=2 where id='749863f8-f148-4f3b-90eb-35841a26e12f'::uuid and version=1; nested exception is org.hibernate.StaleStateException: Batch update returned unexpected row count from update [1]; actual row count: 0; expected: 1; statement executed: HikariProxyPreparedStatement@1522577332 wrapping update patient set city='Gotham', country='US', line='Manoir Wayne', postal_code='12000', birth_date='1964-03-12 +00', email='batman(a)goth.com', family_name_official='Wayne', family_name_usual=NULL, first_name='Bruce', gender='male', last_crm_update='2020-04-03 13:52:21.638307+00', last_modified='2020-04-03 13:42:06.158879+00', phone='06 01 01 01 05', version=2 where id='749863f8-f148-4f3b-90eb-35841a26e12f'::uuid and version=1 [1] at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:340) [1] at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:255) [1] at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:538) [1] at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:743) [1] at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:711) [1] at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:631) [1] at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:385) [1] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118) [1] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) [1] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) [1] at net.javacrumbs.shedlock.core.DefaultLockingTaskExecutor.executeWithLock(DefaultLockingTaskExecutor.java:73) [1] at net.javacrumbs.shedlock.spring.aop.MethodProxyScheduledLockAdvisor$LockingInterceptor.invoke(MethodProxyScheduledLockAdvisor.java:85) [1] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) [1] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) [1] at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) [1] at com.serenitymedicalservices.smc.backend.use_cases.crm.AutoUpdateCrmAppointments$$EnhancerBySpringCGLIB$$3cbc2df0.perform(<generated>) [1] at com.serenitymedicalservices.smc.backend.infra.job.JobDecorator.run(JobDecorator.java:35) [1] at com.serenitymedicalservices.smc.backend.infra.job.RunAsyncJob.lambda$perform$0(RunAsyncJob.java:13) [1] at java.base/java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1800) [1] at java.base/java.util.concurrent.CompletableFuture$AsyncRun.exec(CompletableFuture.java:1792) [1] at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:290) [1] at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1016) [1] at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1665) [1] at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1598) [1] at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:177) [1] Caused by: org.hibernate.StaleStateException: Batch update returned unexpected row count from update [1]; actual row count: 0; expected: 1; statement executed: HikariProxyPreparedStatement@1522577332 wrapping update patient set city='Gotham', country='US', line='Manoir Wayne', postal_code='12000', birth_date='1964-03-12 +00', email='batman(a)goth.com', family_name_official='Wayne', family_name_usual=NULL, first_name='Bruce', gender='male', last_crm_update='2020-04-03 13:52:21.638307+00', last_modified='2020-04-03 13:42:06.158879+00', phone='06 01 01 01 05', version=2 where id='749863f8-f148-4f3b-90eb-35841a26e12f'::uuid and version=1 [1] at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:67) [1] at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:54) [1] at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.checkRowCounts(BatchingBatch.java:149) [1] at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:124) [1] at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:105) [1] at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:148) [1] at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:198) [1] at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:633) [1] at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478) [1] at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:723) [1] at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475) [1] at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:348) [1] at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:40) [1] at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:102) [1] at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1352) [1] at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:443) [1] at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3202) [1] at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2370) [1] at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:447) [1] at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:183) [1] at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40) [1] at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:281) [1] at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101) [1] at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:534) [1] ... 22 common frames omitted You are correct, the problem is not the statement but the parameter values. I would be perfectly fine if we would just remove those values from the exception message. We use: * Spring Boot 2.3.1 * HikariCP 3.4.5 * PostgreSQL driver 42.2.14 Thanks for your help ( https://hibernate.atlassian.net/browse/HHH-13926#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-13926#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100133- sha1:abe90d4 )

3 years, 11 months

1
0
0 / 0

[JIRA] (HHH-14038) None of the PostGIS dialects refer to which version of PostGIS they work with

by Karel Maesen (JIRA)

3 years, 11 months

1
0
0 / 0

[JIRA] (HHH-14038) None of the PostGIS dialects refer to which version of PostGIS they work with

by Karel Maesen (JIRA)

3 years, 11 months

1
0
0 / 0

[JIRA] (HHH-14038) None of the PostGIS dialects refer to which version of PostGIS they work with

by Karel Maesen (JIRA)

Karel Maesen ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-14038 ( https://hibernate.atlassian.net/browse/HHH-14038?atlOrigin=eyJpIjoiODNkMz... ) Re: None of the PostGIS dialects refer to which version of PostGIS they work with ( https://hibernate.atlassian.net/browse/HHH-14038?atlOrigin=eyJpIjoiODNkMz... ) The features and operators supported are documented in the Hibernate userguide, chapter 18. ( https://docs.jboss.org/hibernate/orm/5.4/userguide/html_single/Hibernate_... ) Currently the support is limited to the Simple Features Specification. The suggestion to include both postgresql and postgis version is not sustainable in my opinion because we'd end up with way too many dialects to be manageable. The better route is using HHH-10901 ( https://hibernate.atlassian.net/browse/HHH-10901 ) so we can separate the Postgis support from the dialect. ( https://hibernate.atlassian.net/browse/HHH-14038#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14038#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100133- sha1:abe90d4 )

3 years, 11 months

1
0
0 / 0

[JIRA] (HHH-14037) Please make a PostgisPG10Dialect

by Karel Maesen (JIRA)

3 years, 11 months

1
0
0 / 0

[JIRA] (HSEARCH-3962) Document possible architectures

by Yoann Rodière (JIRA)

3 years, 11 months

1
0
0 / 0

[JIRA] (HSEARCH-3710) Document declaration of dependencies in bridges

by Yoann Rodière (JIRA)

3 years, 11 months

1
0
0 / 0

[JIRA] (HSEARCH-3709) Document routing key bridges

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate Search ( https://hibernate.atlassian.net/browse/HSEARCH?atlOrigin=eyJpIjoiOTY0MGYw... ) / Sub-task ( https://hibernate.atlassian.net/browse/HSEARCH-3709?atlOrigin=eyJpIjoiOTY... ) HSEARCH-3709 ( https://hibernate.atlassian.net/browse/HSEARCH-3709?atlOrigin=eyJpIjoiOTY... ) Document routing key bridges ( https://hibernate.atlassian.net/browse/HSEARCH-3709?atlOrigin=eyJpIjoiOTY... ) Change By: Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Pull Request: https://github.com/hibernate/hibernate-search/pull/2321 Status: In Progress Pull Request Sent ( https://hibernate.atlassian.net/browse/HSEARCH-3709#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-3709#add-comment?atlOrigin... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100133- sha1:abe90d4 )

3 years, 11 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues July 2020