Impossible to create a new space

Lazom Dzemaili Moz Technologie March 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 Moz Technologie March 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
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 14, 2019

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

Lazom Dzemaili Moz Technologie March 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
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 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 Moz Technologie March 14, 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
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 14, 2019

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

Lazom Dzemaili Moz Technologie March 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 Moz Technologie March 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 Moz Technologie March 14, 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 Moz Technologie March 14, 2019

-

Lazom Dzemaili Moz Technologie March 14, 2019

-

Lazom Dzemaili Moz Technologie March 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 Moz Technologie March 14, 2019

-

Lazom Dzemaili Moz Technologie March 14, 2019

-

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 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 Moz Technologie March 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
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 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
TAGS
AUG Leaders

Atlassian Community Events