Hi listers,

I just got here, so please let me know if this is not the appropriate list! :)

Running MySQL 4.0.20 on Fedora Core 1, with InnoDB tables. Installed from RPMs provided at MySQL.com.

Last night the beastie came down hard, and requred a physical reboot in order to free/kill some mysqld processes. I say this as I worry that it could be from a hardware error, however it is running on a dual Xeon machine that is not even 6 months old...

When I attempted to get the stack trace I only get "nm: /usr/sbin/mysqld: no symbols", and the docs point at stuff that is not on this box. ?

I see two errors that need resolution:

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

1) In the error log, I see the following:

InnoDB: ###### Diagnostic info printed to the standard error stream
InnoDB: Warning: a long semaphore wait:
--Thread 23207961 has waited at btr0sea.c line 480 for 625.00 seconds the semaphore:
X-lock on RW-latch at 0x4506a768 created in file btr0sea.c line 139
a writer (thread id 23207961) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file btr0sea.c line 745
Last time write locked in file btr0sea.c line 480
InnoDB: Error: semaphore wait has lasted > 600 seconds
InnoDB: We intentionally crash the server, because it appears to be hung.
040702 20:45:27InnoDB: Assertion failure in thread 24583 in file sync0arr.c line 925
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. See section 6.1 of
InnoDB: http://www.innodb.com/ibman.php about forcing recovery.
mysqld got signal 11;


...and goes on to say:

key_buffer_size=402653184
read_buffer_size=2093056
max_used_connections=176
max_connections=500
threads_connected=146
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 2439212 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.


thd=(nil)
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0xbfedf758, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x80720d4
0x8250d48
0x81ed044
0x80f9148
0x824e4fc
0x828452a
New value of fp=(nil) failed sanity check, terminating stack trace!

Again, I try to follow the instructons on dealing with the stack trace but the instructions fail, and also do not provide enough explanation for me to figure out on my own how to fix it :(

---------------------------------------------------------------------------------------------
2) After rebooting the server, the error log fills up with:

040703 9:07:59 Aborted connection 55 to db: 'db1' user: 'www' host: `192.168.1.1' (Got an error reading communication packets)
...and it repeats itself roughly every 5-to-10 seconds, which I obviously find alarming.


Cannot find any reference on that error, and don't really have enough data to know how to react...


Can somebody please whack me upside the head with a cluestick?

-- Mitch

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to