On Feb 14, 2011, at 10:24 AM, Luis Díaz wrote: > ready to investigate: > > psycopg2 > > http://wiki.postgresql.org/wiki/Using_psycopg2_with_PostgreSQL > > The error could be caused by a bad query > developed? > > Could provide an app that generates the error?
I'm not using it myself; I'm not sure what triggers the error. I assume that there's more information earlier in this thread. > > Díaz Luis > TSU Analisis de Sistemas > Universidad de Carabobo > > Facultad de Odontología > > > > > > 2011/2/14 Luis Díaz <diazluis2...@gmail.com> > > I have installed: > python-psycopg2/lenny update 2.0.7-4 > > Question: > What is the funsion of psycopg2? > > Díaz Luis > TSU Analisis de Sistemas > Universidad de Carabobo > > Facultad de Odontología > > > > > > 2011/2/14 Jonathan Lundell <jlund...@pobox.com> > > On Feb 14, 2011, at 9:48 AM, Luis Díaz wrote: >> >> Greetings. >> >> I have tried to replicate the error and have had no >> exicto. > > Thanks. What version of psycopg2 are you using? > >> >> Environment: >> virtual server 1: debian ssl web2py >> virtual server 2: debian ssl postgresql >> >> Application: >> simple queries and throwing 2 >> results. >> >> tool: >> Jmeter: >> Threads 1200 >> 0.2 seconds upload >> >> Díaz Luis >> TSU Analisis de Sistemas >> Universidad de Carabobo >> >> Facultad de Odontología >> >> >> >> >> >> 2011/2/12 Luis Díaz <diazluis2...@gmail.com> >> Translation error .. sorry. >> >> I could not .. >> might wonder if any of you? >> >> Díaz Luis >> TSU Analisis de Sistemas >> Universidad de Carabobo >> >> Facultad de Odontología >> >> >> >> >> >> 2011/2/12 Jonathan Lundell <jlund...@pobox.com> >> On Feb 12, 2011, at 8:46 AM, ron_m wrote: >> >> > FWIW I am on Ubuntu 10.04 with all patches applied and could not reproduce >> > the above problem when I tried. The version of python-psycopg2 from the >> > standard repository is 2.0.13. Not an iron-clad guarantee because >> > something else could be at play but at least a data point. I also drove >> > the application a lot harder from ab with 10x number of requests to try >> > and reproduce but still nothing. >> > >> > The fact it doesn't fail when processes=5 and threads=1 agrees well with >> > the GIL problem - without threads there is no need to hold the GIL. >> >> Yes, it's a useful data point. >> >> The best test will be to have an environment that actually fails with >> psycopg2 2.0.7, and have the failure disappear with an updated version (and >> no other changes), and to get the error back again with 2.0.7. >> >> > > > >