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 Phillips wrote:
>
> On the eve of delivering a project to a client, I've come up against a 
> problem that has me stumped. select() statements on one of my mysql tables 
> have stopped working.
>
> My application is a web2py web server and a background process (also 
> called a homemade task queue in the web2py book). They share the database. 
> The web server writes to the table from within an HTTP request, and several 
> seconds later, I attempt to read the record in my background process.
>
> Up until yesterday, I didn't have any trouble reading from this or any of 
> the tables. And now, all the others work fine. I can still write and read 
> from the misbehaving table from the web server. 
>
> I am at a loss. I'm not sure where to look to diagnose the problem. Any 
> pointers would be gratefully received.
>

-- 



Reply via email to