Re: InnoDB: Assertion failure - MySQL keeps crashing

2007-06-22 Thread Ananda Kumar
Hi Julien, Do you see any InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/mysql/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. of these error in the error log file.

Re: Re : InnoDB: Assertion failure - MySQL keeps crashing

2007-06-22 Thread Ananda Kumar
: Julien Marchand [EMAIL PROTECTED] Cc : mysql@lists.mysql.com Envoyé le : Vendredi, 22 Juin 2007, 13h45mn 12s Objet : Re: InnoDB: Assertion failure - MySQL keeps crashing Hi Julien, Do you see any InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/mysql/ibdata1, error

Re : InnoDB: Assertion failure - MySQL keeps crashing

2007-06-22 Thread Julien Marchand
No, I don't have this error :/ And not any file system full issue... - Message d'origine De : Ananda Kumar [EMAIL PROTECTED] À : Julien Marchand [EMAIL PROTECTED] Cc : mysql@lists.mysql.com Envoyé le : Vendredi, 22 Juin 2007, 13h45mn 12s Objet : Re: InnoDB: Assertion failure - MySQL

Re : Re : InnoDB: Assertion failure - MySQL keeps crashing

2007-06-22 Thread Julien Marchand
@lists.mysql.com Envoyé le : Vendredi, 22 Juin 2007, 16h31mn 15s Objet : Re: Re : InnoDB: Assertion failure - MySQL keeps crashing I had this issue, so just wanted to know, even if you have the same error message. regards anandkl On 6/22/07, Julien Marchand [EMAIL PROTECTED] wrote: No, I don't have

RE: InnoDB: Assertion failure - MySQL keeps crashing

2007-06-22 Thread David Griffiths
Did you see this part of the stack trace? It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 182271 K bytes of memory Hope that's ok, if not, decrease some variables in the equation How much memory (MyISAM and InnoDB) are you allocating

Re : InnoDB: Assertion failure - MySQL keeps crashing

2007-06-22 Thread Julien Marchand
PROTECTED] À : Julien Marchand [EMAIL PROTECTED]; mysql@lists.mysql.com Envoyé le : Vendredi, 22 Juin 2007, 21h18mn 01s Objet : RE: InnoDB: Assertion failure - MySQL keeps crashing Did you see this part of the stack trace? It is possible that mysqld could use up to key_buffer_size + (record_buffer

RE: Re : InnoDB: Assertion failure - MySQL keeps crashing

2007-06-22 Thread David Griffiths
me know how it goes. David -Original Message- From: Julien Marchand [mailto:[EMAIL PROTECTED] Sent: June 22, 2007 12:43 PM To: David Griffiths Cc: mysql@lists.mysql.com Subject: Re : InnoDB: Assertion failure - MySQL keeps crashing Yes, and I also saw InnoDB: Out of memory in additional

Re : Re : InnoDB: Assertion failure - MySQL keeps crashing

2007-06-22 Thread Julien Marchand
:) - Message d'origine De : David Griffiths [EMAIL PROTECTED] À : Julien Marchand [EMAIL PROTECTED] Cc : mysql@lists.mysql.com Envoyé le : Vendredi, 22 Juin 2007, 23h31mn 27s Objet : RE: Re : InnoDB: Assertion failure - MySQL keeps crashing It doesn't look like a memory issue, but only you