This query may assist in your search for locking and blocking ids.
# IS-tx-wait-block-qrys.sql to help research BUSY systems Last Updated 20191227 wh
# if this helps you, please email SHAREABLE comments to firstname.lastname@example.org
# From article at
# 20191227 tested on ...
The error is related to the difference between Innodb definition and the frm file definition.
It probably occurred because of a crash during an ALTER TABLE or similar statement at some point.
To restore the consistency an ALTER TABLE wtb_device_auths FORCE will recreate the table (while exclusively locking it). This recreation should make both the innodb ...
I've experienced the exact same issue before.
Please make the following changes to rectify "Seconds_Behind_Master" increasing once slave has started.
Firstly check the "trx" value on slave server
show variables like '%trx%';
if the value of "innodb_flush_log_at_trx_commit" is "1" as below
Variable_name | Value |
You need to embrace the filepath in quotes. This works for me (tested on MariaDB 10.4, but should work on older versions as well):
CREATE PROCEDURE test(filepath text, _query text)
DECLARE stmt TEXT;
SET stmt := CONCAT(_query, ' into OUTFILE \'' , filepath, '\'');
PREPARE s FROM stmt;
DEALLOCATE PREPARE s;
Issue fixed. I found mysql tables (db & user) columns available in 5.7. So i copy these tables from 8.0 to 5.7. And copy data only for available columns in tables db & user of mysql schema. Now its working fine.