Crucible will OOM if have large commit messages

[Philip Schlesinger]

FYI to all:

If your Fisheye slurps up commits with large commit messages – and then if those commits are included in a Crucible review – you might experience an OutOfMemoryError error.  This problem is being tracked here:

https://jira.atlassian.com/browse/CRUC-7341

There is an easy workaround to truncate the commit messages stored in the Fisheye / Crucible database:

UPDATE cru_fr_detail
SET cru_value = SUBSTRING(cru_value, 0, 2000)
WHERE cru_name = 'comment' AND length(cru_value) > 2000

MySQL version:

UPDATE cru_fr_detail SET cru_value = SUBSTRING(cru_value, 0, 2000) WHERE cru_name = 'comment' AND char_length(cru_value) > 2000

Please vote for https://jira.atlassian.com/browse/CRUC-7341

Thanks

[Philip Schlesinger · Accepted solution]

Answered in above message