You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by "jack (Jira)" <ji...@apache.org> on 2019/10/03 05:25:00 UTC

[jira] [Commented] (AIRFLOW-3032) _pickle.UnpicklingError with using remote MySQL Server

    [ https://issues.apache.org/jira/browse/AIRFLOW-3032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16943343#comment-16943343 ] 

jack commented on AIRFLOW-3032:
-------------------------------

Is this still an issue?

> _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 updated
>  * 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
(v8.3.4#803005)