Hi Matt, Thanks for the detailed response regrading the SIGSEGV. I am stumped, the compiler and hardware sound fine. The defaults on MySQL are very stingy (A good thing). I think this is time for a linux expert, (I run FreeBSD).
My first suggestion would be to come up to a much more current version currently 3.23.46. There have been 15 releases since that version and you may be running across a known bug that has been fixed. Looking at the back trace you provided though I am going to guess that there is a threads problem in your particular Linux (Only a guess). My only other suggestion as Sasha already suggested is to try the MySQL statically compiled binary available from the web site and see if it does the same for you. That one is built with know good libraries. Hopefully someone more expert on linux will respond! Good Luck! Ken ----- Original Message ----- From: "matt" <[EMAIL PROTECTED]> To: "Ken Menzel" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, December 04, 2001 11:40 AM Subject: Re: killed by SIGSEGV > On Tue, 4 Dec 2001, Ken Menzel wrote: > > Your platform: Linux? What version? your kernel? > > Sorry, I should have included this information in my first post. > > The hardware is a Dell 2550 poweredge with a 1GHz Intel 3, 500MB ECC > RAM, 2 SCSI disks in RAID and some intel NICS. > > The OS is GNU/Linux 2.4.4 patched for Dell's RAID. The distro is > my own (based on LFS and Slackware). Library info below. > > Here are some details from mysqlbug: > > >Release: mysql-3.23.31 (Source distribution) > > System: Linux bertha 2.4.4 #2 SMP Thu Aug 23 15:43:39 BST 2001 i686 > unknown > Architecture: i686 > > Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc > GCC: Reading specs from > /usr/lib/gcc-lib/i686-pc-linux-gnu/2.95.2/specs > gcc version 2.95.2 19991024 (release) > Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' > LDFLAGS='' > LIBC: > lrwxrwxrwx 1 root root 13 Aug 17 12:14 /lib/libc.so.6 > -> libc-2.1.3.so > -rwxr-xr-x 1 root root 4186643 May 3 2001 > /lib/libc-2.1.3.so > -rw-r--r-- 1 root root 20332328 May 3 2001 /usr/lib/libc.a > -rw-r--r-- 1 root root 178 May 3 2001 > /usr/lib/libc.so > Configure command: ./configure --prefix=/usr/local/mysql > > Here are the first 3 lines from /proc/meminfo: > > total: used: free: shared: buffers: cached: > Mem: 525471744 508993536 16478208 0 10096640 361168896 > Swap: 304324608 131072 304193536 > > Fractional usage of swap indicates that the machine isn't being > pushed, and indeed the load is usually low. > > > What is your my.cnf? > > I don't have a my.cnf, so I assume its all defaults - do you know > where I can find this out or would I be advised to work out my own > custom config for this machine based on the my-medium.cnf or > my-large.cnf files in share/mysql? > > > Many time a signal 11 indicates a Harware/memory problem are you > > running ECC memory? > > I currently have 500MB ECC RAM, supplied by Dell. I used to get this > problem on an old Linux box with some dodgy RAM. It would be fine > until I compiled big programs. This box has been fine though, I've > compiled the kernel no problem 10s of times. > > Hopefully thats covered everything, > > thanks again - Matt. > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
