2020-12-23 20:40:11 0 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. 2020-12-23 20:40:11 0 [Note] InnoDB: Using Linux native AIO 2020-12-23 20:40:11 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-12-23 20:40:11 0 [Note] InnoDB: Uses event mutexes 2020-12-23 20:40:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-12-23 20:40:11 0 [Note] InnoDB: Number of pools: 1 2020-12-23 20:40:11 0 [Note] InnoDB: Using SSE2 crc32 instructions 2020-12-23 20:40:11 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-12-23 20:40:11 0 [Note] InnoDB: Completed initialization of buffer pool 2020-12-23 20:40:11 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-12-23 20:40:11 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=46668849927 2020-12-23 20:40:11 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2020-12-23 20:40:11 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-12-23 20:40:11 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-12-23 20:40:11 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-12-23 20:40:11 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-12-23 20:40:11 0 [Note] InnoDB: Waiting for purge to start 2020-12-23 20:40:11 0 [Note] InnoDB: 10.3.27 started; log sequence number 46668849936; transaction id 9138472 2020-12-23 20:40:11 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2020-12-23 20:40:11 0 [Note] Plugin 'FEEDBACK' is disabled. 2020-12-23 20:40:11 0 [Note] Recovering after a crash using tc.log 2020-12-23 20:40:11 0 [Note] Starting crash recovery... 2020-12-23 20:40:11 0 [Note] Crash recovery finished. 2020-12-23 20:40:11 0 [Note] Server socket created on IP: '0.0.0.0'. 2020-12-23 20:40:11 0 [Note] Reading of all Master_info entries succeeded 2020-12-23 20:40:11 0 [Note] Added new Master_info '' to hash table 2020-12-23 20:40:11 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.3.27-MariaDB-0+deb10u1-log' socket: '/run/mysqld/mysqld.sock' port: 3306 Debian 10 2020-12-23 20:40:11 0 [Note] InnoDB: Buffer pool(s) load completed at 201223 20:40:11 2020-12-23 20:40:11 8 [ERROR] mysqld: Table './outsourcing/ci_sessions' is marked as crashed and should be repaired 2020-12-23 20:40:11 8 [Warning] Checking table: './outsourcing/ci_sessions' 2020-12-23 20:40:11 8 [ERROR] mysqld: Table './outsourcing/user' is marked as crashed and should be repaired 2020-12-23 20:40:11 8 [Warning] Checking table: './outsourcing/user' 2020-12-23 20:40:11 9 [Warning] Access denied for user 'root'@'localhost' (using password: NO) 2020-12-23 20:40:11 10 [Warning] Access denied for user 'root'@'localhost' (using password: NO) 2020-12-23 20:40:11 11 [Warning] Access denied for user 'root'@'localhost' (using password: NO) 2020-12-23 20:40:12 15 [ERROR] mysqld: Table './fv/ci_sessions' is marked as crashed and should be repaired 2020-12-23 20:40:12 15 [Warning] Checking table: './fv/ci_sessions' 2020-12-23 20:40:13 16 [ERROR] mysqld: Table './msg/ci_sessions' is marked as crashed and should be repaired 2020-12-23 20:40:13 16 [Warning] Checking table: './msg/ci_sessions' 2020-12-23 20:40:13 16 [ERROR] mysqld: Table './msg/user' is marked as crashed and should be repaired 2020-12-23 20:40:13 16 [Warning] Checking table: './msg/user' 2020-12-23 20:40:14 27 [ERROR] mysqld: Table './outsourcing/object' is marked as crashed and should be repaired 2020-12-23 20:40:14 27 [Warning] Checking table: './outsourcing/object' 2020-12-23 20:40:14 27 [ERROR] mysqld: Table './outsourcing/employee_client' is marked as crashed and should be repaired 2020-12-23 20:40:14 27 [Warning] Checking table: './outsourcing/employee_client' 2020-12-23 20:40:18 40 [ERROR] mysqld: Table './pplfast/ci_sessions' is marked as crashed and should be repaired 2020-12-23 20:40:18 40 [Warning] Checking table: './pplfast/ci_sessions' 2020-12-23 20:40:38 36 [ERROR] mysqld: Table './outsourcing/plan' is marked as crashed and should be repaired 2020-12-23 20:40:38 36 [Warning] Checking table: './outsourcing/plan' 2020-12-23 20:40:44 36 [ERROR] mysqld: Table './outsourcing/shift' is marked as crashed and should be repaired 2020-12-23 20:40:44 36 [Warning] Checking table: './outsourcing/shift' 2020-12-23 20:40:45 36 [ERROR] mysqld: Table './outsourcing/shift_template' is marked as crashed and should be repaired 2020-12-23 20:40:45 36 [Warning] Checking table: './outsourcing/shift_template' 2020-12-23 20:40:45 36 [ERROR] mysqld: Table './outsourcing/paid_money' is marked as crashed and should be repaired 2020-12-23 20:40:45 36 [Warning] Checking table: './outsourcing/paid_money' 2020-12-23 20:40:50 17 [ERROR] mysqld: Table './outsourcing/users_action_log' is marked as crashed and should be repaired 2020-12-23 20:40:50 17 [Warning] Checking table: './outsourcing/users_action_log' 2020-12-23 20:40:50 36 [ERROR] mysqld: Table './outsourcing/checklist' is marked as crashed and should be repaired 2020-12-23 20:40:50 36 [Warning] Checking table: './outsourcing/checklist' 2020-12-23 20:40:52 36 [ERROR] mysqld: Table './outsourcing/employee_bonus' is marked as crashed and should be repaired 2020-12-23 20:40:52 36 [Warning] Checking table: './outsourcing/employee_bonus' 2020-12-23 20:40:52 36 [ERROR] mysqld: Table './outsourcing/employee_fine' is marked as crashed and should be repaired 2020-12-23 20:40:52 36 [Warning] Checking table: './outsourcing/employee_fine' 2020-12-23 20:40:52 36 [ERROR] mysqld: Table './outsourcing/employee_deduction' is marked as crashed and should be repaired 2020-12-23 20:40:52 36 [Warning] Checking table: './outsourcing/employee_deduction' 2020-12-23 20:40:52 36 [ERROR] mysqld: Table './outsourcing/employee_salary' is marked as crashed and should be repaired 2020-12-23 20:40:52 36 [Warning] Checking table: './outsourcing/employee_salary' 2020-12-23 20:41:01 65 [ERROR] mysqld: Table './tm/ci_sessions' is marked as crashed and should be repaired 2020-12-23 20:41:01 65 [Warning] Checking table: './tm/ci_sessions' 2020-12-23 20:41:01 63 [ERROR] mysqld: Table './outsourcing/employee_notifications' is marked as crashed and should be repaired 2020-12-23 20:41:01 63 [Warning] Checking table: './outsourcing/employee_notifications' 2020-12-23 20:41:01 62 [ERROR] mysqld: Table './fv/plan' is marked as crashed and should be repaired 2020-12-23 20:41:01 62 [Warning] Checking table: './fv/plan' 2020-12-23 20:41:01 62 [ERROR] mysqld: Table './fv/employee_notifications' is marked as crashed and should be repaired 2020-12-23 20:41:01 62 [Warning] Checking table: './fv/employee_notifications' 2020-12-23 20:41:12 50 [ERROR] mysqld: Table './outsourcing/category_client' is marked as crashed and should be repaired 2020-12-23 20:41:12 50 [Warning] Checking table: './outsourcing/category_client' 2020-12-23 20:41:12 50 [ERROR] mysqld: Table './outsourcing/rate' is marked as crashed and should be repaired 2020-12-23 20:41:12 50 [Warning] Checking table: './outsourcing/rate' 2020-12-23 20:41:12 50 [ERROR] mysqld: Table './outsourcing/category' is marked as crashed and should be repaired 2020-12-23 20:41:12 50 [Warning] Checking table: './outsourcing/category' 2020-12-23 20:41:12 50 [ERROR] mysqld: Table './outsourcing/candidate_history_status' is marked as crashed and should be repaired 2020-12-23 20:41:12 50 [Warning] Checking table: './outsourcing/candidate_history_status' 2020-12-23 20:41:14 50 [ERROR] mysqld: Table './outsourcing/fl_job_patent' is marked as crashed and should be repaired 2020-12-23 20:41:14 50 [Warning] Checking table: './outsourcing/fl_job_patent' 2020-12-23 20:41:14 50 [ERROR] mysqld: Table './outsourcing/fl_migration_service' is marked as crashed and should be repaired 2020-12-23 20:41:14 50 [Warning] Checking table: './outsourcing/fl_migration_service' 2020-12-23 20:41:14 50 [ERROR] mysqld: Table './outsourcing/checklist_data' is marked as crashed and should be repaired 2020-12-23 20:41:14 50 [Warning] Checking table: './outsourcing/checklist_data' 2020-12-23 20:41:49 69 [ERROR] mysqld: Table './outsourcing/employee_contact' is marked as crashed and should be repaired 2020-12-23 20:41:49 69 [Warning] Checking table: './outsourcing/employee_contact' 2020-12-23 20:41:50 69 [ERROR] mysqld: Table './outsourcing/paid_money_budget_and_articles' is marked as crashed and should be repaired 2020-12-23 20:41:50 69 [Warning] Checking table: './outsourcing/paid_money_budget_and_articles' 2020-12-23 20:41:51 69 [ERROR] mysqld: Table './outsourcing/paid_money_goods_and_services' is marked as crashed and should be repaired 2020-12-23 20:41:51 69 [Warning] Checking table: './outsourcing/paid_money_goods_and_services' 2020-12-23 20:41:53 69 [ERROR] mysqld: Table './outsourcing/employee_action_log' is marked as crashed and should be repaired 2020-12-23 20:41:53 69 [Warning] Checking table: './outsourcing/employee_action_log' 2020-12-23 20:42:01 83 [ERROR] mysqld: Table './ars/ci_sessions' is marked as crashed and should be repaired 2020-12-23 20:42:01 83 [Warning] Checking table: './ars/ci_sessions' 2020-12-23 20:42:18 42 [ERROR] mysqld: Table './outsourcing/employee_interview' is marked as crashed and should be repaired 2020-12-23 20:42:18 42 [Warning] Checking table: './outsourcing/employee_interview' 2020-12-23 20:42:18 42 [ERROR] mysqld: Table './outsourcing/interview' is marked as crashed and should be repaired 2020-12-23 20:42:18 42 [Warning] Checking table: './outsourcing/interview' 2020-12-23 20:42:19 42 [ERROR] mysqld: Table './outsourcing/employee_metro' is marked as crashed and should be repaired 2020-12-23 20:42:19 42 [Warning] Checking table: './outsourcing/employee_metro' 2020-12-23 20:42:19 42 [ERROR] mysqld: Table './outsourcing/employee_experience' is marked as crashed and should be repaired 2020-12-23 20:42:19 42 [Warning] Checking table: './outsourcing/employee_experience' 2020-12-23 20:42:19 42 [ERROR] mysqld: Table './outsourcing/employee_history' is marked as crashed and should be repaired 2020-12-23 20:42:19 42 [Warning] Checking table: './outsourcing/employee_history' 2020-12-23 20:42:49 60 [ERROR] mysqld: Table './outsourcing/checklist_export_data' is marked as crashed and should be repaired 2020-12-23 20:42:49 60 [Warning] Checking table: './outsourcing/checklist_export_data' 2020-12-23 20:45:01 152 [ERROR] mysqld: Table './ars/users_action_log' is marked as crashed and should be repaired 2020-12-23 20:45:01 152 [Warning] Checking table: './ars/users_action_log' 2020-12-23 20:45:01 155 [ERROR] mysqld: Table './msg/users_action_log' is marked as crashed and should be repaired 2020-12-23 20:45:01 155 [Warning] Checking table: './msg/users_action_log' 2020-12-23 20:45:01 163 [ERROR] mysqld: Table './pplfast/users_action_log' is marked as crashed and should be repaired 2020-12-23 20:45:01 163 [Warning] Checking table: './pplfast/users_action_log' 2020-12-23 20:45:01 156 [ERROR] mysqld: Table './fv/users_action_log' is marked as crashed and should be repaired 2020-12-23 20:45:01 156 [Warning] Checking table: './fv/users_action_log' 2020-12-23 20:45:53 150 [ERROR] mysqld: Table './outsourcing/fl_migration_card' is marked as crashed and should be repaired 2020-12-23 20:45:53 150 [Warning] Checking table: './outsourcing/fl_migration_card' 2020-12-23 20:48:11 247 [ERROR] mysqld: Table './outsourcing/paid_money_period' is marked as crashed and should be repaired 2020-12-23 20:48:11 247 [Warning] Checking table: './outsourcing/paid_money_period' 2020-12-23 20:59:57 581 [ERROR] mysqld: Table './outsourcing/checklist_export' is marked as crashed and should be repaired 2020-12-23 20:59:57 581 [Warning] Checking table: './outsourcing/checklist_export' 2020-12-23 21:05:09 731 [ERROR] mysqld: Table './outsourcing/fl_medical_policy' is marked as crashed and should be repaired 2020-12-23 21:05:09 731 [Warning] Checking table: './outsourcing/fl_medical_policy' 2020-12-23 21:05:32 731 [ERROR] mysqld: Table './outsourcing/nsms_simple_message' is marked as crashed and should be repaired 2020-12-23 21:05:32 731 [Warning] Checking table: './outsourcing/nsms_simple_message' 2020-12-23 21:06:24 880 [Warning] IP address '192.168.5.247' could not be resolved: Name or service not known double free or corruption (!prev) 2020-12-23 21:30:01 0x7fd010c1d700 InnoDB: Assertion failure in file /build/mariadb-10.3-Zg5BW3/mariadb-10.3-10.3.27/storage/innobase/include/ut0lst.h line 334 InnoDB: Failing assertion: list.count > 0 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/ InnoDB: about forcing recovery. 201223 21:30:01 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.3.27-MariaDB-0+deb10u1-log key_buffer_size=1317011456 read_buffer_size=131072 max_used_connections=170 max_threads=802 thread_count=52 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 3049343 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7fcee40008d8 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... 2020-12-23 21:30:07 0 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. 2020-12-23 21:30:07 0 [Note] InnoDB: Using Linux native AIO 2020-12-23 21:30:07 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-12-23 21:30:07 0 [Note] InnoDB: Uses event mutexes 2020-12-23 21:30:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-12-23 21:30:07 0 [Note] InnoDB: Number of pools: 1 2020-12-23 21:30:07 0 [Note] InnoDB: Using SSE2 crc32 instructions 2020-12-23 21:30:07 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-12-23 21:30:07 0 [Note] InnoDB: Completed initialization of buffer pool 2020-12-23 21:30:07 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-12-23 21:30:07 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=46674388337 2020-12-23 21:30:07 0 [Note] InnoDB: Starting final batch to recover 3 pages from redo log. 2020-12-23 21:30:08 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2020-12-23 21:30:08 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-12-23 21:30:08 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-12-23 21:30:08 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-12-23 21:30:08 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-12-23 21:30:08 0 [Note] InnoDB: Waiting for purge to start 2020-12-23 21:30:08 0 [Note] InnoDB: 10.3.27 started; log sequence number 46674389284; transaction id 9177829 2020-12-23 21:30:08 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2020-12-23 21:30:08 0 [Note] Plugin 'FEEDBACK' is disabled. 2020-12-23 21:30:08 0 [Note] Recovering after a crash using tc.log 2020-12-23 21:30:08 0 [Note] Starting crash recovery... 2020-12-23 21:30:08 0 [Note] Crash recovery finished. 2020-12-23 21:30:08 0 [Note] Server socket created on IP: '0.0.0.0'. 2020-12-23 21:30:08 0 [Note] Reading of all Master_info entries succeeded 2020-12-23 21:30:08 0 [Note] Added new Master_info '' to hash table 2020-12-23 21:30:08 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.3.27-MariaDB-0+deb10u1-log' socket: '/run/mysqld/mysqld.sock' port: 3306 Debian 10 2020-12-23 21:30:08 0 [Note] InnoDB: Buffer pool(s) load completed at 201223 21:30:08 2020-12-23 21:30:08 8 [ERROR] mysqld: Table './outsourcing/ci_sessions' is marked as crashed and should be repaired 2020-12-23 21:30:08 8 [Warning] Checking table: './outsourcing/ci_sessions' 2020-12-23 21:30:08 9 [Warning] Access denied for user 'root'@'localhost' (using password: NO) 2020-12-23 21:30:08 10 [Warning] Access denied for user 'root'@'localhost' (using password: NO) 2020-12-23 21:30:08 11 [Warning] Access denied for user 'root'@'localhost' (using password: NO) 2020-12-23 21:30:08 8 [ERROR] mysqld: Table './outsourcing/user' is marked as crashed and should be repaired 2020-12-23 21:30:08 8 [Warning] Checking table: './outsourcing/user' 2020-12-23 21:30:09 12 [ERROR] mysqld: Table './msg/ci_sessions' is marked as crashed and should be repaired 2020-12-23 21:30:09 12 [Warning] Checking table: './msg/ci_sessions' 2020-12-23 21:30:09 14 [ERROR] mysqld: Table './fv/ci_sessions' is marked as crashed and should be repaired 2020-12-23 21:30:09 14 [Warning] Checking table: './fv/ci_sessions' 2020-12-23 21:30:12 27 [ERROR] mysqld: Table './outsourcing/employee_client' is marked as crashed and should be repaired 2020-12-23 21:30:12 27 [Warning] Checking table: './outsourcing/employee_client' 2020-12-23 21:30:13 30 [ERROR] mysqld: Table './outsourcing/plan' is marked as crashed and should be repaired 2020-12-23 21:30:13 30 [Warning] Checking table: './outsourcing/plan' 2020-12-23 21:30:14 32 [ERROR] mysqld: Table './pplfast/ci_sessions' is marked as crashed and should be repaired 2020-12-23 21:30:14 32 [Warning] Checking table: './pplfast/ci_sessions' 2020-12-23 21:30:19 30 [ERROR] mysqld: Table './outsourcing/shift' is marked as crashed and should be repaired 2020-12-23 21:30:19 30 [Warning] Checking table: './outsourcing/shift' 2020-12-23 21:30:20 30 [ERROR] mysqld: Table './outsourcing/checklist' is marked as crashed and should be repaired 2020-12-23 21:30:20 30 [Warning] Checking table: './outsourcing/checklist' 2020-12-23 21:30:35 24 [ERROR] mysqld: Table './outsourcing/users_action_log' is marked as crashed and should be repaired 2020-12-23 21:30:35 24 [Warning] Checking table: './outsourcing/users_action_log' 2020-12-23 21:30:59 16 [ERROR] mysqld: Table './outsourcing/checklist_data' is marked as crashed and should be repaired 2020-12-23 21:30:59 16 [Warning] Checking table: './outsourcing/checklist_data' 2020-12-23 21:31:01 50 [ERROR] mysqld: Table './tm/ci_sessions' is marked as crashed and should be repaired 2020-12-23 21:31:01 50 [Warning] Checking table: './tm/ci_sessions' 2020-12-23 21:31:04 23 [ERROR] mysqld: Table './ars/ci_sessions' is marked as crashed and should be repaired 2020-12-23 21:31:04 23 [Warning] Checking table: './ars/ci_sessions' 2020-12-23 21:31:12 46 [ERROR] mysqld: Table './outsourcing/employee_action_log' is marked as crashed and should be repaired 2020-12-23 21:31:12 46 [Warning] Checking table: './outsourcing/employee_action_log' 2020-12-23 21:32:56 87 [ERROR] mysqld: Table './msg/users_action_log' is marked as crashed and should be repaired 2020-12-23 21:32:56 87 [Warning] Checking table: './msg/users_action_log' 2020-12-23 21:40:02 251 [ERROR] mysqld: Table './fv/users_action_log' is marked as crashed and should be repaired 2020-12-23 21:40:02 251 [Warning] Checking table: './fv/users_action_log' 2020-12-23 21:45:01 389 [ERROR] mysqld: Table './ars/users_action_log' is marked as crashed and should be repaired 2020-12-23 21:45:01 389 [Warning] Checking table: './ars/users_action_log' 2020-12-23 21:45:01 393 [ERROR] mysqld: Table './pplfast/users_action_log' is marked as crashed and should be repaired 2020-12-23 21:45:01 393 [Warning] Checking table: './pplfast/users_action_log' 2020-12-24 0:00:02 3593 [Warning] Access denied for user 'root'@'localhost' (using password: NO) 2020-12-24 0:00:46 3620 [ERROR] mysqld: Table './outsourcing/checklist_export' is marked as crashed and should be repaired 2020-12-24 0:00:46 3620 [Warning] Checking table: './outsourcing/checklist_export' 2020-12-24 0:00:51 3620 [ERROR] mysqld: Table './outsourcing/checklist_export_data' is marked as crashed and should be repaired 2020-12-24 0:00:51 3620 [Warning] Checking table: './outsourcing/checklist_export_data' 2020-12-24 7:38:16 11255 [Warning] IP address '192.168.5.247' could not be resolved: Name or service not known 2020-12-24 11:42:18 20333 [Warning] Aborted connection 20333 to db: 'outsourcing' user: 'root' host: 'localhost' (Got an error reading communication packets) double free or corruption (!prev) 201224 11:45:20 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.3.27-MariaDB-0+deb10u1-log key_buffer_size=1317011456 read_buffer_size=131072 max_used_connections=168 max_threads=802 thread_count=138 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 3049343 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f43cca4d438 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x7f44f04a5dd8 thread_stack 0x30000 2020-12-24 11:49:21 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:49:21 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:49:21 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:49:21 0 [Note] InnoDB: A semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 228.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:49:21 0 [Note] InnoDB: A semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:49:21 0 [Note] InnoDB: A semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 225.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:49:21 0 [Note] InnoDB: A semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 228.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:49:21 0 [Note] InnoDB: A semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 225.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:49:21 0 [Note] InnoDB: A semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 225.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:49:21 0 [Note] InnoDB: A semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 225.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:49:21 0 [Note] InnoDB: A semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 226.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:49:21 0 [Note] InnoDB: A semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 227.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:49:21 0 [Note] InnoDB: A semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 210.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:49:21 0 [Note] InnoDB: A semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:49:21 0 [Note] InnoDB: A semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 239.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:49:21 0 [Note] InnoDB: A semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2020-12-24 11:49:29 0x7f44f2ffd700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 16490 srv_active, 0 srv_shutdown, 34752 srv_idle srv_master_thread log flush and writes: 51236 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1837962 --Thread 139934086178560 has waited at btr0sea.h line 266 for 236.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 --Thread 139933663459072 has waited at btr0sea.cc line 946 for 249.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 --Thread 139933674313472 has waited at dict0dict.cc line 348 for 233.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 --Thread 139933668169472 has waited at dict0dict.cc line 973 for 236.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 --Thread 139934532060928 has waited at dict0dict.cc line 973 for 233.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 --Thread 139934537262848 has waited at dict0dict.cc line 348 for 233.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 --Thread 139934539310848 has waited at dict0dict.cc line 973 for 233.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 --Thread 139934196270848 has waited at dict0dict.cc line 973 for 234.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 235.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 218.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 249.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 247.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 --Thread 139933669193472 has waited at btr0sea.cc line 946 for 249.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 OS WAIT ARRAY INFO: signal count 2828631 RW-shared spins 3252809, rounds 50502265, OS waits 1390080 RW-excl spins 2019604, rounds 17390998, OS waits 241302 RW-sx spins 2056, rounds 84974, OS waits 2025 Spin rounds per wait: 15.53 RW-shared, 8.61 RW-excl, 41.33 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 9404614 Purge done for trx's n:o < 9404496 undo n:o < 0 state: running but idle History list length 11 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421409518177232, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518227824, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518181448, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518173016, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518143504, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518118208, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518113992, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518080264, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518232040, ACTIVE 252 sec fetching rows mysql tables in use 7, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 20511, OS thread handle 139934066935552, query id 52390845 localhost root Sending data SELECT DISTINCT `phone`, DATE_FORMAT(`date`, '%d.%m.%y') `date`, TIME_FORMAT(`start_time`, '%H:%i') `start_time`, TIME_FORMAT(`end_time`, '%H:%i') `end_time`, `address` FROM ( SELECT `p`.`phone`, `p`.`date`, `p`.`start_time`, `p`.`end_time`, `p`.`address` FROM nsms_plans `p` JOIN nsms_message_plans `m_p` ON `m_p`.`id_plan` = `p`.`id` JOIN ( SELECT max(`id`) `id` FROM nsms_message Trx read view will not see trx with id >= 9404482, sees < 9404482 ---TRANSACTION 421409518430192, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518413328, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518404896, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518383816, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518375384, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518358520, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518354304, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518337440, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518324792, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518253120, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518198312, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518168800, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518164584, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518139288, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518286848, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518236256, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518185664, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518135072, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518109776, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518560888, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518556672, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518527160, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518438624, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518396464, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518371168, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518341656, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518269984, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518240472, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518202528, not started mysql tables in use 2, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518151936, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518535592, ACTIVE 249 sec starting index read mysql tables in use 31, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 20438, OS thread handle 139933663459072, query id 52422572 localhost root Statistics SELECT cl_opt.value INTO @need_medical FROM shift sh LEFT JOIN shift_template st ON st.id = sh.id_shift_template LEFT JOIN category_client cc ON cc.id = st.id_category_client LEFT JOIN client_option cl_opt ON cl_opt.id_client = cc.id_client AND cl_opt.name = 'is_required_medical' WHERE sh.id=@id_shift AND sh.start_date > (UNIX_TIMESTAMP() - 15*86400) GROUP BY sh.id LIMIT 1 Trx read view will not see trx with id >= 9404513, sees < 9404513 ---TRANSACTION 421409518518728, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518510296, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518497648, not started returning various info to MariaDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518392248, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518388032, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518366952, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518194096, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518189880, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518265768, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518105560, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518092912, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518581968, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518244688, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518573536, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518565104, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518552456, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518485000, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518472352, ACTIVE 250 sec fetching rows mysql tables in use 5, locked 5 1223 lock struct(s), heap size 188536, 117701 row lock(s) MySQL thread id 20398, OS thread handle 139934065911552, query id 52412101 localhost root Sending data CREATE TEMPORARY TABLE tmp_acs_coord_payment (INDEX my_index(id_paid_money)) SELECT id_doc as id_paid_money FROM coordination_history_status LEFT JOIN coordination_view coordination ON id_coordination = coordination.id WHERE id_user = '595' AND coordination.element_table_name='paid_money' GROUP BY id_doc ---TRANSACTION 421409518468136, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518425976, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518295280, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518274200, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518101344, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518278416, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518522944, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518514512, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518506080, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518303712, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518130856, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518126640, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518442840, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518345872, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518417544, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518409112, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518400680, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518316360, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518299496, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518223608, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518122424, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518097128, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518261552, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518248904, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518160368, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518489216, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518455488, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518451272, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518147720, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518156152, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518421760, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518350088, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518329008, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518210960, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518312144, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518307928, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518257336, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518088696, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518628344, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518590400, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518569320, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518548240, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518544024, ACTIVE 249 sec starting index read mysql tables in use 15, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 20140, OS thread handle 139933669193472, query id 52422343 localhost root Creating sort index SELECT CAST(CONCAT('Индивидуальная ставка_',`eir`.`individual_rate`) as char(50)) INTO @individual_rate FROM `employee_individual_rate` `eir` WHERE `eir`.`id_employee` = NAME_CONST('id_employee_param',7779) AND `eir`.`id_unit_of_measure` = NAME_CONST('id_unit_of_measure_param',4) AND (`eir`.`id_category_client` = NAME_CONST('id_category_client_param',43) OR `eir`.`id_category_client` = 0) AND (`eir`.`id_client` = NAME_CONST('id_client_param',34) OR `eir`.`id_client` = 0) ORDER BY id_client DESC, id_category_client DESC LIMIT 1 Trx read view will not see trx with id >= 9404558, sees < 9404558 ---TRANSACTION 421409518320576, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518219392, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518215176, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518362736, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518084480, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518206744, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518476568, not started returning various info to MariaDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421409518076048, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (write thread) I/O thread 7 state: waiting for completed aio requests (write thread) I/O thread 8 state: waiting for completed aio requests (write thread) I/O thread 9 state: waiting for completed aio requests (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 0; buffer pool: 0 18915912 OS file reads, 765597 OS file writes, 157594 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 69, seg size 71, 22308 merges merged operations: insert 28627, delete mark 11490, delete 3572 discarded operations: insert 0, delete mark 0, delete 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2020-12-24 11:49:52 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 259.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:49:52 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:49:52 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 256.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:49:52 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 259.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:49:52 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 256.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:49:52 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 256.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:49:52 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 256.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:49:52 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 257.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:49:52 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 258.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:49:52 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 241.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:49:52 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:49:52 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 270.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:49:52 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:49:52 0 [Note] InnoDB: A semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 259.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:49:52 0 [Note] InnoDB: A semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:49:52 0 [Note] InnoDB: A semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 256.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:49:52 0 [Note] InnoDB: A semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 259.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:49:52 0 [Note] InnoDB: A semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 256.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:49:52 0 [Note] InnoDB: A semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 256.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:49:52 0 [Note] InnoDB: A semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 23.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:49:52 0 [Note] InnoDB: A semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 256.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:49:52 0 [Note] InnoDB: A semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 257.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:49:52 0 [Note] InnoDB: A semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 258.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:49:52 0 [Note] InnoDB: A semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 241.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:49:52 0 [Note] InnoDB: A semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:49:52 0 [Note] InnoDB: A semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 270.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:49:52 0 [Note] InnoDB: A semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2020-12-24 11:50:23 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 290.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:50:23 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:50:23 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 287.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:23 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 290.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:23 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 287.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:23 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 287.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:23 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 287.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:23 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 288.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:23 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 289.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:23 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 272.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:23 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:50:23 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 301.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:50:23 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:50:23 0 [Note] InnoDB: A semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 290.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:50:23 0 [Note] InnoDB: A semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:50:23 0 [Note] InnoDB: A semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 287.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:23 0 [Note] InnoDB: A semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 290.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:23 0 [Note] InnoDB: A semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 287.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:23 0 [Note] InnoDB: A semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 287.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:23 0 [Note] InnoDB: A semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 54.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:50:23 0 [Note] InnoDB: A semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 287.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:23 0 [Note] InnoDB: A semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 288.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:23 0 [Note] InnoDB: A semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 289.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:23 0 [Note] InnoDB: A semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 272.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:23 0 [Note] InnoDB: A semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:50:23 0 [Note] InnoDB: A semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 301.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:50:23 0 [Note] InnoDB: A semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2020-12-24 11:50:54 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 321.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:50:54 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 334.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:50:54 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 318.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:54 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 321.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:54 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 318.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:54 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 318.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:54 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 318.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:54 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 319.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:54 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 320.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:54 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 303.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:54 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 334.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:50:54 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 332.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:50:54 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 334.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:50:54 0 [Note] InnoDB: A semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 321.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:50:54 0 [Note] InnoDB: A semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 334.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:50:54 0 [Note] InnoDB: A semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 318.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:54 0 [Note] InnoDB: A semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 321.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:54 0 [Note] InnoDB: A semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 318.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:54 0 [Note] InnoDB: A semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 318.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:54 0 [Note] InnoDB: A semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 85.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:50:54 0 [Note] InnoDB: A semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 318.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:54 0 [Note] InnoDB: A semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 319.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:54 0 [Note] InnoDB: A semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 320.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:54 0 [Note] InnoDB: A semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 303.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:50:54 0 [Note] InnoDB: A semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 334.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:50:54 0 [Note] InnoDB: A semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 332.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:50:54 0 [Note] InnoDB: A semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 334.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2020-12-24 11:51:25 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 352.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:51:25 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 365.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:51:25 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 349.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:25 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 352.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:25 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 349.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:25 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 349.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:25 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 349.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:25 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 350.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:25 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 351.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:25 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 334.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:25 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 365.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:51:25 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 363.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:51:25 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 365.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:51:25 0 [Note] InnoDB: A semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 352.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:51:25 0 [Note] InnoDB: A semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 365.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:51:25 0 [Note] InnoDB: A semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 349.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:25 0 [Note] InnoDB: A semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 352.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:25 0 [Note] InnoDB: A semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 349.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:25 0 [Note] InnoDB: A semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 349.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:25 0 [Note] InnoDB: A semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 116.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:51:25 0 [Note] InnoDB: A semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 349.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:25 0 [Note] InnoDB: A semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 350.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:25 0 [Note] InnoDB: A semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 351.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:25 0 [Note] InnoDB: A semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 334.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:25 0 [Note] InnoDB: A semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 365.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:51:25 0 [Note] InnoDB: A semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 363.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:51:25 0 [Note] InnoDB: A semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 365.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2020-12-24 11:51:56 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 383.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:51:56 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 396.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:51:56 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 380.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:56 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 383.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:56 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 380.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:56 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 380.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:56 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 380.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:56 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 381.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:56 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 382.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:56 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 365.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:56 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 396.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:51:56 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 394.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:51:56 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 396.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:51:56 0 [Note] InnoDB: A semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 383.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:51:56 0 [Note] InnoDB: A semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 396.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:51:56 0 [Note] InnoDB: A semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 380.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:56 0 [Note] InnoDB: A semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 383.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:56 0 [Note] InnoDB: A semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 380.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:56 0 [Note] InnoDB: A semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 380.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:56 0 [Note] InnoDB: A semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 147.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:51:56 0 [Note] InnoDB: A semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 380.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:56 0 [Note] InnoDB: A semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 381.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:56 0 [Note] InnoDB: A semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 382.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:56 0 [Note] InnoDB: A semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 365.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:51:56 0 [Note] InnoDB: A semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 396.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:51:56 0 [Note] InnoDB: A semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 394.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:51:56 0 [Note] InnoDB: A semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 396.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2020-12-24 11:52:27 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 414.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:52:27 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 427.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:52:27 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 411.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:27 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 414.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:27 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 411.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:27 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 411.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:27 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 411.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:27 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 412.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:27 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 413.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:27 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 396.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:27 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 427.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:52:27 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 425.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:52:27 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 427.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:52:27 0 [Note] InnoDB: A semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 414.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:52:27 0 [Note] InnoDB: A semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 427.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:52:27 0 [Note] InnoDB: A semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 411.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:27 0 [Note] InnoDB: A semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 414.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:27 0 [Note] InnoDB: A semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 411.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:27 0 [Note] InnoDB: A semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 411.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:27 0 [Note] InnoDB: A semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 178.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:52:27 0 [Note] InnoDB: A semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 411.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:27 0 [Note] InnoDB: A semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 412.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:27 0 [Note] InnoDB: A semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 413.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:27 0 [Note] InnoDB: A semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 396.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:27 0 [Note] InnoDB: A semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 427.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:52:27 0 [Note] InnoDB: A semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 425.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:52:27 0 [Note] InnoDB: A semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 427.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2020-12-24 11:52:58 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 445.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:52:58 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 458.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:52:58 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 442.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:58 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 445.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:58 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 442.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:58 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 442.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:58 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 442.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:58 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 443.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:58 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 444.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:58 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 427.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:58 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 458.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:52:58 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 456.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:52:58 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 458.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:52:58 0 [Note] InnoDB: A semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 445.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:52:58 0 [Note] InnoDB: A semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 458.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:52:58 0 [Note] InnoDB: A semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 442.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:58 0 [Note] InnoDB: A semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 445.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:58 0 [Note] InnoDB: A semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 442.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:58 0 [Note] InnoDB: A semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 442.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:58 0 [Note] InnoDB: A semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 209.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:52:58 0 [Note] InnoDB: A semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 442.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:58 0 [Note] InnoDB: A semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 443.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:58 0 [Note] InnoDB: A semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 444.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:58 0 [Note] InnoDB: A semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 427.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:52:58 0 [Note] InnoDB: A semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 458.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:52:58 0 [Note] InnoDB: A semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 456.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:52:58 0 [Note] InnoDB: A semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 458.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2020-12-24 11:53:29 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 476.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:53:29 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 489.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:53:29 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 473.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:53:29 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 476.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:53:29 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 473.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:53:29 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 473.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:53:29 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 473.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:53:29 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 474.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:53:29 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 475.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:53:29 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 458.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:53:29 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 489.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:53:29 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 487.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:53:29 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 489.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:53:29 0 [Note] InnoDB: A semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 476.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:53:29 0 [Note] InnoDB: A semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 489.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:53:29 0 [Note] InnoDB: A semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 473.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:53:29 0 [Note] InnoDB: A semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 476.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:53:29 0 [Note] InnoDB: A semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 473.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:53:29 0 [Note] InnoDB: A semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 473.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:53:29 0 [Note] InnoDB: A semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 240.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:53:29 0 [Note] InnoDB: A semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 473.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:53:29 0 [Note] InnoDB: A semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 474.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:53:29 0 [Note] InnoDB: A semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 475.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:53:29 0 [Note] InnoDB: A semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 458.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:53:29 0 [Note] InnoDB: A semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 489.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:53:29 0 [Note] InnoDB: A semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 487.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:53:29 0 [Note] InnoDB: A semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 489.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2020-12-24 11:54:00 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 507.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:54:00 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 520.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:54:00 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 504.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:00 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 507.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:00 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 504.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:00 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 504.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:00 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 271.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:54:00 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 504.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:00 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 505.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:00 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 506.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:00 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 489.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:00 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 520.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:54:00 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 518.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:54:00 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 520.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:54:00 0 [Note] InnoDB: A semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 507.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:54:00 0 [Note] InnoDB: A semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 520.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:54:00 0 [Note] InnoDB: A semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 504.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:00 0 [Note] InnoDB: A semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 507.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:00 0 [Note] InnoDB: A semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 504.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:00 0 [Note] InnoDB: A semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 504.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:00 0 [Note] InnoDB: A semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 271.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:54:00 0 [Note] InnoDB: A semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 504.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:00 0 [Note] InnoDB: A semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 505.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:00 0 [Note] InnoDB: A semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 506.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:00 0 [Note] InnoDB: A semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 489.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:00 0 [Note] InnoDB: A semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 520.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:54:00 0 [Note] InnoDB: A semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 518.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:54:00 0 [Note] InnoDB: A semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 520.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2020-12-24 11:54:31 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 538.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:54:31 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 551.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:54:31 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 535.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:31 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 538.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:31 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 535.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:31 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 535.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:31 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 302.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:54:31 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 535.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:31 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 536.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:31 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 537.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:31 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 520.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:31 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 551.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:54:31 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 549.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:54:31 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 551.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:54:31 0 [Note] InnoDB: A semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 538.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:54:31 0 [Note] InnoDB: A semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 551.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:54:31 0 [Note] InnoDB: A semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 535.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:31 0 [Note] InnoDB: A semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 538.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:31 0 [Note] InnoDB: A semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 535.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:31 0 [Note] InnoDB: A semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 535.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:31 0 [Note] InnoDB: A semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 302.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:54:31 0 [Note] InnoDB: A semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 535.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:31 0 [Note] InnoDB: A semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 536.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:31 0 [Note] InnoDB: A semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 537.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:31 0 [Note] InnoDB: A semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 520.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:54:31 0 [Note] InnoDB: A semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 551.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:54:31 0 [Note] InnoDB: A semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 549.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:54:31 0 [Note] InnoDB: A semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 551.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2020-12-24 11:55:02 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 569.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:55:02 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 582.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:55:02 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 566.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:02 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 569.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:02 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 566.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:02 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 566.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:02 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 333.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:55:02 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 566.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:02 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 567.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:02 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 568.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:02 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 551.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:02 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 582.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:55:02 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 580.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:55:02 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 582.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:55:02 0 [Note] InnoDB: A semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 569.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:55:02 0 [Note] InnoDB: A semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 582.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:55:02 0 [Note] InnoDB: A semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 566.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:02 0 [Note] InnoDB: A semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 569.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:02 0 [Note] InnoDB: A semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 566.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:02 0 [Note] InnoDB: A semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 566.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:02 0 [Note] InnoDB: A semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 333.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:55:02 0 [Note] InnoDB: A semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 566.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:02 0 [Note] InnoDB: A semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 567.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:02 0 [Note] InnoDB: A semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 568.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:02 0 [Note] InnoDB: A semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 551.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:02 0 [Note] InnoDB: A semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 582.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:55:02 0 [Note] InnoDB: A semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 580.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:55:02 0 [Note] InnoDB: A semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 582.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2020-12-24 11:55:33 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 600.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:55:33 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 613.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:55:33 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 597.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:33 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 600.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:33 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 597.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:33 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 597.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:33 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 364.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:55:33 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 597.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:33 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 598.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:33 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 599.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:33 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 582.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:33 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 613.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:55:33 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 611.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:55:33 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 613.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:55:33 0 [Note] InnoDB: A semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 600.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:55:33 0 [Note] InnoDB: A semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 613.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:55:33 0 [Note] InnoDB: A semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 597.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:33 0 [Note] InnoDB: A semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 600.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:33 0 [Note] InnoDB: A semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 597.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:33 0 [Note] InnoDB: A semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 597.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:33 0 [Note] InnoDB: A semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 364.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:55:33 0 [Note] InnoDB: A semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 597.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:33 0 [Note] InnoDB: A semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 598.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:33 0 [Note] InnoDB: A semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 599.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:33 0 [Note] InnoDB: A semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 582.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:55:33 0 [Note] InnoDB: A semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 613.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:55:33 0 [Note] InnoDB: A semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 611.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:55:33 0 [Note] InnoDB: A semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 613.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2020-12-24 11:56:04 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 631.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:56:04 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 644.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:56:04 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 628.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:04 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 631.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:04 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 628.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:04 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 628.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:04 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 395.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:56:04 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 628.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:04 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 629.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:04 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 630.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:04 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 613.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:04 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 644.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:56:04 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 642.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:56:04 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 644.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:56:04 0 [Note] InnoDB: A semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 631.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:56:04 0 [Note] InnoDB: A semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 644.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:56:04 0 [Note] InnoDB: A semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 628.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:04 0 [Note] InnoDB: A semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 631.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:04 0 [Note] InnoDB: A semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 628.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:04 0 [Note] InnoDB: A semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 628.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:04 0 [Note] InnoDB: A semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 395.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:56:04 0 [Note] InnoDB: A semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 628.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:04 0 [Note] InnoDB: A semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 629.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:04 0 [Note] InnoDB: A semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 630.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:04 0 [Note] InnoDB: A semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 613.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:04 0 [Note] InnoDB: A semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 644.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:56:04 0 [Note] InnoDB: A semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 642.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:56:04 0 [Note] InnoDB: A semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 644.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2020-12-24 11:56:35 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 662.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:56:35 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 675.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:56:35 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 659.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:35 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 662.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:35 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 659.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:35 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 659.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:35 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 426.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:56:35 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 659.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:35 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 660.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:35 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 661.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:35 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 644.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:35 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 675.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:56:35 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 673.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:56:35 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 675.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:56:35 0 [Note] InnoDB: A semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 662.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:56:35 0 [Note] InnoDB: A semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 675.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:56:35 0 [Note] InnoDB: A semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 659.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:35 0 [Note] InnoDB: A semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 662.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:35 0 [Note] InnoDB: A semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 659.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:35 0 [Note] InnoDB: A semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 659.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:35 0 [Note] InnoDB: A semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 426.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:56:35 0 [Note] InnoDB: A semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 659.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:35 0 [Note] InnoDB: A semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 660.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:35 0 [Note] InnoDB: A semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 661.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:35 0 [Note] InnoDB: A semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 644.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:56:35 0 [Note] InnoDB: A semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 675.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:56:35 0 [Note] InnoDB: A semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 673.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:56:35 0 [Note] InnoDB: A semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 675.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2020-12-24 11:57:06 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 693.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:57:06 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 706.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:57:06 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 690.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:06 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 693.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:06 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 690.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:06 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 690.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:06 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 457.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:57:06 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 690.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:06 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 691.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:06 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 692.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:06 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 675.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:06 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 706.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:57:06 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 704.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:57:06 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 706.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:57:06 0 [Note] InnoDB: A semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 693.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:57:06 0 [Note] InnoDB: A semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 706.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:57:06 0 [Note] InnoDB: A semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 690.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:06 0 [Note] InnoDB: A semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 693.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:06 0 [Note] InnoDB: A semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 690.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:06 0 [Note] InnoDB: A semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 690.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:06 0 [Note] InnoDB: A semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 457.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:57:06 0 [Note] InnoDB: A semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 690.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:06 0 [Note] InnoDB: A semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 691.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:06 0 [Note] InnoDB: A semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 692.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:06 0 [Note] InnoDB: A semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 675.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:06 0 [Note] InnoDB: A semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 706.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:57:06 0 [Note] InnoDB: A semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 704.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:57:06 0 [Note] InnoDB: A semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 706.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2020-12-24 11:57:37 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 724.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:57:37 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 737.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:57:37 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 721.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:37 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 724.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:37 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 721.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:37 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 721.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:37 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 488.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:57:37 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 721.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:37 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 722.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:37 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 723.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:37 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 706.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:37 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 737.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:57:37 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 735.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:57:37 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 737.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:57:37 0 [Note] InnoDB: A semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 724.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:57:37 0 [Note] InnoDB: A semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 737.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:57:37 0 [Note] InnoDB: A semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 721.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:37 0 [Note] InnoDB: A semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 724.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:37 0 [Note] InnoDB: A semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 721.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:37 0 [Note] InnoDB: A semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 721.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:37 0 [Note] InnoDB: A semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 488.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:57:37 0 [Note] InnoDB: A semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 721.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:37 0 [Note] InnoDB: A semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 722.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:37 0 [Note] InnoDB: A semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 723.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:37 0 [Note] InnoDB: A semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 706.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:57:37 0 [Note] InnoDB: A semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 737.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:57:37 0 [Note] InnoDB: A semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 735.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:57:37 0 [Note] InnoDB: A semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 737.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2020-12-24 11:58:08 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 755.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:58:08 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 768.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:58:08 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 752.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:08 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 755.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:08 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 752.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:08 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 752.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:08 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 519.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:58:08 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 752.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:08 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 753.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:08 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 754.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:08 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 737.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:08 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 768.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:58:08 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 766.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:58:08 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 768.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:58:08 0 [Note] InnoDB: A semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 755.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:58:08 0 [Note] InnoDB: A semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 768.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:58:08 0 [Note] InnoDB: A semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 752.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:08 0 [Note] InnoDB: A semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 755.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:08 0 [Note] InnoDB: A semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 752.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:08 0 [Note] InnoDB: A semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 752.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:08 0 [Note] InnoDB: A semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 519.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:58:08 0 [Note] InnoDB: A semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 752.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:08 0 [Note] InnoDB: A semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 753.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:08 0 [Note] InnoDB: A semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 754.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:08 0 [Note] InnoDB: A semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 737.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:08 0 [Note] InnoDB: A semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 768.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:58:08 0 [Note] InnoDB: A semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 766.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:58:08 0 [Note] InnoDB: A semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 768.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2020-12-24 11:58:39 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 786.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:58:39 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 799.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:58:39 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 783.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:39 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 786.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:39 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 783.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:39 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 783.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:39 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 550.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:58:39 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 783.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:39 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 784.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:39 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 785.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:39 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 768.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:39 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 799.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:58:39 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 797.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:58:39 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 799.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:58:39 0 [Note] InnoDB: A semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 786.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:58:39 0 [Note] InnoDB: A semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 799.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:58:39 0 [Note] InnoDB: A semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 783.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:39 0 [Note] InnoDB: A semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 786.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:39 0 [Note] InnoDB: A semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 783.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:39 0 [Note] InnoDB: A semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 783.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:39 0 [Note] InnoDB: A semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 550.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:58:39 0 [Note] InnoDB: A semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 783.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:39 0 [Note] InnoDB: A semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 784.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:39 0 [Note] InnoDB: A semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 785.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:39 0 [Note] InnoDB: A semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 768.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:58:39 0 [Note] InnoDB: A semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 799.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:58:39 0 [Note] InnoDB: A semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 797.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:58:39 0 [Note] InnoDB: A semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 799.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2020-12-24 11:59:10 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 817.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:59:10 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 830.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:59:10 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 814.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:10 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 817.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:10 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 814.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:10 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 814.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:10 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 581.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:59:10 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 814.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:10 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 815.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:10 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 816.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:10 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 799.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:10 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 830.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:59:10 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 828.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:59:10 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 830.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:59:10 0 [Note] InnoDB: A semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 817.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:59:10 0 [Note] InnoDB: A semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 830.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:59:10 0 [Note] InnoDB: A semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 814.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:10 0 [Note] InnoDB: A semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 817.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:10 0 [Note] InnoDB: A semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 814.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:10 0 [Note] InnoDB: A semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 814.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:10 0 [Note] InnoDB: A semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 581.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:59:10 0 [Note] InnoDB: A semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 814.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:10 0 [Note] InnoDB: A semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 815.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:10 0 [Note] InnoDB: A semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 816.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:10 0 [Note] InnoDB: A semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 799.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:10 0 [Note] InnoDB: A semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 830.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:59:10 0 [Note] InnoDB: A semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 828.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:59:10 0 [Note] InnoDB: A semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 830.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2020-12-24 11:59:41 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 848.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:59:41 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 861.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:59:41 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 845.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:41 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 848.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:41 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 845.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:41 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 845.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:41 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 612.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:59:41 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 845.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:41 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 846.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:41 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 847.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:41 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 830.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:41 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 861.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:59:41 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 859.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:59:41 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 861.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:59:41 0 [Note] InnoDB: A semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 848.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:59:41 0 [Note] InnoDB: A semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 861.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:59:41 0 [Note] InnoDB: A semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 845.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:41 0 [Note] InnoDB: A semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 848.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:41 0 [Note] InnoDB: A semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 845.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:41 0 [Note] InnoDB: A semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 845.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:41 0 [Note] InnoDB: A semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 612.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:59:41 0 [Note] InnoDB: A semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 845.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:41 0 [Note] InnoDB: A semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 846.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:41 0 [Note] InnoDB: A semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 847.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:41 0 [Note] InnoDB: A semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 830.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 11:59:41 0 [Note] InnoDB: A semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 861.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:59:41 0 [Note] InnoDB: A semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 859.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 11:59:41 0 [Note] InnoDB: A semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 861.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2020-12-24 12:00:12 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 879.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 12:00:12 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 892.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 12:00:12 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 876.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:12 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 879.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:12 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 876.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:12 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 876.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:12 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 643.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 12:00:12 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 876.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:12 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 877.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:12 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 878.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:12 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 861.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:12 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 892.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 12:00:12 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 890.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 12:00:12 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 892.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 12:00:12 0 [Note] InnoDB: A semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 879.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 12:00:12 0 [Note] InnoDB: A semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 892.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 12:00:12 0 [Note] InnoDB: A semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 876.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:12 0 [Note] InnoDB: A semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 879.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:12 0 [Note] InnoDB: A semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 876.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:12 0 [Note] InnoDB: A semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 876.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:12 0 [Note] InnoDB: A semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 643.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 12:00:12 0 [Note] InnoDB: A semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 876.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:12 0 [Note] InnoDB: A semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 877.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:12 0 [Note] InnoDB: A semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 878.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:12 0 [Note] InnoDB: A semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 861.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:12 0 [Note] InnoDB: A semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 892.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 12:00:12 0 [Note] InnoDB: A semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 890.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 12:00:12 0 [Note] InnoDB: A semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 892.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2020-12-24 12:00:43 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 910.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 12:00:43 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 923.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 12:00:43 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 907.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:43 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 910.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:43 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 907.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:43 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 907.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:43 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 674.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 12:00:43 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 907.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:43 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 908.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:43 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 909.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:43 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 892.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:43 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 923.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 12:00:43 0 [Warning] InnoDB: A long semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 921.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 12:00:43 0 [Warning] InnoDB: A long semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 923.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 12:00:43 0 [Note] InnoDB: A semaphore wait: --Thread 139934086178560 has waited at btr0sea.h line 266 for 910.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 12:00:43 0 [Note] InnoDB: A semaphore wait: --Thread 139933663459072 has waited at btr0sea.cc line 946 for 923.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 12:00:43 0 [Note] InnoDB: A semaphore wait: --Thread 139933674313472 has waited at dict0dict.cc line 348 for 907.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:43 0 [Note] InnoDB: A semaphore wait: --Thread 139933668169472 has waited at dict0dict.cc line 973 for 910.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:43 0 [Note] InnoDB: A semaphore wait: --Thread 139934532060928 has waited at dict0dict.cc line 973 for 907.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:43 0 [Note] InnoDB: A semaphore wait: --Thread 139934537262848 has waited at dict0dict.cc line 348 for 907.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:43 0 [Note] InnoDB: A semaphore wait: --Thread 139934111356672 has waited at btr0sea.ic line 91 for 674.00 seconds the semaphore: X-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 12:00:43 0 [Note] InnoDB: A semaphore wait: --Thread 139934539310848 has waited at dict0dict.cc line 973 for 907.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:43 0 [Note] InnoDB: A semaphore wait: --Thread 139934196270848 has waited at dict0dict.cc line 973 for 908.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:43 0 [Note] InnoDB: A semaphore wait: --Thread 139933666326272 has waited at ha_innodb.cc line 14179 for 909.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:43 0 [Note] InnoDB: A semaphore wait: --Thread 139933663254272 has waited at ha_innodb.cc line 14179 for 892.00 seconds the semaphore: Mutex at 0x56477791e5c0, Mutex DICT_SYS created dict0dict.cc:909, lock var 2 2020-12-24 12:00:43 0 [Note] InnoDB: A semaphore wait: --Thread 139934066935552 has waited at btr0sea.cc line 1135 for 923.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 12:00:43 0 [Note] InnoDB: A semaphore wait: --Thread 139934209169152 has waited at btr0sea.cc line 1135 for 921.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 2020-12-24 12:00:43 0 [Note] InnoDB: A semaphore wait: --Thread 139933669193472 has waited at btr0sea.cc line 946 for 923.00 seconds the semaphore: S-lock on RW-latch at 0x564777547c00 created in file btr0sea.cc line 240 a writer (thread id 139934065911552) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time write locked in file btr0sea.cc line 1210 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2020-12-24 12:01:13 0 [ERROR] [FATAL] InnoDB: Semaphore wait has lasted > 600 seconds. We intentionally crash the server because it appears to be hung.