From owner-freebsd-ports Thu Sep 20 2:24:51 2001 Delivered-To: freebsd-ports@freebsd.org Received: from ringworld.nanolink.com (straylight.ringlet.net [217.75.134.254]) by hub.freebsd.org (Postfix) with SMTP id 9B3A637B40F for ; Thu, 20 Sep 2001 02:23:21 -0700 (PDT) Received: (qmail 55293 invoked by uid 1000); 20 Sep 2001 09:09:37 -0000 Date: Thu, 20 Sep 2001 12:09:37 +0300 From: Peter Pentchev To: "Hartmann, O." Cc: freebsd-ports@freebsd.org Subject: Re: MySQL 2.32.42 problems Message-ID: <20010920120937.C4915@ringworld.oblivion.bg> Mail-Followup-To: "Hartmann, O." , freebsd-ports@freebsd.org References: <20010918153746.W2151-100000@klima.physik.uni-mainz.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i 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 +0200 Sender: owner-freebsd-ports@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.org 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