airflow-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Christie (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (AIRFLOW-1068) Autocommit error with Airflow v1.7.1.3 and pymssql v2.1.3
Date Tue, 04 Apr 2017 18:37:41 GMT

     [ https://issues.apache.org/jira/browse/AIRFLOW-1068?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Thomas Christie updated AIRFLOW-1068:
-------------------------------------
    Environment: 
OS: Centos 6
pymssql: 2.1.3

  was:OS: Centos 6

    Description: 
After upgrading pymssql started getting the following error when trying to use the MSSQL hook.

    [2017-04-04 13:02:27,260] {models.py:1286} ERROR - 'pymssql.Connection' object attribute
'autocommit' is read-only
    Traceback (most recent call last):
      File "/home/jobrunner/.virtualenvs/airflow/lib/python3.5/site-packages/airflow/models.py",
line 1245, in run
        result = task_copy.execute(context=context)
      File "/home/jobrunner/.virtualenvs/airflow/lib/python3.5/site-packages/airflow/operators/mssql_operator.py",
line 34, in execute
        hook.run(self.sql, parameters=self.parameters)
      File "/home/jobrunner/.virtualenvs/airflow/lib/python3.5/site-packages/airflow/hooks/dbapi_hook.py",
line 124, in run
        self.set_autocommit(conn, autocommit)
      File "/home/jobrunner/.virtualenvs/airflow/lib/python3.5/site-packages/airflow/hooks/dbapi_hook.py",
line 138, in set_autocommit
        conn.autocommit = autocommit
    AttributeError: 'pymssql.Connection' object attribute 'autocommit' is read-only

I looked at the dbapi_hook.py file and this is the offending line:

    def set_autocommit(self, conn, autocommit):
        conn.autocommit = autocommit

Changing the line to:

conn.autocommit(autocommit)

seems to work.  From what I understand, autocommit was a getter/setter method in pymssql versions
<2.0.0.  Maybe they've reverted the behavior?

> Autocommit error with Airflow v1.7.1.3 and pymssql v2.1.3
> ---------------------------------------------------------
>
>                 Key: AIRFLOW-1068
>                 URL: https://issues.apache.org/jira/browse/AIRFLOW-1068
>             Project: Apache Airflow
>          Issue Type: Bug
>          Components: db, hooks
>    Affects Versions: Airflow 1.7.1.3
>         Environment: OS: Centos 6
> pymssql: 2.1.3
>            Reporter: Thomas Christie
>
> After upgrading pymssql started getting the following error when trying to use the MSSQL
hook.
>     [2017-04-04 13:02:27,260] {models.py:1286} ERROR - 'pymssql.Connection' object attribute
'autocommit' is read-only
>     Traceback (most recent call last):
>       File "/home/jobrunner/.virtualenvs/airflow/lib/python3.5/site-packages/airflow/models.py",
line 1245, in run
>         result = task_copy.execute(context=context)
>       File "/home/jobrunner/.virtualenvs/airflow/lib/python3.5/site-packages/airflow/operators/mssql_operator.py",
line 34, in execute
>         hook.run(self.sql, parameters=self.parameters)
>       File "/home/jobrunner/.virtualenvs/airflow/lib/python3.5/site-packages/airflow/hooks/dbapi_hook.py",
line 124, in run
>         self.set_autocommit(conn, autocommit)
>       File "/home/jobrunner/.virtualenvs/airflow/lib/python3.5/site-packages/airflow/hooks/dbapi_hook.py",
line 138, in set_autocommit
>         conn.autocommit = autocommit
>     AttributeError: 'pymssql.Connection' object attribute 'autocommit' is read-only
> I looked at the dbapi_hook.py file and this is the offending line:
>     def set_autocommit(self, conn, autocommit):
>         conn.autocommit = autocommit
> Changing the line to:
> conn.autocommit(autocommit)
> seems to work.  From what I understand, autocommit was a getter/setter method in pymssql
versions <2.0.0.  Maybe they've reverted the behavior?



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message