farovictor opened a new issue, #33252:
URL: https://github.com/apache/superset/issues/33252
### Bug description
When spinning up **Apache Superset** using the **official Helm chart
(v0.14.2)**, the database initialization process (superset-init-db Job)
**fails** with a **PostgreSQL deadlock** error during schema migration.
The deadlock occurs specifically when dropping a constraint from the
dashboard_roles table:
```sql
ALTER TABLE dashboard_roles DROP CONSTRAINT dashboard_roles_role_id_fkey
```
The full stack trace shows:
```plaintext
psycopg2.errors.DeadlockDetected: deadlock detected
DETAIL: Process 524296 waits for AccessExclusiveLock on relation 30677 of
database 26028; blocked by process 524734.
Process 524734 waits for AccessShareLock on relation 30685 of database
26028; blocked by process 524296.
```
As a result, superset db upgrade crashes and Superset cannot complete
initialization.
Steps to reproduce
1. Deploy Superset via the Apache Superset Helm chart (0.14.2)
with default or minimally customized values.
2. Use an external Postgres database (in this case, connection to
an existing db).
3. Observe the init container superset-init-db running migrations.
4. Migration fails when trying to drop the constraint on the
dashboard_roles table.
5. Deadlock error appears and initialization job fails.
### Fix
In order to make it pass, I scale down all deployments to 0 replicas. I
guess, this shouldn't be needed.
### Screenshots/recordings
_No response_
### Superset version
4.1.2
### Python version
3.10
### Node version
16
### Browser
Chrome
### Additional context
error trace:
```text
superset-init-db Setting up cpp (4:12.2.0-3) ...
superset-init-db Setting up binutils-x86-64-linux-gnu (2.40-2) ...
superset-init-db Setting up gpg-wks-client (2.2.40-1.1) ...
superset-init-db Setting up libstdc++-12-dev:amd64 (12.2.0-14) ...
superset-init-db Setting up libfile-fcntllock-perl (0.22-4+b1) ...
superset-init-db Setting up libalgorithm-diff-perl (1.201-1) ...
superset-init-db Setting up binutils (2.40-2) ...
superset-init-db Setting up dpkg-dev (1.21.22) ...
superset-init-db Setting up gcc-12 (12.2.0-14) ...
superset-init-db Setting up gnupg (2.2.40-1.1) ...
superset-init-db Setting up libalgorithm-diff-xs-perl:amd64 (0.04-8+b1) ...
superset-init-db Setting up libalgorithm-merge-perl (0.08-5) ...
superset-init-db Setting up g++-12 (12.2.0-14) ...
superset-init-db Setting up gcc (4:12.2.0-3) ...
superset-init-db Setting up g++ (4:12.2.0-3) ...
superset-init-db update-alternatives: using /usr/bin/g++ to provide
/usr/bin/c++ (c++) in auto mode
superset-init-db Setting up build-essential (12.9) ...
superset-init-db Processing triggers for libc-bin (2.36-9+deb12u10) ...
superset-init-db Collecting authlib
superset-init-db Downloading authlib-1.5.2-py2.py3-none-any.whl.metadata
(3.9 kB)
superset-init-db Collecting psycopg2-binary
superset-init-db Downloading
psycopg2_binary-2.9.10-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.metadata
(4.9 kB)
superset-init-db Requirement already satisfied: cryptography in
/usr/local/lib/python3.10/site-packages (from authlib) (42.0.7)
superset-init-db Requirement already satisfied: cffi>=1.12 in
/usr/local/lib/python3.10/site-packages (from cryptography->authlib) (1.16.0)
superset-init-db Requirement already satisfied: pycparser in
/usr/local/lib/python3.10/site-packages (from
cffi>=1.12->cryptography->authlib) (2.22)
superset-init-db Downloading authlib-1.5.2-py2.py3-none-any.whl (232 kB)
superset-init-db Downloading
psycopg2_binary-2.9.10-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
(3.0 MB)
superset-init-db ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 3.0/3.0 MB
130.1 MB/s eta 0:00:00
superset-init-db Installing collected packages: psycopg2-binary, authlib
superset-init-db Successfully installed authlib-1.5.2 psycopg2-binary-2.9.10
superset-init-db WARNING: Running pip as the 'root' user can result in
broken permissions and conflicting behaviour with the system package manager,
possibly rendering your system unusable. It is recommended to use a virtual
environment instead: https://pip.pypa.io/warnings/venv. Use the
--root-user-action option if you know what you are doing and want to suppress
this warning.
superset-init-db
superset-init-db [notice] A new release of pip is available: 25.0.1 -> 25.1
superset-init-db [notice] To update, run: pip install --upgrade pip
superset-init-db Upgrading DB schema...
superset-init-db Loaded your LOCAL configuration at
[/app/pythonpath/superset_config.py]
superset-init-db 2025-04-26
16:25:08,229:INFO:superset.initialization:Setting database isolation level to
READ COMMITTED
superset-init-db
/usr/local/lib/python3.10/site-packages/flask_limiter/extension.py:333:
UserWarning: Using the in-memory storage for tracking rate limits as no storage
was explicitly specified. This is not recommended for production use. See:
https://flask-limiter.readthedocs.io#configuring-a-storage-backend for
documentation about configuring the storage backend.
superset-init-db warnings.warn(
superset-init-db 2025-04-26 16:25:16,875:INFO:superset.utils.screenshots:No
PIL installation found
superset-init-db 2025-04-26 16:25:17,545:INFO:superset.utils.pdf:No PIL
installation found
superset-init-db INFO [alembic.env] Starting the migration scripts.
superset-init-db INFO [alembic.runtime.migration] Context impl
PostgresqlImpl.
superset-init-db INFO [alembic.runtime.migration] Will assume transactional
DDL.
superset-init-db INFO [alembic.runtime.migration] Running upgrade ->
4e6a06bad7a8, Init
superset-init-db INFO [alembic.runtime.migration] Running upgrade
4e6a06bad7a8 -> 5a7bad26f2a7, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
5a7bad26f2a7 -> 1e2841a4128, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
1e2841a4128 -> 2929af7925ed, TZ offsets in data sources
superset-init-db INFO [alembic.runtime.migration] Running upgrade
2929af7925ed -> 289ce07647b, Add encrypted password field
superset-init-db INFO [alembic.runtime.migration] Running upgrade
289ce07647b -> 1a48a5411020, adding slug to dash
superset-init-db INFO [alembic.runtime.migration] Running upgrade
1a48a5411020 -> 315b3f4da9b0, adding log model
superset-init-db INFO [alembic.runtime.migration] Running upgrade
315b3f4da9b0 -> 55179c7f25c7, sqla_descr
superset-init-db INFO [alembic.runtime.migration] Running upgrade
55179c7f25c7 -> 12d55656cbca, is_featured
superset-init-db INFO [alembic.runtime.migration] Running upgrade
12d55656cbca -> 2591d77e9831, user_id
superset-init-db INFO [alembic.runtime.migration] Running upgrade
2591d77e9831 -> 8e80a26a31db, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
8e80a26a31db -> 7dbf98566af7, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
7dbf98566af7 -> 43df8de3a5f4, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
43df8de3a5f4 -> d827694c7555, css templates
superset-init-db INFO [alembic.runtime.migration] Running upgrade
d827694c7555 -> 430039611635, log more
superset-init-db INFO [alembic.runtime.migration] Running upgrade
430039611635 -> 18e88e1cc004, making audit nullable
superset-init-db INFO [alembic.runtime.migration] Running upgrade
18e88e1cc004 -> 836c0bf75904, cache_timeouts
superset-init-db INFO [alembic.runtime.migration] Running upgrade
18e88e1cc004 -> a2d606a761d9, adding favstar model
superset-init-db INFO [alembic.runtime.migration] Running upgrade
a2d606a761d9, 836c0bf75904 -> d2424a248d63, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
d2424a248d63 -> 763d4b211ec9, fixing audit fk
superset-init-db INFO [alembic.runtime.migration] Running upgrade
d2424a248d63 -> 1d2ddd543133, log dt
superset-init-db INFO [alembic.runtime.migration] Running upgrade
1d2ddd543133, 763d4b211ec9 -> fee7b758c130, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
fee7b758c130 -> 867bf4f117f9, Adding extra field to Database model
superset-init-db INFO [alembic.runtime.migration] Running upgrade
867bf4f117f9 -> bb51420eaf83, add schema to table model
superset-init-db INFO [alembic.runtime.migration] Running upgrade
bb51420eaf83 -> b4456560d4f3, change_table_unique_constraint
superset-init-db INFO [alembic.runtime.migration] Running upgrade
b4456560d4f3 -> 4fa88fe24e94, owners_many_to_many
superset-init-db INFO [alembic.runtime.migration] Running upgrade
4fa88fe24e94 -> c3a8f8611885, Materializing permission
superset-init-db INFO [alembic.runtime.migration] Running upgrade
c3a8f8611885 -> f0fbf6129e13, Adding verbose_name to tablecolumn
superset-init-db INFO [alembic.runtime.migration] Running upgrade
f0fbf6129e13 -> 956a063c52b3, adjusting key length
superset-init-db INFO [alembic.runtime.migration] Running upgrade
956a063c52b3 -> 1226819ee0e3, Fix wrong constraint on table columns
superset-init-db WARNI [root] Could not find or drop constraint on `columns`
superset-init-db INFO [alembic.runtime.migration] Running upgrade
1226819ee0e3 -> d8bc074f7aad, Add new field 'is_restricted' to SqlMetric and
DruidMetric
superset-init-db INFO [alembic.runtime.migration] Running upgrade
d8bc074f7aad -> 27ae655e4247, Make creator owners
superset-init-db INFO [alembic.runtime.migration] Running upgrade
27ae655e4247 -> 960c69cb1f5b, add dttm_format related fields in table_columns
superset-init-db INFO [alembic.runtime.migration] Running upgrade
960c69cb1f5b -> f162a1dea4c4, d3format_by_metric
superset-init-db INFO [alembic.runtime.migration] Running upgrade
f162a1dea4c4 -> ad82a75afd82, Update models to support storing the queries.
superset-init-db INFO [alembic.runtime.migration] Running upgrade
ad82a75afd82 -> 3c3ffe173e4f, add_sql_string_to_table
superset-init-db INFO [alembic.runtime.migration] Running upgrade
3c3ffe173e4f -> 41f6a59a61f2, database options for sql lab
superset-init-db INFO [alembic.runtime.migration] Running upgrade
41f6a59a61f2 -> 4500485bde7d, allow_run_sync_async
superset-init-db INFO [alembic.runtime.migration] Running upgrade
4500485bde7d -> 65903709c321, allow_dml
superset-init-db INFO [alembic.runtime.migration] Running upgrade
41f6a59a61f2 -> 33d996bcc382, update slice model
superset-init-db INFO [alembic.runtime.migration] Running upgrade
33d996bcc382, 65903709c321 -> b347b202819b, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
b347b202819b -> 5e4a03ef0bf0, Add access_request table to manage requests to
access datastores.
superset-init-db INFO [alembic.runtime.migration] Running upgrade
5e4a03ef0bf0 -> eca4694defa7, sqllab_setting_defaults
superset-init-db INFO [alembic.runtime.migration] Running upgrade
eca4694defa7 -> ab3d66c4246e, add_cache_timeout_to_druid_cluster
superset-init-db INFO [alembic.runtime.migration] Running upgrade
eca4694defa7 -> 3b626e2a6783, Sync DB with the models.py.
superset-init-db INFO [alembic.runtime.migration] Running upgrade
3b626e2a6783, ab3d66c4246e -> ef8843b41dac, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
ef8843b41dac -> b46fa1b0b39e, Add json_metadata to the tables table.
superset-init-db INFO [alembic.runtime.migration] Running upgrade
b46fa1b0b39e -> 7e3ddad2a00b, results_key to query
superset-init-db INFO [alembic.runtime.migration] Running upgrade
7e3ddad2a00b -> ad4d656d92bc, Add avg() to default metrics
superset-init-db INFO [alembic.runtime.migration] Running upgrade
ad4d656d92bc -> c611f2b591b8, dim_spec
stream closed EOF for superset/superset-init-db-6kxgj (wait-for-postgres)
superset-init-db INFO [alembic.runtime.migration] Running upgrade
c611f2b591b8 -> e46f2d27a08e, materialize perms
superset-init-db INFO [alembic.runtime.migration] Running upgrade
e46f2d27a08e -> f1f2d4af5b90, Enable Filter Select
superset-init-db INFO [alembic.runtime.migration] Running upgrade
e46f2d27a08e -> 525c854f0005, log_this_plus
superset-init-db INFO [alembic.runtime.migration] Running upgrade
525c854f0005, f1f2d4af5b90 -> 6414e83d82b7, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
6414e83d82b7 -> 1296d28ec131, Adds params to the datasource (druid) table
superset-init-db INFO [alembic.runtime.migration] Running upgrade
1296d28ec131 -> f18570e03440, Add index on the result key to the query table.
superset-init-db INFO [alembic.runtime.migration] Running upgrade
f18570e03440 -> bcf3126872fc, Add keyvalue table
superset-init-db INFO [alembic.runtime.migration] Running upgrade
f18570e03440 -> db0c65b146bd, update_slice_model_json
superset-init-db INFO [alembic.runtime.migration] Running upgrade
db0c65b146bd -> a99f2f7c195a, rewriting url from shortener with new format
superset-init-db INFO [alembic.runtime.migration] Running upgrade
a99f2f7c195a, bcf3126872fc -> d6db5a5cdb5d, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
d6db5a5cdb5d -> b318dfe5fb6c, adding verbose_name to druid column
superset-init-db INFO [alembic.runtime.migration] Running upgrade
d6db5a5cdb5d -> 732f1c06bcbf, add fetch values predicate
superset-init-db INFO [alembic.runtime.migration] Running upgrade
732f1c06bcbf, b318dfe5fb6c -> ea033256294a, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
b318dfe5fb6c -> db527d8c4c78, Add verbose name to DruidCluster and Database
superset-init-db INFO [alembic.runtime.migration] Running upgrade
db527d8c4c78, ea033256294a -> 979c03af3341, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
979c03af3341 -> a6c18f869a4e, query.start_running_time
superset-init-db INFO [alembic.runtime.migration] Running upgrade
a6c18f869a4e -> 2fcdcb35e487, saved_queries
superset-init-db INFO [alembic.runtime.migration] Running upgrade
2fcdcb35e487 -> a65458420354, add_result_backend_time_logging
superset-init-db INFO [alembic.runtime.migration] Running upgrade
a65458420354 -> ca69c70ec99b, tracking_url
superset-init-db INFO [alembic.runtime.migration] Running upgrade
ca69c70ec99b -> a9c47e2c1547, add impersonate_user to dbs
superset-init-db INFO [alembic.runtime.migration] Running upgrade
ca69c70ec99b -> ddd6ebdd853b, annotations
superset-init-db INFO [alembic.runtime.migration] Running upgrade
a9c47e2c1547, ddd6ebdd853b -> d39b1e37131d, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
ca69c70ec99b -> 19a814813610, Adding metric warning_text
superset-init-db INFO [alembic.runtime.migration] Running upgrade
19a814813610, a9c47e2c1547 -> 472d2f73dfd4, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
472d2f73dfd4, d39b1e37131d -> f959a6652acd, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
f959a6652acd -> 4736ec66ce19, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
4736ec66ce19 -> 67a6ac9b727b, update_spatial_params
superset-init-db INFO [alembic.runtime.migration] Running upgrade
67a6ac9b727b -> 21e88bc06c02, migrate_old_annotation_layers
superset-init-db INFO [alembic.runtime.migration] Running upgrade
21e88bc06c02 -> e866bd2d4976, smaller_grid
superset-init-db INFO [alembic.runtime.migration] Running upgrade
e866bd2d4976 -> e68c4473c581, allow_multi_schema_metadata_fetch
superset-init-db INFO [alembic.runtime.migration] Running upgrade
e68c4473c581 -> f231d82b9b26, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
f231d82b9b26 -> bf706ae5eb46, cal_heatmap_metric_to_metrics
superset-init-db INFO [alembic.runtime.migration] Running upgrade
f231d82b9b26 -> 30bb17c0dc76, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
30bb17c0dc76, bf706ae5eb46 -> c9495751e314, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
f231d82b9b26 -> 130915240929, is_sqllab_view
superset-init-db INFO [alembic.runtime.migration] Running upgrade
130915240929, c9495751e314 -> 5ccf602336a0, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
5ccf602336a0 -> e502db2af7be, add template_params to tables
superset-init-db INFO [alembic.runtime.migration] Running upgrade
e502db2af7be -> c5756bec8b47, Time grain SQLA
superset-init-db INFO [alembic.runtime.migration] Running upgrade
c5756bec8b47 -> afb7730f6a9c, remove empty filters
superset-init-db INFO [alembic.runtime.migration] Running upgrade
afb7730f6a9c -> 80a67c5192fa, single pie chart metric
superset-init-db INFO [alembic.runtime.migration] Running upgrade
80a67c5192fa -> bddc498dd179, adhoc filters
superset-init-db INFO [alembic.runtime.migration] Running upgrade
bddc498dd179 -> 4451805bbaa1, remove double percents
superset-init-db INFO [alembic.runtime.migration] Running upgrade
bddc498dd179 -> 3dda56f1c4c6, Migrate num_period_compare and period_ratio_type
superset-init-db INFO [alembic.runtime.migration] Running upgrade
3dda56f1c4c6 -> 1d9e835a84f9, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
4451805bbaa1, 1d9e835a84f9 -> e3970889f38e, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
4451805bbaa1, 1d9e835a84f9 -> 705732c70154, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
4451805bbaa1, 1d9e835a84f9 -> fc480c87706c, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
fc480c87706c -> bebcf3fed1fe, Migrate dashboard position_json data from V1 to V2
superset-init-db INFO [alembic.runtime.migration] Running upgrade
bebcf3fed1fe, 705732c70154 -> ec1f88a35cc6, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
705732c70154, e3970889f38e -> 46ba6aaaac97, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
46ba6aaaac97, ec1f88a35cc6 -> c18bd4186f15, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
c18bd4186f15 -> 7fcdcde0761c, Reduce position_json size by remove extra space
and component id prefix
superset-init-db INFO [alembic.runtime.migration] Running upgrade
7fcdcde0761c -> 0c5070e96b57, add user attributes table
superset-init-db INFO [alembic.runtime.migration] Running upgrade
0c5070e96b57 -> 1a1d627ebd8e, position_json
superset-init-db INFO [alembic.runtime.migration] Running upgrade
1a1d627ebd8e -> 55e910a74826, add_metadata_column_to_annotation_model.py
superset-init-db INFO [alembic.runtime.migration] Running upgrade
55e910a74826 -> 4ce8df208545, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
4ce8df208545 -> 46f444d8b9b7, remove_coordinator_from_druid_cluster_model.py
superset-init-db INFO [alembic.runtime.migration] Running upgrade
46f444d8b9b7 -> a61b40f9f57f, remove allow_run_sync
superset-init-db INFO [alembic.runtime.migration] Running upgrade
a61b40f9f57f -> 6c7537a6004a, models for email reports
superset-init-db INFO [alembic.runtime.migration] Running upgrade
6c7537a6004a -> 3e1b21cd94a4, change_owner_to_m2m_relation_on_datasources.py
superset-init-db INFO [alembic.runtime.migration] Running upgrade
6c7537a6004a -> cefabc8f7d38, Increase size of name column in ab_view_menu
superset-init-db INFO [alembic.runtime.migration] Running upgrade
55e910a74826 -> 0b1f1ab473c0, Add extra column to Query
superset-init-db INFO [alembic.runtime.migration] Running upgrade
0b1f1ab473c0, cefabc8f7d38, 3e1b21cd94a4 -> de021a1ca60d, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
de021a1ca60d -> fb13d49b72f9, better_filters
superset-init-db INFO [alembic.runtime.migration] Running upgrade
fb13d49b72f9 -> a33a03f16c4a, Add extra column to SavedQuery
superset-init-db INFO [alembic.runtime.migration] Running upgrade
4451805bbaa1, 1d9e835a84f9 -> c829ff0b37d0, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
c829ff0b37d0 -> 7467e77870e4, remove_aggs
superset-init-db INFO [alembic.runtime.migration] Running upgrade
7467e77870e4, de021a1ca60d -> fbd55e0f83eb, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
fbd55e0f83eb, fb13d49b72f9 -> 8b70aa3d0f87, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
8b70aa3d0f87, a33a03f16c4a -> 18dc26817ad2, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
18dc26817ad2 -> c617da68de7d, form nullable
superset-init-db INFO [alembic.runtime.migration] Running upgrade
c617da68de7d -> c82ee8a39623, Add implicit tags
superset-init-db INFO [alembic.runtime.migration] Running upgrade
18dc26817ad2 -> e553e78e90c5, add_druid_auth_py.py
superset-init-db INFO [alembic.runtime.migration] Running upgrade
e553e78e90c5, c82ee8a39623 -> 45e7da7cfeba, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
45e7da7cfeba -> 80aa3f04bc82, Add Parent ids in dashboard layout metadata
superset-init-db INFO [alembic.runtime.migration] Running upgrade
80aa3f04bc82 -> d94d33dbe938, form strip
superset-init-db INFO [alembic.runtime.migration] Running upgrade
d94d33dbe938 -> 937d04c16b64, update datasources
superset-init-db INFO [alembic.runtime.migration] Running upgrade
937d04c16b64 -> 7f2635b51f5d, update base columns
superset-init-db INFO [alembic.runtime.migration] Running upgrade
7f2635b51f5d -> e9df189e5c7e, update base metrics
superset-init-db INFO [alembic.runtime.migration] Running upgrade
e9df189e5c7e -> afc69274c25a, update the sql, select_sql, and executed_sql
columns in the
superset-init-db query table in mysql dbs to be long text columns
superset-init-db INFO [alembic.runtime.migration] Running upgrade
afc69274c25a -> d7c1a0d6f2da, Remove limit used from query model
superset-init-db INFO [alembic.runtime.migration] Running upgrade
d7c1a0d6f2da -> ab8c66efdd01, resample
superset-init-db INFO [alembic.runtime.migration] Running upgrade
ab8c66efdd01 -> b4a38aa87893, deprecate database expression
superset-init-db INFO [alembic.runtime.migration] Running upgrade
b4a38aa87893 -> d6ffdf31bdd4, Add published column to dashboards
superset-init-db INFO [alembic.runtime.migration] Running upgrade
d6ffdf31bdd4 -> 190188938582, Remove duplicated entries in dashboard_slices
table and add unique constraint
superset-init-db INFO [alembic.runtime.migration] Running upgrade
190188938582 -> def97f26fdfb, Add index to tagged_object
superset-init-db INFO [alembic.runtime.migration] Running upgrade
def97f26fdfb -> 11c737c17cc6, deprecate_restricted_metrics
superset-init-db INFO [alembic.runtime.migration] Running upgrade
11c737c17cc6 -> 258b5280a45e, form strip leading and trailing whitespace
superset-init-db INFO [alembic.runtime.migration] Running upgrade
258b5280a45e -> 1495eb914ad3, time range
superset-init-db INFO [alembic.runtime.migration] Running upgrade
1495eb914ad3 -> b6fa807eac07, make_names_non_nullable
superset-init-db INFO [alembic.runtime.migration] Running upgrade
b6fa807eac07 -> cca2f5d568c8, add encrypted_extra to dbs
superset-init-db INFO [alembic.runtime.migration] Running upgrade
cca2f5d568c8 -> c2acd2cf3df2, alter type of dbs encrypted_extra
superset-init-db INFO [alembic.runtime.migration] Running upgrade
c2acd2cf3df2 -> 78ee127d0d1d, reconvert legacy filters into adhoc
superset-init-db INFO [alembic.runtime.migration] Running upgrade
78ee127d0d1d -> db4b49eb0782, Add tables for SQL Lab state
superset-init-db INFO [alembic.runtime.migration] Running upgrade
db4b49eb0782 -> 5afa9079866a, serialize_schema_permissions.py
superset-init-db INFO [alembic.runtime.migration] Running upgrade
5afa9079866a -> 89115a40e8ea, Change table schema description to long text
superset-init-db INFO [alembic.runtime.migration] Running upgrade
89115a40e8ea -> 817e1c9b09d0, add_not_null_to_dbs_sqlalchemy_url
superset-init-db INFO [alembic.runtime.migration] Running upgrade
817e1c9b09d0 -> e96dbf2cfef0, datasource_cluster_fk
superset-init-db INFO [alembic.runtime.migration] Running upgrade
e96dbf2cfef0 -> 3325d4caccc8, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
3325d4caccc8 -> 0a6f12f60c73, add_role_level_security
superset-init-db INFO [alembic.runtime.migration] Running upgrade
0a6f12f60c73 -> 72428d1ea401, Add tmp_schema_name to the query object.
superset-init-db INFO [alembic.runtime.migration] Running upgrade
72428d1ea401 -> b5998378c225, add certificate to dbs
superset-init-db INFO [alembic.runtime.migration] Running upgrade
b5998378c225 -> f9a30386bd74, cleanup_time_granularity
superset-init-db INFO [alembic.runtime.migration] Running upgrade
f9a30386bd74 -> 620241d1153f, update time_grain_sqla
superset-init-db INFO [alembic.runtime.migration] Running upgrade
620241d1153f -> 743a117f0d98, Add slack to the schedule
superset-init-db INFO [alembic.runtime.migration] Running upgrade
743a117f0d98 -> e557699a813e, add_tables_relation_to_row_level_security
superset-init-db INFO [alembic.runtime.migration] Running upgrade
e557699a813e -> ea396d202291, Add ctas_method to the Query object
superset-init-db INFO [alembic.runtime.migration] Running upgrade
ea396d202291 -> a72cb0ebeb22, deprecate dbs.perm column
superset-init-db INFO [alembic.runtime.migration] Running upgrade
a72cb0ebeb22 -> 2f1d15e8a6af, add_alerts
superset-init-db INFO [alembic.runtime.migration] Running upgrade
2f1d15e8a6af -> f2672aa8350a, add_slack_to_alerts
superset-init-db INFO [alembic.runtime.migration] Running upgrade
f2672aa8350a -> f120347acb39, Add extra column to tables and metrics
superset-init-db INFO [alembic.runtime.migration] Running upgrade
f2672aa8350a -> 978245563a02, Migrate iframe in dashboard to markdown component
superset-init-db INFO [alembic.runtime.migration] Running upgrade
978245563a02, f120347acb39 -> f80a3b88324b, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
f80a3b88324b -> 2e5a0ee25ed4, refractor_alerting
superset-init-db INFO [alembic.runtime.migration] Running upgrade
f80a3b88324b -> 175ea3592453, Add cache to datasource lookup table.
superset-init-db INFO [alembic.runtime.migration] Running upgrade
175ea3592453, 2e5a0ee25ed4 -> ae19b4ee3692, empty message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
ae19b4ee3692 -> e5ef6828ac4e, add rls filter type and grouping key
superset-init-db INFO [alembic.runtime.migration] Running upgrade
e5ef6828ac4e -> 3fbbc6e8d654, fix data access permissions for virtual datasets
superset-init-db INFO [alembic.runtime.migration] Running upgrade
3fbbc6e8d654 -> 18532d70ab98, Delete table_name unique constraint in mysql
superset-init-db INFO [alembic.runtime.migration] Running upgrade
18532d70ab98 -> b56500de1855, add_uuid_column_to_import_mixin
superset-init-db INFO [alembic.runtime.migration] Running upgrade
b56500de1855 -> af30ca79208f, Collapse alerting models into a single one
superset-init-db INFO [alembic.runtime.migration] Running upgrade
af30ca79208f -> 585b0b1a7b18, add exec info to saved queries
superset-init-db INFO [alembic.runtime.migration] Running upgrade
585b0b1a7b18 -> 96e99fb176a0, add_import_mixing_to_saved_query
superset-init-db INFO [alembic.runtime.migration] Running upgrade
96e99fb176a0 -> 49b5a32daba5, add report schedules
superset-init-db INFO [alembic.runtime.migration] Running upgrade
49b5a32daba5 -> a8173232b786, Add path to logs
superset-init-db INFO [alembic.runtime.migration] Running upgrade
a8173232b786 -> e38177dbf641, security converge saved queries
superset-init-db INFO [alembic.runtime.migration] Running upgrade
e38177dbf641 -> 8ee129739cf9, security converge css templates
superset-init-db INFO [alembic.runtime.migration] Running upgrade
8ee129739cf9 -> 811494c0cc23, Remove path, path_no_int, and ref from logs
superset-init-db INFO [alembic.runtime.migration] Running upgrade
811494c0cc23 -> 5daced1f0e76, reports add working_timeout column
superset-init-db INFO [alembic.runtime.migration] Running upgrade
5daced1f0e76 -> 40f16acf1ba7, security converge reports
superset-init-db INFO [alembic.runtime.migration] Running upgrade
40f16acf1ba7 -> ccb74baaa89b, security converge charts
superset-init-db INFO [alembic.runtime.migration] Running upgrade
ccb74baaa89b -> c25cb2c78727, security converge annotations
superset-init-db INFO [alembic.runtime.migration] Running upgrade
c25cb2c78727 -> 45731db65d9c, security converge datasets
superset-init-db INFO [alembic.runtime.migration] Running upgrade
45731db65d9c -> 4b84f97828aa, security converge logs
superset-init-db INFO [alembic.runtime.migration] Running upgrade
4b84f97828aa -> 1f6dca87d1a2, security converge dashboards
superset-init-db INFO [alembic.runtime.migration] Running upgrade
1f6dca87d1a2 -> 42b4c9e01447, security converge databases
superset-init-db INFO [alembic.runtime.migration] Running upgrade
42b4c9e01447 -> e37912a26567, security converge queries
superset-init-db INFO [alembic.runtime.migration] Running upgrade
e37912a26567 -> ab104a954a8f, reports alter crontab size
superset-init-db INFO [alembic.runtime.migration] Running upgrade
ab104a954a8f -> 73fd22e742ab, add_dynamic_plugins.py
superset-init-db INFO [alembic.runtime.migration] Running upgrade
73fd22e742ab -> c878781977c6, alert reports shared uniqueness
superset-init-db INFO [alembic.runtime.migration] Running upgrade
c878781977c6 -> 260bf0649a77, migrate [x dateunit] to [x dateunit ago/later]
superset-init-db INFO [alembic.runtime.migration] Running upgrade
260bf0649a77 -> e11ccdd12658, add roles relationship to dashboard
superset-init-db INFO [alembic.runtime.migration] Running upgrade
e11ccdd12658 -> 41ce8799acc3, rename pie label type
superset-init-db INFO [alembic.runtime.migration] Running upgrade
41ce8799acc3 -> 070c043f2fdb, add granularity to charts where missing
superset-init-db INFO [alembic.runtime.migration] Running upgrade
070c043f2fdb -> c501b7c653a3, add missing uuid column
superset-init-db INFO [alembic.runtime.migration] Running upgrade
c501b7c653a3 -> 1412ec1e5a7b, legacy force directed to echart
superset-init-db INFO [alembic.runtime.migration] Running upgrade
1412ec1e5a7b -> 67da9ef1ef9c, add hide_left_bar to tabstate
superset-init-db INFO [alembic.runtime.migration] Running upgrade
67da9ef1ef9c -> 989bbe479899,
rename_filter_configuration_in_dashboard_metadata.py
superset-init-db INFO [alembic.runtime.migration] Running upgrade
989bbe479899 -> 301362411006, add_execution_id_to_report_execution_log_model.py
superset-init-db INFO [alembic.runtime.migration] Running upgrade
301362411006 -> 134cea61c5e7, remove dataset health check message
superset-init-db INFO [alembic.runtime.migration] Running upgrade
134cea61c5e7 -> 085f06488938, Country map use lowercase country name
superset-init-db INFO [alembic.runtime.migration] Running upgrade
085f06488938 -> fc3a3a8ff221, migrate filter sets to new format
superset-init-db INFO [alembic.runtime.migration] Running upgrade
fc3a3a8ff221 -> 19e978e1b9c3, add_report_format_to_report_schedule_model.py
superset-init-db INFO [alembic.runtime.migration] Running upgrade
19e978e1b9c3 -> d416d0d715cc, add_limiting_factor_column_to_query_model.py
superset-init-db INFO [alembic.runtime.migration] Running upgrade
d416d0d715cc -> f1410ed7ec95, migrate native filters to new schema
superset-init-db INFO [alembic.runtime.migration] Running upgrade
f1410ed7ec95 -> 453530256cea, add_save_form_column_to_db_model
superset-init-db INFO [alembic.runtime.migration] Running upgrade
453530256cea -> 3317e9248280, add_creation_method_to_reports_model
superset-init-db INFO [alembic.runtime.migration] Running upgrade
3317e9248280 -> 030c840e3a1c, Add query context to slices
superset-init-db INFO [alembic.runtime.migration] Running upgrade
030c840e3a1c -> ae1ed299413b, add_timezone_to_report_schedule
superset-init-db INFO [alembic.runtime.migration] Running upgrade
ae1ed299413b -> 31b2a1039d4a, drop tables constraint
superset-init-db INFO [alembic.runtime.migration] Running upgrade
31b2a1039d4a -> e323605f370a, fix schemas_allowed_for_csv_upload
superset-init-db INFO [alembic.runtime.migration] Running upgrade
e323605f370a -> 143b6f2815da, migrate pivot table v2 heatmaps to new format
superset-init-db INFO [alembic.runtime.migration] Running upgrade
143b6f2815da -> f6196627326f, update chart permissions
superset-init-db INFO [alembic.runtime.migration] Running upgrade
f6196627326f -> 6d20ba9ecb33, add_last_saved_at_to_slice_model
superset-init-db INFO [alembic.runtime.migration] Running upgrade
6d20ba9ecb33 -> 07071313dd52, change_fetch_values_predicate_to_text
superset-init-db INFO [alembic.runtime.migration] Running upgrade
07071313dd52 -> 021b81fe4fbb, Add type to native filter configuration
superset-init-db INFO [alembic] [AddTypeToNativeFilter] Starting upgrade
superset-init-db INFO [alembic] [AddTypeToNativeFilter] Done!
superset-init-db INFO [alembic.runtime.migration] Running upgrade
021b81fe4fbb -> 181091c0ef16, add_extra_column_to_columns_model
superset-init-db INFO [alembic.runtime.migration] Running upgrade
181091c0ef16 -> 3ebe0993c770, add filter set model
superset-init-db INFO [alembic.runtime.migration] Running upgrade
3ebe0993c770 -> 60dc453f4e2e, migrate timeseries_limit_metric to
legacy_order_by in pivot_table_v2
superset-init-db INFO [alembic.runtime.migration] Running upgrade
60dc453f4e2e -> 32646df09c64, update time grain SQLA
superset-init-db INFO [alembic.runtime.migration] Running upgrade
32646df09c64 -> f9847149153d, add_certifications_columns_to_slice
superset-init-db INFO [alembic.runtime.migration] Running upgrade
f9847149153d -> aea15018d53b, add_certifications_columns_to_dashboard
superset-init-db INFO [alembic.runtime.migration] Running upgrade
aea15018d53b -> b92d69a6643c, rename_csv_to_file
superset-init-db INFO [alembic.runtime.migration] Running upgrade
b92d69a6643c -> 0ca9e5f1dacd, rename to schemas_allowed_for_file_upload in
dbs.extra
superset-init-db INFO [alembic.runtime.migration] Running upgrade
0ca9e5f1dacd -> abe27eaf93db, add_extra_config_column_to_alerts
superset-init-db INFO [alembic.runtime.migration] Running upgrade
abe27eaf93db -> 3ba29ecbaac5, Change datatype of type in BaseColumn
superset-init-db INFO [alembic.runtime.migration] Running upgrade
3ba29ecbaac5 -> fe23025b9441, rename_big_viz_total_form_data_fields
superset-init-db INFO [alembic.runtime.migration] Running upgrade
fe23025b9441 -> 31bb738bd1d2,
move_pivot_table_v2_legacy_order_by_to_timeseries_limit_metric
superset-init-db INFO [alembic.runtime.migration] Running upgrade
31bb738bd1d2 -> bb38f40aa3ff, Add force_screenshot to alerts/reports
superset-init-db INFO [alembic.runtime.migration] Running upgrade
bb38f40aa3ff -> c53bae8f08dd, add_saved_query_foreign_key_to_tab_state
superset-init-db INFO [alembic.runtime.migration] Running upgrade
c53bae8f08dd -> 5fd49410a97a, Add columns for external management
superset-init-db INFO [alembic.runtime.migration] Running upgrade
5fd49410a97a -> 5afbb1a5849b, add_embedded_dashboard_table
superset-init-db INFO [alembic.runtime.migration] Running upgrade
5afbb1a5849b -> b8d3a24d9131, New dataset models
superset-init-db INFO [alembic.runtime.migration] Running upgrade
b8d3a24d9131 -> b5a422d8e252, fix query and saved_query null schema
superset-init-db INFO [alembic.runtime.migration] Running upgrade
b5a422d8e252 -> ab9a9d86e695, deprecate time_range_endpoints
superset-init-db INFO [alembic.runtime.migration] Running upgrade
ab9a9d86e695 -> 7293b0ca7944, change_adhoc_filter_b_from_none_to_empty_array
superset-init-db INFO [alembic.runtime.migration] Running upgrade
7293b0ca7944 -> 6766938c6065, add key-value store
superset-init-db INFO [alembic.runtime.migration] Running upgrade
6766938c6065 -> 58df9d617f14,
add_on_saved_query_delete_tab_state_null_constraint"
superset-init-db INFO [alembic.runtime.migration] Running upgrade
58df9d617f14 -> 2ed890b36b94, rm_time_range_endpoints_from_qc
superset-init-db INFO [alembic.runtime.migration] Running upgrade
2ed890b36b94 -> b0d0249074e4, deprecate time_range_endpoints v2
superset-init-db INFO [alembic.runtime.migration] Running upgrade
2ed890b36b94 -> 8b841273bec3, sql_lab_models_database_constraint_updates
superset-init-db INFO [alembic.runtime.migration] Running upgrade
8b841273bec3, b0d0249074e4 -> 9d8a8d575284, merge point
superset-init-db INFO [alembic.runtime.migration] Running upgrade
9d8a8d575284 -> cecc6bf46990, rm_time_range_endpoints_2
superset-init-db INFO [alembic.runtime.migration] Running upgrade
cecc6bf46990 -> ad07e4fdbaba, rm_time_range_endpoints_from_qc_3
superset-init-db INFO [alembic.runtime.migration] Running upgrade
ad07e4fdbaba -> a9422eeaae74, new_dataset_models_take_2
superset-init-db INFO [alembic.runtime.migration] Running upgrade
a9422eeaae74 -> cbe71abde154, fix report schedule and execution log
superset-init-db INFO [alembic.runtime.migration] Running upgrade
cbe71abde154 -> 6f139c533bea, adding advanced data type to column models
superset-init-db INFO [alembic.runtime.migration] Running upgrade
6f139c533bea -> e786798587de, Delete None permissions
superset-init-db INFO [alembic.runtime.migration] Running upgrade
e786798587de -> e09b4ae78457, Resize key_value blob
superset-init-db INFO [alembic.runtime.migration] Running upgrade
e09b4ae78457 -> f3afaf1f11f0, add_unique_name_desc_rls
superset-init-db INFO [alembic.runtime.migration] Running upgrade
f3afaf1f11f0 -> 7fb8bca906d2, permalink_rename_filterState
superset-init-db INFO [alembic.runtime.migration] Running upgrade
7fb8bca906d2 -> cdcf3d64daf4, Add user_id and dttm composite index to Log model
superset-init-db INFO [alembic.runtime.migration] Running upgrade
cdcf3d64daf4 -> c747c78868b6, Migrating legacy TreeMap
superset-init-db INFO [alembic.runtime.migration] Running upgrade
c747c78868b6 -> 06e1e70058c7, Migrating legacy Area
superset-init-db INFO [alembic.runtime.migration] Running upgrade
06e1e70058c7 -> a39867932713, query_context_to_mediumtext
superset-init-db INFO [alembic.runtime.migration] Running upgrade
a39867932713 -> 409c7b420ab0, add created_by_fk as owner
superset-init-db INFO [alembic.runtime.migration] Running upgrade
409c7b420ab0 -> ffa79af61a56, rename report_schedule.extra to extra_json
superset-init-db INFO [alembic.runtime.migration] Running upgrade
ffa79af61a56 -> 6d3c6f9d665d, fix_table_chart_conditional_formatting_colors
superset-init-db INFO [alembic.runtime.migration] Running upgrade
6d3c6f9d665d -> 291f024254b5, drop_column_allow_multi_schema_metadata_fetch
superset-init-db INFO [alembic.runtime.migration] Running upgrade
291f024254b5 -> deb4c9d4a4ef, parameters in saved queries
superset-init-db INFO [alembic.runtime.migration] Running upgrade
deb4c9d4a4ef -> 4ce1d9b25135, remove_filter_bar_orientation
superset-init-db INFO [alembic.runtime.migration] Running upgrade
4ce1d9b25135 -> f3c2d8ec8595, create_ssh_tunnel_credentials_tbl
superset-init-db INFO [alembic.runtime.migration] Running upgrade
f3c2d8ec8595 -> 9c2a5681ddfd, convert key-value entries to json
superset-init-db INFO [alembic.runtime.migration] Running upgrade
9c2a5681ddfd -> c0a3ea245b61, remove_show_native_filters
superset-init-db INFO [alembic.runtime.migration] Running upgrade
c0a3ea245b61 -> d0ac08bb5b83, invert_horizontal_bar_chart_order
superset-init-db INFO [alembic.runtime.migration] Running upgrade
d0ac08bb5b83 -> b5ea9d343307, bar_chart_stack_options
superset-init-db INFO [alembic.runtime.migration] Running upgrade
b5ea9d343307 -> 07f9a902af1b, drop postgres enum constrains for tags
superset-init-db INFO [alembic.runtime.migration] Running upgrade
07f9a902af1b -> 7e67aecbf3f1, chart-ds-constraint
superset-init-db INFO [alembic.runtime.migration] Running upgrade
7e67aecbf3f1 -> 4ea966691069, cross-filter-global-scoping
superset-init-db INFO [alembic.runtime.migration] Running upgrade
4ea966691069 -> 9ba2ce3086e5, migrate-pivot-table-v1-to-v2
superset-init-db INFO [alembic.runtime.migration] Running upgrade
9ba2ce3086e5 -> 4c5da39be729, migrate_treemap_chart
superset-init-db INFO [alembic.runtime.migration] Running upgrade
4c5da39be729 -> ae58e1e58e5c, migrate_dual_line_to_mixed_chart
superset-init-db INFO [alembic.runtime.migration] Running upgrade
ae58e1e58e5c -> 83e1abbe777f, drop access_request
superset-init-db INFO [alembic.runtime.migration] Running upgrade
83e1abbe777f -> 90139bf715e4, add_currency_column_to_metrics
superset-init-db INFO [alembic.runtime.migration] Running upgrade
90139bf715e4 -> 6fbe660cac39, add on delete cascade for tables references
superset-init-db INFO [alembic.runtime.migration] Running upgrade
6fbe660cac39 -> 8e5b0fb85b9a, Add custom size columns to report schedule
superset-init-db INFO [alembic.runtime.migration] Running upgrade
8e5b0fb85b9a -> 240d23c7f86f, update_tag_model_w_description
superset-init-db INFO [alembic.runtime.migration] Running upgrade
240d23c7f86f -> f92a3124dd66, drop rouge constraints and tables
superset-init-db INFO [alembic.runtime.migration] Running upgrade
f92a3124dd66 -> 6d05b0a70c89, add on delete cascade for owners references
superset-init-db INFO [alembic.runtime.migration] Running upgrade
6d05b0a70c89 -> 863adcf72773, delete obsolete Druid NoSQL slice parameters
superset-init-db INFO [alembic.runtime.migration] Running upgrade
863adcf72773 -> a23c6f8b1280, cleanup erroneous parent filter IDs
superset-init-db INFO [alembic.runtime.migration] Running upgrade
a23c6f8b1280 -> bf646a0c1501, json_metadata
superset-init-db INFO [alembic.runtime.migration] Running upgrade
bf646a0c1501 -> e0f6f91c2055, create_user_favorite_table
superset-init-db INFO [alembic.runtime.migration] Running upgrade
e0f6f91c2055 -> ee179a490af9, deckgl-path-width-units
superset-init-db INFO [alembic.runtime.migration] Running upgrade
ee179a490af9 -> 0769ef90fddd, Fix schema perm for datasets
superset-init-db INFO [alembic.runtime.migration] Running upgrade
0769ef90fddd -> 2e826adca42c, Fix schema for log
superset-init-db INFO [alembic.runtime.migration] Running upgrade
2e826adca42c -> 8ace289026f3, add on delete cascade for dashboard_slices
superset-init-db INFO [alembic.runtime.migration] Running upgrade
8ace289026f3 -> 4448fa6deeb1, add on delete cascade for embedded_dashboards
superset-init-db INFO [alembic.runtime.migration] Running upgrade
4448fa6deeb1 -> 9f4a086c2676, add_normalize_columns_to_sqla_model
superset-init-db INFO [alembic.runtime.migration] Running upgrade
9f4a086c2676 -> ec54aca4c8a2, Increase ab_user.email field size
superset-init-db INFO [alembic.runtime.migration] Running upgrade
ec54aca4c8a2 -> 317970b4400c, Added always_filter_main_dttm to datasource
superset-init-db INFO [alembic.runtime.migration] Running upgrade
317970b4400c -> 4b85906e5b91, add on delete cascade for dashboard_roles
superset-init-db Upgraded 0 slices.
superset-init-db slices updated with no time_range_endpoints: 0
superset-init-db >> Assign new UUIDs to tables...
superset-init-db >> Drop intermediate columns...
superset-init-db Traceback (most recent call last):
superset-init-db File
"/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910,
in _execute_context
superset-init-db self.dialect.do_execute(
superset-init-db File
"/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line
736, in do_execute
superset-init-db cursor.execute(statement, parameters)
superset-init-db psycopg2.errors.DeadlockDetected: deadlock detected
superset-init-db DETAIL: Process 542957 waits for AccessExclusiveLock on
relation 43670 of database 43650; blocked by process 543951.
superset-init-db Process 543951 waits for AccessShareLock on relation 43678
of database 43650; blocked by process 542957.
superset-init-db HINT: See server log for query details.
superset-init-db
superset-init-db
superset-init-db The above exception was the direct cause of the following
exception:
superset-init-db
superset-init-db Traceback (most recent call last):
superset-init-db File "/usr/local/bin/superset", line 8, in <module>
superset-init-db sys.exit(superset())
superset-init-db File
"/usr/local/lib/python3.10/site-packages/click/core.py", line 1157, in __call__
superset-init-db return self.main(*args, **kwargs)
superset-init-db File
"/usr/local/lib/python3.10/site-packages/click/core.py", line 1078, in main
superset-init-db rv = self.invoke(ctx)
superset-init-db File
"/usr/local/lib/python3.10/site-packages/click/core.py", line 1688, in invoke
superset-init-db return _process_result(sub_ctx.command.invoke(sub_ctx))
superset-init-db File
"/usr/local/lib/python3.10/site-packages/click/core.py", line 1688, in invoke
superset-init-db return _process_result(sub_ctx.command.invoke(sub_ctx))
superset-init-db File
"/usr/local/lib/python3.10/site-packages/click/core.py", line 1434, in invoke
superset-init-db return ctx.invoke(self.callback, **ctx.params)
superset-init-db File
"/usr/local/lib/python3.10/site-packages/click/core.py", line 783, in invoke
superset-init-db return __callback(*args, **kwargs)
superset-init-db File
"/usr/local/lib/python3.10/site-packages/click/decorators.py", line 33, in
new_func
superset-init-db return f(get_current_context(), *args, **kwargs)
superset-init-db File
"/usr/local/lib/python3.10/site-packages/flask/cli.py", line 358, in decorator
superset-init-db return __ctx.invoke(f, *args, **kwargs)
superset-init-db File
"/usr/local/lib/python3.10/site-packages/click/core.py", line 783, in invoke
superset-init-db return __callback(*args, **kwargs)
superset-init-db File
"/usr/local/lib/python3.10/site-packages/flask_migrate/cli.py", line 149, in
upgrade
superset-init-db _upgrade(directory, revision, sql, tag, x_arg)
superset-init-db File
"/usr/local/lib/python3.10/site-packages/flask_migrate/__init__.py", line 98,
in wrapped
superset-init-db f(*args, **kwargs)
superset-init-db File
"/usr/local/lib/python3.10/site-packages/flask_migrate/__init__.py", line 185,
in upgrade
superset-init-db command.upgrade(config, revision, sql=sql, tag=tag)
superset-init-db File
"/usr/local/lib/python3.10/site-packages/alembic/command.py", line 403, in
upgrade
superset-init-db script.run_env()
superset-init-db File
"/usr/local/lib/python3.10/site-packages/alembic/script/base.py", line 583, in
run_env
superset-init-db util.load_python_file(self.dir, "env.py")
superset-init-db File
"/usr/local/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 95, in
load_python_file
superset-init-db module = load_module_py(module_id, path)
superset-init-db File
"/usr/local/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 113, in
load_module_py
superset-init-db spec.loader.exec_module(module) # type: ignore
superset-init-db File "<frozen importlib._bootstrap_external>", line 883,
in exec_module
superset-init-db File "<frozen importlib._bootstrap>", line 241, in
_call_with_frames_removed
superset-init-db File "/app/superset/extensions/../migrations/env.py",
line 142, in <module>
superset-init-db run_migrations_online()
superset-init-db File "/app/superset/extensions/../migrations/env.py",
line 133, in run_migrations_online
superset-init-db context.run_migrations()
superset-init-db File "<string>", line 8, in run_migrations
superset-init-db File
"/usr/local/lib/python3.10/site-packages/alembic/runtime/environment.py", line
948, in run_migrations
superset-init-db self.get_context().run_migrations(**kw)
superset-init-db File
"/usr/local/lib/python3.10/site-packages/alembic/runtime/migration.py", line
627, in run_migrations
superset-init-db step.migration_fn(**kw)
superset-init-db 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-db redefine(foreign_key, on_delete="CASCADE")
superset-init-db File "/app/superset/migrations/shared/constraints.py",
line 59, in redefine
superset-init-db with op.batch_alter_table(foreign_key.table,
naming_convention=conv) as batch_op:
superset-init-db File "/usr/local/lib/python3.10/contextlib.py", line 142,
in __exit__
superset-init-db next(self.gen)
superset-init-db File
"/usr/local/lib/python3.10/site-packages/alembic/operations/base.py", line 398,
in batch_alter_table
superset-init-db impl.flush()
superset-init-db File
"/usr/local/lib/python3.10/site-packages/alembic/operations/batch.py", line
116, in flush
superset-init-db fn(*arg, **kw)
superset-init-db File
"/usr/local/lib/python3.10/site-packages/alembic/ddl/impl.py", line 350, in
drop_constraint
superset-init-db self._exec(schema.DropConstraint(const))
superset-init-db File
"/usr/local/lib/python3.10/site-packages/alembic/ddl/impl.py", line 207, in
_exec
superset-init-db return conn.execute(construct, multiparams)
superset-init-db File
"/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1385,
in execute
superset-init-db return meth(self, multiparams, params,
_EMPTY_EXECUTION_OPTS)
superset-init-db File
"/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/ddl.py", line 80, in
_execute_on_connection
superset-init-db return connection._execute_ddl(
superset-init-db File
"/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1477,
in _execute_ddl
superset-init-db ret = self._execute_context(
superset-init-db File
"/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1953,
in _execute_context
superset-init-db self._handle_dbapi_exception(
superset-init-db File
"/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2134,
in _handle_dbapi_exception
superset-init-db util.raise_(
superset-init-db File
"/usr/local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211,
in raise_
superset-init-db raise exception
superset-init-db File
"/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910,
in _execute_context
superset-init-db self.dialect.do_execute(
superset-init-db File
"/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line
736, in do_execute
superset-init-db cursor.execute(statement, parameters)
superset-init-db sqlalchemy.exc.OperationalError:
(psycopg2.errors.DeadlockDetected) deadlock detected
superset-init-db DETAIL: Process 542957 waits for AccessExclusiveLock on
relation 43670 of database 43650; blocked by process 543951.
superset-init-db Process 543951 waits for AccessShareLock on relation 43678
of database 43650; blocked by process 542957.
superset-init-db HINT: See server log for query details.
superset-init-db
superset-init-db [SQL: ALTER TABLE dashboard_roles DROP CONSTRAINT
dashboard_roles_role_id_fkey]
superset-init-db (Background on this error at: https://sqlalche.me/e/14/e3q8)
stream closed EOF for superset/superset-init-db-6kxgj (superset-init-db)
```
### Checklist
- [x] I have searched Superset docs and Slack and didn't find a solution to
my problem.
- [x] I have searched the GitHub issue tracker and didn't find a similar bug
report.
- [x] I have checked Superset's logs for errors and if I found a relevant
Python stacktrace, I included it here as text in the "additional context"
section.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
