DetachedInstanceError

[nl5887]

If you're getting DetachedInstanceErrors with database models, then you should disable 'expire_on_commit':

DBSession = scoped_session(sessionmaker(extension=ZopeTransactionExtension(), expire_on_commit=False))

[domenkozar]

Not sure I understand how is that connected to pyramid_marrowmailer, it has nothing to do with sqlalchemy dbsessions?

[nl5887]

Actually it is ;-) when it attaches to the transactions including db
transactions.

We are using it to mail rendered templates with data from database. That is
causing issues because db is flushed after commit.
On Sep 3, 2013 4:27 PM, "Domen Kožar" notifications@github.com wrote:

Not sure I understand how is that connected to pyramid_marrowmailer, it
has nothing to do with sqlalchemy dbsessions?

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/1#issuecomment-23716248
.

[domenkozar]

Maybe transaction has some way to support order of transaction managers and sqlalchemy needs to wrap pyramid_marrrowmailer transactions.

[domenkozar]

Did you manage to solve this issue?

[nl5887]

Yes, the issue was solved by changing the expire_on_commit setting. This is actually more a documentation thing, then something we should solve in code.