Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 07075200B20 for ; Wed, 11 May 2016 21:50:19 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 056C3160A19; Wed, 11 May 2016 19:50:19 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 4D2AE160A17 for ; Wed, 11 May 2016 21:50:18 +0200 (CEST) Received: (qmail 98980 invoked by uid 500); 11 May 2016 19:50:17 -0000 Mailing-List: contact commits-help@airflow.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@airflow.incubator.apache.org Delivered-To: mailing list commits@airflow.incubator.apache.org Received: (qmail 98971 invoked by uid 99); 11 May 2016 19:50:17 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 May 2016 19:50:17 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 21D68C81EF for ; Wed, 11 May 2016 19:50:17 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -5.436 X-Spam-Level: X-Spam-Status: No, score=-5.436 tagged_above=-999 required=6.31 tests=[KAM_LAZY_DOMAIN_SECURITY=1, RCVD_IN_DNSWL_HI=-5, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RP_MATCHES_RCVD=-1.416] autolearn=disabled Received: from mx2-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id jr78a0lwqu5O for ; Wed, 11 May 2016 19:50:15 +0000 (UTC) Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx2-lw-eu.apache.org (ASF Mail Server at mx2-lw-eu.apache.org) with SMTP id 6AC475FB2C for ; Wed, 11 May 2016 19:50:14 +0000 (UTC) Received: (qmail 98257 invoked by uid 99); 11 May 2016 19:50:13 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 May 2016 19:50:13 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id DDAD02C1F68 for ; Wed, 11 May 2016 19:50:12 +0000 (UTC) Date: Wed, 11 May 2016 19:50:12 +0000 (UTC) From: "James Yoo (JIRA)" To: commits@airflow.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (AIRFLOW-107) syntax error when running airflow initdb with mysql connection MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Wed, 11 May 2016 19:50:19 -0000 James Yoo created AIRFLOW-107: --------------------------------- Summary: 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.4#6332)