It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Impossible to create a new space

Lazom Dzemaili Mar 14, 2019

Hello,

I have the same problem as this one : Confluence Server / CONFSERVER-57943

The workaround do not work in my case.

Please do not end my support until this Jira is resolved.

Regards

2 answers

1 accepted

0 votes
Answer accepted
Lazom Dzemaili Mar 29, 2019

Resolved.

This was a problem with the sql_mode parameter in mysql.

The value was set to 'NO_AUTO_VALUE_ON_ZERO'. This is not good.

I modified the my.cnf configuration file of mysql, I added : sql_mode=""

Restart mysql server

Restart Confluence and it is OK!

0 votes
Nic Brough [Adaptavist] Community Leader Mar 14, 2019

You'll need to explain where the work-around is failing for you?

Lazom Dzemaili Mar 14, 2019

I followed the 4 steps of the workaround but it did not resolved the problem, it is still impossible to create a new space. I get exactly the same error as previously : "unknown server error".

Other informations :

This problem occurs after an update from Confluence 6.3.1 to 6.14.1

I use MySql version 5.7.25-0ubuntu0.16.04.2.

Nic Brough [Adaptavist] Community Leader Mar 14, 2019

Ok, with errors at that level, you will need to be looking at the application logs to see what the internal errors are.

Lazom Dzemaili Mar 14, 2019 • edited Mar 29, 2019

I get the same kind of error as in the Jira :

in /var/atlassian/application-data/confluence/logs/atlassian-confluence.log :

2019-03-14 10:45:46,214 WARN [http-nio-8090-exec-4] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:
->[PluginReadWriteTx]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #1592074488)
-- referer: http://XX.XX.XX.XX:8090/ | url: /rest/create-dialog/1.0/space-blueprint/dialog/web-items | traceId: 6150904283a2a164 | userName: admin

Nic Brough [Adaptavist] Community Leader Mar 14, 2019

That's consistent with a bug - have a look at https://jira.atlassian.com/browse/CONFSERVER-56094

Lazom Dzemaili Mar 14, 2019

I tried to set the correct sequence ids in 2 tables with this kind of command :

alter table AO_88BB94_BATCH_NOTIFICATION AUTO_INCREMENT=1

I set the correct sequence id on 2 tables : AO_88BB94_BATCH_NOTIFICATION and AO_187CCC_SIDEBAR_LINK.

But I'm still getting the error.

Lazom Dzemaili Mar 14, 2019

I changed the logging level :

Please find below the NullPointerException. This is the error thrown just after I tried to create a new space.

