[Z3-sqlos] Database error (connection closed)

[Roy Mathew]

I've seen this quite a few times on the server that I am using (in a
production context) and the only recourse I have is to delete the
adapter utility and recreate it.

    File "/usr/local/Zope3/src/zope/tales/expressions.py", line 217, in __call__                     
      return self._eval(econtext)                                                                    
    File "/usr/local/Zope3/src/zope/tales/expressions.py", line 211, in _eval                        
      return ob()                                                                                    
    File "/usr/local/Zope3/src/zope/app/container/size.py", line 38, in sizeForDisplay               
      num_items = len(self._container)                                                               
    File "/var/lib/zope3/instances/instance.barry2007/lib/python/sqlos/container.py", line 182, in _ _len__                                                                                             
      i += utility.select().count() # optimal, does not get all objects                              
    File "/usr/lib/python2.4/site-packages/SQLObject-0.8dev_r1814-py2.4.egg/sqlobject/sresults.py",  line 189, in count                                                                                 
      count = self.accumulate('COUNT(*)')                                                            
    File "/usr/lib/python2.4/site-packages/SQLObject-0.8dev_r1814-py2.4.egg/sqlobject/sresults.py", line 173, in accumulate                                                                            
      return conn.accumulateSelect(self, *expressions)                                               
    File "/usr/lib/python2.4/site-packages/SQLObject-0.8dev_r1814-py2.4.egg/sqlobject/dbconnection.py", line 391, in accumulateSelect                                                                  
      val = self.queryOne(q)                                                                         
    File "/usr/lib/python2.4/site-packages/SQLObject-0.8dev_r1814-py2.4.egg/sqlobject/dbconnection.py", line 358, in queryOne                                                                          
      return self._runWithConnection(self._queryOne, s)                                              
    File "/var/lib/zope3/instances/instance.barry2007/lib/python/sqlos/adapter.py", line 83, in _runWithConnection                                                                                     
      val = meth(conn, *args)                                                                        
    File "/usr/lib/python2.4/site-packages/SQLObject-0.8dev_r1814-py2.4.egg/sqlobject/dbconnection.py", line 351, in _queryOne                                                                         
      self._executeRetry(conn, c, s)                                                                 
    File "/var/lib/zope3/instances/instance.barry2007/lib/python/sqlos/adapter.py", line 77, in _executeRetry                                                                                          
      raise DatabaseException(str(exc.args))                                                         
  DatabaseException: ("Shouldn't load state for 0xb55d when the connection is closed",)              

Can someone tell me if this looks familiar.

-- 
Thanks,
Roy Mathew.