traceback.txt

Configuring a mount point to use Postgresql storage and SQLMultiTableProperties works fine, but when Zope is restarted the mounted point is broken. Changing apeconf.xml to use SQLProperties instead of SQLMultiTableProperties and restarting again solves the problem. A traceback is provided

File details

Size

1 K

File type

text/plain

Click here to get the file

File contents

2004-03-24T18:39:05 ERROR(200) ZODB Failed to mount database. psycopg.ProgrammingError (ERROR:  current transaction is aborted, queries ignored until end of transaction block

SELECT class_name, mapper_name FROM classification WHERE objoid = '1')
Traceback (most recent call last):
  File "/usr/local/zope270/lib/python/Products/ZODBMountPoint/Mount.py", line 88, in _getOrOpenObject
    obj = self._traverseToMountedRoot(root, parent)
  File "/usr/local/zope270/lib/python/Products/ZODBMountPoint/MountedObject.py", line 182, in _traverseToMountedRoot
    obj = obj.unrestrictedTraverse(real_path)
  File "/usr/local/zope270/lib/python/Products/Ape/lib/apelib/zodb3/connection.py", line 322, in setstate
    p, serial = self._storage.load(oid, self._version)
  File "/usr/local/zope270/lib/python/Products/Ape/lib/apelib/zodb3/storage.py", line 97, in load
    event, classification, state, hash_value = self._gwio.load(oid)
  File "/usr/local/zope270/lib/python/Products/Ape/lib/apelib/core/io.py", line 94, in load
    classification = self.classify_state(oid)
  File "/usr/local/zope270/lib/python/Products/Ape/lib/apelib/core/io.py", line 91, in classify_state
    return self.conf.classifier.classify_state(event)
  File "/usr/local/zope270/lib/python/Products/Ape/lib/apelib/zope2/classifier.py", line 121, in classify_state
    classification, serial = self.gateway.load(event)
  File "/usr/local/zope270/lib/python/Products/Ape/lib/apelib/sql/classification.py", line 37, in load
    rows = conn.select(self.table, self.columns, oid=event.oid)
  File "/usr/local/zope270/lib/python/Products/Ape/lib/apelib/sql/dbapi.py", line 115, in select
    return self.execute(sql, filter, fetch=1)
  File "/usr/local/zope270/lib/python/Products/Ape/lib/apelib/sql/dbapi.py", line 258, in execute
    cursor.execute(sql, params)
ProgrammingError: ERROR:  current transaction is aborted, queries ignored until end of transaction block

SELECT class_name, mapper_name FROM classification WHERE objoid = '1'