Lazom Dzemaili Mar 14, 2019 • edited Mar 29, 2019
2019-03-14 18:19:26,912 TRACE [http-nio-8090-exec-1] [confluence.impl.vcache.VCacheRequestContextManager] initRequestContext Thread-local request context already present, skipping new context creation
2019-03-14 18:19:26,913 DEBUG [http-nio-8090-exec-1] [atlassian.confluence.setup.ConfluenceListableBeanFactory] doGetBean Returning cached instance of singleton bean 'tenantedTransactionManager'
2019-03-14 18:19:26,913 TRACE [http-nio-8090-exec-1] [springframework.transaction.support.TransactionSynchronizationManager] getResource Retrieved value [org.springframework.orm.hibernate.SessionHolder@55a87ce9] for key [com.atlassian.hibernate.adapter.bridge.factory.SessionFactoryV2orV5BridgeProxy@519d3f2b] bound to thread [http-nio-8090-exec-1]
2019-03-14 18:19:26,914 DEBUG [http-nio-8090-exec-1] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doGetTransaction Found thread-bound Session [com.atlassian.hibernate.adapter.adapters.session.SessionV2Adapter@4992b0a7] for Hibernate transaction
2019-03-14 18:19:26,915 DEBUG [http-nio-8090-exec-1] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] getTransaction Creating new transaction with name [PluginReadWriteTx]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT
2019-03-14 18:19:26,916 DEBUG [http-nio-8090-exec-1] [engine.transaction.internal.TransactionImpl] begin begin
2019-03-14 18:19:26,917 TRACE [http-nio-8090-exec-1] [resource.jdbc.internal.AbstractLogicalConnectionImplementor] begin Preparing to begin transaction via JDBC Connection.setAutoCommit(false)
2019-03-14 18:19:26,918 TRACE [http-nio-8090-exec-1] [resource.jdbc.internal.AbstractLogicalConnectionImplementor] begin Transaction begun via JDBC Connection.setAutoCommit(false)
2019-03-14 18:19:26,919 TRACE [http-nio-8090-exec-1] [backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl] afterBeginCallback ResourceLocalTransactionCoordinatorImpl#afterBeginCallback
2019-03-14 18:19:26,920 TRACE [http-nio-8090-exec-1] [springframework.transaction.support.TransactionSynchronizationManager] getResource Retrieved value [org.springframework.orm.hibernate.SessionHolder@55a87ce9] for key [com.atlassian.hibernate.adapter.bridge.factory.SessionFactoryV2orV5BridgeProxy@519d3f2b] bound to thread [http-nio-8090-exec-1]
2019-03-14 18:19:26,920 DEBUG [http-nio-8090-exec-1] [atlassian.confluence.setup.ConfluenceListableBeanFactory] doGetBean Returning cached instance of singleton bean 'tenantedLocalSessionFactoryBean5'
2019-03-14 18:19:26,921 TRACE [http-nio-8090-exec-1] [springframework.transaction.support.TransactionSynchronizationManager] initSynchronization Initializing transaction synchronization
2019-03-14 18:19:26,922 TRACE [http-nio-8090-exec-1] [springframework.transaction.support.TransactionSynchronizationManager] getResource Retrieved value [org.springframework.orm.hibernate.SessionHolder@55a87ce9] for key [com.atlassian.hibernate.adapter.bridge.factory.SessionFactoryV2orV5BridgeProxy@519d3f2b] bound to thread [http-nio-8090-exec-1]
2019-03-14 18:19:26,923 DEBUG [http-nio-8090-exec-1] [net.java.ao.sql] onSql INSERT INTO AO_54C900_C_TEMPLATE_REF (ID) VALUES (DEFAULT)
2019-03-14 18:19:26,926 DEBUG [http-nio-8090-exec-1] [springframework.transaction.support.TransactionTemplate] rollbackOnException Initiating transaction rollback on application exception
-- referer: http://XX.XX.XX.XX:8090/display/~admin/Installation+WikiQuizz | url: /rest/create-dialog/1.0/space-blueprint/dialog/web-items | traceId: 2340fe8caa829780 | userName: admin
java.lang.NullPointerException
at net.java.ao.EntityManager.create(EntityManager.java:375)
at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.create(EntityManagedActiveObjects.java:92)
at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects.create(TenantAwareActiveObjects.java:266)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56)
at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70)
at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy1311.create(Unknown Source)
at com.atlassian.confluence.plugins.createcontent.impl.HelperAoManager.createWithUuid(HelperAoManager.java:28)
at com.atlassian.confluence.plugins.createcontent.impl.DefaultContentTemplateRefManager.internalCreateAo(DefaultContentTemplateRefManager.java:26)
at com.atlassian.confluence.plugins.createcontent.impl.DefaultContentTemplateRefManager.internalCreateAo(DefaultContentTemplateRefManager.java:16)
at com.atlassian.confluence.plugins.createcontent.impl.AbstractAoManager.lambda$createAo$3(AbstractAoManager.java:118)
at com.atlassian.sal.core.transaction.HostContextTransactionTemplate$1.doInTransaction(HostContextTransactionTemplate.java:21)
at com.atlassian.sal.spring.component.SpringHostContextAccessor$1.doInTransaction(SpringHostContextAccessor.java:71)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)
Lazom Dzemaili Mar 14, 2019 • edited Mar 29, 2019

-

Lazom Dzemaili Mar 14, 2019 • edited Mar 29, 2019

-

Lazom Dzemaili Mar 14, 2019

I tried to post several times the logs but at each time, the message is deleted, how can I send you the logs ?

Lazom Dzemaili Mar 14, 2019 • edited Mar 29, 2019

-

Lazom Dzemaili Mar 14, 2019 • edited Mar 29, 2019

-

Nic Brough [Adaptavist] Community Leader Mar 14, 2019

Ok, this is one that definitely needs to go to Atlassian support - they should be contactable at https://support.atlassian.com/contact

Lazom Dzemaili Mar 14, 2019

I used this url (https://support.atlassian.com/contact) to create the current issue that we are on here.

Do you mean that I have to create a new issue ?

Nic Brough [Adaptavist] Community Leader Mar 14, 2019

Sorry, my comments crossed over with yours.  I typed half an answer on a train, finishing it later - I missed your comment about "the message is deleted".  I have removed it from spam (the 'bots don't like mass blocks of logs a lot, and once you post one, really do not like repeated attempts!).  Will take a look when it re-appears here.

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Confluence

Confluence CVEs and common questions

Two vulnerabilities have been published for Confluence Server and Data Center recently: March 20, 2019 CVE-2019-3395 / CVE-2019-3396 April 17, 2019 CVE-2019-3398 The goal of this article is...

945 views 0 19
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