5 Replies Latest reply on Nov 7, 2008 2:37 AM by dloebbe

Portal 2.7 with Postgres

dloebbe Sep 12, 2008 9:22 AM

Hi,

I can't get running the portal in version 2.7 (BETA1 or CR1 makes no difference) with a postgres database version 8.3.

During the initial setup after creating all necessary tables and while inserting the default content for the cms the following error occurs:

15:18:18,457 INFO [JBossCachePersistenceManager] -------------------------------------------------
15:18:18,457 INFO [JBossCachePersistenceManager] JBossCachePersistenceManager is fully loaded.....
15:18:18,457 INFO [JBossCachePersistenceManager] -------------------------------------------------
15:18:18,692 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: null
15:18:18,692 ERROR [JDBCExceptionReporter] Batch-Eintrag 0 insert into jbp_cms_version_node (NODE_ID, NODE_DATA, PK) values (deadbeef-face-babe-cafe-babecafebabe, <stream of 109 bytes>, 30) wurde abgebrochen. Rufen Sie 'getNextException' auf, um die Ursache zu erfahren.
15:18:18,692 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: 42804
15:18:18,692 ERROR [JDBCExceptionReporter] ERROR: column "node_data" is of type oid but expression is of type bytea
15:18:18,692 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
 at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
 at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
 at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
 at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222)
 at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2224)
 at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
 at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
 at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
 at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
 at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
 at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
 at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
 at org.hibernate.transaction.CacheSynchronization.beforeCompletion(CacheSynchronization.java:59)
 at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:114)
 at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:247)
 at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:86)
 at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)
 at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1389)
 at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:135)
 at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:87)
 at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.commit(ServerVMClientUserTransaction.java:140)
 at org.hibernate.transaction.JTATransaction.commit(JTATransaction.java:146)
 at org.jboss.portal.cms.hibernate.state.JBossCachePersistenceManager.store(JBossCachePersistenceManager.java:1315)
 at org.apache.jackrabbit.core.version.VersionManagerImpl.<init>(VersionManagerImpl.java:157)
 at org.apache.jackrabbit.core.RepositoryImpl.createVersionManager(RepositoryImpl.java:400)
 at org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:294)
 at org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:557)
 at org.jboss.portal.cms.impl.jcr.jackrabbit.JackrabbitJCRService.start(JackrabbitJCRService.java:107)
 at org.jboss.portal.cms.impl.jcr.JCRCMS.startJCR(JCRCMS.java:326)
 at org.jboss.portal.cms.impl.jcr.JCRCMS.startService(JCRCMS.java:291)
 at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
 at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)
 at org.jboss.portal.jems.as.system.AbstractJBossService.start(AbstractJBossService.java:73)
 at sun.reflect.GeneratedMethodAccessor25.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.portal.jems.as.system.JBossServiceModelMBean$ServiceMixin.execute(JBossServiceModelMBean.java:486)
 at org.jboss.portal.jems.as.system.JBossServiceModelMBean$ServiceMixin.startService(JBossServiceModelMBean.java:452)
 at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
 at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)
 at org.jboss.portal.jems.as.system.JBossServiceModelMBean$6.invoke(JBossServiceModelMBean.java:374)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
 at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
 at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
 at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:995)
 at $Proxy0.start(Unknown Source)
 at org.jboss.system.ServiceController.start(ServiceController.java:417)
 at org.jboss.system.ServiceController.start(ServiceController.java:435)
 at org.jboss.system.ServiceController.start(ServiceController.java:435)
 at org.jboss.system.ServiceController.start(ServiceController.java:435)
 at org.jboss.system.ServiceController.start(ServiceController.java:435)
 at org.jboss.system.ServiceController.start(ServiceController.java:435)
 at org.jboss.system.ServiceController.start(ServiceController.java:435)
 at org.jboss.system.ServiceController.start(ServiceController.java:435)
 at org.jboss.system.ServiceController.start(ServiceController.java:435)
 at org.jboss.system.ServiceController.start(ServiceController.java:435)
 at org.jboss.system.ServiceController.start(ServiceController.java:435)
 at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
 at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
 at $Proxy4.start(Unknown Source)
 at org.jboss.deployment.SARDeployer.start(SARDeployer.java:304)
 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:585)
 at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
 at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
 at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
 at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
 at $Proxy198.start(Unknown Source)
 at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:197)
 at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
 at sun.reflect.GeneratedMethodAccessor30.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
 at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
 at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
 at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
 at $Proxy9.deploy(Unknown Source)
 at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
 at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
 at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
 at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)
 at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
 at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
 at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
 at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
 at $Proxy0.start(Unknown Source)
 at org.jboss.system.ServiceController.start(ServiceController.java:417)
 at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
 at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
 at $Proxy4.start(Unknown Source)
 at org.jboss.deployment.SARDeployer.start(SARDeployer.java:304)
 at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
 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:585)
 at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
 at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
 at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
 at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
 at $Proxy5.deploy(Unknown Source)
 at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
 at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
 at org.jboss.Main.boot(Main.java:200)
 at org.jboss.Main$1.run(Main.java:508)
 at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.BatchUpdateException: Batch-Eintrag 0 insert into jbp_cms_version_node (NODE_ID, NODE_DATA, PK) values (deadbeef-face-babe-cafe-babecafebabe, <stream of 109 bytes>, 30) wurde abgebrochen. Rufen Sie 'getNextException' auf, um die Ursache zu erfahren.
 at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2537)
 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1328)
 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:351)
 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2674)
 at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:774)
 at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
 at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
 ... 155 more

