Lighthouse has a new layout. Prefer the old one? Return to the old layout, and switch back any time from the link at the top of each page.

Daniele Varrazzo's latest activity

Thursday, July 24 2014
223 Process Hangs was updated in psycopg
  • Daniele Varrazzo
    Daniele Varrazzo commented at 10:41 AM

    You can attach gcc to the stuck process, or kill it generating a core.

    You can also try to make the process responsive again (killable at python level) switchin...

Tuesday, July 22 2014
223 Process Hangs was updated in psycopg
  • Daniele Varrazzo
    Daniele Varrazzo commented at 9:47 AM

    With AWS or with regular Postgres?

    You may be bumping in some quirkiness of AWS pooling or throttling that the libpq is not prepared to handle. Getting a C stac...

Sunday, July 20 2014
223 Process Hangs was updated in psycopg
  • Daniele Varrazzo
    Daniele Varrazzo commented at 10:31 PM

    Ticket #112 you reference is about queries, not about connections.

    The driver is not referencing a deallocated object: it destroyed one and allocated a new one ...

  • Daniele Varrazzo
    • State changed from new to invalid
    by Daniele Varrazzo at 10:21 AM

    For what I can see here it's the server not completing the connection. I tend to blame the AWS servers, not the client side.

    If you want to perform operation "s...

221 Unable to cancel query 2.4.5-1 (debian stable) was updated in psycopg
  • Daniele Varrazzo
    • State changed from new to invalid
    by Daniele Varrazzo at 10:38 AM

    A way to make the query interruptable is to work in green mode with a wait callback that can tolerate being broken by ctrl-c:

    from select import select
    from ps...
  • Daniele Varrazzo
    Daniele Varrazzo edited a comment at 10:56 AM

    A way to make the query interruptable is to work in green mode with a wait callback that can tolerate being broken by ctrl-c:

    from select import select
    from ps...
224 Installing pscopg2 is failing was updated in psycopg
  • Daniele Varrazzo
    • State changed from new to invalid
    by Daniele Varrazzo at 10:10 AM

    Please install python-dev package (and libpq-dev too).

Friday, July 11 2014
222 Integer range upper bound coerced to exclusive was updated in psycopg
  • Daniele Varrazzo
    • State changed from new to invalid
    by Daniele Varrazzo at 9:45 AM

    You are observing PostgreSQL's behaviours, not psycopg.

    piro=> select '[1,10]'::int4range;
     int4range 
    -----------
     [1,11)
    (1 row)
    

    Check the docs about the c...

Monday, June 30 2014
221 Unable to cancel query 2.4.5-1 (debian stable) was updated in psycopg
  • Daniele Varrazzo
    Daniele Varrazzo commented at 9:28 PM

    Hello,

    yes, I know the issue. No, it's not fixed in the master and I don't know how to fix it; actually I don't think it's generally fixable in psycopg: you may...

Friday, June 06 2014
219 Segmentation fault when reading "copy from" in a file was updated in psycopg
  • Daniele Varrazzo
    • State changed from open to resolved
    by Daniele Varrazzo at 7:46 PM

    Fixed: the segfault was caused by a missing check in a path normally not used, triggered executing a COPY statement via execute().