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,296,708
Community Members
 
Community Events
165
Community Groups

Cannot create space/page after setting up staging instance of Confluence - "Rollback" error

 

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

3 answers

1 accepted

0 votes
Answer accepted

Hi @Bryan Guffey 
I hope you are well.

Could you please run the following query on your staging instance?

SELECT table_name = so.name
,trigger_name = st.name
,trigger_text = sc.text
,create_date = st.create_date
FROM sys.triggers st
JOIN sysobjects so ON st.parent_id = so.id
JOIN syscomments sc ON sc.id = st.[object_id];
I wonder if there are triggers on your database still pointing to the production DB.
If that's the case you will probably need to:
  1. Copy the trigger definition to use it in next steps.
  2. Drop the trigger pointing to the prod DB.
  3. Create the trigger based on step 1, but this time targeting the current DB.
  4. Enable the trigger.

Let me know how it goes.

Kind regards,
Thiago Masutti

 

Yes, it does look like that's the case.

 

Can you tell me how to drop, create, and enable the trigger? 

table_name,trigger_name,trigger_text,create_date
SPACES,denormalised_space_trigger,"CREATE TRIGGER [dbo].denormalised_space_trigger
ON [production].[dbo].SPACES
AFTER INSERT, UPDATE, DELETE
AS
BEGIN
SET NOCOUNT ON;
if ([dbo].space_function_for_denormalised_permissions() = 1)
BEGIN
INSERT INTO DENORMALISED_SPACE_CHANGE_LOG (space_id) select SPACEID from inserted;
INSERT INTO DENORMALISED_SPACE_CHANGE_LOG (space_id) select SPACEID from deleted;
END
END
",2022-02-05 20:40:09.867
SPACEPERMISSIONS,denormalised_space_permission_trigger,"CREATE TRIGGER [dbo].denormalised_space_permission_trigger
ON [production].[dbo].SPACEPERMISSIONS
AFTER INSERT, UPDATE, DELETE
AS
BEGIN
SET NOCOUNT ON;
if ([dbo].space_permission_function_for_denormalised_permissions() = 1)
BEGIN
INSERT INTO DENORMALISED_SPACE_CHANGE_LOG (space_id) select SPACEID from inserted;
INSERT INTO DENORMALISED_SPACE_CHANGE_LOG (space_id) select SPACEID from deleted;
END
END
",2022-02-05 20:40:09.873
CONTENT,denormalised_content_trigger,"CREATE TRIGGER [dbo].denormalised_content_trigger
ON [production].[dbo].CONTENT
AFTER INSERT, UPDATE, DELETE
AS
BEGIN
SET NOCOUNT ON;
if ([dbo].content_function_for_denormalised_permissions() = 1)
BEGIN
INSERT INTO DENORMALISED_CONTENT_CHANGE_LOG (content_id)
SELECT CONTENTID
FROM inserted
WHERE CONTENTTYPE = 'PAGE' AND PREVVER IS NULL;
INSERT INTO DENORMALISED_CONTENT_CHANGE_LOG (content_id)
SELECT CONTENTID
FROM deleted
WHERE CONTENTTYPE = 'PAGE' AND PREVVER IS NULL;
END
END
",2022-02-05 20:40:09.880
CONTENT_PERM,denormalised_content_permission_trigger,"CREATE TRIGGER [dbo].denormalised_content_permission_trigger
ON [production].[dbo].CONTENT_PERM
AFTER INSERT, UPDATE, DELETE
AS
BEGIN
SET NOCOUNT ON;
if ([dbo].content_permission_function_for_denormalised_permissions() = 1)
BEGIN
INSERT INTO DENORMALISED_CONTENT_CHANGE_LOG (cps_id) select CPS_ID from inserted;
INSERT INTO DENORMALISED_CONTENT_CHANGE_LOG (cps_id) select CPS_ID from deleted;
END
END
",2022-02-05 20:40:09.887
CONTENT_PERM_SET,denormalised_content_perm_set_trigger,"CREATE TRIGGER [dbo].denormalised_content_perm_set_trigger
ON [production].[dbo].CONTENT_PERM_SET
AFTER INSERT, UPDATE, DELETE
AS
BEGIN
SET NOCOUNT ON;
if ([dbo].content_perm_set_function_for_denormalised_permissions() = 1)
BEGIN
INSERT INTO DENORMALISED_CONTENT_CHANGE_LOG (content_id, cps_id) select CONTENT_ID, ID from deleted;
END
END
",2022-02-05 20:40:09.890

Hi @Bryan Guffey 

See if the following works.

USE [conf_sbox];

--- Drop triggers
DROP TRIGGER [production].[dbo].[denormalised_space_trigger]
GO


DROP TRIGGER [production].[dbo].[denormalised_space_permission_trigger]
GO


DROP TRIGGER [production].[dbo].[denormalised_content_trigger]
GO


DROP TRIGGER [production].[dbo].[denormalised_content_permission_trigger]
GO


DROP TRIGGER [production].[dbo].[denormalised_content_perm_set_trigger]
GO


