docker-compose build error " sqlalchemy.exc.OperationalError: (psycopg2.errors.DeadlockDetected) deadlock detected" #28191
Unanswered
morttrager
asked this question in
Q&A / Help
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I have cloned the superset repo and build a base image without any changes using docker build . -t superset:base.
The used my superset:base image in docker-compose.yaml file. I am using my own postgresql and given the details in docker/.env file. When I run docker-compose up I am getting the below error in superset_init and worker.
superset_init | INFO [alembic.runtime.migration] Running upgrade 90139bf715e4 -> 6fbe660cac39, add on delete cascade for tables references
superset_init | INFO [alembic.runtime.migration] Running upgrade 6fbe660cac39 -> 8e5b0fb85b9a, Add custom size columns to report schedule
superset_init | INFO [alembic.runtime.migration] Running upgrade 8e5b0fb85b9a -> 240d23c7f86f, update_tag_model_w_description
superset_init | INFO [alembic.runtime.migration] Running upgrade 240d23c7f86f -> f92a3124dd66, drop rouge constraints and tables
superset_init | INFO [alembic.runtime.migration] Running upgrade f92a3124dd66 -> 6d05b0a70c89, add on delete cascade for owners references
superset_init | INFO [alembic.runtime.migration] Running upgrade 6d05b0a70c89 -> 863adcf72773, delete obsolete Druid NoSQL slice parameters
superset_init | INFO [alembic.runtime.migration] Running upgrade 863adcf72773 -> a23c6f8b1280, cleanup erroneous parent filter IDs
superset_init | INFO [alembic.runtime.migration] Running upgrade a23c6f8b1280 -> bf646a0c1501, json_metadata
superset_init | INFO [alembic.runtime.migration] Running upgrade bf646a0c1501 -> e0f6f91c2055, create_user_favorite_table
superset_init | INFO [alembic.runtime.migration] Running upgrade e0f6f91c2055 -> ee179a490af9, deckgl-path-width-units
superset_init | INFO [alembic.runtime.migration] Running upgrade ee179a490af9 -> 0769ef90fddd, Fix schema perm for datasets
superset_init | INFO [alembic.runtime.migration] Running upgrade 0769ef90fddd -> 2e826adca42c, Fix schema for log
superset_init | INFO [alembic.runtime.migration] Running upgrade 2e826adca42c -> 8ace289026f3, add on delete cascade for dashboard_slices
superset_init | INFO [alembic.runtime.migration] Running upgrade 8ace289026f3 -> 4448fa6deeb1, add on delete cascade for embedded_dashboards
superset_init | INFO [alembic.runtime.migration] Running upgrade 4448fa6deeb1 -> 9f4a086c2676, add_normalize_columns_to_sqla_model
superset_init | INFO [alembic.runtime.migration] Running upgrade 9f4a086c2676 -> ec54aca4c8a2, Increase ab_user.email field size
superset_init | INFO [alembic.runtime.migration] Running upgrade ec54aca4c8a2 -> 317970b4400c, Added always_filter_main_dttm to datasource
superset_init | INFO [alembic.runtime.migration] Running upgrade 317970b4400c -> 4b85906e5b91, add on delete cascade for dashboard_roles
superset_init | Loaded your LOCAL configuration at [/app/docker/pythonpath_dev/superset_config.py]
superset_init |
Cleaning up slice uuid from dashboard position json.. Done. position json..
superset_init |
superset_init | Updated 0 pie chart labels.
superset_init | 0 slices altered
superset_init |
Cleaning up slice uuid from dashboard position json.. Done. position json..
superset_init |
superset_init | Updated 0 native filter configurations.
superset_init | Updated 0 filter sets with 0 filters.
superset_init | Upgraded 0 filters and 0 filter sets.
superset_init | Upgraded 0 slices.
superset_init | slices updated with no time_range_endpoints: 0
superset_init | >> Assign new UUIDs to tables...
superset_init | >> Drop intermediate columns...
superset_init | Traceback (most recent call last):
superset_init | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
superset_init | self.dialect.do_execute(
superset_init | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
superset_init | cursor.execute(statement, parameters)
superset_init | psycopg2.errors.DeadlockDetected: deadlock detected
superset_init | DETAIL: Process 16497 waits for AccessExclusiveLock on relation 6073086 of database 6073068; blocked by process 16530.
superset_init | Process 16530 waits for AccessShareLock on relation 6073094 of database 6073068; blocked by process 16497.
superset_init | HINT: See server log for query details.
superset_init |
superset_init |
superset_init | The above exception was the direct cause of the following exception:
superset_init |
superset_init | Traceback (most recent call last):
superset_init | File "/usr/local/bin/superset", line 8, in
superset_init | sys.exit(superset())
superset_init | File "/usr/local/lib/python3.10/site-packages/click/core.py", line 1157, in call
superset_init | return self.main(*args, **kwargs)
superset_init | File "/usr/local/lib/python3.10/site-packages/click/core.py", line 1078, in main
superset_init | rv = self.invoke(ctx)
superset_init | File "/usr/local/lib/python3.10/site-packages/click/core.py", line 1688, in invoke
superset_init | return _process_result(sub_ctx.command.invoke(sub_ctx))
superset_init | File "/usr/local/lib/python3.10/site-packages/click/core.py", line 1688, in invoke
superset_init | return _process_result(sub_ctx.command.invoke(sub_ctx))
superset_init | File "/usr/local/lib/python3.10/site-packages/click/core.py", line 1434, in invoke
superset_init | return ctx.invoke(self.callback, **ctx.params)
superset_init | File "/usr/local/lib/python3.10/site-packages/click/core.py", line 783, in invoke
superset_init | return __callback(*args, **kwargs)
superset_init | File "/usr/local/lib/python3.10/site-packages/click/decorators.py", line 33, in new_func
superset_init | return f(get_current_context(), *args, **kwargs)
superset_init | File "/usr/local/lib/python3.10/site-packages/flask/cli.py", line 358, in decorator
superset_init | return __ctx.invoke(f, *args, **kwargs)
superset_init | File "/usr/local/lib/python3.10/site-packages/click/core.py", line 783, in invoke
superset_init | return __callback(*args, **kwargs)
superset_init | File "/usr/local/lib/python3.10/site-packages/flask_migrate/cli.py", line 149, in upgrade
superset_init | _upgrade(directory, revision, sql, tag, x_arg)
superset_init | File "/usr/local/lib/python3.10/site-packages/flask_migrate/init.py", line 98, in wrapped
superset_init | f(*args, **kwargs)
superset_init | File "/usr/local/lib/python3.10/site-packages/flask_migrate/init.py", line 185, in upgrade
superset_init | command.upgrade(config, revision, sql=sql, tag=tag)
superset_init | File "/usr/local/lib/python3.10/site-packages/alembic/command.py", line 403, in upgrade
superset_init | script.run_env()
superset_init | File "/usr/local/lib/python3.10/site-packages/alembic/script/base.py", line 583, in run_env
superset_init | util.load_python_file(self.dir, "env.py")
superset_init | File "/usr/local/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 95, in load_python_file
superset_init | module = load_module_py(module_id, path)
superset_init | File "/usr/local/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 113, in load_module_py
superset_init | spec.loader.exec_module(module) # type: ignore
superset_init | File "", line 883, in exec_module
superset_init | File "", line 241, in _call_with_frames_removed
superset_init | File "/app/superset/extensions/../migrations/env.py", line 127, in
superset_init | run_migrations_online()
superset_init | File "/app/superset/extensions/../migrations/env.py", line 119, in run_migrations_online
superset_init | context.run_migrations()
superset_init | File "", line 8, in run_migrations
superset_init | File "/usr/local/lib/python3.10/site-packages/alembic/runtime/environment.py", line 948, in run_migrations
superset_init | self.get_context().run_migrations(**kw)
superset_init | File "/usr/local/lib/python3.10/site-packages/alembic/runtime/migration.py", line 627, in run_migrations
superset_init | step.migration_fn(**kw)
superset_init | File "/app/superset/migrations/versions/2023-09-15_12-58_4b85906e5b91_add_on_delete_cascade_for_dashboard_roles.py", line 50, in upgrade
superset_init | redefine(foreign_key, on_delete="CASCADE")
superset_init | File "/app/superset/migrations/shared/constraints.py", line 57, in redefine
superset_init | with op.batch_alter_table(foreign_key.table, naming_convention=conv) as batch_op:
superset_init | File "/usr/local/lib/python3.10/contextlib.py", line 142, in exit
superset_init | next(self.gen)
superset_init | File "/usr/local/lib/python3.10/site-packages/alembic/operations/base.py", line 398, in batch_alter_table
superset_init | impl.flush()
superset_init | File "/usr/local/lib/python3.10/site-packages/alembic/operations/batch.py", line 116, in flush
superset_init | fn(*arg, **kw)
superset_init | File "/usr/local/lib/python3.10/site-packages/alembic/ddl/impl.py", line 350, in drop_constraint
superset_init | self._exec(schema.DropConstraint(const))
superset_init | File "/usr/local/lib/python3.10/site-packages/alembic/ddl/impl.py", line 207, in _exec
superset_init | return conn.execute(construct, multiparams)
superset_init | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1385, in execute
superset_init | return meth(self, multiparams, params, _EMPTY_EXECUTION_OPTS)
superset_init | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/ddl.py", line 80, in _execute_on_connection
superset_init | return connection._execute_ddl(
superset_init | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1477, in _execute_ddl
superset_init | ret = self._execute_context(
superset_init | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1953, in _execute_context
superset_init | self.handle_dbapi_exception(
superset_init | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2134, in handle_dbapi_exception
superset_init | util.raise(
superset_init | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise
superset_init | raise exception
superset_init | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
superset_init | self.dialect.do_execute(
superset_init | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
superset_init | cursor.execute(statement, parameters)
superset_init | sqlalchemy.exc.OperationalError: (psycopg2.errors.DeadlockDetected) deadlock detected
superset_init | DETAIL: Process 16497 waits for AccessExclusiveLock on relation 6073086 of database 6073068; blocked by process 16530.
superset_init | Process 16530 waits for AccessShareLock on relation 6073094 of database 6073068; blocked by process 16497.
superset_init | HINT: See server log for query details.
superset_init |
superset_init | [SQL: ALTER TABLE dashboard_roles DROP CONSTRAINT dashboard_roles_role_id_fkey]
superset_init | (Background on this error at: https://sqlalche.me/e/14/e3q8)
superset_init exited with code 1
superset_app | 2024-04-24 09:03:07,432:WARNING:werkzeug: * Debugger is active!
superset_app | 2024-04-24 09:03:07,433:INFO:werkzeug: * Debugger PIN: 920-980-873
superset_node |
superset_node | added 119 packages in 25s
superset_node |
superset_node | 16 packages are looking for funding
superset_node | run
npm fund
for detailssuperset_node | npm notice
superset_node | npm notice New patch version of npm available! 10.5.0 -> 10.5.2
superset_node | npm notice Changelog: https://github.com/npm/cli/releases/tag/v10.5.2
superset_node | npm notice Run
npm install -g [email protected]
to update!superset_node | npm notice
superset_node | npm WARN config optional Use
--omit=optional
to exclude optional dependencies, orsuperset_node | npm WARN config
--include=optional
to include them.superset_node | npm WARN config
superset_node | npm WARN config Default value does install optional deps unless otherwise omitted.
superset_node | npm WARN using --force Recommended protections disabled.
superset_app | 2024-04-24 09:03:18,969:DEBUG:superset.stats_logger:[stats_logger] (incr) health
superset_app | 2024-04-24 09:03:18,970:INFO:werkzeug:127.0.0.1 - - [24/Apr/2024 09:03:18] "GET /health HTTP/1.1" 200 -
superset_app | 2024-04-24 09:03:49,121:DEBUG:superset.stats_logger:[stats_logger] (incr) health
superset_app | 2024-04-24 09:03:49,121:INFO:werkzeug:127.0.0.1 - - [24/Apr/2024 09:03:49] "GET /health HTTP/1.1" 200 -
superset_node | npm ERR! code ENOTEMPTY
superset_node | npm ERR! syscall rename
superset_node | npm ERR! path /app/superset-frontend/node_modules/deasync
superset_node | npm ERR! dest /app/superset-frontend/node_modules/.deasync-RIvnU4o5
superset_node | npm ERR! errno -39
superset_node | npm ERR! ENOTEMPTY: directory not empty, rename '/app/superset-frontend/node_modules/deasync' -> '/app/superset-frontend/node_modules/.deasync-RIvnU4o5'
superset_node |
superset_node | npm ERR! A complete log of this run can be found in: /root/.npm/_logs/2024-04-24T09_03_16_295Z-debug-0.log
superset_node exited with code 217
superset_worker_beat | [2024-04-24 09:04:00,047: INFO/MainProcess] Scheduler: Sending due task reports.scheduler (reports.scheduler)
superset_worker | [2024-04-24 09:04:00,051: INFO/MainProcess] Task reports.scheduler[1ebb6ab8-7950-43b7-bf3c-b9d2690e84cc] received
superset_worker | [2024-04-24 09:04:00,053: DEBUG/ForkPoolWorker-1] [stats_logger] (incr) reports.scheduler
superset_worker | [2024-04-24 09:04:00,064: ERROR/ForkPoolWorker-1] Task reports.scheduler[1ebb6ab8-7950-43b7-bf3c-b9d2690e84cc] raised unexpected: ProgrammingError('(psycopg2.errors.UndefinedTable) relation "report_schedule" does not exist\nLINE 2: FROM report_schedule \n ^\n')
superset_worker | Traceback (most recent call last):
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
superset_worker | self.dialect.do_execute(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
superset_worker | cursor.execute(statement, parameters)
superset_worker | psycopg2.errors.UndefinedTable: relation "report_schedule" does not exist
superset_worker | LINE 2: FROM report_schedule
superset_worker | ^
superset_worker |
superset_worker |
superset_worker | The above exception was the direct cause of the following exception:
superset_worker |
superset_worker | Traceback (most recent call last):
superset_worker | File "/usr/local/lib/python3.10/site-packages/celery/app/trace.py", line 477, in trace_task
superset_worker | R = retval = fun(*args, **kwargs)
superset_worker | File "/app/superset/initialization/init.py", line 110, in call
superset_worker | return task_base.call(self, *args, **kwargs)
superset_worker | File "/usr/local/lib/python3.10/site-packages/celery/app/trace.py", line 760, in protected_call
superset_worker | return self.run(*args, **kwargs)
superset_worker | File "/app/superset/tasks/scheduler.py", line 48, in scheduler
superset_worker | active_schedules = ReportScheduleDAO.find_active()
superset_worker | File "/app/superset/daos/report.py", line 213, in find_active
superset_worker | .all()
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2773, in all
superset_worker | return self._iter().all()
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2916, in _iter
superset_worker | result = self.session.execute(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1717, in execute
superset_worker | result = conn._execute_20(statement, params or {}, execution_options)
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1710, in _execute_20
superset_worker | return meth(self, args_10style, kwargs_10style, execution_options)
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 334, in _execute_on_connection
superset_worker | return connection._execute_clauseelement(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1577, in _execute_clauseelement
superset_worker | ret = self._execute_context(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1953, in _execute_context
superset_worker | self.handle_dbapi_exception(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2134, in handle_dbapi_exception
superset_worker | util.raise(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise
superset_worker | raise exception
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
superset_worker | self.dialect.do_execute(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
superset_worker | cursor.execute(statement, parameters)
superset_worker | sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "report_schedule" does not exist
superset_worker | LINE 2: FROM report_schedule
superset_worker | ^
superset_worker |
superset_worker | [SQL: SELECT report_schedule.created_on AS report_schedule_created_on, report_schedule.changed_on AS report_schedule_changed_on, report_schedule.extra_json AS report_schedule_extra_json, report_schedule.id AS report_schedule_id, report_schedule.type AS report_schedule_type, report_schedule.name AS report_schedule_name, report_schedule.description AS report_schedule_description, report_schedule.context_markdown AS report_schedule_context_markdown, report_schedule.active AS report_schedule_active, report_schedule.crontab AS report_schedule_crontab, report_schedule.creation_method AS report_schedule_creation_method, report_schedule.timezone AS report_schedule_timezone, report_schedule.report_format AS report_schedule_report_format, report_schedule.sql AS report_schedule_sql, report_schedule.chart_id AS report_schedule_chart_id, report_schedule.dashboard_id AS report_schedule_dashboard_id, report_schedule.database_id AS report_schedule_database_id, report_schedule.last_eval_dttm AS report_schedule_last_eval_dttm, report_schedule.last_state AS report_schedule_last_state, report_schedule.last_value AS report_schedule_last_value, report_schedule.last_value_row_json AS report_schedule_last_value_row_json, report_schedule.validator_type AS report_schedule_validator_type, report_schedule.validator_config_json AS report_schedule_validator_config_json, report_schedule.log_retention AS report_schedule_log_retention, report_schedule.grace_period AS report_schedule_grace_period, report_schedule.working_timeout AS report_schedule_working_timeout, report_schedule.force_screenshot AS report_schedule_force_screenshot, report_schedule.custom_width AS report_schedule_custom_width, report_schedule.custom_height AS report_schedule_custom_height, report_schedule.created_by_fk AS report_schedule_created_by_fk, report_schedule.changed_by_fk AS report_schedule_changed_by_fk
superset_worker | FROM report_schedule
superset_worker | WHERE report_schedule.active IS true]
superset_worker | (Background on this error at: https://sqlalche.me/e/14/f405)
superset_app | 2024-04-24 09:04:19,219:DEBUG:superset.stats_logger:[stats_logger] (incr) health
superset_app | 2024-04-24 09:04:19,219:INFO:werkzeug:127.0.0.1 - - [24/Apr/2024 09:04:19] "GET /health HTTP/1.1" 200 -
superset_app | 2024-04-24 09:04:49,304:DEBUG:superset.stats_logger:[stats_logger] (incr) health
superset_app | 2024-04-24 09:04:49,305:INFO:werkzeug:127.0.0.1 - - [24/Apr/2024 09:04:49] "GET /health HTTP/1.1" 200 -
superset_worker_beat | [2024-04-24 09:05:00,040: INFO/MainProcess] Scheduler: Sending due task reports.scheduler (reports.scheduler)
superset_worker | [2024-04-24 09:05:00,044: INFO/MainProcess] Task reports.scheduler[616bd268-c4b8-4b69-9bcd-737279ccc35a] received
superset_worker | [2024-04-24 09:05:00,045: DEBUG/ForkPoolWorker-1] [stats_logger] (incr) reports.scheduler
superset_worker | [2024-04-24 09:05:00,054: ERROR/ForkPoolWorker-1] Task reports.scheduler[616bd268-c4b8-4b69-9bcd-737279ccc35a] raised unexpected: ProgrammingError('(psycopg2.errors.UndefinedTable) relation "report_schedule" does not exist\nLINE 2: FROM report_schedule \n ^\n')
superset_worker | Traceback (most recent call last):
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
superset_worker | self.dialect.do_execute(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
superset_worker | cursor.execute(statement, parameters)
superset_worker | psycopg2.errors.UndefinedTable: relation "report_schedule" does not exist
superset_worker | LINE 2: FROM report_schedule
superset_worker | ^
superset_worker |
superset_worker |
superset_worker | The above exception was the direct cause of the following exception:
superset_worker |
superset_worker | Traceback (most recent call last):
superset_worker | File "/usr/local/lib/python3.10/site-packages/celery/app/trace.py", line 477, in trace_task
superset_worker | R = retval = fun(*args, **kwargs)
superset_worker | File "/app/superset/initialization/init.py", line 110, in call
superset_worker | return task_base.call(self, *args, **kwargs)
superset_worker | File "/usr/local/lib/python3.10/site-packages/celery/app/trace.py", line 760, in protected_call
superset_worker | return self.run(*args, **kwargs)
superset_worker | File "/app/superset/tasks/scheduler.py", line 48, in scheduler
superset_worker | active_schedules = ReportScheduleDAO.find_active()
superset_worker | File "/app/superset/daos/report.py", line 213, in find_active
superset_worker | .all()
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2773, in all
superset_worker | return self._iter().all()
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2916, in _iter
superset_worker | result = self.session.execute(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1717, in execute
superset_worker | result = conn._execute_20(statement, params or {}, execution_options)
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1710, in _execute_20
superset_worker | return meth(self, args_10style, kwargs_10style, execution_options)
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 334, in _execute_on_connection
superset_worker | return connection._execute_clauseelement(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1577, in _execute_clauseelement
superset_worker | ret = self._execute_context(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1953, in _execute_context
superset_worker | self.handle_dbapi_exception(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2134, in handle_dbapi_exception
superset_worker | util.raise(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise
superset_worker | raise exception
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
superset_worker | self.dialect.do_execute(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
superset_worker | cursor.execute(statement, parameters)
superset_worker | sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "report_schedule" does not exist
superset_worker | LINE 2: FROM report_schedule
superset_worker | ^
superset_worker |
superset_worker | [SQL: SELECT report_schedule.created_on AS report_schedule_created_on, report_schedule.changed_on AS report_schedule_changed_on, report_schedule.extra_json AS report_schedule_extra_json, report_schedule.id AS report_schedule_id, report_schedule.type AS report_schedule_type, report_schedule.name AS report_schedule_name, report_schedule.description AS report_schedule_description, report_schedule.context_markdown AS report_schedule_context_markdown, report_schedule.active AS report_schedule_active, report_schedule.crontab AS report_schedule_crontab, report_schedule.creation_method AS report_schedule_creation_method, report_schedule.timezone AS report_schedule_timezone, report_schedule.report_format AS report_schedule_report_format, report_schedule.sql AS report_schedule_sql, report_schedule.chart_id AS report_schedule_chart_id, report_schedule.dashboard_id AS report_schedule_dashboard_id, report_schedule.database_id AS report_schedule_database_id, report_schedule.last_eval_dttm AS report_schedule_last_eval_dttm, report_schedule.last_state AS report_schedule_last_state, report_schedule.last_value AS report_schedule_last_value, report_schedule.last_value_row_json AS report_schedule_last_value_row_json, report_schedule.validator_type AS report_schedule_validator_type, report_schedule.validator_config_json AS report_schedule_validator_config_json, report_schedule.log_retention AS report_schedule_log_retention, report_schedule.grace_period AS report_schedule_grace_period, report_schedule.working_timeout AS report_schedule_working_timeout, report_schedule.force_screenshot AS report_schedule_force_screenshot, report_schedule.custom_width AS report_schedule_custom_width, report_schedule.custom_height AS report_schedule_custom_height, report_schedule.created_by_fk AS report_schedule_created_by_fk, report_schedule.changed_by_fk AS report_schedule_changed_by_fk
superset_worker | FROM report_schedule
superset_worker | WHERE report_schedule.active IS true]
superset_worker | (Background on this error at: https://sqlalche.me/e/14/f405)
superset_app | 2024-04-24 09:05:19,388:DEBUG:superset.stats_logger:[stats_logger] (incr) health
superset_app | 2024-04-24 09:05:19,389:INFO:werkzeug:127.0.0.1 - - [24/Apr/2024 09:05:19] "GET /health HTTP/1.1" 200 -
superset_app | 2024-04-24 09:05:49,503:DEBUG:superset.stats_logger:[stats_logger] (incr) health
superset_app | 2024-04-24 09:05:49,504:INFO:werkzeug:127.0.0.1 - - [24/Apr/2024 09:05:49] "GET /health HTTP/1.1" 200 -
superset_worker_beat | [2024-04-24 09:06:00,042: INFO/MainProcess] Scheduler: Sending due task reports.scheduler (reports.scheduler)
superset_worker | [2024-04-24 09:06:00,046: INFO/MainProcess] Task reports.scheduler[b887ee35-d73d-471d-909c-343e4b2ac8c2] received
superset_worker | [2024-04-24 09:06:00,048: DEBUG/ForkPoolWorker-1] [stats_logger] (incr) reports.scheduler
superset_worker | [2024-04-24 09:06:00,055: ERROR/ForkPoolWorker-1] Task reports.scheduler[b887ee35-d73d-471d-909c-343e4b2ac8c2] raised unexpected: ProgrammingError('(psycopg2.errors.UndefinedTable) relation "report_schedule" does not exist\nLINE 2: FROM report_schedule \n ^\n')
superset_worker | Traceback (most recent call last):
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
superset_worker | self.dialect.do_execute(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
superset_worker | cursor.execute(statement, parameters)
superset_worker | psycopg2.errors.UndefinedTable: relation "report_schedule" does not exist
superset_worker | LINE 2: FROM report_schedule
superset_worker | ^
superset_worker |
superset_worker |
superset_worker | The above exception was the direct cause of the following exception:
superset_worker |
superset_worker | Traceback (most recent call last):
superset_worker | File "/usr/local/lib/python3.10/site-packages/celery/app/trace.py", line 477, in trace_task
superset_worker | R = retval = fun(*args, **kwargs)
superset_worker | File "/app/superset/initialization/init.py", line 110, in call
superset_worker | return task_base.call(self, *args, **kwargs)
superset_worker | File "/usr/local/lib/python3.10/site-packages/celery/app/trace.py", line 760, in protected_call
superset_worker | return self.run(*args, **kwargs)
superset_worker | File "/app/superset/tasks/scheduler.py", line 48, in scheduler
superset_worker | active_schedules = ReportScheduleDAO.find_active()
superset_worker | File "/app/superset/daos/report.py", line 213, in find_active
superset_worker | .all()
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2773, in all
superset_worker | return self._iter().all()
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2916, in _iter
superset_worker | result = self.session.execute(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1717, in execute
superset_worker | result = conn._execute_20(statement, params or {}, execution_options)
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1710, in _execute_20
superset_worker | return meth(self, args_10style, kwargs_10style, execution_options)
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 334, in _execute_on_connection
superset_worker | return connection._execute_clauseelement(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1577, in _execute_clauseelement
superset_worker | ret = self._execute_context(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1953, in _execute_context
superset_worker | self.handle_dbapi_exception(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2134, in handle_dbapi_exception
superset_worker | util.raise(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise
superset_worker | raise exception
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
superset_worker | self.dialect.do_execute(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
superset_worker | cursor.execute(statement, parameters)
superset_worker | sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "report_schedule" does not exist
superset_worker | LINE 2: FROM report_schedule
superset_worker | ^
superset_worker |
superset_worker | [SQL: SELECT report_schedule.created_on AS report_schedule_created_on, report_schedule.changed_on AS report_schedule_changed_on, report_schedule.extra_json AS report_schedule_extra_json, report_schedule.id AS report_schedule_id, report_schedule.type AS report_schedule_type, report_schedule.name AS report_schedule_name, report_schedule.description AS report_schedule_description, report_schedule.context_markdown AS report_schedule_context_markdown, report_schedule.active AS report_schedule_active, report_schedule.crontab AS report_schedule_crontab, report_schedule.creation_method AS report_schedule_creation_method, report_schedule.timezone AS report_schedule_timezone, report_schedule.report_format AS report_schedule_report_format, report_schedule.sql AS report_schedule_sql, report_schedule.chart_id AS report_schedule_chart_id, report_schedule.dashboard_id AS report_schedule_dashboard_id, report_schedule.database_id AS report_schedule_database_id, report_schedule.last_eval_dttm AS report_schedule_last_eval_dttm, report_schedule.last_state AS report_schedule_last_state, report_schedule.last_value AS report_schedule_last_value, report_schedule.last_value_row_json AS report_schedule_last_value_row_json, report_schedule.validator_type AS report_schedule_validator_type, report_schedule.validator_config_json AS report_schedule_validator_config_json, report_schedule.log_retention AS report_schedule_log_retention, report_schedule.grace_period AS report_schedule_grace_period, report_schedule.working_timeout AS report_schedule_working_timeout, report_schedule.force_screenshot AS report_schedule_force_screenshot, report_schedule.custom_width AS report_schedule_custom_width, report_schedule.custom_height AS report_schedule_custom_height, report_schedule.created_by_fk AS report_schedule_created_by_fk, report_schedule.changed_by_fk AS report_schedule_changed_by_fk
superset_worker | FROM report_schedule
superset_worker | WHERE report_schedule.active IS true]
superset_worker | (Background on this error at: https://sqlalche.me/e/14/f405)
superset_app | 2024-04-24 09:06:19,610:DEBUG:superset.stats_logger:[stats_logger] (incr) health
superset_app | 2024-04-24 09:06:19,611:INFO:werkzeug:127.0.0.1 - - [24/Apr/2024 09:06:19] "GET /health HTTP/1.1" 200 -
superset_app | 2024-04-24 09:06:49,712:DEBUG:superset.stats_logger:[stats_logger] (incr) health
superset_app | 2024-04-24 09:06:49,713:INFO:werkzeug:127.0.0.1 - - [24/Apr/2024 09:06:49] "GET /health HTTP/1.1" 200 -
superset_worker_beat | [2024-04-24 09:07:00,044: INFO/MainProcess] Scheduler: Sending due task reports.scheduler (reports.scheduler)
superset_worker | [2024-04-24 09:07:00,048: INFO/MainProcess] Task reports.scheduler[98b8e728-4f48-42bf-b018-3e4de1f75102] received
superset_worker | [2024-04-24 09:07:00,049: DEBUG/ForkPoolWorker-1] [stats_logger] (incr) reports.scheduler
superset_worker | [2024-04-24 09:07:00,058: ERROR/ForkPoolWorker-1] Task reports.scheduler[98b8e728-4f48-42bf-b018-3e4de1f75102] raised unexpected: ProgrammingError('(psycopg2.errors.UndefinedTable) relation "report_schedule" does not exist\nLINE 2: FROM report_schedule \n ^\n')
superset_worker | Traceback (most recent call last):
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
superset_worker | self.dialect.do_execute(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
superset_worker | cursor.execute(statement, parameters)
superset_worker | psycopg2.errors.UndefinedTable: relation "report_schedule" does not exist
superset_worker | LINE 2: FROM report_schedule
superset_worker | ^
superset_worker |
superset_worker |
superset_worker | The above exception was the direct cause of the following exception:
superset_worker |
superset_worker | Traceback (most recent call last):
superset_worker | File "/usr/local/lib/python3.10/site-packages/celery/app/trace.py", line 477, in trace_task
superset_worker | R = retval = fun(*args, **kwargs)
superset_worker | File "/app/superset/initialization/init.py", line 110, in call
superset_worker | return task_base.call(self, *args, **kwargs)
superset_worker | File "/usr/local/lib/python3.10/site-packages/celery/app/trace.py", line 760, in protected_call
superset_worker | return self.run(*args, **kwargs)
superset_worker | File "/app/superset/tasks/scheduler.py", line 48, in scheduler
superset_worker | active_schedules = ReportScheduleDAO.find_active()
superset_worker | File "/app/superset/daos/report.py", line 213, in find_active
superset_worker | .all()
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2773, in all
superset_worker | return self._iter().all()
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2916, in _iter
superset_worker | result = self.session.execute(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1717, in execute
superset_worker | result = conn._execute_20(statement, params or {}, execution_options)
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1710, in _execute_20
superset_worker | return meth(self, args_10style, kwargs_10style, execution_options)
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 334, in _execute_on_connection
superset_worker | return connection._execute_clauseelement(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1577, in _execute_clauseelement
superset_worker | ret = self._execute_context(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1953, in _execute_context
superset_worker | self.handle_dbapi_exception(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2134, in handle_dbapi_exception
superset_worker | util.raise(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise
superset_worker | raise exception
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
superset_worker | self.dialect.do_execute(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
superset_worker | cursor.execute(statement, parameters)
superset_worker | sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "report_schedule" does not exist
superset_worker | LINE 2: FROM report_schedule
superset_worker | ^
superset_worker |
superset_worker | [SQL: SELECT report_schedule.created_on AS report_schedule_created_on, report_schedule.changed_on AS report_schedule_changed_on, report_schedule.extra_json AS report_schedule_extra_json, report_schedule.id AS report_schedule_id, report_schedule.type AS report_schedule_type, report_schedule.name AS report_schedule_name, report_schedule.description AS report_schedule_description, report_schedule.context_markdown AS report_schedule_context_markdown, report_schedule.active AS report_schedule_active, report_schedule.crontab AS report_schedule_crontab, report_schedule.creation_method AS report_schedule_creation_method, report_schedule.timezone AS report_schedule_timezone, report_schedule.report_format AS report_schedule_report_format, report_schedule.sql AS report_schedule_sql, report_schedule.chart_id AS report_schedule_chart_id, report_schedule.dashboard_id AS report_schedule_dashboard_id, report_schedule.database_id AS report_schedule_database_id, report_schedule.last_eval_dttm AS report_schedule_last_eval_dttm, report_schedule.last_state AS report_schedule_last_state, report_schedule.last_value AS report_schedule_last_value, report_schedule.last_value_row_json AS report_schedule_last_value_row_json, report_schedule.validator_type AS report_schedule_validator_type, report_schedule.validator_config_json AS report_schedule_validator_config_json, report_schedule.log_retention AS report_schedule_log_retention, report_schedule.grace_period AS report_schedule_grace_period, report_schedule.working_timeout AS report_schedule_working_timeout, report_schedule.force_screenshot AS report_schedule_force_screenshot, report_schedule.custom_width AS report_schedule_custom_width, report_schedule.custom_height AS report_schedule_custom_height, report_schedule.created_by_fk AS report_schedule_created_by_fk, report_schedule.changed_by_fk AS report_schedule_changed_by_fk
superset_worker | FROM report_schedule
superset_worker | WHERE report_schedule.active IS true]
superset_worker | (Background on this error at: https://sqlalche.me/e/14/f405)
superset_app | 2024-04-24 09:07:19,875:DEBUG:superset.stats_logger:[stats_logger] (incr) health
superset_app | 2024-04-24 09:07:19,876:INFO:werkzeug:127.0.0.1 - - [24/Apr/2024 09:07:19] "GET /health HTTP/1.1" 200 -
superset_app | 2024-04-24 09:07:49,974:DEBUG:superset.stats_logger:[stats_logger] (incr) health
superset_app | 2024-04-24 09:07:49,975:INFO:werkzeug:127.0.0.1 - - [24/Apr/2024 09:07:49] "GET /health HTTP/1.1" 200 -
superset_worker_beat | [2024-04-24 09:08:00,047: INFO/MainProcess] Scheduler: Sending due task reports.scheduler (reports.scheduler)
superset_worker | [2024-04-24 09:08:00,051: INFO/MainProcess] Task reports.scheduler[2c31b203-2a19-430e-817d-139d97d1e2ef] received
superset_worker | [2024-04-24 09:08:00,052: DEBUG/ForkPoolWorker-1] [stats_logger] (incr) reports.scheduler
superset_worker | [2024-04-24 09:08:00,061: ERROR/ForkPoolWorker-1] Task reports.scheduler[2c31b203-2a19-430e-817d-139d97d1e2ef] raised unexpected: ProgrammingError('(psycopg2.errors.UndefinedTable) relation "report_schedule" does not exist\nLINE 2: FROM report_schedule \n ^\n')
superset_worker | Traceback (most recent call last):
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
superset_worker | self.dialect.do_execute(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
superset_worker | cursor.execute(statement, parameters)
superset_worker | psycopg2.errors.UndefinedTable: relation "report_schedule" does not exist
superset_worker | LINE 2: FROM report_schedule
superset_worker | ^
superset_worker |
superset_worker |
superset_worker | The above exception was the direct cause of the following exception:
superset_worker |
superset_worker | Traceback (most recent call last):
superset_worker | File "/usr/local/lib/python3.10/site-packages/celery/app/trace.py", line 477, in trace_task
superset_worker | R = retval = fun(*args, **kwargs)
superset_worker | File "/app/superset/initialization/init.py", line 110, in call
superset_worker | return task_base.call(self, *args, **kwargs)
superset_worker | File "/usr/local/lib/python3.10/site-packages/celery/app/trace.py", line 760, in protected_call
superset_worker | return self.run(*args, **kwargs)
superset_worker | File "/app/superset/tasks/scheduler.py", line 48, in scheduler
superset_worker | active_schedules = ReportScheduleDAO.find_active()
superset_worker | File "/app/superset/daos/report.py", line 213, in find_active
superset_worker | .all()
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2773, in all
superset_worker | return self._iter().all()
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2916, in _iter
superset_worker | result = self.session.execute(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1717, in execute
superset_worker | result = conn._execute_20(statement, params or {}, execution_options)
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1710, in _execute_20
superset_worker | return meth(self, args_10style, kwargs_10style, execution_options)
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 334, in _execute_on_connection
superset_worker | return connection._execute_clauseelement(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1577, in _execute_clauseelement
superset_worker | ret = self._execute_context(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1953, in _execute_context
superset_worker | self.handle_dbapi_exception(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2134, in handle_dbapi_exception
superset_worker | util.raise(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise
superset_worker | raise exception
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
superset_worker | self.dialect.do_execute(
superset_worker | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
superset_worker | cursor.execute(statement, parameters)
superset_worker | sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "report_schedule" does not exist
superset_worker | LINE 2: FROM report_schedule
superset_worker | ^
superset_worker |
superset_worker | [SQL: SELECT report_schedule.created_on AS report_schedule_created_on, report_schedule.changed_on AS report_schedule_changed_on, report_schedule.extra_json AS report_schedule_extra_json, report_schedule.id AS report_schedule_id, report_schedule.type AS report_schedule_type, report_schedule.name AS report_schedule_name, report_schedule.description AS report_schedule_description, report_schedule.context_markdown AS report_schedule_context_markdown, report_schedule.active AS report_schedule_active, report_schedule.crontab AS report_schedule_crontab, report_schedule.creation_method AS report_schedule_creation_method, report_schedule.timezone AS report_schedule_timezone, report_schedule.report_format AS report_schedule_report_format, report_schedule.sql AS report_schedule_sql, report_schedule.chart_id AS report_schedule_chart_id, report_schedule.dashboard_id AS report_schedule_dashboard_id, report_schedule.database_id AS report_schedule_database_id, report_schedule.last_eval_dttm AS report_schedule_last_eval_dttm, report_schedule.last_state AS report_schedule_last_state, report_schedule.last_value AS report_schedule_last_value, report_schedule.last_value_row_json AS report_schedule_last_value_row_json, report_schedule.validator_type AS report_schedule_validator_type, report_schedule.validator_config_json AS report_schedule_validator_config_json, report_schedule.log_retention AS report_schedule_log_retention, report_schedule.grace_period AS report_schedule_grace_period, report_schedule.working_timeout AS report_schedule_working_timeout, report_schedule.force_screenshot AS report_schedule_force_screenshot, report_schedule.custom_width AS report_schedule_custom_width, report_schedule.custom_height AS report_schedule_custom_height, report_schedule.created_by_fk AS report_schedule_created_by_fk, report_schedule.changed_by_fk AS report_schedule_changed_by_fk
superset_worker | FROM report_schedule
superset_worker | WHERE report_schedule.active IS true]
superset_worker | (Background on this error at: https://sqlalche.me/e/14/f405)
Beta Was this translation helpful? Give feedback.
All reactions