Not the answer you need?
Register and ask your own question!

System Lock not allowing Data to be inserted into the database

jaquilinajaquilina EntrantCurrent User Role Beginner
I have someone whose trying to insert data through some mobile software and they keep getting an error. Upon further investigation through mysql workbench. I have found the following:

A connection with the info displaying INTERNAL DDL LOG RECOVER IN PROGRESS and the state being a system lock.

After querying the performance schema database I found there are 4 locks. 3 wait/synch/rwlock/myisam/MYISAM_SHARE::key_root_lock and one ::mmap_lock. Each then has a unique object instance begin numerical value. write lcked by thread id are all null for all of those and read locked by count are all 0.

'wait/synch/rwlock/myisam/MYISAM_SHARE::key_root_lock', '111175228706368', NULL, '0'
'wait/synch/rwlock/myisam/MYISAM_SHARE::key_root_lock', '111175228706432', NULL, '0'
'wait/synch/rwlock/myisam/MYISAM_SHARE::key_root_lock', '111175228706496', NULL, '0'
'wait/synch/rwlock/myisam/MYISAM_SHARE::mmap_lock', '111175228705272', NULL, '0'

It seems like in the performance schema rwlock_instances table there are no locks listed now. This is after i restarted the server. Yet on the main thread I am still seing the system lock that INTERAL DDL LOG RECOVER IN PROGRESS.

What do I need to do to solve this issue and remove the system lock?
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.