murrayo / yape

yet another pButtons extractor
MIT License
11 stars 7 forks source link

sqlite3.OperationalError: database is locked #21

Closed waltgh closed 4 years ago

waltgh commented 4 years ago

Is anyone else receiving a database locked message on Window 10 in Docker when trying to load the data into a SQLITE database file?

I mounted my c: drive as a shared drive because I cannot change my firewall to allow Docker direct access. The sqlite file is created but nothing is written to the file. I have tested opening and writing to a text file in another Docker container. Running the normal extract creates all of the files expected.

How I am creating my shared drive and mounting it (dockeruser is a local user): net share C=C:\ /grant:"dockeruser",FULL /CACHE:None

docker volume create --driver local --opt type=cifs --opt device=//Farwlf16u7l9/C/dockerdata --opt o=user=dockeruser,domain=.,password=docker4pass,vers=3.02 --name dockerdata

docker container run --rm -v dockerdata:/data yape/yape --filedb /data/pbuttons.db /data/qdlsp0155_EOC_20181108_103239_30mins.html

waltgh commented 4 years ago

I was able to solve this issue by using mount in the docker run command. There is no need to create a docker volume when using the mount command.

Example command (assumes you are in the same location as the pButtons file): docker container run --rm --mount type=bind,source=$pwd,target=/mnt/data yape/yape --filedb /mnt/data/pbuttons.db /mnt/data/qdlsp0155_EOC_20200112_000100_24hours_30sec.html