LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 05-30-2014, 05:15 AM   #1
byran cheung
Member
 
Registered: Sep 2013
Posts: 321

Rep: Reputation: Disabled
startup mysql error


What I startup the mysql , it pop the below error ,

[code]
140530 17:11:47 mysqld_safe Starting mysqld daemon with databases from /data/mysqld/edp
140530 17:11:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
140530 17:11:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
140530 17:11:47 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140530 17:11:47 InnoDB: Initializing buffer pool, size = 8.0M
140530 17:11:47 InnoDB: Completed initialization of buffer pool
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
140530 17:11:47 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...
InnoDB: Page directory corruption: infimum not pointed to
140530 17:11:47 InnoDB: Page dump in ascii and hex (16384 bytes):
[code/]

From another log , there is the below error .

[code]
cat: /log/mysqld/w2/run/mysqld.pid: No such file or directory
New PID:
ERROR: List of process IDs must follow -p.
[code\]

Then I tried the command mysql_upgrade -u root -p --force , it seems normal to do upgrade , however , the error persist , would advise how can I fix the error ? thanks

Last edited by byran cheung; 05-30-2014 at 05:19 AM.
 
Old 05-30-2014, 07:50 AM   #2
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.10, Centos 7.5
Posts: 17,697

Rep: Reputation: 2494Reputation: 2494Reputation: 2494Reputation: 2494Reputation: 2494Reputation: 2494Reputation: 2494Reputation: 2494Reputation: 2494Reputation: 2494Reputation: 2494
These seem to be the key lines
Code:
 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
If it failed to recover, you'd better hope you have no important data there, or that you do have a backup.
You'll need to re-install the SW and you might(!) be able to recover the DB data ... maybe.
 
Old 06-03-2014, 11:13 PM   #3
byran cheung
Member
 
Registered: Sep 2013
Posts: 321

Original Poster
Rep: Reputation: Disabled
Hi ,

Thanks reply , I tried stop and start the db , it is normal , besides , I checked the plugin tables is exist in the mysql db , would advise what is the possible reason of the error ? thanks
 
Old 06-04-2014, 07:25 AM   #4
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.10, Centos 7.5
Posts: 17,697

Rep: Reputation: 2494Reputation: 2494Reputation: 2494Reputation: 2494Reputation: 2494Reputation: 2494Reputation: 2494Reputation: 2494Reputation: 2494Reputation: 2494Reputation: 2494
Pretty difficult to tell, but these 2 lines try
Code:
140530 17:11:47 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
Looks like someone pulled the plug ...
 
Old 06-09-2014, 06:06 AM   #5
byran cheung
Member
 
Registered: Sep 2013
Posts: 321

Original Poster
Rep: Reputation: Disabled
thanks reply ,

I tried the command mysql_upgrade , but got the following error , would advise what is wrong ? thanks

#mysql_upgrade -u root -p
Enter password:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed
 
Old 06-09-2014, 08:08 AM   #6
thangict93
LQ Newbie
 
Registered: Jun 2014
Posts: 3

Rep: Reputation: Disabled
you can share file config in /etc/my.cnf direction.
I will help you.

Last edited by thangict93; 06-09-2014 at 08:09 AM.
 
Old 06-10-2014, 09:44 PM   #7
byran cheung
Member
 
Registered: Sep 2013
Posts: 321

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by thangict93 View Post
you can share file config in /etc/my.cnf direction.
I will help you.
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
 
Old 06-15-2014, 10:19 PM   #8
byran cheung
Member
 
Registered: Sep 2013
Posts: 321

Original Poster
Rep: Reputation: Disabled
Hi thangict93 ,

Would you help for it ? thanks
 
Old 06-17-2014, 09:37 PM   #9
byran cheung
Member
 
Registered: Sep 2013
Posts: 321

Original Poster
Rep: Reputation: Disabled
Is my question not clear enough ? thanks
 
Old 06-18-2014, 06:04 AM   #10
byran cheung
Member
 
Registered: Sep 2013
Posts: 321

Original Poster
Rep: Reputation: Disabled
my full error log is below , would advise how to fix it ? thanks

mysqld_safe Starting mysqld daemon with databases from /data/mysqld/w2
[Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
[Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: Initializing buffer pool, size = 8.0M
InnoDB: Completed initialization of buffer pool
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
140618 17:45:00 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...
InnoDB: Page directory corruption: infimum not pointed to
140618 17:45:00 InnoDB: Page dump in ascii and hex (16384 bytes):
 
Old 06-28-2014, 10:05 AM   #11
thangict93
LQ Newbie
 
Registered: Jun 2014
Posts: 3

Rep: Reputation: Disabled
1. restart PC.
or
2.
#ps -ef | grep my
#kill -9 [PID]
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql startup error when trying to install Vbulletin mw83 Linux - Software 3 09-07-2011 05:27 AM
MySQL startup error Seti Linux - Server 2 12-29-2010 08:24 AM
Mysql startup error on Centos 5.2 custangro Linux - Server 4 09-16-2009 06:23 PM
MySQL startup error goosie Linux - Software 13 11-16-2005 04:30 PM
MySql Thread error on startup Biggen Linux - Software 9 09-30-2004 09:05 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 05:29 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration