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