<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">Hello,<div><br></div><div>Yes, you are right that major issue is termination of SSL connection.</div><div>Unfortunately, R16B03 did not help anyhow. Iíve tried this on multiple platform (Linux, OS X) and used various ciphers.  </div><div><br></div><div>This happens on very long query that takes about 5 min to evaluate.</div><div><br></div><div>=ERROR REPORT==== 20-Jan-2014::22:07:09 ===<br>** Generic server <0.75.0> terminating <br>** Last message in was {ssl_closed,<br>                           {sslsocket,<br>                               {gen_tcp,#Port<0.6578>,tls_connection},<br>                               <0.79.0>}}<br>** When Server state == {state,<0.74.0>,ssl,<br>                            {sslsocket,<br>                                {gen_tcp,#Port<0.6578>,tls_connection},<br>                                <0.79.0>},<br>                            <<>>}<br>** Reason for termination == <br>** sock_closed<br><br>=ERROR REPORT==== 20-Jan-2014::22:07:09 ===<br>** State machine <0.74.0> terminating <br>** Last message in was {'EXIT',<0.75.0>,sock_closed}<br>** When State == querying<br>**      Data  == {state,undefined,<0.75.0>,3600000,<br>                        [{<<"client_encoding">>,<<"UNICODE">>},<br>                         {<<"datestyle">>,<<"ISO, MDY">>},<br>                         {<<"gconf_case_sensitive">>,<<"on">>},<br>                         {<<"integer_datetimes">>,<<"on">>},<br>                         {<<"is_superuser">>,<<"on">>},<br>                         {<<"server_encoding">>,<<"UNICODE">>},<br>                         {<<"server_version">>,<<"8.0.2">>},<br>                         {<<"session_authorization">>,<<"sa">>},<br>                         {<<"TimeZone">>,<<"UTC">>},<br>                         {<<"timezone_abbreviations">>,<<"Default">>},<br>                         {<<"padb_version">>,<<".">>},<br>                         {<<"padb_revision">>,<<>>},<br>                         {<<"max_numeric_precision">>,<<"38">>},<br>                         {<<"max_varchar_size">>,<<"65535">>}],<br>                        undefined,<br>                        {<0.38.0>,#Ref<0.0.0.241>},<br>                        undefined,<br>                        {3453,1382948247},<br>                        {statement,[],<br>                                   [...],<br>                                   [int4,int4]},<br>                        73}<br>** Reason for termination = <br>** sock_closed<br>** exception exit: sock_closed</div><div><br></div><div><br><div><div>On 17 Jan 2014, at 23:31, Florian Waas <<a href="mailto:flw@mx4.org">flw@mx4.org</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div dir="ltr">If you're running R161 or older you will hit <span style="white-space: pre-wrap;">OTP-11228 </span>which terminates your SSL connection during renegotiations. Got nothing to do with the client you're using. Fixed in R16B2.<div>
<br></div><div>HTH,</div><div>-fl.</div><div><br><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Jan 17, 2014 at 5:15 AM, Dmitry Kolesnikov <span dir="ltr"><<a href="mailto:dmkolesnikov@gmail.com" target="_blank">dmkolesnikov@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello,<br>
<br>
Does any one successfully used AWS RedShift from Erlang.<br>
It uses postgres as an interface. I've been trying to use following Erlang libraries:<br>
<br>
<a href="https://github.com/wg/epgsql" target="_blank">https://github.com/wg/epgsql</a><br>
<a href="https://github.com/semiocast/pgsql" target="_blank">https://github.com/semiocast/pgsql</a><br>
<br>
None of them works reliably. The SSL connection is terminated while query runs.<br>
However, native sql works fine.<br>
<br>
- Dmitry<br>
<br>
<br>
_______________________________________________<br>
erlang-questions mailing list<br>
<a href="mailto:erlang-questions@erlang.org">erlang-questions@erlang.org</a><br>
<a href="http://erlang.org/mailman/listinfo/erlang-questions" target="_blank">http://erlang.org/mailman/listinfo/erlang-questions</a><br>
</blockquote></div><br></div></div></div>
</blockquote></div><br></div></body></html>