it also was my first idea to check /var/log/messages
immediately, but nothing in there.

we now run our servers as diskless machines over nfs
on the netapp filer for +6 month and no errors at all,
on any of the machines.

regards

Sven Huster
Senior IT Systems Engineer



> -----Original Message-----
> From: Dan Nelson [mailto:[EMAIL PROTECTED]]
> Sent: 15 June, 2001 19:58
> To: Heikki Tuuri
> Cc: [EMAIL PROTECTED]
> Subject: Re: mysql died with innodb
>
>
> *This message was transferred with a trial version of
> CommuniGate(tm) Pro*
> In the last episode (Jun 15), Heikki Tuuri said:
> > 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?
>
> When fsync() is called on an NFS filehandle, the system flushes any
> dirty buffers on the client, and if over an NFSv3 mount, commits the
> writes.
>
> Sven: did you get any "nfs server timeout" messages in
> /var/log/messages?
>
> Heikki: how hard would it be to send the errno back to the client if
> filesystem calls fail?  On regular MYISAM tables, the user sees an
> error message (or something gets dumped to the error log) and the
> server doesn't assert().
>
> --
>       Dan Nelson
>       [EMAIL PROTECTED]
>
> ---------------------------------------------------------------------
> 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

Reply via email to