[Pgpool-general] Problem with pgpool2 3.0.4 segfaulting

John Workman johnw at voyageurweb.com
Tue Aug 9 16:53:11 UTC 2011


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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool2-pid21438.log.gz
Type: application/x-gzip
Size: 6578 bytes
Desc: not available
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110809/53c67534/attachment.bin>


More information about the Pgpool-general mailing list