Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

Error on ibdata1...

deadmanalivedeadmanalive ContributorCurrent User Role Beginner
Hello experts,
I found sudden error in error logs. Please let me know how to resolve it.


InnoDB: Unable to lock ./ibdata1, error: 11
[Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.

Comments

  • mirfanmirfan Database Administrator Inactive User Role Beginner
    Hi,

    It look likes you are running two mysql instances on same port. Check with

    $ ps -aux | grep -v grep | grep mysql

    Kill the processes and start mysqld again.
  • deadmanalivedeadmanalive Contributor Current User Role Beginner
    Hi Mirfan,
    I check the process but there is only one process is running . I had checked logs & found couple of time same error occur. During that time mysql is running fine & only single process was running.

    Is there any other way to debug ?


    During process monitoring i found a single user was connected multiple time and chocking the connection cause max_connection reached error & doing nothing. Command were in Sleep state & info were NULL.(this may not be db issue). Why this situation error ?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.