Michael Bayer wrote: > there seems to be more going on there, but perhaps are all side effects of > the same thing: > > http://www.sqlalchemy.org/trac/wiki/FAQ#MySQLserverhasgoneawaypsycopg.InterfaceError:connectionalreadyclosed > > or otherwise your mysql client is not able to connect at all. I have switched to trying postgresql, to see what shows up.
The new problem being that it appears I have WAY TOO MANY processes open to the database being made: braydon 24226 0.2 8.5 339524 33536 pts/2 Sl Feb04 0:13 python http_server.py postgres 24229 0.0 1.7 102416 6968 ? Ss Feb04 0:00 postgres: braydon braydon 127.0.0.1(35089) idle in transaction postgres 24233 0.0 1.6 102300 6356 ? Ss Feb04 0:00 postgres: braydon braydon 127.0.0.1(35093) idle postgres 24277 0.0 1.2 101876 4836 ? Ss Feb04 0:00 postgres: braydon braydon 127.0.0.1(35564) idle postgres 24412 0.0 1.2 101876 4840 ? Ss 00:02 0:00 postgres: braydon braydon 127.0.0.1(59737) idle postgres 24483 0.0 1.2 101876 4836 ? Ss 00:17 0:00 postgres: braydon braydon 127.0.0.1(53032) idle postgres 24547 0.0 1.2 101876 4840 ? Ss 00:32 0:00 postgres: braydon braydon 127.0.0.1(33366) idle postgres 24675 0.0 1.2 101876 4840 ? Ss 01:00 0:00 postgres: braydon braydon 127.0.0.1(54586) idle postgres 24676 0.0 1.2 101880 4840 ? Ss 01:00 0:00 postgres: braydon braydon 127.0.0.1(54589) idle postgres 24677 0.0 1.2 101876 4828 ? Ss 01:00 0:00 postgres: braydon braydon 127.0.0.1(54591) idle postgres 24736 0.0 1.2 101876 4832 ? Ss 01:12 0:00 postgres: braydon braydon 127.0.0.1(51563) idle postgres 24741 0.0 1.2 101876 4840 ? Ss 01:13 0:00 postgres: braydon braydon 127.0.0.1(51579) idle postgres 24743 0.0 1.2 101876 4844 ? Ss 01:13 0:00 postgres: braydon braydon 127.0.0.1(51585) idle postgres 24756 0.0 1.2 101876 4844 ? Ss 01:15 0:00 postgres: braydon braydon 127.0.0.1(42054) idle postgres 24773 0.0 0.5 100724 2148 ? Ds 01:18 0:00 postgres: autovacuum worker process I am using the following to establish get the database going: import cherrypy from sparrow.settings import Settings from sparrow.database import Database from sparrow.templates import render db = Database() settings = Settings() class Root(): def __init__(self): self.cmd = __import__('exposed', globals(), locals(),['sparrow']) db.create_all() def default(self, *args, **kwargs): location_st = "" for arg in args: location_st += "/"+arg try: return render(args, kwargs, location_st) except: db.start_engine() return render(args, kwargs, location_st) default.exposed = True This is the wrong way to go about insuring that there is a DB connection. I'd like to know the correct way. Would this be to test the database, and if that fails to open a connection? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---