rabindragogoi commented on issue #23483:
URL: https://github.com/apache/superset/issues/23483#issuecomment-1751951245
@eschutho : Thanks for the airflow link that you have provided. It helped
me to get the idea and fix the issue. i am able to upgrade superset db from
1.5.2 to 2.1.1 being mariadb as my metastore db.
Below are the steps I followed:
1.
I created all the the missing sequence as below.
DROP SEQUENCE IF EXISTS ab_permission_id_seq;
CREATE SEQUENCE ab_permission_id_seq start with 1 minvalue 1 maxvalue
9223372036854775806 increment by 1 cache 1000 nocycle ENGINE = InnoDB;
SELECT SETVAL(ab_permission_id_seq, **105**, 0);
DROP SEQUENCE IF EXISTS ab_view_menu_id_seq;
CREATE SEQUENCE ab_view_menu_id_seq start with 1 minvalue 1 maxvalue
9223372036854775806 increment by 1 cache 1000 nocycle ENGINE = InnoDB;
SELECT SETVAL(ab_view_menu_id_seq, **8014**, 0);
DROP SEQUENCE IF EXISTS ab_permission_view_id_seq;
CREATE SEQUENCE ab_permission_view_id_seq start with 1 minvalue 1 maxvalue
9223372036854775806 increment by 1 cache 1000 nocycle ENGINE = InnoDB;
SELECT SETVAL(ab_permission_view_id_seq, **8195**, 0);
DROP SEQUENCE IF EXISTS ab_permission_view_role_id_seq;
CREATE SEQUENCE ab_permission_view_role_id_seq start with 1 minvalue 1
maxvalue 9223372036854775806 increment by 1 cache 1000 nocycle ENGINE = InnoDB;
SELECT SETVAL(ab_permission_view_role_id_seq, **1238**, 0);
2.
For each table ab_permission_view, ab_permission_view_role, ab_view_menu and
ab_permission I extracted the max id columns value and same I placed in the
create sequence command as the start index. (else will return a duplicate
value.).
Cheers !!!!
--
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]
