Mysql?

Rob robbyrnes at ozemail.com.au
Fri Jan 9 16:52:51 PST 2004


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=0x11fff70c pc=0x160389bd4
> ra=0x160389bc0 op=stq
>
>
> 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 at 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 at 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



More information about the freebsd-alpha mailing list