Can no longer run multiple gpt jobs at once since Ver 8.0.0

snap
#1

I have been starting multiple gpt jobs at once using gnu parallel in order to reduce processing time.

Now since version 8 I can only run one at a time or I get the following error:

Caused by: java.lang.IllegalStateException: The file is locked:nio:/home/hnw/.snap/product-library/products.mv.db [1.4.197/7]

This database is present, and permissions seem fine. I can touch it and date refreshes to now.

Is this a known issue?

Thanks,

Bill H.

#2

This looks interesting (besides the problem)… would you be willing to explain how do use SNAP and Parallel together? Thanks.

There’s a new version of the product library in SNAP8 but it should not influence how the GPT is used… @oana_hogoiu can you have a look from the product library side? @marpet can you confirm the GPT side?

#3

I get this exception too.

SEVERE: org.esa.snap.product.library.v2.activator.ProductLibraryActivator: Failed to initialize the database.
org.h2.jdbc.JdbcSQLException: Datenbank wird wahrscheinlich bereits benutzt: null. M÷gliche L÷sungen: alle Verbindungen schliessen; Server Modus verwenden
Database may be already in use: null. Possible solutions: close all other connection(s); use the server mode [90020-197]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
        at org.h2.message.DbException.get(DbException.java:168)
        at org.h2.mvstore.db.MVTableEngine$Store.convertIllegalStateException(MVTableEngine.java:188)
        at org.h2.mvstore.db.MVTableEngine$Store.open(MVTableEngine.java:168)
        at org.h2.mvstore.db.MVTableEngine.init(MVTableEngine.java:100)
        at org.h2.engine.Database.getPageStore(Database.java:2538)
        at org.h2.engine.Database.open(Database.java:709)
        at org.h2.engine.Database.openDatabase(Database.java:286)
        at org.h2.engine.Database.<init>(Database.java:280)
        at org.h2.engine.Engine.openSession(Engine.java:66)
        at org.h2.engine.Engine.openSession(Engine.java:179)
        at org.h2.engine.Engine.createSessionAndValidate(Engine.java:157)
        at org.h2.engine.Engine.createSession(Engine.java:140)
        at org.h2.engine.Engine.createSession(Engine.java:28)
        at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:351)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:124)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:103)
        at org.h2.Driver.connect(Driver.java:69)
        at java.sql.DriverManager.getConnection(DriverManager.java:664)
        at java.sql.DriverManager.getConnection(DriverManager.java:208)
        at org.esa.snap.product.library.v2.database.DataAccess.getConnection(DataAccess.java:1063)
        at org.esa.snap.product.library.v2.database.DataAccess.upgradeDatabase(DataAccess.java:82)
        at org.esa.snap.product.library.v2.activator.ProductLibraryActivator.start(ProductLibraryActivator.java:27)
        at org.esa.snap.runtime.Engine.informActivators(Engine.java:222)
        at org.esa.snap.runtime.Engine.lambda$start$0(Engine.java:121)
        at org.esa.snap.runtime.Engine.runClientCode(Engine.java:189)
        at org.esa.snap.runtime.Engine.start(Engine.java:121)
        at org.esa.snap.runtime.Engine.start(Engine.java:90)
        at org.esa.snap.runtime.Launcher.run(Launcher.java:51)
        at org.esa.snap.runtime.Launcher.main(Launcher.java:31)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.exe4j.runtime.LauncherEngine.launch(LauncherEngine.java:84)
        at com.exe4j.runtime.WinLauncher.main(WinLauncher.java:94)
        at com.install4j.runtime.launcher.WinLauncher.main(WinLauncher.java:25)
Caused by: java.lang.IllegalStateException: The file is locked: nio:C:/Users/Marco/.snap/product-library/products.mv.db [1.4.197/7]
        at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:870)
        at org.h2.mvstore.FileStore.open(FileStore.java:173)
        at org.h2.mvstore.MVStore.<init>(MVStore.java:350)
        at org.h2.mvstore.MVStore$Builder.open(MVStore.java:2934)
        at org.h2.mvstore.db.MVTableEngine$Store.open(MVTableEngine.java:155)
        ... 33 more

Good is that the exception text also provides a solution for it.

Database may be already in use: null. Possible solutions: close all other connection(s); use the server mode

Despite the exception the processing goes on normally and I got the processing results.

#4

Currently the Product Library H2 database is used in embedded mode, which allows only 1 connection.
The error is thrown when a new connection is required (after an existing one).
However, this should not impact the gpt (it appears because it’s part of SNAP initialization).
Server mode should be used for H2 database, for allowing multiple connections.
I will create a JIRA ticket for this.
(https://senbox.atlassian.net/browse/SNAP-1359)

database.\r\norg.h2.jdbc.JdbcSQLException: Database may be already in use: "Locked by another process"