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 <[email protected]> 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"
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 */
_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
