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] [Created] (AIRFLOW-3032) _pickle.UnpicklingError with using remote MySQL Server

Max Richter created AIRFLOW-3032:
------------------------------------

             Summary: _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
         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:<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



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)