--- Create and enable triggers

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[denormalised_space_trigger]
ON [conf_sbox].[dbo].[SPACES]
AFTER INSERT, UPDATE, DELETE
AS
BEGIN
SET NOCOUNT ON;
if ([dbo].space_function_for_denormalised_permissions() = 1)
BEGIN
INSERT INTO DENORMALISED_SPACE_CHANGE_LOG (space_id) select SPACEID from inserted;
INSERT INTO DENORMALISED_SPACE_CHANGE_LOG (space_id) select SPACEID from deleted;
END
END
GO
ALTER TABLE [dbo].[SPACES] ENABLE TRIGGER [denormalised_space_trigger]
GO



SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[denormalised_space_permission_trigger]
ON [conf_sbox].[dbo].[SPACEPERMISSIONS]
AFTER INSERT, UPDATE, DELETE
AS
BEGIN
SET NOCOUNT ON;
if ([dbo].space_permission_function_for_denormalised_permissions() = 1)
BEGIN
INSERT INTO DENORMALISED_SPACE_CHANGE_LOG (space_id) select SPACEID from inserted;
INSERT INTO DENORMALISED_SPACE_CHANGE_LOG (space_id) select SPACEID from deleted;
END
END
GO
ALTER TABLE [dbo].[SPACEPERMISSIONS] ENABLE TRIGGER [denormalised_space_permission_trigger]
GO



SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[denormalised_content_trigger]
ON [conf_sbox].[dbo].[CONTENT]
AFTER INSERT, UPDATE, DELETE
AS
BEGIN
SET NOCOUNT ON;
if ([dbo].content_function_for_denormalised_permissions() = 1)
BEGIN
INSERT INTO DENORMALISED_CONTENT_CHANGE_LOG (content_id)
SELECT CONTENTID
FROM inserted
WHERE CONTENTTYPE = 'PAGE' AND PREVVER IS NULL;
INSERT INTO DENORMALISED_CONTENT_CHANGE_LOG (content_id)
SELECT CONTENTID
FROM deleted
WHERE CONTENTTYPE = 'PAGE' AND PREVVER IS NULL;
END
END
GO
ALTER TABLE [dbo].[CONTENT] ENABLE TRIGGER [denormalised_content_trigger]
GO



SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[denormalised_content_permission_trigger]
ON [conf_sbox].[dbo].[CONTENT_PERM]
AFTER INSERT, UPDATE, DELETE
AS
BEGIN
SET NOCOUNT ON;
if ([dbo].content_permission_function_for_denormalised_permissions() = 1)
BEGIN
INSERT INTO DENORMALISED_CONTENT_CHANGE_LOG (cps_id) select CPS_ID from inserted;
INSERT INTO DENORMALISED_CONTENT_CHANGE_LOG (cps_id) select CPS_ID from deleted;
END
END
GO
ALTER TABLE [dbo].[CONTENT_PERM] ENABLE TRIGGER [denormalised_content_permission_trigger]
GO



SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[denormalised_content_perm_set_trigger]
ON [conf_sbox].[dbo].[CONTENT_PERM_SET]
AFTER INSERT, UPDATE, DELETE
AS
BEGIN
SET NOCOUNT ON;
if ([dbo].content_perm_set_function_for_denormalised_permissions() = 1)
BEGIN
INSERT INTO DENORMALISED_CONTENT_CHANGE_LOG (content_id, cps_id) select CONTENT_ID, ID from deleted;
END
END
GO
ALTER TABLE [dbo].[CONTENT_PERM_SET] ENABLE TRIGGER [denormalised_content_perm_set_trigger]
GO
Kind regards,
Thiago Masutti
Like Bryan Guffey likes this

Thiago-

This worked! Thank you so much! Any idea what exactly is causing this? If you're interested, i can share the process I used to to create the sandbox database. I will add this to our refresh procedure going forward, however!

 

One note - I had to remove the word "production" from the initial set of SQL commands to remove the triggers, because they aren't used in the trigger name itself. 

And one other note - with Azure SQL, we don't use the USE statement, and instead have to select the DB directly for our query. 

Hi Bryan.

That's really great!

I noticed you opened a support request. Could you please add the information on how you've created the staging DB there?

We will work internally to better understand this situation as it might impact any customer using SQL Server after we introduced triggers to the DB.
Depending on the outcome we will provide a public KB article to help you and other customers.

Kind regards,
Thiago Masutti

0 votes

What database are you using?  Azure-sql does not tell us what type of database it is, and the errors you are getting look like you have chosen an unsupported one.

Also, could you show us what you have in <jira home>/dbconfig.xml - it might be that you are using a supported database, but your connection settings in there are wrong.

@Nic Brough _Adaptavist_  - Azure SQL Database, AKA Microsoft SQL Azure (RTM) - 12.0.2000.8

 

Also, this is Confluence, not Jira - the confluence.cfg.xml is as follows: 

<?xml version="1.0" encoding="UTF-8"?>

