Re: mysqld got signal 11; This could be because you hit a bug ....
Mariella Di Giacomo writes: > Hi, > > I would prefer the debug version which the latest I believe is the 4.0.10. > The same error I get it when I run ALTER TABLES or I try to insert data > into tables. > > > I will try and let you know. > > Thanks, > > Mariella > 4.0.11 will be quite soon, but your problems indicate that it is some system setup error, which would be very fast diagnosed if we would login to your system. Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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
Re: mysqld got signal 11; This could be because you hit a bug ....
Hi, I would prefer the debug version which the latest I believe is the 4.0.10. The same error I get it when I run ALTER TABLES or I try to insert data into tables. I will try and let you know. Thanks, Mariella At 06:31 PM 2/24/03 +0200, you wrote: Mariella Di Giacomo writes: > Hi, > > I will install the 2.8 debug version. > > The reason why I set > setting sort and record buffers to 1K > is because with a few tests I have noticed that I was getting a better response > time for queries. > > The limit for the core file was unlimited. > > I will look into customer support. > > Mariella > Please also make sure that mysqld is run under mysql user and that all UNIX permissions are fine. BTW 4.0.11 is out with some fixes for OPTIMIZE table. Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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
Re: mysqld got signal 11; This could be because you hit a bug ....
Mariella Di Giacomo writes: > Hi, > > I will install the 2.8 debug version. > > The reason why I set > setting sort and record buffers to 1K > is because with a few tests I have noticed that I was getting a better response > time for queries. > > The limit for the core file was unlimited. > > I will look into customer support. > > Mariella > Please also make sure that mysqld is run under mysql user and that all UNIX permissions are fine. BTW 4.0.11 is out with some fixes for OPTIMIZE table. Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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
Re: mysqld got signal 11; This could be because you hit a bug ....
Hi, I will install the 2.8 debug version. The reason why I set setting sort and record buffers to 1K is because with a few tests I have noticed that I was getting a better response time for queries. The limit for the core file was unlimited. I will look into customer support. Mariella At 06:17 PM 2/24/03 +0200, you wrote: Mariella Di Giacomo writes: > Hello, > > I have followed your suggestion. > I have installed mysql-debug-4.0.10-gamma-sun-solaris2.9-sparc-64bit on the > Solaris 8 (Machine with 8 cpus, 32GB of Memory and 64 of swap) server. > I have started the mysqld program as root > I have specified the > core-file > in the /etc/my.cnf file. > > Other info that could be interesting in the /etc/my.cnf are HI! Causes of the crashes could be many, among the others: * using 2.9 binary on Solaris 2.8 !! Please use 2.8 binary, we have it * setting sort and record buffers to 1K !! Please set them at 1M There are many other things that could be improved, but that can be done when and if you become a registered customer. > > I have looked for the core file, but I couldn't find it, even though in the > error > log it says "Writing a core file". > > Make sure all ulimit values are OK, including the one for core file. > Does this give you any clue about what is causing the error ? > Could you help please about the "core file" > Do I need to specify the option differently ? > > > Thanks in advance for your help, > > Mariella > Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com Join MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/ - 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
Re: mysqld got signal 11; This could be because you hit a bug ....
Mariella Di Giacomo writes: > Hello, > > I have followed your suggestion. > I have installed mysql-debug-4.0.10-gamma-sun-solaris2.9-sparc-64bit on the > Solaris 8 (Machine with 8 cpus, 32GB of Memory and 64 of swap) server. > I have started the mysqld program as root > I have specified the > core-file > in the /etc/my.cnf file. > > Other info that could be interesting in the /etc/my.cnf are HI! Causes of the crashes could be many, among the others: * using 2.9 binary on Solaris 2.8 !! Please use 2.8 binary, we have it * setting sort and record buffers to 1K !! Please set them at 1M There are many other things that could be improved, but that can be done when and if you become a registered customer. > > I have looked for the core file, but I couldn't find it, even though in the > error > log it says "Writing a core file". > > Make sure all ulimit values are OK, including the one for core file. > Does this give you any clue about what is causing the error ? > Could you help please about the "core file" > Do I need to specify the option differently ? > > > Thanks in advance for your help, > > Mariella > Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com Join MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/ - 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
Re: mysqld got signal 11; This could be because you hit a bug ....
Hello, I have followed your suggestion. I have installed mysql-debug-4.0.10-gamma-sun-solaris2.9-sparc-64bit on the Solaris 8 (Machine with 8 cpus, 32GB of Memory and 64 of swap) server. I have started the mysqld program as root I have specified the core-file in the /etc/my.cnf file. Other info that could be interesting in the /etc/my.cnf are _ set-variable = max_connections=16 set-variable = max_tmp_tables=512 set-variable= table_cache=512 set-variable = key_buffer=16384M set-variable= sort_buffer=1K set-variable= record_buffer=1K set-variable= thread_cache_size=8 set-variable= thread_cache=512 set-variable= thread_concurrency=12 _ I have started 7 concurrent mysql threads (7 OPTIMIZE TABLE from mysql command line) and after 9 hours I got a segmentation fault with Error ERROR 2013: Lost connection to MySQL server during query ERROR 2013: Lost connection to MySQL server during query ERROR 2013: Lost connection to MySQL server during query ERROR 2013: Lost connection to MySQL server during query ERROR 2013: Lost connection to MySQL server during query ERROR 2013: Lost connection to MySQL server during query ERROR 2013: Lost connection to MySQL server during query Segmentation Fault 030223 16:11:05 mysqld restarted I have looked at the mysqld error log file and this is the message 030223 07:03:11 mysqld started /usr/local/mysql-debug-4.0.10-gamma-sun-solaris2.9-sparc-64bit/bin/mysqld: ready for connections. Version: '4.0.10-gamma-debug-debug-log' socket: '/tmp/mysql.sock' port: 3306 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=17179869184 read_buffer_size=8192 sort_buffer_size=32768 max_used_connections=7 max_connections=16 threads_connected=8 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 16777856 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Writing a core file 030223 16:11:05 mysqld restarted __ I have looked for the core file, but I couldn't find it, even though in the error log it says "Writing a core file". Does this give you any clue about what is causing the error ? Could you help please about the "core file" Do I need to specify the option differently ? Thanks in advance for your help, Mariella At 04:34 PM 1/29/03 +0200, Sinisa Milivojevic wrote: On Tue, 28 Jan 2003 17:12:14 -0700 Mariella Di Giacomo <[EMAIL PROTECTED]> wrote: > Hello, > > I am running mysql server (mysql-standard-4.0.5-beta-64bit) 64 bit on > Sun Solaris 2.8 and I have got the binaries form the mysql web site. > The machine I am using has 32GB of RAM + 64GB of swap. > > Thanks in advance for your help, > > Mariella > Hi! The reason why MySQL is crashing is not due to the fact that your memory is exhausted. It is possible that you have shell limits that are far below the available memory, but in your case even that is not a problem. What you should do is get a 4.0.10 debug binary for Solaris 2.8 from our site and send us a core file that is created on the crash. Also add --core-file to startup options. -- Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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
Re: mysqld got signal 11; This could be because you hit a bug ....
Hi Mark, Thanks. The memory that we are using is ECC. The reason I have only 16 connections is because that DB is used only for updates. In reality for that DB we use 3 or 4 connections maximum. We have a mirror copy used for customers which has a lot of connections. Mariella At 10:22 AM 1/29/03 +0100, Mark wrote: - Original Message - From: "Mariella Di Giacomo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, January 29, 2003 1:12 AM Subject: mysqld got signal 11; This could be because you hit a bug > Hello, > > I am running mysql server (mysql-standard-4.0.5-beta-64bit) 64 > bit on Sun Solaris 2.8 and I have got the binaries form the mysql > web site. The machine I am using has 32GB of RAM + 64GB of swap. Hi Mariella, My, that is a LOT of memory! :) What could you possibly have running that allows only 16 connections, yet uses up to the max of 96 GigaByte? :) Yikes! I take it this is high-quality ECC memory? If not, with that much memory, a seg fault could easily occur. I believe FreeBSD already advises to uses ECC memory when you have as "little" as 4 G. I'm sure you got that covered, though; just checking. :) - Mark - 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
Re: mysqld got signal 11; This could be because you hit a bug ....
On Tue, 28 Jan 2003 17:12:14 -0700 Mariella Di Giacomo <[EMAIL PROTECTED]> wrote: > Hello, > > I am running mysql server (mysql-standard-4.0.5-beta-64bit) 64 bit on > Sun Solaris 2.8 and I have got the binaries form the mysql web site. > The machine I am using has 32GB of RAM + 64GB of swap. > > Thanks in advance for your help, > > Mariella > Hi! The reason why MySQL is crashing is not due to the fact that your memory is exhausted. It is possible that you have shell limits that are far below the available memory, but in your case even that is not a problem. What you should do is get a 4.0.10 debug binary for Solaris 2.8 from our site and send us a core file that is created on the crash. Also add --core-file to startup options. -- Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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
Re: mysqld got signal 11; This could be because you hit a bug ....
- Original Message - From: "Mariella Di Giacomo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, January 29, 2003 1:12 AM Subject: mysqld got signal 11; This could be because you hit a bug > Hello, > > I am running mysql server (mysql-standard-4.0.5-beta-64bit) 64 > bit on Sun Solaris 2.8 and I have got the binaries form the mysql > web site. The machine I am using has 32GB of RAM + 64GB of swap. Hi Mariella, My, that is a LOT of memory! :) What could you possibly have running that allows only 16 connections, yet uses up to the max of 96 GigaByte? :) Yikes! I take it this is high-quality ECC memory? If not, with that much memory, a seg fault could easily occur. I believe FreeBSD already advises to uses ECC memory when you have as "little" as 4 G. I'm sure you got that covered, though; just checking. :) - Mark - 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