On Jan 2, 2009, at 4:24 AM, Andreas Jung wrote:
> 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.
SAVEPOINT is only issued if you do so explicitly, via begin_nested()
on Session or Connection. You'll have to modify your application to
not use these methods.
>
>
> 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
>
>
> >
> 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
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
