Re: [bonita] Re : [exoplatform] Exo/Bonita error (PostgreSQL data index

Hi Gena,

It looks like Guillaume found something weird. I'm not sure if you glanced at his post in the eXo mailing list. He's trying to make eXo-Bonita running with PostgreSQL 8.1. He found the following exception when a business process is being deployed. The JCR is being accessed, to store the process definition file:

javax.jcr.InvalidItemStateException: [production] Parent not found (may be deleted by other session) for PROPERTY []:1[h
ttp://www.jcp.org/jcr/1.0]system:1[http://www.exoplatform.com/jcr/exo/1.0]ecm:1[]business processes:1[]content-validatio
n:1[]processdefinition.xpdl:1[http://www.jcp.org/jcr/1.0]content:1[http://www.jcp.org/jcr/1.0]data:1 3391b517527a8fa700f
ddbdb84959606. Cause: ERROR: index row size 2960 exceeds btree maximum, 2713: ERROR: index row size 2960 exceeds btree m
aximum, 2713: ERROR: index row size 2960 exceeds btree maximum, 2713
        at org.exoplatform.services.jcr.impl.storage.jdbc.JDBCStorageConnection.handleAddSQLException(JDBCStorageConnect
ion.java:184)
        at org.exoplatform.services.jcr.impl.storage.jdbc.JDBCStorageConnection.add(JDBCStorageConnection.java:296)
        at org.exoplatform.services.jcr.impl.dataflow.persistent.WorkspaceDataManager.doAdd(WorkspaceDataManager.java:34
8)
        at org.exoplatform.services.jcr.impl.dataflow.persistent.WorkspaceDataManager.save(WorkspaceDataManager.java:91)

        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.picocontainer.defaults.LifecycleVisitor.traverse(LifecycleVisitor.java:75)
        at org.picocontainer.defaults.LifecycleVisitor.start(LifecycleVisitor.java:113)
        at org.picocontainer.defaults.DefaultPicoContainer.start(DefaultPicoContainer.java:369)
        at org.exoplatform.container.PortalContainer.start(PortalContainer.java:83)
        at org.exoplatform.container.RootContainer.createPortalContainer(RootContainer.java:97)
        at org.exoplatform.portal.launcher.PortalContextListener.contextInitialized(PortalContextListener.java:44)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3727)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4162)
        at org.objectweb.jonas.web.catalina55.JOnASStandardContext.start(JOnASStandardContext.java:252)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
        at org.apache.catalina.core.ContainerBase.access$000(ContainerBase.java:121)
        at org.apache.catalina.core.ContainerBase$PrivilegedAddChild.run(ContainerBase.java:143)
        at java.security.AccessController.doPrivileged(Native Method)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:737)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
        at org.objectweb.jonas.web.catalina55.CatalinaJWebContainerServiceImpl.doRegisterWar(CatalinaJWebContainerServic
eImpl.java:570)
        at org.objectweb.jonas.web.AbsJWebContainerServiceImpl.registerWar(AbsJWebContainerServiceImpl.java:854)
        at org.objectweb.jonas.web.AbsJWebContainerServiceImpl.deployWars(AbsJWebContainerServiceImpl.java:1308)
        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.objectweb.jonas.web.wrapper.catalina55.CatalinaJWebContainerServiceWrapper.invoke(CatalinaJWebContainerSe
rviceWrapper.java:157)
        at org.objectweb.jonas.web.wrapper.catalina55.CatalinaJWebContainerServiceWrapper.deployWars(CatalinaJWebContain
erServiceWrapper.java:123)
        at org.objectweb.jonas.ear.EarServiceImpl.deployEar(EarServiceImpl.java:979)
        at org.objectweb.jonas.ear.EarServiceImpl.doStart(EarServiceImpl.java:1286)
        at org.objectweb.jonas.service.AbsServiceImpl.start(AbsServiceImpl.java:80)
        at org.objectweb.jonas.service.ServiceManager.startServices(ServiceManager.java:336)
        at org.objectweb.jonas.server.Server.start(Server.java:546)
        at org.objectweb.jonas.server.Server.main(Server.java:181)
        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.objectweb.jonas.server.Bootstrap.main(Bootstrap.java:97)
Caused by: org.postgresql.util.PSQLException: ERROR: index row size 2960 exceeds btree maximum, 2713
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)

java:148)
        at org.exoplatform.services.jcr.impl.storage.jdbc.JDBCStorageConnection.add(JDBCStorageConnection.java:293)
        ... 51 more
