User Tools

Site Tools



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/02 02:20]
k2patel old revision restored (2016/05/18 18:26)
daily_issues [2018/08/19 05:15]
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
daily_issues.txt ยท Last modified: 2018/08/19 05:15 by k2patel