[Pgpool-general] prepared statements

Simone Tregnago simonetregnago at grivaonline.com
Tue Oct 28 09:33:27 UTC 2008


Hi,
yesterday I've written a function that produce the following error:

Oct 27 16:03:45 pgmirror1 pgpool: 2008-10-27 16:03:45 ERROR: pid 5529: 
pool_read_kind: kind does not match between master(73) slot[1] (84)
Oct 27 16:03:45 pgmirror1 pgpool: 2008-10-27 16:03:45 ERROR: pid 5529: 
pool_read_kind: kind does not match between master(73) slot[1] (84)

The error appears when I execute prepared statements. If I change the 
method, executing new statements each time without preparing them 
before, then pgpool works well without errors.

For example, one statement that raise the error is:
update presenze.boldaydet set "IDCAUSALE"=
	(select "IDCAUSALE" from presenze.causali
	 where "CODCAUSALE"=:codcausale)
	where"IDBOLDAYDET"=:idboldaydet

It's possible that using a prepared statement with a select inside an
update confuses pgpool?
The function is written in .net, with the Npgsql connector. Pgpool-II is 
version 2.1, and Postgresql backend is 8.1.11

Thanks,
Simone Tregnago


More information about the Pgpool-general mailing list