Re: [Trac] - database is locked

2010-10-27 Thread Matthew Caron

The database is locked. Does anyone know how to solve this problem?


(1) Fewer concurrent users.
(2) A database that is not SQLite. :-)

(This is why we migrated to PostgreSQL from SQLite at my installation - 
Once we got over about 5 people using it, these became more and more 
frequent).


--
Matthew Caron
Build Engineer
Sixnet | www.sixnet.com
O +1 518 877 5173 Ext. 138
F +1 518 602 9209
matt.ca...@sixnet.com

--
You received this message because you are subscribed to the Google Groups "Trac 
Users" group.
To post to this group, send email to trac-us...@googlegroups.com.
To unsubscribe from this group, send email to 
trac-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/trac-users?hl=en.



Re: [Trac] - database is locked

2010-10-27 Thread Erik Andersson
http://tinyurl.com/2ewt5lu

You're using sqlite and a lot of plugins. How many users? Sqlite locks
database while reading from it so maybe shift to postgresql will be a
saviour?

Cheers / Erik

On Wed, Oct 27, 2010 at 6:22 AM, mark ardiente  wrote:

> Hi,
>
>  How to Reproduce 
>
> While doing a GET operation on `/`, Trac issued an internal error.
>
> ''(please provide additional details here)''
>
> Request parameters:
> {{{
> {}
> }}}
>
> User agent: `#USER_AGENT#`
>
>  System Information 
> || '''`Trac`''' || `0.12` ||
> || '''`CustomFieldAdmin`''' || `0.2.2` ||
> || '''`FullBlog`''' || `0.1.1-r7774` ||
> || '''`Genshi`''' || `0.6` ||
> || '''`mod_wsgi`''' || `3.2 (WSGIProcessGroup sites WSGIApplicationGroup
> %{GLOBAL})` ||
> || '''`Pygments`''' || `1.3.1` ||
> || '''`pysqlite`''' || `2.4.1` ||
> || '''`Python`''' || `2.6.5 (r265:79063, Mar 27 2010, 19:33:24) ` [[br]]
> `[GCC 4.1.2 20070626 (Red Hat 4.1.2-14)]` ||
> || '''`RPC`''' || `1.6.6` ||
> || '''`setuptools`''' || `0.6c11` ||
> || '''`SQLite`''' || `3.3.6` ||
> || '''`Subversion`''' || `1.4.2 (r22196)` ||
> || '''`jQuery`''' || `#JQUERY#` ||
>
>  Enabled Plugins 
> || '''`AdvancedTicketWorkflowPlugin`''' || `0.10dev-r7701` ||
> || '''`cc-selector`''' || `0.0.2` ||
> || '''`MilestoneCatcher`''' || `1.0.0` ||
> || '''`timingandestimationplugin`''' || `1.0.2` ||
> || '''`TracAccountManager`''' || `0.2.1dev-r7737` ||
> || '''`TracActiveDirectoryAuth`''' || `0.2.2` ||
> || '''`TracAddCommentMacro`''' || `0.3` ||
> || '''`TracBurndown`''' || `1.9.2` ||
> || '''`Tracchildtickets`''' || `1.0.2` ||
> || '''`TracCustomFieldAdmin`''' || `0.2.2` ||
> || '''`TracDateField`''' || `1.0.1` ||
> || '''`TracFullBlogPlugin`''' || `0.1.1-r7774` ||
> || '''`TracGanttCalendarPlugin`''' || `0.2` ||
> || '''`TracHTTPAuth`''' || `1.1` ||
> || '''`TracMacroPost`''' || `0.2` ||
> || '''`TracPermRedirect`''' || `2.0` ||
> || '''`TracWysiwyg`''' || `0.2-r7772` ||
> || '''`TracXMLRPC`''' || `1.6.6` ||
>
>  Python Traceback 
> {{{
> Traceback (most recent call last):
>   File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 513, in
> _dispatch_request
> dispatcher.dispatch(req)
>   File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 258, in
> dispatch
> req.session.save()
>   File "build/bdist.linux-x86_64/egg/trac/web/session.py", line 88, in save
> @self.env.with_transaction()
>   File "build/bdist.linux-x86_64/egg/trac/db/api.py", line 78, in
> transaction_wrapper
> ldb.commit()
> OperationalError: database is locked
> }}}
>
> The database is locked. Does anyone know how to solve this problem?
>
> --Mark
>
>
>  --
> You received this message because you are subscribed to the Google Groups
> "Trac Users" group.
> To post to this group, send email to trac-us...@googlegroups.com.
> To unsubscribe from this group, send email to
> trac-users+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/trac-users?hl=en.
>

-- 
You received this message because you are subscribed to the Google Groups "Trac 
Users" group.
To post to this group, send email to trac-us...@googlegroups.com.
To unsubscribe from this group, send email to 
trac-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/trac-users?hl=en.