Advertisement
Guest User

Untitled

a guest
Aug 2nd, 2015
203
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.28 KB | None | 0 0
  1. ROW OPERATIONS
  2. --------------
  3. 0 queries inside InnoDB, 0 queries in queue
  4. 3 read views open inside InnoDB
  5. Main thread process no. 2376, id 139688581822208, state: doing insert buffer merge
  6. Number of rows inserted 199807793, updated 1003503102, deleted 124405713, read 3445542818038
  7. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 1972091.50 reads/s
  8. ----------------------------
  9. END OF INNODB MONITOR OUTPUT
  10. ============================
  11. InnoDB: ###### Diagnostic info printed to the standard error stream
  12. InnoDB: Warning: a long semaphore wait:
  13. --Thread 139682125571840 has waited at buf0buf.cc line 2477 for 268.00 seconds the semaphore:
  14. S-lock on RW-latch at 0x7f0c23824cc0 created in file buf0buf.cc line 1016
  15. a writer (thread id 139682125571840) has reserved it in mode exclusive
  16. number of readers 0, waiters flag 1, lock_word: 0
  17. Last time read locked in file buf0flu.cc line 1033
  18. Last time write locked in file /pb2/build/sb_0-11763321-1394824179.77/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/innobase/buf/buf0buf.cc line 3598
  19. InnoDB: Warning: a long semaphore wait:
  20. --Thread 139686395033344 has waited at dict0dict.cc line 941 for 271.00 seconds the semaphore:
  21. Mutex at 0x72b2be8 created file dict0dict.cc line 878, lock var 1
  22. --
  23. --------------
  24. 0 queries inside InnoDB, 0 queries in queue
  25. 6 read views open inside InnoDB
  26. Main thread process no. 2376, id 139688581822208, state: doing insert buffer merge
  27. Number of rows inserted 199807793, updated 1003503102, deleted 124405713, read 3445582531959
  28. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 1985596.77 reads/s
  29. ----------------------------
  30. END OF INNODB MONITOR OUTPUT
  31. END OF INNODB MONITOR OUTPUT
  32. ============================
  33. InnoDB: ###### Diagnostic info printed to the standard error stream
  34. InnoDB: Warning: a long semaphore wait:
  35. --Thread 139682125571840 has waited at buf0buf.cc line 2477 for 485.00 seconds the semaphore:
  36. S-lock on RW-latch at 0x7f0c23824cc0 created in file buf0buf.cc line 1016
  37. a writer (thread id 139682125571840) has reserved it in mode exclusive
  38. number of readers 0, waiters flag 1, lock_word: 0
  39. Last time read locked in file buf0flu.cc line 1033
  40. Last time write locked in file /pb2/build/sb_0-11763321-1394824179.77/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/innobase/buf/buf0buf.cc line 3598
  41. InnoDB: Warning: a long semaphore wait:
  42. --Thread 139686395033344 has waited at dict0dict.cc line 941 for 488.00 seconds the semaphore:
  43. Mutex at 0x72b2be8 created file dict0dict.cc line 878, lock var 1
  44. --
  45. --Thread 139688571332352 has waited at row0purge.cc line 720 for 489.00 seconds the semaphore:
  46. S-lock on RW-latch at 0x135d740 created in file dict0dict.cc line 887
  47. a writer (thread id 139686375597824) has reserved it in mode exclusive
  48. number of readers 0, waiters flag 1, lock_word: 0
  49. Last time read locked in file row0purge.cc line 720
  50. Last time write locked in file /pb2/build/sb_0-11763321-1394824179.77/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/innobase/handler/handler0alter.cc line 5418
  51. InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
  52. InnoDB: Pending preads 0, pwrites 0
  53. 2015-07-31 02:18:53 7f0b44cc2700 InnoDB: Warning: problems renaming 'simutv/out_sms_backup' to 'simutv/#sql-ib22520', 25000 iterations
  54. 2015-07-31 02:18:53 7f0b44cc2700 InnoDB: Assertion failure in thread 139686375597824 in file handler0alter.cc line 4948
  55. InnoDB: Failing assertion: error == DB_SUCCESS
  56. InnoDB: We intentionally generate a memory trap.
  57. InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
  58. InnoDB: If you get repeated assertion failures or crashes, even
  59. InnoDB: immediately after the mysqld startup, there may be
  60. InnoDB: corruption in the InnoDB tablespace. Please refer to
  61. InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
  62. InnoDB: about forcing recovery.
  63. 23:18:53 UTC - mysqld got signal 6 ;
  64. This could be because you hit a bug. It is also possible that this binary
  65. or one of the libraries it was linked against is corrupt, improperly built,
  66. or misconfigured. This error can also be caused by malfunctioning hardware.
  67. We will try our best to scrape up some info that will hopefully help
  68. diagnose the problem, but since we have already crashed,
  69. something is definitely wrong and this may fail.
  70.  
  71. key_buffer_size=125829120
  72. read_buffer_size=131072
  73. max_used_connections=222
  74. max_threads=500
  75. thread_count=60
  76. connection_count=57
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement