[Pgpool-general] segfault in pgpool 2.2

Simone Tregnago simonetregnago at grivaonline.com
Mon Apr 6 15:23:50 UTC 2009


Hi all,
I've started some tests in order to try the switch from
pgpool 2.1 to 2.2.
Unfortunately, when the client executes an update, pgpool crashes with
a segfault.
Here are the last lines until the fault:

Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
statement2: PREPARE "ARCO1"
(int4,int4,int4,int4,text,int4,text,text,text,text,int4) AS UPDATE
ZSTATUS SET "IDSTATUS"=$1, "CODPROCESS"=$2, "IDUTENTE"=$3,
"LASTEVENTD"=$4, "YEAR"=$5, "ID_UTENTE"=$6, "COD_FRAME"=$7, "INDICE"=$8,
"COD_WINDOW"=$9, "WIN_TITLE"=$10, "IDRECORD"=$11 WHERE "IDSTATUS" = 26315
Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
do_command: Query: BEGIN
Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
detect_error: kind: C
Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
do_command: kind: C
Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
do_command: kind: Z
Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
do_command: transaction state: T
Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
waiting for backend 0 completing the query
Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
detect_error: kind: C
Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
detect_error: kind: C
Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
detect_error: kind: C
Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
read_kind_from_backend: read kind from 0 th backend C NUM_BACKENDS: 1
Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
pool_process_query: kind from backend: C
Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 1
Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
pool_process_query: kind from backend: Z
Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
pool_read_message_length: slot: 0 length: 5
Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
ReadyForQuery: message length: 5
Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
ReadyForQuery: transaction state: T
Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
do_command: Query: COMMIT
Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
detect_error: kind: C
Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
do_command: kind: C
Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
do_command: kind: Z
Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
pool_read_message_length: slot: 0 length: 5
Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
ReadyForQuery: message length: 5
Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
ReadyForQuery: transaction state: I
Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
read kind from frontend B(42)
Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
bind message: portal_name  stmt_name ARCO1
Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
read_kind_from_backend: read kind from 0 th backend 2 NUM_BACKENDS: 1
Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
read kind from frontend D(44)
Apr  6 15:39:16 pgcluster1 pgpool: 2009-04-06 15:39:16 DEBUG: pid 7710:
read_kind_from_backend: read kind from 0 th backend n NUM_BACKENDS: 1
Apr  6 15:39:16 pgcluster1 kernel: [473832.539728] pgpool[7710]:
segfault at 0 ip 40f4b0 sp 7fff1e09b010 error 4 in pgpool[400000+b0000]

Using the same config file with 2.1 works without crashes.
If needed I could send more lines, or config details.
Thanks
-- 
Simone Tregnago



More information about the Pgpool-general mailing list