potiuk commented on issue #11543: URL: https://github.com/apache/airflow/issues/11543#issuecomment-713544274
We have the first Deadlock with more information (on my PR): https://github.com/apache/airflow/pull/11659/checks?check_run_id=1286626048 ``` docker logs docker-compose_mysql_1 Warning: 1T12:13:45.327151Z 0 [Warning] InnoDB: New log files created, LSN=45790 Warning: 1T12:13:45.529998Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. Warning: 1T12:13:45.536107Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: ddfdefd0-1396-11eb-b63d-0242ac120002. Warning: 1T12:13:45.536994Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. Warning: 1T12:13:46.395368Z 0 [Warning] CA certificate ca.pem is self signed. Warning: 1T12:13:46.676996Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. Warning: 1T12:13:48.763110Z 0 [Warning] Insecure configuration for --secure-file-priv: Data directory is accessible through --secure-file-priv. Consider choosing a different directory. Warning: 1T12:13:48.763169Z 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory. 2020-10-21T12:13:48.763199Z 0 [Note] mysqld (mysqld 5.7.32) starting as process 78 ... 2020-10-21T12:13:48.766314Z 0 [Note] InnoDB: PUNCH HOLE support available 2020-10-21T12:13:48.766333Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-10-21T12:13:48.766337Z 0 [Note] InnoDB: Uses event mutexes 2020-10-21T12:13:48.766340Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2020-10-21T12:13:48.766342Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-10-21T12:13:48.766345Z 0 [Note] InnoDB: Using Linux native AIO 2020-10-21T12:13:48.766602Z 0 [Note] InnoDB: Number of pools: 1 2020-10-21T12:13:48.766721Z 0 [Note] InnoDB: Using CPU crc32 instructions 2020-10-21T12:13:48.768615Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-10-21T12:13:48.777325Z 0 [Note] InnoDB: Completed initialization of buffer pool 2020-10-21T12:13:48.780120Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-10-21T12:13:48.792424Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2020-10-21T12:13:48.799564Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-10-21T12:13:48.799614Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-10-21T12:13:48.912728Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-10-21T12:13:48.913728Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2020-10-21T12:13:48.913751Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2020-10-21T12:13:48.914971Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2747371 2020-10-21T12:13:48.915829Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2020-10-21T12:13:48.916133Z 0 [Note] Plugin 'FEDERATED' is disabled. 2020-10-21T12:13:48.917666Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201021 12:13:48 2020-10-21T12:13:48.922794Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2020-10-21T12:13:48.922812Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. Warning: 1T12:13:48.923346Z 0 [Warning] CA certificate ca.pem is self signed. 2020-10-21T12:13:48.923378Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. Warning: 1T12:13:48.924897Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory. 2020-10-21T12:13:48.932039Z 0 [Note] Event Scheduler: Loaded 0 events 2020-10-21T12:13:48.932212Z 0 [Note] mysqld: ready for connections. Version: '5.7.32' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server (GPL) Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it. 2020-10-21T12:13:51.958028Z 0 [Note] Giving 0 client threads a chance to die gracefully 2020-10-21T12:13:51.958054Z 0 [Note] Shutting down slave threads 2020-10-21T12:13:51.958058Z 0 [Note] Forcefully disconnecting 0 remaining clients 2020-10-21T12:13:51.958063Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2020-10-21T12:13:51.958104Z 0 [Note] Binlog end 2020-10-21T12:13:51.958564Z 0 [Note] Shutting down plugin 'ngram' 2020-10-21T12:13:51.958577Z 0 [Note] Shutting down plugin 'partition' 2020-10-21T12:13:51.958580Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2020-10-21T12:13:51.958583Z 0 [Note] Shutting down plugin 'ARCHIVE' 2020-10-21T12:13:51.958585Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2020-10-21T12:13:51.958612Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2020-10-21T12:13:51.958620Z 0 [Note] Shutting down plugin 'MyISAM' 2020-10-21T12:13:51.958626Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2020-10-21T12:13:51.958628Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2020-10-21T12:13:51.958631Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2020-10-21T12:13:51.958633Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2020-10-21T12:13:51.958636Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2020-10-21T12:13:51.958638Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2020-10-21T12:13:51.958641Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2020-10-21T12:13:51.958643Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2020-10-21T12:13:51.958645Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2020-10-21T12:13:51.958648Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2020-10-21T12:13:51.958650Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2020-10-21T12:13:51.958652Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2020-10-21T12:13:51.958654Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2020-10-21T12:13:51.958656Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2020-10-21T12:13:51.958659Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2020-10-21T12:13:51.958661Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2020-10-21T12:13:51.958663Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2020-10-21T12:13:51.958665Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2020-10-21T12:13:51.958667Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2020-10-21T12:13:51.958670Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2020-10-21T12:13:51.958672Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2020-10-21T12:13:51.958674Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2020-10-21T12:13:51.958677Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2020-10-21T12:13:51.958679Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2020-10-21T12:13:51.958681Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2020-10-21T12:13:51.958683Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2020-10-21T12:13:51.958685Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2020-10-21T12:13:51.958687Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2020-10-21T12:13:51.958690Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2020-10-21T12:13:51.958692Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2020-10-21T12:13:51.958694Z 0 [Note] Shutting down plugin 'InnoDB' 2020-10-21T12:13:51.958909Z 0 [Note] InnoDB: FTS optimize thread exiting. 2020-10-21T12:13:51.959115Z 0 [Note] InnoDB: Starting shutdown... 2020-10-21T12:13:52.059511Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2020-10-21T12:13:52.059907Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201021 12:13:52 2020-10-21T12:13:53.769699Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12605548 2020-10-21T12:13:53.771313Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-10-21T12:13:53.771338Z 0 [Note] Shutting down plugin 'MEMORY' 2020-10-21T12:13:53.771343Z 0 [Note] Shutting down plugin 'CSV' 2020-10-21T12:13:53.771347Z 0 [Note] Shutting down plugin 'sha256_password' 2020-10-21T12:13:53.771349Z 0 [Note] Shutting down plugin 'mysql_native_password' 2020-10-21T12:13:53.771498Z 0 [Note] Shutting down plugin 'binlog' 2020-10-21T12:13:53.772004Z 0 [Note] mysqld: Shutdown complete Warning: 1T12:13:54.152755Z 0 [Warning] Insecure configuration for --secure-file-priv: Data directory is accessible through --secure-file-priv. Consider choosing a different directory. Warning: 1T12:13:54.152813Z 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory. 2020-10-21T12:13:54.152842Z 0 [Note] mysqld (mysqld 5.7.32) starting as process 1 ... 2020-10-21T12:13:54.155987Z 0 [Note] InnoDB: PUNCH HOLE support available 2020-10-21T12:13:54.156007Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-10-21T12:13:54.156010Z 0 [Note] InnoDB: Uses event mutexes 2020-10-21T12:13:54.156013Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2020-10-21T12:13:54.156016Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-10-21T12:13:54.156019Z 0 [Note] InnoDB: Using Linux native AIO 2020-10-21T12:13:54.156282Z 0 [Note] InnoDB: Number of pools: 1 2020-10-21T12:13:54.156408Z 0 [Note] InnoDB: Using CPU crc32 instructions 2020-10-21T12:13:54.158290Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-10-21T12:13:54.167097Z 0 [Note] InnoDB: Completed initialization of buffer pool 2020-10-21T12:13:54.169910Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-10-21T12:13:54.182337Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2020-10-21T12:13:54.189985Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-10-21T12:13:54.190154Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-10-21T12:13:54.319985Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-10-21T12:13:54.321025Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2020-10-21T12:13:54.321052Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2020-10-21T12:13:54.322371Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 12605548 2020-10-21T12:13:54.322754Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2020-10-21T12:13:54.323136Z 0 [Note] Plugin 'FEDERATED' is disabled. 2020-10-21T12:13:54.327481Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201021 12:13:54 2020-10-21T12:13:54.330575Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2020-10-21T12:13:54.330595Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. Warning: 1T12:13:54.331226Z 0 [Warning] CA certificate ca.pem is self signed. 2020-10-21T12:13:54.331275Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2020-10-21T12:13:54.331951Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2020-10-21T12:13:54.332068Z 0 [Note] IPv6 is available. 2020-10-21T12:13:54.332083Z 0 [Note] - '::' resolves to '::'; 2020-10-21T12:13:54.332113Z 0 [Note] Server socket created on IP: '::'. Warning: 1T12:13:54.333196Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory. 2020-10-21T12:13:54.341203Z 0 [Note] Event Scheduler: Loaded 0 events 2020-10-21T12:13:54.341532Z 0 [Note] mysqld: ready for connections. Version: '5.7.32' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL) 2020-10-21T12:13:55.025965Z 2 [Note] Got an error reading communication packets 2020-10-21T12:15:16.775454Z 16 [Note] Aborted connection 16 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:15:31.502655Z 33 [Note] Aborted connection 33 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:15:32.112554Z 37 [Note] Aborted connection 37 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:17:18.613428Z 156 [Note] Aborted connection 156 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:17:19.993993Z 169 [Note] Aborted connection 169 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:17:23.997925Z 178 [Note] Aborted connection 178 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:17:26.428805Z 179 [Note] Aborted connection 179 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:17:28.856039Z 181 [Note] Aborted connection 181 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:17:37.234787Z 183 [Note] Aborted connection 183 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:17:45.177740Z 184 [Note] Aborted connection 184 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:17:47.611966Z 186 [Note] Aborted connection 186 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:17:50.024044Z 188 [Note] Aborted connection 188 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:17:52.451034Z 190 [Note] Aborted connection 190 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:17:54.937623Z 192 [Note] Aborted connection 192 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:17:57.348497Z 194 [Note] Aborted connection 194 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:17:59.753386Z 196 [Note] Aborted connection 196 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:18:00.877236Z 198 [Note] Aborted connection 198 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:18:03.465205Z 199 [Note] Aborted connection 199 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:18:05.882347Z 201 [Note] Aborted connection 201 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:18:08.328999Z 203 [Note] Aborted connection 203 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:18:09.446403Z 205 [Note] Aborted connection 205 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:18:10.727593Z 206 [Note] Aborted connection 206 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:18:11.971021Z 208 [Note] Aborted connection 208 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:18:13.517812Z 209 [Note] Aborted connection 209 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:18:16.500688Z 210 [Note] Aborted connection 210 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:18:19.352522Z 212 [Note] Aborted connection 212 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:18:21.279280Z 213 [Note] Aborted connection 213 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:18:21.692807Z 207 [Note] InnoDB: Transactions deadlock detected, dumping detailed information. 2020-10-21T12:18:21.692825Z 207 [Note] InnoDB: *** (1) TRANSACTION: TRANSACTION 12600, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 LOCK WAIT 3 lock struct(s), heap size 1136, 2 row lock(s) MySQL thread id 214, OS thread handle 140147069556480, query id 33701 docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau 172.18.0.3 root update INSERT INTO dag (dag_id, root_dag_id, is_paused, is_subdag, is_active, last_scheduler_run, last_pickled, last_expired, scheduler_lock, pickle_id, fileloc, owners, description, default_view, schedule_interval, concurrency, has_task_concurrency_limits, next_dagrun, next_dagrun_create_after) VALUES ('test_start_date_scheduling', NULL, 0, 0, 1, NULL, NULL, NULL, NULL, NULL, '/opt/airflow/tests/dags/test_scheduler_dags.py', 'airflow', NULL, 'tree', '{\"type\": \"timedelta\", \"attrs\": {\"days\": 1, \"seconds\": 0, \"microseconds\": 0}}', 16, 0, '2020-10-22 12:18:21.603795', '2020-10-23 12:18:21.603795'),('test_task_start_date_scheduling', NULL, 0, 0, 1, NULL, NULL, NULL, NULL, NULL, '/opt/airflow/tests/dags/test_scheduler_dags.py', 'airflow', NULL, 'tree', '{\"type\": \"timedelta\", \"attrs\": {\"days\": 1, \"seconds\": 0, \"microseconds\": 0}}', 16, 0, '2016-0 2020-10-21T12:18:21.692864Z 207 [Note] InnoDB: *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 278 page no 3 n bits 72 index PRIMARY of table `airflow`.`dag` trx id 12600 lock_mode X insert intention waiting Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0 0: len 8; hex 73757072656d756d; asc supremum;; 2020-10-21T12:18:21.692925Z 207 [Note] InnoDB: *** (2) TRANSACTION: TRANSACTION 12605, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 3 lock struct(s), heap size 1136, 2 row lock(s) MySQL thread id 207, OS thread handle 140147069286144, query id 33704 docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau 172.18.0.3 root update INSERT INTO dag (dag_id, root_dag_id, is_paused, is_subdag, is_active, last_scheduler_run, last_pickled, last_expired, scheduler_lock, pickle_id, fileloc, owners, description, default_view, schedule_interval, concurrency, has_task_concurrency_limits, next_dagrun, next_dagrun_create_after) VALUES ('test_verify_integrity_if_dag_changed', NULL, 0, 0, 1, NULL, NULL, NULL, NULL, NULL, '/opt/airflow/tests/jobs/test_scheduler_job.py', 'airflow', NULL, 'tree', '{\"type\": \"timedelta\", \"attrs\": {\"days\": 1, \"seconds\": 0, \"microseconds\": 0}}', 16, 0, '2016-01-01 00:00:00', '2016-01-02 00:00:00') 2020-10-21T12:18:21.692948Z 207 [Note] InnoDB: *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 278 page no 3 n bits 72 index PRIMARY of table `airflow`.`dag` trx id 12605 lock_mode X Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0 0: len 8; hex 73757072656d756d; asc supremum;; 2020-10-21T12:18:21.692988Z 207 [Note] InnoDB: *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 278 page no 3 n bits 72 index PRIMARY of table `airflow`.`dag` trx id 12605 lock_mode X insert intention waiting Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0 0: len 8; hex 73757072656d756d; asc supremum;; 2020-10-21T12:18:21.693028Z 207 [Note] InnoDB: *** WE ROLL BACK TRANSACTION (2) 2020-10-21T12:19:05.564894Z 280 [Note] Aborted connection 280 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:19:08.107753Z 283 [Note] Aborted connection 283 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:19:08.444137Z 285 [Note] Aborted connection 285 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:19:35.741444Z 291 [Note] Aborted connection 291 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) 2020-10-21T12:19:35.741517Z 41 [Note] Aborted connection 41 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_c1e4b5c82d6d.docker-compose_defau' (Got an error reading communication packets) Container docker-compose_mysql_1 logs dumped to /home/runner/work/airflow/airflow/files/container_logs_docker-compose_mysql_1_2020-10-21_319791128_tests-mysql.log ``` ---------------------------------------------------------------- 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]
