Re: mysqld crash & stack trace from 3.23.47-max (with InnoDB)

2002-02-04 Thread Jeremy Zawodny

On Mon, Feb 04, 2002 at 02:33:40PM -0700, Sasha Pachev wrote:
> On Monday 04 February 2002 11:59 am, Jeremy Zawodny wrote:
> > >?This does look like a libc bug. How did you build either one of the 
> binaries?
> > 
> > They're your binaries. ?I don't buld my own binaries on Linux to save
> > the hassle of using libraries that are different from what you folks
> > use. :-)
> > 
> > Strangely, it's working now--after a reboot. ?I'm gonna keep an eye on
> > that machine.
> 
> If it is working after reboot, I would name the disk cache
> corruption as the primary suspect. My hypothesis is that you were
> unlucky to have libnss.so cached in the buggy part of the disk
> cache. Although our binaries are statically linked, on Linux calls
> to name resolving functions allways require loading a shared
> library, even if you are doing it from a statically linked binary.

Could be.  I sure hope that's not the case, but who knows at this point.

> What kernel version are you running, and is this a virgin kernel
> from kernel.org or a patched one from some Linux distribution?

The box is currently running a 2.4.12 that I don't *think* is
patched.  I've gotta talk to the guy who builds our linux kernels and
get an upgrade on that machine anyway.

> P.S. "It works after reboot" is an ominous phrase that I hope will
> be chased out of the Linux world quickly.

Yeah, it really surprised me.

> We need to track down this problem ASAP and send a full bug report
> to the kernel developers.

Agreed.

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

MySQL 3.23.41-max: up 0 days, processed 22,591,842 queries (388/sec. avg)

-
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 crash & stack trace from 3.23.47-max (with InnoDB)

2002-02-04 Thread Sasha Pachev

On Monday 04 February 2002 11:59 am, Jeremy Zawodny wrote:
> >?This does look like a libc bug. How did you build either one of the 
binaries?
> 
> They're your binaries. ?I don't buld my own binaries on Linux to save
> the hassle of using libraries that are different from what you folks
> use. :-)
> 
> Strangely, it's working now--after a reboot. ?I'm gonna keep an eye on
> that machine.

If it is working after reboot, I would name the disk cache corruption as the 
primary suspect. My hypothesis is that you were unlucky to have libnss.so 
cached in the buggy part of the disk cache. Although our binaries are 
statically linked, on Linux calls to name resolving functions allways require 
loading a shared library, even if you are doing it from a statically linked 
binary.

What kernel version are you running, and is this a virgin kernel from 
kernel.org or a patched one from some Linux distribution?

P.S. "It works after reboot" is an ominous phrase that I hope will be chased 
out of the Linux world quickly. We need to track down this problem ASAP and 
send a full bug report to the kernel developers.

-- 
MySQL Development Team
For technical support contracts, visit https://order.mysql.com/
   __  ___ ___   __ 
  /  |/  /_ __/ __/ __ \/ /   Sasha Pachev <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Provo, Utah, USA
   <___/  

-
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 crash & stack trace from 3.23.47-max (with InnoDB)

2002-02-04 Thread Jeremy Zawodny

On Mon, Feb 04, 2002 at 10:08:37AM -0700, Sasha Pachev wrote:
> On Monday 04 February 2002 02:30 am, Jeremy Zawodny wrote:
> > 0x807bb5f handle_segfault__Fi + 383
> > 0x82a94aa pthread_sighandler + 154
> > 0x7cb80076 __evoke_link_warning_llseek + 1954074198
> > 0x7cb7fe19 __evoke_link_warning_llseek + 1954073593
> > 0x7cb713e6 __evoke_link_warning_llseek + 1954013638
> > 0x7c97db8b __evoke_link_warning_llseek + 1951967595
> > 0x7c980668 __evoke_link_warning_llseek + 1951978568
> > 0x7c981200 __evoke_link_warning_llseek + 1951981536
> > 0x7c96dee4 __evoke_link_warning_llseek + 1951902916
> > 0x82ddd0a gethostbyaddr_r + 346
> > 0x82ddb44 gethostbyaddr + 196
> > 0x807ff98 ip_to_hostname__FP7in_addrPUi + 232
> > 0x808082c check_connections__FP3THD + 152
> > 0x8080c79 handle_one_connection__FPv + 321
> 
> This does look like a libc bug. How did you build either one of the binaries?

