NotifySyncPushCommits() [E] NotifyWatchers: insert new actioner: Error 1406 (22001): Data too long for column 'content' at row 1

[pboguslawski]

Description

One occurrence of

2023/11/24 02:07:13 ...ion/action/action.go:403:NotifySyncPushCommits() [E] NotifyWatchers: insert new actioner: Error 1406 (22001): Data too long for column 'content' at row 1

was caught in gitea 1.20.3 error log on mirror update.

Gitea Version

1.20.3

Can you reproduce the bug on the Gitea demo site?

No

Log Gist

No response

Screenshots

No response

Git Version

2.30.2

Operating System

Debian

How are you running Gitea?

Compiled from sources.

Database

MySQL/MariaDB

[lng2020]

This field uses TEXT in MySQL which is at most 64kb. You can adjust your MySQL settings.

[wxiaoguang]

You can adjust your MySQL settings.

How to "adjust your MySQL settings"? At least, I do not think "truncate silently" is a choice for modern databases.

[lng2020]

I was wrong. It can't be adjusted.

[wxiaoguang]

I think it should be truncated explicitly on Gitea side, to make sure the message fit the database size.

[pboguslawski]

Another similar message noticed in gitea 1.21.10:

2025/04/15 18:46:59 ...vices/feed/action.go:409:SyncPushCommits() [E] NotifyWatchers: insert new actioner: Error 1406 (22001): Data too long for column 'content' at row 1