[
https://issues.apache.org/jira/browse/AIRFLOW-6443?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17064321#comment-17064321
]
Kaxil Naik commented on AIRFLOW-6443:
-------------------------------------
Assigned 2.0.0 as fix version as we Support MySQL 5.6 in Airflow 1.10.* and
this PR fails test on it.
{noformat}
INFO [alembic.runtime.migration] Running upgrade a4c2fd67d16b -> b25a55525161,
Increase length of pool name
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line
1248, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py",
line 588, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 255,
in execute
self.errorhandler(self, exc, value)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line
50, in defaulterrorhandler
raise errorvalue
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 252,
in execute
res = self._query(query)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 378,
in _query
db.query(q)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line
280, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1071, 'Specified key was too long; max key
length is 767 bytes')
The above exception was the direct cause of the following exception:
{noformat}
There are some workarounds but this might most-likely break existing DBs:
https://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes
> Pool name - increase length > 50, make cli give error if too large
> ------------------------------------------------------------------
>
> Key: AIRFLOW-6443
> URL: https://issues.apache.org/jira/browse/AIRFLOW-6443
> Project: Apache Airflow
> Issue Type: Improvement
> Components: cli, database, models
> Affects Versions: 1.10.3
> Reporter: t oo
> Assignee: Ephraim E Anierobi
> Priority: Major
> Labels: gsoc, gsoc2020, mentor, pool
> Fix For: 2.0.0
>
>
> create some pool names (using cli) with 70 or 80 character length
>
> 1. UI does not allow creating > 50 length but why does cli?
> click on one of the pool names listed (link is cut to 50 char name:
> [https://domain:8080/admin/airflow/task?flt1_pool_equals=qjfdal_CRCE_INTERCONNECTION_FORECAST_TNC_EJFLSA_LP)]
> If click 'edit' it shows full 80chars in Description but cut 50chars in Pool
> 2. why limit to 50 length at all? should be increased - say 256
> 3. if trying to create really large length (more than models length) then cli
> should give error
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
