Hello.
Switch to the latest release 4.1.12 (or 4.0.24). It is strongly recommended to use official binaries. "Andrew Hill" <[EMAIL PROTECTED]> wrote: > Hi all, > > Over the last couple of days, a MySQL 4.0.21 server of ours has crashed > a couple of times, with the error message listed below. It has > previously been running without problems since being installed (about > 150 days so far). > > I've not had much luck in tracking down what "signal 6" means - the > references I can find on the 'net seem to be from people running MySQL > on a *BSD machine, while ours is on a RHEL3 server. > > Can anyone please point me in the right direction to track down what > this might be? The server has 10GB of RAM, and MySQL has been compiled > with -fomit-frame-pointer. I can re-compile MySQL without this option if > it's absolutely necessary. > > Thanks, > > > > 050602 17:18:47 Out of memory; Check if mysqld or some other process > uses all available memory. If not you may have to use 'ulimit' to allow > mysqld to use more memory or you can add more swap space > mysqld got signal 6; > 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=3D8388608 > read_buffer_size=3D2093056 > max_used_connections=3D235 > max_connections=3D800 > threads_connected=3D190 > It is possible that mysqld could use up to > key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections > =3D 3281785 K > bytes of memory > Hope that's ok; if not, decrease some variables in the equation. > > thd=3D0xc271010 > 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... > frame pointer (ebp) is NULL, did you compile with > -fomit-frame-pointer? Aborting backtrace! > Trying to get some variables. > Some pointers may be invalid and cause the dump to abort... > thd->query at 0x1a70a218 is invalid pointer > thd->thread_id=3D1642298 > The manual page at http://www.mysql.com/doc/en/Crashing.html contains > information that should help you find out what is causing the crash. > Fatal signal 11 while backtracing > > > -- > Andrew Hill > Software Developer > m3 Media Services Limited > Kirkman House, 12-14 Whitfield Street, London W1T 2RF > T: +44 (0)20 7299 7370 F: +44 (0)20 7299 7371 > IRC: #max on freenode.net=20 > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]