[Pgpool-hackers] pgpool-II crash report

[Devrim GUNDUZ]

Hello,

I'm currently testing pgpool-II . The next step will be pgpool-II +
Slony-I. I want to report a crash that I can duplicate every time.

Below is the debug log. The crash happens when I want to load a schema
to a new created database. 

Any hints?

Regards, Devrim

2006-10-05 14:02:12 DEBUG: pid 6280: SimpleQuery: set master_slave_dml
query: CREATE TABLE event_operations (
    id serial NOT NULL,
    name character varying(50)
);
2006-10-05 14:02:12 DEBUG: pid 6280: waiting for backend 0 completing
the query
2006-10-05 14:02:12 DEBUG: pid 6280: waiting for backend 1 completing
the query
2006-10-05 14:02:12 DEBUG: pid 6280: pool_process_query: num_fds: 14
2006-10-05 14:02:12 DEBUG: pid 6280: read_kind_from_backend: read kind
from 0 th backend E NUM_BACKENDS: 2
2006-10-05 14:02:12 DEBUG: pid 6280: read_kind_from_backend: read kind
from 1 th backend E NUM_BACKENDS: 2
2006-10-05 14:02:12 DEBUG: pid 6280: pool_process_query: kind from
backend: E
2006-10-05 14:02:12 DEBUG: pid 6280: pool_process_query: num_fds: 14
2006-10-05 14:02:12 DEBUG: pid 6280: read_kind_from_backend: read kind
from 0 th backend Z NUM_BACKENDS: 2
2006-10-05 14:02:12 DEBUG: pid 6280: read_kind_from_backend: read kind
from 1 th backend Z NUM_BACKENDS: 2
2006-10-05 14:02:12 DEBUG: pid 6280: pool_process_query: kind from
backend: Z
2006-10-05 14:02:12 DEBUG: pid 6280: pool_read_message_length: slot: 0
length: 5
2006-10-05 14:02:12 DEBUG: pid 6280: pool_read_message_length: slot: 1
length: 5
2006-10-05 14:02:12 DEBUG: pid 6280: ReadyForQuery: message length: 5
2006-10-05 14:02:12 DEBUG: pid 6280: ReadyForQuery: transaction state: I
2006-10-05 14:02:12 DEBUG: pid 6280: pool_process_query: num_fds: 14
2006-10-05 14:02:12 DEBUG: pid 6280: read kind from frontend Q(51)
2006-10-05 14:02:12 DEBUG: pid 6280: statement2: ALTER TABLE
public.event_operations OWNER TO devrim;
2006-10-05 14:02:12 DEBUG: pid 6280: pool_rewrite_stmt: XXX rule 705
2006-10-05 14:02:12 DEBUG: pid 6280: SimpleQuery: set master_slave_dml
query: ALTER TABLE public.event_operations OWNER TO devrim;
2006-10-05 14:02:12 DEBUG: pid 6280: waiting for backend 0 completing
the query
2006-10-05 14:02:12 DEBUG: pid 6280: waiting for backend 1 completing
the query
2006-10-05 14:02:12 DEBUG: pid 6280: pool_process_query: num_fds: 14
2006-10-05 14:02:12 DEBUG: pid 6280: read_kind_from_backend: read kind
from 0 th backend E NUM_BACKENDS: 2
2006-10-05 14:02:12 DEBUG: pid 6280: read_kind_from_backend: read kind
from 1 th backend E NUM_BACKENDS: 2
2006-10-05 14:02:12 DEBUG: pid 6280: pool_process_query: kind from
backend: E
2006-10-05 14:02:12 DEBUG: pid 6280: pool_process_query: num_fds: 14
2006-10-05 14:02:12 DEBUG: pid 6280: read_kind_from_backend: read kind
from 0 th backend Z NUM_BACKENDS: 2
2006-10-05 14:02:12 DEBUG: pid 6280: read_kind_from_backend: read kind
from 1 th backend Z NUM_BACKENDS: 2
2006-10-05 14:02:12 DEBUG: pid 6280: pool_process_query: kind from
backend: Z
2006-10-05 14:02:12 DEBUG: pid 6280: pool_read_message_length: slot: 0
length: 5
2006-10-05 14:02:12 DEBUG: pid 6280: pool_read_message_length: slot: 1
length: 5
2006-10-05 14:02:12 DEBUG: pid 6280: ReadyForQuery: message length: 5
2006-10-05 14:02:12 DEBUG: pid 6280: ReadyForQuery: transaction state: I
2006-10-05 14:02:12 DEBUG: pid 6280: pool_process_query: num_fds: 14
2006-10-05 14:02:12 DEBUG: pid 6280: read kind from frontend Q(51)
2006-10-05 14:02:12 DEBUG: pid 6280: statement2: SELECT
pg_catalog.setval(pg_catalog.pg_get_serial_sequence('event_operations',
'id'), 1, false);
2006-10-05 14:02:12 DEBUG: pid 6280: pool_query_cache_lookup: searching
cache for query: " SELECT
"pg_catalog"."setval"("pg_catalog"."pg_get_serial_sequence"('event_operations','id'),1,'f')"
2006-10-05 14:02:12 DEBUG: pid 6280: pool_query_cache_lookup: executing
query: "SELECT value FROM pgpool_catalog.query_cache WHERE hash =
'70dd02991a5c2581de624517e51bbc6d' AND dbname = 'pgpooltest'"
2006-10-05 14:02:12 DEBUG: pid 6280: pool_query_cache_lookup: received T
from systemdb
2006-10-05 14:02:12 DEBUG: pid 6280: pool_query_cache_lookup: received C
from systemdb
2006-10-05 14:02:12 DEBUG: pid 6280: pool_query_cache_lookup: received Z
from systemdb
2006-10-05 14:02:12 DEBUG: pid 6280: pool_query_cache_lookup: query
cache not found
2006-10-05 14:02:12 DEBUG: pid 6280: OneNode_do_command: Query:  SELECT
pg_catalog.setval(pg_catalog.pg_get_serial_sequence('event_operations','id'),1,'f')
2006-10-05 14:02:12 DEBUG: pid 6280: pool_query_cache: prepared
statements created
2006-10-05 14:02:12 DEBUG: pid 6280: pool_query_cache_register: saving
cache for query: " SELECT
"pg_catalog"."setval"("pg_catalog"."pg_get_serial_sequence"('event_operations','id'),1,'f')"
2006-10-05 14:02:12 DEBUG: pid 6280: pool_query_cache_register: received
'E': free query cache buffer
2006-10-05 14:02:12 DEBUG: pid 4770: reap_handler called
2006-10-05 14:02:12 DEBUG: pid 4770: reap_handler: call wait3
2006-10-05 14:02:12 DEBUG: pid 4770: child 6280 exits with status 11 by
signal 11
2006-10-05 14:02:12 DEBUG: pid 4770: fork a new child pid 17820
2006-10-05 14:02:12 DEBUG: pid 4770: reap_handler: normally exited
2006-10-05 14:02:12 DEBUG: pid 17820: I am 17820
2006-10-05 14:02:12 DEBUG: pid 17820: s_do_auth: auth kind: 0
2006-10-05 14:02:12 DEBUG: pid 17820: s_do_auth: parameter status data
received

-- 
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://pgfoundry.org/pipermail/pgpool-hackers/attachments/20061005/84d38043/attachment.bin