Warning: Can't synchronize with repository "(default)" (Unsupported version control system "svn": No module named svn). Look in the Trac log for more information.

Ticket #306 (closed defect: fixed)

Opened 14 years ago

Last modified 12 years ago

Implicit transactions won't work on mysql with MyISAM tables (e. g. in identity management)

Reported by: fabian.erbach@… Owned by: anonymous
Priority: normal Milestone: 0.9
Component: TurboGears Version:
Severity: normal Keywords: transactions, mysql, myisam, identity
Cc:

Description

The usage of implicit transactions (e. g. in identitiy management) in 0.9 causes an exception run on a mysql database with MyISAM tables only (tested on rev. 410).

The error message is:

[...]

File "/home/faer/workspace/turbogears/turbogears/database.py", line

79, in rollback

self.threadingLocal.connection.rollback()

File

"/usr/lib/python2.4/site-packages/SQLObject-0.7.0-py2.4.egg/sqlobject/dbconnection.py", line 772, in rollback

self._connection.rollback()

NotSupportedError?: (1196, "Warning: Some non-transactional changed tables couldn't be rolled back")

As a workaround you should use innodb tables with mysql.

Change History

comment:1 Changed 14 years ago by slate

Isam doesn't support transactions. The solution see: http://trac.turbogears.org/turbogears/wiki/MySql

comment:2 Changed 14 years ago by kevin

  • Status changed from new to closed
  • Resolution set to fixed

You can now put notrans_ in front of the dburi to turn transactions off for that connection. [417]

Note: See TracTickets for help on using tickets.