Re: monotone: sqlite database is locked... pls help

Marcel van der Boom <[email protected]> Tue, 19 May 2009 09:53:08 +0200
Newsgroups gmane.comp.cms.xaraya.devel
Message-ID <[email protected]>
Ok, no 'weird stuff' in there.

Unfortunately, you'll have to dig deeper now. Things you could try:

1. is there really no other process using the modules.db file? (it  
says it's locked for a reason, we just dont know what it is. On  
reading the db it fails to acquire a shared lock, usually signalling  
something else is (supposed to be) writing to it)
2. cp modules.db to modules2.db and try again
3. Ask on monotone irc/mailing list/forum

marcel


On 19 mei 2009, at 09:36, Banzai wrote:

> sorry... wrong command...
>
> here's the debug msg
>
> mtn041: loading lua hook note_mtn_startup
>
> mtn041: executing command 'pull'
>
> mtn041: matched URI path: 'mt.xaraya.com'
> mtn041: executing SQL 'SELECT sql FROM sqlite_master WHERE (type =
> 'table' OR type = 'index') AND sql IS NOT NULL AND name not like
> 'sqlite_stat%' ORDER BY name'
> mtn041: sqlite error: 5: database is locked
> mtn041: schema_migration.cc:101: detected error 'E(false)' violated
> mtn041: saving current work set: 4 items
> mtn041: finished saving work set
> mtn041: contents of work set:
> mtn041: Current work set: 4 items
> mtn041: ----- begin 'system_flavour' (in virtual void
> sanity::initialize(int, char**, const char*), at sanity.cc:75)
> mtn041: Linux 2.6.28-11-generic #42-Ubuntu SMP Fri Apr 17 01:57:59 UTC
> 2009 i686
> mtn041: -----   end 'system_flavour' (in virtual void
> sanity::initialize(int, char**, const char*), at sanity.cc:75)
> mtn041: ----- begin 'cmdline_string' (in virtual void
> sanity::initialize(int, char**, const char*), at sanity.cc:89)
> mtn041: 'mtn041', '-d', 'modules.db', 'pull', 'mt.xaraya.com',
> 'com.xaraya.modules.*', '--debug'
> mtn041: -----   end 'cmdline_string' (in virtual void
> sanity::initialize(int, char**, const char*), at sanity.cc:89)
> mtn041: ----- begin 'string(lc_all)' (in virtual void
> sanity::initialize(int, char**, const char*), at sanity.cc:94)
> mtn041: en_US.UTF-8
> mtn041: -----   end 'string(lc_all)' (in virtual void
> sanity::initialize(int, char**, const char*), at sanity.cc:94)
> mtn041: ----- begin 'full_version_string' (in virtual void
> mtn_sanity::initialize(int, char**, const char*), at mtn-sanity.cc:23)
> mtn041: monotone 0.41 (base revision:
> 9b264ec9247ce99cd1fdc5293e869c1a60b01c4c)
> mtn041: Running on          : Linux 2.6.28-11-generic #42-Ubuntu SMP  
> Fri
> Apr 17 01:57:59 UTC 2009 i686
> mtn041: C++ compiler        : GNU C++ version 4.3.1
> mtn041: C++ standard library: GNU libstdc++ version 20080814
> mtn041: Boost version       : 1_34_1
> mtn041: Changes since base revision:
> mtn041: unknown
> mtn041: -----   end 'full_version_string' (in virtual void
> mtn_sanity::initialize(int, char**, const char*), at mtn-sanity.cc:23)
> mtn041: statement cache statistics
> mtn041: prepared 1 statements
> mtn041: 0 executions of SELECT domain, name, value FROM db_vars
> mtn041: error: sqlite error: database is locked
>
> Banzai
>
> Banzai wrote:
>> xxx@xxx-desktop:~/Downloads/webdev/monotone$ mtn041 --debug
>>
> ---------- snip 8< --- snip ----- 8< -------------
>>
>> Marcel van der Boom wrote:
>>> If you run mtn with the --debug switch and save the output  
>>> somewhere,
>>> perhaps that does give some insight.
>>>
>>> marcel
> _______________________________________________
> Xaraya_devel mailing list
> [email protected]
> http://xaraya.com/mailman/listinfo/xaraya_devel

-- 
Marcel van der Boom  -- http://hsdev.com/mvdb.vcf
HS-Development BV    -- http://www.hsdev.com
So! web applications -- http://make-it-so.info
Cobra Replica build  -- http://cobra.mrblog.nl

_______________________________________________
Xaraya_devel mailing list
[email protected]
http://xaraya.com/mailman/listinfo/xaraya_devel