<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>