2019-12-08 01:49:38 7f07e72d9700  InnoDB: Warning: problems renaming 'MTPUSHDB/ICAS_CUSTOMER_NEW' to 'MTPUSHDB/ICAS_CUSTOMER', 18000 iterations
InnoDB: ###### Diagnostic info printed to the standard error stream
InnoDB: Warning: a long semaphore wait:
--Thread 139672445486848 has waited at ibuf0ibuf.cc line 4685 for 365.00 seconds the semaphore:
X-lock (wait_ex) on RW-latch at 0x7f0841bc4e40 '&block->lock'
a writer (thread id 139672445486848) has reserved it in mode  wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file buf0flu.cc line 1073 Last time write locked in file /home/buildbot/buildbot/build/storage/xtradb/ibuf/ibuf0ibuf.cc line 4956
InnoDB: Warning: a long semaphore wait:
--Thread 139674866824960 has waited at row0mysql.cc line 1755 for 311.00 seconds the semaphore:
S-lock on RW-latch at 0x149db20 '&dict_operation_lock'
a writer (thread id 139671920023296) has reserved it in mode  exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0purge.cc line 768 Last time write locked in file /home/buildbot/buildbot/build/storage/xtradb/handler/ha_innodb.cc line 12591
InnoDB: Warning: a long semaphore wait:
--Thread 139670499366656 has waited at fsp0fsp.cc line 2880 for 310.00 seconds the semaphore:
Mutex at 0x7f08e27ff168 '&dict_sys->mutex', lock var 1 waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 139670497871616 has waited at fsp0fsp.cc line 2880 for 305.00 seconds the semaphore:
Mutex at 0x7f08e27ff168 '&dict_sys->mutex', lock var 1 waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 139671902955264 has waited at dict0dict.cc line 1163 for 300.00 seconds the semaphore:
Mutex at 0x7f08e27ff168 '&dict_sys->mutex', lock var 1 waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 139671816668928 has waited at dict0dict.cc line 1163 for 295.00 seconds the semaphore:
Mutex at 0x7f08e27ff168 '&dict_sys->mutex', lock var 1 waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 139670497273600 has waited at dict0dict.cc line 1163 for 290.00 seconds the semaphore:
Mutex at 0x7f08e27ff168 '&dict_sys->mutex', lock var 1 waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 139673432975104 has waited at dict0dict.cc line 1163 for 285.00 seconds the semaphore:
Mutex at 0x7f08e27ff168 '&dict_sys->mutex', lock var 1 waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 139674867422976 has waited at dict0dict.cc line 1163 for 280.00 seconds the semaphore:
Mutex at 0x7f08e27ff168 '&dict_sys->mutex', lock var 1 waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 139672075175680 has waited at dict0dict.cc line 1163 for 275.00 seconds the semaphore:
Mutex at 0x7f08e27ff168 '&dict_sys->mutex', lock var 1 waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 139674569332480 has waited at dict0dict.cc line 1163 for 270.00 seconds the semaphore:
Mutex at 0x7f08e27ff168 '&dict_sys->mutex', lock var 1 waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 139674568435456 has waited at dict0dict.cc line 1163 for 265.00 seconds the semaphore:
Mutex at 0x7f08e27ff168 '&dict_sys->mutex', lock var 1 waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 139674962695936 has waited at dict0dict.cc line 1163 for 260.00 seconds the semaphore:
Mutex at 0x7f08e27ff168 '&dict_sys->mutex', lock var 1 waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 139672445486848 has waited at ibuf0ibuf.cc line 4685 for 365.00 seconds the semaphore:
X-lock (wait_ex) on RW-latch at 0x7f0841bc4e40 '&block->lock'
a writer (thread id 139672445486848) has reserved it in mode  wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file buf0flu.cc line 1073 Last time write locked in file /home/buildbot/buildbot/build/storage/xtradb/ibuf/ibuf0ibuf.cc line 4956
InnoDB: Warning: Writer thread is waiting this semaphore:
--Thread 139672445486848 has waited at ibuf0ibuf.cc line 4685 for 365.00 seconds the semaphore:
X-lock (wait_ex) on RW-latch at 0x7f0841bc4e40 '&block->lock'
a writer (thread id 139672445486848) has reserved it in mode  wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file buf0flu.cc line 1073 Last time write locked in file /home/buildbot/buildbot/build/storage/xtradb/ibuf/ibuf0ibuf.cc line 4956
InnoDB: Warning: semaphore wait:
--Thread 139674866824960 has waited at row0mysql.cc line 1755 for 311.00 seconds the semaphore:
S-lock on RW-latch at 0x149db20 '&dict_operation_lock'
a writer (thread id 139671920023296) has reserved it in mode  exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0purge.cc line 768 Last time write locked in file /home/buildbot/buildbot/build/storage/xtradb/handler/ha_innodb.cc line 12591
InnoDB: Warning: semaphore wait:
--Thread 139670499366656 has waited at fsp0fsp.cc line 2880 for 310.00 seconds the semaphore:
Mutex at 0x7f08e27ff168 '&dict_sys->mutex', lock var 1 waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 139670497871616 has waited at fsp0fsp.cc line 2880 for 305.00 seconds the semaphore:
Mutex at 0x7f08e27ff168 '&dict_sys->mutex', lock var 1 waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 139671902955264 has waited at dict0dict.cc line 1163 for 300.00 seconds the semaphore:
Mutex at 0x7f08e27ff168 '&dict_sys->mutex', lock var 1 waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 139671816668928 has waited at dict0dict.cc line 1163 for 295.00 seconds the semaphore:
Mutex at 0x7f08e27ff168 '&dict_sys->mutex', lock var 1 waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 139670497273600 has waited at dict0dict.cc line 1163 for 290.00 seconds the semaphore:
Mutex at 0x7f08e27ff168 '&dict_sys->mutex', lock var 1 waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 139673432975104 has waited at dict0dict.cc line 1163 for 285.00 seconds the semaphore:
Mutex at 0x7f08e27ff168 '&dict_sys->mutex', lock var 1 waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 139674867422976 has waited at dict0dict.cc line 1163 for 280.00 seconds the semaphore:
Mutex at 0x7f08e27ff168 '&dict_sys->mutex', lock var 1 waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 139672075175680 has waited at dict0dict.cc line 1163 for 275.00 seconds the semaphore:
Mutex at 0x7f08e27ff168 '&dict_sys->mutex', lock var 1 waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 139674569332480 has waited at dict0dict.cc line 1163 for 270.00 seconds the semaphore:
Mutex at 0x7f08e27ff168 '&dict_sys->mutex', lock var 1 waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 139674568435456 has waited at dict0dict.cc line 1163 for 265.00 seconds the semaphore:
Mutex at 0x7f08e27ff168 '&dict_sys->mutex', lock var 1 waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 139674962695936 has waited at dict0dict.cc line 1163 for 260.00 seconds the semaphore:
Mutex at 0x7f08e27ff168 '&dict_sys->mutex', lock var 1 waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 139671838844672 has waited at dict0dict.cc line 1163 for 145.00 seconds the semaphore:
Mutex at 0x7f08e27ff168 '&dict_sys->mutex', lock var 1 waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 139671837947648 has waited at dict0dict.cc line 1163 for 140.00 seconds the semaphore:
Mutex at 0x7f08e27ff168 '&dict_sys->mutex', lock var 1 waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 139674850645760 has waited at dict0dict.cc line 1163 for 15.000 seconds the semaphore:
Mutex at 0x7f08e27ff168 '&dict_sys->mutex', lock var 1 waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 139671903254272 has waited at row0mysql.cc line 1755 for 12.000 seconds the semaphore:
S-lock on RW-latch at 0x149db20 '&dict_operation_lock'
a writer (thread id 139671920023296) has reserved it in mode  exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0purge.cc line 768 Last time write locked in file /home/buildbot/buildbot/build/storage/xtradb/handler/ha_innodb.cc line 12591
InnoDB: Warning: semaphore wait:
--Thread 139671739676416 has waited at dict0dict.cc line 1163 for 10.000 seconds the semaphore:
Mutex at 0x7f08e27ff168 '&dict_sys->mutex', lock var 1 waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 139673717290752 has waited at dict0dict.cc line 1163 for 5.0000 seconds the semaphore:
Mutex at 0x7f08e27ff168 '&dict_sys->mutex', lock var 1 waiters flag 1
InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
InnoDB: Pending preads 0, pwrites 0