Unable to upgrade plugins due to Length of LOB data in SQL server
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. 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.
*Except Fisheye and Crucible
Summary
Confluence admin is unable to upgrade plugins due to an exception relating to the "Length of LOB data" exceeding the maximum configured limit.
Diagnosis
Upgrading plugins causes the following error: An unexpected error occurred. Please refer to the logs for more information
The following appears in the atlassian-confluence.log:
Caused by: net.sf.hibernate.exception.GenericJDBCException: could not update: [com.atlassian.confluence.plugin.persistence.PluginData#10190858]
at net.sf.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:80)
at net.sf.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at net.sf.hibernate.persister.AbstractEntityPersister.convert(AbstractEntityPersister.java:1331)
at net.sf.hibernate.persister.EntityPersister.update(EntityPersister.java:681)
at net.sf.hibernate.persister.EntityPersister.update(EntityPersister.java:621)
at net.sf.hibernate.impl.ScheduledUpdate.execute(ScheduledUpdate.java:52)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2464)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2450)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2408)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2276)
at com.atlassian.confluence.plugin.persistence.hibernate.HibernatePluginDataDao.saveOrUpdate(HibernatePluginDataDao.java:60)
... 114 more
Caused by: java.sql.SQLException: Length of LOB data (105082) to be replicated exceeds configured maximum 65536. Use the stored procedure sp_configure to increase the configured maximum value for max text repl size option, which defaults to 65536. A configured value of -1 indicates no limit, other that the limit imposed by the data type.Cause
This is a limitation of MSSQL server Max text exceeding the configured maximum 65536 characters.
Solution
Increase the size that can be replicated. This is applicable for transactional replication only.
Recommendation for DBA to perform the following:
T-SQL: EXEC sp_configure ‘max text repl size’, 2147483647
SSMS (excerpt from BOL):
In Object Explorer, right-click a server and select Properties.
Click the Advanced node.
Under Miscellaneous, change the Max Text Replication Size option to the desired value.
Was this helpful?