Resend due to size. On Sun, Nov 9, 2008 at 10:29 PM, nir osovsky <[EMAIL PROTECTED]> wrote:
> Hi, > > In addition to the fact I'm not familiar with CVS, source codes and > compiling I have a new problem now. > 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 6:15 PM, nir osovsky <[EMAIL PROTECTED]> wrote: > >> Thank you. >> >> Unfortunately, I'm not familiar with CVS, source codes and compiling and >> I'm afraid I will break something that is already running. Is there a way >> to get around this? >> >> 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 >>> >>> > Hi Tatsuo, >>> > >>> > What is it "the CVS head version"? >>> > Where do I take it from? >>> > How do I run it? >>> > >>> > Thanks, >>> > Nir >>> > >>> > 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 Sun, Nov 9, 2008 at 12:21 AM, nir osovsky <[EMAIL PROTECTED]> >>> > > wrote: >>> > > > >>> > > > > Thank you for the quick reply. >>> > > > > 1. I'm using pgpool-II ver 2.0.1 >>> > > > > 2. more postgres.log.1226217600 >>> > > > > >>> > > > > I hope this helps. >>> > > > > >>> > > > > Thanks, >>> > > > > Nir >>> > > > > >>> > > > > >>> > > > > >>> > > > > 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: 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 Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general