Re: [Pgpool-general] pgpool crashing(?) at startup

2010-03-02 Thread Tatsuo Ishii 
Sorry for delay.
Toshihiro Kitagawa identified your problem was fixed in 
pgpool-II 2.2.4. Please upgrade.

http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/main.c.diff?r1=1.49r2=1.50f=u
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

 Sorry, I missed one step in the series:
 
   The problem is as follows:
  
   1. pgpool is stopped
   2. App is started
  Every 0.01 secs, outputs:
  psql: could not connect to server: Connection refused
   Is the server running locally and accepting
   connections on Unix domain socket /tmp/.s.PGSQL.?
  
   4. pgpool tries starting (app is trying connecting every 0.01 secs)
   5. pgpool stop running.
 
 1. pgpool is stopped
 2. App is started
 3. backend0 is up and backend1 is down (on purpose)
 4. pgpool tries starting
 5. pgpool stops. I still don't know if it is a crash or not, but it
 exits.
 
 I think it should still work with the only database available.
 
 Daniel
 
 
  -Original Message-
  From: Xavier Noguer [mailto:xnog...@antica.cl]
  Sent: Thursday, January 21, 2010 4:24 PM
  To: Crespo, Daniel @ SDS
  Cc: pgpool-general@pgfoundry.org
  Subject: Re: [Pgpool-general] pgpool crashing(?) at startup
  
  
   Hi,
  
   2010-01-21 14:31:56 ERROR: pid 10881: connection to
   192.168.101.214(5432) failed
   2010-01-21 14:31:56 ERROR: pid 10881: new_connection: create_cp()
   failed
   2010-01-21 14:31:56 LOG:   pid 10881: notice_backend_error: 1 fail
   over
   request from pid 10881
  
   this seems to indicate the second backend is down or not configured
  properly. For the 0.1 secs test do you use the exact same backends ?
  
   5. pgpool stop running.
  
   Does it crash ? Do you have the last lines on the log before it stops
  ?
  
  
   Regards
  
  On Thu, 2010-01-21 at 14:57 -0500, daniel.cre...@l-3com.com wrote:
   Hi,
  
   I'm using pgpool 2.2.2 connecting to two backends PGSQL8.2.1. Below
  is a
   diagram of my configuration
  
   .--- backend0
  /
   App --- pgpool
  \
   `--- backend1
  
   Where App, for testing purposes is:
  
   while [ 1 ]; do psql -U postgres -p  -c select 1;; sleep 0.01;
   done
  
   The problem is as follows:
  
   1. pgpool is stopped
   2. App is started
  Every 0.01 secs, outputs:
  psql: could not connect to server: Connection refused
   Is the server running locally and accepting
   connections on Unix domain socket /tmp/.s.PGSQL.?
  
   4. pgpool tries starting (app is trying connecting every 0.01 secs)
   5. pgpool stop running.
  
   Below is the output of log of pgpool
  
   2010-01-21 14:31:56 DEBUG: pid 10811: key: listen_addresses
   2010-01-21 14:31:56 DEBUG: pid 10811: value: '*' kind: 4
   2010-01-21 14:31:56 DEBUG: pid 10811: key: port
   2010-01-21 14:31:56 DEBUG: pid 10811: value:  kind: 2
   2010-01-21 14:31:56 DEBUG: pid 10811: key: pcp_port
   2010-01-21 14:31:56 DEBUG: pid 10811: value: 9898 kind: 2
   2010-01-21 14:31:56 DEBUG: pid 10811: key: socket_dir
   2010-01-21 14:31:56 DEBUG: pid 10811: value: '/tmp' kind: 4
   2010-01-21 14:31:56 DEBUG: pid 10811: key: pcp_socket_dir
   2010-01-21 14:31:56 DEBUG: pid 10811: value: '/tmp' kind: 4
   2010-01-21 14:31:56 DEBUG: pid 10811: key: backend_socket_dir
   2010-01-21 14:31:56 DEBUG: pid 10811: value: '/tmp' kind: 4
   2010-01-21 14:31:56 DEBUG: pid 10811: key: pcp_timeout
   2010-01-21 14:31:56 DEBUG: pid 10811: value: 10 kind: 2
   2010-01-21 14:31:56 DEBUG: pid 10811: key: num_init_children
   2010-01-21 14:31:56 DEBUG: pid 10811: value: 100 kind: 2
   2010-01-21 14:31:56 DEBUG: pid 10811: key: max_pool
   2010-01-21 14:31:56 DEBUG: pid 10811: value: 1 kind: 2
   2010-01-21 14:31:56 DEBUG: pid 10811: key: child_life_time
   2010-01-21 14:31:56 DEBUG: pid 10811: value: 0 kind: 2
   2010-01-21 14:31:56 DEBUG: pid 10811: key: connection_life_time
   2010-01-21 14:31:56 DEBUG: pid 10811: value: 0 kind: 2
   2010-01-21 14:31:56 DEBUG: pid 10811: key: child_max_connections
   2010-01-21 14:31:56 DEBUG: pid 10811: value: 0 kind: 2
   2010-01-21 14:31:56 DEBUG: pid 10811: key: client_idle_limit
   2010-01-21 14:31:56 DEBUG: pid 10811: value: 0 kind: 2
   2010-01-21 14:31:56 DEBUG: pid 10811: key: authentication_timeout
   2010-01-21 14:31:56 DEBUG: pid 10811: value: 60 kind: 2
   2010-01-21 14:31:56 DEBUG: pid 10811: key: logdir
   2010-01-21 14:31:56 DEBUG: pid 10811: value: '/tmp' kind: 4
   2010-01-21 14:31:56 DEBUG: pid 10811: key: pid_file_name
   2010-01-21 14:31:56 DEBUG: pid 10811: value:
   '/var/run/pgpool/pgpool.pid' kind: 4
   2010-01-21 14:31:56 DEBUG: pid 10811: key: replication_mode
   2010-01-21 14:31:56 DEBUG: pid 10811: value: true kind: 1
   2010-01-21 14:31:56 DEBUG: pid 10811: key: load_balance_mode
   2010-01-21 14:31:56 DEBUG: pid 10811: value: true kind: 1
   2010-01-21 14:31:56 DEBUG: pid 10811: key

Re: [Pgpool-general] pgpool crashing(?) at startup

2010-01-21 Thread Xavier Noguer 

 Hi,

 2010-01-21 14:31:56 ERROR: pid 10881: connection to
 192.168.101.214(5432) failed
 2010-01-21 14:31:56 ERROR: pid 10881: new_connection: create_cp()
 failed
 2010-01-21 14:31:56 LOG:   pid 10881: notice_backend_error: 1 fail
 over
 request from pid 10881

 this seems to indicate the second backend is down or not configured
properly. For the 0.1 secs test do you use the exact same backends ?

 5. pgpool stop running.

 Does it crash ? Do you have the last lines on the log before it stops ?


 Regards

On Thu, 2010-01-21 at 14:57 -0500, daniel.cre...@l-3com.com wrote:
 Hi,
 
 I'm using pgpool 2.2.2 connecting to two backends PGSQL8.2.1. Below is a
 diagram of my configuration
 
 .--- backend0
/   
 App --- pgpool
\
 `--- backend1
 
 Where App, for testing purposes is:
 
 while [ 1 ]; do psql -U postgres -p  -c select 1;; sleep 0.01;
 done
 
 The problem is as follows:
 
 1. pgpool is stopped
 2. App is started
