How to identify build results for variable that has a length greater than 4000

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。

Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.

*Fisheye および Crucible は除く

要約


On Bamboo versions older than 7.1.1, the database might have issues with the length of the variable column of the build result table for PostgresSQL.

This is related to the bug below:
BAM-21059 - Getting issue details... STATUS

診断

Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(4000)

This error suggests that there's a value in the source that is greater than 4000 characters which is the column size limit in PostgreSQL.

情報

This query identifies on build result the variable that has a length greater than 4000.

SELECT brs.BUILD_KEY, brs.BUILD_NUMBER, vc.VARIABLE_KEY from BUILDRESULTSUMMARY brs
JOIN VARIABLE_CONTEXT vc on
brs.BUILDRESULTSUMMARY_ID=vc.BUILDRESULTSUMMARY_ID
where length(vc.VARIABLE_VALUE) >= 4000;

This query was tested against PostgresSQL. It might need to change it accordingly to your DBMS. 

In addition, the query below will return the variable type and size for the table VARIABLE_CONTEXT and row VARIABLE_VALUE. That way it can be compared to the other database table information that is being migrated to.

SELECT * FROM <DB-NAME>.INFORMATION_SCHEMA.COLUMNS ORDER BY TABLE_NAME

(warning)Replace <DB-NAME> accordingly to the Bamboo database name.

最終更新日: 2021 年 10 月 29 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.