Re: Apache with PHP and PGSQL crashing ...

Thomas Seifert <TS77(at)gmx(dot)de> writes:
> #0 0x400252ef in resetPQExpBuffer () from /usr/local/pgsql/lib/libpq.so.2
> #1 0x4002537d in printfPQExpBuffer () from /usr/local/pgsql/lib/libpq.so.2
> #2 0x400213e7 in PQgetResult () from /usr/local/pgsql/lib/libpq.so.2
> #3 0x40021467 in PQexec () from /usr/local/pgsql/lib/libpq.so.2
> #4 0x80eafa3 in _rollback_transactions (rsrc=0x8378268) at pgsql.c:168
> #5 0x8146ee4 in zend_hash_apply (ht=0x82c0ad4,
> apply_func=0x80eaf80 <_rollback_transactions>) at zend_hash.c:692
> #6 0x80eb140 in php_rshutdown_pgsql (type=1, module_number=20) at pgsql.c:246

Hm. As best I can tell, the only way that that path of control could
occur is if conn->asyncStatus contains an invalid value. Since
resetPQExpBuffer is also seemingly dying because of an invalid value
in the PGconn record, my bet is that _rollback_transactions is passing
an invalid PGconn (perhaps one that's already been freed?) to PQexec.

At this point I think you need an Apache/PHP/Zend expert, not a Postgres
expert ...

regards, tom lane