Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Won't Fix
    • Affects Version/s: 2017.06.0
    • Fix Version/s: 2018.05, 2017.06.0.1
    • Component/s: mycore-base
    • Labels:
      None
    • Environment:

      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

        Attachments

          Activity

            People

            • Assignee:
              mcrsteph Robert Stephan
              Reporter:
              mcrsteph Robert Stephan
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: