On 6/26/14, 1:49 PM, Dustin Oprea wrote: > > > On Jun 26, 2014 1:34 PM, "Mike Bayer" <mike...@zzzcomputing.com > <mailto:mike...@zzzcomputing.com>> wrote: > > > > that looks pretty much like modules are being reloaded in > process. Either get web.py to not reload the "sqlalchemy" modules, > or if it has to, then get it to fully load "sqlalchemy" completely. > I see that "reload(mod)" right in the stack trace there. > > Sure, but I have a dozen web.py projects, and gave been using it for a > while, and haven't had this issue until yesterday. I thought that too, > but doubt that's it. >
I guarantee you that is "it" - maybe it was not being called on this particular module or combination of modules. module reloading is bad IMHO. > > Dustin > > > > > > > > > > > > On 6/26/14, 1:14 PM, Dustin Oprea wrote: > >> > >> I'm using SQLAlchemy with web.py, and have used it many times in > the past. I'm working on a project using gevent/greenlets, and > everything has been fine for a couple of months, until today. > >> > >> Suddenly, I'm getting these at a time when I'm not even receiving > any requests. Does anyone have any advice or steps to troubleshoot? > >> > >>> Traceback (most recent call last): > >>> File > "/usr/local/lib/python2.7/dist-packages/web/application.py", line 237, > in process > >>> return p(lambda: process(processors)) > >>> File > "/usr/local/lib/python2.7/dist-packages/web/application.py", line 565, > in processor > >>> h() > >>> File > "/usr/local/lib/python2.7/dist-packages/web/application.py", line 661, > in __call__ > >>> self.check(mod) > >>> File > "/usr/local/lib/python2.7/dist-packages/web/application.py", line 680, > in check > >>> reload(mod) > >>> File > "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/reflection.py", > line 58, in <module> > >>> class Inspector(object): > >>> File > "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/reflection.py", > line 136, in Inspector > >>> @inspection._inspects(Connectable) > >>> File > "/usr/local/lib/python2.7/dist-packages/sqlalchemy/inspection.py", > line 84, in decorate > >>> "registered" % type_) > >>> AssertionError: Type <class > 'sqlalchemy.engine.interfaces.Connectable'> is already registered > >>> > >>> Traceback (most recent call last): > >>> File > "/usr/local/lib/python2.7/dist-packages/web/application.py", line 237, > in process > >>> return p(lambda: process(processors)) > >>> File > "/usr/local/lib/python2.7/dist-packages/web/application.py", line 565, > in processor > >>> h() > >>> File > "/usr/local/lib/python2.7/dist-packages/web/application.py", line 661, > in __call__ > >>> self.check(mod) > >>> File > "/usr/local/lib/python2.7/dist-packages/web/application.py", line 680, > in check > >>> reload(mod) > >>> File > "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/reflection.py", > line 58, in <module> > >>> class Inspector(object): > >>> File > "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/reflection.py", > line 136, in Inspector > >>> @inspection._inspects(Connectable) > >>> File > "/usr/local/lib/python2.7/dist-packages/sqlalchemy/inspection.py", > line 84, in decorate > >>> "registered" % type_) > >>> AssertionError: Type <class > 'sqlalchemy.engine.interfaces.Connectable'> is already registered > >>> > >>> Traceback (most recent call last): > >>> File > "/usr/local/lib/python2.7/dist-packages/web/application.py", line 237, > in process > >>> return p(lambda: process(processors)) > >>> File > "/usr/local/lib/python2.7/dist-packages/web/application.py", line 565, > in processor > >>> h() > >>> File > "/usr/local/lib/python2.7/dist-packages/web/application.py", line 661, > in __call__ > >>> self.check(mod) > >>> File > "/usr/local/lib/python2.7/dist-packages/web/application.py", line 680, > in check > >>> reload(mod) > >>> File > "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/reflection.py", > line 58, in <module> > >>> class Inspector(object): > >>> File > "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/reflection.py", > line 136, in Inspector > >>> @inspection._inspects(Connectable) > >>> File > "/usr/local/lib/python2.7/dist-packages/sqlalchemy/inspection.py", > line 84, in decorate > >>> "registered" % type_) > >>> AssertionError: Type <class > 'sqlalchemy.engine.interfaces.Connectable'> is already registered > >>> > >>> Traceback (most recent call last): > >>> File > "/usr/local/lib/python2.7/dist-packages/web/application.py", line 237, > in process > >>> return p(lambda: process(processors)) > >>> File > "/usr/local/lib/python2.7/dist-packages/web/application.py", line 565, > in processor > >>> h() > >>> File > "/usr/local/lib/python2.7/dist-packages/web/application.py", line 661, > in __call__ > >>> self.check(mod) > >>> File > "/usr/local/lib/python2.7/dist-packages/web/application.py", line 680, > in check > >>> reload(mod) > >>> File > "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/reflection.py", > line 58, in <module> > >>> class Inspector(object): > >>> File > "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/reflection.py", > line 136, in Inspector > >>> @inspection._inspects(Connectable) > >>> File > "/usr/local/lib/python2.7/dist-packages/sqlalchemy/inspection.py", > line 84, in decorate > >>> "registered" % type_) > >>> AssertionError: Type <class > 'sqlalchemy.engine.interfaces.Connectable'> is already registered > >>> > >>> Traceback (most recent call last): > >>> File > "/usr/local/lib/python2.7/dist-packages/web/application.py", line 237, > in process > >>> return p(lambda: process(processors)) > >>> File > "/usr/local/lib/python2.7/dist-packages/web/application.py", line 565, > in processor > >>> h() > >>> File > "/usr/local/lib/python2.7/dist-packages/web/application.py", line 661, > in __call__ > >>> self.check(mod) > >>> File > "/usr/local/lib/python2.7/dist-packages/web/application.py", line 680, > in check > >>> reload(mod) > >>> File > "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/reflection.py", > line 58, in <module> > >>> class Inspector(object): > >>> File > "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/reflection.py", > line 136, in Inspector > >>> @inspection._inspects(Connectable) > >>> File > "/usr/local/lib/python2.7/dist-packages/sqlalchemy/inspection.py", > line 84, in decorate > >>> "registered" % type_) > >>> AssertionError: Type <class > 'sqlalchemy.engine.interfaces.Connectable'> is already registered > >> > >> > >> > >> > >> Dustin > >> > >> -- > >> You received this message because you are subscribed to the Google > Groups "sqlalchemy" group. > >> To unsubscribe from this group and stop receiving emails from it, > send an email to sqlalchemy+unsubscr...@googlegroups.com > <mailto:sqlalchemy%2bunsubscr...@googlegroups.com>. > >> > >> To post to this group, send email to sqlalchemy@googlegroups.com > <mailto:sqlalchemy@googlegroups.com>. > >> Visit this group at http://groups.google.com/group/sqlalchemy. > >> For more options, visit https://groups.google.com/d/optout. > > > > > > -- > > You received this message because you are subscribed to a topic in > the Google Groups "sqlalchemy" group. > > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/sqlalchemy/7i-ejkz8VWg/unsubscribe. > > To unsubscribe from this group and all its topics, send an email to > sqlalchemy+unsubscr...@googlegroups.com > <mailto:sqlalchemy%2bunsubscr...@googlegroups.com>. > > To post to this group, send email to sqlalchemy@googlegroups.com > <mailto:sqlalchemy@googlegroups.com>. > > Visit this group at http://groups.google.com/group/sqlalchemy. > > For more options, visit https://groups.google.com/d/optout. > > -- > You received this message because you are subscribed to the Google > Groups "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send > an email to sqlalchemy+unsubscr...@googlegroups.com > <mailto:sqlalchemy+unsubscr...@googlegroups.com>. > To post to this group, send email to sqlalchemy@googlegroups.com > <mailto:sqlalchemy@googlegroups.com>. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.