You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by "Max Richter (JIRA)" <ji...@apache.org> on 2018/09/10 09:08:00 UTC
[jira] [Updated] (AIRFLOW-3032) _pickle.UnpicklingError with using
remote MySQL Server
[ https://issues.apache.org/jira/browse/AIRFLOW-3032?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Max Richter updated AIRFLOW-3032:
---------------------------------
Description:
Hello,
I am running Airflow 1.9.0 successfully with a localhost MySQL database, version 5.7.23.
I switched sql_alchemy_conn = mysql://airflow:<password>@<remote-host>:3306/airflow in order to use the proper MySQL server - same version 5.7.23.
I created a dump from my local instance to the remote one.
Issue:
* When tasks are executed by the scheduler everything runs fine, tasks are executed and DB upadted
* When manually triggering a task via the webserver, I am getting "_pickle.UnpicklingError" please see error__log.txt for full log
In the end, I only changed this one line in airflow.cfg which is causing that I can not use it with a remote MySQL server.
Best,
Max
was:
Hello,
I am running Airflow 1.9.0 successfully with a localhost MySQL database, version 5.7.23.
I switched sql_alchemy_conn = mysql://airflow:<pw>l@<remote-host>:3306/airflow in order to use the proper MySQL server - same version 5.7.23.
I created a dump from my local instance to the remote one.
Issue:
* When tasks are executed by the scheduler everything runs fine, tasks are executed and DB upadted
* When manually triggering a task via the webserver, I am getting "_pickle.UnpicklingError" please see error__log.txt for full log
In the end, I only changed this one line in airflow.cfg which is causing that I can not use it with a remote MySQL server.
Best,
Max
> _pickle.UnpicklingError with using remote MySQL Server
> ------------------------------------------------------
>
> Key: AIRFLOW-3032
> URL: https://issues.apache.org/jira/browse/AIRFLOW-3032
> Project: Apache Airflow
> Issue Type: Bug
> Components: database
> Affects Versions: 1.9.0
> Reporter: Max Richter
> Priority: Blocker
> Attachments: error_log.txt, pip_list.txt
>
>
> Hello,
> I am running Airflow 1.9.0 successfully with a localhost MySQL database, version 5.7.23.
> I switched sql_alchemy_conn = mysql://airflow:<password>@<remote-host>:3306/airflow in order to use the proper MySQL server - same version 5.7.23.
> I created a dump from my local instance to the remote one.
> Issue:
> * When tasks are executed by the scheduler everything runs fine, tasks are executed and DB upadted
> * When manually triggering a task via the webserver, I am getting "_pickle.UnpicklingError" please see error__log.txt for full log
> In the end, I only changed this one line in airflow.cfg which is causing that I can not use it with a remote MySQL server.
>
> Best,
> Max
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)