search

verdict-project / verdict

Interactive-Speed Analytics: 200x Faster, 200x Fewer Cluster Resources, Approximate Query Processing
http://verdictdb.org
Apache License 2.0
248 stars 66 forks source link

[Amazon](600000) Error setting/closing connection: General SSLEngine problem. #376

Closed solangepaz closed 5 years ago

solangepaz commented 5 years ago

When I'm trying to use pyverdict with PostgreSQL I get this error:

py4j.protocol.Py4JJavaError: An error occurred while calling z:org.verdictdb.VerdictContext.fromConnectionString.
: org.verdictdb.exception.VerdictDBDbmsException: [Amazon](600000) Error setting/closing connection: General SSLEngine problem.
        at org.verdictdb.connection.ConcurrentJdbcConnection.<init>(ConcurrentJdbcConnection.java:72)
        at org.verdictdb.connection.ConcurrentJdbcConnection.create(ConcurrentJdbcConnection.java:86)
        at org.verdictdb.VerdictContext.fromConnectionString(VerdictContext.java:229)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:244)
        at py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:357)
        at py4j.Gateway.invoke(Gateway.java:282)
        at py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:132)
        at py4j.commands.CallCommand.execute(CallCommand.java:79)
        at py4j.GatewayConnection.run(GatewayConnection.java:238)
        at java.lang.Thread.run(Thread.java:748)
pyongjoo commented 5 years ago

For some reasons, Redshift's JDBC driver seems to be used instead (of postgres driver). I'll post further updates shortly.

pyongjoo commented 5 years ago

It should work now. Please update by pip install pyverdict --upgrade

>>> import pyverdict
>>> pyverdict.__version__
'0.1.3.2'
>>> verdict = pyverdict.postgres(host='127.0.0.1', port=5432, dbname='postgres', user='postgres')
>>> verdict.sql('show schemas')
9 row(s) in the result (0.404 seconds)
                                       schema
0                               verdictdbmeta
1                               verdictdbtemp
2  pyverdict_postgres_datatype_test_schema464
3                          information_schema
4                                      public
5                                  pg_catalog
6                             pg_toast_temp_1
7                                   pg_temp_1
8                                    pg_toast
>>>
pyongjoo commented 5 years ago

Let me close this issue, but please feel free to reopen this if you still experience the same (or closely related) problems.

santfirax commented 5 years ago

Hello, I am having this issue, I can not connect to my instance. [HY000][600000] Amazon Error setting/closing connection: General SSLEngine problem.

pyongjoo commented 5 years ago

Let me get back to this in a couple of days. I’m flying back to the US today.

Yongjoo

On Mon, Jul 22, 2019 at 11:05 AM santfirax notifications@github.com wrote:

Hello, I am having this issue, I can not connect to my instance. [HY000][600000] Amazon http://600000 Error setting/closing connection: General SSLEngine problem.

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub https://github.com/mozafari/verdictdb/issues/376?email_source=notifications&email_token=AAKBQCQAQYEYO23DBBN6IF3QAUITBA5CNFSM4HSHOUM2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD2OR3UI#issuecomment-513613265, or mute the thread https://github.com/notifications/unsubscribe-auth/AAKBQCQNRHEM42XAKQJBJOLQAUITBANCNFSM4HSHOUMQ .

-- Yongjoo Park, Ph.D. Research Fellow Computer Science and Engineering University of Michigan 2260 Hayward St. Ann Arbor, MI 48109-2121 Office: 4957 Beyster Phone: (734) 707-9206 Website: yongjoopark.com