kn6405 opened a new issue #17947:
URL: https://github.com/apache/airflow/issues/17947


   ### Apache Airflow version
   
   2.1.2
   
   ### Operating System
   
   Official docker image
   
   ### Versions of Apache Airflow Providers
   
   _No response_
   
   ### Deployment
   
   Official Apache Airflow Helm Chart
   
   ### Deployment details
   
   Originally had airflow 2.0.2 installed via 3rd party helm chart (running 
external postgres db). I uninstalled it and installed airflow 2.1.2 using the 
official chart. Pods are alll started up except the schedular pod is crashing 
with "ValueError: unsupported pickle protocol: 5"
   
   ### What happened
   
   I get a "ValueError: unsupported pickle protocol: 5". I went into the 
database and did some cleanup but still getting error. Not sure if there are 
other tables/colums that also need to be cleaned up.
   
   Cleanup Done:
   
   UPDATE public.dag_run SET conf= NULL; 
   DELETE FROM public.dag_pickle;
   
   Logs:
   
   File 
"/home/airflow/.local/lib/python3.6/site-packages/sqlalchemy/orm/loading.py", 
line 100, in instances
   cursor.close()
   File 
"/home/airflow/.local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py",
 line 70, in __exit__
   with_traceback=exc_tb,
   File 
"/home/airflow/.local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", 
line 182, in raise_
   raise exception
   File 
"/home/airflow/.local/lib/python3.6/site-packages/sqlalchemy/orm/loading.py", 
line 80, in instances
   rows = [proc(row) for row in fetch]
   File 
"/home/airflow/.local/lib/python3.6/site-packages/sqlalchemy/orm/loading.py", 
line 80, in <listcomp>
   rows = [proc(row) for row in fetch]
   File 
"/home/airflow/.local/lib/python3.6/site-packages/sqlalchemy/orm/loading.py", 
line 588, in _instance
   populators,
   File 
"/home/airflow/.local/lib/python3.6/site-packages/sqlalchemy/orm/loading.py", 
line 725, in _populate_full
   dict_[key] = getter(row)
   File 
"/home/airflow/.local/lib/python3.6/site-packages/sqlalchemy/sql/sqltypes.py", 
line 1723, in process
   return loads(value)
   File "/home/airflow/.local/lib/python3.6/site-packages/dill/_dill.py", line 
275, in loads
   return load(file, ignore, **kwds)
   File "/home/airflow/.local/lib/python3.6/site-packages/dill/_dill.py", line 
270, in load
   return Unpickler(file, ignore=ignore, **kwds).load()
   File "/home/airflow/.local/lib/python3.6/site-packages/dill/_dill.py", line 
472, in load
   obj = StockUnpickler.load(self)
   ValueError: unsupported pickle protocol: 5
   
   
   ### What you expected to happen
   
   _No response_
   
   ### How to reproduce
   
   _No response_
   
   ### Anything else
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of 
Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md)
   


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