[Pgpool-general] kind does not match between backends

[Tatsuo Ishii]

> Hi,
> 
> I'm trying to deploy pgpool 2.5.2 with the following settings:
> 
> backend_host_name = ''
> backend_port = 5432
> secondary_backend_host_name = 'anotherhost'
> secondary_backend_port = 5432
> load_balance_mode = true
> master_slave_mode = true
> 
> Localhost is PG 7.3.9, remote is 7.3.8. When I try to connect to pgpool with 
> psql everything works OK. However the application (PG Samba backend) issues a 
> PQsetdbLogin(). The logs read:
> 
> DEBUG: pid 62439: I am 62439 accept fd 6
> DEBUG: pid 62439: Protocol Major: 1234 Minor: 5679 database:  user:
> DEBUG: pid 62439: SSLRequest: sent N; retry startup
> DEBUG: pid 62439: Protocol Major: 2 Minor: 0 database: MYDB user: MYUSER
> DEBUG: pid 62439: connecting postmaster Unix domain socket: /tmp/.s.PGSQL.5432
> DEBUG: pid 62439: connected to postmaster Unix domain socket: /tmp/.s.PGSQL.5432 fd: 7
> ERROR: pid 62439: read_message_kind: kind does not match between backends master(75) secondary(88)
> 
> The numbers between parenthesis vary.

It seems the authentication settings for the master and secondary are
different, but this is just a guess. I have add some debug statement
to see if this actually happens. Can you grab the latest source using
anon CVS? If you have problem with CVS, I could send you the file via
private mail. Please let me know.

> Note the extrange protocol number in the 
> second line, as well as the empty database and user.

This is normal. The reason why they are empty is that the start up
packet is for SSL negotiation. BTW, do you see same packet(empty
database and user name)  if you connect with psql?
--
Tatsuo Ishii