Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,297,444
Community Members
 
Community Events
165
Community Groups

After setting up Confluence staging instance refreshed from production, cannot create space/page

Edited

I get the following error when trying to create spaces or pages in my staging instances of Confluence:

CleanShot 2022-04-30 at 14.25.33.png

 

Both of the database instances are Azure SQL, so they are on the current version. 

 

Here is what is in the logs when we're doing diagnostic logging. I expect this is somewhat a database issue somewhere, because Confluence is referencing production.dbo.SPACES - but this would not exist in the new database created from the backup of the previous database, because the new database is not called production - it has a different name:

2022-04-30 16:16:28,132 ERROR [https-jsse-nio2-8443-exec-22] [engine.jdbc.spi.SqlExceptionHelper] logExceptions Reference to database and/or server name in 'production.dbo.SPACES' is not supported in this version of SQL Server.
-- referer: https://confluencesandbox.ntst.com:8443/admin/viewlog4j.action | url: /rest/create-dialog/1.0/space-blueprint/create-space | traceId: 130fbb311b51bcdc | userName: BGuffey
2022-04-30 16:16:28,133 ERROR [https-jsse-nio2-8443-exec-22] [core.persistence.hibernate.HibernateObjectDao] reIndex Unable to reIndex object: spacedesc: Create Space v.1 (51019779) -- Failed to add entry to queue
-- referer: https://confluencesandbox.ntst.com:8443/admin/viewlog4j.action | url: /rest/create-dialog/1.0/space-blueprint/create-space | traceId: 130fbb311b51bcdc | userName: BGuffey
com.atlassian.confluence.api.service.exceptions.ServiceException: Failed to add entry to queue
Caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement
Caused by: org.hibernate.exception.SQLGrammarException: could not execute statement
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:106)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Reference to database and/or server name in 'production.dbo.SPACES' is not supported in this version of SQL Server.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:260)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1547)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:528)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:461)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7342)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2688)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:224)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:204)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:408)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:175)
... 490 more
2022-04-30 16:16:28,188 ERROR [https-jsse-nio2-8443-exec-22] [org.hibernate.AssertionFailure] <init> HHH000099: an assertion failure occurred (this may indicate a bug in Hibernate, but is more likely due to unsafe use of the session): org.hibernate.AssertionFailure: null id in com.atlassian.confluence.impl.journal.JournalEntry entry (don't flush the Session after an exception occurs)
-- referer: https://confluencesandbox.ntst.com:8443/admin/viewlog4j.action | url: /rest/create-dialog/1.0/space-blueprint/create-space | traceId: 130fbb311b51bcdc | userName: BGuffey
2022-04-30 16:16:28,190 WARN [https-jsse-nio2-8443-exec-22] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:
->[com.atlassian.confluence.spaces.DefaultSpaceManager.createSpace]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #1550088789)
-- referer: https://confluencesandbox.ntst.com:8443/admin/viewlog4j.action | url: /rest/create-dialog/1.0/space-blueprint/create-space | traceId: 130fbb311b51bcdc | userName: BGuffey
2022-04-30 16:16:28,193 ERROR [https-jsse-nio2-8443-exec-22] [plugins.createcontent.exceptions.RestExceptionMapper] toResponse
-- referer: https://confluencesandbox.ntst.com:8443/admin/viewlog4j.action | url: /rest/create-dialog/1.0/space-blueprint/create-space | traceId: 130fbb311b51bcdc | userName: BGuffey
java.lang.reflect.UndeclaredThrowableException
at com.sun.proxy.$Proxy123.createDefaultSpacePermissions(Unknown Source)
at com.atlassian.confluence.security.SpacePermissionCoordinator.createDefaultSpacePermissions(SpacePermissionCoordinator.java:122)

Caused by: java.lang.reflect.InvocationTargetException
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at com.atlassian.confluence.impl.security.SpacePermissionManagerFactory.lambda$new$0(SpacePermissionManagerFactory.java:68)
... 401 more
Caused by: org.hibernate.AssertionFailure: null id in com.atlassian.confluence.impl.journal.JournalEntry entry (don't flush the Session after an exception occurs)
at org.hibernate.event.internal.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:60)
at org.hibernate.event.internal.DefaultFlushEntityEventListener.getValues(DefaultFlushEntityEventListener.java:175)
at org.hibernate.event.internal.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:135)
at org.hibernate.event.internal.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:216)
at org.hibernate.event.internal.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:85)
at org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:44)
at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1398)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1483)
at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1445)
at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1414)
at com.atlassian.confluence.setup.bandana.persistence.dao.hibernate.HibernateConfluenceBandanaRecordDao.lambda$getRecord$0(HibernateConfluenceBandanaRecordDao.java:52)
at org.springframework.orm.hibernate5.HibernateTemplate.doExecute(HibernateTemplate.java:385)
at org.springframework.orm.hibernate5.HibernateTemplate.execute(HibernateTemplate.java:337)
at com.atlassian.confluence.setup.bandana.persistence.dao.hibernate.HibernateConfluenceBandanaRecordDao.getRecord(HibernateConfluenceBandanaRecordDao.java:48)
at com.atlassian.confluence.setup.bandana.ConfluenceDaoBandanaPersister.retrieve(ConfluenceDaoBandanaPersister.java:29)
at com.atlassian.confluence.impl.bandana.ReadThroughCachingBandanaPersister.lambda$retrieve$0(ReadThroughCachingBandanaPersister.java:84)
at com.atlassian.confluence.impl.cache.ReadThroughAtlassianCache.lambda$get$0(ReadThroughAtlassianCache.java:76)
at com.atlassian.confluence.cache.CacheOperations.lambda$get$0(CacheOperations.java:172)
at java.base/java.util.HashMap.computeIfAbsent(Unknown Source)
at com.atlassian.confluence.cache.CacheOperations.get(CacheOperations.java:172)
at com.atlassian.confluence.cache.DeferredOperationsCache.getOrLoad(DeferredOperationsCache.java:93)
at com.atlassian.confluence.cache.DeferredOperationsCache.get(DeferredOperationsCache.java:57)
at com.atlassian.confluence.cache.TransactionalCacheFactory$TransactionalCache.get(TransactionalCacheFactory.java:343)
at com.atlassian.confluence.impl.cache.ReadThroughAtlassianCache.get(ReadThroughAtlassianCache.java:88)
at com.atlassian.confluence.impl.cache.ReadThroughCache.get(ReadThroughCache.java:28)
at com.atlassian.confluence.impl.bandana.ReadThroughCachingBandanaPersister.retrieve(ReadThroughCachingBandanaPersister.java:82)
at com.atlassian.confluence.impl.bandana.ReadThroughCachingBandanaPersister.retrieve(ReadThroughCachingBandanaPersister.java:75)
at jdk.internal.reflect.GeneratedMethodAccessor292.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:295)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
at com.sun.proxy.$Proxy84.retrieve(Unknown Source)
at com.atlassian.bandana.DefaultBandanaManager.getValue(DefaultBandanaManager.java:32)
at com.atlassian.bandana.DefaultBandanaManager.getValue(DefaultBandanaManager.java:24)
at com.atlassian.confluence.security.DefaultSpacePermissionDefaultsStore.getBandanaValue(DefaultSpacePermissionDefaultsStore.java:143)
at com.atlassian.confluence.security.DefaultSpacePermissionDefaultsStore.loadFromBandana(DefaultSpacePermissionDefaultsStore.java:46)
at com.atlassian.confluence.security.DefaultSpacePermissionDefaultsStore.<init>(DefaultSpacePermissionDefaultsStore.java:42)
at com.atlassian.confluence.security.DefaultSpacePermissionDefaultsStoreFactory.createStore(DefaultSpacePermissionDefaultsStoreFactory.java:22)
at com.atlassian.confluence.security.DefaultSpacePermissionManager.createDefaultSpacePermissions(DefaultSpacePermissionManager.java:299)
... 406 more

2 answers

0 votes
Brant Schroeder Community Leader Apr 30, 2022

@Bryan Guffey What version of SQL server is running on your azure instance?

@Brant Schroeder Azure SQL is always running the latest stable version of SQL Server - this is not a SQL Server installation on an Azure VM, but the Azure SQL Database.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

An update on Confluence Cloud customer feedback – June 2022

Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...

54 views 0 0
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you