airflow-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paul Luong (JIRA)" <j...@apache.org>
Subject [jira] [Created] (AIRFLOW-607) Cannot initdb on Oracle because of String(5000) fields in model
Date Mon, 31 Oct 2016 16:26:59 GMT
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)

Mime
View raw message