Billing and Revenue Management (MOSC)

MOSC Banner

semaphore エラーについて

in Billing and Revenue Management (MOSC) 1 commentAnswered

MySQL5.5.47を使用している環境においてsemaphore エラーが発生し、クエリが滞留する問題が発生しています。

mysqld.logの内容

----------------------------------------------------------------------------------

OS WAIT ARRAY INFO: reservation count 133681, signal count 26092

--Thread 140063310575360 has waited at trx0undo.ic line 156 for 949.00 seconds the semaphore:

X-lock (wait_ex) on RW-latch at 0x7f63872b37c0 created in file buf0buf.c line 938

a writer (thread id 140063310575360) has reserved it in mode wait exclusive

number of readers 1, waiters flag 0, lock_word: ffffffffffffffff

Last time read locked in file buf0flu.c line 1319

Last time write locked in file /builddir/build/BUILD/mysql-5.5.47/storage/innobase/include/trx0undo.ic line 156

--Thread 140063875819264 has waited at btr0pcur.c line 425 for 943.00 seconds the semaphore:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center