They're your binaries.  I don't buld my own binaries on Linux to save
the hassle of using libraries that are different from what you folks
use. :-)

Strangely, it's working now--after a reboot.  I'm gonna keep an eye on
that machine.

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

MySQL 3.23.41-max: up 0 days, processed 18,324,732 queries (409/sec. avg)

-
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 crash & stack trace from 3.23.47-max (with InnoDB)

2002-02-04 Thread Jeremy Zawodny

On Mon, Feb 04, 2002 at 07:15:33PM +0200, Sinisa Milivojevic wrote:
> 
> Yes, this is troubling ...
> 
> It could be hardware, though ...
> 
> Can you find anything in MySQL log and especially in /var/log/dmesg
> or /var/log/messages.

Nope.

> Sometimes, not often,  Linux kernel is capable of noticing potential
> hardware problems.
> 
> If mysql server crashes after number of connections has increased, it
> could be hardware, e.g. RAM or cache ...

Yeah, it's hard to say.  The machine has been stabe and running MySQL
for a long time.  I'll have to tinker some more and see.

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

MySQL 3.23.41-max: up 0 days, processed 14,716,450 queries (376/sec. avg)

-
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 crash & stack trace from 3.23.47-max (with InnoDB)

2002-02-04 Thread Sinisa Milivojevic

Jeremy Zawodny writes:
> On Mon, Feb 04, 2002 at 02:27:01PM +0200, Sinisa Milivojevic wrote:
> 
> That was your binary on Linux.
> 
> Strangely, I just started up that exact same copy of 3.23.47-max and
> it worked fine after a machine reboot.
> 
> That's most unusual (and troubling).
> 
> Thanks,
> 
> Jeremy
> -- 
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936
> 
> MySQL 3.23.41-max: up 0 days, processed 13,981,507 queries (369/sec. avg)
> 


Yes, this is troubling ...

It could be hardware, though ...

Can you find anything in MySQL log and especially in /var/log/dmesg or
/var/log/messages.

Sometimes, not often,  Linux kernel is capable of noticing potential
hardware problems.

If mysql server crashes after number of connections has increased, it
could be hardware, e.g. RAM or cache ...

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /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 crash & stack trace from 3.23.47-max (with InnoDB)

2002-02-04 Thread Sasha Pachev

On Monday 04 February 2002 02:30 am, Jeremy Zawodny wrote:
> 0x807bb5f handle_segfault__Fi + 383
> 0x82a94aa pthread_sighandler + 154
> 0x7cb80076 __evoke_link_warning_llseek + 1954074198
> 0x7cb7fe19 __evoke_link_warning_llseek + 1954073593
> 0x7cb713e6 __evoke_link_warning_llseek + 1954013638
> 0x7c97db8b __evoke_link_warning_llseek + 1951967595
> 0x7c980668 __evoke_link_warning_llseek + 1951978568
> 0x7c981200 __evoke_link_warning_llseek + 1951981536
> 0x7c96dee4 __evoke_link_warning_llseek + 1951902916
> 0x82ddd0a gethostbyaddr_r + 346
> 0x82ddb44 gethostbyaddr + 196
> 0x807ff98 ip_to_hostname__FP7in_addrPUi + 232
> 0x808082c check_connections__FP3THD + 152
> 0x8080c79 handle_one_connection__FPv + 321

