[ZODB-Dev] Connection lost using RelStorage on Oracle 10g

[Riccardo Minet]

2009/1/31 Shane Hathaway <shane at 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