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 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
