Hi, Do you set parallel_mode to true?
Regards, -- Yoshiyuki Asaba [EMAIL PROTECTED] From: [EMAIL PROTECTED] Subject: [Pgpool-general] Parallel Query Mode - SELECT, Phppgadmin, Psql Date: Thu, 10 Jul 2008 15:45:11 +0800 (PHT) > 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: > > [EMAIL PROTECTED]:~$ 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 > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
