search

exasol / pyexasol

Exasol Python driver with low overhead, fast HTTP transport and compression
MIT License
71 stars 39 forks source link

Frequent SSL Error #59

Closed kamal-1 closed 3 years ago

kamal-1 commented 4 years ago

Version: 0.14.1

While executing multiple queries using 1 open connection, frequently it errors out with an SSL error. It happens on Select/Insert/Update/Merge queries.

File "/anaconda3/lib/python3.7/site-packages/pyexasol/connection.py", line 183, in execute return self.cls_statement(self, query, query_params) File "/anaconda3/lib/python3.7/site-packages/pyexasol/statement.py", line 55, in init self._execute() File "/anaconda3/lib/python3.7/site-packages/pyexasol/statement.py", line 159, in _execute 'sqlText': self.query, File "/anaconda3/lib/python3.7/site-packages/pyexasol/connection.py", line 539, in req recv_data = self._ws_recv() File "/anaconda3/lib/python3.7/site-packages/pyexasol/connection.py", line 629, in self._ws_recv = lambda: zlib.decompress(self._ws.recv()) File "/anaconda3/lib/python3.7/site-packages/websocket/_core.py", line 313, in recv opcode, data = self.recv_data() File "/anaconda3/lib/python3.7/site-packages/websocket/_core.py", line 330, in recv_data opcode, frame = self.recv_data_frame(control_frame) File "/anaconda3/lib/python3.7/site-packages/websocket/_core.py", line 343, in recv_data_frame frame = self.recv_frame() File "/anaconda3/lib/python3.7/site-packages/websocket/_core.py", line 377, in recv_frame return self.frame_buffer.recv_frame() File "/anaconda3/lib/python3.7/site-packages/websocket/_abnf.py", line 361, in recv_frame self.recv_header() File "/anaconda3/lib/python3.7/site-packages/websocket/_abnf.py", line 309, in recv_header header = self.recv_strict(2) File "/anaconda3/lib/python3.7/site-packages/websocket/_abnf.py", line 396, in recvstrict bytes = self.recv(min(16384, shortage)) File "/anaconda3/lib/python3.7/site-packages/websocket/_core.py", line 452, in _recv return recv(self.sock, bufsize) File "/anaconda3/lib/python3.7/site-packages/websocket/socket.py", line 102, in recv bytes = _recv() File "/anaconda3/lib/python3.7/site-packages/websocket/_socket.py", line 84, in _recv return sock.recv(bufsize) File "/anaconda3/lib/python3.7/ssl.py", line 1037, in recv return self.read(buflen) File "/anaconda3/lib/python3.7/ssl.py", line 913, in read return self._sslobj.read(len) ssl.SSLError: [SSL: DECRYPTION_FAILED_OR_BAD_RECORD_MAC] decryption failed or bad record mac (_ssl.c:2488)

littleK0i commented 4 years ago

I see you have compression=True and encryption=True at the same time.

It gives me the vibes of this error discovered previously: https://github.com/badoo/pyexasol/issues/53

What Exasol version do you have? Could you enable debug=True connection option and attach the full log?

Thank you!

kamal-1 commented 4 years ago

We are running Exasol version 6.2.9. I'll enable the debug option and share the logs.

littleK0i commented 3 years ago

@kamal-1 , is this problem still relevant?

Thank you.

kamal-1 commented 3 years ago

@kamal-1 , is this problem still relevant?

Thank you.

I apologize for not following up. We had some major changes. I’ll follow up on this today.

kamal-1 commented 3 years ago

@kamal-1 , is this problem still relevant? Thank you.

I apologize for not following up. We had some major changes. I’ll follow up on this today.

I see you have compression=True and encryption=True at the same time.

It gives me the vibes of this error discovered previously: #53

What Exasol version do you have? Could you enable debug=True connection option and attach the full log?

Thank you!

@wildraid - this issue can be closed. After upgrading Exasol to version 6.2.9 this is not happening any more.