From owner-freebsd-sparc Fri Mar 7 4:13:32 2003 Delivered-To: freebsd-sparc@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 85E8237B401 for ; Fri, 7 Mar 2003 04:13:31 -0800 (PST) Received: from gadolinium.btinternet.com (gadolinium.btinternet.com [194.73.73.111]) by mx1.FreeBSD.org (Postfix) with ESMTP id 98CA343F75 for ; Fri, 7 Mar 2003 04:13:30 -0800 (PST) (envelope-from nick@freebsd.cx) Received: from host81-132-34-188.in-addr.btopenworld.com ([81.132.34.188] helo=cordelia.tachief.com) by gadolinium.btinternet.com with smtp (Exim 3.22 #23) id 18rGjA-00049b-00 for freebsd-sparc@freebsd.org; Fri, 07 Mar 2003 12:13:28 +0000 Received: (qmail 6752 invoked from network); 7 Mar 2003 12:02:46 -0000 Received: from localhost (HELO cordelia.tachief.com) (127.0.0.1) by 0 with SMTP; 7 Mar 2003 12:02:46 -0000 Received: (from nick@localhost) by cordelia.tachief.com (8.12.7/8.12.7/Submit) id h27C2iH0014813 for freebsd-sparc@freebsd.org; Fri, 7 Mar 2003 12:02:45 GMT X-Authentication-Warning: cordelia.tachief.com: nick set sender to nick@freebsd.cx using -f Date: Fri, 7 Mar 2003 12:02:44 +0000 From: Nick Jones To: freebsd-sparc@freebsd.org Subject: Strange MySQL Behaviour Message-ID: <20030307120244.GA31139@cordelia.tachief.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.99i X-Operating-System: OpenBSD/3.2 (i386) X-Uptime: 11:40AM up 1:55, 2 users, load averages: 0.32, 0.48, 0.52 Sender: owner-freebsd-sparc@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.org I'm having a particularly strange issue with MySQL running on an Ultra5 with a recent build of -CURRENT (uname -a is: FreeBSD amber.tachief.com 5.0-CURRENT FreeBSD 5.0-CURRENT #1: Sun Mar 2 01:32:07 GMT 2003 nick@amber.tachief.com:/usr/obj/usr/src/sys/AMBER sparc64). I can INSERT data into a table fine, but when I perform a SELECT query on the same table no results are returned. However, if I try the same INSERT statement again with a duplicate primary key, it acknowledges the dupe and the INSERT fails. Again, a subsequent SELECT returns no data. I'm using MySQL 4.0.10 compiled and installed from ports with no special options or configuration directives. A snapshot of the same database running under the same version of MySQL but under -STABLE on x86 works fine. Any clues? -- /Nick To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-sparc" in the body of the message