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