How to solve InnoDB: Unable to lock ./ibdata1 mysql error?
Wojtek Dmyszewicz
2016-03-14 02:30:29 58150 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35 2016-03-14 02:30:29 58150 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
Wojtek Dmyszewicz
First, list MySQL processes using the ps command:
ps aux | grep mysql
And then kill the process
sudo kill 56311
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: gcc suppress warning "too small to hold all values of"
- Next: NUnit 3: Forbid tests to run in parallel
Related
Related Related
- 1
EC2 instance Linux, MYSQL log error:InnoDB: Unable to lock ./ibdata1, error: 11
- 2
InnoDB: Unable to lock ./ibdata1 error: 35
- 3
How to restore innodb tables without ibdata1 and *.ibd files
- 4
How to solve MySQL innodb "Waiting for table metadata lock" on TRUNCATE TABLE?
- 5
How to shrink/purge ibdata1 file in MySQL
- 6
InnoDB: Error: space header page consists of zero bytes in data file ./ibdata1
- 7
InnoDB's data file(ibdata1, *.ibd) HEXA edit
- 8
mysqlbackup: ERROR: Opening of file /var/lib/mysql/ibdata1 failed. Error code: 13, Permission denied
- 9
How to prevent MySQL InnoDB setting a lock for delete statement through JDBC
- 10
How to prevent MySQL InnoDB setting a lock for delete statement through JDBC
- 11
How to put a long-term lock on a row in a MySQL InnoDB Table?
- 12
MySQL InnoDB insert and select lock
- 13
MySQL InnoDb: How solve speed issue with different order by columns needed
- 14
MySQL InnoDb: How solve speed issue with different order by columns needed
- 15
MySQL: restoring 1 InnoDB table with common ibdata file
- 16
InnoDB Error on MySQL Startup
- 17
XAMPP MySQL InnoDB error
- 18
Mysql lock read a single row for innodb
- 19
Unable to solve this Error
- 20
MySQL innodb “The Table is Full” error
- 21
MySQL fulltext searches in InnoDB error
- 22
How to solve MySql "Cannot execute this command" error?
- 23
How can i solve this type of mysql error
- 24
How to solve "Unable to load theme by specified key: 'rwd\/astra'","1":"#0 error in magento2?
- 25
What does the MySQL 5.6 error "InnoDB presently supports one FULLTEXT index creation at a time. Try LOCK=SHARED" mean?
- 26
How to restore data on database when only have the .frm files and ibdata1
- 27
How to solve the 'Unable to find Asm for stackmap generation' error on startup of STS?
- 28
How to configure memcached for mysql innodb?
- 29
How to configure memcached for mysql innodb?
Comments