org.postgresql.util.PSQLException: ERROR: index row size 2960 exceeds btree maximum, 2713
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
        at org.exoplatform.services.jcr.impl.storage.jdbc.SingleDbJDBCConnection.addValueRecords(SingleDbJDBCConnection.
java:148)
        at org.exoplatform.services.jcr.impl.storage.jdbc.JDBCStorageConnection.add(JDBCStorageConnection.java:293)
        at org.exoplatform.services.jcr.impl.dataflow.persistent.WorkspaceDataManager.doAdd(WorkspaceDataManager.java:34
8)
        at org.exoplatform.services.jcr.impl.dataflow.persistent.WorkspaceDataManager.save(WorkspaceDataManager.java:91)

        at org.exoplatform.services.jcr.impl.dataflow.persistent.VersionableWorkspaceDataManager.save(VersionableWorkspa
ceDataManager.java:170)
        at org.exoplatform.services.jcr.impl.dataflow.session.TransactionableDataManager.save(TransactionableDataManager
.java:241)
        at org.exoplatform.services.jcr.impl.dataflow.session.TransactionableDataManager.saveItem(TransactionableDataMan
ager.java:279)
        at org.exoplatform.services.jcr.impl.dataflow.session.TransactionableDataManager.saveItem(TransactionableDataMan
ager.java:290)
        at org.exoplatform.services.jcr.impl.core.SessionDataManager.commit(SessionDataManager.java:392)
        at org.exoplatform.services.jcr.impl.core.ItemImpl.save(ItemImpl.java:424)
        at org.exoplatform.services.jcr.impl.core.SessionImpl.save(SessionImpl.java:269)
        at org.exoplatform.services.workflow.impl.bonita.JCRFileDefinitionServiceImpl.store(JCRFileDefinitionServiceImpl
.java:286)
        at org.exoplatform.services.workflow.impl.bonita.WorkflowServiceContainerImpl.deployProcess(WorkflowServiceConta
inerImpl.java:195)
        at org.exoplatform.services.workflow.impl.bonita.WorkflowServiceContainerImpl.start(WorkflowServiceContainerImpl
.java:736)
        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.picocontainer.defaults.LifecycleVisitor.traverse(LifecycleVisitor.java:75)
        at org.picocontainer.defaults.LifecycleVisitor.start(LifecycleVisitor.java:113)
        at org.picocontainer.defaults.DefaultPicoContainer.start(DefaultPicoContainer.java:369)
        at org.exoplatform.container.PortalContainer.start(PortalContainer.java:83)
        at org.exoplatform.container.RootContainer.createPortalContainer(RootContainer.java:97)
        at org.exoplatform.portal.launcher.PortalContextListener.contextInitialized(PortalContextListener.java:44)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3727)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4162)
        at org.objectweb.jonas.web.catalina55.JOnASStandardContext.start(JOnASStandardContext.java:252)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
        at org.apache.catalina.core.ContainerBase.access$000(ContainerBase.java:121)

        at org.apache.catalina.core.ContainerBase$PrivilegedAddChild.run(ContainerBase.java:143)
        at java.security.AccessController.doPrivileged(Native Method)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:737)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
        at org.objectweb.jonas.web.catalina55.CatalinaJWebContainerServiceImpl.doRegisterWar(CatalinaJWebContainerServic
eImpl.java:570)
        at org.objectweb.jonas.web.AbsJWebContainerServiceImpl.registerWar(AbsJWebContainerServiceImpl.java:854)
        at org.objectweb.jonas.web.AbsJWebContainerServiceImpl.deployWars(AbsJWebContainerServiceImpl.java:1308)
        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.objectweb.jonas.web.wrapper.catalina55.CatalinaJWebContainerServiceWrapper.invoke(CatalinaJWebContainerSe
rviceWrapper.java:157)
        at org.objectweb.jonas.web.wrapper.catalina55.CatalinaJWebContainerServiceWrapper.deployWars(CatalinaJWebContain
erServiceWrapper.java:123)
        at org.objectweb.jonas.ear.EarServiceImpl.deployEar(EarServiceImpl.java:979)
        at org.objectweb.jonas.ear.EarServiceImpl.doStart(EarServiceImpl.java:1286)
        at org.objectweb.jonas.service.AbsServiceImpl.start(AbsServiceImpl.java:80)
        at org.objectweb.jonas.service.ServiceManager.startServices(ServiceManager.java:336)
        at org.objectweb.jonas.server.Server.start(Server.java:546)
        at org.objectweb.jonas.server.Server.main(Server.java:181)
        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.objectweb.jonas.server.Bootstrap.main(Bootstrap.java:97)

In Google the following page can be found:

http://209.85.129.104/search?q=cache:wMelGGYVHvcJ:joseph.randomnetworks.com/archives/2005/08/05/postgresql-index-limitation-index-row-size-xxxxx-exceeds-btree-maximum-2713/+index+row+size+exceeds+btree+maximum&hl=fr&gl=fr&ct=clnk&cd=1

