[Zope] NotSupportedError

Christian Theune ct@gocept.com
Wed, 6 Mar 2002 12:56:10 +0100


HarHar. <aehem> sorry.

You currently found out, that mysql is (on the tables *you* use) a nontransactional
database system (remember: ACID) but zope doesn't know that and tries to rollback 
because the zope transaction was aborted.

My Hint (no solution probably): Go and get a better database. (e.g. Postgresql)

On Wed, Mar 06, 2002 at 01:44:02PM +0200, alienoid wrote:
> Hello!
> I have such a strange error under RedHat 7.2 6 + zope 2.5.0 +
> MySQl-3.23.41 + MySQL-python-0.9.1
> 
> Site Error
> An error was encountered while publishing this resource.
> _mysql_exceptions.NotSupportedError
> Sorry, a site error occurred.
> Traceback (innermost last):
>   File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 150, in publish_module
>   File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 106, in publish
>   File /usr/local/zope/lib/python/Zope/__init__.py, line 177, in abort
>   File /usr/local/zope/lib/python/ZODB/Transaction.py, line 106, in abort
>   File /usr/local/zope/lib/python/Shared/DC/ZRDB/TM.py, line 54, in abort
>   File /usr/local/zope/lib/python/Products/ZMySQLDA/db.py, line 328, in _abort
> NotSupportedError: (1196, "Warning:  Some non-transactional changed tables couldn't be rolled back")
> 
> Please, help!
> 
> -- 
> Best regards,
>  alienoid                          mailto:alienoid@is.lg.ua

-- 
Christian Theune - ct@gocept.com
gocept gmbh & co.kg - schalaunische strasse 6 - 06366 koethen/anhalt
tel.+49 3496 3099112 - fax.+49 3496 3099118 mob. - 0178 48 33 981

reduce(lambda x,y:x+y,[chr(ord(x)^42) for x in 'zS^BED\nX_FOY\x0b'])