fah-issues icon indicating copy to clipboard operation
fah-issues copied to clipboard

Linux 7.6.13 Error executing: 'PRAGMA synchronous=NORMAL

Open shorttack opened this issue 5 years ago • 11 comments

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.

shorttack avatar May 11 '20 22:05 shorttack

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.

dmc5179 avatar May 17 '20 01:05 dmc5179

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

laggarcia avatar Jun 11 '20 04:06 laggarcia

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 ?

gunnrryy avatar Oct 17 '20 12:10 gunnrryy

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

PantherX avatar Nov 15 '20 03:11 PantherX

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.

PeterDaveHello avatar Nov 21 '20 11:11 PeterDaveHello

Hello,

  • same problem with FAHClient v7.6.21 on XUbuntu 20.10 Desktop ; kernel 5.8.0-32-generic ; 8cpu ; 64bits
  • works well on Ubuntu 20.10 Server; kernel 5.8.0-31-generic ; 2 cpu ; 64bits

ojullien avatar Dec 03 '20 13:12 ojullien

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.

cole8888 avatar Dec 06 '20 18:12 cole8888

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?

sirnewton01 avatar Dec 15 '20 13:12 sirnewton01

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

cybr-dev avatar Dec 26 '21 02:12 cybr-dev

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

cybr-dev avatar Dec 26 '21 02:12 cybr-dev

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.

xdrig avatar Jan 02 '22 09:01 xdrig