The tables in the database look ok since they have the same types (oid) as in portal 2.6 (which works fine with postgres using the same VM and driver-jar postgresql-8.3-603.jdbc3.jar).

Thanks for helping, Daniel

1. Re: Portal 2.7 with Postgres

dloebbe Sep 16, 2008 4:51 AM (in response to dloebbe)

Hi all,

am I the only one with this problem or is this the wrong forum?

Thanks, Daniel
Actions

2. Re: Portal 2.7 with Postgres

sdomsta Oct 19, 2008 10:30 PM (in response to dloebbe)

I have also received this error (using PostgreSQL 8.1):
JBoss Portal Release: jboss-portal-2.7.0.CR1
Using JDBC3 library: postgresql-8.1-404.jdbc3.jar

13:18:17,744 INFO [RepositoryImpl] Starting repository...
13:18:18,488 INFO [NodeTypeRegistry] no custom node type definitions found
13:18:18,625 INFO [JBossCachePersistenceManager] Pre-loading the PersistenceManager Cache in the background (started).......
13:18:18,633 INFO [JBossCachePersistenceManager] Pre-loading the PersistenceManager Cache for/wsp_prop (finished).......
13:18:18,634 INFO [JBossCachePersistenceManager] Pre-loading the PersistenceManager Cache for/version_prop (finished).......
13:18:18,643 INFO [JBossCachePersistenceManager] Pre-loading the PersistenceManager Cache for/version_node (finished).......
13:18:18,643 INFO [JBossCachePersistenceManager] Pre-loading the PersistenceManager Cache for/wsp_ref (finished).......
13:18:18,644 INFO [JBossCachePersistenceManager] Pre-loading the PersistenceManager Cache for/wsp_node (finished).......
13:18:18,657 INFO [JBossCachePersistenceManager] Pre-loading the PersistenceManager Cache for/version_ref (finished).......
13:18:20,636 INFO [JBossCachePersistenceManager] -------------------------------------------------
13:18:20,636 INFO [JBossCachePersistenceManager] JBossCachePersistenceManager is fully loaded.....
13:18:20,636 INFO [JBossCachePersistenceManager] -------------------------------------------------
13:18:20,746 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: null
13:18:20,746 ERROR [JDBCExceptionReporter] Batch entry 0 insert into jbp_cms_version_node (NODE_ID, NODE_DATA, PK) values (deadbeef-face-babe-cafe-babecafebabe, <stream of 109 bytes>, 30) was aborted. Call getNextException to see the cause.
13:18:20,746 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: 42804
13:18:20,746 ERROR [JDBCExceptionReporter] ERROR: column "node_data" is of type oid but expression is of type bytea
13:18:20,747 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
 at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
 at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
 at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
 at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222)
 at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2224)
 at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
...

I haven't found a solution to this yet.

3. Re: Portal 2.7 with Postgres

etdias Nov 6, 2008 3:24 PM (in response to dloebbe)

I' am having the same problem... You are not alone...
Actions
4. Re: Portal 2.7 with Postgres

theute Nov 6, 2008 4:05 PM (in response to dloebbe)

Did you try on 2.7.0.GA ?
Actions
5. Re: Portal 2.7 with Postgres

dloebbe Nov 7, 2008 2:37 AM (in response to dloebbe)

Not yet. We will try it next week.

Thank for reply.

Bye, Daniel
Actions

Go to original post