Error 1815 Occurred on TiFlash Node When Upgrading from 7.0 to 7.4

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 从7.0升级到7.4 tiflash接点出现 1815的错误

| username: Running

Encountered error 1815 on TiFlash nodes after upgrading from 7.0 to 7.4.

| username: Fly-bird | Original post link

First, analyze this table: ANALYZE TABLE table_name;

| username: Billmay表妹 | Original post link

More information is needed for analysis~

| username: jaybing926 | Original post link

Were there any errors during the upgrade process, and is the cluster status normal now?

| username: db_user | Original post link

Check the TiFlash replica status of this table. Is it normal? If it is not normal and the table is not large, you can try setting the replica to 0 first and then setting the replica to 1.

| username: zhanggame1 | Original post link

Stopped tilash to try

| username: Kongdom | Original post link

Are you paying attention to 2 and 3?

| username: Running | Original post link

How is the tiflash replica status of the table? Is it normal? If it is not normal and the table is not large, you can try setting the replica to 0 first and then setting it again. There is no DDL in the process.

| username: Running | Original post link

Abnormal

| username: Running | Original post link

What other information is needed? The replica status is all normal.

| username: Billmay表妹 | Original post link

Did you encounter any errors during the upgrade process?

Were all components successfully upgraded?

How is the machine configuration?

| username: jaybing926 | Original post link

What client are you using? Is it possible that the client is not compatible?
Can you try using the command line with mysql -huser?

| username: Running | Original post link

The upgrade process did not report any errors, and the final status of the upgrade was successful. The configuration includes 4 machines with approximately 12 cores, 24GB of RAM, and 1TB SSD.

| username: Billmay表妹 | Original post link

How many TiKV and how many TiFlash?

| username: tidb菜鸟一只 | Original post link

tiup cluster display clustername to check

| username: Billmay表妹 | Original post link

I suspect that the issue is caused by the version not being fully upgraded.