Mottimo commented on issue #24247:
URL: https://github.com/apache/airflow/issues/24247#issuecomment-1150051803
Hi, I run another test on a fresh environment. These the steps using MariaDB:
1. New env prepared starting from Airflow 2.2.5, DB initialized and never
used;
2. Dump of the DB and update of the COLLATE to utf8mb3_general_ci;
3. Airflow 2.3.1 updated using @ephraimbuddy's patch for sequences;
4. `airflow db upgrade` successfully executed without any further
intervention. Service was not started;
5. upgrade to Airflow 2.3.2, vanilla code;
6. `airflow db upgrade` successfully executed;
7. Service started without issues;
8. The creation of a new admin user has fired the following error:
`[2022-06-08 16:58:09,460] {manager.py:351} ERROR - Add Permission:
(sqlalchemy.exc.ProgrammingError) (MySQLdb._exceptions.ProgrammingError) (1146,
"Table 'airflow.ab_permission_id_seq' doesn't exist")`
It seems that the issue with sequences still be there, then...;
9. ... applying the SQL patch from @AlekseiSaff has fixed the issue.
The service is now up & running with 2.3.2 using a set of testing DAGs to
validate. Basing on the above, the only patch for models.py does not fix all
the sequences issue.
--
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]
