Re: [web2py] More DB issues

2012-05-28 Thread Johann Spies
On 25 May 2012 20:08, Bruce Wade wrote: > HINT: See server log for query details. CONTEXT: SQL statement "SELECT 1 > FROM ONLY "public"."ads" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR SHARE > OF x" Any suggestions? > Did you check the server log? Regards Johann -- Because experiencing your

[web2py] More DB issues

2012-05-25 Thread Bruce Wade
deadlock detected DETAIL: Process 20969 waits for ShareLock on tuple (10,126) of relation 16935 of database 16386; blocked by process 20615. Process 20615 waits for ShareLock on transaction 19960600; blocked by process 20124. Process 20124 waits for ExclusiveLock on tuple (10,126) of relation 1693