[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