[erlang-questions] erlang pg client and redshift

[Dmitry Kolesnikov]

Hello,

Yes, you are right that major issue is termination of SSL connection.
Unfortunately, R16B03 did not help anyhow. I’ve tried this on multiple platform (Linux, OS X) and used various ciphers.  

This happens on very long query that takes about 5 min to evaluate.

=ERROR REPORT==== 20-Jan-2014::22:07:09 ===
** Generic server <0.75.0> terminating 
** Last message in was {ssl_closed,
                           {sslsocket,
                               {gen_tcp,#Port<0.6578>,tls_connection},
                               <0.79.0>}}
** When Server state == {state,<0.74.0>,ssl,
                            {sslsocket,
                                {gen_tcp,#Port<0.6578>,tls_connection},
                                <0.79.0>},
                            <<>>}
** Reason for termination == 
** sock_closed

=ERROR REPORT==== 20-Jan-2014::22:07:09 ===
** State machine <0.74.0> terminating 
** Last message in was {'EXIT',<0.75.0>,sock_closed}
** When State == querying
**      Data  == {state,undefined,<0.75.0>,3600000,
                        [{<<"client_encoding">>,<<"UNICODE">>},
                         {<<"datestyle">>,<<"ISO, MDY">>},
                         {<<"gconf_case_sensitive">>,<<"on">>},
                         {<<"integer_datetimes">>,<<"on">>},
                         {<<"is_superuser">>,<<"on">>},
                         {<<"server_encoding">>,<<"UNICODE">>},
                         {<<"server_version">>,<<"8.0.2">>},
                         {<<"session_authorization">>,<<"sa">>},
                         {<<"TimeZone">>,<<"UTC">>},
                         {<<"timezone_abbreviations">>,<<"Default">>},
                         {<<"padb_version">>,<<".">>},
                         {<<"padb_revision">>,<<>>},
                         {<<"max_numeric_precision">>,<<"38">>},
                         {<<"max_varchar_size">>,<<"65535">>}],
                        undefined,
                        {<0.38.0>,#Ref<0.0.0.241>},
                        undefined,
                        {3453,1382948247},
                        {statement,[],
                                   [...],
                                   [int4,int4]},
                        73}
** Reason for termination = 
** sock_closed
** exception exit: sock_closed


On 17 Jan 2014, at 23:31, Florian Waas <flw@REDACTED> wrote:

> If you're running R161 or older you will hit OTP-11228 which terminates your SSL connection during renegotiations. Got nothing to do with the client you're using. Fixed in R16B2.
> 
> HTH,
> -fl.
> 
> 
> On Fri, Jan 17, 2014 at 5:15 AM, Dmitry Kolesnikov <dmkolesnikov@REDACTED> wrote:
> Hello,
> 
> Does any one successfully used AWS RedShift from Erlang.
> It uses postgres as an interface. I've been trying to use following Erlang libraries:
> 
> https://github.com/wg/epgsql
> https://github.com/semiocast/pgsql
> 
> None of them works reliably. The SSL connection is terminated while query runs.
> However, native sql works fine.
> 
> - Dmitry
> 
> 
> _______________________________________________
> erlang-questions mailing list
> erlang-questions@REDACTED
> http://erlang.org/mailman/listinfo/erlang-questions
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://erlang.org/pipermail/erlang-questions/attachments/20140120/09216b9a/attachment.htm>