Git tag name too long for DB

[top-psi]

Description

I have a repo that I want to push into Gitea, the project has branches and tags.

➜ H5hut git:(master) git push --mirror
Certificate invalid: expired
Enumerating objects: 11263, done.
Counting objects: 100% (11263/11263), done.
Delta compression using up to 8 threads
Compressing objects: 100% (3010/3010), done.
Writing objects: 100% (11263/11263), 12.55 MiB | 1.96 MiB/s, done.
Total 11263 (delta 8203), reused 11263 (delta 8203), pack-reused 0
remote: Resolving deltas: 100% (8203/8203), done.
remote: ......................................... Processing 41 references
remote: Processed 41 references in total
To gitea-test.psi.ch:bruhn_b/5Huete.git

• [new branch] master -> master
• [new reference] origin/1.0 -> origin/1.0
• [new reference] origin/1.2 -> origin/1.2
• [new reference] origin/1.4 -> origin/1.4
• [new reference] origin/1.6 -> origin/1.6
• [new reference] origin/1.99 -> origin/1.99
• [new reference] origin/1.99.x -> origin/1.99.x
• [new reference] origin/HEAD -> origin/HEAD
• [new reference] origin/int8 -> origin/int8
• [new reference] origin/master -> origin/master
• [new tag] 1.99.0 -> 1.99.0
• [new tag] 1.99.10 -> 1.99.10
• [new tag] 1.99.11 -> 1.99.11
• [new tag] 1.99.12 -> 1.99.12
• [new tag] 1.99.13 -> 1.99.13`

➜ H5hut git:(master) git ls-remote --tags git@gitea-test.psi.ch:bruhn_b/5Huete.git
edcdd4ce0ff3afc46981d5f24b4e3f7f177f7833 refs/tags/1.99.0
22421d8d88bbecd4bb68106774337647846581ed refs/tags/1.99.10
5d6a9a9ac9dff29b30d6fdcf2413d098c684cfbc refs/tags/1.99.11
cd9b550fe76f6b3d1848865856eced55c0785cb1 refs/tags/1.99.12
fda65e55272c2ba02c4618f21c67ebe258c3fa70 refs/tags/1.99.12^{}
e819b6bcd7627639bc0db19a0a6abf4a3ccdaa79 refs/tags/1.99.13
aac94b38e8d0bdaedbe0d09fdd1d19c7b67a47c4 refs/tags/1.99.13^{}

On the Server side is see this log:

2025/07/21 13:15:59 services/issue/commit.go:126:UpdateIssuesCommit() [W] Repository referenced in commit but does not exist: repository does not exist [id: 0, uid: 0, owner_name: h5hut, name: src]
2025/07/21 13:16:00 services/repository/push.go:41:handler() [E] pushUpdate[bruhn_b/5Huete] failed: PushUpdateAddDeleteTags: Insert: pq: value too long for type character varying(255)

Gitea Version

1.24.3

Can you reproduce the bug on the Gitea demo site?

No

Log Gist

No response

Screenshots

No response

Git Version

git version 2.39.5 (Apple Git-154)

Operating System

RHEL 9

How are you running Gitea?

Docker Container

Database

PostgreSQL

[delvh]

PushUpdateAddDeleteTags: Insert: pq: value too long for type character varying(255)

How long is your tag name/ What's your tag name?

[wxiaoguang]

PushUpdateAddDeleteTags: Insert: pq: value too long for type character varying(255)

How long is your tag name/ What's your tag name?

It's not only related to tag name, but also tag message:

[delvh]

Yes, but that is TEXT. I doubt that text is mapped to VARCHAR(255) in Postgres.

[delvh]

Ah wait, as per that screenshot: It could also be that your tag title (the first line) is too long

[wxiaoguang]

Ah wait, as per that screenshot: It could also be that your tag title (the first line) is too long

Yes, such problem (title varchar 255 bug) has happened many times.

[top-psi]

Hello guys. Thanks for discussing the issue!
Bellow you can find the full console output of the git push. Let me know if I can provide more Infos.

➜ H5hut git:(master) git push --mirror
Certificate invalid: expired
Enumerating objects: 11263, done.
Counting objects: 100% (11263/11263), done.
Delta compression using up to 8 threads
Compressing objects: 100% (3010/3010), done.
Writing objects: 100% (11263/11263), 12.55 MiB | 1.96 MiB/s, done.
Total 11263 (delta 8203), reused 11263 (delta 8203), pack-reused 0
remote: Resolving deltas: 100% (8203/8203), done.
remote: ......................................... Processing 41 references
remote: Processed 41 references in total
To gitea-test.psi.ch:bruhn_b/5Huete.git

• [new branch] master -> master
• [new reference] origin/1.0 -> origin/1.0
• [new reference] origin/1.2 -> origin/1.2
• [new reference] origin/1.4 -> origin/1.4
• [new reference] origin/1.6 -> origin/1.6
• [new reference] origin/1.99 -> origin/1.99
• [new reference] origin/1.99.x -> origin/1.99.x
• [new reference] origin/HEAD -> origin/HEAD
• [new reference] origin/int8 -> origin/int8
• [new reference] origin/master -> origin/master
• [new tag] 1.99.0 -> 1.99.0
• [new tag] 1.99.10 -> 1.99.10
• [new tag] 1.99.11 -> 1.99.11
• [new tag] 1.99.12 -> 1.99.12
• [new tag] 1.99.13 -> 1.99.13
• [new tag] 1.99.2 -> 1.99.2
• [new tag] 1.99.3 -> 1.99.3
• [new tag] 1.99.4 -> 1.99.4
• [new tag] 1.99.5 -> 1.99.5
• [new tag] 1.99.6 -> 1.99.6
• [new tag] 1.99.7 -> 1.99.7
• [new tag] 1.99.8 -> 1.99.8
• [new tag] 1.99.9 -> 1.99.9
• [new tag] H5Part-1.3.1 -> H5Part-1.3.1
• [new tag] H5Part-1.3.2 -> H5Part-1.3.2
• [new tag] H5Part-1.3.3 -> H5Part-1.3.3
• [new tag] H5Part-1.4 -> H5Part-1.4
• [new tag] H5Part-1.6.0 -> H5Part-1.6.0
• [new tag] H5Part-1.6.1 -> H5Part-1.6.1
• [new tag] H5Part-1.6.2 -> H5Part-1.6.2
• [new tag] H5Part-1.6.3 -> H5Part-1.6.3
• [new tag] H5Part-1.6.4 -> H5Part-1.6.4
• [new tag] H5Part-1.6.5 -> H5Part-1.6.5
• [new tag] H5hut-1.99.1 -> H5hut-1.99.1
• [new tag] H5hut-2.0.0rc1 -> H5hut-2.0.0rc1
• [new tag] H5hut-2.0.0rc2 -> H5hut-2.0.0rc2
• [new tag] H5hut-2.0.0rc3 -> H5hut-2.0.0rc3
• [new tag] H5hut-2.0.0rc4 -> H5hut-2.0.0rc4
• [new tag] H5hut-2.0.0rc5 -> H5hut-2.0.0rc5
• [new tag] H5hut-2.0.0rc6 -> H5hut-2.0.0rc6
• [new tag] H5hut-2.0.0rc7 -> H5hut-2.0.0rc7
  ➜ H5hut git:(master) git ls-remote --tags git@gitea-test.psi.ch:bruhn_b/5Huete.git
  edcdd4ce0ff3afc46981d5f24b4e3f7f177f7833 refs/tags/1.99.0
  22421d8d88bbecd4bb68106774337647846581ed refs/tags/1.99.10
  5d6a9a9ac9dff29b30d6fdcf2413d098c684cfbc refs/tags/1.99.11
  cd9b550fe76f6b3d1848865856eced55c0785cb1 refs/tags/1.99.12
  fda65e55272c2ba02c4618f21c67ebe258c3fa70 refs/tags/1.99.12^{}
  e819b6bcd7627639bc0db19a0a6abf4a3ccdaa79 refs/tags/1.99.13
  aac94b38e8d0bdaedbe0d09fdd1d19c7b67a47c4 refs/tags/1.99.13^{}
  562f9ac3e334ef7374bd1469fe3c84cda2192def refs/tags/1.99.2
  7baf635befe7f8905c22b75f34b83d89fbd8eeed refs/tags/1.99.3
  d8c84a3bff9b9ea0af06773fa5784876985adaa3 refs/tags/1.99.4
  aacd90c1ccd0d27b19d1c4c77ecd6ae5171cbfdb refs/tags/1.99.5
  4a33578c8ffadb8d22e6358b50f3590ac0993efb refs/tags/1.99.6
  3569a12376aca48dc1aed13bcce31202e36334e9 refs/tags/1.99.7
  556fe9b8a649f2b3d7719df7f8168bb5e8006161 refs/tags/1.99.8
  e27bdb592e5c08f03f13d576ac7fdddc54803514 refs/tags/1.99.9
  e21e1bf4f4a70b444eb04e68bd5737a524fed589 refs/tags/H5Part-1.3.1
  172ceff05a8ab27b16cfc099870d671b6d37c3c9 refs/tags/H5Part-1.3.2
  7d140c6cb67b6d7c731fd8de50e73d197a9499a0 refs/tags/H5Part-1.3.3
  8a553aee0cb9c7754a07d08c84dac9fb4523e937 refs/tags/H5Part-1.4
  1d23bdab85e79902d7227d1abb7fd963921508b9 refs/tags/H5Part-1.6.0
  1cd47a604aa86c597e7c29707f076988cd7fbcf2 refs/tags/H5Part-1.6.1
  d368a602028c05a7b73aebe35c35fa36c97a0e89 refs/tags/H5Part-1.6.2
  b1aa655b222766ec611993422083c908b8eb3e7b refs/tags/H5Part-1.6.3
  1bda4e3c7047da8bef770272c5862d2adfce2be1 refs/tags/H5Part-1.6.4
  39cee80bc7f9e8e9d4074986a43a709737519d7e refs/tags/H5Part-1.6.5
  ecb23b66dd7557af5068a603b5450a87632739c5 refs/tags/H5hut-1.99.1
  489cf38324532cfa2f66047e9c7dc30e3f855429 refs/tags/H5hut-2.0.0rc1
  7fbd5c5de18d7fe53c67b04fdf91041ff3e2a563 refs/tags/H5hut-2.0.0rc1^{}
  54a03307a64e816940bbaf30bc17d0d84740add6 refs/tags/H5hut-2.0.0rc2
  ad5283302253f44ea82f1e2006e14412acf43da5 refs/tags/H5hut-2.0.0rc2^{}
  026a40d26be7c4d37efc3c03585ced6053154053 refs/tags/H5hut-2.0.0rc3
  e447d536a366578643d8224811277636bc5e7271 refs/tags/H5hut-2.0.0rc3^{}
  863224a563e887218068eefa824c266e01afbe64 refs/tags/H5hut-2.0.0rc4
  ecc4618bd4788992b029a9237e9af7c4a6c448bd refs/tags/H5hut-2.0.0rc4^{}
  6e7352600459a1dcc041d1a2e58a9ecb5ac2a5fe refs/tags/H5hut-2.0.0rc5
  6a4d711b9907ff191065fd70048892a341479b88 refs/tags/H5hut-2.0.0rc5^{}
  7e7a85f14fc3ee123c122859a641db624de41b2a refs/tags/H5hut-2.0.0rc6
  c30655538a77e3804a781f81e78fbc37728d303f refs/tags/H5hut-2.0.0rc7
  c41bd6ec549f1c4e7c90f8d52655054ab56bca57 refs/tags/H5hut-2.0.0rc7

[top-psi]

Also the Postgres log message.

2025-07-21 11:16:00.004 UTC [12987] ERROR:  value too long for type character varying(255)
2025-07-21 11:16:00.004 UTC [12987] STATEMENT:  INSERT INTO "release" ("repo_id","publisher_id","tag_name","original_author","original_author_id","lower_tag_name","target","title","sha1","num_commits","note","is_draft","is_prerelease","is_tag","created_unix") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15),($16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30),($31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45),($46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60),($61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75),($76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90),($91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105),($106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120),($121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135),($136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150),($151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165),($166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180),($181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195),($196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210),($211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225),($226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240),($241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255),($256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270),($271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285),($286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300),($301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315),($316, $317, $318, $319, $320, $321, $322, $323, $324, $325, $326, $327, $328, $329, $330),($331, $332, $333, $334, $335, $336, $337, $338, $339, $340, $341, $342, $343, $344, $345),($346, $347, $348, $349, $350, $351, $352, $353, $354, $355, $356, $357, $358, $359, $360),($361, $362, $363, $364, $365, $366, $367, $368, $369, $370, $371, $372, $373, $374, $375),($376, $377, $378, $379, $380, $381, $382, $383, $384, $385, $386, $387, $388, $389, $390),($391, $392, $393, $394, $395, $396, $397, $398, $399, $400, $401, $402, $403, $404, $405),($406, $407, $408, $409, $410, $411, $412, $413, $414, $415, $416, $417, $418, $419, $420),($421, $422, $423, $424, $425, $426, $427, $428, $429, $430, $431, $432, $433, $434, $435),($436, $437, $438, $439, $440, $441, $442, $443, $444, $445, $446, $447, $448, $449, $450),($451, $452, $453, $454, $455, $456, $457, $458, $459, $460, $461, $462, $463, $464, $465)

[lunny]

Yes, but that is TEXT. I doubt that text is mapped to VARCHAR(255) in Postgres.

Currently, title is defined as VARCHAR(255) and note as TEXT. The title represents the first line of the commit message, while note contains the rest. However, both fields may be too short to store the full content.

Could you please paste the entire commit message here so we can verify?

[top-psi]

`commit 3a9e6d8335e13a154cddc64cf1589b2adbe85e9a (HEAD -> master, origin/master,
origin/HEAD)
Merge: 40644d0 9d4c884
Author: xxxxxxxxx xxxxxxx.xxxxxxxxx@psi.ch
Date: Thu Oct 31 13:29:33 2024 +0100