This does look like a libc bug. How did you build either one of the binaries?


-- 
MySQL Development Team
For technical support contracts, visit https://order.mysql.com/
   __  ___ ___   __ 
  /  |/  /_ __/ __/ __ \/ /   Sasha Pachev <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Provo, Utah, USA
   <___/  

-
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 crash & stack trace from 3.23.47-max (with InnoDB)

2002-02-04 Thread Jeremy Zawodny

On Mon, Feb 04, 2002 at 02:27:01PM +0200, Sinisa Milivojevic wrote:
> 
> Jeremy,
> 
> It could also be a bug in glibc. 
> 
> As you are using Linux, can you try out binary ??

That was your binary on Linux.

Strangely, I just started up that exact same copy of 3.23.47-max and
it worked fine after a machine reboot.

That's most unusual (and troubling).

Thanks,

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

MySQL 3.23.41-max: up 0 days, processed 13,981,507 queries (369/sec. avg)

-
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 crash & stack trace from 3.23.47-max (with InnoDB)

2002-02-04 Thread jocelyn fournier

Hi,

> To tell you a truth, I have downloaded 2.2.5 but still have not found
> time to build / install them.

Perhaps the fear of glibc compilation / installation ;)

I've already installed 2.2.5, and it works really fine for me (and at least
it compiles with gcc 3.0.3 ! :))
(with #define STACK_SIZE  (128 * 1024) and #define PTHREAD_THREADS_MAX 4096)

Anyway, thank you for the advice :)

Regards,

Jocelyn Fournier
- Original Message -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, February 04, 2002 1:49 PM
Subject: Re: mysqld crash & stack trace from 3.23.47-max (with InnoDB)


> jocelyn fournier writes:
> > Hi,
> >
> > About glibc, I saw the 2.2.5 release included the spinlock.c patch, part
of
> > the internals.h (except the following part :
> > -#define STACK_SIZE  (2 * 1024 * 1024)
> > +#define STACK_SIZE  (128 * 1024)
> > )
> > The local_lim.h is also partially patched :
> >
> > The following part :
> > -#define PTHREAD_THREADS_MAX 1024
> > +#define PTHREAD_THREADS_MAX 4096
> >
> > is missing.
> >
> > So my question is : with glibc 2.2.5, should I modify the STACK_SIZE and
> > PTHREAD_THREADS_MAX values ? (and why didn't they applied those part of
> > patches ?)
> >
> > Thank you !
> >
> > Best Regards,
> >
> > Jocelyn Fournier
> > Presence-PC
>
>
> To tell you a truth, I have downloaded 2.2.5 but still have not found
> time to build / install them.
>
> For MySQL 64 * 1024 stack size is sufficient and should be set  in
> that fashion if you run lot's of connections. Similar reasoning
> applies to number of threads.
>
> --
> Regards,
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /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 crash & stack trace from 3.23.47-max (with InnoDB)

2002-02-04 Thread Sinisa Milivojevic

jocelyn fournier writes:
> Hi,
> 
> About glibc, I saw the 2.2.5 release included the spinlock.c patch, part of
> the internals.h (except the following part :
> -#define STACK_SIZE  (2 * 1024 * 1024)
> +#define STACK_SIZE  (128 * 1024)
> )
> The local_lim.h is also partially patched :
> 
> The following part :
> -#define PTHREAD_THREADS_MAX  1024
> +#define PTHREAD_THREADS_MAX  4096
> 
> is missing.
> 
> So my question is : with glibc 2.2.5, should I modify the STACK_SIZE and
> PTHREAD_THREADS_MAX values ? (and why didn't they applied those part of
> patches ?)
> 
> Thank you !
> 
> Best Regards,
> 
> Jocelyn Fournier
> Presence-PC


To tell you a truth, I have downloaded 2.2.5 but still have not found
time to build / install them.

