Item12150: Crash in SQLite cache code

Created:

• Visit http://trunk.foswiki.org/Tasks/CommentPlugin
• Click the "Show Closed and No Action button"
• Click the "Current State / Waiting for" column to sort the table

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.
	Foswiki::PageCache::DBI::fireDependency('Foswiki::PageCache::DBI::SQLite=HASH(0xaaff20)', 'Tasks', 'Item11521') called at /usr/home/trunk.foswiki.org/core/lib/Foswiki/Meta.pm line 768
	Foswiki::Meta::fireDependency('Foswiki::Meta=HASH(0x1134aa8)') called at /usr/home/trunk.foswiki.org/core/lib/Foswiki/Meta.pm line 2053
	Foswiki::Meta::__ANON__() called at /usr/local/lib/perl5/site_perl/5.10.1/Error.pm line 433
	Error::subs::try('CODE(0x114c120)', 'HASH(0x2006fb0)') called at /usr/home/trunk.foswiki.org/core/lib/Foswiki/Meta.pm line 2054
	Foswiki::Meta::saveAs('Foswiki::Meta=HASH(0x1134aa8)', 'Tasks', 'Item11521') called at /usr/home/trunk.foswiki.org/core/lib/Foswiki/Meta.pm line 1916
	Foswiki::Meta::__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(0x11825d8)', 'HASH(0x1ef5d90)') called at /usr/home/trunk.foswiki.org/core/lib/Foswiki/Meta.pm line 1920
	Foswiki::Meta::save('Foswiki::Meta=HASH(0x1134aa8)') called at /usr/home/trunk.foswiki.org/core/lib/Foswiki/UI/Save.pm line 639
	Foswiki::UI::Save::__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(0x1177ad8)', 'HASH(0x1134f58)') called at /usr/home/trunk.foswiki.org/core/lib/Foswiki/UI/Save.pm line 649
	Foswiki::UI::Save::save('Foswiki=HASH(0xaaf998)') 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(0xaaf428)') called at /usr/home/trunk.foswiki.org/core/lib/Foswiki/UI.pm line 435
	Foswiki::UI::_execute('Foswiki::Request=HASH(0xa6f4b0)', 'CODE(0xaa88f8)', 'save', 1) called at /usr/home/trunk.foswiki.org/core/lib/Foswiki/UI.pm line 274
	Foswiki::UI::handleRequest('Foswiki::Request=HASH(0xa6f4b0)') called at /usr/home/trunk.foswiki.org/core/lib/Foswiki/Engine/CGI.pm line 41
	Foswiki::Engine::CGI::run('Foswiki::Engine::CGI=HASH(0x7833b0)') called

Go back in your browser and save your changes locally. 

-- PaulHarvey - 17 Nov 2012

Duplicates Item12258. Reopen if not.

-- MichaelDaum - 21 Nov 2012