Re: mysqld got signal 11;

2007-02-20 Thread Nils Meyer
Michael Fernández M. wrote: Remember that you have to stay under 2GB total memory allocation! I think you hit that limit. Sorry, but why do you say that?, because of the 32 bits kernel? Yes exactly. Depending on kernel version you can allocate something between 2 or 2.7GB. Until 2GB it's sa

Re: mysqld got signal 11;

2007-02-20 Thread M.
El mar, 20-02-2007 a las 13:38 +0100, Nils Meyer escribió: > Hi, > > Michael Fernández M. wrote: > > i use 32 Bits kernel. > > Remember that you have to stay under 2GB total memory allocation! I > think you hit that limit. Sorry, but why do you say that?, because of the 32 bits kernel? > > >

Re: mysqld got signal 11;

2007-02-20 Thread Nils Meyer
Hi, Michael Fernández M. wrote: i use 32 Bits kernel. Remember that you have to stay under 2GB total memory allocation! I think you hit that limit. innodb_additional_mem_pool_size = 500 MB. innodb_buffer_pool_size = 8 MB Before the innodb_additional_mem_pool_size was 1 MB, (the default va

Re: mysqld got signal 11;

2007-02-20 Thread M.
El mar, 20-02-2007 a las 13:16 +0100, Nils Meyer escribió: > Hi, > > Michael Fernández M. wrote: > > key_buffer_size=402653184 > > read_buffer_size=2093056 > > max_used_connections=323 > > max_connections=800 > > threads_connected=55 > > It is possible that mysqld could use up to > > key_buffer_s

Re: mysqld got signal 11;

2007-02-20 Thread Nils Meyer
Hi, Michael Fernández M. wrote: key_buffer_size=402653184 read_buffer_size=2093056 max_used_connections=323 max_connections=800 threads_connected=55 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 3666809 K bytes of memory Ho

mysqld got signal 11;

2007-02-20 Thread M.
, file mysql.c, line 303 Freed mem block at - 21280, file x0trx.c, line 78 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

Re: mysqld got signal 11

2006-02-03 Thread Gleb Paharenko
What version of MySQL are you using and in what way have you installed it. Please report an exact version of FreeBSD. Гаврилов Вячеслав wrote: > Hello developers of MySql. It is my problem: > ------- > mysqld got signal 11; > This could be because yo

mysqld got signal 11

2006-02-03 Thread Гаврилов Вячеслав
Hello developers of MySql. It is my problem: --- 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

[MySQLd got signal 11 on query with UNION of SELECTs]

2005-03-09 Thread yur
>Description: Mysqld got signal 11. HardWare: HP Proliant DL380G4 (5G RAM + 2 * Xeon 3.4GHz) SoftWare: SunOS noc-db.simtel.ru 5.9 Generic_117172-17 i86pc i386 i86pc In error log: =Start Log==> mysqld got signal 11; This could be because you hit a bug.

mysqld got signal 11

2005-02-28 Thread Batara Kesuma
Hi, I have a problem with some of my servers running 4.1.10. It is running on linux 2.6.10, Fedora Core 3 default installation. The mysql I use is from RPM package that mysql.com provides. About once a day, the servers will crash and I find mysqld got signal 11 error on the log file. These

mysqld got signal 11

2005-02-27 Thread Igal Rubinstein
Hey, Maybe, as a result of an attack, the number of threads_connected climbed suddenly to 1206, max_used_connections jumped to 1207 and the server died with the following message: "mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one o

mysqld got signal 11;

2003-07-26 Thread Stephane Raimbault
I've been searching the mailing list for a solution to my problem with "mysqld got signal 11;" and I haven't seen any answers that might help me. This is the situation. I have a db that is being accessed intensively about 400 connections during the wee at a time. I noticed

Re: mysqld got signal 11; (CRASH max-3.23.51) What do I need to do to clean up?

2003-03-21 Thread Heikki Tuuri
Joe, - Original Message - From: ""Jennifer Goodie"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, March 21, 2003 9:45 PM Subject: RE: mysqld got signal 11; (CRASH max-3.23.51) What do I need to do to clean up? > I wouldn't

RE: mysqld got signal 11; (CRASH max-3.23.51) What do I need to do to clean up?

2003-03-21 Thread Jennifer Goodie
e- From: Joe Smith [mailto:[EMAIL PROTECTED] Sent: Friday, March 21, 2003 10:53 AM To: [EMAIL PROTECTED] Subject: mysqld got signal 11; (CRASH max-3.23.51) What do I need to do to clean up? Had my first mysqld crash today after a solid 4 month uptime.The details are below. The DB restart

mysqld got signal 11; (CRASH max-3.23.51) What do I need to do to clean up?

2003-03-21 Thread Joe Smith
Dual Intel 933s 2 Gigs ram 2 gigs swap 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 tr

Re: mysqld got signal 11; This could be because you hit a bug ....

2003-02-24 Thread Sinisa Milivojevic
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, b

Re: mysqld got signal 11; This could be because you hit a bug ....

2003-02-24 Thread Mariella Di Giacomo
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 in

Re: mysqld got signal 11; This could be because you hit a bug ....

2003-02-24 Thread Sinisa Milivojevic
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

Re: mysqld got signal 11; This could be because you hit a bug ....

2003-02-24 Thread Mariella Di Giacomo
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

Re: mysqld got signal 11; This could be because you hit a bug ....

2003-02-24 Thread Sinisa Milivojevic
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 > cor

Re: mysqld got signal 11; This could be because you hit a bug ....

2003-02-24 Thread Mariella Di Giacomo
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.

Re: mysqld got signal 11; This could be because you hit a bug ....

2003-01-29 Thread Mariella Di Giacomo
/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 y

Re: mysqld got signal 11; This could be because you hit a bug ....

2003-01-29 Thread Sinisa Milivojevic
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. >

Re: mysqld got signal 11; This could be because you hit a bug ....

2003-01-29 Thread Mark
- 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

mysqld got signal 11; This could be because you hit a bug ....

2003-01-29 Thread Mariella Di Giacomo
: __ /usr/local/mysql-standard-4.0.5-beta-64bit/bin/mysqld: ready for connections 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

mysqld got signal 11

2003-01-15 Thread Bc. Radek Krejca
Hello, I found more following messages in my mysql log: 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 agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning

mysqld got signal 11;

2003-01-15 Thread Bc. Radek Krejča
Hello, I found more following messages in my mysql log: 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 agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning

4.0.6 + FLUSH QUERY CACHE -> mysqld got signal 11

2002-12-24 Thread Andrew Sitnikov
Hello mysql, Hello mysql, shell#>resolve_stack_dump -s mysqld.sym -n mysqld.stack 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

mysqld got signal 11 bug under FreeBSD 4.6 (using 4.0.3 binary)

2002-09-12 Thread noor
EATE TABLE DepartmentArticles ( DeptID bigint(20) unsigned NOT NULL default '0', AID char(32) NOT NULL default '', SortOrder bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (DeptID,AID), KEY SortOrder (SortOrder), KEY SortOrder_2 (SortOrder) ) TYPE=M

Re: mysqld got signal 11;

2002-05-17 Thread Sasha Pachev
> > A post from the MySQL list > MEMORY PROBLEM ... a pointers is "gone a way" ... > The signal is SIGSEV and this mean in fact: Invalid memory > reference. > > If this is a memory problem, how did it hit two servers ( several kilometers

Re: mysqld got signal 11;

2002-05-17 Thread Rénald CASAGRAUDE
On vendredi, mai 17, 2002, at 05:26 , Luc Foisy wrote: > Can anyone tell me what this means?? > > mysqld got signal 11; [...] (Could be) Bad RAM ? R. - Before posting, please check: http://www.mysql.com/manual.p

Re: mysqld got signal 11;

2002-05-17 Thread Gelu Gogancea
try to restart master and see what happen - Original Message - From: "Luc Foisy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "MYSQL-List (E-mail)" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, May 17, 2002 7:25 PM Subject

Re: mysqld got signal 11;

2002-05-17 Thread Gelu Gogancea
What version of MySQL you use ? I hope is not 3.23.4x. - Original Message - From: "Luc Foisy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "MYSQL-List (E-mail)" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, May 17, 20

Re: mysqld got signal 11;

2002-05-17 Thread Gelu Gogancea
- Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 17, 2002 6:52 PM Subject: Re: mysqld got signal 11; > Luc, > Friday, May 17, 2002, 6:26:19 PM, you wrote: > > LF> Can anyone tell me

RE: mysqld got signal 11;

2002-05-17 Thread Luc Foisy
info -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 11:52 AM To: [EMAIL PROTECTED] Subject: Re: mysqld got signal 11; Luc, Friday, May 17, 2002, 6:26:19 PM, you wrote: LF> Can anyone tell me what this means?? LF> mysqld got sig

RE: mysqld got signal 11;

2002-05-17 Thread Luc Foisy
>Luc Foisy writes: >> Can someone give me some clue as to what this means to me? >> >> mysqld got signal 11; >> The manual section 'Debugging a MySQL server' tells you how to use a >> stack trace and/or the core file to produce a readable backtrace

Re: mysqld got signal 11;

2002-05-17 Thread Victoria Reznichenko
Luc, Friday, May 17, 2002, 6:26:19 PM, you wrote: LF> Can anyone tell me what this means?? LF> mysqld got signal 11; LF> The manual section 'Debugging a MySQL server' tells you how to use a LF> stack trace and/or the core file to produce a readable backtrace that may LF>

Re: mysqld got signal 11;

2002-05-17 Thread Gelu Gogancea
PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Luc Foisy" <[EMAIL PROTECTED]> To: "MYSQL-List (E-mail)" <[EMAIL PROTECTED]> Sent: Friday, May 17, 2002 6:26 PM Subject: mysqld got signal 11; > Can anyone tell me what this means?? &

mysqld got signal 11;

2002-05-17 Thread Luc Foisy
Can anyone tell me what this means?? mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died Attemping backtrace. You can use the following i

Re: mysqld got signal 11;

2001-05-22 Thread Sasha Pachev
On Monday 21 May 2001 23:29, Steve wrote: > Hi, > > I am running mysql 3.23.33 getting this error about once a day causeing > mysql to restart > > > *******

Re: mysqld got signal 11;

2001-05-22 Thread Sinisa Milivojevic
Steve writes: > Hi, > > I am running mysql 3.23.33 getting this error about once a day causeing > mysql to restart > > > Thanks and Regards, > > Steve Reed > Network Administrator > Oznetwork Pty. Ltd. > 8233 1900 > 142 Phillip St > Sydney NSW 2000 > Hi! Please can you check whether your h

mysqld got signal 11;

2001-05-21 Thread Steve
Hi, I am running mysql 3.23.33 getting this error about once a day causeing mysql to restart mysqld got signal 11; The manual section 'Debugging a MySQL server&#

Re: More on: mysqld got signal 11

2001-03-08 Thread Kyle Hayes
Most of the times I have seen signal 11 in the past, it turned out to be bad memory. Once I saw it with a bad motherboard. Another time, it was a bad stick of RAM. The bad stick was a really hard one to track down as you needed to have something really finicky get put at that address before

RE: More on: mysqld got signal 11

2001-03-08 Thread Steven Roussey
s like: mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died Attemping backtrace. You can use the following information to find out where my

More on: mysqld got signal 11

2001-03-08 Thread Steven Roussey
Hi! I have received several emails from people that choose not to (or can not) post to the list about mysql segfaulting. At the moment, I have the segfaults stopped by doing all of the below, I don't know (yet) which are to blame or in what combination: 1) Eliminate insert delayed (not really n

RE: mysqld got signal 11

2001-03-07 Thread Steven Roussey
One more thing: In the processlist: | Delayed_insert | 578 | reschedule | log_day_20010307 After another minute (now over 10 minutes to reschedule) I get a _lot_ of these: | Query | 9| waiting for handler insert | insert delayed into logging.log_day_20010307 ... Which fill

Re: mysqld got signal 11

2001-03-07 Thread Steven Roussey
mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died Attemping backtrace. You can use the following information to find out where mysqld

RE: mysqld got signal 11

2001-03-07 Thread Steven Roussey
e/select. No FT at all. o The stack traces have been different but always have 'thd->query at (nil) = ' in the error log. Looks like a null pointer to me. The last stack trace: 010307 15:13:36 mysqld started /usr/local/mysql/libexec/mysqld: ready for connections mysqld got s

RE: mysqld got signal 11

2001-03-07 Thread Steven Roussey
db: 'logging' user: 'apache' host: `tank' (Got timeout reading communication packets) mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in fin

Re: mysqld got signal 11

2001-03-07 Thread Sinisa Milivojevic
Steven Roussey writes: > Hi, > > Ah, today's problems are from a bug that dates back a year or more. > Streaming a large number of insert delayeds into a table that does not exist > causes the crash. The table was not created correctly last night. > > Is there a web version of mysql code

Re: mysqld got signal 11

2001-03-07 Thread Pat Sherrill
; <[EMAIL PROTECTED]> Sent: Tuesday, March 06, 2001 6:29 PM Subject: Re: mysqld got signal 11 > Hi, > > OK, I now still have the same problem after upgrading to > 3.23.33-pc-linux-gnu-i686 binary. After myisamchking all tables, this time > it took just about one minute before c

Re: mysqld got signal 11

2001-03-07 Thread Steven Roussey
Hi, Ah, today's problems are from a bug that dates back a year or more. Streaming a large number of insert delayeds into a table that does not exist causes the crash. The table was not created correctly last night. Is there a web version of mysql code like PHP has http://lxr.php.net ? I'd like t

Re: mysqld got signal 11

2001-03-07 Thread Steven Roussey
Hi, OK, I now still have the same problem after upgrading to 3.23.33-pc-linux-gnu-i686 binary. After myisamchking all tables, this time it took just about one minute before crashing: mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack tr

mysqld got signal 11

2001-03-07 Thread Steven Roussey
ysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died Attemping backtrace. You can use the following information to find out where mysqld died.

RE: mysqld got signal 11 every 10 minutes

2001-02-01 Thread Matis, Jan
Now I can say I tryed http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.32-pc-linux-gnu-i686.ta r.gz too and it dind't helped mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a rea

RE: mysqld got signal 11 every 10 minutes

2001-02-01 Thread Matis, Jan
Have you tried using the binary tarball from the MySQL web site? http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.32-pc-linux-gnu-i686.ta r.gz Jeremy no I didn't ...so I changed it now and we will see on afternoon :) Jan

mysqld got signal 11 every 10 minutes

2001-02-01 Thread Matis, Jan
uax | grep mysqld | wc -l : between 100 and 600 (really :) this machine is db backend for one wide used portal ( 3 web machines with apache and php 4.0.4pl1 with patched persistent connections) I tryed all combinations of this but in my db.err is really often mysqld got signal 11. Does anybody

Re: mysqld got signal 11 every 10 minutes

2001-02-01 Thread Jeremy D. Zawodny
d persistent connections) > > I tryed all combinations of this but in my db.err is really often > mysqld got signal 11. > Does anybody have an idea what can I do ? > > is it possible that this is caused by bad written php scripts ? > (because I'm not developer but I kn

Re: mysqld got signal 11 every 10 minutes

2001-02-01 Thread Joseph Bueno
> > I tryed all combinations of this but in my db.err is really often > mysqld got signal 11. > Does anybody have an idea what can I do ? > > is it possible that this is caused by bad written php scripts ? (because I'm > not developer but I know how our developers work :