AlekseiSaff commented on issue #24247:
URL: https://github.com/apache/airflow/issues/24247#issuecomment-1147684248

   that  is due to collation issue. my way to fix this
   
   My way of upgrading 2.2.5 to 2.3.0:
   
   create text DB dump
   change all "utf8mb3_unicode_ci" to "utf8mb3_bin" in the backup dump
   drop DB and recreate from modified backup
   
   one more issue with step:
   UPDATE rendered_task_instance_fields, dag_run SET 
rendered_task_instance_fields.run_id=dag_run.run_id WHERE dag_run.dag_id = 
rendered_task_instance_fields.dag_id AND dag_run.execution_date = 
rendered_task_instance_fields.execution_date;
   
   to fix this on the newly created DB run:
   alter table rendered_task_instance_fields change execution_date 
execution_date timestamp NOT NULL default CURRENT_TIMESTAMP;


-- 
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]

Reply via email to