Warning regarding PK_Mutex_Id when installing Octopus server

Legacy Uncategorised
1

I’ve just installed Octopus.3.1.4-x64 on a new server. After the installation/configuration script completed, I got the following warning:

Executing SQL Server script 'Octopus.Core.UpgradeScripts.Script0020 - Create mutex table.sql’
Warning! The maximum key length is 900 bytes. The index ‘PK_Mutex_Id’ has maximum length of 1000 bytes. For some combination of large values, the insert/update operation will fail.

I can see what the warning says, but what does this in practice mean? Will it be fine running Octopus, or may we at some point run into some weird/unforeseen bug? Should I ask my DB administrator do do anything to the database (I don’t know of the maximum key length can be modified)? We didn’t ask for any specific configuration from our DBA when ordering the database (other then what is given here http://docs.octopusdeploy.com/display/OD/SQL+Server+Database+Requirements), so I assume it is a pretty “standard” MS SQL Server database configuration.

What is your recommendation?

2

Hi Julian,

Thanks for letting us know about this!

The warning you’re getting is unlikely to give you any trouble unless your packages have very long names, however I’ve created a GitHub Issue so we can handle it properly.

You shouldn’t need to do anything, but please let us know if it causes you issues.

Thanks,
Damo

3

Thank you for the clarification. We’ll leave it as it is then.