Confluence is getting slow after installation.

Question

I have installed confluence 5.5.2 as a Service with the Microsoft SQL server 2012 database on windows server 2012. After installation Confluence gets very slow. I have attached the LOG file, have lots of error messages. [java.lang.RuntimeException: Active Objects failed to initalize for bundle com.atlassian.webhooks.atlassian-webhooks-plugin] java.lang.RuntimeException: Active Objects failed to initalize for bundle com.atlassian.webhooks.atlassian-webhooks-plugin at com.atlassian.event.internal.SingleParameterMethodListenerInvoker.invoke(SingleParameterMethodListenerInvoker.java:54) at com.atlassian.event.internal.AsynchronousAbleEventDispatcher$1$1.run(AsynchronousAbleEventDispatcher.java:48) at com.google.common.util.concurrent.MoreExecutors$SameThreadExecutorService.execute(MoreExecutors.java:253) at com.atlassian.event.internal.AsynchronousAbleEventDispatcher.dispatch(AsynchronousAbleEventDispatcher.java:107) at com.atlassian.event.internal.EventPublisherImpl.invokeListeners(EventPublisherImpl.java:160) at com.atlassian.event.internal.EventPublisherImpl.publish(EventPublisherImpl.java:79) at sun.reflect.GeneratedMethodAccessor638.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.atlassian.plugin.osgi.hostcomponents.impl.DefaultComponentRegistrar$ContextClassLoaderSettingInvocationHandler.invoke(DefaultComponentRegistrar.java:129) at com.sun.proxy.$Proxy277.publish(Unknown Source) at sun.reflect.GeneratedMethodAccessor638.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:58) at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:62) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:56) at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:39) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.osgi.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy455.publish(Unknown Source) at com.atlassian.confluence.cache.events.CacheStatisticsEventPublisher.publishStatistics(CacheStatisticsEventPublisher.java:56) at com.atlassian.confluence.cache.events.CacheStatisticsEventPublisher.access$000(CacheStatisticsEventPublisher.java:28) at com.atlassian.confluence.cache.events.CacheStatisticsEventPublisher$1.run(CacheStatisticsEventPublisher.java:100) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source) at java.util.concurrent.FutureTask.runAndReset(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: com.atlassian.activeobjects.internal.ActiveObjectsInitException: Active Objects failed to initalize for bundle com.atlassian.webhooks.atlassian-webhooks-plugin at com.atlassian.activeobjects.osgi.ActiveObjectsServiceFactory$5.apply(ActiveObjectsServiceFactory.java:207) at com.atlassian.activeobjects.osgi.ActiveObjectsServiceFactory$5.apply(ActiveObjectsServiceFactory.java:187) at com.atlassian.util.concurrent.Promises$Of$2.apply(Promises.java:259) at com.atlassian.util.concurrent.Promises$Of$2.apply(Promises.java:256) at com.atlassian.util.concurrent.Promises$2.onFailure(Promises.java:162) at com.google.common.util.concurrent.Futures$7.run(Futures.java:1100) at com.google.common.util.concurrent.MoreExecutors$SameThreadExecutorService.execute(MoreExecutors.java:253) at com.google.common.util.concurrent.ExecutionList$RunnableExecutorPair.execute(ExecutionList.java:161) at com.google.common.util.concurrent.ExecutionList.execute(ExecutionList.java:134) at com.google.common.util.concurrent.JdkFutureAdapters$ListenableFutureAdapter$1.run(JdkFutureAdapters.java:152) ... 3 more Caused by: java.util.concurrent.ExecutionException: com.atlassian.activeobjects.osgi.NoServicesFoundException: Was expecting one service reference for interface and filter <(com.atlassian.plugin.key=com.atlassian.webhooks.atlassian-webhooks-plugin)>. Got null ! You should check whether an ActiveObjectsPluginException was thrown at startup. It will give you more information about potential errors in the module in your atlassian-plugin.xml. at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source) at java.util.concurrent.FutureTask.get(Unknown Source) at com.atlassian.activeobjects.osgi.ActiveObjectsServiceFactory$5.apply(ActiveObjectsServiceFactory.java:197) ... 12 more Caused by: com.atlassian.activeobjects.osgi.NoServicesFoundException: Was expecting one service reference for interface and filter <(com.atlassian.plugin.key=com.atlassian.webhooks.atlassian-webhooks-plugin)>. Got null ! You should check whether an ActiveObjectsPluginException was thrown at startup. It will give you more information about potential errors in the module in your atlassian-plugin.xml. at com.atlassian.activeobjects.osgi.OsgiServiceUtilsImpl.getServiceReference(OsgiServiceUtilsImpl.java:50) at com.atlassian.activeobjects.osgi.OsgiServiceUtilsImpl.getService(OsgiServiceUtilsImpl.java:41) at com.atlassian.activeobjects.osgi.AOConfigurationServiceProviderImpl.getConfiguration(AOConfigurationServiceProviderImpl.java:123) at com.atlassian.activeobjects.osgi.AOConfigurationServiceProviderImpl.getAndWait(AOConfigurationServiceProviderImpl.java:85) at com.atlassian.activeobjects.osgi.ActiveObjectsServiceFactory$6.call(ActiveObjectsServiceFactory.java:223) at com.atlassian.activeobjects.osgi.ActiveObjectsServiceFactory$6.call(ActiveObjectsServiceFactory.java:216) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) ... 3 more

Siddheshwar mhetre_l4zeyg · Answer

Hello William,

Ya, the problem was the database Schema rights. I have given full rights to the owner, so now the Confluence get faster without any errors.

Thanks a lot... :)

Cheers,

Sid

Giuliano C. · Answer

Heya, Other suggestion here, as for the configuration of the DB is that we could have been facing some issue related to the usage of the Webhooks plugin in Confluence: Caused by: java.util.concurrent.ExecutionException: com.atlassian.activeobjects.osgi.NoServicesFoundException: Was expecting one service reference for interface and filter <(com.atlassian.plugin.key=com.atlassian.webhooks.atlassian-webhooks-plugin)>. Got null ! You should check whether an ActiveObjectsPluginException was thrown at startup. It will give you more information about potential errors in the module in your atlassian-plugin.xml. So, for that, can you check if your instance will get slow if you also run Confluence under Plugin Safe Mode? Cheers, Giu

William Zanchet · Answer

It seems that Confluence is having a hard time to create the AO tables (Active Objects), can you please make sure that the user that is owner of Confluence's schema has the full rights? Also, can see if your database schema is under the following recommendations?
https://confluence.atlassian.com/display/DOC/Database+Setup+for+SQL+Server

We need to make sure that we have the proper database schema set, like collation.

Cheers,
WZ