Merge branch 'int8' into 'master'

Add support for hdf5 int8 types (int8, uint8)

See merge request H5hut/src!7

`

This was the last one. Let me know if I should dig up more

[top-psi]

Interesting enough - When migrating the project it works. I had it in Gitlab and migrated to Gitea and that worked fine.

[wxiaoguang]

Yes, but that is TEXT. I doubt that text is mapped to VARCHAR(255) in Postgres.

Currently, title is defined as VARCHAR(255) and note as TEXT. The title represents the first line of the commit message, while note contains the rest. However, both fields may be too short to store the full content.

Could you please paste the entire commit message here so we can verify?

No idea what you need to "verify" since it is clearly a bug that the splitted message exceeds the release.Title

[wxiaoguang]

This was the last one. Let me know if I should dig up more

Thank you for the feedback! But this message isn't the one that causes the bug ... 😄

The "releases" are inserted in batch, so any one of the tags that has long message will cause the error.

Although I think there is no need to check the tag messages one by one ..... if you'd like to dig up more, you can take a look for which tag has long message.

Interesting enough - When migrating the project it works. I had it in Gitlab and migrated to Gitea and that worked fine.

Maybe there is another bug, IIRC some users reported that "git repo migration" doesn't sync tags correctly (#34767), Just FYI, TBH I don't know whether that issue is really a bug (tags don't get sync), or something unrelated.

[top-psi]

Thank you for the feedback! But this message isn't the one that causes the bug ... 😄

I just realised that as well :D

I sorted all commit messages by tag and length and the one bellow is the longest. There are 11 messages longer than 255 chars.

H5Part-1.6.5: added documentation for file open flags; added flags to h5pt_openr_par_align(); added H5PartSetViewEmpty() and h5pt_setview_empty() calls for creating empty hyperslab selections (previously kludge was to use H5PartSetViewIndices with a null list); fixed memory leak with file open flags in the Fortran interface; fixed missing statement in 1.6.x logic for _H5Part_have_group()