Hello!

After sending the last mail
(Message-ID: <[EMAIL PROTECTED]>)

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

Attachment: signature.asc
Description: Digital signature

_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general

Reply via email to