id	summary	reporter	owner	description	type	status	priority	component	severity	resolution	keywords	cc	release
11127	"using of ""db.commit()"" make some problems"	ms1014	Ryan J Ollos	"Hello. 
I have to propose you to hear trac developers and to use @with_transaction instead db.commit() in plugin for trac 0.12. .commit() is a cause of ""Database is locked"" error.
Example of configuration: 
{{{
Linux debian 3.2.0-4-amd64 #1 SMP Debian 3.2.41-2 x86_64 GNU/Linux
------
Trac	0.12.3
Genshi	0.6
pysqlite	2.6.0
Python	2.7.3 (default, Jan 2 2013, 13:56:14) [GCC 4.7.2]
setuptools	0.6
SQLite	3.7.13
------
TracMasterTickets 	3.0.5dev
ddblocker 	N/A
Tracchildtickets 	2.5.2
}}}
I see this error, when I try to do ""UPDATE"" or ""DELETE"" in ITicketManupulator.validate_ticket or ITicketChangeListener.ticket_changed in my plugins. And it's gone when I had used @with_transaction in save() method in mastertickets/model.py. So I think commit() was a cause that bad interactions.

Thank you for your job. :)
"	enhancement	new	normal	MasterTicketsPlugin	normal				0.12