Thanks for you suggestion Sasha. I looked at how the HAVE_RENAME
definition is used in mysql and came across:
[harrinp@nlhags50 mysql-3.23.46]$ grep -A 4 HAVE_RENAME
./mysys/my_rename.c#if defined(HAVE_RENAME)
if (rename(from,to))
#else
if (link(from, to) || unlink(from))
#endif
I changed my own rename test program to use link/unlink and I still get
the same problem. It works on my own PC but not on the compaq even though
it runs the same mysql version and linux kernel. This means it won't work
for mysql either. I think we need to go back to basics in here and see how
we installed linux and what the interactions are between it and the compaq
system.
Regarding your support offer, it is something we will keep in mind for
future. Remote access to machines in here is currently not possible.
Thanks again, Paul.
On Thu, 31 Jan 2002 17:55:26 -0700
Sasha Pachev <sasha@stripped> wrote:
> On Wednesday 30 January 2002 06:00 am, Paul Harrington wrote:
> > I can only conclude that the standard rename system call (and
> > presumably others) does not work on my Compaq raid system. MYSQL uses
> > similar calls and also does not work.
>
> Paul:
>
> I agree with your conclusion. Try recompiling MySQL from source, and
> after running ./configure edit config.h and comment out HAVE_RENAME
> line. MySQL then will use a different method to rename files.
>
> On a side note, if rename is broken, I wonder what else might be. I
> would recommend that you run at least our test suite after you recompile
> ( make test), and also a nice stress test that will simulate your
> application.
>
> If you are trying to run MySQL on a problematic system in a business
> environment, the most cost effective way to do it is to purchase MySQL
> support. I am forwarding a copy of this mail to Larry, our sales VP. He
> will be contacting you shortly and explain different support options we
> are offering.
>
> --
> MySQL Development Team
> For technical support contracts, visit https://order.mysql.com/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Sasha Pachev <sasha@stripped>
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
> /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA
> <___/
--
Met vriendelijke groet/Kind Regards,
Experian Nederland B.V.
Paul Harrington
IT Development
Kantoorgebouw t'Schip
Verheeskade 25
2521 BE Den Haag
phone: +31 (0) 70 440 4512
fax: +31 (0) 70 440 40 40
e-mail: Paul.Harrington@stripped
http://www.experian.nl
