-
Type: Bug
-
Status: Resolved
-
Priority: Minor
-
Resolution: Cannot Reproduce
-
Affects Version/s: 5.7-SNAPSHOT
-
Fix Version/s: None
-
Tags:
-
Backlog priority:400
Faceted search selenium tests show random errors on tables while trying to lock them:
Caused by: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table HIERARCHY; SQL statement: SELECT "_C1", "_C2" FROM (SELECT "HIERARCHY"."ID" AS "_C1", "_F1"."TITLE" AS "_C2" FROM "HIERARCHY" LEFT JOIN "DUBLINCORE" "_F1" ON "HIERARCHY"."ID" = "_F1"."ID" LEFT JOIN "MISC" "_F2" ON "HIERARCHY"."ID" = "_F2"."ID" WHERE (("HIERARCHY"."PRIMARYTYPE" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ("HIERARCHY"."PRIMARYTYPE" IN (?, ?) OR ("HIERARCHY"."MIXINTYPES" LIKE ?)) AND ("_F2"."LIFECYCLESTATE" <> ?) AND ("_F2"."LIFECYCLESTATE" <> ?) AND ("HIERARCHY"."PARENTID" = ?)) UNION ALL SELECT "_H"."ID" AS "_C1", "_F1"."TITLE" AS "_C2" FROM "HIERARCHY" "_H" JOIN "PROXIES" ON "_H"."ID" = "PROXIES"."ID" JOIN "HIERARCHY" ON "PROXIES"."TARGETID" = "HIERARCHY"."ID" LEFT JOIN "DUBLINCORE" "_F1" ON "HIERARCHY"."ID" = "_F1"."ID" LEFT JOIN "MISC" "_F2" ON "HIERARCHY"."ID" = "_F2"."ID" WHERE (("HIERARCHY"."PRIMARYTYPE" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ("HIERARCHY"."PRIMARYTYPE" IN (?, ?) OR ("HIERARCHY"."MIXINTYPES" LIKE ?)) AND ("_F2"."LIFECYCLESTATE" <> ?) AND ("_F2"."LIFECYCLESTATE" <> ?) AND ("_H"."PARENTID" = ?))) ORDER BY "_C2" [50200-114] at org.h2.message.Message.getSQLException(Message.java:105) at org.h2.message.Message.getSQLException(Message.java:116) at org.h2.message.Message.getSQLException(Message.java:75) at org.h2.table.TableData.doLock(TableData.java:435) at org.h2.table.TableData.lock(TableData.java:373) at org.h2.table.TableFilter.lock(TableFilter.java:110) at org.h2.command.dml.Select.queryWithoutCache(Select.java:549) at org.h2.command.dml.Query.query(Query.java:234) at org.h2.command.dml.SelectUnion.queryWithoutCache(SelectUnion.java:134) at org.h2.command.dml.SelectUnion.query(SelectUnion.java:336) at org.h2.index.ViewIndex.find(ViewIndex.java:196) at org.h2.table.TableFilter.next(TableFilter.java:296) at org.h2.command.dml.Select.queryFlat(Select.java:493) at org.h2.command.dml.Select.queryWithoutCache(Select.java:561) at org.h2.command.dml.Query.query(Query.java:234) at org.h2.command.CommandContainer.query(CommandContainer.java:82) at org.h2.command.Command.executeQueryLocal(Command.java:142) at org.h2.command.Command.executeQuery(Command.java:123) at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:98) at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.query(JDBCMapper.java:788) ... 204 more
Caused by: org.h2.jdbc.JdbcBatchUpdateException: Timeout trying to lock table DUBLINCORE; SQL statement: UPDATE "DUBLINCORE" SET "MODIFIED" = ? WHERE "ID" = ? [50200-114] at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1067) at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.updateSimpleRows(JDBCRowMapper.java:690) ... 131 more
- depends on
-
NXP-12930 Improve concurrent update detection and behavior
- Resolved