ArchivedUltimaScraper icon indicating copy to clipboard operation
ArchivedUltimaScraper copied to clipboard

Change of download_directories and metadata_directories : (sqlite3.OperationalError) database is locked

Open ephedan opened this issue 1 year ago • 4 comments

Hello.

I contact you because I have an error when I change the directory where the downloaded content is stored and the metadata content is stored. I encounter the error below:

(sqlite3.OperationalError) database is locked
[SQL:
CREATE TABLE alembic_version (
         version_num VARCHAR(32) NOT NULL,
         CONSTRAINT alembic_version_pkc PRIMARY KEY (version_num)
)

]
(Background on this error at: https://sqlalche.me/e/20/e3q8)

Precision, the script runs under Debian 11 and the destination directory is a shared directory mounted from a NAS.

Thanks for your help.

ephedan avatar Mar 16 '23 13:03 ephedan

I forgot to specify that if I leave the default directory ('user_data/sites') of download_directories and the default directory ('user_data/sites') of metadata_directories, everything works perfectly.

ephedan avatar Mar 16 '23 13:03 ephedan

Appreciate this is quite an old post, but for anyone Googling, I was able to get past this by adding the 'nobrl' option to my CIFS mount. For example: sudo mount -t cifs //server/share /mnt/share -o username=user,password=password,nobrl

Or as part of an fstab file: //server/share /mnt/share cifs username=user,password=password,nobrl 0 0

(This is only an example - always use an .smbcredentials file)

zzfet avatar Jul 09 '23 20:07 zzfet

Good morning @zzazzcdts Thanks for your help. This was very valuable to me. I had been going around in circles for a while despite my research. Good day.

ephedan avatar Jul 21 '23 10:07 ephedan

I am also having this issue when I change my download directories from the default.

(sqlite3.OperationalError) database is locked [SQL: PRAGMA main.table_info("alembic_version")] (Background on this error at: https://sqlalche.me/e/20/e3q8)

yommish avatar Oct 16 '23 00:10 yommish