<snip />
Just out of curiosity. How did you handle commits in the Report thread?
the Report Thread was only a read-only thread it did not attempt to commit.
Was this problems always related to using ZSQLMethod or did the problem also appear when only the ZODB was used, or have you not tried pure ZODB?
did not try pure ZODB - but I have a feeling that would work. life is good as long as you dont try to WRITE in the thread because the transaction_manager blocks writes to the ZODB unless the thread is under its control.
so far it works beautifully! I plan to post on zopelabs the threading solution with a huge warning not to use it in conjunction with ZSQLMethods. but I think it should be (actively) discouraged spawning threads inside of ZEO.
Does these problems only appear in ZEO or would they appear in a single mounted database Zope as well?
I would imagine it would be problems in any Zope. I dont see how it would be specific to ClientStorage. ~runyaga