Want more features on Pastebin? Sign Up, it's FREE!
Guest

Crash Log

By: a guest on Dec 6th, 2012  |  syntax: None  |  size: 3.73 KB  |  views: 32  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1.  
  2. [-]InnoDB: Warning: a long semaphore wait:--Thread 1258785088 has waited at ./include/trx0sys.ic line 120 for 241.00 seconds the semaphore:X-lock (wait_ex) on RW-latch at 0x2aaaac992958 created in file buf/buf0buf.c line 682a writer (thread id 1258785088) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 0, lock_word: ffffffffffffffffLast time read locked in file buf/buf0flu.c line 1169Last time write locked in file ./include/trx0sys.ic line 120InnoDB: Warning: a long semaphore wait:--Thread 1245137216 has waited at trx/trx0trx.c line 708 for 241.00 seconds the semaphore:Mutex at 0x107e1ea8 created file srv/srv0srv.c line 943, lock var 1waiters flag 1InnoDB: Warning: a long semaphore wait:--Thread 1206896960 has waited at srv/srv0srv.c line 2148 for 241.00 seconds the semaphore:Mutex at 0x107e1ea8 created file srv/srv0srv.c line 943, lock var 1waiters flag 1InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:InnoDB: Pending preads 0, pwrites 0=====================================121204 15:46:04 INNODB MONITOR OUTPUT=====================================Per second averages calculated from the last 30 seconds-----------------BACKGROUND THREAD-----------------srv_master_thread loops: 1354451 1_second, 1354448 sleeps, 132169 10_second, 33616 background, 33616 flushsrv_master_thread log flush and writes: 1363178----------SEMAPHORES----------OS WAIT ARRAY INFO: reservation count 180507, signal count 179839--Thread 1258785088 has waited at ./include/trx0sys.ic line 120 for 242.00 seconds the semaphore:X-lock (wait_ex) on RW-latch at 0x2aaaac992958 created in file buf/buf0buf.c line 682a writer (thread id 1258785088) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 0, lock_word: ffffffffffffffffLast time read locked in file buf/buf0flu.c line 1169Last time write locked in file ./include/trx0sys.ic line 120--Thr
  3. ...
  4. ...
  5. ...
  6. rv/srv0srv.c line 2148 for 242.00 seconds the semaphore:Mutex at 0x107e1ea8 created file srv/srv0srv.c line 943, lock var 1waiters flag 1--Thread 1261394240 has waited at trx/trx0trx.c line 199 for 237.00 seconds the semaphore:Mutex at 0x107e1ea8 created file srv/srv0srv.c line 943, lock var 1waiters flag 1--Thread 1249954112 has waited at trx/trx0trx.c line 708 for 232.00 seconds the semaphore:Mutex at 0x107e1ea8 created file srv/srv0srv.c line 943, lock var 1waiters flag 1--Thread 1098996032 has waited at trx/trx0trx.c line 708 for 229.00 seconds the semaphore:Mutex at 0x107e1ea8 created file srv/srv0srv.c line 943, lock var 1waiters flag 1--Thread 1257982272 has waited at trx/trx0trx.c line 708 for 229.00 seconds the semaphore:Mutex at 0x107e1ea8 created file srv/srv0srv.c line 943, lock var 1waiters flag 1--Thread 1260992832 has waited at trx/trx0trx.c line 199 for 227.00 seconds the semaphore:Mutex at 0x107e1ea8 created file srv/srv0srv.c line 943, lock var 1waiters flag 1--Thread 1239116096 has waited at trx/trx0trx.c line 344 for 221.00 seconds the semaphore:Mutex at 0x107e1ea8 created file srv/srv0srv.c line 943, lock var 1waiters flag 1Mutex spin waits 18559608, rounds 5933417, OS waits 37160RW-shared spins 134274, OS waits 133041; RW-excl spins 259, OS waits 10205Spin rounds per wait: 0.32 mutex, 30.00 RW-shared, 1184.19 RW-exclFAIL TO OBTAIN KERNEL MUTEX, SKIP LOCK INFO PRINTING--------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: waiting for i/o request (write thread)I/O thread 7 state: waiting for i/o request (write thre
clone this paste RAW Paste Data