MySQL Forums
Forum List  »  InnoDB

Dictionnary Dead Lock on intensive LOAD DATA INFILE table
Posted by: Ben Taieb
Date: December 11, 2008 06:56AM

Hi,
my application insert heavilly in a mysql innodb table ( about 60G+ /day).
I insert with mysqlimport from a text file.
the server is a 16 cores/16G RAM SUn 4150 conncted to storageteck 2540.
I'm using 5.1.24 and seen the exact same problem with different(all) 5.0 versions.
During peak load hour, the server might not finish to load data from one file when the following come in.
running consecutive innodb status doesn't show the same thread owning the lock, so my guess i that each thread get ownership of the lock in a round-robin manner ( or given any priority scheduler).
INODB STATUS says that the thread are waiting for a lockfrom Thread 362 which is waiting for itself... just curious for me.

i have also to say that the import take around 100 secs usually but when this appends i have thread executing for more than 60000 secs before i kill them...

I'm not a "proper" mysql dba and i'm totally clueless, any help is greatly apreciated...
below innodb status (seems like mysql truncate it to 1500ish lines ), and the variables :

Here is the output of innodb status :
=====================================
081211 11:41:16 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 13 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 6994144198, signal count 1362402639
--Thread 266 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 370 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 372 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 331 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 433 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 323 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 385 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 280 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 305 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 295 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 300 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 441 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 311 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 375 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (
thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 150 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 399 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 362 has waited at btr/btr0cur.c line 377 for 50.00 seconds the semaphore:
X-lock on RW-latch at c3cf928 created in file dict/dict0dict.c line 1365
a writer (thread id 362) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr/btr0cur.c line 384
Last time write locked in file btr/btr0cur.c line 377
--Thread 387 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 382 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 378 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 328 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 374 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 276 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 306 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 95 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 361 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 440 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 258 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 217 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 412 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 371 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 288 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 343 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 432 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 251 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 86 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 444 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 402 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 262 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 366 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 273 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 445 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 309 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 384 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 405 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 250 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 349 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 418 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 308 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 350 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 448 has waited at ../../storage/innobase/include/dict0boot.ic line 28 for 50.00 seconds the semaphore:
Mutex at d8ad8a8 created file dict/dict0dict.c line 725, lock var 1
waiters flag 1
--Thread 404 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 348 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 254 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 322 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 358 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 318 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 272 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 316 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 283 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 292 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 395 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 335 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 388 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 442 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 256 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 287 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 422 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 301 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 319 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 369 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 347 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 293 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 353 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 312 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 381 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 425 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 354 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 380 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 315 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 426 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 324 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 408 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 332 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 261 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711
--Thread 252 has waited at row/row0mysql.c line 1711 for 50.00 seconds the semaphore:
X-lock on RW-latch at cacb80 created in file dict/dict0dict.c line 737
a writer (thread id 362) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file row/row0mysql.c line 1676
Last time write locked in file row/row0mysql.c line 1711

Options: ReplyQuote


Subject
Views
Written By
Posted
Dictionnary Dead Lock on intensive LOAD DATA INFILE table
3322
December 11, 2008 06:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.