Skip to content

uploading rpm with large metadata fails with mysql/mariadb database #35042

Open
@alexth4ef9

Description

@alexth4ef9

Description

same bug as #29110

log:

2025/07/10 17:22:29 .../packages/packages.go:312:addFileToPackageVersionUnchecked() [I] [SQL] INSERT INTO package_property (ref_type,ref_id,name,value) VALUES (?,?,?,?) [1 4535 rpm.metadata {"architecture":"x86_64","epoch":"0","version":"6.15.4","release":"200.fc42","vendor":"Fedora Project","group":"Unspecified","packager":"Fedora

... 1.7MB json ...

Linux v6.14.0-0.rc0.95ec54a420b8"}]}] - 36.435431ms
2025/07/10 17:22:29 .../packages/packages.go:313:addFileToPackageVersionUnchecked() [E] Error setting package file property: Error 1406 (22001): Data too long for column 'value' at row 1
2025/07/10 17:22:29 .../api/packages/rpm/rpm.go:172:UploadPackageFile() [I] [SQL] ROLLBACK [] - 2.011846ms
2025/07/10 17:22:29 .../api/packages/rpm/rpm.go:29:apiError() [E] Error 1406 (22001): Data too long for column 'value' at row 1
2025/07/10 17:22:29 HTTPRequest [I] router: completed PUT /api/packages/shardborn/rpm/fedora/f42/upload?sign=true for 10.89.0.6:0, 500 Internal Server Error in 413.7ms @ packages/api.go:553(packages.CommonRoutes.func1.(*Router).Group.CommonRoutes.func1.18.65)

according to https://github.com/go-gitea/gitea/blob/main/models/packages/package_property.go#L35 value column is of type TEXT (64kB on MySQL/MariaDB, unlimited on PostgreSQL)

this is similar to #16656

rpm to reproduce fedora 42 kernel-core (dnf download kernel-core)

no problem to upload it on demo.gitea.com (other database)

Gitea Version

1.24.2

Can you reproduce the bug on the Gitea demo site?

No

Log Gist

No response

Screenshots

No response

Git Version

No response

Operating System

rootless podman container on fedora coreos 42

How are you running Gitea?

running gitea/gitea:latest-rootless

Database

MySQL/MariaDB

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions