OperationalError at /qa/ticket/add/140/

Request Method:	GET
Request URL:	http://qa.openmicroscopy.org.uk/qa/ticket/add/140/
Exception Type:	OperationalError
Exception Value:	FATAL: connection limit exceeded for non-superusers
Exception Location:	/var/www/qa.openmicroscopy.org.uk/OMERO.qa/django/db/backends/postgresql_psycopg2/base.py in _cursor, line 87
Python Executable:	/usr/bin/python
Python Version:	2.6.2
Python Path:	['/var/www/qa.openmicroscopy.org.uk/OMERO.qa', '/usr/lib64/python2.6/site-packages/Trac-0.11.5-py2.6.egg', '/usr/lib64/python2.6/site-packages/Genshi-0.5.1-py2.6-linux-x86_64.egg', '/usr/lib64/python2.6/site-packages/psycopg2-2.0.12-py2.6-linux-x86_64.egg', '/usr/lib64/python2.6/site-packages/zope.interface-3.5.2-py2.6-linux-x86_64.egg', '/usr/lib64/python2.6/site-packages/Twisted-8.2.0-py2.6-linux-x86_64.egg', '/usr/lib64/python2.6/site-packages/setuptools-0.6c9-py2.6.egg', '/usr/lib64/python2.6/site-packages/TracTocMacro-11.0.0.3-py2.6.egg', '/usr/lib64/python2.6/site-packages/TracIncludeMacro-2.1-py2.6.egg', '/usr/lib64/python2.6/site-packages/TracXMLRPC-1.0.6-py2.6.egg', '/usr/lib64/python2.6/site-packages/simplejson-2.0.9-py2.6-linux-x86_64.egg', '/usr/lib64/python2.6/site-packages/tables-2.1.2-py2.6-linux-x86_64.egg', '/usr/lib64/python2.6/site-packages/lxml-2.2.2-py2.6-linux-x86_64.egg', '/usr/lib64/python26.zip', '/usr/lib64/python2.6', '/usr/lib64/python2.6/plat-linux2', '/usr/lib64/python2.6/lib-tk', '/usr/lib64/python2.6/lib-old', '/usr/lib64/python2.6/lib-dynload', '/usr/lib64/python2.6/site-packages', '/usr/lib64/python2.6/site-packages/PIL', '/usr/lib64/portage/pym']
Server time:	Sun, 11 Oct 2009 15:24:53 +0100

Traceback Switch to copy-and-paste view

/var/www/qa.openmicroscopy.org.uk/OMERO.qa/django/core/handlers/base.py in get_response

# Apply view middleware
for middleware_method in self._view_middleware:
response = middleware_method(request, callback, callback_args, callback_kwargs)
if response:
return response
try:

response = callback(request, *callback_args, **callback_kwargs) ...

except Exception, e:
# If the view raised an exception, run it through exception
# middleware, and if the exception middleware returns a
# response, use that. Otherwise, reraise the exception.
for middleware_method in self._exception_middleware:
response = middleware_method(request, e)

▶ Local vars

