Problem with identity management and db transactions

[fabian...@googlemail.com]

Hello,

while using identity management with rev. 403 and mysql as db I
suddenly get the following error. I have added the user with both
catwalk and the shell, it's the same error after I have logged in and
want to display my secured page.

[...]
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")

Any help is appreciated.

Regards,

Fabian

[Kevin Dangoor]

Hi,

Does your database have both InnoDB tables and MyISAM tables? That's
what the error sounds like to me. That's a tricky one... That would
mean that you need to isolate your InnoDB changes from your MyISAM
changes. hmm...

Kevin

--
Kevin Dangoor
Author of the Zesty News RSS newsreader

email: k...@blazingthings.com
company: http://www.BlazingThings.com
blog: http://www.BlueSkyOnMars.com

[fabian...@googlemail.com]

Hello Kevin,

no, they are all myisam tables no innodb at all. It seems that I'm not
the only one having that problem. Some tables have a fixed row format,
most have a dynamic row format, if that does mean anything. Anything
else I can check?

Regards,

Fabian

[Kevin Dangoor]

Hi Fabian,

OK. That may be an easier thing to deal with.

With the implicit transactions in 0.9, if your code hits an exception
it will try to rollback. Of course, if all you have are MyISAM tables,
you *can't* rollback... hence the error.

Personally, I wouldn't run a database without transactions, but that's
just me. (I know that some folks use MyISAM to do full-text indexing
as well.)

The solution for an all-MyISAM database would probably be to turn
implicit transactions off. Would you mind submitting a ticket to add
the ability to do that? (http://trac.turbogears.org)

Thanks,
Kevin

[fabian...@googlemail.com]

Hello Kevin,

thanks for your support, I have added a ticket for the problem.

With best regards,

Fabian