2021-03-31 10:29:06+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server started. 2021-03-31 10:29:07+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' 2021-03-31 10:29:07+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server started. 2021-03-31 10:29:07+00:00 [Note] [Entrypoint]: Initializing database files 2021-03-31T10:29:07.124540Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2021-03-31T10:29:07.154596Z 0 [Warning] InnoDB: New log files created, LSN=45790 2021-03-31T10:29:07.239070Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2021-03-31T10:29:07.296986Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: ec606b97-920b-11eb-89d0-0242ac110004. 2021-03-31T10:29:07.297109Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2021-03-31T10:29:07.541338Z 0 [Warning] CA certificate ca.pem is self signed. 2021-03-31T10:29:07.575676Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. 2021-03-31 10:29:09+00:00 [Note] [Entrypoint]: Database files initialized 2021-03-31 10:29:09+00:00 [Note] [Entrypoint]: Starting temporary server 2021-03-31 10:29:09+00:00 [Note] [Entrypoint]: Waiting for server startup 2021-03-31T10:29:09.826541Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2021-03-31T10:29:09.826610Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2021-03-31T10:29:09.826640Z 0 [Note] mysqld (mysqld 5.7.33-debug) starting as process 78 ... 2021-03-31T10:29:09.830387Z 0 [Note] InnoDB: PUNCH HOLE support available 2021-03-31T10:29:09.830401Z 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2021-03-31T10:29:09.830405Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-03-31T10:29:09.830407Z 0 [Note] InnoDB: Uses event mutexes 2021-03-31T10:29:09.830410Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2021-03-31T10:29:09.830412Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-03-31T10:29:09.830676Z 0 [Note] InnoDB: Number of pools: 1 2021-03-31T10:29:09.830748Z 0 [Note] InnoDB: Using CPU crc32 instructions 2021-03-31T10:29:09.831753Z 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-03-31T10:29:09.836804Z 0 [Note] InnoDB: Completed initialization of buffer pool 2021-03-31T10:29:09.837739Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-03-31T10:29:09.851571Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2021-03-31T10:29:09.879264Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-03-31T10:29:09.879308Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-03-31T10:29:09.881636Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-03-31T10:29:09.887108Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2021-03-31T10:29:09.887118Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2021-03-31T10:29:09.887553Z 0 [Note] InnoDB: Waiting for purge to start 2021-03-31T10:29:09.937900Z 0 [Note] InnoDB: 5.7.33 started; log sequence number 2746838 2021-03-31T10:29:09.938162Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2021-03-31T10:29:09.938445Z 0 [Note] Plugin 'FEDERATED' is disabled. 2021-03-31T10:29:09.940629Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210331 10:29:09 2021-03-31T10:29:09.944430Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2021-03-31T10:29:09.944439Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2021-03-31T10:29:09.944878Z 0 [Warning] CA certificate ca.pem is self signed. 2021-03-31T10:29:09.944904Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2021-03-31T10:29:09.949992Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory. 2021-03-31T10:29:09.967643Z 0 [Note] Event Scheduler: Loaded 0 events 2021-03-31T10:29:09.967965Z 0 [Note] mysqld: ready for connections. Version: '5.7.33-debug' socket: '/var/run/mysqld/mysqld.sock' port: 0 Source distribution 2021-03-31 10:29:10+00:00 [Note] [Entrypoint]: Temporary server started. Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it. 2021-03-31 10:29:18+00:00 [Note] [Entrypoint]: Creating database testdb 2021-03-31 10:29:18+00:00 [Note] [Entrypoint]: Creating user user 2021-03-31 10:29:18+00:00 [Note] [Entrypoint]: Giving user user access to schema testdb 2021-03-31 10:29:18+00:00 [Note] [Entrypoint]: Stopping temporary server 2021-03-31T10:29:18.655703Z 0 [Note] Giving 0 client threads a chance to die gracefully 2021-03-31T10:29:18.655718Z 0 [Note] Shutting down slave threads 2021-03-31T10:29:18.655725Z 0 [Note] Forcefully disconnecting 0 remaining clients 2021-03-31T10:29:18.655731Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2021-03-31T10:29:18.655760Z 0 [Note] Binlog end 2021-03-31T10:29:18.656215Z 0 [Note] Shutting down plugin 'ngram' 2021-03-31T10:29:18.656222Z 0 [Note] Shutting down plugin 'partition' 2021-03-31T10:29:18.656225Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2021-03-31T10:29:18.656228Z 0 [Note] Shutting down plugin 'ARCHIVE' 2021-03-31T10:29:18.656230Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2021-03-31T10:29:18.656271Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2021-03-31T10:29:18.656275Z 0 [Note] Shutting down plugin 'MyISAM' 2021-03-31T10:29:18.656283Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2021-03-31T10:29:18.656287Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2021-03-31T10:29:18.656290Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2021-03-31T10:29:18.656292Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2021-03-31T10:29:18.656296Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2021-03-31T10:29:18.656298Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2021-03-31T10:29:18.656301Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2021-03-31T10:29:18.656305Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2021-03-31T10:29:18.656307Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2021-03-31T10:29:18.656309Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2021-03-31T10:29:18.656313Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2021-03-31T10:29:18.656315Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2021-03-31T10:29:18.656318Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2021-03-31T10:29:18.656320Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2021-03-31T10:29:18.656324Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2021-03-31T10:29:18.656326Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2021-03-31T10:29:18.656329Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2021-03-31T10:29:18.656332Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2021-03-31T10:29:18.656335Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2021-03-31T10:29:18.656337Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2021-03-31T10:29:18.656339Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2021-03-31T10:29:18.656342Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2021-03-31T10:29:18.656345Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2021-03-31T10:29:18.656348Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2021-03-31T10:29:18.656350Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2021-03-31T10:29:18.656353Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2021-03-31T10:29:18.656356Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2021-03-31T10:29:18.656358Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2021-03-31T10:29:18.656361Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2021-03-31T10:29:18.656364Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2021-03-31T10:29:18.656366Z 0 [Note] Shutting down plugin 'MEMORY' 2021-03-31T10:29:18.656371Z 0 [Note] Shutting down plugin 'CSV' 2021-03-31T10:29:18.656374Z 0 [Note] Shutting down plugin 'sha256_password' 2021-03-31T10:29:18.656377Z 0 [Note] Shutting down plugin 'mysql_native_password' 2021-03-31T10:29:18.656438Z 0 [Note] Shutting down plugin 'binlog' 2021-03-31T10:29:18.656445Z 0 [Note] Shutting down plugin 'InnoDB' 2021-03-31T10:29:18.656483Z 0 [Note] InnoDB: FTS optimize thread exiting. 2021-03-31T10:29:18.656579Z 0 [Note] InnoDB: Starting shutdown... 2021-03-31T10:29:18.756900Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2021-03-31T10:29:18.757389Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210331 10:29:18 2021-03-31T10:29:19.367655Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12664279 2021-03-31T10:29:19.371218Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-03-31T10:29:19.375201Z 0 [Note] mysqld: Shutdown complete 2021-03-31 10:29:19+00:00 [Note] [Entrypoint]: Temporary server stopped 2021-03-31 10:29:19+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up. 2021-03-31T10:29:19.846896Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2021-03-31T10:29:19.847075Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2021-03-31T10:29:19.847122Z 0 [Note] mysqld (mysqld 5.7.33-debug) starting as process 1 ... 2021-03-31T10:29:19.852339Z 0 [Note] InnoDB: PUNCH HOLE support available 2021-03-31T10:29:19.852358Z 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2021-03-31T10:29:19.852362Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-03-31T10:29:19.852364Z 0 [Note] InnoDB: Uses event mutexes 2021-03-31T10:29:19.852366Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2021-03-31T10:29:19.852369Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-03-31T10:29:19.852631Z 0 [Note] InnoDB: Number of pools: 1 2021-03-31T10:29:19.852706Z 0 [Note] InnoDB: Using CPU crc32 instructions 2021-03-31T10:29:19.853725Z 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-03-31T10:29:19.858756Z 0 [Note] InnoDB: Completed initialization of buffer pool 2021-03-31T10:29:19.859619Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-03-31T10:29:19.871444Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2021-03-31T10:29:19.892291Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-03-31T10:29:19.892340Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-03-31T10:29:19.894876Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-03-31T10:29:19.900570Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2021-03-31T10:29:19.900583Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2021-03-31T10:29:19.901011Z 0 [Note] InnoDB: Waiting for purge to start 2021-03-31T10:29:19.951337Z 0 [Note] InnoDB: 5.7.33 started; log sequence number 12664279 2021-03-31T10:29:19.951613Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2021-03-31T10:29:19.951944Z 0 [Note] Plugin 'FEDERATED' is disabled. 2021-03-31T10:29:19.960003Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210331 10:29:19 2021-03-31T10:29:19.960610Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2021-03-31T10:29:19.960620Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2021-03-31T10:29:19.961086Z 0 [Warning] CA certificate ca.pem is self signed. 2021-03-31T10:29:19.961114Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2021-03-31T10:29:19.961194Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2021-03-31T10:29:19.961222Z 0 [Note] IPv6 is available. 2021-03-31T10:29:19.961228Z 0 [Note] - '::' resolves to '::'; 2021-03-31T10:29:19.961239Z 0 [Note] Server socket created on IP: '::'. 2021-03-31T10:29:19.966152Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory. 2021-03-31T10:29:19.995694Z 0 [Note] Event Scheduler: Loaded 0 events 2021-03-31T10:29:19.995953Z 0 [Note] mysqld: ready for connections. Version: '5.7.33-debug' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Source distribution 2021-03-31T10:29:21.995847Z 4 [Note] Aborted connection 4 to db: 'testdb' user: 'user' host: '172.17.0.1' (Got an error reading communication packets) 2021-03-31T10:29:21.997519Z 3 [Note] Aborted connection 3 to db: 'testdb' user: 'user' host: '172.17.0.1' (Got an error reading communication packets) 2021-03-31T10:34:39.953005Z 0 [Warning] InnoDB: A long semaphore wait: --Thread 140088797288192 has waited at row0row.cc line 999 for 241 seconds the semaphore: X-lock on RW-latch at 0x7f690e8d6e90 created in file buf0buf.cc line 1462 a writer (thread id 140088939898624) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time read locked in file row0sel.cc line 1343 Last time write locked in file /build/mysql-5.7.33/storage/innobase/buf/buf0flu.cc line 1179 2021-03-31T10:34:39.953041Z 0 [Warning] InnoDB: A long semaphore wait: --Thread 140088805680896 has waited at row0row.cc line 999 for 241 seconds the semaphore: X-lock on RW-latch at 0x7f690e8d6e90 created in file buf0buf.cc line 1462 a writer (thread id 140088939898624) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time read locked in file row0sel.cc line 1343 Last time write locked in file /build/mysql-5.7.33/storage/innobase/buf/buf0flu.cc line 1179 2021-03-31T10:34:39.953052Z 0 [Warning] InnoDB: A long semaphore wait: --Thread 140089048938240 has waited at btr0sea.cc line 1307 for 241 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x556982eff2f8 created in file btr0sea.cc line 203 a writer (thread id 140089048938240) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.cc line 1211 Last time write locked in file /build/mysql-5.7.33/storage/innobase/btr/btr0sea.cc line 1307 2021-03-31T10:34:39.953061Z 0 [Warning] InnoDB: A long semaphore wait: --Thread 140088897935104 has waited at row0row.cc line 999 for 241 seconds the semaphore: X-lock on RW-latch at 0x7f690e8d6e90 created in file buf0buf.cc line 1462 a writer (thread id 140088939898624) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time read locked in file row0sel.cc line 1343 Last time write locked in file /build/mysql-5.7.33/storage/innobase/buf/buf0flu.cc line 1179 2021-03-31T10:34:39.953068Z 0 [Warning] InnoDB: A long semaphore wait: --Thread 140088814073600 has waited at row0row.cc line 999 for 241 seconds the semaphore: X-lock on RW-latch at 0x7f690e8d6e90 created in file buf0buf.cc line 1462 a writer (thread id 140088939898624) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time read locked in file row0sel.cc line 1343 Last time write locked in file /build/mysql-5.7.33/storage/innobase/buf/buf0flu.cc line 1179 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 2021-03-31 10:34:59 0x7f68fdffb700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 35 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 61 srv_active, 0 srv_shutdown, 20 srv_idle srv_master_thread log flush and writes: 80 ---------- SEMAPHORES ---------- ------------- RW-LATCH INFO ------------- RW-LOCK: 0x556982ffc140 Locked: thread 140088805680896 file btr0cur.cc line 1011 S-LOCK Locked: thread 140088897935104 file btr0cur.cc line 1011 S-LOCK Locked: thread 140088814073600 file btr0cur.cc line 1011 S-LOCK Locked: thread 140088797288192 file btr0cur.cc line 1011 S-LOCK RW-LOCK: 0x556982ffefb8 Waiters for the lock exist Locked: thread 140088906327808 file srv0srv.cc line 1989 WAIT X-LOCK Locked: thread 140088805680896 file row0purge.cc line 882 S-LOCK Locked: thread 140088814073600 file row0purge.cc line 882 S-LOCK Locked: thread 140088897935104 file row0purge.cc line 882 S-LOCK Locked: thread 140088797288192 file row0purge.cc line 882 S-LOCK RW-LOCK: 0x556982eff988 Locked: thread 140089174099712 file btr0sea.ic line 154 S-LOCK RW-LOCK: 0x556982eff758 Locked: thread 140089174099712 file btr0sea.ic line 154 S-LOCK RW-LOCK: 0x556982eff528 Locked: thread 140089174099712 file btr0sea.ic line 154 S-LOCK RW-LOCK: 0x556982eff2f8 Waiters for the lock exist Locked: thread 140089048938240 file btr0sea.cc line 1307 WAIT X-LOCK Locked: thread 140089174099712 file btr0sea.ic line 154 S-LOCK RW-LOCK: 0x556982eff0c8 Locked: thread 140089174099712 file btr0sea.ic line 154 S-LOCK RW-LOCK: 0x556982efee98 Locked: thread 140089174099712 file btr0sea.ic line 154 S-LOCK RW-LOCK: 0x556982efec68 Locked: thread 140089174099712 file btr0sea.ic line 154 S-LOCK RW-LOCK: 0x556982efea38 Locked: thread 140089174099712 file btr0sea.ic line 154 S-LOCK RW-LOCK: 0x7f690e8e8dc8 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e8e6b10 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e8e25a0 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e8e15d8 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e8dc3c8 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e8d6fc8 Locked: thread 140088805680896 file row0row.cc line 999 S-LOCK Locked: thread 140088897935104 file row0row.cc line 999 S-LOCK Locked: thread 140088814073600 file row0row.cc line 999 S-LOCK Locked: thread 140088797288192 file row0row.cc line 999 S-LOCK RW-LOCK: 0x7f690e8d6e90 Waiters for the lock exist Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e8d1630 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e8cca70 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e8cc420 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e8c9b18 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e8c45e0 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e8c2328 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e8c1688 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e8bc150 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e8a6948 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e8a4040 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e89ee30 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e89a270 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e897fb8 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e8907c8 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e88fb28 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e888010 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e8850b8 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e87f208 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e87e890 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e87da00 Locked: thread 140088805680896 file row0row.cc line 999 S-LOCK Locked: thread 140088897935104 file row0row.cc line 999 S-LOCK Locked: thread 140088814073600 file row0row.cc line 999 S-LOCK Locked: thread 140088797288192 file row0row.cc line 999 S-LOCK RW-LOCK: 0x7f690e87d8c8 Locked: thread 140088805680896 file row0row.cc line 999 S-LOCK Locked: thread 140088897935104 file row0row.cc line 999 S-LOCK Locked: thread 140088814073600 file row0row.cc line 999 S-LOCK Locked: thread 140088797288192 file row0row.cc line 999 S-LOCK RW-LOCK: 0x7f690e8799a8 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e8760d8 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e870ec8 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e86d920 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e86cc80 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e86b340 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e867d98 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e867a70 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e861570 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e8605a8 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e85ff58 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e85c038 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e85bd10 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e85a6f8 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e856e28 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e853880 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e84f638 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e84d380 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e847e48 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e845540 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e8394b8 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e833f80 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e82ed70 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 RW-LOCK: 0x7f690e8268e0 Locked: thread 140088939898624 file buf0flu.cc line 1179 SX-LOCK pass value 2 Total number of rw-locks 2831 OS WAIT ARRAY INFO: reservation count 18547 --Thread 140088780502784 has waited at dict0stats.cc line 2412 for 183 seconds the semaphore: X-lock on RW-latch at 0x556982ffefb8 created in file dict0dict.cc line 1228 a writer (thread id 140088906327808) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffffffffffc Last time read locked in file row0purge.cc line 882 Last time write locked in file /build/mysql-5.7.33/storage/innobase/row/row0trunc.cc line 1851 --Thread 140088797288192 has waited at row0row.cc line 999 for 261 seconds the semaphore: X-lock on RW-latch at 0x7f690e8d6e90 created in file buf0buf.cc line 1462 a writer (thread id 140088939898624) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time read locked in file row0sel.cc line 1343 Last time write locked in file /build/mysql-5.7.33/storage/innobase/buf/buf0flu.cc line 1179 --Thread 140089173559040 has waited at row0sel.cc line 1673 for 208 seconds the semaphore: S-lock on RW-latch at 0x556982eff2f8 created in file btr0sea.cc line 203 a writer (thread id 140089048938240) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.cc line 1211 Last time write locked in file /build/mysql-5.7.33/storage/innobase/btr/btr0sea.cc line 1307 --Thread 140088906327808 has waited at srv0srv.cc line 1989 for 259 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x556982ffefb8 created in file dict0dict.cc line 1228 a writer (thread id 140088906327808) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffffffffffc Last time read locked in file row0purge.cc line 882 Last time write locked in file /build/mysql-5.7.33/storage/innobase/row/row0trunc.cc line 1851 --Thread 140088805680896 has waited at row0row.cc line 999 for 261 seconds the semaphore: X-lock on RW-latch at 0x7f690e8d6e90 created in file buf0buf.cc line 1462 a writer (thread id 140088939898624) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time read locked in file row0sel.cc line 1343 Last time write locked in file /build/mysql-5.7.33/storage/innobase/buf/buf0flu.cc line 1179 --Thread 140089173829376 has waited at row0sel.cc line 1673 for 242 seconds the semaphore: S-lock on RW-latch at 0x556982eff2f8 created in file btr0sea.cc line 203 a writer (thread id 140089048938240) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.cc line 1211 Last time write locked in file /build/mysql-5.7.33/storage/innobase/btr/btr0sea.cc line 1307 --Thread 140089048938240 has waited at btr0sea.cc line 1307 for 261 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x556982eff2f8 created in file btr0sea.cc line 203 a writer (thread id 140089048938240) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.cc line 1211 Last time write locked in file /build/mysql-5.7.33/storage/innobase/btr/btr0sea.cc line 1307 --Thread 140088897935104 has waited at row0row.cc line 999 for 261 seconds the semaphore: X-lock on RW-latch at 0x7f690e8d6e90 created in file buf0buf.cc line 1462 a writer (thread id 140088939898624) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time read locked in file row0sel.cc line 1343 Last time write locked in file /build/mysql-5.7.33/storage/innobase/buf/buf0flu.cc line 1179 --Thread 140088814073600 has waited at row0row.cc line 999 for 261 seconds the semaphore: X-lock on RW-latch at 0x7f690e8d6e90 created in file buf0buf.cc line 1462 a writer (thread id 140088939898624) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time read locked in file row0sel.cc line 1343 Last time write locked in file /build/mysql-5.7.33/storage/innobase/buf/buf0flu.cc line 1179 OS WAIT ARRAY INFO: signal count 11736 RW-shared spins 0, rounds 20522, OS waits 8809 RW-excl spins 0, rounds 90345, OS waits 1234 RW-sx spins 2390, rounds 60408, OS waits 1248 Spin rounds per wait: 20522.00 RW-shared, 90345.00 RW-excl, 25.28 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 37812 Purge done for trx's n:o < 37726 undo n:o < 0 state: running History list length 578 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421564187225376, not started 0 lock struct(s), heap size 1160, 0 row lock(s) ---TRANSACTION 37811, ACTIVE 207 sec 0 lock struct(s), heap size 1160, 0 row lock(s) Trx read view will not see trx with id >= 37812, sees < 37809 ---TRANSACTION 37810, ACTIVE 241 sec 0 lock struct(s), heap size 1160, 0 row lock(s) Trx read view will not see trx with id >= 37811, sees < 37809 ---TRANSACTION 37809, ACTIVE 261 sec truncating table mysql tables in use 1, locked 1 0 lock struct(s), heap size 1160, 0 row lock(s) MySQL thread id 5, OS thread handle 140089174099712, query id 38291 172.17.0.1 user System lock truncate `testdb`.`testTable` -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: complete io for buf page (write thread) ev set I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [48, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 0; buffer pool: 0 17151 OS file reads, 31097 OS file writes, 14920 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 0, seg size 2, 10177 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, used cells 0, node heap has 1 buffer(s) Hash table size 4441, used cells 0, node heap has 1 buffer(s) Hash table size 4441, used cells 0, node heap has 0 buffer(s) Hash table size 4441, used cells 0, node heap has 1 buffer(s) InnoDB: ###### Diagnostic info printed to the standard error stream 2021-03-31T10:35:10.953413Z 0 [Warning] InnoDB: A long semaphore wait: --Thread 140088797288192 has waited at row0row.cc line 999 for 272 seconds the semaphore: X-lock on RW-latch at 0x7f690e8d6e90 created in file buf0buf.cc line 1462 a writer (thread id 140088939898624) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time read locked in file row0sel.cc line 1343 Last time write locked in file /build/mysql-5.7.33/storage/innobase/buf/buf0flu.cc line 1179 2021-03-31T10:35:10.953489Z 0 [Warning] InnoDB: A long semaphore wait: --Thread 140088906327808 has waited at srv0srv.cc line 1989 for 270 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x556982ffefb8 created in file dict0dict.cc line 1228 a writer (thread id 140088906327808) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffffffffffc Last time read locked in file row0purge.cc line 882 Last time write locked in file /build/mysql-5.7.33/storage/innobase/row/row0trunc.cc line 1851 2021-03-31T10:35:10.953521Z 0 [Warning] InnoDB: A long semaphore wait: --Thread 140088805680896 has waited at row0row.cc line 999 for 272 seconds the semaphore: X-lock on RW-latch at 0x7f690e8d6e90 created in file buf0buf.cc line 1462 a writer (thread id 140088939898624) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time read locked in file row0sel.cc line 1343 Last time write locked in file /build/mysql-5.7.33/storage/innobase/buf/buf0flu.cc line 1179 2021-03-31T10:35:10.953548Z 0 [Warning] InnoDB: A long semaphore wait: --Thread 140089173829376 has waited at row0sel.cc line 1673 for 253 seconds the semaphore: S-lock on RW-latch at 0x556982eff2f8 created in file btr0sea.cc line 203 a writer (thread id 140089048938240) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.cc line 1211 Last time write locked in file /build/mysql-5.7.33/storage/innobase/btr/btr0sea.cc line 1307 2021-03-31T10:35:10.953574Z 0 [Warning] InnoDB: A long semaphore wait: --Thread 140089048938240 has waited at btr0sea.cc line 1307 for 272 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x556982eff2f8 created in file btr0sea.cc line 203 a writer (thread id 140089048938240) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.cc line 1211 Last time write locked in file /build/mysql-5.7.33/storage/innobase/btr/btr0sea.cc line 1307 2021-03-31T10:35:10.953599Z 0 [Warning] InnoDB: A long semaphore wait: --Thread 140088897935104 has waited at row0row.cc line 999 for 272 seconds the semaphore: X-lock on RW-latch at 0x7f690e8d6e90 created in file buf0buf.cc line 1462 a writer (thread id 140088939898624) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time read locked in file row0sel.cc line 1343 Last time write locked in file /build/mysql-5.7.33/storage/innobase/buf/buf0flu.cc line 1179 2021-03-31T10:35:10.953626Z 0 [Warning] InnoDB: A long semaphore wait: --Thread 140088814073600 has waited at row0row.cc line 999 for 272 seconds the semaphore: X-lock on RW-latch at 0x7f690e8d6e90 created in file buf0buf.cc line 1462 a writer (thread id 140088939898624) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time read locked in file row0sel.cc line 1343 Last time write locked in file /build/mysql-5.7.33/storage/innobase/buf/buf0flu.cc line 1179 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 InnoDB: ###### Diagnostic info printed to the standard error stream 2021-03-31T10:35:41.954000Z 0 [Warning] InnoDB: A long semaphore wait: --Thread 140088797288192 has waited at row0row.cc line 999 for 303 seconds the semaphore: X-lock on RW-latch at 0x7f690e8d6e90 created in file buf0buf.cc line 1462 a writer (thread id 140088939898624) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time read locked in file row0sel.cc line 1343 Last time write locked in file /build/mysql-5.7.33/storage/innobase/buf/buf0flu.cc line 1179 2021-03-31T10:35:41.954059Z 0 [Warning] InnoDB: A long semaphore wait: --Thread 140089173559040 has waited at row0sel.cc line 1673 for 250 seconds the semaphore: S-lock on RW-latch at 0x556982eff2f8 created in file btr0sea.cc line 203 a writer (thread id 140089048938240) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.cc line 1211 Last time write locked in file /build/mysql-5.7.33/storage/innobase/btr/btr0sea.cc line 1307 2021-03-31T10:35:41.954078Z 0 [Warning] InnoDB: A long semaphore wait: --Thread 140088906327808 has waited at srv0srv.cc line 1989 for 301 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x556982ffefb8 created in file dict0dict.cc line 1228 a writer (thread id 140088906327808) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffffffffffc Last time read locked in file row0purge.cc line 882 Last time write locked in file /build/mysql-5.7.33/storage/innobase/row/row0trunc.cc line 1851 2021-03-31T10:35:41.954097Z 0 [Warning] InnoDB: A long semaphore wait: --Thread 140088805680896 has waited at row0row.cc line 999 for 303 seconds the semaphore: X-lock on RW-latch at 0x7f690e8d6e90 created in file buf0buf.cc line 1462 a writer (thread id 140088939898624) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time read locked in file row0sel.cc line 1343 Last time write locked in file /build/mysql-5.7.33/storage/innobase/buf/buf0flu.cc line 1179 2021-03-31T10:35:41.954112Z 0 [Warning] InnoDB: A long semaphore wait: --Thread 140089173829376 has waited at row0sel.cc line 1673 for 284 seconds the semaphore: S-lock on RW-latch at 0x556982eff2f8 created in file btr0sea.cc line 203 a writer (thread id 140089048938240) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.cc line 1211 Last time write locked in file /build/mysql-5.7.33/storage/innobase/btr/btr0sea.cc line 1307 2021-03-31T10:35:41.954129Z 0 [Warning] InnoDB: A long semaphore wait: --Thread 140089048938240 has waited at btr0sea.cc line 1307 for 303 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x556982eff2f8 created in file btr0sea.cc line 203 a writer (thread id 140089048938240) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.cc line 1211 Last time write locked in file /build/mysql-5.7.33/storage/innobase/btr/btr0sea.cc line 1307 2021-03-31T10:35:41.954145Z 0 [Warning] InnoDB: A long semaphore wait: --Thread 140088897935104 has waited at row0row.cc line 999 for 303 seconds the semaphore: X-lock on RW-latch at 0x7f690e8d6e90 created in file buf0buf.cc line 1462 a writer (thread id 140088939898624) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time read locked in file row0sel.cc line 1343 Last time write locked in file /build/mysql-5.7.33/storage/innobase/buf/buf0flu.cc line 1179 2021-03-31T10:35:41.954161Z 0 [Warning] InnoDB: A long semaphore wait: --Thread 140088814073600 has waited at row0row.cc line 999 for 303 seconds the semaphore: X-lock on RW-latch at 0x7f690e8d6e90 created in file buf0buf.cc line 1462 a writer (thread id 140088939898624) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time read locked in file row0sel.cc line 1343 Last time write locked in file /build/mysql-5.7.33/storage/innobase/buf/buf0flu.cc line 1179 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 InnoDB: ###### Diagnostic info printed to the standard error stream