Yoann Rodière (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%...
) *updated* an issue
Hibernate Search (
https://hibernate.atlassian.net/browse/HSEARCH?atlOrigin=eyJpIjoiMzg4YzA4...
) / Bug (
https://hibernate.atlassian.net/browse/HSEARCH-4774?atlOrigin=eyJpIjoiMzg...
) HSEARCH-4774 (
https://hibernate.atlassian.net/browse/HSEARCH-4774?atlOrigin=eyJpIjoiMzg...
) Database deadlock while processing events with MS SQL Server (
https://hibernate.atlassian.net/browse/HSEARCH-4774?atlOrigin=eyJpIjoiMzg...
)
Change By: Yoann Rodière (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%...
)
Encountered on CI:
[
https://ci.hibernate.org/job/hibernate-search/job/main/549/testReport/jun...
],
[
https://ci.hibernate.org/blue/organizations/jenkins/hibernate-search/deta...
|
https://ci.hibernate.org/blue/organizations/jenkins/hibernate-search/deta...
smart-link]
{{org.hibernate.search.integrationtest.mapper.orm.coordination.outboxpolling.automaticindexing.OutboxPollingAutomaticIndexingConcurrencyIT(coord-outbox-default-database-mssql).noDeadlock}}
{noformat}19:13:58,809 (Hibernate Search - Outbox event processor - 0) ERROR
LogFailureHandler:31 - HSEARCH000058: Exception occurred
javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException:
could not execute query
Failing operation:
Executing task 'Outbox event processor'
javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException:
could not execute query
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
~[hibernate-core-5.6.14.Final.jar:5.6.14.Final]
at
org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1626)
~[hibernate-core-5.6.14.Final.jar:5.6.14.Final]
at
org.hibernate.search.mapper.orm.coordination.outboxpolling.event.impl.DefaultOutboxEventFinder.findOutboxEvents(DefaultOutboxEventFinder.java:61)
~[hibernate-search-mapper-orm-coordination-outbox-polling-6.2.0-SNAPSHOT.jar:6.2.0-SNAPSHOT]
at
org.hibernate.search.mapper.orm.coordination.outboxpolling.event.impl.OutboxPollingEventProcessor$Worker.lambda$work$0(OutboxPollingEventProcessor.java:252)
~[hibernate-search-mapper-orm-coordination-outbox-polling-6.2.0-SNAPSHOT.jar:6.2.0-SNAPSHOT]
at
org.hibernate.search.mapper.orm.common.spi.TransactionHelper.inTransaction(TransactionHelper.java:54)
~[hibernate-search-mapper-orm-6.2.0-SNAPSHOT.jar:6.2.0-SNAPSHOT]
at
org.hibernate.search.mapper.orm.coordination.outboxpolling.event.impl.OutboxPollingEventProcessor$Worker.work(OutboxPollingEventProcessor.java:244)
~[hibernate-search-mapper-orm-coordination-outbox-polling-6.2.0-SNAPSHOT.jar:6.2.0-SNAPSHOT]
at
org.hibernate.search.engine.backend.orchestration.spi.SingletonTask$RunnableWrapper.run(SingletonTask.java:199)
~[hibernate-search-engine-6.2.0-SNAPSHOT.jar:6.2.0-SNAPSHOT]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539) ~[?:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?]
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304)
~[?:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?]
at 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)
~[hibernate-core-5.6.14.Final.jar:5.6.14.Final]
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
~[hibernate-core-5.6.14.Final.jar:5.6.14.Final]
at org.hibernate.loader.Loader.doList(Loader.java:2871)
~[hibernate-core-5.6.14.Final.jar:5.6.14.Final]
at org.hibernate.loader.Loader.doList(Loader.java:2850)
~[hibernate-core-5.6.14.Final.jar:5.6.14.Final]
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2682)
~[hibernate-core-5.6.14.Final.jar:5.6.14.Final]
at org.hibernate.loader.Loader.list(Loader.java:2677)
~[hibernate-core-5.6.14.Final.jar:5.6.14.Final]
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:540)
~[hibernate-core-5.6.14.Final.jar:5.6.14.Final]
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400)
~[hibernate-core-5.6.14.Final.jar:5.6.14.Final]
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219)
~[hibernate-core-5.6.14.Final.jar:5.6.14.Final]
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1459)
~[hibernate-core-5.6.14.Final.jar:5.6.14.Final]
at
org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1649)
~[hibernate-core-5.6.14.Final.jar:5.6.14.Final]
at
org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1617)
~[hibernate-core-5.6.14.Final.jar:5.6.14.Final]
... 11 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An error occurred during the
current command (Done status 0). Transaction (Process ID 76) 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)
~[mssql-jdbc-11.2.2.jre11.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer$FetchBufferTokenHandler.onDone(SQLServerResultSet.java:5396)
~[mssql-jdbc-11.2.2.jre11.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:99)
~[mssql-jdbc-11.2.2.jre11.jar:?]
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:37)
~[mssql-jdbc-11.2.2.jre11.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:5491)
~[mssql-jdbc-11.2.2.jre11.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1796)
~[mssql-jdbc-11.2.2.jre11.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1054)
~[mssql-jdbc-11.2.2.jre11.jar:?]
at org.hibernate.loader.Loader.getRowsFromResultSet(Loader.java:1043)
~[hibernate-core-5.6.14.Final.jar:5.6.14.Final]
at org.hibernate.loader.Loader.processResultSet(Loader.java:998)
~[hibernate-core-5.6.14.Final.jar:5.6.14.Final]
at org.hibernate.loader.Loader.doQuery(Loader.java:967)
~[hibernate-core-5.6.14.Final.jar:5.6.14.Final]
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:357)
~[hibernate-core-5.6.14.Final.jar:5.6.14.Final]
at org.hibernate.loader.Loader.doList(Loader.java:2868)
~[hibernate-core-5.6.14.Final.jar:5.6.14.Final]
at org.hibernate.loader.Loader.doList(Loader.java:2850)
~[hibernate-core-5.6.14.Final.jar:5.6.14.Final]
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2682)
~[hibernate-core-5.6.14.Final.jar:5.6.14.Final]
at org.hibernate.loader.Loader.list(Loader.java:2677)
~[hibernate-core-5.6.14.Final.jar:5.6.14.Final]
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:540)
~[hibernate-core-5.6.14.Final.jar:5.6.14.Final]
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400)
~[hibernate-core-5.6.14.Final.jar:5.6.14.Final]
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219)
~[hibernate-core-5.6.14.Final.jar:5.6.14.Final]
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1459)
~[hibernate-core-5.6.14.Final.jar:5.6.14.Final]
at
org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1649)
~[hibernate-core-5.6.14.Final.jar:5.6.14.Final]
at
org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1617)
~[hibernate-core-5.6.14.Final.jar:5.6.14.Final]
... 11 more{noformat}
(
https://hibernate.atlassian.net/browse/HSEARCH-4774#add-comment?atlOrigin...
) Add Comment (
https://hibernate.atlassian.net/browse/HSEARCH-4774#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#100214- sha1:bdfa1eb )