Date: Thu, 20 Sep 2001 12:09:37 +0300 From: Peter Pentchev <roam@ringlet.net> To: "Hartmann, O." <ohartman@klima.physik.uni-mainz.de> Cc: freebsd-ports@freebsd.org Subject: Re: MySQL 2.32.42 problems Message-ID: <20010920120937.C4915@ringworld.oblivion.bg> In-Reply-To: <20010918153746.W2151-100000@klima.physik.uni-mainz.de>; from ohartman@klima.physik.uni-mainz.de on Tue, Sep 18, 2001 at 03:44:56PM %2B0200 References: <20010918153746.W2151-100000@klima.physik.uni-mainz.de>
next in thread | previous in thread | raw e-mail | index | archive | help
On Tue, Sep 18, 2001 at 03:44:56PM +0200, Hartmann, O. wrote: > Hello. > > Since our upgrade to FreeBSD 4.4 (began around September, 1st) we ran into > trouble with mysql 2.32.42. > > The symptoms are that columns of type 'DOUBLE' shows 'NaN' after recompilation > of FreeBSD (make world). > We use a small C programm which inserts double vars into a table containing > climate values for research. The phenomenon is reproducable although I recompiled > the C program to ensure that the newest mysql libs are included, recompiling > the whole mysql port (after I recompiled FreeBSD AND did mergemaster AND restarted > FreeBSD first). I ensured that all paths are correct and search the right way, > especially for the libraries. > But after a reboot I can be sure that the next inserts into the table has the value > 'NaN' and reading from this table serves always 'NaN' although before the reboot data > has been inserted the correct way. > I saw the 'NaN' value many times in FreeBSD 4.4, especially when getting ports and > at the end of the ftp transfer the net statistic is printed, the transmitted byte > amount often shows 'NaN'. This does not occur in FreeBSD 4.3. Can you provide the table definition (preferably the 'create table' statement as displayed by 'SHOW CREATE TABLE tblname') and the exact query with which your program is trying to insert data into the table? G'luck, Peter -- I am the meaning of this sentence. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-ports" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20010920120937.C4915>