ashb commented on issue #5430: [AIRFLOW-4810] Bump supported mysqlclient to <1.5 URL: https://github.com/apache/airflow/pull/5430#issuecomment-503466608 If you view the raw log for the failed test and search for " FAIL:" you see this ``` 74) FAIL: test_database_schema_and_sqlalchemy_model_are_in_sync (tests.utils.test_db.DbTest) ---------------------------------------------------------------------- Traceback (most recent call last): tests/utils/test_db.py line 98 in test_database_schema_and_sqlalchemy_model_are_in_sync 'Database schema and SQLAlchemy model are not in sync: ' + str(diff) AssertionError: [('remove_table', Table('test_airflow', MetaData(bind=None), Column('dummy', VARCHAR(length=50), table=<test_airflow>), schema=None)), ('remove_table', Table('test_mysql_to_mysql', MetaData(bind=None), Column('TABLE_CATALOG', VARCHAR(length=512), table=<test_mysql_to_mysql>, nullable=False, server_default=DefaultClause(<sqlalchemy.sql.elements.TextClause object at 0x7f0aff565d68>, for_update=False)), Column('TABLE_SCHEMA', VARCHAR(length=64), table=<test_mysql_to_mysql>, nullable=False, server_default=DefaultClause(<sqlalchemy.sql.elements.TextClause object at 0x7f0aff565b00>, for_update=False)), Column('TABLE_NAME', VARCHAR(length=64), table=<test_mysql_to_mysql>, nullable=False, server_default=DefaultClause(<sqlalchemy.sql.elements.TextClause object at 0x7f0aff5651d0>, for_update=False)), Column('TABLE_TYPE', VARCHAR(length=64), table=<test_mysql_to_mysql>, nullable=False, server_default=DefaultClause(<sqlalchemy.sql.elements.TextClause object at 0x7f0aff565b38>, for_update=False)), Column('ENGINE', VARCHAR(length=64), table=<test_mysql_to_mysql>), Column('VERSION', BIGINT(display_width=21, unsigned=True), table=<test_mysql_to_mysql>), Column('ROW_FORMAT', VARCHAR(length=10), table=<test_mysql_to_mysql>), Column('TABLE_ROWS', BIGINT(display_width=21, unsigned=True), table=<test_mysql_to_mysql>), Column('AVG_ROW_LENGTH', BIGINT(display_width=21, unsigned=True), table=<test_mysql_to_mysql>), Column('DATA_LENGTH', BIGINT(display_width=21, unsigned=True), table=<test_mysql_to_mysql>), Column('MAX_DATA_LENGTH', BIGINT(display_width=21, unsigned=True), table=<test_mysql_to_mysql>), Column('INDEX_LENGTH', BIGINT(display_width=21, unsigned=True), table=<test_mysql_to_mysql>), Column('DATA_FREE', BIGINT(display_width=21, unsigned=True), table=<test_mysql_to_mysql>), Column('AUTO_INCREMENT', BIGINT(display_width=21, unsigned=True), table=<test_mysql_to_mysql>), Column('CREATE_TIME', DATETIME(), table=<test_mysql_to_mysql>), Column('UPDATE_TIME', DATETIME(), table=<test_mysql_to_mysql>), Column('CHECK_TIME', DATETIME(), table=<test_mysql_to_mysql>), Column('TABLE_COLLATION', VARCHAR(length=32), table=<test_mysql_to_mysql>), Column('CHECKSUM', BIGINT(display_width=21, unsigned=True), table=<test_mysql_to_mysql>), Column('CREATE_OPTIONS', VARCHAR(length=255), table=<test_mysql_to_mysql>), Column('TABLE_COMMENT', VARCHAR(length=2048), table=<test_mysql_to_mysql>, nullable=False, server_default=DefaultClause(<sqlalchemy.sql.elements.TextClause object at 0x7f0aff5655c0>, for_update=False)), schema=None))] is not false : Database schema and SQLAlchemy model are not in sync: [('remove_table', Table('test_airflow', MetaData(bind=None), Column('dummy', VARCHAR(length=50), table=<test_airflow>), schema=None)), ('remove_table', Table('test_mysql_to_mysql', MetaData(bind=None), Column('TABLE_CATALOG', VARCHAR(length=512), table=<test_mysql_to_mysql>, nullable=False, server_default=DefaultClause(<sqlalchemy.sql.elements.TextClause object at 0x7f0aff565d68>, for_update=False)), Column('TABLE_SCHEMA', VARCHAR(length=64), table=<test_mysql_to_mysql>, nullable=False, server_default=DefaultClause(<sqlalchemy.sql.elements.TextClause object at 0x7f0aff565b00>, for_update=False)), Column('TABLE_NAME', VARCHAR(length=64), table=<test_mysql_to_mysql>, nullable=False, server_default=DefaultClause(<sqlalchemy.sql.elements.TextClause object at 0x7f0aff5651d0>, for_update=False)), Column('TABLE_TYPE', VARCHAR(length=64), table=<test_mysql_to_mysql>, nullable=False, server_default=DefaultClause(<sqlalchemy.sql.elements.TextClause object at 0x7f0aff565b38>, for_update=False)), Column('ENGINE', VARCHAR(length=64), table=<test_mysql_to_mysql>), Column('VERSION', BIGINT(display_width=21, unsigned=True), table=<test_mysql_to_mysql>), Column('ROW_FORMAT', VARCHAR(length=10), table=<test_mysql_to_mysql>), Column('TABLE_ROWS', BIGINT(display_width=21, unsigned=True), table=<test_mysql_to_mysql>), Column('AVG_ROW_LENGTH', BIGINT(display_width=21, unsigned=True), table=<test_mysql_to_mysql>), Column('DATA_LENGTH', BIGINT(display_width=21, unsigned=True), table=<test_mysql_to_mysql>), Column('MAX_DATA_LENGTH', BIGINT(display_width=21, unsigned=True), table=<test_mysql_to_mysql>), Column('INDEX_LENGTH', BIGINT(display_width=21, unsigned=True), table=<test_mysql_to_mysql>), Column('DATA_FREE', BIGINT(display_width=21, unsigned=True), table=<test_mysql_to_mysql>), Column('AUTO_INCREMENT', BIGINT(display_width=21, unsigned=True), table=<test_mysql_to_mysql>), Column('CREATE_TIME', DATETIME(), table=<test_mysql_to_mysql>), Column('UPDATE_TIME', DATETIME(), table=<test_mysql_to_mysql>), Column('CHECK_TIME', DATETIME(), table=<test_mysql_to_mysql>), Column('TABLE_COLLATION', VARCHAR(length=32), table=<test_mysql_to_mysql>), Column('CHECKSUM', BIGINT(display_width=21, unsigned=True), table=<test_mysql_to_mysql>), Column('CREATE_OPTIONS', VARCHAR(length=255), table=<test_mysql_to_mysql>), Column('TABLE_COMMENT', VARCHAR(length=2048), table=<test_mysql_to_mysql>, nullable=False, server_default=DefaultClause(<sqlalchemy.sql.elements.TextClause object at 0x7f0aff5655c0>, for_update=False)), schema=None))] ``` So this implies something about the mysql client behaviour has changed.
---------------------------------------------------------------- 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: [email protected] With regards, Apache Git Services
