From owner-freebsd-stable Fri Sep 7 8: 9:36 2001 Delivered-To: freebsd-stable@freebsd.org Received: from klima.physik.uni-mainz.de (klima.Physik.Uni-Mainz.DE [134.93.180.162]) by hub.freebsd.org (Postfix) with ESMTP id D2BC537B403; Fri, 7 Sep 2001 08:09:25 -0700 (PDT) Received: from klima.Physik.Uni-Mainz.DE (klima.Physik.Uni-Mainz.DE [134.93.180.162]) by klima.physik.uni-mainz.de (8.11.6/8.11.4) with ESMTP id f87F9ON04538; Fri, 7 Sep 2001 17:09:25 +0200 (CEST) (envelope-from ohartman@klima.physik.uni-mainz.de) Date: Fri, 7 Sep 2001 17:09:24 +0200 (CEST) From: "Hartmann, O." To: Cc: 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> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-stable@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG 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