You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by GitBox <gi...@apache.org> on 2020/07/06 18:26:41 UTC

[GitHub] [airflow] prasanthbangs2016 opened a new issue #9700: _mysql_exceptions.OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')

prasanthbangs2016 opened a new issue #9700:
URL: https://github.com/apache/airflow/issues/9700


   PS C:\Users\prasanth\Desktop\p> docker logs -f 5b560ac952ff
   [2020-07-06 18:24:00,905] {{settings.py:253}} INFO - settings.configure_orm(): Using pool settings. pool_size=5, max_overflow=10, pool_recycle=1800, pid=13
   DB: mysql://TrueDataAdmin:***@truedata-aurora-test.cluster-cnvi8lcgayl4.us-west-2.rds.amazonaws.com:3306/prashanth_airflow
   [2020-07-06 18:24:01,919] {{db.py:368}} INFO - Creating tables
   INFO  [alembic.runtime.migration] Context impl MySQLImpl.
   INFO  [alembic.runtime.migration] Will assume non-transactional DDL.
   INFO  [alembic.runtime.migration] Running upgrade  -> e3a246e0dc1, current schema
   Traceback (most recent call last):
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1248, in _execute_context
       cursor, statement, parameters, context
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 588, in do_execute
       cursor.execute(statement, parameters)
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/cursors.py", line 255, in execute
       self.errorhandler(self, exc, value)
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
       raise errorvalue
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/cursors.py", line 252, in execute
       res = self._query(query)
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/cursors.py", line 378, in _query
       db.query(q)
     File "/usr/local/lib/python3.7/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:
   
   Traceback (most recent call last):
     File "/usr/local/bin/airflow", line 37, in <module>
       args.func(args)
     File "/usr/local/lib/python3.7/site-packages/airflow/bin/cli.py", line 1140, in initdb
       db.initdb(settings.RBAC)
     File "/usr/local/lib/python3.7/site-packages/airflow/utils/db.py", line 106, in initdb
       upgradedb()
     File "/usr/local/lib/python3.7/site-packages/airflow/utils/db.py", line 376, in upgradedb
       command.upgrade(config, 'heads')
     File "/usr/local/lib/python3.7/site-packages/alembic/command.py", line 298, in upgrade
       script.run_env()
     File "/usr/local/lib/python3.7/site-packages/alembic/script/base.py", line 489, in run_env
       util.load_python_file(self.dir, "env.py")
     File "/usr/local/lib/python3.7/site-packages/alembic/util/pyfiles.py", line 98, in load_python_file
       module = load_module_py(module_id, path)
     File "/usr/local/lib/python3.7/site-packages/alembic/util/compat.py", line 184, in load_module_py
       spec.loader.exec_module(module)
     File "<frozen importlib._bootstrap_external>", line 728, in exec_module
     File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
     File "/usr/local/lib/python3.7/site-packages/airflow/migrations/env.py", line 96, in <module>
       run_migrations_online()
     File "/usr/local/lib/python3.7/site-packages/airflow/migrations/env.py", line 90, in run_migrations_online
       context.run_migrations()
     File "<string>", line 8, in run_migrations
     File "/usr/local/lib/python3.7/site-packages/alembic/runtime/environment.py", line 846, in run_migrations
       self.get_context().run_migrations(**kw)
     File "/usr/local/lib/python3.7/site-packages/alembic/runtime/migration.py", line 520, in run_migrations
       step.migration_fn(**kw)
     File "/usr/local/lib/python3.7/site-packages/airflow/migrations/versions/e3a246e0dc1_current_schema.py", line 73, in upgrade
       sa.PrimaryKeyConstraint('dag_id')
     File "<string>", line 8, in create_table
     File "<string>", line 3, in create_table
     File "/usr/local/lib/python3.7/site-packages/alembic/operations/ops.py", line 1252, in create_table
       return operations.invoke(op)
     File "/usr/local/lib/python3.7/site-packages/alembic/operations/base.py", line 374, in invoke
       return fn(self, operation)
     File "/usr/local/lib/python3.7/site-packages/alembic/operations/toimpl.py", line 101, in create_table
       operations.impl.create_table(table)
     File "/usr/local/lib/python3.7/site-packages/alembic/ddl/impl.py", line 258, in create_table
       self._exec(schema.CreateTable(table))
     File "/usr/local/lib/python3.7/site-packages/alembic/ddl/impl.py", line 140, in _exec
       return conn.execute(construct, *multiparams, **params)
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 984, in execute
       return meth(self, multiparams, params)
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection
       return connection._execute_ddl(self, multiparams, params)
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1046, in _execute_ddl
       compiled,
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1288, in _execute_context
       e, statement, parameters, cursor, context
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1482, in _handle_dbapi_exception
       sqlalchemy_exception, with_traceback=exc_info[2], from_=e
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 178, in raise_
       raise exception
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1248, in _execute_context
       cursor, statement, parameters, context
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 588, in do_execute
       cursor.execute(statement, parameters)
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/cursors.py", line 255, in execute
       self.errorhandler(self, exc, value)
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
       raise errorvalue
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/cursors.py", line 252, in execute
       res = self._query(query)
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/cursors.py", line 378, in _query
       db.query(q)
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/connections.py", line 280, in query
       _mysql.connection.query(self, query)
   sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1071, 'Specified key was too long; max key length is 767 bytes')
   [SQL:
   CREATE TABLE dag (
           dag_id VARCHAR(250) NOT NULL,
           is_paused BOOL,
           is_subdag BOOL,
           is_active BOOL,
           last_scheduler_run DATETIME,
           last_pickled DATETIME,
           last_expired DATETIME,
           scheduler_lock BOOL,
           pickle_id INTEGER,
           fileloc VARCHAR(2000),
           owners VARCHAR(2000),
           PRIMARY KEY (dag_id),
           CHECK (is_paused IN (0, 1)),
           CHECK (is_subdag IN (0, 1)),
           CHECK (is_active IN (0, 1)),
           CHECK (scheduler_lock IN (0, 1))
   )
   
   ]
   (Background on this error at: http://sqlalche.me/e/e3q8)
   [2020-07-06 18:24:11,231] {{settings.py:253}} INFO - settings.configure_orm(): Using pool settings. pool_size=5, max_overflow=10, pool_recycle=1800, pid=1
   [2020-07-06 18:24:11,267] {{settings.py:253}} INFO - settings.configure_orm(): Using pool settings. pool_size=5, max_overflow=10, pool_recycle=1800, pid=17
   [2020-07-06 18:24:18,405] {{cli_action_loggers.py:107}} WARNING - Failed to log action with (_mysql_exceptions.ProgrammingError) (1146, "Table 'prashanth_airflow.log' doesn't exist")
   [SQL: INSERT INTO log (dttm, dag_id, task_id, event, execution_date, owner, extra) VALUES (%s, %s, %s, %s, %s, %s, %s)]
   [parameters: (datetime.datetime(2020, 7, 6, 18, 24, 13, 55847, tzinfo=<Timezone [UTC]>), None, None, 'cli_webserver', None, 'airflow', '{"host_name": "5b560ac952ff", "full_command": "[\'/usr/local/bin/airflow\', \'webserver\']"}')]
   (Background on this error at: http://sqlalche.me/e/f405)
     ____________       _____________
    ____    |__( )_________  __/__  /________      __
   ____  /| |_  /__  ___/_  /_ __  /_  __ \_ | /| / /
   ___  ___ |  / _  /   _  __/ _  / / /_/ /_ |/ |/ /
    _/_/  |_/_/  /_/    /_/    /_/  \____/____/|__/
   [2020-07-06 18:24:18,604] {{cli_action_loggers.py:107}} WARNING - Failed to log action with (_mysql_exceptions.ProgrammingError) (1146, "Table 'prashanth_airflow.log' doesn't exist")
   [SQL: INSERT INTO log (dttm, dag_id, task_id, event, execution_date, owner, extra) VALUES (%s, %s, %s, %s, %s, %s, %s)]
   [parameters: (datetime.datetime(2020, 7, 6, 18, 24, 13, 213461, tzinfo=<Timezone [UTC]>), None, None, 'cli_scheduler', None, 'airflow', '{"host_name": "5b560ac952ff", "full_command": "[\'/usr/local/bin/airflow\', \'scheduler\']"}')]
   (Background on this error at: http://sqlalche.me/e/f405)
     ____________       _____________
    ____    |__( )_________  __/__  /________      __
   ____  /| |_  /__  ___/_  /_ __  /_  __ \_ | /| / /
   ___  ___ |  / _  /   _  __/ _  / / /_/ /_ |/ |/ /
    _/_/  |_/_/  /_/    /_/    /_/  \____/____/|__/
   [2020-07-06 18:24:18,606] {{__init__.py:51}} INFO - Using executor SequentialExecutor
   [2020-07-06 18:24:18,667] {{__init__.py:51}} INFO - Using executor SequentialExecutor
   [2020-07-06 18:24:18,668] {{dagbag.py:403}} INFO - Filling up the DagBag from /usr/local/airflow/dags
   Traceback (most recent call last):
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1248, in _execute_context
       cursor, statement, parameters, context
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 588, in do_execute
       cursor.execute(statement, parameters)
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/cursors.py", line 255, in execute
       self.errorhandler(self, exc, value)
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
       raise errorvalue
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/cursors.py", line 252, in execute
       res = self._query(query)
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/cursors.py", line 378, in _query
       db.query(q)
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/connections.py", line 280, in query
       _mysql.connection.query(self, query)
   _mysql_exceptions.ProgrammingError: (1146, "Table 'prashanth_airflow.job' doesn't exist")
   
   The above exception was the direct cause of the following exception:
   
   Traceback (most recent call last):
     File "/usr/local/bin/airflow", line 37, in <module>
       args.func(args)
     File "/usr/local/lib/python3.7/site-packages/airflow/utils/cli.py", line 75, in wrapper
       return f(*args, **kwargs)
     File "/usr/local/lib/python3.7/site-packages/airflow/bin/cli.py", line 1040, in scheduler
       job.run()
     File "/usr/local/lib/python3.7/site-packages/airflow/jobs/base_job.py", line 215, in run
       session.commit()
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 1036, in commit
       self.transaction.commit()
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 503, in commit
       self._prepare_impl()
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 482, in _prepare_impl
       self.session.flush()
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2496, in flush
       self._flush(objects)
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2637, in _flush
       transaction.rollback(_capture_exception=True)
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 69, in __exit__
       exc_value, with_traceback=exc_tb,
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 178, in raise_
       raise exception
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2597, in _flush
       flush_context.execute()
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/unitofwork.py", line 422, in execute
       rec.execute(self)
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/unitofwork.py", line 589, in execute
       uow,
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/persistence.py", line 245, in save_obj
       insert,
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/persistence.py", line 1136, in _emit_insert_statements
       statement, params
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 984, in execute
       return meth(self, multiparams, params)
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 293, in _execute_on_connection
       return connection._execute_clauseelement(self, multiparams, params)
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1103, in _execute_clauseelement
       distilled_params,
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1288, in _execute_context
       e, statement, parameters, cursor, context
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1482, in _handle_dbapi_exception
       sqlalchemy_exception, with_traceback=exc_info[2], from_=e
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 178, in raise_
       raise exception
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1248, in _execute_context
       cursor, statement, parameters, context
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 588, in do_execute
       cursor.execute(statement, parameters)
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/cursors.py", line 255, in execute
       self.errorhandler(self, exc, value)
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
       raise errorvalue
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/cursors.py", line 252, in execute
       res = self._query(query)
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/cursors.py", line 378, in _query
       db.query(q)
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/connections.py", line 280, in query
       _mysql.connection.query(self, query)
   sqlalchemy.exc.ProgrammingError: (_mysql_exceptions.ProgrammingError) (1146, "Table 'prashanth_airflow.job' doesn't exist")
   [SQL: INSERT INTO job (dag_id, state, job_type, start_date, end_date, latest_heartbeat, executor_class, hostname, unixname) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)]
   [parameters: (None, 'running', 'SchedulerJob', datetime.datetime(2020, 7, 6, 18, 24, 18, 608905, tzinfo=<Timezone [UTC]>), None, datetime.datetime(2020, 7, 6, 18, 24, 18, 608938, tzinfo=<Timezone [UTC]>), 'NoneType', '5b560ac952ff', 'airflow')]
   (Background on this error at: http://sqlalche.me/e/f405)
   Running the Gunicorn Server with:
   Workers: 4 sync
   Host: 0.0.0.0:8080
   Timeout: 120
   Logfiles: - -
   =================================================================
   [2020-07-06 18:24:21,892] {{settings.py:253}} INFO - settings.configure_orm(): Using pool settings. pool_size=5, max_overflow=10, pool_recycle=1800, pid=24
   [2020-07-06 18:24:21 +0000] [24] [INFO] Starting gunicorn 19.10.0
   [2020-07-06 18:24:21 +0000] [24] [INFO] Listening at: http://0.0.0.0:8080 (24)
   [2020-07-06 18:24:21 +0000] [24] [INFO] Using worker: sync
   [2020-07-06 18:24:21 +0000] [27] [INFO] Booting worker with pid: 27
   [2020-07-06 18:24:21 +0000] [28] [INFO] Booting worker with pid: 28
   [2020-07-06 18:24:22 +0000] [29] [INFO] Booting worker with pid: 29
   [2020-07-06 18:24:22 +0000] [30] [INFO] Booting worker with pid: 30
   [2020-07-06 18:24:23,664] {{__init__.py:51}} INFO - Using executor SequentialExecutor
   [2020-07-06 18:24:23,674] {{dagbag.py:403}} INFO - Filling up the DagBag from /usr/local/airflow/dags
   [2020-07-06 18:24:23,695] {{__init__.py:51}} INFO - Using executor SequentialExecutor
   [2020-07-06 18:24:23,702] {{dagbag.py:403}} INFO - Filling up the DagBag from /usr/local/airflow/dags
   [2020-07-06 18:24:23,762] {{__init__.py:51}} INFO - Using executor SequentialExecutor
   [2020-07-06 18:24:23,764] {{dagbag.py:403}} INFO - Filling up the DagBag from /usr/local/airflow/dags
   [2020-07-06 18:24:23,770] {{__init__.py:51}} INFO - Using executor SequentialExecutor
   [2020-07-06 18:24:23,773] {{dagbag.py:403}} INFO - Filling up the DagBag from /usr/local/airflow/dags
   [2020-07-06 18:24:58,395] {{app.py:1892}} ERROR - Exception on /admin/ [GET]
   Traceback (most recent call last):
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1248, in _execute_context
       cursor, statement, parameters, context
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 588, in do_execute
       cursor.execute(statement, parameters)
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/cursors.py", line 255, in execute
       self.errorhandler(self, exc, value)
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
       raise errorvalue
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/cursors.py", line 252, in execute
       res = self._query(query)
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/cursors.py", line 378, in _query
       db.query(q)
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/connections.py", line 280, in query
       _mysql.connection.query(self, query)
   _mysql_exceptions.ProgrammingError: (1146, "Table 'prashanth_airflow.dag' doesn't exist")
   
   The above exception was the direct cause of the following exception:
   
   Traceback (most recent call last):
     File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 2447, in wsgi_app
       response = self.full_dispatch_request()
     File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1952, in full_dispatch_request
       rv = self.handle_user_exception(e)
     File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1821, in handle_user_exception
       reraise(exc_type, exc_value, tb)
     File "/usr/local/lib/python3.7/site-packages/flask/_compat.py", line 39, in reraise
       raise value
     File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1950, in full_dispatch_request
       rv = self.dispatch_request()
     File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1936, in dispatch_request
       return self.view_functions[rule.endpoint](**req.view_args)
     File "/usr/local/lib/python3.7/site-packages/flask_admin/base.py", line 69, in inner
       return self._run_view(f, *args, **kwargs)
     File "/usr/local/lib/python3.7/site-packages/flask_admin/base.py", line 368, in _run_view
       return fn(self, *args, **kwargs)
     File "/usr/local/lib/python3.7/site-packages/flask_login/utils.py", line 258, in decorated_view
       return func(*args, **kwargs)
     File "/usr/local/lib/python3.7/site-packages/airflow/utils/db.py", line 74, in wrapper
       return func(*args, **kwargs)
     File "/usr/local/lib/python3.7/site-packages/airflow/www/views.py", line 2258, in index
       dags = query.offset(start).limit(dags_per_page).all()
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3244, in all
       return list(self)
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3403, in __iter__
       return self._execute_and_instances(context)
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3428, in _execute_and_instances
       result = conn.execute(querycontext.statement, self._params)
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 984, in execute
       return meth(self, multiparams, params)
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 293, in _execute_on_connection
       return connection._execute_clauseelement(self, multiparams, params)
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1103, in _execute_clauseelement
       distilled_params,
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1288, in _execute_context
       e, statement, parameters, cursor, context
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1482, in _handle_dbapi_exception
       sqlalchemy_exception, with_traceback=exc_info[2], from_=e
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 178, in raise_
       raise exception
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1248, in _execute_context
       cursor, statement, parameters, context
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 588, in do_execute
       cursor.execute(statement, parameters)
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/cursors.py", line 255, in execute
       self.errorhandler(self, exc, value)
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
       raise errorvalue
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/cursors.py", line 252, in execute
       res = self._query(query)
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/cursors.py", line 378, in _query
       db.query(q)
     File "/usr/local/lib/python3.7/site-packages/MySQLdb/connections.py", line 280, in query
       _mysql.connection.query(self, query)
   sqlalchemy.exc.ProgrammingError: (_mysql_exceptions.ProgrammingError) (1146, "Table 'prashanth_airflow.dag' doesn't exist")
   [SQL: SELECT dag.dag_id AS dag_dag_id, dag.root_dag_id AS dag_root_dag_id, dag.is_paused AS dag_is_paused, dag.is_subdag AS dag_is_subdag, dag.is_active AS dag_is_active, dag.last_scheduler_run AS dag_last_scheduler_run, dag.last_pickled AS dag_last_pickled, dag.last_expired AS dag_last_expired, dag.scheduler_lock AS dag_scheduler_lock, dag.pickle_id AS dag_pickle_id, dag.fileloc AS dag_fileloc, dag.owners AS dag_owners, dag.description AS dag_description, dag.default_view AS dag_default_view, dag.schedule_interval AS dag_schedule_interval
   FROM dag
   WHERE dag.is_subdag = 0 AND dag.is_active = 1 ORDER BY dag.dag_id
    LIMIT %s, %s]
   [parameters: (0, 100)]
   (Background on this error at: http://sqlalche.me/e/f405)
   172.17.0.1 - - [06/Jul/2020:18:24:58 +0000] "GET /admin/ HTTP/1.1" 500 7676 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.116 Safari/537.36"
   [2020-07-06 18:25:00 +0000] [24] [INFO] Handling signal: ttin
   [2020-07-06 18:25:00 +0000] [35] [INFO] Booting worker with pid: 35
   [2020-07-06 18:25:00,962] {{__init__.py:51}} INFO - Using executor SequentialExecutor
   [2020-07-06 18:25:00,963] {{dagbag.py:403}} INFO - Filling up the DagBag from /usr/local/airflow/dags
   [2020-07-06 18:25:07 +0000] [24] [INFO] Handling signal: ttou
   [2020-07-06 18:25:07 +0000] [27] [INFO] Worker exiting (pid: 27)
   [2020-07-06 18:25:37 +0000] [24] [INFO] Handling signal: ttin
   [2020-07-06 18:25:37 +0000] [37] [INFO] Booting worker with pid: 37
   [2020-07-06 18:25:38,572] {{__init__.py:51}} INFO - Using executor SequentialExecutor
   [2020-07-06 18:25:38,573] {{dagbag.py:403}} INFO - Filling up the DagBag from /usr/local/airflow/dags
   [2020-07-06 18:25:44 +0000] [24] [INFO] Handling signal: ttou
   [2020-07-06 18:25:44 +0000] [28] [INFO] Worker exiting (pid: 28)
   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [airflow] kaxil closed issue #9700: _mysql_exceptions.OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')

Posted by GitBox <gi...@apache.org>.
kaxil closed issue #9700:
URL: https://github.com/apache/airflow/issues/9700


   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [airflow] mik-laj commented on issue #9700: _mysql_exceptions.OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')

Posted by GitBox <gi...@apache.org>.
mik-laj commented on issue #9700:
URL: https://github.com/apache/airflow/issues/9700#issuecomment-654503157


   Here is fix: https://github.com/apache/airflow/pull/7570


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [airflow] boring-cyborg[bot] commented on issue #9700: _mysql_exceptions.OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')

Posted by GitBox <gi...@apache.org>.
boring-cyborg[bot] commented on issue #9700:
URL: https://github.com/apache/airflow/issues/9700#issuecomment-654395483


   Thanks for opening your first issue here! Be sure to follow the issue template!
   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org