[Pgpool-general] pgpool2.1b2 segfaulting

Thu May 15 15:52:14 UTC 2008

Hello!

After sending the last mail
(Message-ID: <20080515153241.GC1434 at denkbrett.schottelius.org>)

I get segfaults when trying to connect with our jdbc application:

pgpool[14512]: segfault at 0000000000000010 rip 000000000041780c rsp 00007fff3dace960 error 4
pgpool[13608]: segfault at 0000000000000010 rip 000000000041780c rsp 00007fff3dace960 error 4
pgpool[14625]: segfault at 0000000000000010 rip 000000000041780c rsp 00007fff3dace960 error 4

pgpool is started with ./pgpool -n -d

[17:47] u0238:bin# ./pgpool -v
pgpool-II version 2.1-beta2 (inamiboshi)

It continues to work, but I guess the child which is connected to the
jdbc application dies.

The other connections from apache2/php5 are still running.

Debug:

--------------------------------------------------------------------------------
2008-05-15 17:48:46 DEBUG: pid 15162: I am 15162 accept fd 0
2008-05-15 17:48:46 LOG:   pid 15162: connection received: host=62.65.136.66 port=48571
2008-05-15 17:48:46 DEBUG: pid 15162: Protocol Major: 2 Minor: 0 database: nello user: postgres
2008-05-15 17:48:46 DEBUG: pid 15162: no empty connection slot was found
2008-05-15 17:48:46 DEBUG: pid 15162: user: smt_web database: smt closetime: 1210866521
2008-05-15 17:48:46 DEBUG: pid 15162: discarding old 0 th connection. user: smt_web database: smt
2008-05-15 17:48:46 DEBUG: pid 15162: new_connection: connecting 0 backend
2008-05-15 17:48:46 DEBUG: pid 15162: new_connection: connecting 1 backend
2008-05-15 17:48:46 DEBUG: pid 15162: new_connection: skipping slot 1 because backend_status = 3
2008-05-15 17:48:46 DEBUG: pid 15162: pool_send_auth_ok: send pid 15419 to frontend
2008-05-15 17:48:46 DEBUG: pid 15162: select_load_balancing_node: selected backend id is 0
2008-05-15 17:48:46 DEBUG: pid 15162: read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 2
2008-05-15 17:48:46 DEBUG: pid 15162: pool_process_query: kind from backend: Z
2008-05-15 17:48:46 DEBUG: pid 15162: read kind from frontend Q(51)
2008-05-15 17:48:46 DEBUG: pid 15162: pool_read_string: read all from pending data. po:0 len:0
2008-05-15 17:48:46 LOG:   pid 15162: statement: set datestyle = 'ISO'; select version(), case when pg_encoding_to_
char(1) = 'SQL_ASCII' then 'UNKNOWN' else getdatabaseencoding() end
2008-05-15 17:48:46 DEBUG: pid 15162: waiting for backend 0 completing the query
2008-05-15 17:48:46 DEBUG: pid 15162: read_kind_from_backend: read kind from 0 th backend C NUM_BACKENDS: 2
2008-05-15 17:48:46 DEBUG: pid 15162: pool_process_query: kind from backend: C
2008-05-15 17:48:46 DEBUG: pid 15162: pool_read_string: read all from pending data. po:5 len:169
2008-05-15 17:48:46 DEBUG: pid 15162: Complete Command Response: string: "SET"
2008-05-15 17:48:46 DEBUG: pid 15162: read_kind_from_backend: read kind from 0 th backend P NUM_BACKENDS: 2
2008-05-15 17:48:46 DEBUG: pid 15162: pool_process_query: kind from backend: P
2008-05-15 17:48:46 DEBUG: pid 15162: pool_read_string: read all from pending data. po:12 len:162
2008-05-15 17:48:46 DEBUG: pid 15162: read_kind_from_backend: read kind from 0 th backend T NUM_BACKENDS: 2
2008-05-15 17:48:46 DEBUG: pid 15162: pool_process_query: kind from backend: T
2008-05-15 17:48:46 DEBUG: pid 15162: pool_read_string: read all from pending data. po:23 len:151
2008-05-15 17:48:46 DEBUG: pid 15162: RowDescription: type oid: 25
2008-05-15 17:48:46 DEBUG: pid 15162: RowDescription: field size: 65535
2008-05-15 17:48:46 DEBUG: pid 15162: RowDescription: modifier: 65535
2008-05-15 17:48:46 DEBUG: pid 15162: pool_read_string: read all from pending data. po:53 len:121
2008-05-15 17:48:46 DEBUG: pid 15162: RowDescription: type oid: 19
2008-05-15 17:48:46 DEBUG: pid 15162: RowDescription: field size: 64
2008-05-15 17:48:46 DEBUG: pid 15162: RowDescription: modifier: 65535
2008-05-15 17:48:46 DEBUG: pid 15162: read_kind_from_backend: read kind from 0 th backend D NUM_BACKENDS: 2
2008-05-15 17:48:46 DEBUG: pid 15162: pool_process_query: kind from backend: D
2008-05-15 17:48:46 DEBUG: pid 15162: AsciiRow: len: 88 data: PostgreSQL 8.3.1 on x86_64-pc-linux-gnu, compiled by GCC cc (GCC) 4.2.3 (Debian 4.2.3-2)
2008-05-15 17:48:46 DEBUG: pid 15162: AsciiRow: 0 th field size does not match between master(1476395008) and 1 th backend(92)
2008-05-15 17:48:46 DEBUG: pid 15074: reap_handler called
2008-05-15 17:48:46 DEBUG: pid 15074: reap_handler: call wait3
2008-05-15 17:48:46 DEBUG: pid 15074: child 15162 exits with status 11 by signal 11
--------------------------------------------------------------------------------

Any hotfix available?

Sincerly,

Nico

-- 
Think about Free and Open Source Software (FOSS).
http://nico.schottelius.org/documentations/foss/the-term-foss/

PGP: BFE4 C736 ABE5 406F 8F42  F7CF B8BE F92A 9885 188C
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://pgfoundry.org/pipermail/pgpool-general/attachments/20080515/379bc86c/attachment.bin 