[Pgpool-general] Fwd: Re: [HELP] Sometime it's running sometime not

[Hervé Piedvache]

Sorry other email from work ...

No there is none error in the error log of PostgreSQL no secondary node ...
If I configure pgpool to access only to the second node everything work perfectly !
If I do the same with only the first and may node (where pgpool run) it's running also perflectly ...
Those message arrives only if I set up the configuration with both of the node in pgpool ...

I have also tried the same thing only with my third node ... it's running also alone perfectly ...

If I do psql connection it loadbalance perfectly ... and I know throught Slony-I that I'm switching well from one node to the other ... something like this :
psql rss -p 9999
Timing is on.
Welcome to psql 8.2.5, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

rss=# select * from _cluster_ef.sl_local_node_id;
  sequence_name   | last_value | increment_by |      max_value      | min_value | cache_value | log_cnt | is_cycled | is_called
------------------+------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
 sl_local_node_id |          4 |            1 | 9223372036854775807 |        -1 |           1 |       0 | f         | t
(1 row)

psql rss -p 9999
Timing is on.
Welcome to psql 8.2.5, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

rss=# select * from _cluster_ef.sl_local_node_id;
  sequence_name   | last_value | increment_by |      max_value      | min_value | cache_value | log_cnt | is_cycled | is_called
------------------+------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
 sl_local_node_id |          2 |            1 | 9223372036854775807 |        -1 |           1 |       0 | f         | t


Ok I think I have found the origine of the problem ...
If I have a PDO request from my php code ... it seems to being prepared on the host0 and executed on the host1 !!!

Host0 :
Sep 26 11:20:00 s152 postgres[9484]: [1-1] <2007-09-26 11:20:00 CEST [unknown](9484): [unknown] ()> LOG:  connection received: host=192.168.0.151 port=40899
Sep 26 11:20:00 s152 postgres[9484]: [2-1] <2007-09-26 11:20:00 CEST postgres(9484): rss (192.168.0.151(40899))> LOG:  connection authorized: user=postgres database=rss
Sep 26 11:20:00 s152 postgres[9484]: [3-1] <2007-09-26 11:20:00 CEST postgres(9484): rss (192.168.0.151(40899))> LOG:  duration: 13.919 ms  parse pdo_pgsql_stmt_446c5e04:
Sep 26 11:20:00 s152 postgres[9484]: [3-2]  SELECT DISTINCT f.folder_id, f.last_update, fd.name, f.grade FROM folder f INNER JOIN folder_data fd USING(folder_id) INNER etc.

Host1:
Sep 26 11:20:00 localhost postgres[32663]: [3-1] <2007-09-26 11:20:00 CEST postgres(32663): rss (192.168.0.151(54152))> LOG:  duration: 34.449 ms  parse pdo_pgsql_stmt_446c5e04:
Sep 26 11:20:00 localhost postgres[32663]: [3-2]  SELECT DISTINCT f.folder_id, f.last_update, fd.name, f.grade FROM folder f INNER JOIN folder_data fd USING(folder_id) INNER etc.

This seems to be a bug in pgpool-II for me ...

Le mercredi 26 septembre 2007, vous avez écrit :
> ----------  Forwarded Message  ----------
>
> Subject: Re: [Pgpool-general] [HELP] Sometime it's running sometime not
> Date: mercredi 26 septembre 2007
> From: Yoshiyuki Asaba <y-asaba at sraoss.co.jp>
> To: bill.footcow at gmail.com
>
> Hi,
>
> From: Hervé_Piedvache <bill.footcow at gmail.com>
> Subject: [Pgpool-general] [HELP] Sometime it's running sometime not
> Date: Tue, 25 Sep 2007 22:58:54 +0200
>
> > 2007-09-25 22:53:57 DEBUG: pid 13321: read kind from frontend P(50)
> > 2007-09-25 22:53:57 ERROR: pid 13321: pool_read_kind: kind does not match
> > between master(49) slot[1] (69)
>
> It seems that secondary server returned an error. Can you check
> PostgreSQL's log on secondary?
>
> --
> Yoshiyuki Asaba
> y-asaba at sraoss.co.jp
>
>
> -------------------------------------------------------



-- 
Hervé Piedvache

Elma Ingénierie Informatique
Groupe Maximiles S.A.
3 rue d'Uzès
F-75002 - Paris - France
Pho. 33-144949901
Fax. 33-144882747
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20070926/80f8c459/attachment-0001.html