air mysql_airflow + mysql（CentOS7安装MySQL（完整版））

[root@localairflow airflow]# airflow initdb

DB: mysql://airflow:***@192.168.213.200:3306/airflow

[2020-05-27 11:33:18,143] {db.py:378} 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

INFO [alembic.runtime.migration] Running upgrade e3a246e0dc1->1507a7289a2f, create is_encrypted

INFO [alembic.runtime.migration] Running upgrade 1507a7289a2f-> 13eb55f81627, maintain history forcompatibility with earlier migrations

INFO [alembic.runtime.migration] Running upgrade 13eb55f81627->338e90f54d61, More logging into task_instance

INFO [alembic.runtime.migration] Running upgrade 338e90f54d61->52d714495f0, job_id indices

INFO [alembic.runtime.migration] Running upgrade 52d714495f0->502898887f84, Adding extra to Log

INFO [alembic.runtime.migration] Running upgrade 502898887f84->1b38cef5b76e, add dagrun

INFO [alembic.runtime.migration] Running upgrade 1b38cef5b76e->2e541a1dcfed, task_duration

INFO [alembic.runtime.migration] Running upgrade 2e541a1dcfed->40e67319e3a9, dagrun_config

INFO [alembic.runtime.migration] Running upgrade 40e67319e3a9->561833c1c74b, add password column to user

INFO [alembic.runtime.migration] Running upgrade 561833c1c74b->4446e08588, dagrun start end

INFO [alembic.runtime.migration] Running upgrade 4446e08588->bbc73705a13e, Add notification_sent column to sla_miss

INFO [alembic.runtime.migration] Running upgrade bbc73705a13e-> bba5a7cfc896, Add a column to track the encryption state of the 'Extra' field inconnection

INFO [alembic.runtime.migration] Running upgrade bba5a7cfc896->1968acfc09e3, add is_encrypted column to variable table

INFO [alembic.runtime.migration] Running upgrade 1968acfc09e3->2e82aab8ef20, rename user table

INFO [alembic.runtime.migration] Running upgrade 2e82aab8ef20->211e584da130, add TI state index

INFO [alembic.runtime.migration] Running upgrade 211e584da130->64de9cddf6c9, add task fails journal table

INFO [alembic.runtime.migration] Running upgrade 64de9cddf6c9->f2ca10b85618, add dag_stats table

INFO [alembic.runtime.migration] Running upgrade f2ca10b85618->4addfa1236f1, Add fractional seconds to mysql tables

INFO [alembic.runtime.migration] Running upgrade 4addfa1236f1->8504051e801b, xcom dag task indices

INFO [alembic.runtime.migration] Running upgrade 8504051e801b->5e7d17757c7a, add pid field to TaskInstance

INFO [alembic.runtime.migration] Running upgrade 5e7d17757c7a-> 127d2bf2dfa7, Add dag_id/state index on dag_run table

INFO [alembic.runtime.migration] Running upgrade 127d2bf2dfa7->cc1e65623dc7, add max tries column to task instance

INFO [alembic.runtime.migration] Running upgrade cc1e65623dc7->bdaa763e6c56, Make xcom value column a large binary

INFO [alembic.runtime.migration] Running upgrade bdaa763e6c56->947454bf1dff, add ti job_id index

INFO [alembic.runtime.migration] Running upgrade 947454bf1dff-> d2ae31099d61, Increase text size for MySQL (not relevant for other DBs'text types)

INFO [alembic.runtime.migration] Running upgrade d2ae31099d61 -> 0e2a74e0fc9f, Add timezone awareness

INFO [alembic.runtime.migration] Running upgrade d2ae31099d61->33ae817a1ff4, kubernetes_resource_checkpointing

INFO [alembic.runtime.migration] Running upgrade 33ae817a1ff4->27c6a30d7c24, kubernetes_resource_checkpointing

INFO [alembic.runtime.migration] Running upgrade 27c6a30d7c24->86770d1215c0, add kubernetes scheduler uniqueness

INFO [alembic.runtime.migration] Running upgrade 86770d1215c0, 0e2a74e0fc9f->05f30312d566, merge heads

INFO [alembic.runtime.migration] Running upgrade 05f30312d566-> f23433877c24, fix mysql not nullconstraint

INFO [alembic.runtime.migration] Running upgrade f23433877c24->856955da8476, fix sqlite foreign key

INFO [alembic.runtime.migration] Running upgrade 856955da8476-> 9635ae0956e7, index-faskfail

INFO [alembic.runtime.migration] Running upgrade 9635ae0956e7->dd25f486b8ea, add idx_log_dag

INFO [alembic.runtime.migration] Running upgrade dd25f486b8ea->bf00311e1990, add index to taskinstance

INFO [alembic.runtime.migration] Running upgrade 9635ae0956e7->0a2a5b66e19d, add task_reschedule table

INFO [alembic.runtime.migration] Running upgrade 0a2a5b66e19d, bf00311e1990->03bc53e68815, merge_heads_2

INFO [alembic.runtime.migration] Running upgrade 03bc53e68815->41f5f12752f8, add superuser field

INFO [alembic.runtime.migration] Running upgrade 41f5f12752f8->c8ffec048a3b, add fields to dag

INFO [alembic.runtime.migration] Running upgrade c8ffec048a3b->dd4ecb8fbee3, Add schedule interval to dag

INFO [alembic.runtime.migration] Running upgrade dd4ecb8fbee3->939bb1e647c8, task reschedule fk on cascade delete

INFO [alembic.runtime.migration] Running upgrade 939bb1e647c8->6e96a59344a4, Make TaskInstance.pool not nullable

INFO [alembic.runtime.migration] Running upgrade 6e96a59344a4->d38e04c12aa2, add serialized_dag table

Revision ID: d38e04c12aa2

Revises: 6e96a59344a4

Create Date:2019-08-01 14:39:35.616417INFO [alembic.runtime.migration] Running upgrade d38e04c12aa2->b3b105409875, add root_dag_id to DAG

Revision ID: b3b105409875

Revises: d38e04c12aa2

Create Date:2019-09-28 23:20:01.744775INFO [alembic.runtime.migration] Running upgrade 6e96a59344a4-> 74effc47d867, change datetime to datetime2(6) on MSSQL tables

INFO [alembic.runtime.migration] Running upgrade 939bb1e647c8->004c1210f153, increase queue name size limit

INFO [alembic.runtime.migration] Running upgrade c8ffec048a3b->a56c9515abdc, Remove dag_stat table

INFO [alembic.runtime.migration] Running upgrade a56c9515abdc, 004c1210f153, 74effc47d867, b3b105409875->08364691d074, Merge the four heads back together

INFO [alembic.runtime.migration] Running upgrade 08364691d074->fe461863935f, increase_length_for_connection_password

INFO [alembic.runtime.migration] Running upgrade fe461863935f->7939bcff74ba, Add DagTags table

INFO [alembic.runtime.migration] Running upgrade 7939bcff74ba->a4c2fd67d16b, add pool_slots field to task_instance

INFO [alembic.runtime.migration] Running upgrade a4c2fd67d16b->852ae6c715af, Add RenderedTaskInstanceFields table

INFO [alembic.runtime.migration] Running upgrade 852ae6c715af->952da73b5eff, add dag_code table

WARNI [airflow.utils.log.logging_mixin.LoggingMixin] cryptography not found-values will not be stored encrypted.

Done.