airflow-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ruslan Dautkhanov (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (AIRFLOW-607) Cannot initdb on Oracle because of String(5000) fields in model
Date Tue, 28 Mar 2017 21:31:41 GMT

    [ https://issues.apache.org/jira/browse/AIRFLOW-607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15945997#comment-15945997
] 

Ruslan Dautkhanov commented on AIRFLOW-607:
-------------------------------------------

[~hokuriku], workaround for 12c databases - enable extended 32k varchar2 :
 https://oracle-base.com/articles/12c/extended-data-types-12cR1 

Although an Airflow fix seems to be easy too.
https://github.com/apache/incubator-airflow/search?utf8=%E2%9C%93&q=5000&type=



> 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)

Mime
View raw message