Advertisement
Guest User

Untitled

a guest
Jun 7th, 2015
311
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.68 KB | None | 0 0
  1. InnoDB: ###### Diagnostic info printed to the standard error stream
  2. InnoDB: Warning: a long semaphore wait:
  3. --Thread 140310821447424 has waited at btr0cur.c line 570 for 273.00 seconds the semaphore:
  4. X-lock (wait_ex) on RW-latch at 0x7fa0f0028af8 '&new_index->lock'
  5. a writer (thread id 140310821447424) has reserved it in mode wait exclusive
  6. number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
  7. Last time read locked in file btr0cur.c line 577
  8. Last time write locked in file /home/lianjie.ning/rpmbuild/BUILD/Percona-Server-5.5.43/storage/innobase/btr/btr0cur.c line 570
  9. InnoDB: Warning: a long semaphore wait:
  10. --Thread 140310498342656 has waited at btr0cur.c line 577 for 273.00 seconds the semaphore:
  11. S-lock on RW-latch at 0x7fa0f0028af8 '&new_index->lock'
  12. a writer (thread id 140310821447424) has reserved it in mode wait exclusive
  13. number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
  14. Last time read locked in file btr0cur.c line 577
  15. Last time write locked in file /home/lianjie.ning/rpmbuild/BUILD/Percona-Server-5.5.43/storage/innobase/btr/btr0cur.c line 570
  16. InnoDB: Warning: a long semaphore wait:
  17. --Thread 140310497277696 has waited at btr0cur.c line 577 for 272.00 seconds the semaphore:
  18. S-lock on RW-latch at 0x7fa0f0028af8 '&new_index->lock'
  19. a writer (thread id 140310821447424) has reserved it in mode wait exclusive
  20. number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
  21. Last time read locked in file btr0cur.c line 577
  22. Last time write locked in file /home/lianjie.ning/rpmbuild/BUILD/Percona-Server-5.5.43/storage/innobase/btr/btr0cur.c line 570
  23. InnoDB: Warning: a long semaphore wait:
  24. --Thread 140310508992256 has waited at btr0cur.c line 577 for 272.00 seconds the semaphore:
  25. S-lock on RW-latch at 0x7fa0f0028af8 '&new_index->lock'
  26. a writer (thread id 140310821447424) has reserved it in mode wait exclusive
  27. number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
  28. Last time read locked in file btr0cur.c line 577
  29. Last time write locked in file /home/lianjie.ning/rpmbuild/BUILD/Percona-Server-5.5.43/storage/innobase/btr/btr0cur.c line 570
  30. InnoDB: Warning: a long semaphore wait:
  31. --Thread 140310502868736 has waited at btr0cur.c line 577 for 272.00 seconds the semaphore:
  32. S-lock on RW-latch at 0x7fa0f0028af8 '&new_index->lock'
  33. a writer (thread id 140310821447424) has reserved it in mode wait exclusive
  34. number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
  35. Last time read locked in file btr0cur.c line 577
  36. Last time write locked in file /home/lianjie.ning/rpmbuild/BUILD/Percona-Server-5.5.43/storage/innobase/btr/btr0cur.c line 570
  37. InnoDB: Warning: a long semaphore wait:
  38. --Thread 140310592362240 has waited at btr0cur.c line 577 for 272.00 seconds the semaphore:
  39. S-lock on RW-latch at 0x7fa0f0028af8 '&new_index->lock'
  40. a writer (thread id 140310821447424) has reserved it in mode wait exclusive
  41. number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
  42. Last time read locked in file btr0cur.c line 577
  43. Last time write locked in file /home/lianjie.ning/rpmbuild/BUILD/Percona-Server-5.5.43/storage/innobase/btr/btr0cur.c line 570
  44. InnoDB: Warning: a long semaphore wait:
  45. --Thread 140310499407616 has waited at btr0cur.c line 577 for 272.00 seconds the semaphore:
  46. S-lock on RW-latch at 0x7fa0f0028af8 '&new_index->lock'
  47. a writer (thread id 140310821447424) has reserved it in mode wait exclusive
  48. number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
  49. Last time read locked in file btr0cur.c line 577
  50. Last time write locked in file /home/lianjie.ning/rpmbuild/BUILD/Percona-Server-5.5.43/storage/innobase/btr/btr0cur.c line 570
  51. InnoDB: Warning: a long semaphore wait:
  52. --Thread 140310594492160 has waited at btr0cur.c line 577 for 272.00 seconds the semaphore:
  53. S-lock on RW-latch at 0x7fa0f0028af8 '&new_index->lock'
  54. a writer (thread id 140310821447424) has reserved it in mode wait exclusive
  55. number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
  56. Last time read locked in file btr0cur.c line 577
  57. Last time write locked in file /home/lianjie.ning/rpmbuild/BUILD/Percona-Server-5.5.43/storage/innobase/btr/btr0cur.c line 570
  58. InnoDB: Warning: a long semaphore wait:
  59. --Thread 140310588901120 has waited at btr0cur.c line 577 for 272.00 seconds the semaphore:
  60. S-lock on RW-latch at 0x7fa0f0028af8 '&new_index->lock'
  61. a writer (thread id 140310821447424) has reserved it in mode wait exclusive
  62. number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
  63. Last time read locked in file btr0cur.c line 577
  64. Last time write locked in file /home/lianjie.ning/rpmbuild/BUILD/Percona-Server-5.5.43/storage/innobase/btr/btr0cur.c line 570
  65. InnoDB: Warning: a long semaphore wait:
  66. --Thread 140310513252096 has waited at btr0cur.c line 577 for 271.00 seconds the semaphore:
  67. S-lock on RW-latch at 0x7fa0f0028af8 '&new_index->lock'
  68. a writer (thread id 140310821447424) has reserved it in mode wait exclusive
  69. number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
  70. Last time read locked in file btr0cur.c line 577
  71. Last time write locked in file /home/lianjie.ning/rpmbuild/BUILD/Percona-Server-5.5.43/storage/innobase/btr/btr0cur.c line 570
  72. InnoDB: Warning: a long semaphore wait:
  73. --Thread 140310593959680 has waited at btr0cur.c line 577 for 271.00 seconds the semaphore:
  74. S-lock on RW-latch at 0x7fa0f0028af8 '&new_index->lock'
  75. a writer (thread id 140310821447424) has reserved it in mode wait exclusive
  76. number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
  77. Last time read locked in file btr0cur.c line 577
  78. Last time write locked in file /home/lianjie.ning/rpmbuild/BUILD/Percona-Server-5.5.43/storage/innobase/btr/btr0cur.c line 570
  79. InnoDB: Warning: a long semaphore wait:
  80. --Thread 140310502602496 has waited at btr0cur.c line 577 for 271.00 seconds the semaphore:
  81. S-lock on RW-latch at 0x7fa0f0028af8 '&new_index->lock'
  82. a writer (thread id 140310821447424) has reserved it in mode wait exclusive
  83. number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
  84. Last time read locked in file btr0cur.c line 577
  85. Last time write locked in file /home/lianjie.ning/rpmbuild/BUILD/Percona-Server-5.5.43/storage/innobase/btr/btr0cur.c line 570
  86. InnoDB: Warning: a long semaphore wait:
  87. --Thread 140310597420800 has waited at btr0cur.c line 577 for 271.00 seconds the semaphore:
  88. S-lock on RW-latch at 0x7fa0f0028af8 '&new_index->lock'
  89. a writer (thread id 140310821447424) has reserved it in mode wait exclusive
  90. number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
  91. Last time read locked in file btr0cur.c line 577
  92. Last time write locked in file /home/lianjie.ning/rpmbuild/BUILD/Percona-Server-5.5.43/storage/innobase/btr/btr0cur.c line 570
  93. InnoDB: Warning: a long semaphore wait:
  94. --Thread 140310608869120 has waited at btr0cur.c line 577 for 271.00 seconds the semaphore:
  95. S-lock on RW-latch at 0x7fa0f0028af8 '&new_index->lock'
  96. a writer (thread id 140310821447424) has reserved it in mode wait exclusive
  97. number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
  98. Last time read locked in file btr0cur.c line 577
  99. Last time write locked in file /home/lianjie.ning/rpmbuild/BUILD/Percona-Server-5.5.43/storage/innobase/btr/btr0cur.c line 570
  100. InnoDB: Warning: a long semaphore wait:
  101. --Thread 140310500472576 has waited at btr0cur.c line 577 for 268.00 seconds the semaphore:
  102. S-lock on RW-latch at 0x7fa0f0028af8 '&new_index->lock'
  103. a writer (thread id 140310821447424) has reserved it in mode wait exclusive
  104. number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
  105. Last time read locked in file btr0cur.c line 577
  106. Last time write locked in file /home/lianjie.ning/rpmbuild/BUILD/Percona-Server-5.5.43/storage/innobase/btr/btr0cur.c line 570
  107. InnoDB: Warning: a long semaphore wait:
  108. --Thread 140310594758400 has waited at btr0cur.c line 577 for 267.00 seconds the semaphore:
  109. S-lock on RW-latch at 0x7fa0f0028af8 '&new_index->lock'
  110. a writer (thread id 140310821447424) has reserved it in mode wait exclusive
  111. number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
  112. Last time read locked in file btr0cur.c line 577
  113. Last time write locked in file /home/lianjie.ning/rpmbuild/BUILD/Percona-Server-5.5.43/storage/innobase/btr/btr0cur.c line 570
  114. InnoDB: Warning: a long semaphore wait:
  115. --Thread 140310873896704 has waited at buf0flu.c line 1357 for 265.00 seconds the semaphore:
  116. S-lock on RW-latch at 0x7f9cd089bb10 '&block->lock'
  117. a writer (thread id 140310499673856) has reserved it in mode exclusive
  118. number of readers 0, waiters flag 1, lock_word: 0
  119. Last time read locked in file btr0cur.c line 260
  120. Last time write locked in file /home/lianjie.ning/rpmbuild/BUILD/Percona-Server-5.5.43/storage/innobase/btr/btr0cur.c line 350
  121. InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
  122. InnoDB: Pending preads 0, pwrites 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement