Hi,

I tried to install mysql on PowerPC-LynxOS machine, and got into the
following issues. If some body can help me resolve this, it would be of
great help.

First I like to list the changes I did to compile mysql for PowerPC-LynxOS
using cross compilers in sparc-sunos.

Configure script changes
-------------------------
1) Changed ps options in lines which find out whether a particular process
is running or not. In LynxOS it is ps -ax. In LynxOS scripts are shown as
bash process, hence ps -ax | grep process_name will not fetch one for
configure since it's process name is marked as bash.

2) In LynxOS for obtaining thread related functions you have to
use -mthreads options, there is no thread library.  Hence added check
for -mthreads in configure script when checking for thread related features.

3) I was using cross compiler environment, configure script was trying to
execute some binary produced for the host platform which failed, so I
started with config outputs generated for a similar environment(LynxOS/x86)
and tweaked it for the host.

Makefile/Code changes
---------------------
1) I was using cross compiler environment, hence gen_lex_hash and
conf_to_src compiled for the host platform didn't ran on the build
environment, so I have generate these binary for build environment and
modify Makefile to use them.

Also removed -O3 flag in sql/Makefile since it was reporting undefined
symbols with that option, In the following link,
http://gcc.gnu.org/ml/gcc-prs/2002-11/msg01111.html
they have adviced to remove that option for compiling it

2) vi_mode.c - Added the following
#  include <my_global.h>

3) my_pthread.h - LynxOS was offering a nonposix version of sigwait, so I
had to modify the my_sigwait macro def in
my_pthread.h to the below
....
#ifndef HAVE_NONPOSIX_SIGWAIT
#define my_sigwait(A,B) *B = sigwait((A),NULL)
#else
....

4)system include file : sem.h
Commented out mutex_exit macro in sem.h since it collides with mutex_exit
function of innobase

Some info about compilation :

Release:       mysql-4.0.15a (Source distribution)
C compiler:    2.95.3
C++ compiler:  2.95.3
Environment:
        <machine, os, target, libraries (multiple lines)>
System: LynxOS Decimus  0.7.0.0 PowerPC

GCC: Using builtin specs.
gcc version 2.9-gnupro-98r2
Compilation info: CC='gcc'  CFLAGS=''  CXX='g++'  CXXFLAGS=''  LDFLAGS=''
ASFLAGS=''
LIBC:
Configure command: ./configure '--prefix=/users/spraja/usr/local/mysql'
'--host=powerpc-unknown-lynxos'

Then things went fine, and I got the mysql bins. When I run it on
powerpc-lynxos,
faced the following issues/problems. This is where I require help

===============================================================
Decimus:/users/spraja/usr/local/mysql# bin/mysqladmin version
bin/mysqladmin: connect to server at 'localhost' failed
error: 'Lost connection to MySQL server during query'
==============================================================

So I tried telnet connection to 3306 port

==============================================================
Decimus:/users/spraja/usr/local/mysql# telnet Decimus 3306
Trying 172.16.254.93 ...
Connected to Decimus.
Escape character is '^]'.
(
4.0.15a\KBH$xQn  <-- I pressed enter key
                 <-- I pressed enter key pressed

Bad handshakeConnection closed by foreign host.
==============================================================

Log files content at time where

==============================================================
Log files (hostname.err)
031015 06:28:27  mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
031015  6:28:28  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
031015  6:28:29  InnoDB: Log file ./ib_logfile0 did not exist: new to be
created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
031015  6:28:30  InnoDB: Log file ./ib_logfile1 did not exist: new to be
created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
031015  6:28:33  InnoDB: Started
/users/spraja/usr/local/mysql/libexec/mysqld: ready for connections.
Version: '4.0.15a'  socket: '/tmp/mysql.sock'  port: 3306

031015  6:29:16  Error on new connection socket: Socket operation on
non-socket
031015  6:29:26  Error on new connection socket: Socket operation on
non-socket
031015  6:31:39  Error on new connection socket: Socket operation on
non-socket
031015  6:32:08  Error on new connection socket: Socket operation on
non-socket

mysqld got signal 6;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose
the problem, but since we have already crashed, something is definitely
wrong
and this may fail.

key_buffer_size=16384
read_buffer_size=131072
max_used_connections=0
max_connections=100
threads_connected=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections =
19215 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

free: pid[91] : Double free of 0x215b8e68 allocated at
0x10374c44:0x10374a90:0x10378d98
==============================================================

I tried stopping the server, but in vain

==============================================================
Decimus:/users/spraja/usr/local/mysql# ./share/mysql/mysql.server stop
Killing mysqld with pid 108
Wait for mysqld to exit\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
 gave up waiting!
==============================================================

Thanks in advance,
Regards,
Sp.Raja




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to