[
https://issues.apache.org/jira/browse/AIRFLOW-107?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16010084#comment-16010084
]
Samarth Gahire commented on AIRFLOW-107:
----------------------------------------
I can confirm that even with mysql 5.5.55-0ubuntu0.14.04.1 its not working and
looks like some issue with airflow version 1.8.0.
After trying few versions I settled on 1.7.1.3 however with recent release it
is not working.
> syntax error when running airflow initdb with mysql connection
> --------------------------------------------------------------
>
> Key: AIRFLOW-107
> URL: https://issues.apache.org/jira/browse/AIRFLOW-107
> Project: Apache Airflow
> Issue Type: Bug
> Affects Versions: Airflow 1.7.0
> Reporter: James Yoo
>
> Not sure if I've setup my mysql database correctly or not, assume that you
> just specify a connection string to a mysql server and port? In any case,
> I'm getting a syntax error when running 'airflow initdb'
> {code}
> cursor.execute(statement, parameters)
> File "build/bdist.linux-x86_64/egg/MySQLdb/cursors.py", line 226, in execute
> File "build/bdist.linux-x86_64/egg/MySQLdb/connections.py", line 36, in
> defaulterrorhandler
> sqlalchemy.exc.ProgrammingError: (_mysql_exceptions.ProgrammingError) (1064,
> "You have an error in your SQL syntax; check the manual that corresponds to
> your MySQL server version for the right syntax to use near 'connection
> (\n\tid INTEGER NOT NULL AUTO_INCREMENT, \n\tconn_id VARCHAR(250), \n\tconn'
> at line 1") [SQL: u'\nCREATE TABLE connection (\n\tid INTEGER NOT NULL
> AUTO_INCREMENT, \n\tconn_id VARCHAR(250), \n\tconn_type VARCHAR(500),
> \n\thost VARCHAR(500), \n\t`schema` VARCHAR(500), \n\tlogin VARCHAR(500),
> \n\tpassword VARCHAR(500), \n\tport INTEGER, \n\textra VARCHAR(5000),
> \n\tPRIMARY KEY (id)\n)\n\n']
> {code}
> python 2.7.11,
> mysqlclient 1.3.7,
> sqlalchemy 1.0.12
> mysql Ver 14.14 Distrib 5.5.14, for Linux (x86_64) using EditLine wrapper
> Server version: 5.0.27-max MySQL Community Edition - Experimental
> (GPL)
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
