Sep 24 01:00:00 db2 newsyslog[21388]: logfile turned over 070924 7:00:03 [Warning] Aborted connection 300680 to db: 'openads' user: 'maxads' host: 'realtown2.sandiegort.com' (Got an error reading communication packets) InnoDB: Warning: a long semaphore wait: --Thread 661651456 has waited at btr0sea.c line 995 for 242.00 seconds the semaphore: X-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 661651456 has waited at btr0sea.c line 995 for 274.00 seconds the semaphore: X-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 661651456 has waited at btr0sea.c line 995 for 306.00 seconds the semaphore: X-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 661651456 has waited at btr0sea.c line 995 for 338.00 seconds the semaphore: X-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 661651456 has waited at btr0sea.c line 995 for 370.00 seconds the semaphore: X-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 661651456 has waited at btr0sea.c line 995 for 402.00 seconds the semaphore: X-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 661651456 has waited at btr0sea.c line 995 for 434.00 seconds the semaphore: X-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 661651456 has waited at btr0sea.c line 995 for 466.00 seconds the semaphore: X-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 661651456 has waited at btr0sea.c line 995 for 498.00 seconds the semaphore: X-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656901120 has waited at row0sel.c line 3326 for 256.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666058752 has waited at row0sel.c line 3326 for 256.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656902144 has waited at row0sel.c line 3326 for 256.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 138910976 has waited at srv0srv.c line 1952 for 256.00 seconds the semaphore: Mutex at 0xb544160 created file srv0srv.c line 872, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 657600000 has waited at row0sel.c line 3326 for 256.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 661319424 has waited at btr0sea.c line 916 for 256.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656902656 has waited at btr0sea.c line 916 for 256.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 660892160 has waited at row0sel.c line 3326 for 256.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 659148288 has waited at btr0sea.c line 916 for 256.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666983936 has waited at btr0sea.c line 916 for 256.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656901632 has waited at row0sel.c line 3326 for 256.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 664461056 has waited at btr0sea.c line 916 for 256.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 665122560 has waited at btr0sea.c line 916 for 256.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 1084410112 has waited at btr0sea.c line 916 for 256.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 657599488 has waited at row0sel.c line 3326 for 256.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666061312 has waited at btr0sea.c line 916 for 256.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 661651456 has waited at btr0sea.c line 995 for 530.00 seconds the semaphore: X-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656901120 has waited at row0sel.c line 3326 for 288.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666058752 has waited at row0sel.c line 3326 for 288.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656902144 has waited at row0sel.c line 3326 for 288.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 138910976 has waited at srv0srv.c line 1952 for 288.00 seconds the semaphore: Mutex at 0xb544160 created file srv0srv.c line 872, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 657600000 has waited at row0sel.c line 3326 for 288.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 661319424 has waited at btr0sea.c line 916 for 288.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656902656 has waited at btr0sea.c line 916 for 288.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 660892160 has waited at row0sel.c line 3326 for 288.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 659148288 has waited at btr0sea.c line 916 for 288.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666983936 has waited at btr0sea.c line 916 for 288.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656901632 has waited at row0sel.c line 3326 for 288.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 664461056 has waited at btr0sea.c line 916 for 288.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 665122560 has waited at btr0sea.c line 916 for 288.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 1084410112 has waited at btr0sea.c line 916 for 288.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 657599488 has waited at row0sel.c line 3326 for 288.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666061312 has waited at btr0sea.c line 916 for 288.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 661651456 has waited at btr0sea.c line 995 for 562.00 seconds the semaphore: X-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656901120 has waited at row0sel.c line 3326 for 320.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666058752 has waited at row0sel.c line 3326 for 320.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656902144 has waited at row0sel.c line 3326 for 320.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 138910976 has waited at srv0srv.c line 1952 for 320.00 seconds the semaphore: Mutex at 0xb544160 created file srv0srv.c line 872, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 657600000 has waited at row0sel.c line 3326 for 320.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 661319424 has waited at btr0sea.c line 916 for 320.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656902656 has waited at btr0sea.c line 916 for 320.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 660892160 has waited at row0sel.c line 3326 for 320.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 659148288 has waited at btr0sea.c line 916 for 320.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666983936 has waited at btr0sea.c line 916 for 320.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656901632 has waited at row0sel.c line 3326 for 320.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 664461056 has waited at btr0sea.c line 916 for 320.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 665122560 has waited at btr0sea.c line 916 for 320.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 1084410112 has waited at btr0sea.c line 916 for 320.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 657599488 has waited at row0sel.c line 3326 for 320.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666061312 has waited at btr0sea.c line 916 for 320.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 661651456 has waited at btr0sea.c line 995 for 594.00 seconds the semaphore: X-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656901120 has waited at row0sel.c line 3326 for 352.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666058752 has waited at row0sel.c line 3326 for 352.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656902144 has waited at row0sel.c line 3326 for 352.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 138910976 has waited at srv0srv.c line 1952 for 352.00 seconds the semaphore: Mutex at 0xb544160 created file srv0srv.c line 872, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 657600000 has waited at row0sel.c line 3326 for 352.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 661319424 has waited at btr0sea.c line 916 for 352.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656902656 has waited at btr0sea.c line 916 for 352.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 660892160 has waited at row0sel.c line 3326 for 352.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 659148288 has waited at btr0sea.c line 916 for 352.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666983936 has waited at btr0sea.c line 916 for 352.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656901632 has waited at row0sel.c line 3326 for 352.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 664461056 has waited at btr0sea.c line 916 for 352.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 665122560 has waited at btr0sea.c line 916 for 352.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 1084410112 has waited at btr0sea.c line 916 for 352.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 657599488 has waited at row0sel.c line 3326 for 352.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666061312 has waited at btr0sea.c line 916 for 352.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 661651456 has waited at btr0sea.c line 995 for 626.00 seconds the semaphore: X-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656901120 has waited at row0sel.c line 3326 for 384.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666058752 has waited at row0sel.c line 3326 for 384.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656902144 has waited at row0sel.c line 3326 for 384.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 138910976 has waited at srv0srv.c line 1952 for 384.00 seconds the semaphore: Mutex at 0xb544160 created file srv0srv.c line 872, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 657600000 has waited at row0sel.c line 3326 for 384.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 661319424 has waited at btr0sea.c line 916 for 384.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656902656 has waited at btr0sea.c line 916 for 384.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 660892160 has waited at row0sel.c line 3326 for 384.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 659148288 has waited at btr0sea.c line 916 for 384.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666983936 has waited at btr0sea.c line 916 for 384.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656901632 has waited at row0sel.c line 3326 for 384.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 664461056 has waited at btr0sea.c line 916 for 384.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 665122560 has waited at btr0sea.c line 916 for 384.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 1084410112 has waited at btr0sea.c line 916 for 384.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 657599488 has waited at row0sel.c line 3326 for 384.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666061312 has waited at btr0sea.c line 916 for 384.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 661651456 has waited at btr0sea.c line 995 for 658.00 seconds the semaphore: X-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656901120 has waited at row0sel.c line 3326 for 416.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666058752 has waited at row0sel.c line 3326 for 416.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656902144 has waited at row0sel.c line 3326 for 416.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 138910976 has waited at srv0srv.c line 1952 for 416.00 seconds the semaphore: Mutex at 0xb544160 created file srv0srv.c line 872, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 657600000 has waited at row0sel.c line 3326 for 416.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 661319424 has waited at btr0sea.c line 916 for 416.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656902656 has waited at btr0sea.c line 916 for 416.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 660892160 has waited at row0sel.c line 3326 for 416.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 659148288 has waited at btr0sea.c line 916 for 416.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666983936 has waited at btr0sea.c line 916 for 416.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656901632 has waited at row0sel.c line 3326 for 416.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 664461056 has waited at btr0sea.c line 916 for 416.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 665122560 has waited at btr0sea.c line 916 for 416.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 1084410112 has waited at btr0sea.c line 916 for 416.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 657599488 has waited at row0sel.c line 3326 for 416.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666061312 has waited at btr0sea.c line 916 for 416.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 661651456 has waited at btr0sea.c line 995 for 690.00 seconds the semaphore: X-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656901120 has waited at row0sel.c line 3326 for 448.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666058752 has waited at row0sel.c line 3326 for 448.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656902144 has waited at row0sel.c line 3326 for 448.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 138910976 has waited at srv0srv.c line 1952 for 448.00 seconds the semaphore: Mutex at 0xb544160 created file srv0srv.c line 872, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 657600000 has waited at row0sel.c line 3326 for 448.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 661319424 has waited at btr0sea.c line 916 for 448.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656902656 has waited at btr0sea.c line 916 for 448.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 660892160 has waited at row0sel.c line 3326 for 448.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 659148288 has waited at btr0sea.c line 916 for 448.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666983936 has waited at btr0sea.c line 916 for 448.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656901632 has waited at row0sel.c line 3326 for 448.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 664461056 has waited at btr0sea.c line 916 for 448.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 665122560 has waited at btr0sea.c line 916 for 448.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 1084410112 has waited at btr0sea.c line 916 for 448.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 657599488 has waited at row0sel.c line 3326 for 448.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666061312 has waited at btr0sea.c line 916 for 448.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 661651456 has waited at btr0sea.c line 995 for 722.00 seconds the semaphore: X-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656901120 has waited at row0sel.c line 3326 for 480.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666058752 has waited at row0sel.c line 3326 for 480.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656902144 has waited at row0sel.c line 3326 for 480.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 138910976 has waited at srv0srv.c line 1952 for 480.00 seconds the semaphore: Mutex at 0xb544160 created file srv0srv.c line 872, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 657600000 has waited at row0sel.c line 3326 for 480.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 661319424 has waited at btr0sea.c line 916 for 480.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656902656 has waited at btr0sea.c line 916 for 480.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 660892160 has waited at row0sel.c line 3326 for 480.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 659148288 has waited at btr0sea.c line 916 for 480.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666983936 has waited at btr0sea.c line 916 for 480.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656901632 has waited at row0sel.c line 3326 for 480.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 664461056 has waited at btr0sea.c line 916 for 480.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 665122560 has waited at btr0sea.c line 916 for 480.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 1084410112 has waited at btr0sea.c line 916 for 480.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 657599488 has waited at row0sel.c line 3326 for 480.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666061312 has waited at btr0sea.c line 916 for 480.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 661651456 has waited at btr0sea.c line 995 for 754.00 seconds the semaphore: X-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656901120 has waited at row0sel.c line 3326 for 512.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666058752 has waited at row0sel.c line 3326 for 512.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656902144 has waited at row0sel.c line 3326 for 512.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 138910976 has waited at srv0srv.c line 1952 for 512.00 seconds the semaphore: Mutex at 0xb544160 created file srv0srv.c line 872, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 657600000 has waited at row0sel.c line 3326 for 512.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 661319424 has waited at btr0sea.c line 916 for 512.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656902656 has waited at btr0sea.c line 916 for 512.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 660892160 has waited at row0sel.c line 3326 for 512.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 659148288 has waited at btr0sea.c line 916 for 512.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666983936 has waited at btr0sea.c line 916 for 512.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656901632 has waited at row0sel.c line 3326 for 512.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 664461056 has waited at btr0sea.c line 916 for 512.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 665122560 has waited at btr0sea.c line 916 for 512.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 1084410112 has waited at btr0sea.c line 916 for 512.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 657599488 has waited at row0sel.c line 3326 for 512.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666061312 has waited at btr0sea.c line 916 for 512.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 661651456 has waited at btr0sea.c line 995 for 786.00 seconds the semaphore: X-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656901120 has waited at row0sel.c line 3326 for 544.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666058752 has waited at row0sel.c line 3326 for 544.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656902144 has waited at row0sel.c line 3326 for 544.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 138910976 has waited at srv0srv.c line 1952 for 544.00 seconds the semaphore: Mutex at 0xb544160 created file srv0srv.c line 872, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 657600000 has waited at row0sel.c line 3326 for 544.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 661319424 has waited at btr0sea.c line 916 for 544.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656902656 has waited at btr0sea.c line 916 for 544.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 660892160 has waited at row0sel.c line 3326 for 544.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 659148288 has waited at btr0sea.c line 916 for 544.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666983936 has waited at btr0sea.c line 916 for 544.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 656901632 has waited at row0sel.c line 3326 for 544.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 664461056 has waited at btr0sea.c line 916 for 544.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 665122560 has waited at btr0sea.c line 916 for 544.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 1084410112 has waited at btr0sea.c line 916 for 544.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 657599488 has waited at row0sel.c line 3326 for 544.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: Warning: a long semaphore wait: --Thread 666061312 has waited at btr0sea.c line 916 for 544.00 seconds the semaphore: S-lock on RW-latch at 0xb545a60 created in file btr0sea.c line 139 a writer (thread id 661651456) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file row0sel.c line 3326 Last time write locked in file btr0sea.c line 489 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Error: semaphore wait has lasted > 600 seconds InnoDB: We intentionally crash the server, because it appears to be hung. 070924 10:02:51InnoDB: Assertion failure in thread 138911232 in file srv0srv.c line 2093 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html InnoDB: about forcing recovery. 070924 10:02:51 - mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=402653184 read_buffer_size=2093056 max_used_connections=251 max_connections=250 threads_connected=251 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1416214 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. 070924 10:02:53 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 070924 10:02:53 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 29 1172898187. InnoDB: Doing recovery: scanned up to log sequence number 29 1172898187 InnoDB: Last MySQL binlog file position 0 28220611, file name /var/mysql/db2-bin.000087 070924 10:02:53 InnoDB: Started; log sequence number 29 1172898187 070924 10:02:53 [Note] Recovering after a crash using /var/mysql/db2-bin 070924 10:02:53 [Note] Starting crash recovery... 070924 10:02:53 [Note] Crash recovery finished. 070924 10:02:54 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.0.45-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.45 070924 11:00:07 [Warning] Aborted connection 42890 to db: 'InternetCrusade' user: 'realtown' host: 'realtown2.sandiegort.com' (Got an error reading communication packets)