[Pgpool-general] pgpool-II 2.2 beta2 released

[Tatsuo Ishii]

Thanks for the report.

This is was reported by Lukasz and I have fixed it on the CVS Head.
Could you please apply included patches and try?
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> On Sat, Feb 7, 2009 at 3:45 PM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
> 
> > pgpool-II 2.2 beta2 released. Changes from beta1:
> 
> Hi, Tatsuo.
> 
> Here are you are my first bug report to beta2 version (the "vanilla"
> one taken from the downloads section in pgFoundry). I set up the
> cluster with load balance and replication. Then I tried to create a
> database remotely with the following command:
> 
> createdb -h 10.0.3.75 -p 9999 -U pgpool2 bench_replication
> 
> This is the syslog in the master node:
> 
> 2009-02-10 17:12:02 CET ERROR:  CREATE DATABASE cannot run inside a
> transaction block
> 2009-02-10 17:12:02 CET STATEMENT:  CREATE DATABASE bench_replication;
> 
> And this is the syslog in the slave node:
> 
> 2009-02-10 17:12:02 CET ERROR:  syntax error at or near "send" at character 1
> 2009-02-10 17:12:02 CET STATEMENT:  send invalid query from pgpool to
> abort transaction
> 
> This was on Debian Lenny with PostgreSQL 8.3.5-1.
> 
> Shall you need any more information, please let me know. See the
> attached pgpool.conf file for reference.
> 
> P.S. To be honest, I cannot remember whether, with version 2.1, I
> created the databases on each node first or whether I did that through
> pgpool2, although I think it was the latter.
> 
> -- 
> Jaume Sabater
> http://linuxsilo.net/
> 
> "Ubi sapientas ibi libertas"
-------------- next part --------------
Index: pool_process_query.c
===================================================================
RCS file: /cvsroot/pgpool/pgpool-II/pool_process_query.c,v
retrieving revision 1.137
retrieving revision 1.138
diff -c -r1.137 -r1.138
*** pool_process_query.c	6 Feb 2009 15:30:51 -0000	1.137
--- pool_process_query.c	10 Feb 2009 01:11:43 -0000	1.138
***************
*** 1,6 ****
  /* -*-pgsql-c-*- */
  /*
!  * $Header: /cvsroot/pgpool/pgpool-II/pool_process_query.c,v 1.137 2009/02/06 15:30:51 t-ishii Exp $
   *
   * pgpool: a language independent connection pool server for PostgreSQL 
   * written by Tatsuo Ishii
--- 1,6 ----
  /* -*-pgsql-c-*- */
  /*
!  * $Header: /cvsroot/pgpool/pgpool-II/pool_process_query.c,v 1.138 2009/02/10 01:11:43 t-ishii Exp $
   *
   * pgpool: a language independent connection pool server for PostgreSQL 
   * written by Tatsuo Ishii
***************
*** 3910,3917 ****
  		T_ViewStmt,		/* CREATE VIEW */
  		T_LoadStmt,
  		T_CreateDomainStmt,
! 		T_CreatedbStmt,
! 		T_DropdbStmt,
  		T_CreateSeqStmt,
  		T_AlterSeqStmt,
  		T_VariableSetStmt,		/* SET */
--- 3910,3919 ----
  		T_ViewStmt,		/* CREATE VIEW */
  		T_LoadStmt,
  		T_CreateDomainStmt,
! 		/*
! 		  T_CreatedbStmt,	CREATE DATABASE/DROP DATABASE cannot execute inside a transaction block
! 		  T_DropdbStmt,
! 		*/
  		T_CreateSeqStmt,
  		T_AlterSeqStmt,
  		T_VariableSetStmt,		/* SET */