Hi Tatsuo, I urgently need your help. I appreciate any help you can give.
While trying to follow the instruction at http://pgfoundry.org/scm/?group_id=1000055 I'm getting the following errors: 1. cvs -d :pserver:[EMAIL PROTECTED]:/cvsroot/pgpool login Logging in to :pserver:[EMAIL PROTECTED]:2401/cvsroot/pgpool CVS password: cvs [login aborted]: connect to [cvs.pgfoundry.org]:2401 failed: Connection timed out 2. cvs -d :pserver:[EMAIL PROTECTED]:/cvsroot/pgpool checkout pgpool/pgpool-II/ cvs [checkout aborted]: connect to [cvs.pgfoundry.org]:2401 failed: Connection timed out Please help me. Thanks, Nir > On Sun, Nov 9, 2008 at 5:35 PM, Tatsuo Ishii <[EMAIL PROTECTED]> wrote: > >> CVS Head is the lastest development version. >> >> See: >> >> http://pgfoundry.org/scm/?group_id=1000055 >> >> to know how to get it. After getting the source code, the way for >> compiling and running is exactly same as the production release. >> -- >> Tatsuo Ishii >> SRA OSS, Inc. Japan >> > > > On Sun, Nov 9, 2008 at 5:02 PM, Tatsuo Ishii <[EMAIL PROTECTED]> wrote: >> > >> > > Hum. I think I need more info. I have added more debug message to the >> > > CVS Head version. Can you grab the CVS head and try again? >> > > -- >> > > Tatsuo Ishii >> > > SRA OSS, Inc. Japan >> > > >> > > > Please ignore the previous log. Here is the correct one: >> > > > >> > > > [2008-11-09 00:23:19.115 PST] :[unknown] LOG: connection received: >> host= >> > > > 127.0.0.1 port=38487 >> > > > [2008-11-09 00:23:19.115 PST] : DEBUG: forked new backend, >> pid=24766 >> > > > socket=8 >> > > > [2008-11-09 00:23:19.117 PST] 127.0.0.1:bench_replication LOG: >> > > connection >> > > > authorized: user=postgres database=bench_replic >> > > > ation >> > > > [2008-11-09 00:23:19.117 PST] 127.0.0.1:bench_replication DEBUG: >> > > postmaster >> > > > child[24766]: starting with ( >> > > > [2008-11-09 00:23:19.117 PST] 127.0.0.1:bench_replication DEBUG: >> > > > postgres >> > > > [2008-11-09 00:23:19.117 PST] 127.0.0.1:bench_replication DEBUG: >> > > > -v196608 >> > > > [2008-11-09 00:23:19.117 PST] 127.0.0.1:bench_replication DEBUG: >> > > -p >> > > > [2008-11-09 00:23:19.117 PST] 127.0.0.1:bench_replication DEBUG: >> > > > bench_replication >> > > > [2008-11-09 00:23:19.117 PST] 127.0.0.1:bench_replication DEBUG: ) >> > > > [2008-11-09 00:23:19.117 PST] 127.0.0.1:bench_replication DEBUG: >> > > > InitPostgres >> > > > [2008-11-09 00:23:19.118 PST] 127.0.0.1:bench_replication DEBUG: >> > > > StartTransaction >> > > > [2008-11-09 00:23:19.118 PST] 127.0.0.1:bench_replication DEBUG: >> name: >> > > > unnamed; blockState: DEFAULT; state: INPROGR >> > > > , xid/subid/cid: 28257057/1/0, nestlvl: 1, children: <> >> > > > [2008-11-09 00:23:19.118 PST] 127.0.0.1:bench_replication DEBUG: >> > > > CommitTransaction >> > > > [2008-11-09 00:23:19.118 PST] 127.0.0.1:bench_replication DEBUG: >> name: >> > > > unnamed; blockState: STARTED; state: INPROGR >> > > > , xid/subid/cid: 28257057/1/0, nestlvl: 1, children: <> >> > > > [2008-11-09 00:23:19.120 PST] 127.0.0.1:bench_replication DEBUG: >> > > > StartTransactionCommand >> > > > [2008-11-09 00:23:19.120 PST] 127.0.0.1:bench_replication DEBUG: >> > > > StartTransaction >> > > > [2008-11-09 00:23:19.120 PST] 127.0.0.1:bench_replication DEBUG: >> name: >> > > > unnamed; blockState: DEFAULT; state: INPROGR >> > > > , xid/subid/cid: 28257058/1/0, nestlvl: 1, children: <> >> > > > [2008-11-09 00:23:19.121 PST] 127.0.0.1:bench_replication LOG: >> > > statement: >> > > > BEGIN >> > > > [2008-11-09 00:23:19.121 PST] 127.0.0.1:bench_replication DEBUG: >> > > > ProcessUtility >> > > > [2008-11-09 00:23:19.121 PST] 127.0.0.1:bench_replication DEBUG: >> > > > CommitTransactionCommand >> > > > [2008-11-09 00:23:19.121 PST] 127.0.0.1:bench_replication LOG: >> > > duration: >> > > > 0.269 ms >> > > > [2008-11-09 00:23:19.121 PST] 127.0.0.1:bench_replication LOG: >> > > duration: >> > > > 0.269 ms statement: BEGIN >> > > > [2008-11-09 00:23:19.121 PST] 127.0.0.1:bench_replication LOG: >> could >> > > not >> > > > receive data from client: Connection reset by pe >> > > > er >> > > > [2008-11-09 00:23:19.121 PST] 127.0.0.1:bench_replication LOG: >> > > unexpected >> > > > EOF on client connection >> > > > [2008-11-09 00:23:19.121 PST] 127.0.0.1:bench_replication DEBUG: >> > > > proc_exit(0) >> > > > [2008-11-09 00:23:19.121 PST] 127.0.0.1:bench_replication DEBUG: >> > > > shmem_exit(0) >> > > > [2008-11-09 00:23:19.121 PST] 127.0.0.1:bench_replication LOG: >> > > > disconnection: session time: 0:00:00.00 user=postgres data >> > > > base=bench_replication host=127.0.0.1 port=38487 >> > > > [2008-11-09 00:23:19.121 PST] 127.0.0.1:bench_replication DEBUG: >> > > exit(0) >> > > > [2008-11-09 00:23:19.122 PST] : DEBUG: reaping dead processes >> > > > [2008-11-09 00:23:19.122 PST] : DEBUG: server process (PID 24766) >> exited >> > > > with exit code 0 >> > > > >> > > > > On Sat, Nov 8, 2008 at 11:43 PM, Tatsuo Ishii <[EMAIL PROTECTED] >> > >> > > wrote: >> > > > > >> > > > >> Can you show me the error log of PostgreSQL? >> > > > >> >> > > > >> Also is it possible to try the latest version of of pgpool-II >> (2.1)? >> > > > >> -- >> > > > >> Tatsuo Ishii >> > > > >> SRA OSS, Inc. Japan >> > > > >> >> > > > >> > Hi, >> > > > >> > I'm trying to configure pgpool-II 2.to to replication between >> two >> > > > >> computers >> > > > >> > and postgresql database in each. >> > > > >> > pgpool-II is defined on dev1. >> > > > >> > postgresql 8.1.11 (testdb) is defined on dev1 >> > > > >> > postgresql 8.1.11 (testdb) is defined on dev2 >> > > > >> > >> > > > >> > I can run the following commands from each computer and run >> queries >> > > from >> > > > >> the >> > > > >> > databases: >> > > > >> > psql -h dev1 -U postgres testdb >> > > > >> > psql -h dev2 -U postgres testdb >> > > > >> > >> > > > >> > I'm also able to do and see the databases bench_replication >> created >> > > on >> > > > >> both >> > > > >> > computers and have the same data: >> > > > >> > createdb -p 9999 bench_replication >> > > > >> > pgbench -i -p 9999 bench_replication >> > > > >> > >> > > > >> > While trying to run: >> > > > >> > psql -p 9999 -c "INSERT INTO branches VALUES (3,1,' ')" >> > > > >> bench_replication >> > > > >> > >> > > > >> > I'm getting: >> > > > >> > server closed the connection unexpectedly >> > > > >> > This probably means the server terminated abnormally >> > > > >> > before or while processing the request. >> > > > >> > connection to server was lost >> > > > >> > >> > > > >> > And the /tmp/pgpool.log show: >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: I am 23744 accept fd 0 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: Protocol Major: 3 Minor: >> 0 >> > > > >> database: >> > > > >> > bench_replication user: postgres >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: new_connection: >> connecting 0 >> > > > >> backend >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: new_connection: >> connecting 1 >> > > > >> backend >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: pool_read_message_length: >> > > slot: 0 >> > > > >> > length: 8 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: pool_read_message_length: >> > > slot: 1 >> > > > >> > length: 8 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: >> pool_read_message_length2: >> > > master >> > > > >> > slot: 0 length: 25 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: >> pool_read_message_length2: >> > > master >> > > > >> > slot: 1 length: 25 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: 0 th backend: name: >> > > > >> client_encoding >> > > > >> > value: UTF8 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: 1 th backend: name: >> > > > >> client_encoding >> > > > >> > value: UTF8 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: >> pool_read_message_length2: >> > > master >> > > > >> > slot: 0 length: 23 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: >> pool_read_message_length2: >> > > master >> > > > >> > slot: 1 length: 23 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: 0 th backend: name: >> DateStyle >> > > > >> value: >> > > > >> > ISO, MDY >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: 1 th backend: name: >> DateStyle >> > > > >> value: >> > > > >> > ISO, MDY >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: >> pool_read_message_length2: >> > > master >> > > > >> > slot: 0 length: 26 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: >> pool_read_message_length2: >> > > master >> > > > >> > slot: 1 length: 26 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: 0 th backend: name: >> > > > >> integer_datetimes >> > > > >> > value: off >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: 1 th backend: name: >> > > > >> integer_datetimes >> > > > >> > value: off >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: >> pool_read_message_length2: >> > > master >> > > > >> > slot: 0 length: 20 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: >> pool_read_message_length2: >> > > master >> > > > >> > slot: 1 length: 20 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: 0 th backend: name: >> > > is_superuser >> > > > >> > value: on >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: 1 th backend: name: >> > > is_superuser >> > > > >> > value: on >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: >> pool_read_message_length2: >> > > master >> > > > >> > slot: 0 length: 25 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: >> pool_read_message_length2: >> > > master >> > > > >> > slot: 1 length: 25 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: 0 th backend: name: >> > > > >> server_encoding >> > > > >> > value: UTF8 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: 1 th backend: name: >> > > > >> server_encoding >> > > > >> > value: UTF8 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: >> pool_read_message_length2: >> > > master >> > > > >> > slot: 0 length: 25 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: >> pool_read_message_length2: >> > > master >> > > > >> > slot: 1 length: 25 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: 0 th backend: name: >> > > server_version >> > > > >> > value: 8.1.2 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: 1 th backend: name: >> > > server_version >> > > > >> > value: 8.1.2 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: >> pool_read_message_length2: >> > > master >> > > > >> > slot: 0 length: 35 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: >> pool_read_message_length2: >> > > master >> > > > >> > slot: 1 length: 35 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: 0 th backend: name: >> > > > >> > session_authorization value: postgres >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: 1 th backend: name: >> > > > >> > session_authorization value: postgres >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: >> pool_read_message_length2: >> > > master >> > > > >> > slot: 0 length: 36 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: >> pool_read_message_length2: >> > > master >> > > > >> > slot: 1 length: 36 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: 0 th backend: name: >> > > > >> > standard_conforming_strings value: off >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: 1 th backend: name: >> > > > >> > standard_conforming_strings value: off >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: >> pool_read_message_length2: >> > > master >> > > > >> > slot: 0 length: 21 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: >> pool_read_message_length2: >> > > master >> > > > >> > slot: 1 length: 21 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: 0 th backend: name: >> TimeZone >> > > > >> value: >> > > > >> > PST8PDT >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: 1 th backend: name: >> TimeZone >> > > > >> value: >> > > > >> > PST8PDT >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: pool_read_message_length: >> > > slot: 0 >> > > > >> > length: 12 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: pool_read_message_length: >> > > slot: 1 >> > > > >> > length: 12 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: pool_send_auth_ok: send >> pid >> > > 6156 >> > > > >> to >> > > > >> > frontend >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: >> select_load_balancing_node: >> > > > >> selected >> > > > >> > backend id is 0 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: read_kind_from_backend: >> read >> > > kind >> > > > >> from >> > > > >> > 0 th backend Z NUM_BACKENDS: 2 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: read_kind_from_backend: >> read >> > > kind >> > > > >> from >> > > > >> > 1 th backend Z NUM_BACKENDS: 2 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: pool_process_query: kind >> from >> > > > >> backend: >> > > > >> > Z >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: pool_read_message_length: >> > > slot: 0 >> > > > >> > length: 5 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: pool_read_message_length: >> > > slot: 1 >> > > > >> > length: 5 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: ReadyForQuery: message >> length: >> > > 5 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: ReadyForQuery: >> transaction >> > > state: >> > > > >> I >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: read kind from frontend >> Q(51) >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: statement2: INSERT INTO >> > > branches >> > > > >> > VALUES (3,1,' ') >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: do_command: Query: BEGIN >> > > > >> > 2008-11-08 22:41:53 LOG: pid 23744: do_command: backend does >> not >> > > > >> > successfully complete command BEGIN status N >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: command tag: SDEBUG >> > > > >> > 2008-11-08 22:41:53 LOG: pid 23744: do_command: backend does >> not >> > > > >> > successfully complete command BEGIN status N >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: command tag: SDEBUG >> > > > >> > 2008-11-08 22:41:53 LOG: pid 23744: do_command: backend does >> not >> > > > >> > successfully complete command BEGIN status N >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: command tag: SDEBUG >> > > > >> > 2008-11-08 22:41:53 LOG: pid 23744: do_command: backend does >> not >> > > > >> > successfully complete command BEGIN status N >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: command tag: SLOG >> > > > >> > 2008-11-08 22:41:53 LOG: pid 23744: do_command: backend does >> not >> > > > >> > successfully complete command BEGIN status N >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: command tag: SDEBUG >> > > > >> > 2008-11-08 22:41:53 LOG: pid 23744: do_command: backend does >> not >> > > > >> > successfully complete command BEGIN status N >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: command tag: SDEBUG >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23744: command tag: BEGIN >> > > > >> > 2008-11-08 22:41:53 ERROR: pid 23744: do_command: backend does >> not >> > > > >> return >> > > > >> > ReadyForQuery >> > > > >> > 2008-11-08 22:41:53 LOG: pid 23744: do_child: exits with >> status 1 >> > > due >> > > > >> to >> > > > >> > error >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23713: reap_handler called >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23713: reap_handler: call wait3 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23713: child 23744 exits with >> status >> > > 256 >> > > > >> by >> > > > >> > signal 0 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 24215: I am 24215 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23713: fork a new child pid >> 24215 >> > > > >> > 2008-11-08 22:41:53 DEBUG: pid 23713: reap_handler: normally >> exited >> > > > >> > >> > > > >> > My questions are: >> > > > >> > 1. Why the above insert command failed? >> > > > >> > 2. What do I need to configure in order for any change to the >> testdb >> > > on >> > > > >> dev1 >> > > > >> > to replicate automaticly to testdb on dev2? >> > > > >> > >> > > > >> > Can someone please help? If there is a need for additional >> > > > >> information/files >> > > > >> > please let me know. >> > > > >> > >> > > > >> > Than you for any help, >> > > > >> > Nir >> >> >
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
