Upgrade to 2021.3 shows potential database issue in index-key length

Hi there,

Just upgraded from 2021.1 to 2021.3 and i noticed in the upgrade log, the there is a index key to long for SQL Server. Output is directly visible in the logs. Might be worth fixing to avoid future issues.

Executing .NET Database Server script 'Script0297CreateBlobTable'
Warning! The maximum key length for a clustered index is 900 bytes. The index 'IX_Blob_BlobId' has maximum length of 1040 bytes. For some combination of large values, the insert/update operation will fail.

Hi Kasper,
Thanks for letting us know about this issue.

It looks like this was fixed in a recent version (2021.3.5805) - the GH issue is here:

If you get a chance to upgrade to a later version this will hopefully fix that warning for you.

Appreciate the heads up.

Kind Regards,
Paraic

This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.