Redash with external postgres throwing Database does not appear to be installed | kubernetes & Helm

[Sameer1808]

Hi Team,

we are trying to setup redash using helm chart on kubernetes with external postgres, for the same we are passing the postgres endpoint as a kubernetes secret, below is the config :

externalPostgreSQL: $(connectionString) externalPostgreSQLSecret: name: redash-postgres ## (kubernetes secret name) key: connectionString

Even tried to pass the above config as it is without substituting the variable just connectionString, but no luck.

but the redash-release-upgrade pods keep on going into error state, with the error as below:

"Status: Traceback (most recent call last):

File "/app/manage.py", line 9, in
manager()
File "/usr/local/lib/python2.7/site-packages/click/core.py", line 716, in call
return self.main(*args, **kwargs)
File "/usr/local/lib/python2.7/site-packages/flask/cli.py", line 380, in main
return AppGroup.main(self, *args, **kwargs)
File "/usr/local/lib/python2.7/site-packages/click/core.py", line 696, in main
rv = self.invoke(ctx)
File "/usr/local/lib/python2.7/site-packages/click/core.py", line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/usr/local/lib/python2.7/site-packages/click/core.py", line 889, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/usr/local/lib/python2.7/site-packages/click/core.py", line 534, in invoke
return callback(*args, **kwargs)
File "/usr/local/lib/python2.7/site-packages/click/decorators.py", line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File "/usr/local/lib/python2.7/site-packages/flask/cli.py", line 257, in decorator
return __ctx.invoke(f, *args, **kwargs)
File "/usr/local/lib/python2.7/site-packages/click/core.py", line 534, in invoke
return callback(args, **kwargs)
File "/app/redash/cli/init.py", line 49, in status
print(simplejson.dumps(get_status(), indent=2))
File "/app/redash/monitor.py", line 63, in get_status
status.update(get_object_counts())
File "/app/redash/monitor.py", line 16, in get_object_counts
status['queries_count'] = Query.query.count()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 3230, in count
return self.from_self(col).scalar()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2983, in scalar
ret = self.one()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2954, in one
ret = self.one_or_none()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2924, in one_or_none
ret = list(self)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2995, in iter
return self._execute_and_instances(context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 3018, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 265, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 509, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) relation "queries" does not exist
LINE 3: FROM queries) AS anon_1
^
[SQL: 'SELECT count() AS count_1 \nFROM (SELECT queries.query AS queries_query, queries.updated_at AS queries_updated_at, queries.created_at AS queries_created_at, queries.id AS queries_id, queries.version AS queries_version, queries.org_id AS queries_org_id, queries.data_source_id AS queries_data_source_id, queries.latest_query_data_id AS queries_latest_query_data_id, queries.name AS queries_name, queries.description AS queries_description, queries.query_hash AS queries_query_hash, queries.api_key AS queries_api_key, queries.user_id AS queries_user_id, queries.last_modified_by_id AS queries_last_modified_by_id, queries.is_archived AS queries_is_archived, queries.is_draft AS queries_is_draft, queries.schedule AS queries_schedule, queries.schedule_failures AS queries_schedule_failures, queries.options AS queries_options, queries.search_vector AS queries_search_vector, queries.tags AS queries_tags \nFROM queries) AS anon_1'] (Background on this error at: http://sqlalche.me/e/f405)
Database does not appear to be installed.
Waiting 10 seconds before retrying.
Reached 5 attempts, giving up."

I logged into the redash-release-upgrade pod and checked the REDASH_DATABASE_URL env variable, which seems to be alright as per the docs i.e postgres://user:pass@host:5432/redash
Even checked the connectivity by deploying a postgres sample pod in the same subnet and tried connecting to my external Postgres which as well works fine.

Regards,
Sameer

[frivoire]

(old thread, but still open, so let's try to answer it)

I'm using today's helm chart (master branch) + the latest "preview" docker image (24.06-dev) with basically the following HR values:

externalPostgreSQL: postgresql://redash:$(POSTGRESQL_PASSWORD)@pg-redash/redash
externalRedis: redis://:$(REDASH_REDIS_PASSWORD)@redis-redash:6379/
envSecretName: redash
postgresql:
  enabled: false   # disable the integrated PG server
redis:
  enabled: false   # disable the integrated Redis server

And the redash secret looks like that:

kind: Secret
metadata:
  name: redash
data:
  POSTGRESQL_PASSWORD: mySecretPassword
  REDASH_REDIS_PASSWORD: my2ndSecretPassword
  ...

And it works fine with my external postgresql (a cloudsql on GCP) 😃

So, I'm not putting the whole connection-string in the secret as you, but only the password.
Maybe it explains the issue ?

Also, when comparing with your config, I see a subtle difference in syntax:

• you: postgres://
• mine: postgresql://

I don't know if really relevant, but maybe also something to try 🤷