Hi - I’m trying to install on AWS EKS with external Postgres and external Redis. Having issue with the install job not able to create the tables…although no error logs printed. Please see below logs.
Any idea please?
Installing Redash:
[2022-08-18 03:13:08,299][PID:64][DEBUG][redash.query_runner] Registering PostgreSQL (pg) query runner.
[2022-08-18 03:13:08,299][PID:64][DEBUG][redash.query_runner] Registering Redshift (redshift) query runner.
[2022-08-18 03:13:08,300][PID:64][DEBUG][redash.query_runner] Registering Redshift (with IAM User/Role) (redshift_iam) query runner.
[2022-08-18 03:13:08,300][PID:64][DEBUG][redash.query_runner] Registering CockroachDB (cockroach) query runner.
[2022-08-18 03:13:08,302][PID:64][DEBUG][redash.query_runner] Registering MySQL (mysql) query runner.
[2022-08-18 03:13:08,302][PID:64][DEBUG][redash.query_runner] Registering MySQL (Amazon RDS) (rds_mysql) query runner.
[2022-08-18 03:13:08,304][PID:64][DEBUG][redash.query_runner] Registering Druid (druid) query runner.
[2022-08-18 03:13:08,363][PID:64][DEBUG][passlib.utils.compat] loaded lazy attr ‘SafeConfigParser’: <class ‘configparser.ConfigParser’>
[2022-08-18 03:13:08,363][PID:64][DEBUG][passlib.utils.compat] loaded lazy attr ‘NativeStringIO’: <class ‘_io.StringIO’>
[2022-08-18 03:13:08,363][PID:64][DEBUG][passlib.utils.compat] loaded lazy attr ‘BytesIO’: <class ‘_io.BytesIO’>
[2022-08-18 03:13:08,787][PID:64][DEBUG][redash.query_runner] Registering Python (python) query runner.
[2022-08-18 03:13:08,788][PID:64][DEBUG][redash.destinations] Registering Email (email) destinations.
Tables created
Running Redash database migrations after install
[2022-08-18 03:13:10,214][PID:68][DEBUG][redash.query_runner] Registering PostgreSQL (pg) query runner.
[2022-08-18 03:13:10,214][PID:68][DEBUG][redash.query_runner] Registering Redshift (redshift) query runner.
[2022-08-18 03:13:10,214][PID:68][DEBUG][redash.query_runner] Registering Redshift (with IAM User/Role) (redshift_iam) query runner.
[2022-08-18 03:13:10,214][PID:68][DEBUG][redash.query_runner] Registering CockroachDB (cockroach) query runner.
[2022-08-18 03:13:10,217][PID:68][DEBUG][redash.query_runner] Registering MySQL (mysql) query runner.
[2022-08-18 03:13:10,217][PID:68][DEBUG][redash.query_runner] Registering MySQL (Amazon RDS) (rds_mysql) query runner.
[2022-08-18 03:13:10,218][PID:68][DEBUG][redash.query_runner] Registering Druid (druid) query runner.
[2022-08-18 03:13:10,281][PID:68][DEBUG][passlib.utils.compat] loaded lazy attr ‘SafeConfigParser’: <class ‘configparser.ConfigParser’>
[2022-08-18 03:13:10,281][PID:68][DEBUG][passlib.utils.compat] loaded lazy attr ‘NativeStringIO’: <class ‘_io.StringIO’>
[2022-08-18 03:13:10,281][PID:68][DEBUG][passlib.utils.compat] loaded lazy attr ‘BytesIO’: <class ‘_io.BytesIO’>
[2022-08-18 03:13:10,716][PID:68][DEBUG][redash.query_runner] Registering Python (python) query runner.
[2022-08-18 03:13:10,717][PID:68][DEBUG][redash.destinations] Registering Email (email) destinations.
[2022-08-18 03:13:11,198][PID:68][INFO][alembic.runtime.migration] Context impl PostgresqlImpl.
[2022-08-18 03:13:11,198][PID:68][INFO][alembic.runtime.migration] Will assume transactional DDL.
[2022-08-18 03:13:11,223][PID:68][INFO][alembic.runtime.migration] Running upgrade → 65fc9ede4746, Add is_draft status to queries and dashboards
Traceback (most recent call last):
File “/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py”, line 1249, in _execute_context
cursor, statement, parameters, context
File “/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py”, line 580, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.InFailedSqlTransaction: current transaction is aborted, commands ignored until end of transaction block
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File “/app/manage.py”, line 9, in
manager()
File “/usr/local/lib/python3.7/site-packages/click/core.py”, line 722, in call
return self.main(*args, **kwargs)
File “/usr/local/lib/python3.7/site-packages/flask/cli.py”, line 586, in main
return super(FlaskGroup, self).main(*args, **kwargs)
File “/usr/local/lib/python3.7/site-packages/click/core.py”, line 697, in main
rv = self.invoke(ctx)
File “/usr/local/lib/python3.7/site-packages/click/core.py”, line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/usr/local/lib/python3.7/site-packages/click/core.py”, line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/usr/local/lib/python3.7/site-packages/click/core.py”, line 895, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/usr/local/lib/python3.7/site-packages/click/core.py”, line 535, in invoke
return callback(*args, **kwargs)
File “/usr/local/lib/python3.7/site-packages/click/decorators.py”, line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File “/usr/local/lib/python3.7/site-packages/flask/cli.py”, line 426, in decorator
return __ctx.invoke(f, *args, **kwargs)
File “/usr/local/lib/python3.7/site-packages/click/core.py”, line 535, in invoke
return callback(*args, **kwargs)
File “/usr/local/lib/python3.7/site-packages/flask_migrate/cli.py”, line 134, in upgrade
_upgrade(directory, revision, sql, tag, x_arg)
File “/usr/local/lib/python3.7/site-packages/flask_migrate/init.py”, line 95, in wrapped
f(*args, **kwargs)
File “/usr/local/lib/python3.7/site-packages/flask_migrate/init.py”, line 280, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File “/usr/local/lib/python3.7/site-packages/alembic/command.py”, line 320, in upgrade
script.run_env()
File “/usr/local/lib/python3.7/site-packages/alembic/script/base.py”, line 563, in run_env
util.load_python_file(self.dir, “env.py”)
File “/usr/local/lib/python3.7/site-packages/alembic/util/pyfiles.py”, line 92, in load_python_file
module = load_module_py(module_id, path)
File “/usr/local/lib/python3.7/site-packages/alembic/util/pyfiles.py”, line 108, in load_module_py
spec.loader.exec_module(module) # type: ignore
File “”, line 728, in exec_module
File “”, line 219, in _call_with_frames_removed
File “migrations/env.py”, line 93, in
run_migrations_online()
File “migrations/env.py”, line 85, in run_migrations_online
context.run_migrations()
File “”, line 8, in run_migrations
File “/usr/local/lib/python3.7/site-packages/alembic/runtime/environment.py”, line 851, in run_migrations
self.get_context().run_migrations(**kw)
File “/usr/local/lib/python3.7/site-packages/alembic/runtime/migration.py”, line 619, in run_migrations
head_maintainer.update_to_step(step)
File “/usr/local/lib/python3.7/site-packages/alembic/runtime/migration.py”, line 808, in update_to_step
self._insert_version(vers)
File “/usr/local/lib/python3.7/site-packages/alembic/runtime/migration.py”, line 750, in _insert_version
version_num=literal_column(“‘%s’” % version)
File “/usr/local/lib/python3.7/site-packages/alembic/ddl/impl.py”, line 197, in _exec
return conn.execute(construct, multiparams)
File “/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py”, line 988, in execute
return meth(self, multiparams, params)
File “/usr/local/lib/python3.7/site-packages/sqlalchemy/sql/elements.py”, line 287, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File “/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py”, line 1107, in _execute_clauseelement
distilled_params,
File “/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py”, line 1253, in _execute_context
e, statement, parameters, cursor, context
File “/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py”, line 1473, in _handle_dbapi_exception
util.raise_from_cause(sqlalchemy_exception, exc_info)
File “/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py”, line 398, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File “/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py”, line 152, in reraise
raise value.with_traceback(tb)
File “/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py”, line 1249, in _execute_context
cursor, statement, parameters, context
File “/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py”, line 580, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.InternalError: (psycopg2.errors.InFailedSqlTransaction) current transaction is aborted, commands ignored until end of transaction block
[SQL: INSERT INTO alembic_version (version_num) VALUES (‘65fc9ede4746’) RETURNING alembic_version.version_num]
(Background on this error at: Error Messages — SQLAlchemy 1.4 Documentation)
Upgrade complete
Return code: 124