Web lists-archives.com

Re: Unable to start mysql after power Failure




On 7/4/2015 2:26 PM, Reindl Harald wrote:

Am 04.07.2015 um 06:24 schrieb Jatin Davey:
We are trying to High Availability solution for our database. We have
our application running on a node-1 and the DB running on the shared
storage which is shared across node-1 & node-2. Whenever there is a
power Failure on node-1 , we start our application on node-2 but our
problem is that now after a failover onto node-2 the DB deamon on node-2
will fail to start.

did you see that lines of your log?

2015-07-03 16:04:03 17753 [Note] InnoDB: Retrying to lock the first data file 2015-07-03 16:04:04 17753 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2015-07-03 16:04:04 17753 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.

Yes , But i dont have any mysqld process running on the node-2 as i have mentioned above and attempting to start mysqld on node-2 is when i face this issue for which the logs are showing the above error message.

Thanks
Jatin

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