Not wanting to be impatient, but I'm very concerned about this
problem, since its impossible to predict when it will occur. Is there
additional information that I can provide to investigate this further?
thanks
On Tue, Nov 22, 2011 at 10:11 AM, Lonni J Friedman netll...@gmail.com wrote
On Wed, Nov 23, 2011 at 10:42 PM, Tatsuo Ishii is...@sraoss.co.jp wrote:
Not wanting to be impatient, but I'm very concerned about this
problem, since its impossible to predict when it will occur. Is there
additional information that I can provide to investigate this further?
I really need
,
argv=value optimized out)
at main.c:549
(gdb) cont
Continuing.
On Tue, Sep 20, 2011 at 9:25 AM, Lonni J Friedman netll...@gmail.com wrote:
Nevermind, I figured out what I was doing wrong. Now I just need for
this to hang again.
On Tue, Sep 20, 2011 at 9:08 AM, Lonni J Friedman netll
Thanks for your reply. No, I do not regularly schedule any vacuum
cronjobs, as I was led to believe that this was no longer necessary
from past discussions on this and other mailing lists. I had been
running vacuum full as frequently as twice/month earlier this year,
but it was basically making
*sigh* I thought that I did, but clearly I did not. Sorry about the noise.
On Tue, Nov 22, 2011 at 6:16 PM, Tatsuo Ishii is...@sraoss.co.jp wrote:
I think you'd better post to pgsql-general since your question is
nothing related to pgpool.
___
On Sun, Nov 20, 2011 at 4:27 AM, Tatsuo Ishii is...@sraoss.co.jp wrote:
By enabling log_connections you have your client IP and pgpool child
pid in your log. Since the log for unable parse... includes pgpool
child pid, you can get client IP by checking pgpool child pid.
LOG: pid 4327:
On Fri, Sep 23, 2011 at 4:24 PM, Tatsuo Ishii is...@sraoss.co.jp wrote:
No. Just try:
$ psql -h cuda-db0 -U postgres -d postgres -c select pgpool_walrecrunning();
If it succeeds, you are done.
Returned true. thanks for your help!
___
Greetings,
I'm running pgpool-II-3.0.4 on a Linux-x86_64 server, which is load
balancing for a cluster of 3 PostgreSQL-9.0.4 servers (1 master, 2
standby). I'm using pgpool for load balancing only (not managing
streaming replication or failover). Last night, pgpool started
segfaulting
:40
pgpool: lfriedman nightly 10.31.96.84(61698) idle
I'd really appreciate some input on how to debug this.
On Fri, Sep 9, 2011 at 8:11 AM, Lonni J Friedman netll...@gmail.com
wrote:
No one else has experienced this or has suggestions how to debug it?
On Wed, Sep 7, 2011 at 12:49 PM
pgpool
postgres 29191 3.4 0.1 80192 14728 ? R Sep13 51:40
pgpool: lfriedman nightly 10.31.96.84(61698) idle
I'd really appreciate some input on how to debug this.
On Fri, Sep 9, 2011 at 8:11 AM, Lonni J Friedman netll...@gmail.com wrote:
No one else has experienced this or has
On Thu, Sep 15, 2011 at 8:57 AM, Johnny Tan johnnyd...@gmail.com wrote:
On Wed, Sep 14, 2011 at 9:12 PM, Lonni J Friedman netll...@gmail.com wrote:
On Wed, Sep 14, 2011 at 6:00 PM, Tatsuo Ishii is...@sraoss.co.jp wrote:
On Wed, Sep 14, 2011 at 4:22 PM, Tatsuo Ishii is...@sraoss.co.jp wrote
really appreciate some input on how to debug this.
On Fri, Sep 9, 2011 at 8:11 AM, Lonni J Friedman netll...@gmail.com wrote:
No one else has experienced this or has suggestions how to debug it?
On Wed, Sep 7, 2011 at 12:49 PM, Lonni J Friedman netll...@gmail.com wrote:
Greetings,
I'm running
postgres 20 0 80192 14m 1544 R 89.8 0.2 51:15.91 pgpool
postgres 29191 3.4 0.1 80192 14728 ? R Sep13 51:40
pgpool: lfriedman nightly 10.31.96.84(61698) idle
I'd really appreciate some input on how to debug this.
On Fri, Sep 9, 2011 at 8:11 AM, Lonni J Friedman netll
On Wed, Sep 14, 2011 at 6:00 PM, Tatsuo Ishii is...@sraoss.co.jp wrote:
On Wed, Sep 14, 2011 at 4:22 PM, Tatsuo Ishii is...@sraoss.co.jp wrote:
I'm pretty sure that's not the case as the messages stop whenever
pgpool isn't running, they were not present prior to using pgpool, and
pg_hba.conf
On Mon, Sep 12, 2011 at 6:47 PM, Lonni J Friedman netll...@gmail.com wrote:
On Mon, Sep 12, 2011 at 6:39 PM, Tatsuo Ishii is...@sraoss.co.jp wrote:
I couldn't find anything possibly related to your problem at a first
grance(in theory client_idle_limit and authentication_timeout are not
related
On Mon, Sep 12, 2011 at 3:34 AM, Toshihiro Kitagawa
kitag...@sraoss.co.jp wrote:
Hi,
However, I'm see tons (dozens every minute) of the
following in my postgresql server logs:
LOG: unexpected EOF on client connection
I found recently that it occurs if you specify the role that needs a
Of Lonni J Friedman
Sent: Monday, September 12, 2011 1:14 PM
To: pgpool-general@pgfoundry.org
Subject: [Pgpool-general] pgpool thinks a backend is down even though
its not
Greetings,
I've got a 3 node postgresql-9.0.4 cluster (1 master, two standby, all
running on Linux-x86_64. I had
On Mon, Sep 12, 2011 at 5:14 PM, Tatsuo Ishii is...@sraoss.co.jp wrote:
On Mon, Sep 12, 2011 at 4:16 PM, Tatsuo Ishii is...@sraoss.co.jp wrote:
Yes, all connections defined in pool_hba.conf are trust auth.
However, I also have
health_check_period = 0
in pgpool.conf, so I'd assume that no
On Mon, Sep 12, 2011 at 6:39 PM, Tatsuo Ishii is...@sraoss.co.jp wrote:
I couldn't find anything possibly related to your problem at a first
grance(in theory client_idle_limit and authentication_timeout are not
related but you might want to change them to see anything could be
changed).
OK,
On Thu, Sep 8, 2011 at 5:30 AM, Toshihiro Kitagawa
kitag...@sraoss.co.jp wrote:
- Change the lock method of insert_lock. The previous insert_lock uses
row locking against the sequence relation, but the current one uses
row locking against pgpool_catalog.insert_lock table. The reason is
that
No one has any ideas or suggestions?
On Fri, Sep 2, 2011 at 6:44 PM, Lonni J Friedman netll...@gmail.com wrote:
Greetings,
I just deployed a postgresql-9.0.4 cluster (1 master, 2 hot
standby's), with pgpool-II-3.0.4 (all running on Linux-x86_64
servers). I'm currently only using pgpool
, and that you can connect from the server running
pgpool.
On Sep 4, 2011 7:22 PM, Lonni J Friedman netll...@gmail.com wrote:
No one has any ideas or suggestions?
On Fri, Sep 2, 2011 at 6:44 PM, Lonni J Friedman netll...@gmail.com
wrote:
Greetings,
I just deployed a postgresql-9.0.4 cluster (1 master
Greetings,
I just deployed a postgresql-9.0.4 cluster (1 master, 2 hot
standby's), with pgpool-II-3.0.4 (all running on Linux-x86_64
servers). I'm currently only using pgpool for load balancing, and its
working fine. However, I'm see tons (dozens every minute) of the
following in my postgresql
23 matches
Mail list logo