Edgewall Software

Opened 15 years ago

Last modified 15 years ago

#8539 closed defect

Problem with pyPgSql — at Version 1

Reported by: nnoshin@… Owned by:
Priority: normal Milestone: 0.12
Component: database backend Version: none
Severity: normal Keywords: pypgsql
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description (last modified by Christian Boos)

Hello! Unfortunately, I can not upload my website at ​http://browsershots.org/ due. Something is blocking my website, so they couldn't find any connection to the server. There are some particular reasons. But unfortunately I don't understand the problems, so "​http://browsershots.org/" recommended your website so that you can solve the problem.

Here is the traceback: 

Python Traceback
Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/trac/web/main.py", line 406, in dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.5/site-packages/trac/web/main.py", line 191, in dispatch
    chosen_handler = self._pre_process_request(req, chosen_handler)
  File "/usr/lib/python2.5/site-packages/trac/web/main.py", line 263, in _pre_process_request
    chosen_handler = f.pre_process_request(req, chosen_handler)
  File "/usr/lib/python2.5/site-packages/trac/versioncontrol/api.py", line 73, in pre_process_request
    self.get_repository(req.authname).sync()
  File "/usr/lib/python2.5/site-packages/trac/versioncontrol/cache.py", line 70, in sync
    cursor = self.db.cursor()
  File "/usr/lib/python2.5/site-packages/trac/db/util.py", line 78, in cursor
    return IterableCursor(self.cnx.cursor())
  File "/usr/lib/python2.5/site-packages/trac/db/util.py", line 78, in cursor
    return IterableCursor(self.cnx.cursor())
  File "/usr/lib/python2.5/site-packages/pyPgSQL/PgSQL.py", line 2599, in cursor
    return Cursor(self, name, isRefCursor)
  File "/usr/lib/python2.5/site-packages/pyPgSQL/PgSQL.py", line 2718, in __init__
    self.conn._Connection__setupTransaction()
  File "/usr/lib/python2.5/site-packages/pyPgSQL/PgSQL.py", line 2510, in __setupTransaction
    self.conn.query("BEGIN WORK")
OperationalError: no connection to the server

Change History (1)

comment:1 by Christian Boos, 15 years ago

Component: general → database backend
Description: modified (diff)
Keywords: pypgsql added
Milestone: → 0.12
Summary: Blocked page → Problem with pyPgSql

Well, this seems to be a local administration issue, you've lost connection to your database, so it sounds like the database is down.

This problem might also come from too many opened connections, and hence be related to #8443.

Finally, this problem might be due to the use of pyPgSql itself, as we don't test it, we don't know how reliable this package is (and there are a number of reported problems with it).

So we recommend that you use psycopg2 rather than pyPgSql (see DatabaseBackend).

Hijacking this ticket so that we effectively disable support for pyPgSql in the code. That will remove one possible cause of trouble.

Note: See TracTickets for help on using tickets.