Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

When a binlog message too large error occurs, tidb-server exits abnormally. #28659

Closed
jackysp opened this issue Oct 8, 2021 · 5 comments · Fixed by #46365
Closed

When a binlog message too large error occurs, tidb-server exits abnormally. #28659

jackysp opened this issue Oct 8, 2021 · 5 comments · Fixed by #46365
Assignees
Labels
affects-5.0 This bug affects 5.0.x versions. affects-5.1 This bug affects 5.1.x versions. affects-5.2 This bug affects 5.2.x versions. affects-5.3 This bug affects 5.3.x versions. affects-5.4 This bug affects the 5.4.x(LTS) versions. affects-6.0 affects-6.1 This bug affects the 6.1.x(LTS) versions. affects-6.5 This bug affects the 6.5.x(LTS) versions. affects-7.1 This bug affects the 7.1.x(LTS) versions. component/binlog severity/major type/bug The issue is confirmed as a bug.

Comments

@jackysp
Copy link
Member

jackysp commented Oct 8, 2021

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

Create a very large transaction of over 2G.

2. What did you expect to see? (Required)

Execution failure.

3. What did you see instead (Required)

tidb-server exited.

[2021/09/27 17:17:44.432 +08:00] [WARN] [session.go:1533] ["run statement failed"] [conn=341] [schemaVersion=12389] [error="[global:3]critical error rpc error: code = ResourceExhausted desc = trying to send message larger than max (4097419655 vs. 2147483647)"] [session="{\n  \"currDBName\": \"polcent_db\",\n  \"id\": 341,\n  \"status\": 2,\n  \"strictMode\": true,\n  \"user\": {\n    \"Username\": \"tiuser1\",\n    \"Hostname\": \"10.79.166.195\",\n    \"CurrentUser\": false,\n    \"AuthUsername\": \"tiuser1\",\n    \"AuthHostname\": \"%\"\n  }\n}"]
[2021/09/27 17:17:44.432 +08:00] [FATAL] [conn.go:871] ["critical error, stop the server"] [conn=341] [error="[global:3]critical error rpc error: code = ResourceExhausted desc = trying to send message larger than max (4097419655 vs. 2147483647)"] [stack="github.com/pingcap/tidb/server.(*clientConn).Run\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/conn.go:871\ngit.luolix.top/pingcap/tidb/server.(*Server).onConn\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/server.go:485"]

4. What is your TiDB version? (Required)

c16092e

@jackysp jackysp added the type/bug The issue is confirmed as a bug. label Oct 8, 2021
@jackysp
Copy link
Member Author

jackysp commented Oct 8, 2021

In

if strings.Contains(err.Error(), "received message larger than max") {
, it tries to catch "received message larger than max", but we got "trying to send message larger than max"

image

PTAL @coocood

@coocood
Copy link
Member

coocood commented Oct 8, 2021

In

if strings.Contains(err.Error(), "received message larger than max") {

, it tries to catch "received message larger than max", but we got "trying to send message larger than max"
image

PTAL @coocood

So we can change it to message larger than max

@lichunzhu
Copy link
Contributor

Should be fixed by pingcap/tidb-binlog#1039

@jebter jebter added affects-5.0 This bug affects 5.0.x versions. affects-5.1 This bug affects 5.1.x versions. affects-5.2 This bug affects 5.2.x versions. affects-5.3 This bug affects 5.3.x versions. labels Jan 11, 2022
@lichunzhu
Copy link
Contributor

close this now because pingcap/tidb-binlog#1039 is already fixed. Feel free to reopen this if a further problem is found.

@jackysp
Copy link
Member Author

jackysp commented Aug 23, 2023

The bug is still here, it happened in v6.5.3. PTAL @lichunzhu

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-5.0 This bug affects 5.0.x versions. affects-5.1 This bug affects 5.1.x versions. affects-5.2 This bug affects 5.2.x versions. affects-5.3 This bug affects 5.3.x versions. affects-5.4 This bug affects the 5.4.x(LTS) versions. affects-6.0 affects-6.1 This bug affects the 6.1.x(LTS) versions. affects-6.5 This bug affects the 6.5.x(LTS) versions. affects-7.1 This bug affects the 7.1.x(LTS) versions. component/binlog severity/major type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

6 participants