Start-up Error for Confluence

Question

Hi,

Does anyone know why I am getting this error during the startup of Confluence?

2016-09-27 12:11:03,611 ERROR [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] checkSchema Failed to verify schema consistency
java.lang.NullPointerException
 at com.atlassian.confluence.core.persistence.schema.hibernate.HibernateSchemaComparator.compareIndexes(HibernateSchemaComparator.java:136)
 at com.atlassian.confluence.core.persistence.schema.hibernate.HibernateSchemaComparator.compareTable(HibernateSchemaComparator.java:99)
 at com.atlassian.confluence.core.persistence.schema.hibernate.HibernateSchemaComparator.access$000(HibernateSchemaComparator.java:50)
 at com.atlassian.confluence.core.persistence.schema.hibernate.HibernateSchemaComparator$1.apply(HibernateSchemaComparator.java:83)
 at com.atlassian.confluence.core.persistence.schema.hibernate.HibernateSchemaComparator$1.apply(HibernateSchemaComparator.java:77)
 at com.google.common.collect.Iterators$8.next(Iterators.java:812)
 at com.google.common.collect.Lists.newArrayList(Lists.java:139)
 at com.google.common.collect.Lists.newArrayList(Lists.java:119)
 at com.atlassian.confluence.core.persistence.schema.hibernate.HibernateSchemaComparator.compareTables(HibernateSchemaComparator.java:76)
 at com.atlassian.confluence.core.persistence.schema.hibernate.HibernateSchemaComparator.compareSchema(HibernateSchemaComparator.java:66)
 at com.atlassian.confluence.core.persistence.schema.hibernate.HibernateSchemaComparisonService.compareExpectedWithActualSchema(HibernateSchemaComparisonService.java:53)
 at com.atlassian.confluence.core.persistence.schema.StartupSchemaChecker.checkSchema(StartupSchemaChecker.java:75)
 at com.atlassian.confluence.core.persistence.schema.StartupSchemaChecker.checkSchemaIfBuildNumbersMatch(StartupSchemaChecker.java:60)
 at com.atlassian.tenancy.api.helper.TenantAccessors$2.call(TenantAccessors.java:43)
 at com.atlassian.tenancy.api.helper.TenantAccessors$2.call(TenantAccessors.java:40)
 at com.atlassian.confluence.tenant.VolatileSingleTenantRegistry.asTenant(VolatileSingleTenantRegistry.java:53)
 at com.atlassian.tenancy.api.helper.TenantAccessors$1.apply(TenantAccessors.java:27)
 at com.atlassian.tenancy.api.helper.TenantAccessors$1.apply(TenantAccessors.java:23)
 at com.google.common.collect.Iterators$8.next(Iterators.java:812)
 at com.google.common.collect.Iterables$3.next(Iterables.java:508)
 at com.google.common.collect.Iterables$3.next(Iterables.java:501)
 at com.google.common.collect.Iterators$5.hasNext(Iterators.java:544)
 at com.google.common.collect.Iterators$8.hasNext(Iterators.java:807)
 at com.google.common.collect.Iterables$3.hasNext(Iterables.java:504)
 at com.google.common.collect.Iterators$5.hasNext(Iterators.java:543)
 at com.atlassian.tenancy.api.helper.PerTenantInitialiser.init(PerTenantInitialiser.java:41)
 at com.atlassian.confluence.core.persistence.schema.StartupSchemaChecker.runTenantInitialiser(StartupSchemaChecker.java:46)
 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:497)

Thank-you,

Cynthia

Guilherme V. · Answer

Did you setup a view for the user as stated in this article: https://confluence.atlassian.com/display/DOC/Database+Setup+for+Oracle#DatabaseSetupforOracle-Step3.SetupyourOracleuserwithschema-creationprivileges The query would be: create view .all_objects as select * from sys.all_objects where owner = upper('');

clem · Answer

Hi,

Thanks for the reply.  I'm using an Oracle database.

Do you know if the error would be serious in nature or some noise that can be ignored or recovered from?

Thank-you,

Cynthia

Guilherme V. · Answer

Hi Cynthia,
That's the method that checks the database, I mean, there's an internal task that will check the content of the tables and the columns. 
Are you using MySQL? 
Maybe this article can provide more information:https://confluence.atlassian.com/confkb/the-database-constraint-checker-722143829.html