644: Reviewboard with pgpool

pos****@gmai***** (Google Code) (Is this you? Claim this profile.)
Oct. 20, 2008
What's the URL of the page containing the problem?


What steps will reproduce the problem?
1. any constant use of reviewboard will eventually trigger the problem
2.
3.

What is the expected output? What do you see instead?
Environment:

Request Method: GET
Request URL: http://...
Django Version: 0.97-pre-SVN-unknown
Python Version: 2.4.3
Installed Applications:
['django.contrib.admin',
 'django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.markup',
 'django.contrib.sites',
 'django.contrib.sessions',
 'djblets.datagrid',
 'djblets.util',
 'djblets.webapi',
 'reviewboard.accounts',
 'reviewboard.admin',
 'reviewboard.diffviewer',
 'reviewboard.iphone',
 'reviewboard.reports',
 'reviewboard.reviews',
 'reviewboard.scmtools',
 'reviewboard.webapi']
Installed Middleware:
('django.middleware.common.CommonMiddleware',
 'django.middleware.doc.XViewMiddleware',
 'django.middleware.locale.LocaleMiddleware',
 'django.contrib.sessions.middleware.SessionMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware')


Traceback:
File
"...FDSreviewboard_0.0.1/lib/python2.4/site-packages/django/core/handlers/base.py"
in get_response
  82.                 response = callback(request, *callback_args,
**callback_kwargs)
File "...FDSreviewboard_0.0.1/reviewboard/djblets/auth/util.py" in _checklogin
  44.         if request.user.is_authenticated():
File
"...FDSreviewboard_0.0.1/lib/python2.4/site-packages/django/contrib/auth/middleware.py"
in __get__
  5.             request._cached_user = get_user(request)
File
"...FDSreviewboard_0.0.1/lib/python2.4/site-packages/django/contrib/auth/__init__.py"
in get_user
  80.         user_id = request.session[SESSION_KEY]
File
"...FDSreviewboard_0.0.1/lib/python2.4/site-packages/django/contrib/sessions/backends/base.py"
in __getitem__
  31.         return self._session[key]
File
"...FDSreviewboard_0.0.1/lib/python2.4/site-packages/django/contrib/sessions/backends/base.py"
in _get_session
  126.                 self._session_cache = self.load()
File
"...FDSreviewboard_0.0.1/lib/python2.4/site-packages/django/contrib/sessions/backends/db.py"
in load
  18.                 expire_date__gt=datetime.datetime.now()
File
"...FDSreviewboard_0.0.1/lib/python2.4/site-packages/django/db/models/manager.py"
in get
  82.         return self.get_query_set().get(*args, **kwargs)
File
"...FDSreviewboard_0.0.1/lib/python2.4/site-packages/django/db/models/query.py"
in get
  192.         num = len(clone)
File
"...FDSreviewboard_0.0.1/lib/python2.4/site-packages/django/db/models/query.py"
in __len__
  53.                 self._result_cache = list(self.iterator())
File
"...FDSreviewboard_0.0.1/lib/python2.4/site-packages/django/db/models/query.py"
in iterator
  162.         for row in self.query.results_iter():
File
"...FDSreviewboard_0.0.1/lib/python2.4/site-packages/django/db/models/sql/query.py"
in results_iter
  200.         for rows in self.execute_sql(MULTI):
File
"...FDSreviewboard_0.0.1/lib/python2.4/site-packages/django/db/models/sql/query.py"
in execute_sql
  1464.         cursor = self.connection.cursor()
File
"...FDSreviewboard_0.0.1/lib/python2.4/site-packages/django/db/backends/__init__.py"
in cursor
  33.         cursor = self._cursor(settings)
File
"...FDSreviewboard_0.0.1/lib/python2.4/site-packages/django/db/backends/postgresql_psycopg2/base.py"
in _cursor
  69.             self.connection = Database.connect(conn_string,
**self.options)

Exception Type: OperationalError at /dashboard/
Exception Value: server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.


What operating system are you using? What browser?
linux

Please provide any additional information below.
chipx86
#1 chipx86
This sounds like an issue with the database configuration, though I don't know what
would cause it. Perhaps there's too many users and the database has reached some sort
of a max connection count?
chipx86
#2 chipx86
There's a chance some work we've been doing on reducing the number of SQL queries
will help. We found some bugs causing an excessive amount of queries on the
dashboard. Can you try to reproduce this using the latest SVN?
  • +Confirmed
#3 pos****@gmai***** (Google Code) (Is this you? Claim this profile.)
Fixed you may close this.
chipx86
#4 chipx86
  • -Confirmed
    +Fixed