[jira] [Created] (AIRFLOW-607) Cannot initdb on Oracle because of String(5000) fields in model

["Paul Luong (JIRA)" <ji...@apache.org>]

Paul Luong created AIRFLOW-607:
----------------------------------

             Summary: Cannot initdb on Oracle because of String(5000) fields in model
                 Key: AIRFLOW-607
                 URL: https://issues.apache.org/jira/browse/AIRFLOW-607
             Project: Apache Airflow
          Issue Type: Bug
    Affects Versions: Airflow 1.7.1.3
            Reporter: Paul Luong
            Priority: Blocker


Unfortunately Oracle cannot be used to host the Airflow application DB due to the fact that Oracle limits varchar data types to 4000 bytes.

If you try to run the airflow initdb command to install the DB onto Oracle you will end up with the following error: 

sqlalchemy.exc.DatabaseError: (cx_Oracle.DatabaseError) ORA-00910: specified length too long for its datatype
 [SQL: '\nCREATE TABLE connection (\n\tid INTEGER NOT NULL, \n\tconn_id VARCHAR2(250 CHAR), \n\tconn_type VARCHAR2(500 CHAR), \n\thost VARCHAR2(500 CHAR), \n\tschema VARCHAR2(500 CHAR), \n\tlogin VARCHAR2(500 CHAR), \n\tpassword VARCHAR2(500 CHAR), \n\tport INTEGER, \n\textra VARCHAR2(5000 CHAR), \n\tPRIMARY KEY (id)\n)\n\n']

Request that we change String(5000) types in the Chart and Connection models to 4000. 

Thanks!



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)