Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 7 Sep 2001 17:09:24 +0200 (CEST)
From:      "Hartmann, O." <ohartman@klima.physik.uni-mainz.de>
To:        <freebsd-stable@freebsd.org>
Cc:        <freebsd-smp@freebsd.org>
Subject:   WARNING! FreeBSD4.4-RC and MySQL 3.23.41_1 seem to do strange things!
Message-ID:  <20010907165837.V4420-100000@klima.physik.uni-mainz.de>

next in thread | raw e-mail | index | archive | help
Dear Sirs.

Since my upgrade to 4.4-RC several days ago, I have had problems
never seen bevor. Starting with crahes on SMP systems, key misgeneration
under ssh environment up to this:

We use MySQL 3.23.41_1 from ports as our climate-database serving
system with several simple homebrewn C programs for feeding the
database. These programs were all recompiled whenever I changed the
system (FBSD) AND the MySQL server sources so mysqllib should be
compiled in the right way. these programs do nothing tricky, simply
read out ASCII files and inserting them after a check into the data=
base - nothing else.

Phenomenon:

After recompiling the OS, restarting the server three days ago a very
strange behaviour occured: all entries of the recent day withing the
table of the database were set to 'NaN' (aka NULL). The only way to get rid
of that was to recompile both server, OS and the C programs (I thought that
might help without investigating deeper inside the problem). That helped.

Today I cvsupdated again and did all the stuff, recompiling MySQL from
the ports, FreeBSD 4.4-RC and the C client to get the newest code inside.
But that didn't help anyway.

Then I watched the download from the prefered cvsupdate- and ports-site
and realized this:

	>> mysql-3.23.41.tar.gz doesn't seem to exist in
	/usr/ports/distfiles/.
	>> Attempting to fetch from
	ftp://ftp.de.freebsd.org/pub/FreeBSD/ports/distfiles/.
	Receiving mysql-3.23.41.tar.gz (11723146 bytes): 100%
	11723146 bytes transferred in NaN seconds (NaN Bps)

Watch out the transfer statistics in the last row. This appears now
all over the whole system and looks like the same what kills our data=
base application.

That seems to be a fault of the OS, not of the database (MySQL) or
the C client program (but it is involved by libs from the system, also).

What's wrong?

Is something wrong with the floats?

--
MfG
O. Hartmann

ohartman@klima.physik.uni-mainz.de
----------------------------------------------------------------
IT-Administration des Institutes fuer Physik der Atmosphaere (IPA)
----------------------------------------------------------------
Johannes Gutenberg Universitaet Mainz
Becherweg 21
55099 Mainz

Tel: +496131/3924662 (Maschinenraum)
Tel: +496131/3924144
FAX: +496131/3923532


To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-stable" in the body of the message




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20010907165837.V4420-100000>