2009/1/31 Shane Hathaway <sh...@hathawaymix.org>:
> Change it to this:
>
>    except (cx_Oracle.OperationalError, cx_Oracle.InterfaceError,
>        cx_Oracle.DatabaseError), e:
>
> If that change works, I will include it in the next release of RelStorage.
>
> Shane
>
>

Hi Shane,
 thanks a lot for your answer.
Your diagnosis seems to be correct but maybe the same fix should be
applied to the "restart_store" method too.
See the log below:

2009-02-02T16:14:21 INFO relstorage Reconnected.
2009-02-02T16:14:31 WARNING relstorage Reconnecting load_conn:
ORA-03135: connection lost contact
2009-02-02T16:14:31 INFO relstorage Reconnected.
2009-02-02T16:14:58 WARNING relstorage Reconnecting load_conn:
ORA-03135: connection lost contact
2009-02-02T16:14:58 INFO relstorage Reconnected.
2009-02-02T16:16:52 ERROR Zope.SiteErrorLog http://...
Traceback (innermost last):
 Module ZPublisher.Publish, line 125, in publish
 Module Zope2.App.startup, line 270, in commit
 Module transaction._manager, line 93, in commit
 Module transaction._transaction, line 325, in commit
 Module transaction._transaction, line 422, in _commitResources
 Module ZODB.Connection, line 562, in tpc_begin
 Module relstorage.relstorage, line 505, in tpc_begin
 Module relstorage.relstorage, line 186, in _restart_store
 Module relstorage.adapters.oracle, line 532, in restart_store
DatabaseError: ORA-03135: connection lost contact

Do you agree with me?
The 'close' method also deals with the same exceptions: does it need
this fix too?

Thanks again,

Riccardo Minet
_______________________________________________
For more information about ZODB, see the ZODB Wiki:
http://www.zope.org/Wikis/ZODB/

ZODB-Dev mailing list  -  ZODB-Dev@zope.org
http://mail.zope.org/mailman/listinfo/zodb-dev

Reply via email to