Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
shorttack opened this issue May 11, 2020 · 11 comments
Open

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

shorttack opened this issue May 11, 2020 · 11 comments
Labels
1.Type - Defect Reported issue is a defect. 3.Component - FAHClient Reported issue relates to FAHClient. 3.Component - Installer Reported issue relates to the installer. 4.OS - Debian Reported issue occurs on Debian based OS (Debian, Mint, Ubuntu). 4.OS - Fedora Reported issue occurs on Fedora based OS (Fedora, Red Hat, CentOS).

Comments

@shorttack
Copy link

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 shorttack added 3.Component - FAHClient Reported issue relates to FAHClient. 3.Component - Installer Reported issue relates to the installer. Linux labels May 11, 2020
@dmc5179 dmc5179 added the 1.Type - Defect Reported issue is a defect. label May 17, 2020
@dmc5179
Copy link

dmc5179 commented May 17, 2020

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.

@PantherX PantherX added 4.OS - Debian Reported issue occurs on Debian based OS (Debian, Mint, Ubuntu). 4.OS - Fedora Reported issue occurs on Fedora based OS (Fedora, Red Hat, CentOS). and removed Linux labels May 22, 2020
@laggarcia
Copy link

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

@gunnrryy
Copy link

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
Copy link
Contributor

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

@PeterDaveHello
Copy link

PeterDaveHello commented Nov 21, 2020

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
Copy link

ojullien commented Dec 3, 2020

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

@cole8888
Copy link

cole8888 commented Dec 6, 2020

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
Copy link

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
Copy link

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

@cybr-dev
Copy link

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
Copy link

xdrig commented Jan 2, 2022

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
1.Type - Defect Reported issue is a defect. 3.Component - FAHClient Reported issue relates to FAHClient. 3.Component - Installer Reported issue relates to the installer. 4.OS - Debian Reported issue occurs on Debian based OS (Debian, Mint, Ubuntu). 4.OS - Fedora Reported issue occurs on Fedora based OS (Fedora, Red Hat, CentOS).
Projects
None yet
Development

No branches or pull requests