Re: Backend crash in 8.2.3 with plpgsql function

SM wrote:

> Program terminated with signal 11, Segmentation fault.
> Reading symbols from /usr/libexec/ld.so...done.
> Reading symbols from /usr/lib/libm.so.1.0...done.
> Reading symbols from /usr/lib/libc.so.29.0...done.
> Reading symbols from /usr/local/pgsql/lib/plpgsql.so...done.
> #0  0x234c2a in hash_search (hashp=0x0, keyPtr=0xcfbfcc50, action=HASH_FIND,
>     foundPtr=0x0) at dynahash.c:782
> 782             return hash_search_with_hash_value(hashp,
> (gdb) bt
> #0  0x234c2a in hash_search (hashp=0x0, keyPtr=0xcfbfcc50, action=HASH_FIND,
>     foundPtr=0x0) at dynahash.c:782
> #1  0x4038ac25 in plpgsql_HashTableLookup (func_key=0xcfbfcc50)
>     at pl_comp.c:2092

Note that "hashp" (which is plpgsql_HashTable) is NULL here ... how can
that be?  The only way I see is that _PG_init was not called.  Maybe
there is a race condition?


--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support