thanks florent :D On Mon, Dec 13, 2010 at 2:29 AM, Florent Guillaume <[email protected]> wrote:
> 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
