You are here: Foswiki>Tasks Web>Item12150 (06 Nov 2018, MichaelDaum)Edit Attach

Item12150: Crash in SQLite cache code

pencil
Priority: Urgent
Current State: Duplicate
Released In: 1.2.0
Target Release: minor
Applies To: Engine
Component: PageCache
Branches:
Reported By: GeorgeClark
Waiting For:
Last Change By: MichaelDaum
Created:

Reproducable: YES

DBD::SQLite::db do failed: near "Closed": syntax error at /usr/home/trunk.foswiki.org/core/lib/Foswiki/PageCache/DBI.pm line 271.
 at /usr/home/trunk.foswiki.org/core/lib/Foswiki/PageCache/DBI.pm line 271.
   Foswiki::PageCache::DBI::deletePage('Foswiki::PageCache::DBI::SQLite=HASH(0x9f67e8)', 'Tasks', 'CommentPlugin', '::trunk.foswiki.org::80::1::language=en::AUTHUSER=GeorgeClark...') called at /usr/home/trunk.foswiki.org/core/lib/Foswiki/PageCache.pm line 217
   Foswiki::PageCache::cachePage('Foswiki::PageCache::DBI::SQLite=HASH(0x9f67e8)', 'text/html', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN...') called at /usr/home/trunk.foswiki.org/core/lib/Foswiki.pm line 821
   Foswiki::writeCompletePage('Foswiki=HASH(0x9f6218)', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN...', 'view', 'text/html') called at /usr/home/trunk.foswiki.org/core/lib/Foswiki/UI/View.pm line 441
   Foswiki::UI::View::view('Foswiki=HASH(0x9f6218)') called at /usr/home/trunk.foswiki.org/core/lib/Foswiki/UI.pm line 316
   Foswiki::UI::__ANON__() called at /usr/local/lib/perl5/site_perl/5.10.1/Error.pm line 419
   eval {...} called at /usr/local/lib/perl5/site_perl/5.10.1/Error.pm line 411
   Error::subs::try('CODE(0x603c88)', 'HASH(0x9f5570)') called at /usr/home/trunk.foswiki.org/core/lib/Foswiki/UI.pm line 435
   Foswiki::UI::_execute('Foswiki::Request=HASH(0x9d9300)', 'CODE(0x671f70)', 'view', 1) called at /usr/home/trunk.foswiki.org/core/lib/Foswiki/UI.pm line 274
   Foswiki::UI::handleRequest('Foswiki::Request=HASH(0x9d9300)') called at /usr/home/trunk.foswiki.org/core/lib/Foswiki/Engine/CGI.pm line 41
   Foswiki::Engine::CGI::run('Foswiki::Engine::CGI=HASH(0x7896b0)') called at /home/trunk.foswiki.org/core/bin/view line 29.

-- GeorgeClark - 14 Oct 2012

I just got it just now

Attention

Error saving topic
During save of Tasks.Item11521 an error was found by the version control system. Please notify your Foswiki.org development testing administrator.

DBD::SQLite::db do failed: database is locked at /usr/home/trunk.foswiki.org/core/lib/Foswiki/PageCache/DBI.pm line 451.
 at /usr/home/trunk.foswiki.org/core/lib/Foswiki/PageCache/DBI.pm line 451.
&#9;Foswiki::PageCache::DBI::fireDependency(&#39;Foswiki::PageCache::DBI::SQLite&#61;HASH(0xaaff20)&#39;, &#39;Tasks&#39;, &#39;Item11521&#39;) called at /usr/home/trunk.foswiki.org/core/lib/Foswiki/Meta.pm line 768
&#9;Foswiki::Meta::fireDependency(&#39;Foswiki::Meta&#61;HASH(0x1134aa8)&#39;) called at /usr/home/trunk.foswiki.org/core/lib/Foswiki/Meta.pm line 2053
&#9;Foswiki::Meta::&#95;&#95;ANON&#95;&#95;() called at /usr/local/lib/perl5/site&#95;perl/5.10.1/Error.pm line 433
&#9;Error::subs::try(&#39;CODE(0x114c120)&#39;, &#39;HASH(0x2006fb0)&#39;) called at /usr/home/trunk.foswiki.org/core/lib/Foswiki/Meta.pm line 2054
&#9;Foswiki::Meta::saveAs(&#39;Foswiki::Meta&#61;HASH(0x1134aa8)&#39;, &#39;Tasks&#39;, &#39;Item11521&#39;) called at /usr/home/trunk.foswiki.org/core/lib/Foswiki/Meta.pm line 1916
&#9;Foswiki::Meta::&#95;&#95;ANON&#95;&#95;() called at /usr/local/lib/perl5/site&#95;perl/5.10.1/Error.pm line 419
&#9;eval {...} called at /usr/local/lib/perl5/site&#95;perl/5.10.1/Error.pm line 411
&#9;Error::subs::try(&#39;CODE(0x11825d8)&#39;, &#39;HASH(0x1ef5d90)&#39;) called at /usr/home/trunk.foswiki.org/core/lib/Foswiki/Meta.pm line 1920
&#9;Foswiki::Meta::save(&#39;Foswiki::Meta&#61;HASH(0x1134aa8)&#39;) called at /usr/home/trunk.foswiki.org/core/lib/Foswiki/UI/Save.pm line 639
&#9;Foswiki::UI::Save::&#95;&#95;ANON&#95;&#95;() called at /usr/local/lib/perl5/site&#95;perl/5.10.1/Error.pm line 419
&#9;eval {...} called at /usr/local/lib/perl5/site&#95;perl/5.10.1/Error.pm line 411
&#9;Error::subs::try(&#39;CODE(0x1177ad8)&#39;, &#39;HASH(0x1134f58)&#39;) called at /usr/home/trunk.foswiki.org/core/lib/Foswiki/UI/Save.pm line 649
&#9;Foswiki::UI::Save::save(&#39;Foswiki&#61;HASH(0xaaf998)&#39;) called at /usr/home/trunk.foswiki.org/core/lib/Foswiki/UI.pm line 316
&#9;Foswiki::UI::&#95;&#95;ANON&#95;&#95;() called at /usr/local/lib/perl5/site&#95;perl/5.10.1/Error.pm line 419
&#9;eval {...} called at /usr/local/lib/perl5/site&#95;perl/5.10.1/Error.pm line 411
&#9;Error::subs::try(&#39;CODE(0x603c88)&#39;, &#39;HASH(0xaaf428)&#39;) called at /usr/home/trunk.foswiki.org/core/lib/Foswiki/UI.pm line 435
&#9;Foswiki::UI::&#95;execute(&#39;Foswiki::Request&#61;HASH(0xa6f4b0)&#39;, &#39;CODE(0xaa88f8)&#39;, &#39;save&#39;, 1) called at /usr/home/trunk.foswiki.org/core/lib/Foswiki/UI.pm line 274
&#9;Foswiki::UI::handleRequest(&#39;Foswiki::Request&#61;HASH(0xa6f4b0)&#39;) called at /usr/home/trunk.foswiki.org/core/lib/Foswiki/Engine/CGI.pm line 41
&#9;Foswiki::Engine::CGI::run(&#39;Foswiki::Engine::CGI&#61;HASH(0x7833b0)&#39;) called

Go back in your browser and save your changes locally. 

-- PaulHarvey - 17 Nov 2012

Duplicates Item12258. Reopen if not.

-- MichaelDaum - 21 Nov 2012

ItemTemplate edit

Summary Crash in SQLite cache code
ReportedBy GeorgeClark
Codebase trunk
SVN Range
AppliesTo Engine
Component PageCache
Priority Urgent
CurrentState Duplicate
WaitingFor
Checkins
TargetRelease minor
ReleasedIn 1.2.0
CheckinsOnBranches
trunkCheckins
Release01x01Checkins
Topic revision: r4 - 06 Nov 2018, MichaelDaum
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