Re: BUG #3031: PHP (and others?) cannot close a connection when "in" a COPY-statement

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Arjen van der Meijden" <acmmailing(at)tweakers(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3031: PHP (and others?) cannot close a connection when "in" a COPY-statement
Date: 2007-02-20 03:42:38
Message-ID: 19233.1171942958@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Arjen van der Meijden" <acmmailing(at)tweakers(dot)net> writes:
> I'm not sure whether this is a php-issue or a postgresql-client-api one, but
> when connecting gdb to that process and doing a 'bt' it displays:
> #0 0xa7c36d9f in free () from /lib/tls/libc.so.6
> #1 0xa7c38c4f in malloc () from /lib/tls/libc.so.6
> #2 0xa7f58bdb in PQmakeEmptyPGresult () from /usr/lib/libpq.so.5
> #3 0xa7f59941 in PQgetResult () from /usr/lib/libpq.so.5
> #4 0x08086fd0 in _close_pgsql_link (rsrc=0x81e42bc) at
> /usr/src/php-4.4.2/ext/pgsql/pgsql.c:276

Given that stack trace, you'd better complain to the PHP folk. There is
no loop in that path in libpq, so the looping must be occurring
somewhere in the PHP code.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2007-02-20 03:46:35 Re: [BUGS] BUG #2913: Subscript on multidimensional array yields no value
Previous Message Bruce Momjian 2007-02-19 22:50:36 Re: "Julian day" date format is off by 12 hours