[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.&nbsp; Anyone =
have an
idea what could be causing it?&nbsp; Is there something I need to do =
with Mysql?&nbsp;
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'>&nbsp;</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'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</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, &quot;Warning:&nbsp; Some
non-transactional changed tables couldn't be rolled =
back&quot;)</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&lt;!--</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'>&nbsp; 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'>&nbsp; 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'>&nbsp; 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'>&nbsp;&nbsp;&nbsp; (Object: )</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp; 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'>&nbsp; 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'>&nbsp; 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'>&nbsp; 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'>&nbsp; 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'>&nbsp; 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'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</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'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</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'>&nbsp;</span></font></p>

</div>

</body>

</html>
=00
------_=_NextPart_001_01C1F5EE.A86B2D70--