<confluence-configuration>
<setupStep>complete</setupStep>
<setupType>custom</setupType>
<buildNumber>8803</buildNumber>
<properties>
<property name="access.mode">READ_WRITE</property>
<property name="admin.ui.allow.daily.backup.custom.location">false</property>
<property name="admin.ui.allow.manual.backup.download">false</property>
<property name="admin.ui.allow.site.support.email">false</property>
<property name="atlassian.license.message">AAABmw0ODAoPeNp1kVFvmzAUhd/9K5D20mqiwtAkEMnSUiAtSUi6hjStlBcHXcAqMaltkvHvZ6BR1 017s++Rzrnnu9+mghmTozDwwMDO2MZjyzP8IDFsy7bRGzTPICSrOMFDyxpZruNg5Fdc0VQt6QHIP q+zDJofXEl1k1YHlFY8u9EqOwFRogb0WIu0oBICqoC0rqZ1a+IhWrAUuITw15GJ5g9x0IofEWFMW flvxhrECUQUkLsNXpnJ/cwzn6KtY8bOJkRl7/tAZUFi/+xPwwfxPn1+lfWtf55n77N58qhgMNp47 vdJ8VO8lO50dv/WcHbeJ1HoRel8G229Is93ZEf6Pno96gNXIPpO63ovU8GOqiXTTfSiWuaUp/9p1 Pks68MexCrbSE2VmLifrhUVrXVGSwkXLrrdIgrW4dJcYNcejZyhi/SPfJ2sRE45k7RbZAlKHrSVk UBa8KqscgYS+QI6+W/+XfRHWNIcoTunv4rj8MmPJosLx8v9bRTAZ2d9n6ysQbc1rlo4Rk/nejc2w hMt6y4RfT57SL8Bv+XNyjAtAhUAg5vYYahZImFlg9uTGU4XUEwHzb8CFGL+QzDx3xlS4pjMcuv/e B1eGW7uX02jr</property>
<property name="attachments.dir">${confluenceHome}\attachments</property>
<property name="confluence.setup.server.id">BUFB-L5TZ-Y2RR-VVYP</property>
<property name="confluence.webapp.context.path"></property>
<property name="finalizedBuildNumber">8803</property>
<property name="hibernate.c3p0.validate">true</property>
<property name="hibernate.connection.autocommit">false</property>
<property name="hibernate.connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
<property name="hibernate.connection.isolation">2</property>
<property name="hibernate.connection.password">removed</property>
<property name="hibernate.connection.provider_class">com.atlassian.confluence.impl.hibernate.DelegatingHikariConnectionProvider</property>
<property name="hibernate.connection.url">jdbc:sqlserver://someserver.database.windows.net:1433;databaseName=conf_sbox</property>
<property name="hibernate.connection.username">removed</property>
<property name="hibernate.database.lower_non_ascii_supported">true</property>
<property name="hibernate.dialect">com.atlassian.confluence.impl.hibernate.dialect.SQLServerDialect</property>
<property name="hibernate.hikari.idleTimeout">30000</property>
<property name="hibernate.hikari.maximumPoolSize">187</property>
<property name="hibernate.hikari.minimumIdle">20</property>
<property name="hibernate.hikari.registerMbeans">true</property>
<property name="hibernate.setup">true</property>
<property name="jwt.private.key">removed</property>
<property name="jwt.public.key">removed</property>
<property name="lucene.index.dir">${localHome}\index</property>
<property name="spring.datasource.hikari.registerMbeans">true</property>
<property name="synchrony.encryption.disabled">true</property>
<property name="synchrony.proxy.enabled">true</property>
<property name="webwork.multipart.saveDir">${localHome}\temp</property>
</properties>
</confluence-configuration>

 

Additionally, this config works perfectly fine in my production instance of Confluence 7.15.0 - same version I replicated from, following the instructions here

Bother!  Sorry about that, I mixed your post up with a "database problems with Jira" I was answering around the same time.

Thank you for translating it into what I was asking for in Confluence, and answering the question I was trying to ask!

This version of Confluence runs (supported) on MS-SQL 2017 and Azure SQL, so we can rule out version incompatibilities.

There's nothing in the config that looks iffy, so I don't think it's that either.

The only other time I've seen the main message in your log is when I've messed up the creation of the database for Confluence to use, badly enough that it looks like it's not even there.  But for me, I've then got a pile of "tables aren't there" messages, not what you are getting, and what you've got suggests the database does exist.

I think this one needs to go to Atlassian - what type of licence do you have?  (free and starter licences are not supported, but community leaders can pitch in and ask Atlassian for help.  Standard and above accounts can raise it at https://support.atlassian.com/contact to get direct help, usually a bit faster than community escalation)

Like Bryan Guffey likes this

I've got a commercial license, so I can definitely reach out to them! Thanks, @Nic Brough _Adaptavist_

0 votes

Hi @Bryan Guffey ,

please specify your Confluence version and your dbms type/version.

Fabio

@Fabio Racobaldo _Herzum_ 

Confluence 7.15.0 

Microsoft SQL Azure (RTM) - 12.0.2000.8

Suggest an answer

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

Confluence: Where work and wellness meet

Feeling overwhelmed by the demands of work and life? With a 25% increase in the prevalence of anxiety and depression worldwide during the pandemic, for most of us, it’s a resounding yes . 🙋‍♀️ ...

1,042 views 18 28
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