[Zope] Transaction Problems with ZMySQLDA and SQLSession
Chris A. Bruce
cbruce@sleeter.com
Tue, 7 May 2002 10:43:11 -0700
This is a multi-part message in MIME format.
------_=_NextPart_001_01C1F5EE.A86B2D70
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
I randomly get the following exception. Anyone have an idea what could
be causing it? Is there something I need to do with Mysql? The pages
all have a call to SQLSession.
=20
SQLSession Version: SQLSession-0-3-0
Mysql Version: 3.23.41
ZMySQLDA Version: ZMySQLDA 2.0.7
=20
=20
=20
=20
Error Type: NotSupportedError
Error Value (1196, "Warning: Some non-transactional changed tables
couldn't be rolled back")
=20
<!--
Traceback (innermost last):
File /usr/local/Zope-2.4/lib/python/ZPublisher/Publish.py, line 223,
in publish_module
File /usr/local/Zope-2.4/lib/python/ZPublisher/Publish.py, line 187,
in publish
File /usr/local/Zope-2.4/lib/python/Zope/__init__.py, line 226, in
zpublisher_exception_hook
(Object: )
File /usr/local/Zope-2.4/lib/python/ZPublisher/Publish.py, line 160,
in publish
File /usr/local/Zope-2.4/lib/python/Zope/__init__.py, line 235, in
begin
File /usr/local/Zope-2.4/lib/python/ZODB/Transaction.py, line 203, in
begin
File /usr/local/Zope-2.4/lib/python/ZODB/Transaction.py, line 179, in
abort
File /usr/local/Zope-2.4/lib/python/Shared/DC/ZRDB/TM.py, line 126, in
abort
File /usr/local/Zope-2.4/lib/python/Products/ZMySQLDA/db.py, line 328,
in _abort
NotSupportedError: (see above)
=20
=20
=20
=20
Thanks,
=20
=20
Chris
=20
------_=_NextPart_001_01C1F5EE.A86B2D70
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html>
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>I randomly get the following exception. Anyone =
have an
idea what could be causing it? Is there something I need to do =
with Mysql?
The pages all have a call to SQLSession.</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>SQLSession Version: =
SQLSession-0-3-0</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Mysql Version: 3.23.41</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>ZMySQLDA Version: ZMySQLDA 2.0.7</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Error Type: NotSupportedError</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Error Value (1196, "Warning: Some
non-transactional changed tables couldn't be rolled =
back")</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><!--</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Traceback (innermost last):</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> File
/usr/local/Zope-2.4/lib/python/ZPublisher/Publish.py, line 223, in =
publish_module</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> File
/usr/local/Zope-2.4/lib/python/ZPublisher/Publish.py, line 187, in =
publish</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> File =
/usr/local/Zope-2.4/lib/python/Zope/__init__.py,
line 226, in zpublisher_exception_hook</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> (Object: )</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> File
/usr/local/Zope-2.4/lib/python/ZPublisher/Publish.py, line 160, in =
publish</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> File =
/usr/local/Zope-2.4/lib/python/Zope/__init__.py,
line 235, in begin</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> File
/usr/local/Zope-2.4/lib/python/ZODB/Transaction.py, line 203, in =
begin</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> File
/usr/local/Zope-2.4/lib/python/ZODB/Transaction.py, line 179, in =
abort</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> File =
/usr/local/Zope-2.4/lib/python/Shared/DC/ZRDB/TM.py,
line 126, in abort</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> File
/usr/local/Zope-2.4/lib/python/Products/ZMySQLDA/db.py, line 328, in =
_abort</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>NotSupportedError: (see above)</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Thanks,</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Chris</span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'> </span></font></p>
</div>
</body>
</html>
=00
------_=_NextPart_001_01C1F5EE.A86B2D70--