mansuf
commented
1 year ago Hmmmmm, can you try execute this code ? it's basically test to see if writing sqlite database with nolock parameter is working on your samba directory
import sqlite3
con = sqlite3.connect("file:/mnt/W/some_test_folder_in_samba_dir/test.db?nolock=1", check_same_thread=False, uri=True)
con.execute('CREATE TABLE "test" ("name" TEXT NOT NULL);')
con.commit()
con.close()If it's still not working, maybe this answer could help https://stackoverflow.com/a/4695262. NOTE: You might need to backup your files before doing this.
Annihilator6000
What happened ?
When trying to download new or update existing manga series that are located on my Samba file server, mangadex-dl throws the error "[ERROR] Unhandled exception, OperationalError: database is locked"
Console output from trying to update existing manga on Samba server:
Just to note - my Samba file server runs Ubuntu 18.04.6 LTS (GNU/Linux 4.15.0-204-generic x86_64)
Permissions for the directories that the above manga resides:
Linux Mint
ls -lin /mnt/W/Manga/:drwxrwxrwx 2 x x 0 Feb 25 10:02 MangaLinux Mintls -lin /mnt/W/Manga/Manga/:drwxrwxrwx 2 x x 0 Feb 28 14:39 'Sometimes Even Reality Is a Lie!'Ubuntu Server
ls -lfor the same directories:drwxr-sr-x 23 x x 4096 Feb 25 10:02 Mangadrwxr-sr-x 2 x x 4096 Feb 28 14:39 'Sometimes Even Reality Is a Lie!'I havecreate mask = 0777set in smb.conf, so folder perms shouldn't be an issue here.After running mangadex-dl and getting the error, there is an empty
download.dbfile (0B) that is created in the download directory:-rwxrwxrwx 1 x x 0 Feb 28 14:39 download.dbThe above error only happens when setting the path to my file server. Saving locally still works perfectly fine. This was a local successful test (initial download):
Re-running the command (update):
What did you expect to happen ?
The expected result was for mangadex-dl to download/update comic series located on the file server like the local test above.
Versions 2.7.x would save to the file server without issue.
OS version
Linux Mint 20.3 Cinnamon
Full System Info
App version
Release v2.8.0
No development versions have been installed or used.
Installation origin
Other
Installation origin (other sources)
mangadex-dl was initially installed via PyPI 3 versions ago (v.2.7.0 I believe). Updated to v2.8.0 today via the 'mangadex-dl --update' command. Had to manually update 'requests-doh' and 'requests' via PIP after update.
Reproducible command
mangadex-dl -lang "en" --save-as "cbz" --path "/mnt/W/Manga/Manga/" --group "all" https://mangadex.org/title/de9e3b62-eac5-4c0a-917d-ffccad694381/sometimes-even-reality-is-a-lieAdditional context
mangadex-dl --updateconsole output from today, including PIP requirements errors that required manual updates:requests-dohandrequeststhrew an incompatibility error (version mismatch) during the update. I had to update them manually usingpython3 -m pip install --force-reinstall requests==2.28.1andpython3 -m pip install --force-reinstall requests-doh==0.3.0/etc/fstab entry in Linux Mint for the file server:
//192.168.1.93/ga7pesh2 /mnt/W cifs username=x,password=xxxxxxxxxx,uid=1000,gid=1000,iocharset=utf8,rw,file_mode=0777,dir_mode=0777,sec=ntlmv2,nounix 0 0