Every 0.01 secs, outputs:
psql: could not connect to server: Connection refused
 Is the server running locally and accepting
 connections on Unix domain socket /tmp/.s.PGSQL.?
 
 4. pgpool tries starting (app is trying connecting every 0.01 secs)
 5. pgpool stop running.
 
 Below is the output of log of pgpool
 
 2010-01-21 14:31:56 DEBUG: pid 10811: key: listen_addresses
 2010-01-21 14:31:56 DEBUG: pid 10811: value: '*' kind: 4
 2010-01-21 14:31:56 DEBUG: pid 10811: key: port
 2010-01-21 14:31:56 DEBUG: pid 10811: value:  kind: 2
 2010-01-21 14:31:56 DEBUG: pid 10811: key: pcp_port
 2010-01-21 14:31:56 DEBUG: pid 10811: value: 9898 kind: 2
 2010-01-21 14:31:56 DEBUG: pid 10811: key: socket_dir
 2010-01-21 14:31:56 DEBUG: pid 10811: value: '/tmp' kind: 4
 2010-01-21 14:31:56 DEBUG: pid 10811: key: pcp_socket_dir
 2010-01-21 14:31:56 DEBUG: pid 10811: value: '/tmp' kind: 4
 2010-01-21 14:31:56 DEBUG: pid 10811: key: backend_socket_dir
 2010-01-21 14:31:56 DEBUG: pid 10811: value: '/tmp' kind: 4
 2010-01-21 14:31:56 DEBUG: pid 10811: key: pcp_timeout
 2010-01-21 14:31:56 DEBUG: pid 10811: value: 10 kind: 2
 2010-01-21 14:31:56 DEBUG: pid 10811: key: num_init_children
 2010-01-21 14:31:56 DEBUG: pid 10811: value: 100 kind: 2
 2010-01-21 14:31:56 DEBUG: pid 10811: key: max_pool
 2010-01-21 14:31:56 DEBUG: pid 10811: value: 1 kind: 2
 2010-01-21 14:31:56 DEBUG: pid 10811: key: child_life_time
 2010-01-21 14:31:56 DEBUG: pid 10811: value: 0 kind: 2
 2010-01-21 14:31:56 DEBUG: pid 10811: key: connection_life_time
 2010-01-21 14:31:56 DEBUG: pid 10811: value: 0 kind: 2
 2010-01-21 14:31:56 DEBUG: pid 10811: key: child_max_connections
 2010-01-21 14:31:56 DEBUG: pid 10811: value: 0 kind: 2
 2010-01-21 14:31:56 DEBUG: pid 10811: key: client_idle_limit
 2010-01-21 14:31:56 DEBUG: pid 10811: value: 0 kind: 2
 2010-01-21 14:31:56 DEBUG: pid 10811: key: authentication_timeout
 2010-01-21 14:31:56 DEBUG: pid 10811: value: 60 kind: 2
 2010-01-21 14:31:56 DEBUG: pid 10811: key: logdir
 2010-01-21 14:31:56 DEBUG: pid 10811: value: '/tmp' kind: 4
 2010-01-21 14:31:56 DEBUG: pid 10811: key: pid_file_name
 2010-01-21 14:31:56 DEBUG: pid 10811: value:
 '/var/run/pgpool/pgpool.pid' kind: 4
 2010-01-21 14:31:56 DEBUG: pid 10811: key: replication_mode
 2010-01-21 14:31:56 DEBUG: pid 10811: value: true kind: 1
 2010-01-21 14:31:56 DEBUG: pid 10811: key: load_balance_mode
 2010-01-21 14:31:56 DEBUG: pid 10811: value: true kind: 1
 2010-01-21 14:31:56 DEBUG: pid 10811: key: replication_stop_on_mismatch
 2010-01-21 14:31:56 DEBUG: pid 10811: value: true kind: 1
 2010-01-21 14:31:56 DEBUG: pid 10811: replication_stop_on_mismatch: 1
 2010-01-21 14:31:56 DEBUG: pid 10811: key: replicate_select
 2010-01-21 14:31:56 DEBUG: pid 10811: value: false kind: 1
 2010-01-21 14:31:56 DEBUG: pid 10811: replicate_select: 0
 2010-01-21 14:31:56 DEBUG: pid 10811: key: reset_query_list
 2010-01-21 14:31:56 DEBUG: pid 10811: value: 'ABORT; RESET ALL; SET
 SESSION AUTHORIZATION DEFAULT' kind: 4
 2010-01-21 14:31:56 DEBUG: pid 10811: extract_string_tokens: token:
 ABORT
 2010-01-21 14:31:56 DEBUG: pid 10811: extract_string_tokens: token:
 RESET ALL
 2010-01-21 14:31:56 DEBUG: pid 10811: extract_string_tokens: token:  SET
 SESSION AUTHORIZATION DEFAULT
 2010-01-21 14:31:56 DEBUG: pid 10811: key: print_timestamp
 2010-01-21 14:31:56 DEBUG: pid 10811: value: true kind: 1
 2010-01-21 14:31:56 DEBUG: pid 10811: key: master_slave_mode
 2010-01-21 14:31:56 DEBUG: pid 10811: value: false kind: 1
 2010-01-21 14:31:56 DEBUG: pid 10811: key: connection_cache
 2010-01-21 14:31:56 DEBUG: pid 10811: value: false kind: 1
 2010-01-21 14:31:56 DEBUG: pid 10811: key: health_check_timeout
 2010-01-21 14:31:56 DEBUG: pid 10811: value: 20 kind: 2
 2010-01-21 14:31:56 DEBUG: pid 10811: key: health_check_period
 2010-01-21 14:31:56 DEBUG: pid 10811: value: 5 kind: 2
 2010-01-21 14:31:56 DEBUG: pid 10811: key: health_check_user
 2010-01-21 14:31:56 DEBUG: pid 10811:

