From owner-freebsd-alpha@FreeBSD.ORG  Fri Jan  9 16:52:51 2004
Return-Path: <owner-freebsd-alpha@FreeBSD.ORG>
Delivered-To: freebsd-alpha@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 5529716A4CE
	for <freebsd-alpha@freebsd.org>; Fri,  9 Jan 2004 16:52:51 -0800 (PST)
Received: from smta06.mail.ozemail.net (smta06.mail.ozemail.net
	[203.103.165.100])
	by mx1.FreeBSD.org (Postfix) with ESMTP id E9D3043D1D
	for <freebsd-alpha@freebsd.org>;
	Fri,  9 Jan 2004 16:52:48 -0800 (PST)
	(envelope-from robbyrnes@ozemail.com.au)
Received: from cartman ([203.61.129.215]) by smta06.mail.ozemail.net
          with SMTP
          id <20040110005042.VOSE5468.smta06.mail.ozemail.net@cartman>;
          Sat, 10 Jan 2004 00:50:42 +0000
From: Rob <robbyrnes@ozemail.com.au>
To: <holm@freibergnet.de>, <freebsd-alpha@freebsd.org>
X-Mailer: PocoMail 3.03 (1740) - Licensed Version
Date: Sat, 10 Jan 2004 11:52:03 +1100
Message-ID: <200411011523.232363@cartman>
In-Reply-To: <20040109121513.GA57018@pegasus.freiberg-net.de>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: Re: Mysql?
X-BeenThere: freebsd-alpha@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Porting FreeBSD to the Alpha <freebsd-alpha.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-alpha>,
	<mailto:freebsd-alpha-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-alpha>
List-Post: <mailto:freebsd-alpha@freebsd.org>
List-Help: <mailto:freebsd-alpha-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-alpha>,
	<mailto:freebsd-alpha-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sat, 10 Jan 2004 00:52:51 -0000

On Fri, 9 Jan 2004 13:15:13 +0100, Holm Tiffe wrote:
> Hi,
>
>
> has anyone got mysql to work properly on alpha?
>
>
> I've tried mysql-4.0.16 from the ports, 4.0.17, 4.1xx and I've got
> alsways the same error if I try to connect to the mysqld over tcp:
>
> # /usr/local/bin/mysqladmin -u root -h install password 'lolo'
> /usr/local/bin/mysqladmin: connect to server at 'install' failed
> error: 'Lost connection to MySQL server during query'
>
>
> the mysqld logs in this moment:
>
>
> pid 65409 (mysqld): unaligned access: va=3D0x11fff70c pc=3D0x160389bd4
> ra=3D0x160389bc0 op=3Dstq
>
>
> ll is fine if I connect the daemon over the unix domain socket:
>
>
> # /usr/local/bin/mysqladmin -u root -p password 'lolo' Enter
> password: (xxxx) #
>
> I do'nt think, that this is a FreeBSD issue, it looks like a mysql
> bug on 64bit Machines....
>
> BTW: PostgreSQL works as expected, but I need mysql.

I don't get any unaligned accesses on my Miata, are you building mysql with=
 
any fancy optimisations?

loop@erwin ~ % /usr/local/bin/mysqladmin -u root -h localhost -p 'status'
Enter password:
Uptime: 927362  Threads: 1  Questions: 40716  Slow queries: 0  Opens: 107  
Flush tables: 1  Open tables: 49  Queries per second avg: 0.044

loop@erwin ~ % pkg_info | grep mysql
mysql-client-4.0.17 Multithreaded SQL database (client)
mysql-server-4.0.17 Multithreaded SQL database (server)

cheers,
Rob