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

[Riccardo Minet]

2009/2/2 Shane Hathaway <shane at hathawaymix.org>:
>
> Yes, in fact, it's clear now that there should be a module-level global that
> lists all exception types we want to catch.  I've committed a fix in
> Subversion and I'll release a new version soon.
>
> Shane
>
>
Hi Shane,
 I've applied the fixed code from subversion and it works fine for
normal operations.
Unfortunately testing the Pack operation I have seen another exception
of the same type:
...
...
2009-02-06T12:57:45 INFO relstorage.adapters.common pre_pack:
following references, pass 106
2009-02-06T12:57:45 INFO relstorage.adapters.common pre_pack:
following references, pass 107
2009-02-06T12:57:45 INFO relstorage.adapters.common pre_pack:
following references, pass 108
2009-02-06T12:57:45 INFO relstorage.adapters.common pre_pack:
enumerating states to pack
2009-02-06T12:57:45 INFO relstorage.adapters.common pre_pack:
enumerating transactions to pack
2009-02-06T12:57:45 INFO relstorage.adapters.common pre_pack: will
remove 668 object state(s)
2009-02-06T12:57:45 INFO relstorage.adapters.common pre_pack: finished
successfully
2009-02-06T12:57:46 INFO relstorage.adapters.common pack: will pack
199 transaction(s)
2009-02-06T12:57:49 INFO relstorage.adapters.common pack: cleaning up
2009-02-06T12:57:50 INFO relstorage.adapters.common pack: finished successfully
------
2009-02-06T12:57:50 ERROR ZODB.DB packing
Traceback (most recent call last):
  File "/home/spadmin/Runtime/Zope-2.11.2-final/lib/python/ZODB/DB.py",
line 688, in pack
    self._storage.pack(t, self.references)
  File "/home/spadmin/Environments/Development/Zope/Site-exp/lib/python/relstorage/relstorage.py",
line 880, in pack
    self._after_pack()
  File "/home/spadmin/Environments/Development/Zope/Site-exp/lib/python/relstorage/relstorage.py",
line 891, in _after_pack
    self._rollback_load_connection()
  File "/home/spadmin/Environments/Development/Zope/Site-exp/lib/python/relstorage/relstorage.py",
line 142, in _rollback_load_connection
    self._load_conn.rollback()
DatabaseError: ORA-03135: connection lost contact

------
2009-02-06T12:57:50 ERROR Zope.SiteErrorLog
http://laerte.te.actalis.it:18080/Control_Panel/Database/main/manage_pack
Traceback (innermost last):
  Module ZPublisher.Publish, line 119, in publish
  Module ZPublisher.mapply, line 88, in mapply
  Module ZPublisher.Publish, line 42, in call_object
  Module <string>, line 3, in manage_pack
  Module AccessControl.requestmethod, line 70, in _curried
  Module App.ApplicationManager, line 431, in manage_pack
  Module ZODB.DB, line 688, in pack
  Module relstorage.relstorage, line 880, in pack
  Module relstorage.relstorage, line 891, in _after_pack
  Module relstorage.relstorage, line 142, in _rollback_load_connection
DatabaseError: ORA-03135: connection lost contact

I think it's not a seriuos problem because the operation seems to be
completed at that point but if possible
could you take care of it for the next release?

Thanks,
 Riccardo