[Zope-DB] ZPsycopgDA : no connection to the server

[Christophe Caron]

Hello

I run zope 2.7.0, postgresl 7.3.3, python 2.3.3 under solaris 9 and
psycopg 1.1.14.

I've some problems with the postgresql DA.

I've created a Z Psycopg Databse Connection / ZSQL Method and at the top a
Zope Page Templates

All works fine but sometimes i've this message:
OperationalError: no connection to the server

All will work again if :
 - i restart zope
 - i close/open the  Z Psycopg Databse Connection
 - i click on porperties/save changes on the  Z Psycopg Databse
Connection (withou any modification)

I've no trace of any connection when the connection failed in the
postgresql logs.

Below the results of the exception:
Traceback (most recent call last):
  File "/usr/local/www/zope-2.7.0/lib/python/ZPublisher/Publish.py", line
100, in publish
    request, bind=1)
  File "/usr/local/www/zope-2.7.0/lib/python/ZPublisher/mapply.py", line
88, in mapply
    if debug is not None: return debug(object,args,context)
  File "/usr/local/www/zope-2.7.0/lib/python/ZPublisher/Publish.py", line
40, in call_object
    result=apply(object,args) # Type s<cr> to step into published object.
  File
"/usr/local/www/zope-2.7.0/lib/python/Shared/DC/Scripts/Bindings.py", line
306, in __call__
    return self._bindAndExec(args, kw, None)
  File
"/usr/local/www/zope-2.7.0/lib/python/Shared/DC/Scripts/Bindings.py", line
343, in _bindAndExec
    return self._exec(bound_data, args, kw)
  File
"/usr/local/www/zope-2.7.0/lib/python/Products/PageTemplates/ZopePageTemplate.py",
line 222, in _exec
    result = self.pt_render(extra_context=bound_names)
  File
"/usr/local/www/zope-2.7.0/lib/python/Products/PageTemplates/PageTemplate.py",
line 96, in pt_render
    tal=not source, strictinsert=0)()
  File "/usr/local/www/zope-2.7.0/lib/python/TAL/TALInterpreter.py", line
189, in __call__
    self.interpret(self.program)
  File "/usr/local/www/zope-2.7.0/lib/python/TAL/TALInterpreter.py", line
233, in interpret
    handlers[opcode](self, args)
  File "/usr/local/www/zope-2.7.0/lib/python/TAL/TALInterpreter.py", line
663, in do_useMacro
    self.interpret(macro)
  File "/usr/local/www/zope-2.7.0/lib/python/TAL/TALInterpreter.py", line
233, in interpret
    handlers[opcode](self, args)
  File "/usr/local/www/zope-2.7.0/lib/python/TAL/TALInterpreter.py", line
408, in do_optTag_tal
    self.do_optTag(stuff)
  File "/usr/local/www/zope-2.7.0/lib/python/TAL/TALInterpreter.py", line
393, in do_optTag
    return self.no_tag(start, program)
  File "/usr/local/www/zope-2.7.0/lib/python/TAL/TALInterpreter.py", line
388, in no_tag
    self.interpret(program)
  File "/usr/local/www/zope-2.7.0/lib/python/TAL/TALInterpreter.py", line
233, in interpret
    handlers[opcode](self, args)
  File "/usr/local/www/zope-2.7.0/lib/python/TAL/TALInterpreter.py", line
686, in do_defineSlot
    self.interpret(slot)
  File "/usr/local/www/zope-2.7.0/lib/python/TAL/TALInterpreter.py", line
233, in interpret
    handlers[opcode](self, args)
  File "/usr/local/www/zope-2.7.0/lib/python/TAL/TALInterpreter.py", line
459, in do_setLocal_tal
    self.engine.setLocal(name, self.engine.evaluateValue(expr))
  File
"/usr/local/www/zope-2.7.0/lib/python/Products/PageTemplates/TALES.py",
line 220, in evaluate
    return expression(self)
  File
"/usr/local/www/zope-2.7.0/lib/python/Products/PageTemplates/Expressions.py",
line 201, in __call__
    return self._eval(econtext)
  File
"/usr/local/www/zope-2.7.0/lib/python/Products/PageTemplates/Expressions.py",
line 196, in _eval
    return render(ob, econtext.vars)
  File
"/usr/local/www/zope-2.7.0/lib/python/Products/PageTemplates/Expressions.py",
line 103, in render
    ob = ob()
  File "/usr/local/www/zope-2.7.0/lib/python/Shared/DC/ZRDB/DA.py", line
449, in __call__
    else: result=DB__.query(query, self.max_rows_)
  File "/usr/local/www/zope-2.7.0/lib/python/Products/ZPsycopgDA/db.py",
line 228, in query
    raise err
OperationalError: no connection to the server


Thanks for your help

cc


=============================================================
= Christophe Caron  					    =
= Mathematique Informatique et Genome
= INRA - Domaine de Vilvert 78350 Jouy-en-Josas  	    =
= Tel: 01-34-65-28-88  Email: Christophe.Caron at jouy.inra.fr =
=============================================================