Is there a chance anyone met similar symptoms?
We have standalone server (5.7.29) running for some time (weeks,months) smoothly. From time to time very innocent query ( UPDATE table_name SET col1 = 1.37, col2 = NOW(), col3 = ‘y’, col4 = ‘y’, col5 = NULL , col6 = NULL , col7 = NULL , col8 = 229767515 , col9 = ‘481x1x0x152.50’ WHERE id = 364416672 ) is still “running”, stalling whole server. Even backup process running 10 000 seconds after this query was not succeeded (stucked on flush tables with read lock → I’m expecting consequence of still running query).
There is no related deadlock(show engine innodb status), performance_schema.metadata_locks is empty, 98 records in performance_schema.table_handles having both internal and external locks column NULL for all records.
Any ideas are highly appreciated! Any trace I missed and I’m supposed to follow, anything… Thanks!