Sven,

line 637 in mysql/innobase/os/os0file.c asserts that

TRUE == os_file_flush(file)

If you look at about line 557, you see how InnoDB does
the file flush: the default is to call fdatasync.

To solve the problem we should look at the NFS manuals
about what Unix functions are available in it. Maybe there
is some special NFS_fsync?

Did it crash immediately you started using it? What is
my.cnf like?

Regards,

Heikki

-----Original Message-----
From: Sven Huster <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Friday, June 15, 2001 11:32 AM
Subject: mysql died with innodb


>hi
>
>i got this on my mysql server (any ideas?):
>
>InnoDB: Assertion failure in thread 234323968 in file os0file.c line 637
>InnoDB: We intentionally generate a memory trap.
>InnoDB: Send a detailed bug report to [EMAIL PROTECTED]
>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 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=134213632
>record_buffer=2093056
>sort_buffer=2097144
>max_used_connections=121
>max_connections=360
>threads_connected=106
>It is possible that mysqld could use up to
>key_buffer_size + (record_buffer + sort_buffer)*max_connections = 1604185 K
>bytes of memory
>Hope that's ok, if not, decrease some variables in the equation
>
>010615 08:09:27  mysqld ended
>
>System: FreeBSD 4.3-RELEASE
>MySQL: MySQL-Max-3.23.39 over nfs
>
>thanks
>regards
>Sven



---------------------------------------------------------------------
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

Reply via email to