On Wed, Mar 21, 2012 at 11:20 AM, William Stein <wst...@gmail.com> wrote:
> On Wed, Mar 21, 2012 at 5:32 AM, David Roe <r...@math.harvard.edu> wrote:
>> This seems to be happening much more frequently right now.  Could someone
>> with root on boxen either restart the postgres server or kill some of the
>> postgres processes?
>
> Done.  I don't know if anybody also did so in the last five hours...

Restarting postgres doesn't fix the problem.

>
>>
>> I'm afraid this is my fault: I've started a few long running processes while
>> experimenting with SQL reports and can't kill them.
>> David
>>
>>
>> On Sun, Mar 18, 2012 at 17:34, Hugh Thomas <hugh.ross.tho...@gmail.com>
>> wrote:
>>>
>>>
>>> Twice, today, instead of the page I was expecting, trac produced something
>>> like this:
>>>
>>> Traceback (most recent call last):
>>>   File
>>> "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/web/api.py",
>>> line 377, in send_error
>>>     'text/html')
>>>   File
>>> "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/web/chrome.py",
>>> line 725, in render_template
>>>     req.chrome[type_].append(
>>>   File
>>> "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/web/api.py",
>>> line 195, in __getattr__
>>>     value = self.callbacks[name](self)
>>>   File
>>> "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/web/chrome.py",
>>> line 489, in prepare_request
>>>     for category, name, text in contributor.get_navigation_items(req):
>>>   File
>>> "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/ticket/web_ui.py",
>>> line 163, in get_navigation_items
>>>     if 'TICKET_CREATE' in req.perm:
>>>   File
>>> "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/web/api.py",
>>> line 195, in __getattr__
>>>     value = self.callbacks[name](self)
>>>   File
>>> "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/web/main.py",
>>> line 261, in _get_perm
>>>     return PermissionCache(self.env, self.authenticate(req))
>>>   File
>>> "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/web/main.py",
>>> line 133, in authenticate
>>>     authname = authenticator.authenticate(req)
>>>   File
>>> "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/web/auth.py",
>>> line 70, in authenticate
>>>     authname = self._get_name_for_cookie(req, req.incookie['trac_auth'])
>>>   File
>>> "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/web/auth.py",
>>> line 184, in _get_name_for_cookie
>>>     db = self.env.get_db_cnx()
>>>   File
>>> "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/env.py", line
>>> 273, in get_db_cnx
>>>     return DatabaseManager(self).get_connection()
>>>   File
>>> "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/db/api.py",
>>> line 87, in get_connection
>>>     return self._cnx_pool.get_cnx(self.timeout or None)
>>>   File
>>> "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/db/pool.py",
>>> line 176, in get_cnx
>>>     return _backend.get_cnx(self._connector, self._kwargs, timeout)
>>>   File
>>> "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/db/pool.py",
>>> line 109, in get_cnx
>>>     cnx = connector.get_connection(**kwargs)
>>>   File
>>> "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/db/postgres_backend.py",
>>> line 53, in get_connection
>>>     params)
>>>   File
>>> "/usr/lib/python2.5/site-packages/Trac-0.11.5-py2.5.egg/trac/db/postgres_backend.py",
>>> line 183, in __init__
>>>     cnx = psycopg.connect(' '.join(dsn))
>>> OperationalError: FATAL:  connection limit exceeded for non-superusers
>>>
>>> I don't think I was doing anything especially controversial (looking
>>> through a multi-page ticket report one time, trying to post a ticket the
>>> second time).  So it occurred to me that it might be related to the
>>> upgrade.  This was between 5:00 pm and 5:30 pm PDT.
>>>
>>> cheers,
>>>
>>> Hugh
>>>
>>>
>>> --
>>> To post to this group, send an email to sage-devel@googlegroups.com
>>> To unsubscribe from this group, send an email to
>>> sage-devel+unsubscr...@googlegroups.com
>>> For more options, visit this group at
>>> http://groups.google.com/group/sage-devel
>>> URL: http://www.sagemath.org
>>
>>
>> --
>> To post to this group, send an email to sage-devel@googlegroups.com
>> To unsubscribe from this group, send an email to
>> sage-devel+unsubscr...@googlegroups.com
>> For more options, visit this group at
>> http://groups.google.com/group/sage-devel
>> URL: http://www.sagemath.org
>
>
>
> --
> William Stein
> Professor of Mathematics
> University of Washington
> http://wstein.org



-- 
William Stein
Professor of Mathematics
University of Washington
http://wstein.org

-- 
To post to this group, send an email to sage-devel@googlegroups.com
To unsubscribe from this group, send an email to 
sage-devel+unsubscr...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/sage-devel
URL: http://www.sagemath.org

Reply via email to