MySQL Forums
Forum List  »  InnoDB

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

suite of the innodb status
--Thread 431 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 307 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 299 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 302 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 438 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 337 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 409 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 376 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 320 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 325 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 377 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 439 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 269 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 317 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 342 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 291 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 391 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 339 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 379 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 398 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 330 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 367 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 264 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 333 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 364 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 270 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 277 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 396 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 286 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 310 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 447 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 263 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 365 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 419 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 390 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 436 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 285 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 314 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 383 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 275 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 326 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 407 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 446 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 421 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 413 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 443 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 393 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 437 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 373 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 304 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 278 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 294 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 341 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 414 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 271 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 340 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 394 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 346 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 417 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 274 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 406 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 303 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 327 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 313 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 338 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 321 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 345 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 296 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 355 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 83 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 329 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 164 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 255 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 430 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 284 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 434 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 334 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 359 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 336 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 109 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 403 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 297 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 352 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 401 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 290 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 298 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 259 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 289 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 400 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 exclus |

Options: ReplyQuote


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


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.