You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2019/04/16 18:19:13 UTC
[GitHub] [incubator-superset] kakoni commented on issue #6606: DB Migration
Fails When Running Upgrade 6c7537a6004a -> 3e1b21cd94a4
kakoni commented on issue #6606: DB Migration Fails When Running Upgrade 6c7537a6004a -> 3e1b21cd94a4
URL: https://github.com/apache/incubator-superset/issues/6606#issuecomment-483787450
Also ran into this.
```sql
SELECT ab_permission_view.id AS ab_permission_view_id,
ab_permission_view.permission_id AS ab_permission_view_permission_id,
ab_permission_view.view_menu_id AS ab_permission_view_view_menu_id
FROM ab_permission_view
WHERE 13 = ab_permission_view.permission_id AND 25 = ab_permission_view.view_menu_id
LIMIT 1
```
Looking at pg_stat_activity, this query was fired first, sitting in `idle in transaction` state.
Few milli seconds later
```sql
ALTER TABLE ab_view_menu ALTER COLUMN name TYPE VARCHAR(255)
```
is executed, but it locks, as ab_permission_view references ab_view_menu (and select+alter table on the same table block, as per https://www.citusdata.com/blog/2018/02/15/when-postgresql-blocks/)
Anyhow, this was reported earlier, see https://github.com/apache/incubator-superset/issues/1260#issuecomment-334115725
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org