[Pgpool-general] Problem with pgpool2 3.0.4 segfaulting

Toshihiro Kitagawa kitagawa at sraoss.co.jp
Mon Aug 22 03:21:49 UTC 2011 

Sorry for delay,

I am investigating this segfaults, but a cause is still unclear.
Could you give following information?

 - backtrace when pgpool2 segfaults
 - driver name and version which your application uses
 - what is '#011' in statement log if you know?
   > Aug  9 10:35:59 SCHOLARS-Web2 pgpool: #011#011SELECT DISTINCT u.pageid

Regards,

-- 
Toshihiro Kitagawa
SRA OSS, Inc. Japan

On Tue, 09 Aug 2011 11:53:11 -0500
John Workman <johnw at voyageurweb.com> wrote:

> Greetings,
> 
> Attempting to use pgpool2 in a production environment.
> 
> Unfortunately we have run into an issue where pgpool2 segfaults.
> 
> I've attached the debug output from syslog of this happening one time.
> 
> System is Linux (Debian 5.0) 32bit userland with x86_64 Kernel (Ubuntu's 
> "2.6.32-30.59-server" kernel)
> 
> This is from a production system. I can probably clone this to a quiet 
> VM and reproduce the segfault under gdb or other tools if that's helpful.
> 
> Here's an excerpt:
> 
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: Execute: portal 
> name <>
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: Execute: query:
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: #011#011SELECT DISTINCT u.pageid
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: #011#011FROM page p
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: #011#011INNER JOIN userdata u ON 
> p.pageid = u.pageid
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: #011#011WHERE p.appid = $1
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: #011#011AND p.series > $2
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: #011#011AND u.userid = $3
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: #011#011
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> wait_for_query_response: waiting for backend 0 completing the query
> Aug  9 10:35:59 SCHOLARS-Web2 kernel: [2372419.276881] pgpool[21438]: 
> segfault at 10 ip 00000000080a3ec9 sp 00000000ffc93e20 error 4 in 
> pgpool[8048000+c0000]
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: detect_error: 
> kind: C
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: detect_error: 
> kind: C
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: detect_error: 
> kind: C
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: detect_error: 
> kind: C
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> read_kind_from_backend: read kind from 0 th backend C NUM_BACKENDS: 1
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessBackendResponse: kind from backend: C
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_unset_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessFrontendResponse: kind from frontend S(53)
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_unset_doing_extended_query_message: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_doing_extended_query_message: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 1
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessBackendResponse: kind from backend: Z
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_read_message_length: slot: 0 length: 5
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_unset_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessFrontendResponse: kind from frontend P(50)
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_unset_doing_extended_query_message: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_doing_extended_query_message: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: Parse: statement 
> name <>
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_read_message_length: slot: 0 length: 5
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_unset_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: Parse: waiting 
> for master completing the query
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> wait_for_query_response: waiting for backend 0 completing the query
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: detect_error: 
> kind: 1
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> read_kind_from_backend: read kind from 0 th backend 1 NUM_BACKENDS: 1
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessBackendResponse: kind from backend: 1
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_add_sent_message: prepared statement "" already exists
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> can_query_context_destroy: query context is still used.
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_unset_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessFrontendResponse: kind from frontend B(42)
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_unset_doing_extended_query_message: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_doing_extended_query_message: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: Bind: waiting 
> for master completing the query
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> wait_for_query_response: waiting for backend 0 completing the query
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> read_kind_from_backend: read kind from 0 th backend 2 NUM_BACKENDS: 1
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessBackendResponse: kind from backend: 2
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_add_sent_message: portal "" already exists
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_unset_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_unset_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessFrontendResponse: kind from frontend D(44)
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_unset_doing_extended_query_message: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_doing_extended_query_message: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: Describe: 
> waiting for master completing the query
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> wait_for_query_response: waiting for backend 0 completing the query
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> read_kind_from_backend: read kind from 0 th backend T NUM_BACKENDS: 1
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessBackendResponse: kind from backend: T
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_unset_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessFrontendResponse: kind from frontend E(45)
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_unset_doing_extended_query_message: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_doing_extended_query_message: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: Execute: portal 
> name <>
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: Execute: query: 
> SELECT pageid, fieldid, value FROM userdata where appid = $1 AND userid = $2
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> wait_for_query_response: waiting for backend 0 completing the query
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: detect_error: 
> kind: D
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: detect_error: 
> kind: D
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: detect_error: 
> kind: D
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: detect_error: 
> kind: D
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> read_kind_from_backend: read kind from 0 th backend D NUM_BACKENDS: 1
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessBackendResponse: kind from backend: D
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> read_kind_from_backend: read kind from 0 th backend D NUM_BACKENDS: 1
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessBackendResponse: kind from backend: D
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> read_kind_from_backend: read kind from 0 th backend D NUM_BACKENDS: 1
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessBackendResponse: kind from backend: D
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> read_kind_from_backend: read kind from 0 th backend D NUM_BACKENDS: 1
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessBackendResponse: kind from backend: D
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> read_kind_from_backend: read kind from 0 th backend D NUM_BACKENDS: 1
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessBackendResponse: kind from backend: D
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> read_kind_from_backend: read kind from 0 th backend D NUM_BACKENDS: 1
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessBackendResponse: kind from backend: D
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> read_kind_from_backend: read kind from 0 th backend C NUM_BACKENDS: 1
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessBackendResponse: kind from backend: C
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_unset_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessFrontendResponse: kind from frontend S(53)
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_unset_doing_extended_query_message: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_doing_extended_query_message: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 1
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessBackendResponse: kind from backend: Z
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_read_message_length: slot: 0 length: 5
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_unset_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessFrontendResponse: kind from frontend P(50)
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_unset_doing_extended_query_message: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_doing_extended_query_message: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: Parse: statement 
> name <>
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_read_message_length: slot: 0 length: 5
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_unset_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: Parse: waiting 
> for master completing the query
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> wait_for_query_response: waiting for backend 0 completing the query
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: detect_error: 
> kind: 1
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> read_kind_from_backend: read kind from 0 th backend 1 NUM_BACKENDS: 1
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessBackendResponse: kind from backend: 1
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_add_sent_message: prepared statement "" already exists
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> can_query_context_destroy: query context is still used.
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_unset_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessFrontendResponse: kind from frontend B(42)
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_unset_doing_extended_query_message: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_doing_extended_query_message: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: Bind: waiting 
> for master completing the query
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> wait_for_query_response: waiting for backend 0 completing the query
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> read_kind_from_backend: read kind from 0 th backend 2 NUM_BACKENDS: 1
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessBackendResponse: kind from backend: 2
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_add_sent_message: portal "" already exists
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_unset_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_unset_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessFrontendResponse: kind from frontend D(44)
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_unset_doing_extended_query_message: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_doing_extended_query_message: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: Describe: 
> waiting for master completing the query
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> wait_for_query_response: waiting for backend 0 completing the query
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> read_kind_from_backend: read kind from 0 th backend T NUM_BACKENDS: 1
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessBackendResponse: kind from backend: T
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_unset_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessFrontendResponse: kind from frontend E(45)
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_unset_doing_extended_query_message: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_doing_extended_query_message: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: Execute: portal 
> name <>
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: Execute: query: 
> SELECT editable_content FROM content, section WHERE appid=$1 AND 
> content.sectionid = section.sectionid AND section.name=$2 LIMIT 1
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> wait_for_query_response: waiting for backend 0 completing the query
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: detect_error: 
> kind: D
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: detect_error: 
> kind: D
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: detect_error: 
> kind: D
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: detect_error: 
> kind: D
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> read_kind_from_backend: read kind from 0 th backend D NUM_BACKENDS: 1
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessBackendResponse: kind from backend: D
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> read_kind_from_backend: read kind from 0 th backend C NUM_BACKENDS: 1
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessBackendResponse: kind from backend: C
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_unset_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessFrontendResponse: kind from frontend S(53)
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_unset_doing_extended_query_message: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_doing_extended_query_message: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 1
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessBackendResponse: kind from backend: Z
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_read_message_length: slot: 0 length: 5
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_unset_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> ProcessFrontendResponse: kind from frontend P(50)
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_unset_doing_extended_query_message: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_doing_extended_query_message: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: Parse: statement 
> name <>
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 21438: 
> pool_set_query_in_progress: done
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: ERROR: pid 19857: Child process 
> 21438 was terminated by segmentation fault
> Aug  9 10:35:59 SCHOLARS-Web2 pgpool: DEBUG: pid 19857: child 21438 
> exits with status 11 by signal 11
> 
> # addr2line -e /usr/local/bin/pgpool 00000000080a3ec9
> /usr/local/src/pgpool-II-3.0.4/parser/pool_memory.c:93
> 
> 
> -- 
> John Workman
> VoyageurWeb Engineering
> P.O. Box 205 Mankato, MN 56002-0205
> (507) 344-2280
> http://www.voyageurweb.com
>

More information about the Pgpool-general mailing list