Edgewall Software
Modify

Opened 15 years ago

Closed 14 years ago

#8688 closed defect (cantfix)

Trac internal error "OperationalError: cannot commit - no transaction is active"

Reported by: jsinger@… Owned by:
Priority: normal Milestone:
Component: database backend Version: 0.11.5
Severity: major Keywords: sqlite needinfo
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description

I upgraded apache to 2.2.13 and Trac from 0.11b2 to 0.11.5.

After this, my system does not work any more. The list of trac projects is still automatically generated, however, as soon as I try to open open one of the project pages I get the following message:

Trac detected an internal error: OperationalError: cannot commit - no transaction is active

The action that triggered the error was: GET: /

It seems that Trac has difficulties with the database. Attempts to upgrade with trac-admin result in: Database is up to date, no upgrade necessary.

Attachments (2)

trac11.5_bugreport (7.0 KB ) - added by jsinger@… 15 years ago.
Report from Trac when accessing site
Trac_error_jks_091214.txt (7.0 KB ) - added by jsinger@… 15 years ago.
detailed error message for failure to sync with svn repository

Download all attachments as: .zip

Change History (9)

by jsinger@…, 15 years ago

Attachment: trac11.5_bugreport added

Report from Trac when accessing site

comment:1 by Christian Boos, 15 years ago

Keywords: needinfo added

Quite strange indeed, never seen this.

Maybe you have old plugins which somehow badly interfere?

Try disabling all plugins and see if the problem persists.

by jsinger@…, 15 years ago

Attachment: Trac_error_jks_091214.txt added

detailed error message for failure to sync with svn repository

comment:2 by jsinger@…, 15 years ago

The problem seemed to have disappeared for a while, but now it back: After I submitted some documents for a project with svn, trac suddenly stopped working again. Removing this project from trac does not help: The error appears in all projects.

(cf. attached file Trac_error_jks_091214.txt for detailed error message)

comment:3 by Christian Boos, 15 years ago

You're using the default pysqlite bundled with your stock python… Maybe it uses a buggy SQLite, I remember having seen some reports about Apple-specific changes to SQLite that were not so fine (can't remember the exact thing though).

Try this from your Python command line:

>>> import sqlite3
>>> c = sqlite3.Connection("ddd")
>>> c.commit()

This shouldn't raise an error.

So I would advise you to upgrade PySqlite, and use the amalgamation build to get the latest SQLite.

in reply to:  3 ; comment:4 by anonymous, 15 years ago

Actually, I was not using the stock pysqlite, but a newer one - and the above test just worked fine.

Nevertheless, I did upgrade to newer versions of sqlite3, pysqlite, subversion and recompiled mod_python. As a result the error seems to have disappeared once more - but I already did believe last time that it had gone. System Information Trac: 0.11.5 Python: 2.5.2 (r252:60911, Apr 12 2008, 11:53:13) [GCC 4.0.1 (Apple Computer, Inc. build 5370)] setuptools: 0.6c9 SQLite: 3.6.21 pysqlite: 2.5.6 Genshi: 0.5.1 mod_python: 3.3.1 Subversion: 1.6.6 (r40053) jQuery: 1.2.6

in reply to:  4 ; comment:5 by Christian Boos, 15 years ago

Replying to anonymous:

SQLite: 3.6.21 pysqlite: 2.5.6

That's as recent as you can get, but it's not what was written in Trac_error_jks_091214.txt. Could it be a server install issue which ends up in your mod_python not using that pysqlite 2.5.6 extension?

Last edited 14 years ago by Christian Boos (previous) (diff)

in reply to:  5 comment:6 by anonymous, 15 years ago

Replying to cboos:

Replying to anonymous:

SQLite: 3.6.21 pysqlite: 2.5.6

That's as recent as you can get, but it's not what was written in Trac_error_jks_091214.txt. Could it be a server install issue which ends up in your mod_python not using that pysqlite 2.5.6 extension?

No - I just upgraded today, after your recommendation - the version numbers in the attached file are correct and refer to the installation as it was when the error occured.

Last edited 14 years ago by Christian Boos (previous) (diff)

comment:7 by Christian Boos, 14 years ago

Component: generaldatabase backend
Keywords: sqlite added; database internal error removed
Resolution: cantfix
Status: newclosed

No feedback, closing.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The ticket will remain with no owner.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from (none) to the specified user.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.