Good day! We want to use redash in our infra and have some issues while explotation 8.0.2 latest image of redash
We using official redash helm chart for deploy redash service in 2 different data centers and their connected to external postgres cluster and redis+sentinel
We fix some issues with pool_pre_ping with postgres instead of redis issues:
[2021-04-27 12:56:49,717] ERROR in app: Exception on /static/app.a0595254bc5893ba54aa.js [GET]
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1982, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1614, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask_restful/__init__.py", line 271, in error_router
return original_handler(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1517, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1609, in full_dispatch_request
request_started.send(self)
File "/usr/local/lib/python2.7/site-packages/blinker/base.py", line 267, in send
for receiver in self.receivers_for(sender)]
File "/app/redash/models/users.py", line 55, in update_user_active_at
redis_connection.hset(LAST_ACTIVE_KEY, current_user.id, int(time.time()))
File "/usr/local/lib/python2.7/site-packages/redis/client.py", line 2674, in hset
return self.execute_command('HSET', name, key, value)
File "/usr/local/lib/python2.7/site-packages/redis/client.py", line 775, in execute_command
return self.parse_response(connection, command_name, **options)
File "/usr/local/lib/python2.7/site-packages/redis/client.py", line 789, in parse_response
response = connection.read_response()
File "/usr/local/lib/python2.7/site-packages/redis/connection.py", line 637, in read_response
response = self._parser.read_response()
File "/usr/local/lib/python2.7/site-packages/redis/connection.py", line 290, in read_response
response = self._buffer.readline()
File "/usr/local/lib/python2.7/site-packages/redis/connection.py", line 224, in readline
self._read_from_socket()
File "/usr/local/lib/python2.7/site-packages/redis/connection.py", line 199, in _read_from_socket
(e.args,))
ConnectionError: Error while reading from socket: (104, 'Connection reset by peer')
Redash connects to redis through haproxy which does some healthchecks who is master and proxies connects to master
After some amount of time, we have these issues. Its belongs only for update_user_active_at method.
I didnt find any redash environment variables for redis connections (timeout, pool and etc)