Cannot install MyCoRe with Postgres 9.6

Description

Trying to set up my development machine with current Postgres 9.6 Database server and current Postgres JDBC driver I get the following exception:

It looks like some internal Postgres database tables have changed.

[java] 2017-08-17T11:14:49,717 ERROR SqlExceptionHelper: FEHLER: Spalte am.amcanorder existiert nicht
[java] Position: 427
[java] 2017-08-17T11:14:49,719 ERROR MCRJPABootstrapper: Could not initialize JPA. Database access is disabled in this session.
[java] javax.persistence.PersistenceException: [PersistenceUnit: MyCoRe] Unable to build Hibernate SessionFactory
[java] at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.persistenceException(EntityManagerFactoryBuilderImpl.java:961)
[java] at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:891)
[java] at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:58)
[java] at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:55)
[java] at org.mycore.backend.jpa.MCRJPABootstrapper.initializeJPA(MCRJPABootstrapper.java:74)
[java] at org.mycore.backend.jpa.MCRJPABootstrapper.initializeJPA(MCRJPABootstrapper.java:70)
[java] at org.mycore.backend.jpa.MCRJPABootstrapper.startUp(MCRJPABootstrapper.java:47)
[java] at org.mycore.common.events.MCRStartupHandler.startExecutable(MCRStartupHandler.java:91)
[java] at org.mycore.common.events.MCRStartupHandler.lambda$startUp$1(MCRStartupHandler.java:85)
[java] at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
[java] at java.util.stream.SortedOps$SizedRefSortingSink.end(SortedOps.java:352)
[java] at java.util.stream.Sink$ChainedReference.end(Sink.java:258)
[java] at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:482)
[java] at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471)
[java] at java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
[java] at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
[java] at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
[java] at java.util.stream.ReferencePipeline.forEachOrdered(ReferencePipeline.java:423)
[java] at org.mycore.common.events.MCRStartupHandler.startUp(MCRStartupHandler.java:85)
[java] at org.mycore.frontend.cli.MCRCommandLineInterface.main(MCRCommandLineInterface.java:87)
[java] Caused by: org.hibernate.exception.SQLGrammarException: Error accessing index information: rosdok.MCRCategory
[java] at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:106)
[java] at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
[java] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
[java] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
[java] at org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl.convertSQLException(InformationExtractorJdbcDatabaseMetaDataImpl.java:97)
[java] at org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl.getIndexes(InformationExtractorJdbcDatabaseMetaDataImpl.java:613)
[java] at org.hibernate.tool.schema.extract.internal.TableInformationImpl.indexes(TableInformationImpl.java:110)
[java] at org.hibernate.tool.schema.extract.internal.TableInformationImpl.getIndex(TableInformationImpl.java:121)
[java] at org.hibernate.tool.schema.internal.SchemaMigratorImpl.findMatchingIndex(SchemaMigratorImpl.java:415)
[java] at org.hibernate.tool.schema.internal.SchemaMigratorImpl.applyIndexes(SchemaMigratorImpl.java:398)
[java] at org.hibernate.tool.schema.internal.SchemaMigratorImpl.performMigration(SchemaMigratorImpl.java:277)
[java] at org.hibernate.tool.schema.internal.SchemaMigratorImpl.doMigration(SchemaMigratorImpl.java:137)
[java] at org.hibernate.tool.schema.internal.SchemaMigratorImpl.doMigration(SchemaMigratorImpl.java:110)
[java] at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:176)
[java] at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:65)
[java] at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:308)
[java] at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:476)
[java] at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:888)
[java] ... 18 more
[java] Caused by: org.postgresql.util.PSQLException: FEHLER: Spalte am.amcanorder existiert nicht
[java] Position: 427
[java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2284)
[java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2003)
[java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:200)
[java] at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424)
[java] at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:321)
[java] at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:284)
[java] at org.postgresql.jdbc.PgDatabaseMetaData.getIndexInfo(PgDatabaseMetaData.java:2948)
[java] at org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl.getIndexes(InformationExtractorJdbcDatabaseMetaDataImpl.java:571)
[java] ... 30 more

Environment

Postgres 9.6

Assignee

Robert Stephan

Reporter

Robert Stephan

Labels

None

URL

None

External issue ID

None

Components

Fix versions

Affects versions

Priority

High
Configure