Upgrading fails with ERROR The size (16777215) given to the column 'event' exceeds the maximum allowed for any data type (8000) in Confluence
This Knowledge Base article was written specifically for the Atlassian Server platform. Due to the Restricted functions in Atlassian Cloud apps, the contents of this article cannot be applied to Atlassian Cloud applications.
Customers on Microsoft SQL Server can run into an error where the 'EVENTS' table fails to be created due to the size given to the 'EVENT' column, when upgrading to Confluence 6.0 or later.
The following appears in the
ERROR [localhost-startStop-1] [hibernate.tool.hbm2ddl.SchemaUpdate] execute Unsuccessful: create table [EVENTS] ([rev] varchar(255) not null, [history] varchar(255) not null, [partition] int not null, [sequence] int not null, [event] varbinary(16777215) null, primary key ([rev], [history])) java.sql.SQLException: The size (16777215) given to the column 'event' exceeds the maximum allowed for any data type (8000).
- Database: Microsoft SQL Server (2012 and 2014)
Prior to upgrading, the
<confluence-home>/confluence.cfg.xmlfile contains the following value for the "hibernate.dialect" property:
The "hibernate.dialect" property is incorrectly retained after upgrading.
net.sf.hibernate.dialect.SQLServerDialect dialect was used in a very old version of Confluence, and has since been deprecated. Instances that have been upgraded from Confluence 2.4 or earlier have retained this deprecated dialect due to a bug in the upgrade process, which has caused a problem for customers upgrading to Confluence 6.0 or later.
To manually work around this issue, before upgrading to Confluence 6.0 or later, edit
<confluence-home>/confluence.cfg.xml, and change this property:
to the following: