[Pgpool-general] Pgpool-II - replication problems

Mon Nov 10 08:10:32 UTC 2008

Resend due to size.

On Sun, Nov 9, 2008 at 10:29 PM, nir osovsky <nosovsky1 at gmail.com> 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:anonymous at cvs.pgfoundry.org:/cvsroot/pgpool login
> Logging in to :pserver:anonymous at cvs.pgfoundry.org:2401/cvsroot/pgpool
> CVS password:
> cvs [login aborted]: connect to [cvs.pgfoundry.org]:2401 failed:
> Connection timed out
>
> 2. cvs -d :pserver:anonymous at cvs.pgfoundry.org:/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 <nosovsky1 at gmail.com> 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 <ishii at sraoss.co.jp> 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 <ishii at sraoss.co.jp>
>>> 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 <nosovsky1 at gmail.com>
>>> > > 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 <
>>> ishii at sraoss.co.jp>
>>> > > 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
>>> > > > >>
>>> > > > >
>>> > > > >
>>> > >
>>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20081110/74dd4a88/attachment-0001.html 