[Gllug] MySQl Problem - Please Help

[wendy carr]

Hi,

Thanks for you comments. I have another server wiyh
same mysql configuration , so i suppose making changes
as in the error log is not a solution. I have used
rpms to install mysql and only one version.Also there
is only one instance running, i have cheked with ps
axf and pstree.

is there any test procedure ? 

Thanks again.

cheers

--- Richard Huxton <dev at archonet.com> wrote:
> wendy carr wrote:
> > Hi,
> > 
> > Could you please help me to solve this problem ? I
> am
> > getting totally frustrated. I have a redhat 7.3
> server
> > with around 500 web sites.It runs mysql 3.23 , up
> to a
> > three days everything was ok. The problem is the
> > mysqld server fails about every 10 minutes.I ve
> > checked the /var/log/mysqld which says,
> > 
> > Cannot initialize InnoDB as
> 'innodb_data_file_path' is
> > not set.
> > If you do not want to use transactional InnoDB
> tables,
> > add a line
> > skip-innodb
> > to the [mysqld] section of init parameters in your
> > my.cnf
> 
> Well - that's clear enough.
> 
> > and
> > 
> > 050510  0:45:14  Aborting
> > 
> > 050510  0:45:14  /usr/libexec/mysqld: Shutdown
> > Complete
> > 
> > 050510  0:45:14  Can't start server: Bind on
> TCP/IP
> > port: Address already in use
> > 050510  0:45:14  Do you already have another
> mysqld
> > server running on port: 3306
> >  ?
> > 050510  0:45:14  Aborting
> > 
> > when i check netstat -na iget quite a few socket
> > connections
> > /var/lib/mysql/mysql.sock
> 
> Which implies mysql is still running. What about
> port 3306?
> 
> You don't have two versions installed by any chance
> - one by RPM, one 
> from source? I've seen that cause this sort of
> confusion.
> 
> --
>    Richard Huxton
>    Archonet Ltd
> -- 
> Gllug mailing list  -  Gllug at gllug.org.uk
> http://lists.gllug.org.uk/mailman/listinfo/gllug
> 


		
___________________________________________________________ 
How much free photo storage do you get? Store your holiday 
snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug