Can't start MySQL

[wildmanmatt]

I'm having rather a problem with MySQL... I don't seem able to get it to start and I'm not sure why.

This is what is in my log:

100206 19:20:06 InnoDB: Starting shutdown...
100206 19:20:07 InnoDB: Shutdown completed; log sequence number 0 2322854460
100206 19:20:07 [Note]
100206 19:20:07 mysqld_safe mysqld from pid file /usr/local/mysql/data/serv1.pid ended
100206 19:20:11 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
100206 19:20:11 [Warning] The syntax '--log' is deprecated and will be removed in MySQL 7.0. Please use '--general_log'/'--general_log_file' instead.
100206 19:20:11 [ERROR] Can't find messagefile '/usr/share/mysql/english/errmsg.sys'
100206 19:20:11 [Note] Plugin 'FEDERATED' is disabled.
100206 19:20:11 InnoDB: Started; log sequence number 0 2322854460
100206 19:20:11 [ERROR] Aborting

100206 19:20:11 InnoDB: Starting shutdown...
100206 19:20:12 InnoDB: Shutdown completed; log sequence number 0 2322854460
100206 19:20:12 [Note]
100206 19:20:12 mysqld_safe mysqld from pid file /usr/local/mysql/data/serv1.pid ended


It just won't stay started :/

I changed a line in /etc/init.d/mysqld to
/usr/local/mysql/bin/mysqld_safe --user=mysql --datadir=${DB_DIR} --language=./share/english/. --pid-file=${PIDFILE} > /dev/null &

to try and show it where errmsg.sys is, but the log now shows:

Version: '5.1.42-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
100206 19:36:32 mysqld_safe Number of processes running now: 0
100206 19:36:32 mysqld_safe mysqld restarted
100206 19:36:32 [Warning] The syntax '--log' is deprecated and will be removed in MySQL 7.0. Please use '--general_log'/'--general_log_file' instead.
100206 19:36:32 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
100206 19:36:32 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
100206 19:36:32 InnoDB: Started; log sequence number 0 2322871212
100206 19:36:32 [Note] Event Scheduler: Loaded 0 events
100206 19:36:32 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.1.42-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
100206 19:37:01 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
100206 19:37:01 [Warning] The syntax '--log' is deprecated and will be removed in MySQL 7.0. Please use '--general_log'/'--general_log_file' instead.
100206 19:37:01 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
100206 19:37:01 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
100206 19:37:01 InnoDB: Started; log sequence number 0 2322872115
100206 19:37:01 [Note] Event Scheduler: Loaded 0 events
100206 19:37:01 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.1.42-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
100206 19:37:07 mysqld_safe A mysqld process already exists
100206 19:37:44 mysqld_safe A mysqld process already exists
100206 19:37:55 [ERROR] /usr/local/mysql/bin/mysqld: Table './wwimages_g2_birds/g2_SequenceEventLog' is marked as crashed and should be repaired
100206 19:37:55 [Warning] Checking table: './wwimages_g2_birds/g2_SequenceEventLog'


I really don't know what's wrong Please could someone help?

Thanks,

Matt

 

[wildmanmatt]

I have now tried using custombuild to ./build all d and the errors are slightly different...

I now get ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
when trying to use mysql

and when trying to start mysql I get this:

serv1:/var/log/mysql# /etc/init.d/mysqld start
Starting mysqld: [ OK ]
serv1:/var/log/mysql# nohup: redirecting stderr to stdout

The error log shows this:


100206 20:42:01 mysqld started
100206 20:42:01 [ERROR] Can't find messagefile '/usr/local/mysql-5.0.89-linux-i686/share/english/errmsg.sys'
100206 20:42:01 [ERROR] Aborting

100206 20:42:01 mysqld ended

100206 20:42:11 mysqld started
100206 20:42:11 [ERROR] Can't find messagefile '/usr/local/mysql-5.0.89-linux-i686/share/english/errmsg.sys'
100206 20:42:11 [ERROR] Aborting

100206 20:42:11 mysqld ended

100206 20:42:20 mysqld started
100206 20:42:20 [ERROR] Can't find messagefile '/usr/local/mysql-5.0.89-linux-i686/share/english/errmsg.sys'
100206 20:42:20 [ERROR] Aborting

100206 20:42:20 mysqld ended

 

[wildmanmatt]

Ok...I seem to have resolved my problems...
I removed all of the my.cnf files I could find and then removed all mysql source directories from /usr/local (leaving just /usr/local/mysql/)

Then I went to /usr/local/custombuild and edited options.conf to set the mysql version to 5.1 and did ./build update ./build clean and ./build all d

And now things seem to be working...

But I'm not sure why this fixed everything.

 

[neojick]

Hi wildmanmatt, all is good now for you ?