Thanks - and sorry for all this brain dump - I figure it could be
useful to others!
It looks like I was correct before - I have a bug where for static
content (the images I mentioned earlier) I do not create a
transaction- however the authentication needed one really.
Thanks,
Andrew
On Mar 15,
it sounds like you are coming up against basic transaction isolation
behavior. some background is available at
http://dev.mysql.com/doc/refman/5.1/en/innodb-transaction-model.html .
if you wanted to turn it off, you could use MyISAM tables or use your
session with autocommit=True.
Andrew wr
Ok... looks like I was hasty. The problem still seems fixed so far -
but my reasoning seems wrong.
It looks like the authentication request is contained within the
transaction - so I don't see why doing a select on a table within the
authentication function would cause problems. However adding a
se
I may have found the problem.
It turns out this problem only occurs if I use the cherrypy auth_basic
to provide authentication.
In my authentication checkpassword function I was querying the user
table without using sessions.
Adding a session rollback, clear and close to the end of this functi