It looks like the size of indexes is limited in Postgres. I did the test to remove all the CREATE INDEX statements from jcr-sjdbc.pgsql.sql and the error disappeared.

I was willing to get your feeling about that. Would there be a convenient way to workaround this issue ?

Thanks a lot,
-Brice.

--
Brice REVENANT
Open Software R&D - BSOA Project
Bull, Architect of an Open World TM
phone: +33 (0)4 76 29 74 22
http://www.bull.com

This e-mail contains material that is confidential for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.

-----Forwarded by Brice Revenant/FR/BULL on 10/10/2006 09:02PM -----

To: brice.revenant@xxxxxxxx, bonita@xxxxxxxxxxxxx, exoplatform@xxxxxxxxxxxxx
From: Dalibart Guillaume <gdalibart@xxxxxxxx>
Date: 10/10/2006 02:13PM
Subject: Re : [bonita] Re : [exoplatform] Exo/Bonita error

Hi Brice,
I use the compiled version eXoECM-JOnAS-Bonita-1.0-final.zip present on http://forge.objectweb.org/project/showfiles.php?group_id=151&release_id=1673
To configure Bonita, ECM and JCR for PostgreSQL, I only need to modify these files ?
        - bonita.properties
        - exo-jcr.services.jcr.impl-1.0.jar (configuration.xml)
        - ecm.war (database-configuration.xml)
I will also try this night with derby database...
Guillaume

----- Message d'origine ----
De : "brice.revenant@xxxxxxxx" <brice.revenant@xxxxxxxx>
À : bonita@xxxxxxxxxxxxx; exoplatform@xxxxxxxxxxxxx
Cc : Dalibart Guillaume <gdalibart@xxxxxxxx>
Envoyé le : Mardi, 10 Octobre 2006, 13h33mn 16s
Objet : Re: [bonita] Re : [exoplatform] Exo/Bonita error

Hi Guillaume,

