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. `db.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