Re: [Postgres-xc-general] Interday Degradation

[鈴木 幸市 <ko...@in...>]

If you have similar problem, please raise log_min_messages to DEBUG1 or higher.   This may give some more info of the problem.

Thank you;
---
Koichi Suzuki

2014/05/29 2:29、Aaron Jackson <aja...@re...> のメール：

> I'm using 1.2.1 with gcc 4.7 on Amazon i3 instances.  I'm actually becoming somewhat suspect of the i3 platform running this specific version of ubuntu.  So, I've recompiled the entire database using the intel compilers and I'm going to see if I see the same behavioral problems I've seen in the last month and a half.
> 
> I will let you know.
> 
> ________________________________________
> From: Koichi Suzuki [koi...@gm...]
> Sent: Saturday, May 24, 2014 11:09 AM
> To: Aaron Jackson
> Cc: pos...@li...
> Subject: Re: [Postgres-xc-general] Interday Degradation
> 
> Sorry for the late response.
> 
> What version are you using?   1.2.1 includes several fix for GTM connectivity.
> ---
> Koichi Suzuki
> 
> 
> 2014-05-22 12:28 GMT-04:00 Aaron Jackson <aja...@re...>:
>> Given my past experience with compiler issues, I'm a little hesitant to even
>> report this.  That said, I have a three node cluster, each with a
>> coordinator, data node and gtm proxy.  I have a standalone gtm instance
>> without a slave.  Often, when I come in after the servers have been up for a
>> while, I'm greeted with a variety of issues.
>> 
>> There are several warnings in the coordinator and data node logs, that read
>> "Do not have a GTM snapshot available" - I've discarded these as mostly
>> benign for the moment.
>> 
>> The coordinator is much worse..
>> 
>> 30770 | 2014-05-22 15:53:06 UTC | ERROR:  current transaction is aborted,
>> commands ignored until end of transaction block
>> 30770 | 2014-05-22 15:53:06 UTC | STATEMENT:  DISCARD ALL
>> 4560 | 2014-05-22 15:54:30 UTC | LOG:  failed to connect to Datanode
>> 4560 | 2014-05-22 15:54:30 UTC | LOG:  failed to connect to Datanode
>> 4560 | 2014-05-22 15:54:30 UTC | WARNING:  can not connect to node 16390
>> 30808 | 2014-05-22 15:54:30 UTC | LOG:  failed to acquire connections
>> 
>> 
>> Usually, I reset the coordinator and datanode and the world is happy again.
>> However, it makes me somewhat concerned that I'm seeing these kinds of
>> failures on a daily basis.  I wouldn't rule out the compiler again as it's
>> been the reason for previous failures, but has anyone else seen anything
>> like this??
>> 
>> Aaron
>> 
>> ------------------------------------------------------------------------------
>> "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
>> Instantly run your Selenium tests across 300+ browser/OS combos.
>> Get unparalleled scalability from the best Selenium testing platform
>> available
>> Simple to use. Nothing to install. Get started now for free."
>> http://p.sf.net/sfu/SauceLabs
>> _______________________________________________
>> Postgres-xc-general mailing list
>> Pos...@li...
>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>> 
> 
> ------------------------------------------------------------------------------
> Time is money. Stop wasting it! Get your web API in 5 minutes.
> www.restlet.com/download
> http://p.sf.net/sfu/restlet
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>