GeoTools
  1. GeoTools
  2. GEOT-4629

"Timeout trying to lock table" when creating image mosaic

    Details

      Description

      I have a simple mosaic unit test which tries to use a H2 datastore. There are only two images in the mosaic. During creation of the mosaic, I get an SQL exception about a lock timeout (see log file).

      The same error is occuring during a Jenkins build of geotools-master:
      http://winbuild.geo-solutions.it/jenkins/job/GeoTools-Master/133/consoleText
      But the unit tests do not seem to fail. (In later builds, the exception doesn't seem to occur, but the number of tests that have run is also a lot smaller.)

        Issue Links

          Activity

          Hide
          Daniele Romagnoli added a comment -
          Found these:
          http://www.h2database.com/html/advanced.html#mvcc
          http://stackoverflow.com/questions/4162557/timeout-error-trying-to-lock-table-in-h2

          I have locally tested it and it works.
          I just need to understand and test whether it has any unexpected side effect.
          Show
          Daniele Romagnoli added a comment - Found these: http://www.h2database.com/html/advanced.html#mvcc http://stackoverflow.com/questions/4162557/timeout-error-trying-to-lock-table-in-h2 I have locally tested it and it works. I just need to understand and test whether it has any unexpected side effect.
          Hide
          Daniele Romagnoli added a comment -
          Fixed on trunk and 10.x
          Show
          Daniele Romagnoli added a comment - Fixed on trunk and 10.x

            People

            • Assignee:
              Daniele Romagnoli
              Reporter:
              Jeroen Dries
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: