[Pgpool-general] Parallel Query Mode - SELECT, Phppgadmin, Psql

[Vlad Kosilov]

I noticed your version of pgpool is pgpool-II 2.1beta2
you may want to update to latest release - RC1
btw, I've had my share of problems using parallel mode with beta2 ...
I'm also about to redo my tests with RC1 which should hopefully fix my 
parallel mode issues.
V.

calimlimvl at nationalbookstore.com.ph wrote:
> Hello!
>
> First of all, thank you for taking the time to reply and excellent tip
> regarding my last question about Parallel Query. However, I've got a new
> problem.
>
> In Parallel Query Mode, as per the Tutorial guidelines, I created the
> following:
>
> - Database "test"
> - Schema "testschema"
> - Table "testtable"
> - Fields "id integer", "name varchar(20)"
> - Function pgpool_catalog.dist_def_test with same ranges (1..100000 etc)
> - Inserted a row in dist_def table with key "id"
>
> I have 3 backend servers 0, 1, 2 and 1 pgpool-II dedicated server. I did
> not insert a row in replicate_def because I still don't understand that
> part (sorry).
>
> My question is that whenever I issue the command:
>
> postgres at pgpool-server:~$ psql -p 9999 -c "INSERT INTO
> testschema.testtable VALUES (100000,'testname')" test
>
> ... I checked all the backends and it send the data to node0 ALONE and
> when I do a SELECT *, it shows only 1 row.
>
> But when I use Phppgadmin or even run a PHP script (using PDO) on port
> 9999 of the pgpool-II server to insert data, I checked all the backends
> and all of them has the copy of the inserted row. When I do SELECT *, I
> get 3 rows of the same data. Another thing about Phppgadmin, when I click
> on the BROWSE button on testtable, it just keeps on Loading... meaning, it
> stuck forever for some reason and I had to kill all pgpool processes.
>
> tail postgresql log: lots of "LOG:  unexpected EOF on client connection"
> tail pgpool log:
>
> 2008-07-10 15:41:28 DEBUG: pid 6621: read_kind_from_backend: read kind
> from 0 th backend Z NUM_BACKENDS: 3
> 2008-07-10 15:41:28 DEBUG: pid 6621: read_kind_from_backend: read kind
> from 1 th backend Z NUM_BACKENDS: 3
> 2008-07-10 15:41:28 DEBUG: pid 6621: read_kind_from_backend: read kind
> from 2 th backend Z NUM_BACKENDS: 3
> 2008-07-10 15:41:28 DEBUG: pid 6621: pool_process_query: kind from backend: Z
> 2008-07-10 15:41:28 DEBUG: pid 6621: pool_read_message_length: slot: 0
> length: 5
> 2008-07-10 15:41:28 DEBUG: pid 6621: pool_read_message_length: slot: 1
> length: 5
> 2008-07-10 15:41:28 DEBUG: pid 6621: pool_read_message_length: slot: 2
> length: 5
> 2008-07-10 15:41:28 DEBUG: pid 6621: ReadyForQuery: message length: 5
> 2008-07-10 15:41:28 DEBUG: pid 6621: ReadyForQuery: transaction state: I
> 2008-07-10 15:41:28 DEBUG: pid 6621: pool_connection_pool_timer: set close
> time 1215675688
>
> Version: pgpool-II 2.1beta2
> OS: Ubuntu 8.04 Server
> PostgreSQL: 8.3.1
>
> Please help. I really want this to work. Ive been after this for 3 months
> now.
>
> Thank you very much for your help.
>
> Regards,
> Viril
>
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
>
>   


-- 
________________________________________
Vladimir (Vlad) Kosilov
Senior Systems Administrator
Contigo Systems Inc.
604.683.3106 (phone)
604.648.9886 (fax)
vkosilov at contigo.com
www.contigo.com
________________________________________