Variable	Value
callback	<function ticket at 0x2db0c80>
callback_args	()
callback_kwargs	{'action': u'add', 'fid': u'140', 'tid': None}
e	OperationalError('FATAL: connection limit exceeded for non-superusers\n',)
exc_info	(<class 'psycopg2.OperationalError'>, OperationalError('FATAL: connection limit exceeded for non-superusers\n',), <traceback object at 0x20b9830>)
exceptions	<module 'django.core.exceptions' from '/var/www/qa.openmicroscopy.org.uk/OMERO.qa/django/core/exceptions.py'>
middleware_method	<bound method SetRemoteAddrFromForwardedFor.process_request of <django.middleware.http.SetRemoteAddrFromForwardedFor object at 0x2385a50>>
receivers	[(<function _rollback_on_exception at 0x282ef50>, None)]
request	<ModPythonRequest path:/qa/ticket/add/140/, GET:<QueryDict: {}>, POST:<QueryDict: {}>, COOKIES:{'sessionid': '87510fae1bb6af3987bee593b45f869a'}, META:{'AUTH_TYPE': None, 'CONTENT_LENGTH': 0L, 'CONTENT_TYPE': None, 'GATEWAY_INTERFACE': 'CGI/1.1', 'HTTP_ACCEPT': 'text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8', 'HTTP_ACCEPT_CHARSET': 'ISO-8859-1,utf-8;q=0.7,*;q=0.7', 'HTTP_ACCEPT_ENCODING': 'gzip,deflate', 'HTTP_ACCEPT_LANGUAGE': 'en-us,en;q=0.5', 'HTTP_CONNECTION': 'keep-alive', 'HTTP_COOKIE': 'sessionid=87510fae1bb6af3987bee593b45f869a', 'HTTP_HOST': 'qa.openmicroscopy.org.uk', 'HTTP_KEEP_ALIVE': '300', 'HTTP_REFERER': 'http://qa.openmicroscopy.org.uk/qa/feedback/140/', 'HTTP_USER_AGENT': 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.4; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3', 'PATH_INFO': u'/qa/ticket/add/140/', 'PATH_TRANSLATED': None, 'QUERY_STRING': None, 'REMOTE_ADDR': '89.48.1.61', 'REMOTE_HOST': None, 'REMOTE_IDENT': None, 'REMOTE_USER': None, 'REQUEST_METHOD': 'GET', 'SCRIPT_NAME': '', 'SERVER_NAME': 'qa.openmicroscopy.org.uk', 'SERVER_PORT': 80, 'SERVER_PROTOCOL': 'HTTP/1.1', 'SERVER_SOFTWARE': 'mod_python'}>
resolver	<RegexURLResolver omero_qa.urls ^/>
response	None
self	<django.core.handlers.modpython.ModPythonHandler object at 0x2295790>
settings	<django.conf.LazySettings object at 0x239be10>
urlconf	'omero_qa.urls'
urlresolvers	<module 'django.core.urlresolvers' from '/var/www/qa.openmicroscopy.org.uk/OMERO.qa/django/core/urlresolvers.py'>

/var/www/qa.openmicroscopy.org.uk/OMERO.qa/omero_qa/qa/views.py in ticket

# pass
# else:
# request.session['error'] = "File cannot be deleted."
# return create_response(request)
def ticket(request, action, fid, tid=None, **kwargs):

error = check_if_error(request) ...

logger.debug(request.POST)
if request.user.is_authenticated() and request.user.is_staff:
template = "qa/ticket.html"
ticket_form = None
if action == 'new':
feedback = Feedback.objects.get(pk=fid)

▶ Local vars

Variable	Value
action	u'add'
fid	u'140'
kwargs	{}
request	<ModPythonRequest path:/qa/ticket/add/140/, GET:<QueryDict: {}>, POST:<QueryDict: {}>, COOKIES:{'sessionid': '87510fae1bb6af3987bee593b45f869a'}, META:{'AUTH_TYPE': None, 'CONTENT_LENGTH': 0L, 'CONTENT_TYPE': None, 'GATEWAY_INTERFACE': 'CGI/1.1', 'HTTP_ACCEPT': 'text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8', 'HTTP_ACCEPT_CHARSET': 'ISO-8859-1,utf-8;q=0.7,*;q=0.7', 'HTTP_ACCEPT_ENCODING': 'gzip,deflate', 'HTTP_ACCEPT_LANGUAGE': 'en-us,en;q=0.5', 'HTTP_CONNECTION': 'keep-alive', 'HTTP_COOKIE': 'sessionid=87510fae1bb6af3987bee593b45f869a', 'HTTP_HOST': 'qa.openmicroscopy.org.uk', 'HTTP_KEEP_ALIVE': '300', 'HTTP_REFERER': 'http://qa.openmicroscopy.org.uk/qa/feedback/140/', 'HTTP_USER_AGENT': 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.4; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3', 'PATH_INFO': u'/qa/ticket/add/140/', 'PATH_TRANSLATED': None, 'QUERY_STRING': None, 'REMOTE_ADDR': '89.48.1.61', 'REMOTE_HOST': None, 'REMOTE_IDENT': None, 'REMOTE_USER': None, 'REQUEST_METHOD': 'GET', 'SCRIPT_NAME': '', 'SERVER_NAME': 'qa.openmicroscopy.org.uk', 'SERVER_PORT': 80, 'SERVER_PROTOCOL': 'HTTP/1.1', 'SERVER_SOFTWARE': 'mod_python'}>
tid	None

/var/www/qa.openmicroscopy.org.uk/OMERO.qa/omero_qa/qa/views.py in check_if_error

def check_if_error(request):
error = None
try:
if request.session['error']:
error = request.session['error']
request.session['error'] = None
except:

request.session['error'] = None ...

logger.debug("Error: %s" % error)
return error
def get_lng_and_lat(ip_address):
latitude = None

▶ Local vars

Variable	Value
error	None
request	<ModPythonRequest path:/qa/ticket/add/140/, GET:<QueryDict: {}>, POST:<QueryDict: {}>, COOKIES:{'sessionid': '87510fae1bb6af3987bee593b45f869a'}, META:{'AUTH_TYPE': None, 'CONTENT_LENGTH': 0L, 'CONTENT_TYPE': None, 'GATEWAY_INTERFACE': 'CGI/1.1', 'HTTP_ACCEPT': 'text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8', 'HTTP_ACCEPT_CHARSET': 'ISO-8859-1,utf-8;q=0.7,*;q=0.7', 'HTTP_ACCEPT_ENCODING': 'gzip,deflate', 'HTTP_ACCEPT_LANGUAGE': 'en-us,en;q=0.5', 'HTTP_CONNECTION': 'keep-alive', 'HTTP_COOKIE': 'sessionid=87510fae1bb6af3987bee593b45f869a', 'HTTP_HOST': 'qa.openmicroscopy.org.uk', 'HTTP_KEEP_ALIVE': '300', 'HTTP_REFERER': 'http://qa.openmicroscopy.org.uk/qa/feedback/140/', 'HTTP_USER_AGENT': 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.4; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3', 'PATH_INFO': u'/qa/ticket/add/140/', 'PATH_TRANSLATED': None, 'QUERY_STRING': None, 'REMOTE_ADDR': '89.48.1.61', 'REMOTE_HOST': None, 'REMOTE_IDENT': None, 'REMOTE_USER': None, 'REQUEST_METHOD': 'GET', 'SCRIPT_NAME': '', 'SERVER_NAME': 'qa.openmicroscopy.org.uk', 'SERVER_PORT': 80, 'SERVER_PROTOCOL': 'HTTP/1.1', 'SERVER_SOFTWARE': 'mod_python'}>

Variable

Value

error

None

request

<ModPythonRequest path:/qa/ticket/add/140/, GET:<QueryDict: {}>, POST:<QueryDict: {}>, COOKIES:{'sessionid': '87510fae1bb6af3987bee593b45f869a'}, META:{'AUTH_TYPE': None, 'CONTENT_LENGTH': 0L, 'CONTENT_TYPE': None, 'GATEWAY_INTERFACE': 'CGI/1.1', 'HTTP_ACCEPT': 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8', 'HTTP_ACCEPT_CHARSET': 'ISO-8859-1,utf-8;q=0.7,*;q=0.7', 'HTTP_ACCEPT_ENCODING': 'gzip,deflate', 'HTTP_ACCEPT_LANGUAGE': 'en-us,en;q=0.5', 'HTTP_CONNECTION': 'keep-alive', 'HTTP_COOKIE': 'sessionid=87510fae1bb6af3987bee593b45f869a', 'HTTP_HOST': 'qa.openmicroscopy.org.uk', 'HTTP_KEEP_ALIVE': '300', 'HTTP_REFERER': 'http://qa.openmicroscopy.org.uk/qa/feedback/140/', 'HTTP_USER_AGENT': 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.4; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3', 'PATH_INFO': u'/qa/ticket/add/140/', 'PATH_TRANSLATED': None, 'QUERY_STRING': None, 'REMOTE_ADDR': '89.48.1.61', 'REMOTE_HOST': None, 'REMOTE_IDENT': None, 'REMOTE_USER': None, 'REQUEST_METHOD': 'GET', 'SCRIPT_NAME': '', 'SERVER_NAME': 'qa.openmicroscopy.org.uk', 'SERVER_PORT': 80, 'SERVER_PROTOCOL': 'HTTP/1.1', 'SERVER_SOFTWARE': 'mod_python'}>

/var/www/qa.openmicroscopy.org.uk/OMERO.qa/django/contrib/sessions/backends/base.py in __setitem__

def __contains__(self, key):
return key in self._session
def __getitem__(self, key):
return self._session[key]
def __setitem__(self, key, value):

self._session[key] = value ...

self.modified = True
def __delitem__(self, key):
del self._session[key]
self.modified = True

▶ Local vars

Variable	Value
key	'error'
self	<django.contrib.sessions.backends.db.SessionStore object at 0x2753190>
value	None

/var/www/qa.openmicroscopy.org.uk/OMERO.qa/django/contrib/sessions/backends/base.py in _get_session

self.accessed = True
try:
return self._session_cache
except AttributeError:
if self._session_key is None or no_load:
self._session_cache = {}
else:

self._session_cache = self.load() ...

return self._session_cache
_session = property(_get_session)
def get_expiry_age(self):
"""Get the number of seconds until the session expires."""

▶ Local vars

Variable	Value
no_load	False
self	<django.contrib.sessions.backends.db.SessionStore object at 0x2753190>

/var/www/qa.openmicroscopy.org.uk/OMERO.qa/django/contrib/sessions/backends/db.py in load

"""
Implements database session store.
"""
def load(self):
try:
s = Session.objects.get(
session_key = self.session_key,

expire_date__gt=datetime.datetime.now() ...

)
return self.decode(force_unicode(s.session_data))
except (Session.DoesNotExist, SuspiciousOperation):
self.create()
return {}

▶ Local vars

Variable	Value
self	<django.contrib.sessions.backends.db.SessionStore object at 0x2753190>

/var/www/qa.openmicroscopy.org.uk/OMERO.qa/django/db/models/manager.py in get

def distinct(self, *args, **kwargs):
return self.get_query_set().distinct(*args, **kwargs)
def extra(self, *args, **kwargs):
return self.get_query_set().extra(*args, **kwargs)
def get(self, *args, **kwargs):

return self.get_query_set().get(*args, **kwargs) ...

def get_or_create(self, **kwargs):
return self.get_query_set().get_or_create(**kwargs)
def create(self, **kwargs):
return self.get_query_set().create(**kwargs)

▶ Local vars

Variable	Value
args	()
kwargs	{'expire_date__gt': datetime.datetime(2009, 10, 11, 15, 24, 53, 213837), 'session_key': '87510fae1bb6af3987bee593b45f869a'}
self	<django.contrib.sessions.models.SessionManager object at 0x2f71390>

/var/www/qa.openmicroscopy.org.uk/OMERO.qa/django/db/models/query.py in get

def get(self, *args, **kwargs):
"""
Performs the query and returns a single object matching the given
keyword arguments.
"""
clone = self.filter(*args, **kwargs)

num = len(clone) ...

if num == 1:
return clone._result_cache[0]
if not num:
raise self.model.DoesNotExist("%s matching query does not exist."
% self.model._meta.object_name)
raise self.model.MultipleObjectsReturned("get() returned more than one %s -- it returned %s! Lookup parameters were %s"

▶ Local vars

Variable	Value
args	()
clone	Error in formatting: FATAL: connection limit exceeded for non-superusers
kwargs	{'expire_date__gt': datetime.datetime(2009, 10, 11, 15, 24, 53, 213837), 'session_key': '87510fae1bb6af3987bee593b45f869a'}
self	Error in formatting: FATAL: connection limit exceeded for non-superusers

/var/www/qa.openmicroscopy.org.uk/OMERO.qa/django/db/models/query.py in __len__

# Since __len__ is called quite frequently (for example, as part of
# list(qs), we make some effort here to be as efficient as possible
# whilst not messing up any existing iterators against the QuerySet.
if self._result_cache is None:
if self._iter:
self._result_cache = list(self._iter)
else:

self._result_cache = list(self.iterator()) ...

elif self._iter:
self._result_cache.extend(list(self._iter))
return len(self._result_cache)
def __iter__(self):
if self._result_cache is None:

▶ Local vars

Variable	Value
self	Error in formatting: FATAL: connection limit exceeded for non-superusers

/var/www/qa.openmicroscopy.org.uk/OMERO.qa/django/db/models/query.py in iterator

if isinstance(fill_cache, dict):
requested = fill_cache
else:
requested = None
max_depth = self.query.max_depth
extra_select = self.query.extra_select.keys()
index_start = len(extra_select)

for row in self.query.results_iter(): ...

if fill_cache:
obj, _ = get_cached_row(self.model, row, index_start,
max_depth, requested=requested)
else:
obj = self.model(*row[index_start:])
for i, k in enumerate(extra_select):

▶ Local vars

Variable	Value
extra_select	[]
fill_cache	False
index_start	0
max_depth	5
requested	None
self	Error in formatting: FATAL: connection limit exceeded for non-superusers

/var/www/qa.openmicroscopy.org.uk/OMERO.qa/django/db/models/sql/query.py in results_iter

def results_iter(self):
"""
Returns an iterator over the results from executing this query.
"""
resolve_columns = hasattr(self, 'resolve_columns')
fields = None

for rows in self.execute_sql(MULTI): ...

for row in rows:
if resolve_columns:
if fields is None:
# We only set this up here because
# related_select_fields isn't populated until
# execute_sql() has been called.

▶ Local vars

Variable	Value
fields	None
resolve_columns	False
self	<django.db.models.sql.query.BaseQuery object at 0x396e750>

/var/www/qa.openmicroscopy.org.uk/OMERO.qa/django/db/models/sql/query.py in execute_sql

raise EmptyResultSet
except EmptyResultSet:
if result_type == MULTI:
return empty_iter()
else:
return

cursor = self.connection.cursor() ...

cursor.execute(sql, params)
if not result_type:
return cursor
if result_type == SINGLE:
if self.ordering_aliases:

▶ Local vars

Variable	Value
params	('87510fae1bb6af3987bee593b45f869a', u'2009-10-11 15:24:53.213837')
result_type	'multi'
self	<django.db.models.sql.query.BaseQuery object at 0x396e750>
sql	'SELECT "django_session"."session_key", "django_session"."session_data", "django_session"."expire_date" FROM "django_session" WHERE ("django_session"."session_key" = %s AND "django_session"."expire_date" > %s )'

/var/www/qa.openmicroscopy.org.uk/OMERO.qa/django/db/backends/__init__.py in cursor

def close(self):
if self.connection is not None:
self.connection.close()
self.connection = None
def cursor(self):
from django.conf import settings

cursor = self._cursor(settings) ...

if settings.DEBUG:
return self.make_debug_cursor(cursor)
return cursor
def make_debug_cursor(self, cursor):
return util.CursorDebugWrapper(cursor, self)

▶ Local vars

Variable	Value
self	<django.db.backends.postgresql_psycopg2.base.DatabaseWrapper object at 0x27f4ec0>
settings	<django.conf.LazySettings object at 0x239be10>

/var/www/qa.openmicroscopy.org.uk/OMERO.qa/django/db/backends/postgresql_psycopg2/base.py in _cursor

conn_params['user'] = settings.DATABASE_USER
if settings.DATABASE_PASSWORD:
conn_params['password'] = settings.DATABASE_PASSWORD
if settings.DATABASE_HOST:
conn_params['host'] = settings.DATABASE_HOST
if settings.DATABASE_PORT:
conn_params['port'] = settings.DATABASE_PORT

self.connection = Database.connect(**conn_params) ...

self.connection.set_isolation_level(1) # make transactions transparent to all cursors
self.connection.set_client_encoding('UTF8')
cursor = self.connection.cursor()
cursor.tzinfo_factory = None
if set_tz:
cursor.execute("SET TIME ZONE %s", [settings.TIME_ZONE])

▶ Local vars

Variable	Value
conn_params	{'database': 'feedback', 'host': 'localhost', 'password': 'WeckDozt7', 'user': 'feedback'}
self	<django.db.backends.postgresql_psycopg2.base.DatabaseWrapper object at 0x27f4ec0>
set_tz	True
settings	<django.conf.LazySettings object at 0x239be10>

Environment:

Request Method: GET
Request URL: http://qa.openmicroscopy.org.uk/qa/ticket/add/140/
Django Version: 1.0.3
Python Version: 2.6.2
Installed Applications:
['django.contrib.admin',
 'django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.markup',
 'django.contrib.sessions',
 'django.contrib.sites',
 'omero_qa.qa',
 'omero_qa.feedback',
 'omero_qa.registry',
 'omero_qa.validator']
Installed Middleware:
('django.middleware.common.CommonMiddleware',
 'django.contrib.sessions.middleware.SessionMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'djangologging.middleware.LoggingMiddleware',
 'django.middleware.http.SetRemoteAddrFromForwardedFor')

Traceback:
File "/var/www/qa.openmicroscopy.org.uk/OMERO.qa/django/core/handlers/base.py" in get_response
  91.                 response = callback(request, *callback_args, **callback_kwargs)
File "/var/www/qa.openmicroscopy.org.uk/OMERO.qa/omero_qa/qa/views.py" in ticket
  990.     error = check_if_error(request)
File "/var/www/qa.openmicroscopy.org.uk/OMERO.qa/omero_qa/qa/views.py" in check_if_error
  290.         request.session['error'] = None
File "/var/www/qa.openmicroscopy.org.uk/OMERO.qa/django/contrib/sessions/backends/base.py" in __setitem__
  49.         self._session[key] = value
File "/var/www/qa.openmicroscopy.org.uk/OMERO.qa/django/contrib/sessions/backends/base.py" in _get_session
  172.                 self._session_cache = self.load()
File "/var/www/qa.openmicroscopy.org.uk/OMERO.qa/django/contrib/sessions/backends/db.py" in load
  16.                 expire_date__gt=datetime.datetime.now()
File "/var/www/qa.openmicroscopy.org.uk/OMERO.qa/django/db/models/manager.py" in get
  117.         return self.get_query_set().get(*args, **kwargs)
File "/var/www/qa.openmicroscopy.org.uk/OMERO.qa/django/db/models/query.py" in get
  317.         num = len(clone)
File "/var/www/qa.openmicroscopy.org.uk/OMERO.qa/django/db/models/query.py" in __len__
  173.                 self._result_cache = list(self.iterator())
File "/var/www/qa.openmicroscopy.org.uk/OMERO.qa/django/db/models/query.py" in iterator
  288.         for row in self.query.results_iter():
File "/var/www/qa.openmicroscopy.org.uk/OMERO.qa/django/db/models/sql/query.py" in results_iter
  205.         for rows in self.execute_sql(MULTI):
File "/var/www/qa.openmicroscopy.org.uk/OMERO.qa/django/db/models/sql/query.py" in execute_sql
  1819.         cursor = self.connection.cursor()
File "/var/www/qa.openmicroscopy.org.uk/OMERO.qa/django/db/backends/__init__.py" in cursor
  56.         cursor = self._cursor(settings)
File "/var/www/qa.openmicroscopy.org.uk/OMERO.qa/django/db/backends/postgresql_psycopg2/base.py" in _cursor
  87.             self.connection = Database.connect(**conn_params)

Exception Type: OperationalError at /qa/ticket/add/140/
Exception Value: FATAL:  connection limit exceeded for non-superusers

Request information

GET

No GET data

POST

No POST data

Variable	Value
sessionid	'87510fae1bb6af3987bee593b45f869a'

Variable	Value
AUTH_TYPE	None
CONTENT_LENGTH	0L
CONTENT_TYPE	None
GATEWAY_INTERFACE	'CGI/1.1'
HTTP_ACCEPT	'text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8'
HTTP_ACCEPT_CHARSET	'ISO-8859-1,utf-8;q=0.7,*;q=0.7'
HTTP_ACCEPT_ENCODING	'gzip,deflate'
HTTP_ACCEPT_LANGUAGE	'en-us,en;q=0.5'
HTTP_CONNECTION	'keep-alive'
HTTP_COOKIE	'sessionid=87510fae1bb6af3987bee593b45f869a'
HTTP_HOST	'qa.openmicroscopy.org.uk'
HTTP_KEEP_ALIVE	'300'
HTTP_REFERER	'http://qa.openmicroscopy.org.uk/qa/feedback/140/'
HTTP_USER_AGENT	'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.4; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3'
PATH_INFO	u'/qa/ticket/add/140/'
PATH_TRANSLATED	None
QUERY_STRING	None
REMOTE_ADDR	'89.48.1.61'
REMOTE_HOST	None
REMOTE_IDENT	None
REMOTE_USER	None
REQUEST_METHOD	'GET'
SCRIPT_NAME	''
SERVER_NAME	'qa.openmicroscopy.org.uk'
SERVER_PORT	80
SERVER_PROTOCOL	'HTTP/1.1'
SERVER_SOFTWARE	'mod_python'

Settings

Using settings module `omero_qa.settings-prod`

Setting	Value
ABSOLUTE_URL_OVERRIDES	{}
AD	False
ADMINS	(('Ola', 'a.tarkowska@dundee.ac.uk'),)
ADMIN_FOR	()
ADMIN_MEDIA_PREFIX	'/admin_static/'
AD_DNS_NAME	'ldap.lifesci.dundee.ac.uk'
AD_LDAP_PORT	389
AD_LDAP_URL	'ldap://ldap.lifesci.dundee.ac.uk:389'
AD_NT4_DOMAIN	'ou=edir,ou=people,ou=lifesci,o=dundee'
AD_SEARCH_DN	'ou=people,ou=lifesci,o=dundee'
AD_SEARCH_FIELDS	['cn', 'mail', 'givenName', 'sn']
ALLOWED_INCLUDE_ROOTS	()
APPEND_SLASH	True
APPLICATION_HOST	'http://qa.openmicroscopy.org.uk'
AUTHENTICATION_BACKENDS	('omero_qa.extlib.auth.ActiveDirectoryBackend', 'django.contrib.auth.backends.ModelBackend')
BANNED_IPS	()
CACHE_BACKEND	'locmem://'
CACHE_MIDDLEWARE_KEY_PREFIX	''
CACHE_MIDDLEWARE_SECONDS	600
COMMENTS_ALLOW_PROFANITIES	False
COMMENTS_BANNED_USERS_GROUP	None
COMMENTS_FIRST_FEW	0
COMMENTS_MODERATORS_GROUP	None
COMMENTS_SKETCHY_USERS_GROUP	None
DATABASE_ENGINE	'postgresql_psycopg2'
DATABASE_HOST	'localhost'
DATABASE_NAME	'feedback'
DATABASE_OPTIONS	{}
DATABASE_PASSWORD	'********************'
DATABASE_PORT	''
DATABASE_USER	'feedback'
DATETIME_FORMAT	'N j, Y, P'
DATE_FORMAT	'N j, Y'
DEBUG	False
DEBUG_PROPAGATE_EXCEPTIONS	False
DEFAULT_CHARSET	'utf-8'
DEFAULT_CONTENT_TYPE	'text/html'
DEFAULT_FILE_STORAGE	'django.core.files.storage.FileSystemStorage'
DEFAULT_FROM_EMAIL	'webmaster@localhost'
DEFAULT_INDEX_TABLESPACE	''
DEFAULT_TABLESPACE	''
DISALLOWED_USER_AGENTS	()
EMAIL_HOST	'localhost'
EMAIL_HOST_PASSWORD	'********************'
EMAIL_HOST_USER	''
EMAIL_PORT	25
EMAIL_SUBJECT_PREFIX	'[OMERO.qa] '
EMAIL_USE_TLS	False
FEEDBACK_URL	'qa.openmicroscopy.org.uk:80'
FILE_CHARSET	'utf-8'
FILE_UPLOAD_HANDLERS	('django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler')
FILE_UPLOAD_MAX_MEMORY_SIZE	2621440
FILE_UPLOAD_PERMISSIONS	None
FILE_UPLOAD_TEMP_DIR	'/tmp'
FIXTURE_DIRS	()
FORCE_SCRIPT_NAME	None
GEODAT	'/var/www/qa.openmicroscopy.org.uk/OMERO.qa/omero_qa/GeoLiteCity.dat'
GOOGLE_KEY	'ABQIAAAAcRzATjAJdby3MFL9GQa0OhRqbsBcHxR9xxPqA8GjYogFnH1J4xSnQ9xYPWE39vtgyZ0wgekly9YXcA'
GOOGLE_KEY2	'ABQIAAAAcRzATjAJdby3MFL9GQa0OhSJ5mqXSVIaJQSCXsyOCg8XLmEJRBRcahPP7Q8U662olPAw_35hhwCPhQ'
IGNORABLE_404_ENDS	'*.ico'
IGNORABLE_404_STARTS	('/cgi-bin/', '/_vti_bin', '/_vti_inf')
INSTALLED_APPS	['django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.markup', 'django.contrib.sessions', 'django.contrib.sites', 'omero_qa.qa', 'omero_qa.feedback', 'omero_qa.registry', 'omero_qa.validator']
INTERNAL_IPS	()
JING_PATH	'/usr/bin/jing'
LANGUAGES	(('ar', 'Arabic'), ('bn', 'Bengali'), ('bg', 'Bulgarian'), ('ca', 'Catalan'), ('cs', 'Czech'), ('cy', 'Welsh'), ('da', 'Danish'), ('de', 'German'), ('el', 'Greek'), ('en', 'English'), ('es', 'Spanish'), ('et', 'Estonian'), ('es-ar', 'Argentinean Spanish'), ('eu', 'Basque'), ('fa', 'Persian'), ('fi', 'Finnish'), ('fr', 'French'), ('ga', 'Irish'), ('gl', 'Galician'), ('hu', 'Hungarian'), ('he', 'Hebrew'), ('hi', 'Hindi'), ('hr', 'Croatian'), ('is', 'Icelandic'), ('it', 'Italian'), ('ja', 'Japanese'), ('ka', 'Georgian'), ('ko', 'Korean'), ('km', 'Khmer'), ('kn', 'Kannada'), ('lv', 'Latvian'), ('lt', 'Lithuanian'), ('mk', 'Macedonian'), ('nl', 'Dutch'), ('no', 'Norwegian'), ('pl', 'Polish'), ('pt', 'Portuguese'), ('pt-br', 'Brazilian Portuguese'), ('ro', 'Romanian'), ('ru', 'Russian'), ('sk', 'Slovak'), ('sl', 'Slovenian'), ('sr', 'Serbian'), ('sv', 'Swedish'), ('ta', 'Tamil'), ('te', 'Telugu'), ('th', 'Thai'), ('tr', 'Turkish'), ('uk', 'Ukrainian'), ('zh-cn', 'Simplified Chinese'), ('zh-tw', 'Traditional Chinese'))
LANGUAGES_BIDI	('he', 'ar', 'fa')
LANGUAGE_CODE	'en-gb'
LANGUAGE_COOKIE_NAME	'django_language'
LEVEL	20
LOCALE_PATHS	()
LOGDIR	'/var/www/qa.openmicroscopy.org.uk/OMERO.qa/omero_qa/log'
LOGFILE	'OMEROqa.log'
LOGGING_LOG_SQL	False
LOGIN_REDIRECT_URL	'/accounts/profile/'
LOGIN_URL	'/accounts/login/'
LOGOUT_URL	'/accounts/logout/'
MANAGERS	(('Ola', 'a.tarkowska@dundee.ac.uk'),)
MEDIA_ROOT	''
MEDIA_URL	''
MIDDLEWARE_CLASSES	('django.middleware.common.CommonMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'djangologging.middleware.LoggingMiddleware', 'django.middleware.http.SetRemoteAddrFromForwardedFor')
MONTH_DAY_FORMAT	'F j'
OME_HUDSON_PATH	'/ome/hudson/jobs'
PASSWORD_RESET_TIMEOUT_DAYS	'********************'
PERPAGE	25
PREPEND_WWW	False
PROFANITIES_LIST	'********************'
ROOT_URLCONF	'omero_qa.urls'
SECRET_KEY	'********************'
SEND_BROKEN_LINK_EMAILS	False
SERVER_EMAIL	'qa@openmicroscopy.org.uk'
SESSION_COOKIE_AGE	86400
SESSION_COOKIE_DOMAIN	None
SESSION_COOKIE_NAME	'sessionid'
SESSION_COOKIE_PATH	'/'
SESSION_COOKIE_SECURE	False
SESSION_ENGINE	'django.contrib.sessions.backends.db'
SESSION_EXPIRE_AT_BROWSER_CLOSE	True
SESSION_FILE_PATH	None
SESSION_SAVE_EVERY_REQUEST	False
SETTINGS_MODULE	'omero_qa.settings-prod'
SITE_ID	1
TEMPLATE_CONTEXT_PROCESSORS	('django.core.context_processors.auth', 'django.core.context_processors.debug', 'django.core.context_processors.i18n', 'django.core.context_processors.media')
TEMPLATE_DEBUG	False
TEMPLATE_DIRS	('/var/www/qa.openmicroscopy.org.uk/OMERO.qa/djangologging/templates', '/var/www/qa.openmicroscopy.org.uk/OMERO.qa/omero_qa/feedback/templates', '/var/www/qa.openmicroscopy.org.uk/OMERO.qa/omero_qa/qa/templates', '/var/www/qa.openmicroscopy.org.uk/OMERO.qa/omero_qa/registry/templates', '/var/www/qa.openmicroscopy.org.uk/OMERO.qa/omero_qa/validator/templates')
TEMPLATE_LOADERS	('django.template.loaders.filesystem.load_template_source', 'django.template.loaders.app_directories.load_template_source')
TEMPLATE_STRING_IF_INVALID	''
TESTNG_ROOT	'/var/www/qa.openmicroscopy.org.uk/OMERO.qa/TestNG'
TEST_DATABASE_CHARSET	None
TEST_DATABASE_COLLATION	None
TEST_DATABASE_NAME	None
TEST_RUNNER	'django.test.simple.run_tests'
TIME_FORMAT	'P'
TIME_ZONE	'Europe/London'
TRANSACTIONS_MANAGED	False
UPLOAD_ROOT	'/var/www/qa.openmicroscopy.org.uk/OMERO.qa/FileStore'
URL_VALIDATOR_USER_AGENT	'Django/1.0.3 (http://www.djangoproject.com)'
USE_ETAGS	False
USE_I18N	True
VALIDATOR_UPLOAD_ROOT	'/var/www/qa.openmicroscopy.org.uk/OMERO.qa/Validator'
YEAR_MONTH_FORMAT	'F Y'

OperationalError at /qa/ticket/add/140/

Traceback Switch to copy-and-paste view

Request information

GET

POST

COOKIES

META

Settings

Using settings module omero_qa.settings-prod

Using settings module `omero_qa.settings-prod`