[sqlalchemy] Re: Strange caching problem with Apache - Lukasz Szybalski - com.googlegroups.sqlalchemy

8 messages in com.googlegroups.sqlalchemy[sqlalchemy] Re: Strange caching prob...

From	Sent On	Attachments
john spurling	28 Mar 2008 15:41
Michael Bayer	28 Mar 2008 16:12
john spurling	28 Mar 2008 16:55
Michael Bayer	28 Mar 2008 17:02
Graham Dumpleton	28 Mar 2008 20:54
Michael Bayer	28 Mar 2008 21:19
Lukasz Szybalski	29 Mar 2008 08:11
john spurling	31 Mar 2008 15:08

Subject:	[sqlalchemy] Re: Strange caching problem with Apache
From:	Lukasz Szybalski (szyb...@gmail.com)
Date:	03/29/2008 08:11:15 AM
List:	com.googlegroups.sqlalchemy

On Fri, Mar 28, 2008 at 10:54 PM, Graham Dumpleton <Grah...@gmail.com> wrote:

On Mar 29, 11:02 am, Michael Bayer <mike...@zzzcomputing.com> wrote:

On Mar 28, 2008, at 7:56 PM, john spurling wrote:

I added debugging to get id(session) and len(list(session)). The session id is unique every time, and len(list(session)) is 0. I also called session.clear() before using it. Unfortunately, the caching behavior persists.

Any other suggestions? Thank you very much for your time and help!

if its zero, then the Session isnt caching. Something is going on HTTP/process-wise.

Could it be that because Apache is a multi process web server (on UNIX), that OP is getting confused through subsequent requests actually hitting a different process.

That said, sqlalchemy as I understood it was meant to deal with that, ie., change made from one process should be reflected in another process straight away upon a new query, ie., cached data should be replaced. Is it possible that what ever insures that has been disabled.

OP should perhaps print out os.getpid() so they know which process is handling the request each time. This may help to explain what is going on.

Graham

What are you using to handle http requests? turbogears? psp?

Would converting from mod_python to mod_Wsgi help in this situation?

Lucas