Too bad, it looks like the build is broken since last week end (http://docs.exoplatform.org/servlet/continuum), that's why the page hasn't been published yet. Anyhow, I'm attaching it in ".apt" format so that you can take a look at it.

I haven't seen this error so far. It happens when the Process Definition File ("processdefinition.xpdl") of the deployed workflow is being stored in the JCR.

Which version of eXo-Bonita are you using ? Is this "1.0-final" downloaded from the OW forge : http://forge.objectweb.org/project/showfiles.php?group_id=151&release_id=1673 ? I used this one during my test with PostgreSQL 8.1.

Or are you compiling eXo from the SVN snapshot sources?

-Brice.

--
Brice REVENANT
Open Software R&D - BSOA Project
Bull, Architect of an Open World TM
http://www.bull.com

This e-mail contains material that is confidential for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.

Dalibart Guillaume <gdalibart@xxxxxxxx>
09/10/2006 10:52 GMT

Pour : brice.revenant@xxxxxxxx, exoplatform@xxxxxxxxxxxxx, bonita@xxxxxxxxxxxxx
cc :
ccc :
Objet : [bonita] Re : [exoplatform] Exo/Bonita error

Hi Brice,
yhank you for your response. After reading your mail I have tried that :
- JOnAS 4.7.4,
- PostgreSQL 8.1 (my database use by default utf8 format),
- make a new install of all exo platform. I have modified these files in order to use PostgreSQL :
        - bonita.properties
        - exo-jcr.services.jcr.impl-1.0.jar (configuration.xml)
        - ecm.war (database-configuration.xml)
        -put PostgreSQL jdbc driver and tools.jar in lib/ext folder

and I have this errors :
*** Start of Workflow Process creation : CONTENT-VALIDATION
*** End of Workflow Process creation : CONTENT-VALIDATION
javax.jcr.InvalidItemStateException: [production] Parent not found (may be deleted by other session) for PROPERTY []:1[h
ttp://www.jcp.org/jcr/1.0]system:1[http://www.exoplatform.com/jcr/exo/1.0]ecm:1[]business processes:1[]content-validatio
n:1[]processdefinition.xpdl:1[http://www.jcp.org/jcr/1.0]content:1[http://www.jcp.org/jcr/1.0]data:1 2c9fb51e7f000001009
ec9cdf7ff8336. Cause: ERROR: index row size 2960 exceeds btree maximum, 2713: ERROR: index row size 2960 exceeds btree m
aximum, 2713: ERROR: index row size 2960 exceeds btree maximum, 2713
        at org.exoplatform.services.jcr.impl.storage.jdbc.JDBCStorageConnection.handleAddSQLException(JDBCStorageConnect
ion.java:184)
....
*** Start of Workflow Process creation : HOLIDAY PROCESS
*** End of Workflow Process creation : HOLIDAY PROCESS
[INFO] SimpleJCRWebdavServlet - WebDavService = org.exoplatform.services.webdav.impl.WebdavServiceImpl@1d16dae
[INFO] SimpleJCRWebdavServlet - Container = org.exoplatform.container.PortalContainer@77de51
[INFO] SimpleJCRWebdavServlet - resource-path-prefix = '/repository'

Seems to come from my database configuration or JCR hibernate mapping... Do you have seen that before ?
Thank you,
Guillaume
PS: bonita documention seem not to be update with Database configuration" section in the left hand side pane of this page.

----- Message d'origine ----
De : "brice.revenant@xxxxxxxx" <brice.revenant@xxxxxxxx>
À : exoplatform@xxxxxxxxxxxxx; bonita@xxxxxxxxxxxxx
Cc : Dalibart Guillaume <gdalibart@xxxxxxxx>
Envoyé le : Dimanche, 8 Octobre 2006, 13h48mn 55s
Objet : Re: [exoplatform] Exo/Bonita error

Hi Guillaume,

This error typically appears in JOnAS versions prior 4.7.4. Indeed, since this version, the authentication layer has been improved to also work while the application is being started. As you are using version 4.7.6, I'm not sure to understand why it is happening.

I've tried with the same configuration as yours (Windows, JOnAS 4.7.6 and PostgreSQL 8.1) and did not get those errors. Perhaps they are due to inconsistencies in the database during your attempts to make eXo-Bonita work with PostgreSQL 8.1. Just try to restart from a fresh eXo-Bonita install using the documentation I pointed out in my previous mail. Tell me if that works based on that.

Best regards,
-Brice.

PS: You might also see an java.io.IOException: CreateProcess: C:\Sun\AppServer\jdk\jre\..\bin\javac -classpath ... exception while starting JOnAS. This is not severe. It is a known problem due to a too long command line while compiling the EJB stubs. The exception should disappear if you switch back to JOnAS 4.7.4 or if you compile the stubs by hand using the "genic -invokecmd" JOnAS command on the file "apps\autoload\exoplatform.ear\bonita.jar". You need to copy tools.jar from your java distribution to %JONAS_ROOT%\lib\ext (see http://forge.objectweb.org/tracker/index.php?func=detail&aid=100587&group_id=5&atid=100005).

--
Brice REVENANT
Open Software R&D - BSOA Project
Bull, Architect of an Open World TM
phone: +33 (0)4 76 29 74 22
http://www.bull.com

This e-mail contains material that is confidential for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.

Dalibart Guillaume <gdalibart@xxxxxxxx>
04/10/2006 20:59 GMT
Veuillez répondre à Dalibart Guillaume

Pour : exoplatform@xxxxxxxxxxxxx
cc :
ccc :
Objet : [exoplatform] Exo/Bonita error

Hi,
for all workflow present on my install of bonita-exo package I have the same error :
C:\JOnAS-4.7.6\bin\nt>*** Start of Workflow Process creation : PAYRAISE
hero.util.XPDLException: Security Exception thrown by an enterprise Bean
at hero.session.XPDLSessionImportBean.createProject(XPDLSessionImportBea
n.java:365)
at hero.session.XPDLSessionImportBean.obtainProject(XPDLSessionImportBea
n.java:273)...

ecm, portal and bonita are configured with postgresql.

Can you help me ?
Thank you

--
You receive this message as a subscriber of the exoplatform@xxxxxxxxxxxxx mailing list.
To unsubscribe: mailto:exoplatform-unsubscribe@xxxxxxxxxxxxx
For general help: mailto:sympa@xxxxxxxxxxxxx?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

Découvrez un nouveau moyen de poser toutes vos questions quel que soit le sujet ! Yahoo! Questions/Réponses pour partager vos connaissances, vos opinions et vos expériences. Cliquez ici.

--
You receive this message as a subscriber of the bonita@xxxxxxxxxxxxx mailing list.
To unsubscribe: mailto:bonita-unsubscribe@xxxxxxxxxxxxx
For general help: mailto:sympa@xxxxxxxxxxxxx?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Demandez à ceux qui savent sur Yahoo! Questions/Réponses.

--You receive this message as a subscriber of the bonita@xxxxxxxxxxxxx mailing list.To unsubscribe: mailto:bonita-unsubscribe@xxxxxxxxxxxxxFor general help: mailto:sympa@xxxxxxxxxxxxx?subject=helpObjectWeb mailing lists service home page: http://www.objectweb.org/wws

Search OW2 Mail Archive:
Advanced Search - Powered by Google

Re: [bonita] Re : [exoplatform] Exo/Bonita error (PostgreSQL data index length)