Re: [Pgpool-general] pgpool crashing(?) at startup

2010-01-21 Thread Daniel . Crespo 
Sorry, I missed one step in the series:

  The problem is as follows:
 
  1. pgpool is stopped
  2. App is started
 Every 0.01 secs, outputs:
 psql: could not connect to server: Connection refused
  Is the server running locally and accepting
  connections on Unix domain socket /tmp/.s.PGSQL.?
 
  4. pgpool tries starting (app is trying connecting every 0.01 secs)
  5. pgpool stop running.

1. pgpool is stopped
2. App is started
3. backend0 is up and backend1 is down (on purpose)
4. pgpool tries starting
5. pgpool stops. I still don't know if it is a crash or not, but it
exits.

I think it should still work with the only database available.

Daniel


 -Original Message-
 From: Xavier Noguer [mailto:xnog...@antica.cl]
 Sent: Thursday, January 21, 2010 4:24 PM
 To: Crespo, Daniel @ SDS
 Cc: pgpool-general@pgfoundry.org
 Subject: Re: [Pgpool-general] pgpool crashing(?) at startup
 
 
  Hi,
 
  2010-01-21 14:31:56 ERROR: pid 10881: connection to
  192.168.101.214(5432) failed
  2010-01-21 14:31:56 ERROR: pid 10881: new_connection: create_cp()
  failed
  2010-01-21 14:31:56 LOG:   pid 10881: notice_backend_error: 1 fail
  over
  request from pid 10881
 
  this seems to indicate the second backend is down or not configured
 properly. For the 0.1 secs test do you use the exact same backends ?
 
  5. pgpool stop running.
 
  Does it crash ? Do you have the last lines on the log before it stops
 ?
 
 
  Regards
 
 On Thu, 2010-01-21 at 14:57 -0500, daniel.cre...@l-3com.com wrote:
  Hi,
 
  I'm using pgpool 2.2.2 connecting to two backends PGSQL8.2.1. Below
 is a
  diagram of my configuration
 
  .--- backend0
 /
  App --- pgpool
 \
  `--- backend1
 
  Where App, for testing purposes is:
 
  while [ 1 ]; do psql -U postgres -p  -c select 1;; sleep 0.01;
  done
 
  The problem is as follows:
 
  1. pgpool is stopped
  2. App is started
 Every 0.01 secs, outputs:
 psql: could not connect to server: Connection refused
  Is the server running locally and accepting
  connections on Unix domain socket /tmp/.s.PGSQL.?
 
  4. pgpool tries starting (app is trying connecting every 0.01 secs)
  5. pgpool stop running.
 
  Below is the output of log of pgpool
 
  2010-01-21 14:31:56 DEBUG: pid 10811: key: listen_addresses
  2010-01-21 14:31:56 DEBUG: pid 10811: value: '*' kind: 4
  2010-01-21 14:31:56 DEBUG: pid 10811: key: port
  2010-01-21 14:31:56 DEBUG: pid 10811: value:  kind: 2
  2010-01-21 14:31:56 DEBUG: pid 10811: key: pcp_port
  2010-01-21 14:31:56 DEBUG: pid 10811: value: 9898 kind: 2
  2010-01-21 14:31:56 DEBUG: pid 10811: key: socket_dir
  2010-01-21 14:31:56 DEBUG: pid 10811: value: '/tmp' kind: 4
  2010-01-21 14:31:56 DEBUG: pid 10811: key: pcp_socket_dir
  2010-01-21 14:31:56 DEBUG: pid 10811: value: '/tmp' kind: 4
  2010-01-21 14:31:56 DEBUG: pid 10811: key: backend_socket_dir
  2010-01-21 14:31:56 DEBUG: pid 10811: value: '/tmp' kind: 4
  2010-01-21 14:31:56 DEBUG: pid 10811: key: pcp_timeout
  2010-01-21 14:31:56 DEBUG: pid 10811: value: 10 kind: 2
  2010-01-21 14:31:56 DEBUG: pid 10811: key: num_init_children
  2010-01-21 14:31:56 DEBUG: pid 10811: value: 100 kind: 2
  2010-01-21 14:31:56 DEBUG: pid 10811: key: max_pool
  2010-01-21 14:31:56 DEBUG: pid 10811: value: 1 kind: 2
  2010-01-21 14:31:56 DEBUG: pid 10811: key: child_life_time
  2010-01-21 14:31:56 DEBUG: pid 10811: value: 0 kind: 2
  2010-01-21 14:31:56 DEBUG: pid 10811: key: connection_life_time
  2010-01-21 14:31:56 DEBUG: pid 10811: value: 0 kind: 2
  2010-01-21 14:31:56 DEBUG: pid 10811: key: child_max_connections
  2010-01-21 14:31:56 DEBUG: pid 10811: value: 0 kind: 2
  2010-01-21 14:31:56 DEBUG: pid 10811: key: client_idle_limit
  2010-01-21 14:31:56 DEBUG: pid 10811: value: 0 kind: 2
  2010-01-21 14:31:56 DEBUG: pid 10811: key: authentication_timeout
  2010-01-21 14:31:56 DEBUG: pid 10811: value: 60 kind: 2
  2010-01-21 14:31:56 DEBUG: pid 10811: key: logdir
  2010-01-21 14:31:56 DEBUG: pid 10811: value: '/tmp' kind: 4
  2010-01-21 14:31:56 DEBUG: pid 10811: key: pid_file_name
  2010-01-21 14:31:56 DEBUG: pid 10811: value:
  '/var/run/pgpool/pgpool.pid' kind: 4
  2010-01-21 14:31:56 DEBUG: pid 10811: key: replication_mode
  2010-01-21 14:31:56 DEBUG: pid 10811: value: true kind: 1
  2010-01-21 14:31:56 DEBUG: pid 10811: key: load_balance_mode
  2010-01-21 14:31:56 DEBUG: pid 10811: value: true kind: 1
  2010-01-21 14:31:56 DEBUG: pid 10811: key:
 replication_stop_on_mismatch
  2010-01-21 14:31:56 DEBUG: pid 10811: value: true kind: 1
  2010-01-21 14:31:56 DEBUG: pid 10811: replication_stop_on_mismatch:
1
  2010-01-21 14:31:56 DEBUG: pid 10811: key: replicate_select
  2010-01-21 14:31:56 DEBUG: pid 10811: value: false kind: 1
  2010-01-21 14:31:56 DEBUG: pid 10811: replicate_select: 0
  2010-01-21 14:31:56 DEBUG: pid 10811: key: reset_query_list
  2010-01-21 14:31:56 DEBUG: pid 10811: value: 'ABORT; RESET