[
https://issues.apache.org/jira/browse/AIRFLOW-607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15622849#comment-15622849
]
Siddharth Anand commented on AIRFLOW-607:
-----------------------------------------
Please submit a PR for this. I don't suspect we have a lot of Oracle users in
the community so haven't seen this reported before now.
We use SQLAlchemy to generate the columns.
-s
> 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)
