search

FoldingAtHome / fah-issues

49 stars 9 forks source link

Linux 7.6.13 Error executing: 'PRAGMA synchronous=NORMAL #1473

Open shorttack opened 4 years ago

shorttack commented 4 years ago

Installed console and client 7.6.13 (DEB Linux) over 7.5.1 and restarted client. Console showed folding picked up and continued. Log, however, was hung and contained only the following fragment:

Log Started 2020-05-11T15:01:53Z 15:01:53:Trying to access database... \x1b[91m15:02:23:ERROR:Exception: Error executing: 'PRAGMA synchronous=NORMAL': database is locked\x1b[0m

This issue corrects itself with a reboot.

A guess based on the symptoms would be the install fails to close all the running FAHClient files before installing and restarting. The FAHClient cannot open the already open file. Perhaps a pause-to-close-complete is missing on install.

dmc5179 commented 4 years ago

Certainly the RPM version does not appear to have anything in the %pre section which would stop the running service before upgrading if the service exists and is running. That's probably a good thing to have.

laggarcia commented 4 years ago

I am seeing the same issue on Fedora 32 package (fahclient-7.5.1-1.x86_64).

gunnrryy commented 4 years ago

just did a fresh install on Ubuntu 18.04..

did ~$ -> top FAHClient running and using full resources..

out of curiosity to know what it is running, did sudo /etc/init.d/FAHClient log

and got the error

Trying to access database... ERROR: Exception: Error executing: 'PRAGMA synchronous=NORMAL': database is locked

am I missing anything ?

PantherX commented 3 years ago

@shorttack, @laggarcia & @gunnrryy does this issue still happen with the latest stable release, V7.6.21 (https://foldingathome.org/alternative-downloads/)?

PeterDaveHello commented 3 years ago

I have the same problem on CentOS 8 with FAHClient v7.6.21, not like the original post, reboot here is not helping. I also tried to delete /var/lib/fahclient and remove, install FAHclient again, but the problem still exist.

ojullien commented 3 years ago

Hello,

cole8888 commented 3 years ago

Also having this issue on Ubuntu 20.04. My CPU is folding fine, but the GPU says disabled and this shows up in the log.

Edit: I solved this by:

  1. Uninstalling v7.6.21
  2. Installing v7.6.8
  3. Executing: wget https://fah-web.stanford.edu/file-releases/public/GPUs.txt sudo mv GPUs.txt /var/lib/fahclient/ sudo service FAHClient restart
  4. Configuring the client using the fahcontrol GUI and adding the GPU slot.
  5. Installing v7.6.21 (or whatever the latest version is in the future)

Hope this helps. I'm not exactly sure why this worked out for me. For future reference I have a RTX 2060S and am using driver version 455.45.01. Step 3 may not be necessary, but I happened to do it while troubleshooting so I'm not sure if it is needed.

sirnewton01 commented 3 years ago

I'm getting this problem too. Installing the latest fahclient 7.6.21 didn't fix it. Is there an easy way to clear out the database lock?

cybr-dev commented 2 years ago

I am having the same problem on fresh install Ubuntu 20.04 on ARM without desktop. And the latest FAH client

cybr-dev commented 2 years ago

Fixed it! This error might indicate that there are running 2 FAHClient processes in parralel. Just reboot or kill one of the FAHClient processes.

xdrig commented 2 years ago

Maybe you started fah multiple times, run: sudo dpkg -P fahclient then reinstall fah client. Then run sudo /etc/init.d/FAHclient log, if you see log then FAH is already started, you don't need to start it again.