-
Notifications
You must be signed in to change notification settings - Fork 110
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Question: parallel run #91
Comments
Normally I run things in parallel with parallel processes on the OS (so
have a script that launches everything then run that in parallel). I
suspect it would also be possible to use the `multiprocess` python package
to do so in a single script, but have not tried.
…On Sat, Oct 13, 2018 at 2:39 PM Thomas Zipperle ***@***.***> wrote:
Is it possible run message parallel with python multiprocess? Or what is
the best way to run message parallel?
—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
<#91>, or mute the thread
<https://github.com/notifications/unsubscribe-auth/ABVAEd7RZLcX38z13h15rGta4Y7QMg9aks5ukd8JgaJpZM4XanFC>
.
|
I have tried multiprocess with HSQLDB and I got a error. Do I need an oracle data base for parallel run? |
Ah, that I do not know... out of curiosity what error did you get?
…On Wed, Oct 17, 2018 at 10:30 AM Thomas Zipperle ***@***.***> wrote:
I have tried multiprocess with HSQLDB and I got a error. Do I need an
oracle data base for parallel run?
—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
<#91 (comment)>, or mute
the thread
<https://github.com/notifications/unsubscribe-auth/ABVAERn62X9Zvb-kX4lMtg1m_XTZ2Yw1ks5uluqJgaJpZM4XanFC>
.
|
If you use HSQLDB in file-based mode, only one process can access it a time. There is a way to launch an HSQLDB instance in server mode, which would allow multiple connections - but I have never tried that... You will need a configuration file with the following, not sure what the driver should be. The url should probably be the path.
|
I have also tried with the server mode. I started the server with:
And with the following config:
I could connect to the data base. But only one connection. |
Oh, so you were already on the right track. Sorry that it doesn't work as expected. @peterkolp, any ideas? |
Today I did a next try. I have startet a server from the installed ixmp from my conda environment.
But if I try to connect to the server, I get an error:
Do you have any ideas to fix this problem? |
@zikolach, can you take a look? |
@tzipperle to start HSQLDB server you may use following command (same as in your comment):
To check you can connect it use following:
If it succeed the JDBC URL is Now we need to figure out why you have different checksums for migration files. You should see it in the log output as existing and new values. Using HSQLDB client you may try to change checksum in the database manually to fix it (assuming both migrations - the one previously applied and current one - have same changes differs only in formatting/line endings/etc). Please do a backup copy of directory with database before changing anything manually! If you attach more detailed log - we can try to figure out what exactly is the problem. Also you may be interested in using Postgresql database. Recently we added it support (for testing purposes to the moment). But you'll need to care about data migration yourself. |
I could not check this under windows 10. I get a error unknown driver and the log file is after the run empty. I start with a new project without a database. It should not be a problem with the data migration |
@tzipperle please ensure the If you want to try postgresql option - options for config file may look like:
You'll need to create an empty DB before trying to access it or (if you familiar with Docker) use following compose file to run Postgresql instance in container:
In the snippets above |
I had a problem with the backslash. Now I can connect to the server. I have tried the following workflow:
The log-file now contains the following information:
|
I could fix the problem with the migration. It was a problem with the conda environment. After I recreated the environment it works. @zikolach Thanks for your help. |
Hi @zikolach , I think I have to change the table type from Do you have any ideas what I can do? |
Is it possible run message parallel with python multiprocess? Or what is the best way to run message parallel?
The text was updated successfully, but these errors were encountered: