TimesTen: How To Investigate 'Waiting for in-flux' Messages [ID 372825.1]

rongshiyuan發表於2012-11-12
TimesTen: How To Investigate 'Waiting for in-flux' Messages [ID 372825.1]

In this Document
Goal
Solution


Applies to:

TimesTen Data Server - Version: 5.1.27 and later [Release: and later ]
Linux x86-64

Goal

A flux is a form. of semaphore used to serialize certain operations on a TimesTen data store, such as connect, disconnect, recover, load and unload. When waiting for one a message containing 'Waiting for in-flux to clear' will be written to the log. If these waits are causing a problem, this article describes what information to collect in order to assist Oracle TimesTen support in diagnosing the problem.

Solution

This information needs to be collected whilst the problem is ocurring, though the message logs can be collected afterwards, as long as they still exist.

A UNIX or Linux platform. is assumed where relevant.

  1. Output of ttXactAdmin -latch
  2. If the above shows any PID holding a latch, pstack or gdb trace output of the process(es).
  3. Output of pstack or gdb run on the PID mentioned in the 'Waiting for in-flux' message.
  4. Output of pstack or gdb run on the main TimesTen daemon, whose PID is reported by ttStatus
  5. Output of ttStatus -v or ttStatus -debug
  6. ttmesg.log messages covering the period when the in-flux messages were seen.
  7. Use the OS utiity "top" to check for processes using lot of CPU on the system.


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-749037/,如需轉載,請註明出處,否則將追究法律責任。

相關文章