[Pgpool-general] pgpool-II 2.2 beta2 released

[Marcelo Martins]

Hi Jaume,

Actually Lukasz reported that and Tatsuo provided a patch for it  
yesterday at 4:22AM email.

I actually just changed the pool_process_query.c file on beta2 to  
comment out the two lines with  T_CreatedbStmt and also T_DropdbStmt   
since the same goes for droping a DB and then created some etch pkgs  
for it. I tried out CREATE and DROP DB and wokred ok after that.


Marcelo
PostgreSQL DBA
Linux/Solaris System Administrator

On Feb 10, 2009, at 10:19 AM, Jaume Sabater wrote:

> 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"
> <pgpool.conf.gz>_______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general