For MySQL 64 * 1024 stack size is sufficient and should be set  in
that fashion if you run lot's of connections. Similar reasoning
applies to number of threads.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /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 crash & stack trace from 3.23.47-max (with InnoDB)

2002-02-04 Thread jocelyn fournier

Hi,

About glibc, I saw the 2.2.5 release included the spinlock.c patch, part of
the internals.h (except the following part :
-#define STACK_SIZE  (2 * 1024 * 1024)
+#define STACK_SIZE  (128 * 1024)
)
The local_lim.h is also partially patched :

The following part :
-#define PTHREAD_THREADS_MAX1024
+#define PTHREAD_THREADS_MAX4096

is missing.

So my question is : with glibc 2.2.5, should I modify the STACK_SIZE and
PTHREAD_THREADS_MAX values ? (and why didn't they applied those part of
patches ?)

Thank you !

Best Regards,

Jocelyn Fournier
Presence-PC

- Original Message -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, February 04, 2002 1:27 PM
Subject: Re: mysqld crash & stack trace from 3.23.47-max (with InnoDB)


> Jeremy Zawodny writes:
> > I just attempted to upgrade a 3.23.41-max server on Linux 2.4.12 to
> > 3.23.47-max.  Before starting up 3.23.47-max, I added several Innodb
> > options to the my.cnf file:
> >
> [skip]
> >
> > Thanks,
> >
> > Jeremy
> > --
> > Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> > Technical Yahoo - Yahoo Finance
> > Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936
> >
> > MySQL 3.23.41-max: up 0 days, processed 4,634,010 queries (446/sec. avg)
> >
>
> Jeremy,
>
> It could also be a bug in glibc.
>
> As you are using Linux, can you try out binary ??
>
>
> --
> Regards,
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /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
>
>


-
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 crash & stack trace from 3.23.47-max (with InnoDB)

2002-02-04 Thread Heikki Tuuri

Hi!

InnoDB seems to have created the database and started ok. This does not look
like an InnoDB bug.

I think gethostbyaddr asks from a connection the hostname, and subsequent
code checks that the host has access rights to mysqld.

For some reason gethostbyaddr_r crashes.

Hmm.. if you could run inside gdb and look what parameters mysqld passes to
gethostbyaddr in mysql/sql/hostname.cc, then it would be easier to determine
what goes wrong.

Regards,

Heikki
Innobase Oy

Jeremy Zawodny wrote in message ...
>I just attempted to upgrade a 3.23.41-max server on Linux 2.4.12 to
>3.23.47-max.  Before starting up 3.23.47-max, I added several Innodb
>options to the my.cnf file:
>
>---snip---
>innodb_data_file_path =
ibdata1:2000M;ibdata2:2000M;ibdata3:2000M;ibdata4:2000M
>innodb_data_home_dir = /home/mysql/yahoo/ibdata
>innodb_log_group_home_dir = /home/mysql/yahoo/iblog
>innodb_log_arch_dir = /home/mysql/yahoo/iblog
>set-variable = innodb_mirrored_log_groups=1
>set-variable = innodb_log_files_in_group=3
>set-variable = innodb_log_file_size=128M
>set-variable = innodb_log_buffer_size=32M
>innodb_flush_log_at_trx_commit=0
>innodb_log_archive=0
>set-variable = innodb_buffer_pool_size=384M
>set-variable = innodb_additional_mem_pool_size=4M
>set-variable = innodb_file_io_threads=4
>set-variable = innodb_lock_wait_timeout=50
>---snip---
>
>And then started the server.  It created the 4 data files as well as
>the the log files.  Then I got:
>
>InnoDB: Doublewrite buffer not found: creating new
>InnoDB: Doublewrite buffer created
>InnoDB: Creating foreign key constraint system tables
>InnoDB: Foreign key constraint system tables created
>020204  1:24:13  InnoDB: Started
>/home/mysql/bin/mysqld: ready for connections
>mysqld got signal 11;
>
>and a stack trace, which resolved into:
>
>0x807bb5f handle_segfault__Fi + 383
>0x82a94aa pthread_sighandler + 154
>0x7cb80076 __evoke_link_warning_llseek + 1954074198
>0x7cb7fe19 __evoke_link_warning_llseek + 1954073593
>0x7cb713e6 __evoke_link_warning_llseek + 1954013638
>0x7c97db8b __evoke_link_warning_llseek + 1951967595
>0x7c980668 __evoke_link_warning_llseek + 1951978568
>0x7c981200 __evoke_link_warning_llseek + 1951981536
>0x7c96dee4 __evoke_link_warning_llseek + 1951902916
>0x82ddd0a gethostbyaddr_r + 346
>0x82ddb44 gethostbyaddr + 196
>0x807ff98 ip_to_hostname__FP7in_addrPUi + 232
>0x808082c check_connections__FP3THD + 152
>0x8080c79 handle_one_connection__FPv + 321
>
>I'm going back to 3.23.41-max for now.
>
>Any idea what's up?  The configuration, other than InnoDB was
>virtually identical to the previous version.  In fact, I copied the
>working my.cnf file and added the innodb bits.
>
>Thanks,
>
>Jeremy
>--
>Jeremy D. Zawodny, <[EMAIL PROTECTED]>
>Technical Yahoo - Yahoo Finance
>Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936
>
>MySQL 3.23.41-max: up 0 days, processed 4,634,010 queries (446/sec. avg)
>



