Re: [PR] Update conf column in dag_run table type from bytea to JSON [airflow]

Mon, 02 Dec 2024 02:46:29 -0800 


vatsrahul1001 commented on PR #44533:
URL: https://github.com/apache/airflow/pull/44533#issuecomment-2511170203

   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.
   
![image](https://github.com/user-attachments/assets/93d7a456-448c-4d60-956d-50cbef968de3)
   
   Should we also move data to the archive table in case of a downgrade as well?
   cc: @kaxil 
   


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