Yoann Rodière (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%...
) *created* an issue
Hibernate Search (
https://hibernate.atlassian.net/browse/HSEARCH?atlOrigin=eyJpIjoiMGIzNTRl...
) / Task (
https://hibernate.atlassian.net/browse/HSEARCH-4810?atlOrigin=eyJpIjoiMGI...
) HSEARCH-4810 (
https://hibernate.atlassian.net/browse/HSEARCH-4810?atlOrigin=eyJpIjoiMGI...
) Fix flaky test with MSSQL (
https://hibernate.atlassian.net/browse/HSEARCH-4810?atlOrigin=eyJpIjoiMGI...
)
Issue Type: Task Assignee: Yoann Rodière (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%...
) Components: integration, tests Created: 02/Mar/2023 02:26 AM Fix Versions: 6.2-backlog
Priority: Major Reporter: Yoann Rodière (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%...
)
https://ci.hibernate.org/job/hibernate-search/job/main/614/ (
https://ci.hibernate.org/job/hibernate-search/job/main/614/ )
Non-default environments / database-mssql /
org.hibernate.search.integrationtest.mapper.orm.coordination.outboxpolling.automaticindexing.OutboxPollingAutomaticIndexingLifecycleIT(coord-outbox-jakarta-database-mssql).stopWhileOutboxEventsIsBeingProcessed
(
https://ci.hibernate.org/job/hibernate-search/job/main/614/testReport/jun...
)
jakarta.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException:
could not execute query
at
org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
at
org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1626)
at
org.hibernate.query.internal.AbstractProducedQuery.getSingleResult(AbstractProducedQuery.java:1665)
at
org.hibernate.search.integrationtest.mapper.orm.coordination.outboxpolling.testsupport.util.OutboxEventFilter.countOutboxEventsNoFilter(OutboxEventFilter.java:113)
at
org.hibernate.search.integrationtest.mapper.orm.coordination.outboxpolling.automaticindexing.OutboxPollingAutomaticIndexingLifecycleIT.lambda$stopWhileOutboxEventsIsBeingProcessed$2(OutboxPollingAutomaticIndexingLifecycleIT.java:80)
at
org.hibernate.search.util.impl.integrationtest.mapper.orm.PersistenceRunner.lambda$runInTransaction$2(PersistenceRunner.java:43)
at
org.hibernate.search.util.impl.integrationtest.mapper.orm.PersistenceRunner.lambda$applyInTransaction$1(PersistenceRunner.java:36)
at
org.hibernate.search.util.impl.integrationtest.mapper.orm.NativePersistenceRunner.lambda$applyInTransaction$0(NativePersistenceRunner.java:43)
at
org.hibernate.search.util.impl.integrationtest.mapper.orm.OrmUtils.applyInTransaction(OrmUtils.java:49)
at
org.hibernate.search.util.impl.integrationtest.mapper.orm.NativePersistenceRunner.lambda$applyInTransaction$1(NativePersistenceRunner.java:42)
at
org.hibernate.search.util.impl.integrationtest.mapper.orm.NativePersistenceRunner.applyNoTransaction(NativePersistenceRunner.java:33)
at
org.hibernate.search.util.impl.integrationtest.mapper.orm.NativePersistenceRunner.applyInTransaction(NativePersistenceRunner.java:40)
at
org.hibernate.search.util.impl.integrationtest.mapper.orm.PersistenceRunner.applyInTransaction(PersistenceRunner.java:36)
at
org.hibernate.search.util.impl.integrationtest.mapper.orm.PersistenceRunner.runInTransaction(PersistenceRunner.java:42)
at
org.hibernate.search.integrationtest.mapper.orm.coordination.outboxpolling.automaticindexing.OutboxPollingAutomaticIndexingLifecycleIT.lambda$stopWhileOutboxEventsIsBeingProcessed$3(OutboxPollingAutomaticIndexingLifecycleIT.java:79)
at org.awaitility.core.AssertionCondition.lambda$new$0(AssertionCondition.java:53)
at org.awaitility.core.ConditionAwaiter$ConditionPoller.call(ConditionAwaiter.java:248)
at org.awaitility.core.ConditionAwaiter$ConditionPoller.call(ConditionAwaiter.java:235)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:833)
Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
at org.hibernate.loader.Loader.doList(Loader.java:2871)
at org.hibernate.loader.Loader.doList(Loader.java:2850)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2682)
at org.hibernate.loader.Loader.list(Loader.java:2677)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:540)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400)
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1459)
at
org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1649)
at
org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1617)
... 20 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An error occurred during the
current command (Done status 0). Transaction (Process ID 64) was deadlocked on lock
resources with another process and has been chosen as the deadlock victim. Rerun the
transaction.
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:237)
at
com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer$FetchBufferTokenHandler.onDone(SQLServerResultSet.java:5396)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:99)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:37)
at
com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:5491)
at
com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1796)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1054)
at org.hibernate.loader.Loader.getRowsFromResultSet(Loader.java:1043)
at org.hibernate.loader.Loader.processResultSet(Loader.java:998)
at org.hibernate.loader.Loader.doQuery(Loader.java:967)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:357)
at org.hibernate.loader.Loader.doList(Loader.java:2868)
... 29 more
(
https://hibernate.atlassian.net/browse/HSEARCH-4810#add-comment?atlOrigin...
) Add Comment (
https://hibernate.atlassian.net/browse/HSEARCH-4810#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=Em...
) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100217- sha1:65be9f2 )