Issues with multiple databases

[asarch]

With:

alembic==0.7.5.post2
Babel==1.3
backlash==0.0.7
Beaker==1.6.5.post1
cliff==1.10.1
cmd2==0.6.8
crank==0.7.2
decorator==3.4.2
FormEncode==1.3.0
gearbox==0.0.7
Genshi==0.7
Mako==1.0.1
MarkupSafe==0.23
PasteDeploy==1.5.2
pbr==0.10.8
prettytable==0.7.2

FIXME: could not find svn URL in dependency_links for this package:

proyectos===0.1dev-r0
psycopg2==2.6
Pygments==2.0.2
pyparsing==2.0.3
pytz==2015.2
repoze.lru==0.6
repoze.who==2.2
six==1.9.0
speaklater==1.3
sprox==0.9.5
SQLAlchemy==0.9.9
stevedore==1.3.0
Tempita==0.5.2
tg.devtools==2.3.4
tgext.admin==0.6.4
tgext.crud==0.7.3
tgext.debugbar==0.2.4
transaction==1.4.3
TurboGears2==2.3.4
tw2.core==2.2.2
tw2.forms==2.2.2.1
WebOb==1.4
WebTest==1.4.3
zope.interface==4.1.2
zope.sqlalchemy==0.7.6

by setting:

admin1 = AdminController(...)
admin2 = AdminController(...)

sqlalchemy.orm.exc.DetachedInstanceError

DetachedInstanceError: Instance <User at 0xb643e0ac> is not bound to a Session; attribute refresh operation cannot proceed
Traceback (most recent call last)

File "/home/asarch/tg2dev/lib/python2.7/site-packages/tgext/debugbar/templates/debugbar.html", line 47, in <Expression u'Markup(sect.content())'>
<div class="tgdb_content_box" py:content="Markup(sect.content())" />
File "/home/asarch/tg2dev/lib/python2.7/site-packages/tgext/debugbar/sections/request_vars.py", line 59, in content
for k, v in request.environ.iteritems()]
File "/usr/lib/python2.7/pprint.py", line 67, in saferepr
return _safe_repr(object, {}, None, 0)[0]
File "/usr/lib/python2.7/pprint.py", line 289, in _safe_repr
vrepr, vreadable, vrecur = saferepr(v, context, maxlevels, level)
File "/usr/lib/python2.7/pprint.py", line 330, in _safe_repr
rep = repr(object)
File "/home/asarch/tg2dev/proyectos/proyectos/model/auth.py", line 82, in __repr__
repr(self.user_name), repr(self.email_address), repr(self.display_name))
File "/home/asarch/tg2dev/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 239, in __get__
return self.impl.get(instance_state(instance), dict_)
File "/home/asarch/tg2dev/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 589, in get
value = callable_(state, passive)
File "/home/asarch/tg2dev/lib/python2.7/site-packages/sqlalchemy/orm/state.py", line 433, in __call__
self.manager.deferred_scalar_loader(self, toload)
File "/home/asarch/tg2dev/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 567, in load_scalar_attributes
(state_str(state)))
DetachedInstanceError: Instance <User at 0xb643e0ac> is not bound to a Session; attribute refresh operation cannot proceed

And if you set:

keep_session=True

to

ZopeTransactionExtension()

you get:

Error 404

We're sorry but we weren't able to process this request.