Multithreading error (sqlite lock) #350
|
Recently，when I try to use '-t ', I always encounter that 'sqlite3.OperationalError) database is locked' . My version is 1.6.3. Is there any method ? Thanks very much ! By the way, is MsNoise2.0 released？Or say it is just the development version？ |
Replies: 1 comment 2 replies
|
Hi, indeed, as stated in the documentation, the usage of threading can lead to issues with sqlite, as sqlite is a non-parallel "write" database. If you use it, make sure to use the "-d 5" option (5 being the number of seconds to wait between threads). msnoise 2 should be there soon, but "master" version is already very stable |
|
Thanks for your response, unfortunately, it does not work on my computer, even just -t 2 -d 10 conda install -c conda-forge flask-admin flask-wtf markdown folium pymysql logbook pandas pytables pip xarray Required: Only necessary if you plan to build the doc locally: Graphical Backends: Not required, just checking: |
|
don't worry about that, if you have the latest obspy release (1.4.1) and msnoise master, you're good to go! |
Hi, indeed, as stated in the documentation, the usage of threading can lead to issues with sqlite, as sqlite is a non-parallel "write" database. If you use it, make sure to use the "-d 5" option (5 being the number of seconds to wait between threads).
msnoise 2 should be there soon, but "master" version is already very stable