[JBoss jBPM] - Performance slowdown with large JBPM_LOG table
by michaelholtzman
Greetings. We are seeing a huge slowdown in jBPM throughput when the JBPM_LOG file gets very large.
For example, during our benchmark testing we start with a "virgin" database. After three weeks of testing, we see a ~40% increase in workflow execution time. At this point, the JBPM_LOG table has about 6M (yes, million) records.
If we clean the database tables, performance returns to its original level. I don't really understand why the size of JBPM_LOG has such a profound effect on performance.
In production we need the log records to construct an audit trail, so disabling logging is not an option.
Any suggestions on improving performance with large JBPM tables?
Anyone running a high volume jBPM application care to comment on performance over time?
BTW, this is jBPM 3.1.2 with selected fixes from later versions applied.
Thanx.
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4213536#4213536
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4213536
15 years, 9 months
[JBoss jBPM] - problem with jbpm-3.3.1.GA and jboss 4.2.3
by aminoux
hi, i'm new in jbpm, i installed jboss 4.2.3 and jbpm-3.3.1.GA.
when i start the process( all the examples ), the page show me a 404 error status, and it don't show the tasks. the following error are displayed in the log of jboss
| 2009-02-26 18:20:32,687 DEBUG [javax.enterprise.resource.webcontainer.jsf.config] No FacesServlet found in deployment descriptor - bypassing configuration
| 2009-02-26 18:20:32,968 ERROR [STDERR] 250 [main] INFO org.jboss.resteasy.plugins.providers - Added DataSourceProvider
| 2009-02-26 18:20:32,968 ERROR [STDERR] 250 [main] INFO org.jboss.resteasy.plugins.providers - Added DefaultTextPlain
| 2009-02-26 18:20:33,031 ERROR [STDERR] 313 [main] INFO org.jboss.resteasy.plugins.providers - Added JAXBXmlRootElementProvider
| 2009-02-26 18:20:33,031 ERROR [STDERR] 313 [main] INFO org.jboss.resteasy.plugins.providers - Added JAXBElementProvider
| 2009-02-26 18:20:33,046 ERROR [STDERR] 328 [main] INFO org.jboss.resteasy.plugins.providers - Added JAXBXmlTypeProvider
| 2009-02-26 18:20:33,062 ERROR [STDERR] 344 [main] INFO org.jboss.resteasy.plugins.providers - Adding org.jboss.resteasy.plugins.providers.IIOImageProvider
| 2009-02-26 18:20:33,125 ERROR [STDERR] 407 [main] INFO org.jboss.resteasy.plugins.providers - Adding org.jboss.resteasy.plugins.providers.jaxb.json.JsonJAXBElementProvider
| 2009-02-26 18:20:33,125 ERROR [STDERR] 407 [main] INFO org.jboss.resteasy.plugins.providers - Adding org.jboss.resteasy.plugins.providers.jaxb.json.JsonXmlTypeProvider
| 2009-02-26 18:20:33,125 ERROR [STDERR] 407 [main] INFO org.jboss.resteasy.plugins.providers - Adding org.jboss.resteasy.plugins.providers.jaxb.json.JsonXmlRootElementProvider
| 2009-02-26 18:20:33,140 ERROR [STDERR] 422 [main] INFO org.jboss.resteasy.plugins.providers - Adding org.jboss.resteasy.plugins.providers.MimeMultipartProvider
| 2009-02-26 18:20:33,156 ERROR [STDERR] 422 [main] INFO org.jboss.resteasy.plugins.providers - Adding org.jboss.resteasy.plugins.providers.YamlProvider
| 2009-02-26 18:20:33,171 ERROR [STDERR] 453 [main] INFO org.jboss.resteasy.plugins.providers - Adding org.jboss.resteasy.plugins.providers.jaxb.fastinfoset.FastinfoSetXmlRootElementProvider
| 2009-02-26 18:20:33,171 ERROR [STDERR] 453 [main] INFO org.jboss.resteasy.plugins.providers - Adding org.jboss.resteasy.plugins.providers.jaxb.fastinfoset.FastinfoSetJAXBElementProvider
| 2009-02-26 18:20:33,187 ERROR [STDERR] 469 [main] INFO org.jboss.resteasy.plugins.providers - Adding org.jboss.resteasy.plugins.providers.jaxb.fastinfoset.FastinfoSetXmlTypeProvider
|
and later, thease problems are displayed:
| 2009-02-26 18:21:28,562 DEBUG [javax.enterprise.resource.webcontainer.jsf.lifecycle] Entering RenderResponsePhase
| 2009-02-26 18:21:28,562 DEBUG [javax.enterprise.resource.webcontainer.jsf.lifecycle] About to render view /ua/login-example.xhtml
| 2009-02-26 18:21:31,609 DEBUG [javax.enterprise.resource.webcontainer.jsf.application] added component of type 'gravel.action.ResponseActions' and class 'org.jboss.gravel.action.ui.UIResponseActions'
| 2009-02-26 18:21:31,796 ERROR [STDERR] 26 févr. 2009 18:21:31 com.sun.facelets.compiler.TagLibraryConfig loadImplicit
| INFO: Added Library from: jar:file:/C:/Program%20Files/Java/jboss-4.2.3.GA/server/default/deploy/jbpm/jsf-console.war/WEB-INF/lib/gravel-1.0.0.GA.jar!/META-INF/gravel-action.taglib.xml
| 2009-02-26 18:21:31,859 DEBUG [javax.enterprise.resource.webcontainer.jsf.application] added component of type 'gravel.Entry' and class 'org.jboss.gravel.common.ui.UICollectionEntry'
| 2009-02-26 18:21:31,890 DEBUG [javax.enterprise.resource.webcontainer.jsf.application] added component of type 'gravel.compat.DataTable' and class 'org.jboss.gravel.compat.ui.UIDataTable'
| 2009-02-26 18:21:31,890 DEBUG [javax.enterprise.resource.webcontainer.jsf.application] added component of type 'gravel.compat.DataTableColumn' and class 'org.jboss.gravel.compat.ui.UIDataTableColumn'
| 2009-02-26 18:21:31,906 ERROR [STDERR] 26 févr. 2009 18:21:31 com.sun.facelets.compiler.TagLibraryConfig loadImplicit
| INFO: Added Library from: jar:file:/C:/Program%20Files/Java/jboss-4.2.3.GA/server/default/deploy/jbpm/jsf-console.war/WEB-INF/lib/gravel-1.0.0.GA.jar!/META-INF/gravel-compat.taglib.xml
| 2009-02-26 18:21:31,921 DEBUG [javax.enterprise.resource.webcontainer.jsf.application] added component of type 'gravel.Repeat' and class 'org.jboss.gravel.data.ui.UIRepeat'
| 2009-02-26 18:21:31,937 DEBUG [javax.enterprise.resource.webcontainer.jsf.application] added component of type 'gravel.data.InputFile' and class 'org.jboss.gravel.data.ui.UIInputFile'
| 2009-02-26 18:21:31,937 DEBUG [javax.enterprise.resource.webcontainer.jsf.application] added component of type 'gravel.data.InputHidden' and class 'org.jboss.gravel.data.ui.UIInputHidden'
| 2009-02-26 18:21:31,953 DEBUG [javax.enterprise.resource.webcontainer.jsf.application] added component of type 'gravel.Properties' and class 'org.jboss.gravel.data.ui.UIProperties'
| 2009-02-26 18:21:31,953 ERROR [STDERR] 26 févr. 2009 18:21:31 com.sun.facelets.compiler.TagLibraryConfig loadImplicit
| INFO: Added Library from: jar:file:/C:/Program%20Files/Java/jboss-4.2.3.GA/server/default/deploy/jbpm/jsf-console.war/WEB-INF/lib/gravel-1.0.0.GA.jar!/META-INF/gravel-data.taglib.xml
| 2009-02-26 18:21:31,968 ERROR [STDERR] 26 févr. 2009 18:21:31 com.sun.facelets.compiler.TagLibraryConfig loadImplicit
| INFO: Added Library from: jar:file:/C:/Program%20Files/Java/jboss-4.2.3.GA/server/default/deploy/jbpm/jsf-console.war/WEB-INF/lib/gravel-1.0.0.GA.jar!/META-INF/gravel-nav.taglib.xml
| 2009-02-26 18:21:31,984 DEBUG [javax.enterprise.resource.webcontainer.jsf.application] added component of type 'gravel.Simple' and class 'org.jboss.gravel.simple.ui.UISimple'
|
|
|
anyone can help me???
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4213534#4213534
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4213534
15 years, 9 months