Re: [web2py] Re: MySQL DB reads have stopped working for one table in a background process

2012-07-24 Thread Massimo Di Pierro
First of all we need to establish there is a problem and this is not the expected behavior. I am not sure. MySQL has 4 different isolation modes and defaults to: http://dev.mysql.com/doc/refman/5.1/en/set-transaction.html#isolevel_repeatable-read "All consistent reads within the same transacti

Re: [web2py] Re: MySQL DB reads have stopped working for one table in a background process

2012-07-24 Thread David Phillips
Hello, Massimo. > What changed? Did you upgrade? What web2py version? I removed a task in the background process that was periodically calling db.commit. In its place, I started using memcache where I had been writing to the db. I haven't upgraded. I've been using 1.99.7 all along. > When y

[web2py] Re: MySQL DB reads have stopped working for one table in a background process

2012-07-24 Thread Massimo Di Pierro
What changed? Did you upgrade? What web2py version? When you say the select does not work anymore, dwhat do you mean? Does it lock or do you get a traceback? Which database driver? People have reported problems with pymysql but not with mysqldb. On Tuesday, 24 July 2012 19:42:29 UTC-5, David Ph