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