Thanks for the feedback. Could you show me postgresql.conf? -- Tatsuo Ishii SRA OSS, Inc. Japan
> Hi Tatsuo, > > THANK YOU! > I was able to download the file, and install it (configure, make & make > install). > > I run the command again and here are the log file you asked for: > > psql -p 9999 -c "INSERT INTO branches VALUES (3,1,' ')" > ============================================ > DEBUG: InitPostgres > DEBUG: StartTransaction > DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, > xid/subid/cid: 28279195/1/0, nestlvl: 1, children: <> > DEBUG: CommitTransaction > DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, > xid/subid/cid: 28279195/1/0, nestlvl: 1, children: <> > server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > connection to server was lost > > postgresql.log > =========== > [2008-11-12 00:35:53.851 PST] :[unknown] LOG: connection received: host= > 192.168.158.38 port=58332 > [2008-11-12 00:35:53.851 PST] : DEBUG: forked new backend, pid=509 socket=8 > [2008-11-12 00:35:53.855 PST] 192.168.158.38:postgres LOG: connection > authorized: user=postgres database=postgres > [2008-11-12 00:35:53.855 PST] 192.168.158.38:postgres DEBUG: postmaster > child[509]: starting with ( > [2008-11-12 00:35:53.855 PST] 192.168.158.38:postgres DEBUG: postgres > [2008-11-12 00:35:53.855 PST] 192.168.158.38:postgres DEBUG: -v196608 > [2008-11-12 00:35:53.855 PST] 192.168.158.38:postgres DEBUG: -p > [2008-11-12 00:35:53.855 PST] 192.168.158.38:postgres DEBUG: postgres > [2008-11-12 00:35:53.855 PST] 192.168.158.38:postgres DEBUG: ) > [2008-11-12 00:35:53.855 PST] 192.168.158.38:postgres DEBUG: InitPostgres > [2008-11-12 00:35:53.856 PST] 192.168.158.38:postgres DEBUG: > StartTransaction > [2008-11-12 00:35:53.856 PST] 192.168.158.38:postgres DEBUG: name: unnamed; > blockState: DEFAULT; state: INPROGR, xi > d/subid/cid: 28279195/1/0, nestlvl: 1, children: <> > [2008-11-12 00:35:53.857 PST] 192.168.158.38:postgres DEBUG: > CommitTransaction > [2008-11-12 00:35:53.857 PST] 192.168.158.38:postgres DEBUG: name: unnamed; > blockState: STARTED; state: INPROGR, xi > d/subid/cid: 28279195/1/0, nestlvl: 1, children: <> > [2008-11-12 00:35:53.859 PST] 192.168.158.38:postgres DEBUG: > StartTransactionCommand > [2008-11-12 00:35:53.859 PST] 192.168.158.38:postgres DEBUG: > StartTransaction > [2008-11-12 00:35:53.859 PST] 192.168.158.38:postgres DEBUG: name: unnamed; > blockState: DEFAULT; state: INPROGR, xi > d/subid/cid: 28279196/1/0, nestlvl: 1, children: <> > [2008-11-12 00:35:53.859 PST] 192.168.158.38:postgres LOG: statement: BEGIN > [2008-11-12 00:35:53.859 PST] 192.168.158.38:postgres DEBUG: ProcessUtility > [2008-11-12 00:35:53.859 PST] 192.168.158.38:postgres DEBUG: > CommitTransactionCommand > [2008-11-12 00:35:53.859 PST] 192.168.158.38:postgres LOG: duration: 0.383 > ms > [2008-11-12 00:35:53.859 PST] 192.168.158.38:postgres LOG: duration: 0.383 > ms statement: BEGIN > [2008-11-12 00:35:53.860 PST] 192.168.158.38:postgres LOG: could not > receive data from client: Connection reset by peer > [2008-11-12 00:35:53.860 PST] 192.168.158.38:postgres LOG: unexpected EOF > on client connection > [2008-11-12 00:35:53.860 PST] 192.168.158.38:postgres DEBUG: proc_exit(0) > [2008-11-12 00:35:53.860 PST] 192.168.158.38:postgres DEBUG: shmem_exit(0) > [2008-11-12 00:35:53.860 PST] 192.168.158.38:postgres LOG: disconnection: > session time: 0:00:00.00 user=postgres database > =postgres host=192.168.158.38 port=58332 > [2008-11-12 00:35:53.860 PST] 192.168.158.38:postgres DEBUG: exit(0) > [2008-11-12 00:35:53.860 PST] : DEBUG: reaping dead processes > [2008-11-12 00:35:53.860 PST] : DEBUG: server process (PID 509) exited with > exit code 0 > > pgpool.log > ======== > 2008-11-12 00:35:09 LOG: pid 438: pgpool successfully started > 2008-11-12 00:35:09 DEBUG: pid 472: I am PCP 472 > 2008-11-12 00:35:53 DEBUG: pid 471: I am 471 accept fd 5 > 2008-11-12 00:35:53 DEBUG: pid 471: Protocol Major: 3 Minor: 0 database: > postgres user: postgres > 2008-11-12 00:35:53 DEBUG: pid 471: new_connection: connecting 0 backend > 2008-11-12 00:35:53 DEBUG: pid 471: new_connection: connecting 1 backend > 2008-11-12 00:35:53 DEBUG: pid 471: pool_read_message_length: slot: 0 > length: 8 > 2008-11-12 00:35:53 DEBUG: pid 471: pool_read_message_length: slot: 1 > length: 8 > 2008-11-12 00:35:53 DEBUG: pid 471: pool_read_message_length2: master slot: > 0 length: 25 > 2008-11-12 00:35:53 DEBUG: pid 471: pool_read_message_length2: master slot: > 1 length: 25 > 2008-11-12 00:35:53 DEBUG: pid 471: 0 th backend: name: client_encoding > value: UTF8 > 2008-11-12 00:35:53 DEBUG: pid 471: 1 th backend: name: client_encoding > value: UTF8 > 2008-11-12 00:35:53 DEBUG: pid 471: pool_read_message_length2: master slot: > 0 length: 23 > 2008-11-12 00:35:53 DEBUG: pid 471: pool_read_message_length2: master slot: > 1 length: 23 > 2008-11-12 00:35:53 DEBUG: pid 471: 0 th backend: name: DateStyle value: > ISO, MDY > 2008-11-12 00:35:53 DEBUG: pid 471: 1 th backend: name: DateStyle value: > ISO, MDY > 2008-11-12 00:35:53 DEBUG: pid 471: pool_read_message_length2: master slot: > 0 length: 26 > 2008-11-12 00:35:53 DEBUG: pid 471: pool_read_message_length2: master slot: > 1 length: 26 > 2008-11-12 00:35:53 DEBUG: pid 471: 0 th backend: name: integer_datetimes > value: off > 2008-11-12 00:35:53 DEBUG: pid 471: 1 th backend: name: integer_datetimes > value: off > 2008-11-12 00:35:53 DEBUG: pid 471: pool_read_message_length2: master slot: > 0 length: 20 > 2008-11-12 00:35:53 DEBUG: pid 471: pool_read_message_length2: master slot: > 1 length: 20 > 2008-11-12 00:35:53 DEBUG: pid 471: 0 th backend: name: is_superuser value: > on > 2008-11-12 00:35:53 DEBUG: pid 471: 1 th backend: name: is_superuser value: > on > 2008-11-12 00:35:53 DEBUG: pid 471: pool_read_message_length2: master slot: > 0 length: 25 > 2008-11-12 00:35:53 DEBUG: pid 471: pool_read_message_length2: master slot: > 1 length: 25 > 2008-11-12 00:35:53 DEBUG: pid 471: 0 th backend: name: server_encoding > value: UTF8 > 2008-11-12 00:35:53 DEBUG: pid 471: 1 th backend: name: server_encoding > value: UTF8 > 2008-11-12 00:35:53 DEBUG: pid 471: pool_read_message_length2: master slot: > 0 length: 25 > 2008-11-12 00:35:53 DEBUG: pid 471: pool_read_message_length2: master slot: > 1 length: 25 > 2008-11-12 00:35:53 DEBUG: pid 471: 0 th backend: name: server_version > value: 8.1.2 > 2008-11-12 00:35:53 DEBUG: pid 471: 1 th backend: name: server_version > value: 8.1.2 > 2008-11-12 00:35:53 DEBUG: pid 471: pool_read_message_length2: master slot: > 0 length: 35 > 2008-11-12 00:35:53 DEBUG: pid 471: pool_read_message_length2: master slot: > 1 length: 35 > 2008-11-12 00:35:53 DEBUG: pid 471: 0 th backend: name: > session_authorization value: postgres > 2008-11-12 00:35:53 DEBUG: pid 471: 1 th backend: name: > session_authorization value: postgres > 2008-11-12 00:35:53 DEBUG: pid 471: pool_read_message_length2: master slot: > 0 length: 36 > 2008-11-12 00:35:53 DEBUG: pid 471: pool_read_message_length2: master slot: > 1 length: 36 > 2008-11-12 00:35:53 DEBUG: pid 471: 0 th backend: name: > standard_conforming_strings value: off > 2008-11-12 00:35:53 DEBUG: pid 471: 1 th backend: name: > standard_conforming_strings value: off > 2008-11-12 00:35:53 DEBUG: pid 471: pool_read_message_length2: master slot: > 0 length: 21 > 2008-11-12 00:35:53 DEBUG: pid 471: pool_read_message_length2: master slot: > 1 length: 21 > 2008-11-12 00:35:53 DEBUG: pid 471: 0 th backend: name: TimeZone value: > PST8PDT > 2008-11-12 00:35:53 DEBUG: pid 471: 1 th backend: name: TimeZone value: > PST8PDT > 2008-11-12 00:35:53 DEBUG: pid 471: pool_read_message_length: slot: 0 > length: 12 > 2008-11-12 00:35:53 DEBUG: pid 471: pool_read_message_length: slot: 1 > length: 12 > 2008-11-12 00:35:53 DEBUG: pid 471: pool_send_auth_ok: send pid 27154 to > frontend > 2008-11-12 00:35:53 DEBUG: pid 471: select_load_balancing_node: selected > backend id is 1 > 2008-11-12 00:35:53 DEBUG: pid 471: read_kind_from_backend: read kind from 0 > th backend Z NUM_BACKENDS: 2 > 2008-11-12 00:35:53 DEBUG: pid 471: read_kind_from_backend: read kind from 1 > th backend Z NUM_BACKENDS: 2 > 2008-11-12 00:35:53 DEBUG: pid 471: pool_process_query: kind from backend: Z > 2008-11-12 00:35:53 DEBUG: pid 471: pool_read_message_length: slot: 0 > length: 5 > 2008-11-12 00:35:53 DEBUG: pid 471: pool_read_message_length: slot: 1 > length: 5 > 2008-11-12 00:35:53 DEBUG: pid 471: ReadyForQuery: message length: 5 > 2008-11-12 00:35:53 DEBUG: pid 471: ReadyForQuery: transaction state: I > 2008-11-12 00:35:53 DEBUG: pid 471: read kind from frontend Q(51) > 2008-11-12 00:35:53 DEBUG: pid 471: statement2: INSERT INTO branches VALUES > (3,1,' ') > 2008-11-12 00:35:53 DEBUG: pid 471: do_command: Query: BEGIN > 2008-11-12 00:35:53 DEBUG: pid 471: command tag: SDEBUG > 2008-11-12 00:35:53 DEBUG: pid 471: command tag: SDEBUG > 2008-11-12 00:35:53 DEBUG: pid 471: command tag: SDEBUG > 2008-11-12 00:35:53 DEBUG: pid 471: command tag: SLOG > 2008-11-12 00:35:53 DEBUG: pid 471: command tag: SDEBUG > 2008-11-12 00:35:53 DEBUG: pid 471: command tag: SDEBUG > 2008-11-12 00:35:53 DEBUG: pid 471: command tag: BEGIN > 2008-11-12 00:35:53 ERROR: pid 471: do_command: backend returns N while > expecting ReadyForQuery > 2008-11-12 00:35:53 LOG: pid 471: do_child: exits with status 1 due to > error > 2008-11-12 00:35:53 DEBUG: pid 438: reap_handler called > 2008-11-12 00:35:53 DEBUG: pid 438: reap_handler: call wait3 > 2008-11-12 00:35:53 DEBUG: pid 438: child 471 exits with status 256 by > signal 0 > 2008-11-12 00:35:53 DEBUG: pid 510: I am 510 > 2008-11-12 00:35:53 DEBUG: pid 438: fork a new child pid 510 > 2008-11-12 00:35:53 DEBUG: pid 438: reap_handler: normally exited > > > On Wed, Nov 12, 2008 at 12:12 AM, Tatsuo Ishii <[EMAIL PROTECTED]> wrote: > > > Ok, I have put CVS head source tar ball at: > > > > http://www.sra.co.jp/people/t-ishii/tmp/pgpool-II.tar.gz > > > > Please grab and try. > > -- > > Tatsuo Ishii > > SRA OSS, Inc. Japan > > > > > 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 > > > > > > > > _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
