entry too large, the max entry size is 6291456, the size of data is 7254170 #

查看 performance.txn-entry-size-limit 大小：

show config where type='tidb' and name like '%txn-entry-size-limit';

++++++++++++++++++++++++++--++++++++++++++++++++++++++++++++++-+++++++++++
| Type | Instance           | Name                             | Value   |
++++++++++++++++++++++++++--++++++++++++++++++++++++++++++++++-+++++++++++
| tidb | 192.168.70.46:4000 | performance.txn-entry-size-limit | 6291456 |
++++++++++++++++++++++++++--++++++++++++++++++++++++++++++++++-+++++++++++
1 row in set (0.01 sec)

修改 performance.txn-entry-size-limit 大小：

tiup cluster edit-config <cluster-name>

server_configs:
  tidb:
    txn-entry-size-limit: 62914560

重载 tidb 配置：

tiup cluster reload <cluster-name> -R tidb

检查修改是否生效：

show config where type='tidb' and name like '%txn-entry-size-limit';

raft entry is too large, region 157021, entry size 10309778 #

查看 raft-entry-max-size 大小:

show config where type='tikv' and name like '%entry-max-size';

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++-+++++++-+
| Type | Instance            | Name                          | Value |
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++-+++++++-+
| tikv | 192.168.xx.xx:xxxxx | raftstore.raft-entry-max-size | 8MiB  |
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++-+++++++-+

修改 raft-entry-max-size 大小:

tiup cluster edit-config <cluster-name>

server_configs:
  tikv:
    raftstore.raft-entry-max-size: 20MB

重载 tikv 配置:

tiup cluster reload <cluster-name> -R tikv

检查修改是否生效：

show config where type='tikv' and name like '%entry-max-size';

Referencing column ’table’ and referenced column ‘id’ in foreign key constraint ‘fk_1’ are incompatible #

外键约束错误

查找引用 table 的表

SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_NAME = 'table';

删除引用 table 的表，先导入 table，再导入引用 table 的表。