It seems to be a bug in the PostgreSQL 9.0 JDBC drivers: http://archives.postgresql.org/pgsql-jdbc/2010-09/msg00048.php
Florent On Mon, Dec 13, 2010 at 11:07 AM, Oliver Rojo <[email protected]> wrote: > Hi guys, > > why I'm having below error message? I'm using nuxeo-5.4.0 with postgres-9.0 > on debian. > > 18:01:31,662 INFO [StaleObjectLogConfigurer] stale object exceptions will > be hidden from logging > 18:01:31,666 INFO [JbpmConfiguration] using jbpm configuration resource > 'jbpm.cfg.xml' > 18:01:33,377 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: 42501 > 18:01:33,378 ERROR [JDBCExceptionReporter] ERROR: argument to pg_get_expr() > must come from system catalogs > 18:01:33,421 ERROR [SchemaUpdate] could not complete schema update > org.hibernate.exception. > SQLGrammarException: could not get table metadata: JBPM_ACTION > 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.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:105) > at > org.nuxeo.ecm.platform.jbpm.core.service.JbpmComponent.frameworkEvent(JbpmComponent.java:240) > at > org.nuxeo.osgi.OSGiAdapter.fireFrameworkEvent(OSGiAdapter.java:203) > at > org.nuxeo.osgi.application.loader.FrameworkLoader.doStart(FrameworkLoader.java:201) > at > org.nuxeo.osgi.application.loader.FrameworkLoader.start(FrameworkLoader.java:136) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at > org.nuxeo.runtime.jboss.deployer.Bootstrap.invokeStart(Bootstrap.java:130) > at > org.nuxeo.runtime.jboss.deployer.Bootstrap.doStart(Bootstrap.java:113) > at > org.nuxeo.runtime.jboss.deployer.Bootstrap.startNuxeo(Bootstrap.java:93) > at > org.nuxeo.runtime.jboss.deployer.NuxeoLauncher.doDeploy(NuxeoLauncher.java:107) > at > org.nuxeo.runtime.jboss.deployer.AbstractNuxeoDeployer.deploy(AbstractNuxeoDeployer.java:39) > at > org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171) > at > org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439) > at > org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157) > at > org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098) > at > org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348) > at > org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631) > at > org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934) > at > org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082) > at > org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984) > at > org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822) > at > org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553) > at > org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781) > at > org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:702) > at > org.jboss.system.server.profileservice.repository.MainDeployerAdapter.process(MainDeployerAdapter.java:117) > at > org.jboss.system.server.profileservice.repository.ProfileDeployAction.install(ProfileDeployAction.java:70) > at > org.jboss.system.server.profileservice.repository.AbstractProfileAction.install(AbstractProfileAction.java:53) > at > org.jboss.system.server.profileservice.repository.AbstractProfileService.install(AbstractProfileService.java:361) > at > org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348) > at > org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631) > at > org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934) > at > org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082) > at > org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984) > at > org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822) > at > org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553) > at > org.jboss.system.server.profileservice.repository.AbstractProfileService.activateProfile(AbstractProfileService.java:306) > at > org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:271) > at > org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:461) > at org.jboss.Main.boot(Main.java:221) > at org.jboss.Main$1.run(Main.java:556) > at java.lang.Thread.run(Thread.java:619) > Caused by: org.postgresql.util.PSQLException: ERROR: argument to > pg_get_expr() must come from system catalogs > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254) > at > org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getIndexInfo(AbstractJdbc2DatabaseMetaData.java:4023) > at > org.hibernate.tool.hbm2ddl.TableMetadata.initIndexes(TableMetadata.java:167) > at > org.hibernate.tool.hbm2ddl.TableMetadata.<init>(TableMetadata.java:61) > at > org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:113) > ... 48 more > 18:01:34,051 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on > http-0.0.0.0-8081 > 18:01:34,089 INFO [AjpProtocol] Starting Coyote AJP/1.3 on ajp-0.0.0.0-8009 > > Oliver > _______________________________________________ > ECM mailing list > [email protected] > http://lists.nuxeo.com/mailman/listinfo/ecm > To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm > > -- Florent Guillaume, Director of R&D, Nuxeo Open Source, Java EE based, Enterprise Content Management (ECM) http://www.nuxeo.com http://www.nuxeo.org +33 1 40 33 79 87 _______________________________________________ ECM mailing list [email protected] http://lists.nuxeo.com/mailman/listinfo/ecm To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
