You are here: Foswiki>Tasks Web>Item13537 (12 Jul 2019, BeatDoebeli)Edit Attach

Item13537: Cache failures on

Priority: Normal
Current State: No Action Required
Released In: n/a
Target Release: n/a
Applies To: Engine
Component: PageCache
Reported By: GeorgeClark
Waiting For: MichaelDaum
Last Change By: BeatDoebeli
Edited the SKIN setting in SitePreferences. Save hangs - one occasion, it timed out in fcgi.

Other window reported the following error:

rollback ineffective with AutoCommit enabled at /usr/home/ line 115.

-- GeorgeClark - 18 Jul 2015

During the time of the failure there were a large number of errors in the apache log, all similar to:

[Sat Jul 18 16:12:18.260038 2015] [fcgid:warn] [pid 17206] [client] mod_fcgid: stderr: ERROR: unable to create tables in Foswiki::PageCache::DBI: database is locked, referer:
[Sat Jul 18 16:12:18.260077 2015] [fcgid:warn] [pid 17206] [client] mod_fcgid: stderr: DBD::SQLite::db do failed: database is locked [for Statement "      create table foswiki_cache_pages (, referer:
[Sat Jul 18 16:12:18.260081 2015] [fcgid:warn] [pid 17206] [client] mod_fcgid: stderr:         topic varchar(255),, referer:
[Sat Jul 18 16:12:18.260085 2015] [fcgid:warn] [pid 17206] [client] mod_fcgid: stderr:         variation varchar(1024),, referer:
[Sat Jul 18 16:12:18.260088 2015] [fcgid:warn] [pid 17206] [client] mod_fcgid: stderr:         md5 char(32),, referer:
[Sat Jul 18 16:12:18.260091 2015] [fcgid:warn] [pid 17206] [client] mod_fcgid: stderr:         contenttype varchar(255),, referer:
[Sat Jul 18 16:12:18.260095 2015] [fcgid:warn] [pid 17206] [client] mod_fcgid: stderr:         lastmodified varchar(255),, referer:
[Sat Jul 18 16:12:18.260098 2015] [fcgid:warn] [pid 17206] [client] mod_fcgid: stderr:         etag varchar(255),, referer:
[Sat Jul 18 16:12:18.260101 2015] [fcgid:warn] [pid 17206] [client] mod_fcgid: stderr:         status int,, referer:
[Sat Jul 18 16:12:18.260104 2015] [fcgid:warn] [pid 17206] [client] mod_fcgid: stderr:         location varchar(255),, referer:
[Sat Jul 18 16:12:18.260107 2015] [fcgid:warn] [pid 17206] [client] mod_fcgid: stderr:         expire int,, referer:
[Sat Jul 18 16:12:18.260111 2015] [fcgid:warn] [pid 17206] [client] mod_fcgid: stderr:         isdirty int, referer:
[Sat Jul 18 16:12:18.260114 2015] [fcgid:warn] [pid 17206] [client] mod_fcgid: stderr:   ), referer:
[Sat Jul 18 16:12:18.260117 2015] [fcgid:warn] [pid 17206] [client] mod_fcgid: stderr: "] at /usr/home/, referer:
[Sat Jul 18 16:12:18.267165 2015] [fcgid:warn] [pid 17206] [client] mod_fcgid: stderr: ki/PageCache/ line 599., referer:

-- GeorgeClark - 18 Jul 2015

Yes I've experienced the same editing SitePreferences. Save takes so long because all of the cache is invalidated and that takes probably too long for apache as it is configured on So it tries to kill the fcgi backend being busy leaving a stale lock on behind on the sqlite. Maybe using a mysql store for the cache metadata works out better. We surely need to investigate whether a total cache invalidation editing SitePreferences is so inefficient.

The following processes try to rebuild the cache but run against the hanging lock. Only way to recover is to delete the sqlite.db file on disk.

-- MichaelDaum - 18 Jul 2015

Downgraded to Normal.

-- GeorgeClark - 24 Aug 2015

Problem still exists wink

-- BeatDoebeli - 12 Jul 2019 - 16:29

ItemTemplate edit

Summary Cache failures on
ReportedBy GeorgeClark
Codebase 2.0.0
SVN Range
AppliesTo Engine
Component PageCache
Priority Normal
CurrentState No Action Required
WaitingFor MichaelDaum
TargetRelease n/a
ReleasedIn n/a
Topic revision: r5 - 12 Jul 2019, BeatDoebeli - This page was cached on 05 Jun 2020 - 23:48.

The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy