Hi there,
running SA 0.5rc4, psycopg2 together with Postgres 7.4.22.
I am currently migrating a Zope application from SA 0.3 to SA 0.5.
While the migration worked for a bigger application I have an issue
with a smaller application. SA issues a "SAVEPOINT XXX" command although
Postgres 7.4 obviously does not support savepoints.
Andreas
aj...@suxmac2:~/Desktop cat out.txt
>
/local/HRS2/Devel/junga/tb-dev/parts/modules-svn/mediendb/versions.py(394)copyToWorkspace()
-> if generate_thumbnail:
(Pdb) n
>
/local/HRS2/Devel/junga/tb-dev/parts/modules-svn/mediendb/versions.py(395)copyToWorkspace()
-> self.generateThumbnail(lidx, 0, mediumObj)
(Pdb)
2009-01-02 10:15:01 INFO sqlalchemy.engine.base.Engine.0x...6110
SAVEPOINT sa_savepoint_1
2009-01-02 10:15:01 INFO sqlalchemy.engine.base.Engine.0x...6110 {}
ProgrammingError: <sqlalchemy.exc.ProgrammingError instance at
0x2aaaaee7b488>
>
/local/HRS2/Devel/junga/tb-dev/parts/modules-svn/mediendb/versions.py(395)copyToWorkspace()
-> self.generateThumbnail(lidx, 0, mediumObj)
(Pdb) where
/local/HRS2/Devel/junga/tb-dev/parts/zope2/lib/python/ZServer/PubCore/ZServerPublisher.py(23)__init__()
-> response=response)
/local/HRS2/Devel/junga/tb-dev/parts/products-svn/ZopeProfiler/MonkeyPatcher.py(35)__call__()
-> return self._function(*args,**kw)
/local/HRS2/Devel/junga/tb-dev/parts/products-svn/ZopeProfiler/ZopeProfiler.py(353)_profilePublishModule()
-> request=request, response=response)
/local/HRS2/Devel/junga/tb-dev/parts/zope2/lib/python/ZPublisher/Publish.py(494)publish_module()
-> environ, debug, request, response)
/local/HRS2/Devel/junga/tb-dev/parts/zope2/lib/python/ZPublisher/Publish.py(287)publish_module_standard()
-> response = publish(request, module_name, after_list, debug=debug)
/local/HRS2/Devel/junga/tb-dev/parts/zope2/lib/python/ZPublisher/Publish.py(148)publish()
-> request, bind=1)
/local/HRS2/Devel/junga/tb-dev/parts/zope2/lib/python/ZPublisher/mapply.py(98)mapply()
-> if debug is not None: return debug(object,args,context)
/local/HRS2/Devel/junga/tb-dev/parts/zope2/lib/python/ZPublisher/Publish.py(57)call_object()
-> result=apply(object,args) # Type s<cr> to step into published object.
/local/HRS2/Devel/junga/tb-dev/parts/zope2/lib/python/Products/CMFCore/FSPythonScript.py(108)__call__()
-> return Script.__call__(self, *args, **kw)
/local/HRS2/Devel/junga/tb-dev/parts/zope2/lib/python/Shared/DC/Scripts/Bindings.py(313)__call__()
-> return self._bindAndExec(args, kw, None)
/local/HRS2/Devel/junga/tb-dev/parts/zope2/lib/python/Shared/DC/Scripts/Bindings.py(350)_bindAndExec()
-> return self._exec(bound_data, args, kw)
/local/HRS2/Devel/junga/tb-dev/parts/zope2/lib/python/Products/CMFCore/FSPythonScript.py(163)_exec()
-> result = f(*args, **kw)
/local/HRS2/Devel/junga/tb-dev/parts/products-svn/MedienDB/skins/mediendb/mdbMediumCopyToWorkspaceAction.xpy(9)mdbMediumCopyToWorkspaceAction()
-> versioner.copyToWorkspace(context.getId(), version)
>
/local/HRS2/Devel/junga/tb-dev/parts/modules-svn/mediendb/versions.py(395)copyToWorkspace()
-> self.generateThumbnail(lidx, 0, mediumObj)
/local/HRS2/Devel/junga/tb-dev/parts/modules-svn/mediendb/versions.py(252)generateThumbnail()
-> medium = self.mediendb.getMedium(lidx)
/local/HRS2/Devel/junga/tb-dev/parts/modules-svn/mediendb/mediendb.py(185)getMedium()
-> return session.query(Medium).filter_by(linkindex=lidx).one()
/local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/query.py(1048)one()
-> ret = list(self[0:2])
/local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/query.py(952)__getitem__()
-> return list(res)
/local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/query.py(1087)__iter__()
-> self.session._autoflush()
/local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/session.py(912)_autoflush()
-> self.flush()
/local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/session.py(1354)flush()
-> self._flush(objects)
/local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/session.py(1424)_flush()
-> flush_context.execute()
/local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/unitofwork.py(260)execute()
-> UOWExecutor().execute(self, tasks)
/local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/unitofwork.py(723)execute()
-> self.execute_save_steps(trans, task)
/local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/unitofwork.py(738)execute_save_steps()
-> self.save_objects(trans, task)
/local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/unitofwork.py(729)save_objects()
-> task.mapper._save_obj(task.polymorphic_tosave_objects, trans)
/local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/mapper.py(1196)_save_obj()
-> connection = uowtransaction.transaction.connection(self)
/local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/session.py(258)connection()
-> return self._connection_for_bind(engine)
/local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/session.py(315)_connection_for_bind()
-> conn = self._parent._connection_for_bind(bind)
/local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/session.py(315)_connection_for_bind()
-> conn = self._parent._connection_for_bind(bind)
/local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/session.py(315)_connection_for_bind()
-> conn = self._parent._connection_for_bind(bind)
/local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/session.py(315)_connection_for_bind()
-> conn = self._parent._connection_for_bind(bind)
/local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/session.py(315)_connection_for_bind()
-> conn = self._parent._connection_for_bind(bind)
/local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/session.py(315)_connection_for_bind()
-> conn = self._parent._connection_for_bind(bind)
/local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/session.py(331)_connection_for_bind()
-> transaction = conn.begin_nested()
/local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/engine/base.py(669)begin_nested()
-> self.__transaction = NestedTransaction(self, self.__transaction)
/local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/engine/base.py(1038)__init__()
-> self._savepoint = self.connection._savepoint_impl()
/local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/engine/base.py(740)_savepoint_impl()
-> self.engine.dialect.do_savepoint(self, name)
/local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/engine/default.py(110)do_savepoint()
-> connection.execute(expression.SavepointClause(name))
/local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/engine/base.py(806)execute()
-> return Connection.executors[c](self, object, multiparams, params)
/local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/engine/base.py(856)execute_clauseelement()
-> return self.__execute_context(context)
/local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/engine/base.py(878)__execute_context()
-> self._cursor_execute(context.cursor, context.statement,
context.parameters[0], context=context)
/local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/engine/base.py(927)_cursor_execute()
-> self._handle_dbapi_exception(e, statement, parameters, cursor)
/local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/engine/base.py(909)_handle_dbapi_exception()
-> raise exc.DBAPIError.instance(statement, parameters, e,
connection_invalidated=is_disconnect)
--
ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany
Web: www.zopyx.com - Email: [email protected] - Phone +49 - 7071 - 793376
Registergericht: Amtsgericht Stuttgart, Handelsregister A 381535
Geschäftsführer/Gesellschafter: ZOPYX Limited, Birmingham, UK
------------------------------------------------------------------------
E-Publishing, Python, Zope & Plone development, Consulting
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
begin:vcard
fn:Andreas Jung
n:Jung;Andreas
org:ZOPYX Ltd. & Co. KG
adr;quoted-printable:;;Charlottenstr. 37/1;T=C3=BCbingen;;72070;Germany
email;internet:[email protected]
title:CEO
tel;work:+49-7071-793376
tel;fax:+49-7071-7936840
tel;home:+49-7071-793257
x-mozilla-html:FALSE
url:www.zopyx.com
version:2.1
end:vcard
