Bug #32276 | Database crashes after one day of operation | ||
---|---|---|---|
Submitted: | 12 Nov 2007 11:53 | Modified: | 12 Dec 2007 12:56 |
Reporter: | Edwin Deutschl | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server: InnoDB storage engine | Severity: | S2 (Serious) |
Version: | 5.0.21 | OS: | Windows (XP SP2) |
Assigned to: | Assigned Account | CPU Architecture: | Any |
[12 Nov 2007 11:53]
Edwin Deutschl
[12 Nov 2007 11:55]
Edwin Deutschl
.err file
Attachment: RSCVSS.err (application/octet-stream, text), 183.86 KiB.
[12 Nov 2007 12:01]
MySQL Verification Team
Thank you for the bug report. Your server version is quite older, could you please upgrade to latest released version 5.0.45 a lot of bugs fix were done since. If you already have problems please comment here. Thanks in advance.
[12 Nov 2007 12:24]
Edwin Deutschl
We will upgrade to 5.0.46 and report any changes.
[12 Nov 2007 12:56]
Heikki Tuuri
Edwin, looks like a file write is stuck. This type of an error is probably a hardware fault or a buggy driver in the OS. Please test the disk subsystem of your computer. If that does not help, please test on another computer. Regards, Heikki ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 246.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6879, rounds 55472, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ... -------- FILE I/O -------- I/O thread 0 state: wait Windows aio (insert buffer thread) I/O thread 1 state: wait Windows aio (log thread) I/O thread 2 state: wait Windows aio (read thread) I/O thread 3 state: wait Windows aio (write thread) Pending normal aio reads: 0, aio writes: 1, ... ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1067 Pending reads 0 Pending writes: LRU 0, flush list 114,
[13 Dec 2007 0:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".