airflow-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chris Riccomini (JIRA)" <>
Subject [jira] [Commented] (AIRFLOW-107) syntax error when running airflow initdb with mysql connection
Date Wed, 11 May 2016 20:52:12 GMT


Chris Riccomini commented on AIRFLOW-107:

You're running MySQL 5.0.27? This is a 10 year old release. I suspect that SQLAlchemy might
not be working well with this version of MySQL.

> syntax error when running airflow initdb with mysql connection
> --------------------------------------------------------------
>                 Key: AIRFLOW-107
>                 URL:
>             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/", line 226, in execute
>   File "build/bdist.linux-x86_64/egg/MySQLdb/", 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

View raw message