[ https://issues.apache.org/jira/browse/AIRFLOW-607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bolke de Bruin resolved AIRFLOW-607. ------------------------------------ Resolution: Won't Fix Oracle is not a supported backend DB. We will accept a PR for this, but it is not a blocker/bug to us. > 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 > Assignee: 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.15#6346)