When the delete sql exceeds 256MB, the 4000th port of tidb node stops.

[httpcheck]

As the title says,when the delete sql exceeds 256MB, the 4000th port of tidb node stops.
What I want to know is how to write the sql when I want to delete the information of the large table.

[jackysp]

Thanks for your report, @bianxindong !
Do you mean the size of the SQL file is larger than 256MB?
Please provide the TiDB server's log and TiDB version.

[httpcheck]

Thanks for your report, @bianxindong !
Do you mean the size of the SQL file is larger than 256MB?
Please provide the TiDB server's log and TiDB version.

tidb version :
Release Version: v2.0.1
Git Commit Hash: 389703a
Git Commit Branch: release-2.0
UTC Build Time: 2018-05-16 03:39:30
GoVersion: go version go1.10.2 linux/amd64
TiKV Min Version: 2.0.0-rc.4.1

When rd exec the delete sql,our alarm system called me the result. All 4000th ports of tidb nodes were down.I had to exec the script of stop_tidb.sh and start_tidb.sh,and then those service were back to normal.

[jackysp]

It seems a fixed issue. Could you please update to the latest version v2.0.7?
I'll ask an expert for help.
PTAL @WangXiangUSTC .

[WangXiangUSTC]

seems fixed in this pr #7086
you can update to v2.0.7 and try again. @bianxindong

[httpcheck]

When our service is back to normal, I exec the sql that's added condition. It looks ok.
So the limitation of memory is 256MB, Did what I operated cause out of memory ?

[zhexuany]

@bianxindong It is a fixed problem. You did not do anything wrong. Rather, it is a problem on our side. Closing since the problem had been resolved.