veloutin / tilde Goto Github PK

2013-06-03 15:28:32,759 ERROR [twisted] Unhandled Error
Traceback (most recent call last):
  File "/usr/lib/python2.7/dist-packages/twisted/internet/base.py", line 1169, in run
    self.mainLoop()
  File "/usr/lib/python2.7/dist-packages/twisted/internet/base.py", line 1178, in mainLoop
    self.runUntilCurrent()
  File "/usr/lib/python2.7/dist-packages/twisted/internet/base.py", line 800, in runUntilCurrent
    call.func(*call.args, **call.kw)
  File "/usr/lib/python2.7/dist-packages/twisted/internet/task.py", line 595, in _tick
    taskObj._oneWorkUnit()
---  ---
  File "/usr/lib/python2.7/dist-packages/twisted/internet/task.py", line 472, in _oneWorkUnit
    result = self._iterator.next()
  File "/usr/lib/python2.7/dist-packages/tilde/runner.py", line 301, in 
    service.updateOne(*r).addErrback(log_err, log, "failed to update")
  File "/usr/lib/python2.7/dist-packages/tilde/runner.py", line 58, in listSharesToUpdate
    zs = getUtility(IZStorm).get("tilde")
  File "/usr/lib/python2.7/dist-packages/storm/zope/zstorm.py", line 156, in get
    return self.create(name, default_uri)
  File "/usr/lib/python2.7/dist-packages/storm/zope/zstorm.py", line 133, in create
    store = Store(database)
  File "/usr/lib/python2.7/dist-packages/storm/store.py", line 73, in __init__
    self._connection = database.connect(self._event)
  File "/usr/lib/python2.7/dist-packages/storm/database.py", line 410, in connect
    return self.connection_factory(self, event)
  File "/usr/lib/python2.7/dist-packages/storm/database.py", line 185, in __init__
    self._raw_connection = self._database.raw_connect()
  File "/usr/lib/python2.7/dist-packages/storm/databases/postgres.py", line 329, in raw_connect
    raw_connection = psycopg2.connect(self._dsn)
  File "/usr/lib/python2.7/dist-packages/psycopg2/__init__.py", line 179, in connect
    connection_factory=connection_factory, async=async)
psycopg2.OperationalError: could not connect to server: Connection refused
        Is the server running on host "localhost" (127.0.0.1) and accepting
        TCP/IP connections on port 5432?

When running with a loop, it seems like listSharesToUpdate gets stuck
in an old transaction that never refreshed.

DETAIL: Key (server_name, path)=(file01, ) already exists.

when attempting to set path to empty string

it works with NULL, though.

Maybe this is a bad way to delete?