User Tools

Site Tools


daily_issues

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
daily_issues [2017/07/01 22:20]
k2patel old revision restored (2016/05/18 18:26)
daily_issues [2018/08/19 01:15] (current)
k2patel [InnoDB: Unable to lock ./ibdata1, error: 11]
Line 189: Line 189:
  
 restart mysql and check again it should represent new value. restart mysql and check again it should represent new value.
 +
 +==== InnoDB: Unable to lock ./ibdata1, error: 11 ====
 +
 +I've stumble across this issue while running mariadb server in VM Guest.\\
 +I believe this happens sometime when VDP is doing backup or machine is being migrated by DRS.
 +
 +In my case, i've enable innodb per tables. So i've to clear lock from all files in subfolder.\\
 +In order to fix the issue, following command usually fix the issue.
 +<code bash>
 +systemctl stop mariadb
 +cd /​var/​lib/​mysql
 +for i in `find . -name '​*.ibd'​`;​ do mv $i $i.bk; cp -a $i.bk $i ; rm $i.bk ; done
 +systemctl start mariadb
 +</​code>​
daily_issues.1498962059.txt.gz ยท Last modified: 2017/07/01 22:20 by k2patel