Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-11593

Fix timeouts while trying to lock VCS tables

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Cannot Reproduce
    • Affects Version/s: 5.7-SNAPSHOT
    • Fix Version/s: None
    • Component/s: Core VCS, Tests

      Description

      Faceted search selenium tests show random errors on tables while trying to lock them:

      https://qa.nuxeo.org/jenkins/job/addons_FT_nuxeo-platform-faceted-search-master-tomcat/478/artifact/nuxeo-platform-faceted-search-ftest/selenium/target/tomcat/log/server.log

      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
      

      see https://qa.nuxeo.org/jenkins/job/addons_FT_nuxeo-platform-faceted-search-master-tomcat/483/artifact/nuxeo-platform-faceted-search-ftest/selenium/target/tomcat/log/server.log

      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
      

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                2 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: