kaxil commented on PR #44533: URL: https://github.com/apache/airflow/pull/44533#issuecomment-2511643750
> While Testing this I noticed an issue in the downgrade case. We are not removing the data from downgrade and just perform below conversion. > > ``` > ALTER TABLE dag_run > ALTER COLUMN conf TYPE BYTEA > USING CASE > WHEN conf IS NOT NULL THEN CONVERT_TO(conf::TEXT, 'UTF8') > ELSE NULL > END > > ``` > > I am getting `UnpicklingError` error with this when I try to open DAG page.  > > Should we also move data to the archive table in case of a downgrade as well? cc: @kaxil Yeah, it is different than XCom, because XCom code had handling of both JSON & pickle type -- for dagrun conf it would be different. For downgrade you might just want to insert all records from the archive table back here. -- 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]
