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

[calimlimvl at nationalbookstore.com.ph]

Hello,

Update! Upgraded my setup to the latest releases except PostgreSQL 8.3.1:

Pgpool-II: 2.1 RC1
Phppgadmin: 4.2 (Ubuntu 8.10 Intrepid deb file)

* Issue on BROWSE button getting stuck: FIXED
* Issue on inserting a row and partitioning it properly: FIXED
* Only issue left is with Phppgadmin (again) displaying an error about
"Undefined index: strconfdropcred" but they admitted it's a bug and to be
fixed on 4.2.1 release ;)

Everything else works. Now we're ready to fill the servers with data then
test if parallel query is really going to work VS. our single InnoDB MySQL
Server. Thanks guys for your help. I'm just sharing my experiences with
this great project and hopefully it would help somebody else out there. :)

Regards,
Viril Calimlim

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