-
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




mysqld crash & stack trace from 3.23.47-max (with InnoDB)

2002-02-04 Thread Jeremy Zawodny

I just attempted to upgrade a 3.23.41-max server on Linux 2.4.12 to
3.23.47-max.  Before starting up 3.23.47-max, I added several Innodb
options to the my.cnf file:

---snip---
innodb_data_file_path = ibdata1:2000M;ibdata2:2000M;ibdata3:2000M;ibdata4:2000M
innodb_data_home_dir = /home/mysql/yahoo/ibdata
innodb_log_group_home_dir = /home/mysql/yahoo/iblog
innodb_log_arch_dir = /home/mysql/yahoo/iblog
set-variable = innodb_mirrored_log_groups=1
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=128M
set-variable = innodb_log_buffer_size=32M
innodb_flush_log_at_trx_commit=0
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=384M
set-variable = innodb_additional_mem_pool_size=4M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
---snip---

And then started the server.  It created the 4 data files as well as
the the log files.  Then I got:

InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
020204  1:24:13  InnoDB: Started
/home/mysql/bin/mysqld: ready for connections
mysqld got signal 11;

and a stack trace, which resolved into:

0x807bb5f handle_segfault__Fi + 383
0x82a94aa pthread_sighandler + 154
0x7cb80076 __evoke_link_warning_llseek + 1954074198
0x7cb7fe19 __evoke_link_warning_llseek + 1954073593
0x7cb713e6 __evoke_link_warning_llseek + 1954013638
0x7c97db8b __evoke_link_warning_llseek + 1951967595
0x7c980668 __evoke_link_warning_llseek + 1951978568
0x7c981200 __evoke_link_warning_llseek + 1951981536
0x7c96dee4 __evoke_link_warning_llseek + 1951902916
0x82ddd0a gethostbyaddr_r + 346
0x82ddb44 gethostbyaddr + 196
0x807ff98 ip_to_hostname__FP7in_addrPUi + 232
0x808082c check_connections__FP3THD + 152
0x8080c79 handle_one_connection__FPv + 321

I'm going back to 3.23.41-max for now.

Any idea what's up?  The configuration, other than InnoDB was
virtually identical to the previous version.  In fact, I copied the
working my.cnf file and added the innodb bits.

Thanks,

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

MySQL 3.23.41-max: up 0 days, processed 4,634,010 queries (446/sec. avg)

-
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