potiuk commented on issue #11543: URL: https://github.com/apache/airflow/issues/11543#issuecomment-715243196
I have not yet looked at this, but I will have a cloer look during the weekend. From my past investigation It's not always straightforward In the meantime, I also dump another case. https://github.com/apache/airflow/runs/1294560665: ``` ########################################################################################### Dumping logs from docker-compose_mysql_1 container ########################################################################################### Warning: 2T19:48:16.529889Z 0 [Warning] InnoDB: New log files created, LSN=45790 Warning: 2T19:48:16.776700Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. Warning: 2T19:48:16.832316Z 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: 875d400c-149f-11eb-8b8e-0242ac120002. Warning: 2T19:48:16.833133Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. Warning: 2T19:48:17.408204Z 0 [Warning] CA certificate ca.pem is self signed. Warning: 2T19:48:17.659702Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. Warning: 2T19:48:19.915428Z 0 [Warning] Insecure configuration for --secure-file-priv: Data directory is accessible through --secure-file-priv. Consider choosing a different directory. Warning: 2T19:48:19.915523Z 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory. 2020-10-22T19:48:19.915566Z 0 [Note] mysqld (mysqld 5.7.32) starting as process 78 ... 2020-10-22T19:48:19.918410Z 0 [Note] InnoDB: PUNCH HOLE support available 2020-10-22T19:48:19.918431Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-10-22T19:48:19.918433Z 0 [Note] InnoDB: Uses event mutexes 2020-10-22T19:48:19.918435Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2020-10-22T19:48:19.918437Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-10-22T19:48:19.918439Z 0 [Note] InnoDB: Using Linux native AIO 2020-10-22T19:48:19.918653Z 0 [Note] InnoDB: Number of pools: 1 2020-10-22T19:48:19.918755Z 0 [Note] InnoDB: Using CPU crc32 instructions 2020-10-22T19:48:19.920490Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-10-22T19:48:19.928634Z 0 [Note] InnoDB: Completed initialization of buffer pool 2020-10-22T19:48:19.930799Z 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-22T19:48:19.943073Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2020-10-22T19:48:19.950204Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-10-22T19:48:19.950327Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-10-22T19:48:20.086257Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-10-22T19:48:20.086711Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2020-10-22T19:48:20.086724Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2020-10-22T19:48:20.087569Z 0 [Note] InnoDB: Waiting for purge to start 2020-10-22T19:48:20.137709Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2746702 2020-10-22T19:48:20.137942Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2020-10-22T19:48:20.138059Z 0 [Note] Plugin 'FEDERATED' is disabled. 2020-10-22T19:48:20.139479Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201022 19:48:20 2020-10-22T19:48:20.142935Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2020-10-22T19:48:20.142951Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. Warning: 2T19:48:20.143330Z 0 [Warning] CA certificate ca.pem is self signed. 2020-10-22T19:48:20.143361Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. Warning: 2T19:48:20.144650Z 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-22T19:48:20.151260Z 0 [Note] Event Scheduler: Loaded 0 events 2020-10-22T19:48:20.151411Z 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-22T19:48:23.092691Z 0 [Note] Giving 0 client threads a chance to die gracefully 2020-10-22T19:48:23.092712Z 0 [Note] Shutting down slave threads 2020-10-22T19:48:23.092715Z 0 [Note] Forcefully disconnecting 0 remaining clients 2020-10-22T19:48:23.092719Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2020-10-22T19:48:23.092752Z 0 [Note] Binlog end 2020-10-22T19:48:23.093120Z 0 [Note] Shutting down plugin 'ngram' 2020-10-22T19:48:23.093132Z 0 [Note] Shutting down plugin 'partition' 2020-10-22T19:48:23.093134Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2020-10-22T19:48:23.093137Z 0 [Note] Shutting down plugin 'ARCHIVE' 2020-10-22T19:48:23.093138Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2020-10-22T19:48:23.093162Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2020-10-22T19:48:23.093164Z 0 [Note] Shutting down plugin 'MyISAM' 2020-10-22T19:48:23.093169Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2020-10-22T19:48:23.093171Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2020-10-22T19:48:23.093173Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2020-10-22T19:48:23.093175Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2020-10-22T19:48:23.093176Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2020-10-22T19:48:23.093178Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2020-10-22T19:48:23.093179Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2020-10-22T19:48:23.093181Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2020-10-22T19:48:23.093183Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2020-10-22T19:48:23.093184Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2020-10-22T19:48:23.093186Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2020-10-22T19:48:23.093187Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2020-10-22T19:48:23.093189Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2020-10-22T19:48:23.093190Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2020-10-22T19:48:23.093192Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2020-10-22T19:48:23.093194Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2020-10-22T19:48:23.093196Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2020-10-22T19:48:23.093198Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2020-10-22T19:48:23.093200Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2020-10-22T19:48:23.093202Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2020-10-22T19:48:23.093203Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2020-10-22T19:48:23.093205Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2020-10-22T19:48:23.093207Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2020-10-22T19:48:23.093208Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2020-10-22T19:48:23.093210Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2020-10-22T19:48:23.093212Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2020-10-22T19:48:23.093214Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2020-10-22T19:48:23.093216Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2020-10-22T19:48:23.093217Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2020-10-22T19:48:23.093219Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2020-10-22T19:48:23.093221Z 0 [Note] Shutting down plugin 'InnoDB' 2020-10-22T19:48:23.093250Z 0 [Note] InnoDB: FTS optimize thread exiting. 2020-10-22T19:48:23.093358Z 0 [Note] InnoDB: Starting shutdown... 2020-10-22T19:48:23.193551Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2020-10-22T19:48:23.193829Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201022 19:48:23 2020-10-22T19:48:24.901298Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12604863 2020-10-22T19:48:24.902537Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-10-22T19:48:24.902554Z 0 [Note] Shutting down plugin 'MEMORY' 2020-10-22T19:48:24.902559Z 0 [Note] Shutting down plugin 'CSV' 2020-10-22T19:48:24.902562Z 0 [Note] Shutting down plugin 'sha256_password' 2020-10-22T19:48:24.902564Z 0 [Note] Shutting down plugin 'mysql_native_password' 2020-10-22T19:48:24.902670Z 0 [Note] Shutting down plugin 'binlog' 2020-10-22T19:48:24.903053Z 0 [Note] mysqld: Shutdown complete Warning: 2T19:48:25.273019Z 0 [Warning] Insecure configuration for --secure-file-priv: Data directory is accessible through --secure-file-priv. Consider choosing a different directory. Warning: 2T19:48:25.273068Z 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory. 2020-10-22T19:48:25.273087Z 0 [Note] mysqld (mysqld 5.7.32) starting as process 1 ... 2020-10-22T19:48:25.275477Z 0 [Note] InnoDB: PUNCH HOLE support available 2020-10-22T19:48:25.275496Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-10-22T19:48:25.275499Z 0 [Note] InnoDB: Uses event mutexes 2020-10-22T19:48:25.275501Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2020-10-22T19:48:25.275503Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-10-22T19:48:25.275506Z 0 [Note] InnoDB: Using Linux native AIO 2020-10-22T19:48:25.275713Z 0 [Note] InnoDB: Number of pools: 1 2020-10-22T19:48:25.275815Z 0 [Note] InnoDB: Using CPU crc32 instructions 2020-10-22T19:48:25.277398Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-10-22T19:48:25.284153Z 0 [Note] InnoDB: Completed initialization of buffer pool 2020-10-22T19:48:25.286342Z 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-22T19:48:25.298559Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2020-10-22T19:48:25.304352Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-10-22T19:48:25.304498Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-10-22T19:48:25.429832Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-10-22T19:48:25.430265Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2020-10-22T19:48:25.430280Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2020-10-22T19:48:25.431083Z 0 [Note] InnoDB: Waiting for purge to start 2020-10-22T19:48:25.481219Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 12604863 2020-10-22T19:48:25.481434Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2020-10-22T19:48:25.482205Z 0 [Note] Plugin 'FEDERATED' is disabled. 2020-10-22T19:48:25.484299Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201022 19:48:25 2020-10-22T19:48:25.487438Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2020-10-22T19:48:25.487454Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. Warning: 2T19:48:25.487835Z 0 [Warning] CA certificate ca.pem is self signed. 2020-10-22T19:48:25.487866Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2020-10-22T19:48:25.488439Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2020-10-22T19:48:25.488949Z 0 [Note] IPv6 is available. 2020-10-22T19:48:25.489039Z 0 [Note] - '::' resolves to '::'; 2020-10-22T19:48:25.489146Z 0 [Note] Server socket created on IP: '::'. Warning: 2T19:48:25.490394Z 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-22T19:48:25.496938Z 0 [Note] Event Scheduler: Loaded 0 events 2020-10-22T19:48:25.497197Z 0 [Note] mysqld: ready for connections. Version: '5.7.32' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL) 2020-10-22T19:48:25.562027Z 2 [Note] Got an error reading communication packets 2020-10-22T20:00:16.184941Z 921 [Note] Aborted connection 921 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:00:17.542383Z 935 [Note] Aborted connection 935 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:00:21.137430Z 945 [Note] Aborted connection 945 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:00:22.114092Z 946 [Note] Aborted connection 946 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:00:23.384136Z 948 [Note] Aborted connection 948 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:00:24.393428Z 949 [Note] Aborted connection 949 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:00:25.641684Z 951 [Note] Aborted connection 951 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:00:34.445536Z 952 [Note] Aborted connection 952 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:00:42.282983Z 954 [Note] Aborted connection 954 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:00:43.259746Z 956 [Note] Aborted connection 956 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:00:44.529289Z 958 [Note] Aborted connection 958 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:00:45.533847Z 959 [Note] Aborted connection 959 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:00:46.799395Z 961 [Note] Aborted connection 961 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:00:47.811452Z 962 [Note] Aborted connection 962 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:00:49.091139Z 964 [Note] Aborted connection 964 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:00:51.372533Z 965 [Note] Aborted connection 965 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:00:52.313924Z 967 [Note] Aborted connection 967 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:00:53.538350Z 969 [Note] Aborted connection 969 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:00:54.508874Z 970 [Note] Aborted connection 970 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:00:55.757651Z 972 [Note] Aborted connection 972 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:00:56.688589Z 973 [Note] Aborted connection 973 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:00:59.063765Z 974 [Note] Aborted connection 974 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:01:00.035349Z 976 [Note] Aborted connection 976 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:01:01.270706Z 978 [Note] Aborted connection 978 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:01:02.235232Z 979 [Note] Aborted connection 979 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:01:03.463372Z 981 [Note] Aborted connection 981 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:01:04.393960Z 982 [Note] Aborted connection 982 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:01:06.277514Z 983 [Note] Aborted connection 983 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:01:13.338895Z 990 [Note] Aborted connection 990 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:01:17.468557Z 995 [Note] Aborted connection 995 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:01:17.720433Z 985 [Note] InnoDB: Transactions deadlock detected, dumping detailed information. 2020-10-22T20:01:17.720451Z 985 [Note] InnoDB: *** (1) TRANSACTION: TRANSACTION 21364, 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 996, OS thread handle 140653469202176, query id 276580 docker-compose_airflow_run_f920c240a470.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_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-01-01 00:00:00', '2016-01-02 00:00:00'),('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-23 20:01:17 2020-10-22T20:01:17.720580Z 985 [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 21364 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-22T20:01:17.720637Z 985 [Note] InnoDB: *** (2) TRANSACTION: TRANSACTION 21365, 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 985, OS thread handle 140653470013184, query id 276581 docker-compose_airflow_run_f920c240a470.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_scheduler_verify_priority_and_slots', 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-22T20:01:17.720657Z 985 [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 21365 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-22T20:01:17.720696Z 985 [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 21365 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-22T20:01:17.720733Z 985 [Note] InnoDB: *** WE ROLL BACK TRANSACTION (2) 2020-10-22T20:07:01.587109Z 1242 [Note] Unknown database 'foobar' 2020-10-22T20:07:01.654077Z 1245 [Note] Unknown database 'foobar' 2020-10-22T20:08:01.519675Z 1416 [Note] Aborted connection 1416 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:08:01.758318Z 1425 [Note] Aborted connection 1425 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:08:10.341602Z 1430 [Note] Aborted connection 1430 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:08:12.954263Z 1433 [Note] Aborted connection 1433 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:08:14.179306Z 1435 [Note] Aborted connection 1435 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:16:24.691830Z 1506 [Note] Aborted connection 1506 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:16:24.691830Z 1481 [Note] Aborted connection 1481 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:16:24.692096Z 1480 [Note] Aborted connection 1480 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:16:24.692410Z 1474 [Note] Aborted connection 1474 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:16:24.692492Z 1449 [Note] Aborted connection 1449 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:16:24.692618Z 1473 [Note] Aborted connection 1473 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:16:24.692764Z 1444 [Note] Aborted connection 1444 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:16:24.692780Z 1472 [Note] Aborted connection 1472 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:16:24.692967Z 1478 [Note] Aborted connection 1478 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:16:24.693082Z 1446 [Note] Aborted connection 1446 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:16:24.693098Z 1477 [Note] Aborted connection 1477 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:16:24.693229Z 1476 [Note] Aborted connection 1476 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:16:24.693323Z 1452 [Note] Aborted connection 1452 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:16:24.693362Z 1475 [Note] Aborted connection 1475 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:16:24.693514Z 1448 [Note] Aborted connection 1448 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:16:24.693575Z 1441 [Note] Aborted connection 1441 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:16:24.693839Z 1447 [Note] Aborted connection 1447 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:16:24.694051Z 1445 [Note] Aborted connection 1445 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:16:24.694174Z 1453 [Note] Aborted connection 1453 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:16:24.694210Z 1450 [Note] Aborted connection 1450 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:16:24.694229Z 9 [Note] Aborted connection 9 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:16:24.694249Z 8 [Note] Aborted connection 8 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:16:24.694261Z 7 [Note] Aborted connection 7 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:16:24.694287Z 1443 [Note] Aborted connection 1443 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:16:24.694304Z 1451 [Note] Aborted connection 1451 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:16:24.692413Z 1479 [Note] Aborted connection 1479 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.docker-compose_defau' (Got an error reading communication packets) 2020-10-22T20:16:24.696076Z 6 [Note] Aborted connection 6 to db: 'airflow' user: 'root' host: 'docker-compose_airflow_run_f920c240a470.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-22_322613028_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]
