Running Multiple PSL Programs in Parallel

30 views
Skip to first unread message

jonathan...@gmail.com

unread,
Aug 26, 2020, 6:28:00 PM8/26/20
to PSL Users
Is there a way to use the PSL CLI without locking up the database, preventing other programs to also use PSL at the same time? I get this error when trying to use PSL in multiple programs running at the same time:

(Unknown PSL logging level) -- org.h2.jdbc.JdbcSQLException: Database may be already in use: null. Possible solutions: close all other connection(s); use the server mode [90020-192]

Is there a CLI option I can give to the CLI to prevent this issue?

Thank you!

Eriq Augustine

unread,
Aug 26, 2020, 9:10:13 PM8/26/20
to jonathan...@gmail.com, PSL Users
Hey Jonathan,

Each running instance of PSL will want a lock on it's database and try to use all the available cores.

To deal with the database lock, you can just tell each instance to use a different database.
Since it looks like you are using H2 as your database engine, you can use the `--h2path` CLI option.
(To see all the CLI options, just use `--help`.)

To deal with each instance of PSL wanting to use all the cores, you can set the `parallel.numthreads` PSL option to whatever you want.
E.g.: `-D parallel.numthreads=2`

-eriq

--
You received this message because you are subscribed to the Google Groups "PSL Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to psl-users+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/psl-users/23af0769-ea7a-48af-92f2-75bb44c98019n%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages