Hey Richard, Thanks! I did actually have that commit.
I know its hard to say.. Thanks Massimo, I will try psycopg2 and let you all know if it continues. -Mark On Tue, Mar 3, 2015 at 11:02 AM, Massimo Di Pierro < [email protected]> wrote: > Can you try psycopg2 instead of pg8000. > > > On Tuesday, 3 March 2015 09:21:46 UTC-6, Mark Graves wrote: >> >> I've been encountering some strange issues that I have never seen before. >> >> I'm running some a complete regression suite on an application. It's >> pretty long running, in the current iteration. (over 400 seconds). >> >> This includes a number of browser automation tasks using python and >> selenium. >> >> For anyone familiar with py.test, >> >> I'm using a fixture to grab access to the database to make sure the logic >> is working properly. >> >> Namely: >> >> from gluon.shell import env >> >> from gluon.storage import Storage >> >> @pytest.fixture() >> >> def db(): >> >> web2py_env = env(appname, import_models=True) >> >> web2py_env = Storage(web2py_env) >> >> db = web2py_env.db >> >> return db >> When I use a sqlite database, I'm encountering lock issues, on a query >> where there really shouldn't be lock issues. >> >> It's a simple delete query, run before a test to ensure the appropriate >> table is empty. >> >> psuedocode: >> >> db(db.table.id>0).delete() >> driver.get(url) >> >> When running this separately as a test, or within a group of tests, it >> works fine, no lock issues. >> >> When running this in the full regression, I'm getting database lock >> issues. >> >> Then I switched to postgres for testing (I know -- cheap and dirty, but I >> wanted to see if that was really the issue). >> >> So, then I started getting even stranger errors from gluon.contrib.pg8000 >> >> namely: >> >> NoData Object >> Msg Query Idle Object >> >> etc. etc. >> >> In the course of testing, I've seen basically every one of the possible >> pg8000 errors in the source. >> >> Anyone have any clues as to where I might be able to track down the >> source? >> >> Is it a thread issue, where I should have done from gluon import current >> and then set the db in the function? >> >> I'm wondering if this is something to do with pytest's internals or >> web2py's or my own code. >> >> Any thoughts would be greatly appreciated. >> >> >> -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/web2py/WFAB-yKIygg/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
