[Zope-DB] rollback mysql?

[Julián Muñoz]

I think that zope is Rollbacking because there has been and error in the
current zope transaction.

So this message is a warning: your database is going to be garbaged.
That's because some of your tables are not innodb (or another with
transaction capability).


On Tue, 6 Aug 2002, 3205 5361 1215 9784 wrote:

> Hello zope-db,
>
>   i have the following problem:
>
> ===
> Site Error
> An error was encountered while publishing this resource.
>
> _mysql_exceptions.NotSupportedError
>
> Sorry, a site error occurred.
>
> Traceback (innermost last):
>   File C:\www\notebook.hu\lib\python\ZPublisher\Publish.py, line 150, in =
publish_module
>   File C:\www\notebook.hu\lib\python\ZPublisher\Publish.py, line 106, in =
publish
>   File C:\www\notebook.hu\lib\python\Zope\__init__.py, line 178, in abort
>   File C:\www\notebook.hu\lib\python\ZODB\Transaction.py, line 107, in ab=
ort
>   File C:\www\notebook.hu\lib\python\Shared\DC\ZRDB\TM.py, line 60, in ab=
ort
>   File C:\www\notebook.hu\lib\python\Products\ZMySQLDA\db.py, line 328, i=
n _abort
> NotSupportedError: (1196, "Warning:  Some non-transactional changed table=
s couldn't be rolled back")
> ===
>
> mysql.log:
>
> 020806  8:27:41      76 Query       BEGIN
>                      76 Query       update opt_cpu set
>   opt_name='IntelR Pentiumt-4',
>   opt_short_name='P4'
>   where opt_id=13
>                      76 Query       ROLLBACK
>
>
>
> why is zope rollbacking?
> and whats all this?
> the mysql has the correct new data, but zope gives an error...
>
> thanks,
>
>
> k
>
>

-- 

      __o
    _ \<_
   (_)/(_)

Saludos de Julián
EA4ACL
-.-

Foro Wireless Madrid
http://opennetworks.rg3.net