[Pgpool-general] pgpool-II-2.1-beta2 inserts stuck in parallel mode

Vlad Kosilov vkosilov at contigo.com
Thu Jun 5 23:38:31 UTC 2008


responding to my own post...

the only way I was able to make parallel mode functional:
downgrade to pgpool-II-2.0.1, replace its pool_rewrite_query.c with 
version of this file from pgpool-II-2.1-beta2, and recompile.

in my experience neither version of pgpool-II-2.x worked with parallel 
mode without tweaking
hopefully pgpool-II-2.1 stable release will fix the issue.

is there a tentative release date for pgpool-II-2.1 stable ?
Thanks,
V.

I found
Vlad Kosilov wrote:
> I'm experimenting with pgpool-II-2.1-beta2 in parallel mode with two 
> back-end databases running pgsql-8.3.1, and 3rd host running pgpool and 
> pgsql-8.3.1 system/pgpool db.
> I'm having with loading following file where only first insert 
> successfully gets through and second insert hangs.
>
> /usr/local/pgsql-8.3.1/bin/psql -e -U postgres -h 192.168.0.102 -p 9999 
> -d MONSOONAUDIT -f ./tcp_audit_0.dmp
> INSERT INTO tcp_audit_vlad (id, beacon_id, message, flow, "timestamp", 
> unique_id, byte_count) VALUES (531391045, 0, 'message_0', 'in', 
> 1212303601, '352023005147018', 297);
> INSERT 0 1
> INSERT INTO tcp_audit_vlad (id, beacon_id, message, flow, "timestamp", 
> unique_id, byte_count) VALUES (531391046, 0, 'message_1', 'in', 
> 1212303601, '352023005147018', 100);
> ... hangs here ..
>   



More information about the Pgpool-general mailing list