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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 <user>.all_objects as select * from sys.all_objects where owner = upper('<user>');
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.