This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
daily_issues [2016/05/18 18:26] k2patel [Mysql Generate hash for password] |
daily_issues [2018/08/19 05:13] k2patel |
||
---|---|---|---|
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 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> |