Timeline fails due to SQL errors

[PBruin]

Ticket changes, Ticket details event provider failed:

OperationalError: cannot commit transaction - SQL statements in progress

When I tried loading the timeline I got this error. Some of the actions I did before this occured:

• I added new user using the register plugin
• Added his permissions using the admin module
• Added new wiki page

I manage to get the timeline to work again by loading it without ticket information and then adding it again. Before that I did restart apache but it did not solve the problem.

I have had this happen to me before and seem to recall that I also added some permissions around that time. I solved it the by dumping the database and reloading it.

Some system info:

• WinXP
• Apache
• SqLite 3
• trac r3025

[PBruin]

It just happened again. I again managed to solve it by using this link on the page:

 /trac/timeline?milestone=on&changeset=on&wiki=on

After that I added the ticket details and after that ticket changes.

Also to be sure I update my install to the latest version. Will keep you posted if it happens again.

Could it have something to do with a the post-commit hook that imports messages to tickets?

[Christian Boos]

Which version of the PySqlite bindings for SQLite are you using?

[PBruin]

I am using the following version:

pysqlite-2.0.5.win32-py2.3.exe

[anonymous]

I think this is fixed in r3026.

After I updated to the last revision I did not see this problem anymore. But when I reverted to r3022 due to unicode related errors I got the error back (after some time). Restarting apache did not solve the problem. However updating to r3026 solved this problem for now.

Will close the ticket for now as I think it is solved.

[Christian Boos]

I think that this was actually a duplicate of #2902.