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

[Yoshiyuki Asaba]

Hi,

From: Hervé_Piedvache <herve at elma.fr>
Subject: Re: Fwd: Re: [Pgpool-general] [HELP] Sometime it's running sometime not
Date: Wed, 26 Sep 2007 12:08:27 +0200

> 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 !!!

Do you use pgpool-II 1.2? It works perfectly fine with the following
code.

----
<?php
try {
	$dbh = new PDO('pgsql:host=localhost;port=9999;dbname=test', 'y-asaba', '');

	echo "connect\n";
	$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	$stmt = $dbh->prepare("select $1::int");
	$stmt->bindParam(1, $val, PDO::PARAM_INT);
	$val = 123;
	$stmt->execute();
	print_r($stmt->fetch());	
  } catch (Exception $e) {
	  echo "failed: " . $e->getMessage();
	}

?> 
----

BTW, I've fixed handling Parse message. It caused deadlock error.
I think your problem have been fixed in CVS repository.

----
2007-09-25 22:53:57 DEBUG: pid 13321: read kind from frontend P(50)
                                                              ^^^^^
                                                          Parse message
2007-09-25 22:53:57 ERROR: pid 13321: pool_read_kind: kind does not match 
between master(49) slot[1] (69)
----

We release pgpool-II V1.2.1 at tomorrow.

Regards,
--
Yoshiyuki Asaba
y-asaba at sraoss.co.jp