https://connect.hyland.com/t5/nuxeo-forum/error-when-use-elasticsearch/m-p/322140#M9141 <P>Hi,</P> Thu, 26 Jan 2017 12:15:10 GMT JORGE_HERNANDEZ 2017-01-26T12:15:10Z https://connect.hyland.com/t5/nuxeo-forum/error-when-use-elasticsearch/m-p/322138#M9139 <P>Hi, I have Nuxeo 8.10 and use PostgreSQL 9.5 and Elasticsearch 2.3.5.</P> <P>Nuxeo works fine but in server.log I watch this error:</P> <P>2017-01-26 11:07:31,138 ERROR [localhost-startStop-1] [org.hibernate.util.JDBCExceptionReporter] ERROR: column t1.tgisconstraint does not exist Hint: Perhaps you meant to reference the column "t1.tgconstraint". Position: 581 2017-01-26 11:07:31,139 ERROR [localhost-startStop-1] [org.hibernate.tool.hbm2ddl.SchemaUpdate] could not complete schema update org.hibernate.exception.SQLGrammarException: could not get table metadata: NXP_UIDSEQ at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52) at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:128) at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:995) at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:187) at org.hibernate.impl.SessionFactoryImpl.<INIT>(SessionFactoryImpl.java:356) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1341) at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867) at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669) at org.hibernate.ejb.Ejb3Configuration.createEntityManagerFactory(Ejb3Configuration.java:646) at org.nuxeo.ecm.core.persistence.HibernateConfiguration.createEntityManagerFactory(HibernateConfiguration.java:160) at org.nuxeo.ecm.core.persistence.HibernateConfiguration.getFactory(HibernateConfiguration.java:151) at org.nuxeo.ecm.core.persistence.HibernateConfiguration.getFactory(HibernateConfiguration.java:201) at org.nuxeo.ecm.core.persistence.PersistenceProvider.openPersistenceUnit(PersistenceProvider.java:51) at org.nuxeo.ecm.core.persistence.PersistenceComponent.applicationStarted(PersistenceComponent.java:84) at org.nuxeo.runtime.model.impl.RegistrationInfoImpl.notifyApplicationStarted(RegistrationInfoImpl.java:332) at org.nuxeo.runtime.osgi.OSGiRuntimeService.notifyComponentsOnStarted(OSGiRuntimeService.java:487) at org.nuxeo.runtime.osgi.OSGiRuntimeService.fireApplicationStarted(OSGiRuntimeService.java:523) at org.nuxeo.runtime.api.ServicePassivator$Waiter.proceed(ServicePassivator.java:415) at org.nuxeo.runtime.api.ServicePassivator.proceed(ServicePassivator.java:83) at org.nuxeo.runtime.osgi.OSGiRuntimeService.frameworkEvent(OSGiRuntimeService.java:535) at org.nuxeo.osgi.OSGiAdapter.fireFrameworkEvent(OSGiAdapter.java:232) at org.nuxeo.osgi.application.loader.FrameworkLoader.doStart(FrameworkLoader.java:241) at org.nuxeo.osgi.application.loader.FrameworkLoader.start(FrameworkLoader.java:125) at org.nuxeo.runtime.deployment.NuxeoStarter.start(NuxeoStarter.java:120) at org.nuxeo.runtime.deployment.NuxeoStarter.contextInitialized(NuxeoStarter.java:93) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5068) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5584) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:875) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:679) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1966) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: org.postgresql.util.PSQLException: ERROR: column t1.tgisconstraint does not exist Hint: Perhaps you meant to reference the column "t1.tgconstraint". Position: 581 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:303) at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:289) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:266) at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:233) at org.postgresql.jdbc.PgDatabaseMetaData.getImportedExportedKeys(PgDatabaseMetaData.java:2573) at org.postgresql.jdbc.PgDatabaseMetaData.getImportedKeys(PgDatabaseMetaData.java:2717) at org.tranql.connector.jdbc.DatabaseMetaDataHandle.getImportedKeys(DatabaseMetaDataHandle.java:110) at org.hibernate.tool.hbm2ddl.TableMetadata.initForeignKeys(TableMetadata.java:155) at org.hibernate.tool.hbm2ddl.TableMetadata.<INIT>(TableMetadata.java:60) at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:113) ... 36 more 2017-01-26 11:07:31,575 WARN [localhost-startStop-1] [org.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: 42703 2017-01-26 11:07:31,576 ERROR [localhost-startStop-1] [org.hibernate.util.JDBCExceptionReporter] ERROR: column t1.tgisconstraint does not exist Hint: Perhaps you meant to reference the column "t1.tgconstraint". Position: 581 2017-01-26 11:07:31,576 ERROR [localhost-startStop-1] [org.hibernate.tool.hbm2ddl.SchemaUpdate] could not complete schema update org.hibernate.exception.SQLGrammarException: could not get table metadata: NXP_LOGS at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52) at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:128) at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:995) at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:187) at org.hibernate.impl.SessionFactoryImpl.<INIT>(SessionFactoryImpl.java:356) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1341) at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867) at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669) at org.hibernate.ejb.Ejb3Configuration.createEntityManagerFactory(Ejb3Configuration.java:646) at org.nuxeo.ecm.core.persistence.HibernateConfiguration.createEntityManagerFactory(HibernateConfiguration.java:160) at org.nuxeo.ecm.core.persistence.HibernateConfiguration.getFactory(HibernateConfiguration.java:151) at org.nuxeo.ecm.core.persistence.HibernateConfiguration.getFactory(HibernateConfiguration.java:201) at org.nuxeo.ecm.core.persistence.PersistenceProvider.openPersistenceUnit(PersistenceProvider.java:51) at org.nuxeo.ecm.core.persistence.PersistenceComponent.applicationStarted(PersistenceComponent.java:84) at org.nuxeo.runtime.model.impl.RegistrationInfoImpl.notifyApplicationStarted(RegistrationInfoImpl.java:332) at org.nuxeo.runtime.osgi.OSGiRuntimeService.notifyComponentsOnStarted(OSGiRuntimeService.java:487) at org.nuxeo.runtime.osgi.OSGiRuntimeService.fireApplicationStarted(OSGiRuntimeService.java:523) at org.nuxeo.runtime.api.ServicePassivator$Waiter.proceed(ServicePassivator.java:415) at org.nuxeo.runtime.api.ServicePassivator.proceed(ServicePassivator.java:83) at org.nuxeo.runtime.osgi.OSGiRuntimeService.frameworkEvent(OSGiRuntimeService.java:535) at org.nuxeo.osgi.OSGiAdapter.fireFrameworkEvent(OSGiAdapter.java:232) at org.nuxeo.osgi.application.loader.FrameworkLoader.doStart(FrameworkLoader.java:241) at org.nuxeo.osgi.application.loader.FrameworkLoader.start(FrameworkLoader.java:125) at org.nuxeo.runtime.deployment.NuxeoStarter.start(NuxeoStarter.java:120) at org.nuxeo.runtime.deployment.NuxeoStarter.contextInitialized(NuxeoStarter.java:93) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5068) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5584) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:875) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:679) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1966) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: org.postgresql.util.PSQLException: ERROR: column t1.tgisconstraint does not exist Hint: Perhaps you meant to reference the column "t1.tgconstraint". Position: 581 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:303) at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:289) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:266) at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:233) at org.postgresql.jdbc.PgDatabaseMetaData.getImportedExportedKeys(PgDatabaseMetaData.java:2573) at org.postgresql.jdbc.PgDatabaseMetaData.getImportedKeys(PgDatabaseMetaData.java:2717) at org.tranql.connector.jdbc.DatabaseMetaDataHandle.getImportedKeys(DatabaseMetaDataHandle.java:110) at org.hibernate.tool.hbm2ddl.TableMetadata.initForeignKeys(TableMetadata.java:155) at org.hibernate.tool.hbm2ddl.TableMetadata.<INIT>(TableMetadata.java:60) at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:113) ... 36 more</INIT></INIT></INIT></INIT></P> <P>This happened since I connected Nuxeo with external elasticsearch, is it normal?</P> Thu, 26 Jan 2017 10:32:27 GMT https://connect.hyland.com/t5/nuxeo-forum/error-when-use-elasticsearch/m-p/322138#M9139 JORGE_HERNANDEZ 2017-01-26T10:32:27Z https://connect.hyland.com/t5/nuxeo-forum/error-when-use-elasticsearch/m-p/322139#M9140 <P>"ERROR: column t1.tgisconstraint does not exist" is a symptom of a very old PostgreSQL JDBC driver (older than the one we ship with Nuxeo 8.10). Please check your driver version.</P> Thu, 26 Jan 2017 11:40:58 GMT https://connect.hyland.com/t5/nuxeo-forum/error-when-use-elasticsearch/m-p/322139#M9140 Florent_Guillau 2017-01-26T11:40:58Z https://connect.hyland.com/t5/nuxeo-forum/error-when-use-elasticsearch/m-p/322140#M9141 <P>Hi,</P> Thu, 26 Jan 2017 12:15:10 GMT https://connect.hyland.com/t5/nuxeo-forum/error-when-use-elasticsearch/m-p/322140#M9141 JORGE_HERNANDEZ 2017-01-26T12:15:10Z https://connect.hyland.com/t5/nuxeo-forum/error-when-use-elasticsearch/m-p/322141#M9142 <P>(see comment on original question)</P> Thu, 26 Jan 2017 12:23:21 GMT https://connect.hyland.com/t5/nuxeo-forum/error-when-use-elasticsearch/m-p/322141#M9142 JORGE_HERNANDEZ 2017-01-26T12:23:21Z https://connect.hyland.com/t5/nuxeo-forum/error-when-use-elasticsearch/m-p/322142#M9143 <P>Were you able to solve this Jorge.</P> Mon, 09 Sep 2019 12:58:04 GMT https://connect.hyland.com/t5/nuxeo-forum/error-when-use-elasticsearch/m-p/322142#M9143 Ganesh_S 2019-09-09T12:58:04Z