[JBoss jBPM] - Re: Variables == Bottleneck ?
by gchanteb
No problem... I found some posts but I wanted your advices.
For those who read this post:
-----------------
Question:
anonymous wrote : The db is growing much and in 20 days of work it reached 60 GB of size.
|
| The only tables of big dimension are: byteBlock 20GB of tables and 1 GB of index;
| variableinstance reached 10 GB of size plus 20 GB of indexes.
| byteArray is very bigger in number of rows , but has not a real big size.
|
| I can't truncate the tables, because they contain important information about running process.... but how can I discover what
|
| to delete without clean processes in running state?
Answer:
anonymous wrote : processes that have ended have a date in their END_ column
-----------------
Question:
anonymous wrote : The jbpm tables jbpm_variableinstance, jbpm_bytearray, jbpm_byteblock, jbpm_log has more than 10L records now.
|
| I believe the completed processinstance are identified with jbpm_processinstance with a end_ date.
|
| Is there any documentation on the sequence that needs to followed to clean up the associated tables?
Answer:
anonymous wrote :
| You can call GraphSession.deleteProcessInstance on each instance you want to remove. Note that this method is somewhat slow due to cascading.
|
| If you want mass deletion you can analyze the order of the statements executed by deleteProcessInstance and write a SQL script.
-----------------
I found Queries in jbpm-service.sar\jbpm-jpdl\org\jbpm\db\hibernate.queries.hbm.xml. With the code of org.jbpm.db.GraphSession, i'm going to create my own "cleaning methods".
Thx.
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4221546#4221546
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4221546
17 years
[JBoss Messaging] - jbm 2.0 beta1 snapshort server startup error
by gaohoward
Hi,
Building JBM 2.0 from trunk
ant distro
install jbm 2.0, cd <jbm2.0dir>/bin, and start run.sh
error occured in startup console log:
| $ ./run.sh
| data libJBMLibAIO32.so libJBMLibAIO64.so logs run.bat run.sh
| java -XX:+UseParallelGC -Xms512M -Xmx1024M -Djava.util.logging.config.file=../config/logging.properties -Dorg.jboss.logging.Logger.pluginClass=org.jboss.messaging.integration.logging.JBMLoggerPlugin -Djava.library.path=. -classpath ../lib/xercesImpl.jar:../lib/trove.jar:../lib/log4j.jar:../lib/jnpserver.jar:../lib/jboss-xml-binding.jar:../lib/jbossts-common.jar:../lib/jboss-transaction-spi.jar:../lib/jbosssx-client.jar:../lib/jboss-security-spi.jar:../lib/jboss-kernel.jar:../lib/jbossjta.jar:../lib/jbossjta-integration.jar:../lib/jboss-javaee.jar:../lib/jboss-jaspi-api.jar:../lib/jboss-dependency.jar:../lib/jboss-container.jar:../lib/jboss-common-logging-spi.jar:../lib/jboss-common-core.jar:../lib/jboss-aop-mc-int.jar:../lib/jboss-aop-jdk50.jar:../lib/jbm-transports.jar:../lib/jbm-logging.jar:../lib/jbm-jms.jar:../lib/jbm-jbossas-security.jar:../lib/jbm-core.jar:../lib/jbm-core-client.jar:../lib/jbm-bootstrap.jar:../lib/javassist.jar:../lib/commons-logging.jar:../config/:../schemas/ org.jboss.messaging.integration.bootstrap.JBMBootstrapServer jbm-standalone-beans.xml
| data libJBMLibAIO32.so libJBMLibAIO64.so logs run.bat run.sh
| 20:09:45,841 INFO @main [JBMBootstrapServer] Starting server
| 20:09:47,190 INFO @main [XmlDeployer] deploying guest
| 20:09:47,362 INFO @main [JournalStorageManager] NIO Journal selected
| 20:09:47,765 ERROR @main [AbstractKernelController] Error installing to Start: name=RemotingService state=Create
| java.lang.NoClassDefFoundError: org/jboss/netty/channel/ChannelFactory
| at org.jboss.messaging.integration.transports.netty.NettyAcceptorFactory.createAcceptor(NettyAcceptorFactory.java:43)
| at org.jboss.messaging.core.remoting.server.impl.RemotingServiceImpl.start(RemotingServiceImpl.java:165)
| 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.reflect.plugins.introspection.ReflectionUtils.invoke(ReflectionUtils.java:56)
| at org.jboss.reflect.plugins.introspection.ReflectMethodInfoImpl.invoke(ReflectMethodInfoImpl.java:110)
| at org.jboss.joinpoint.plugins.BasicMethodJoinPoint.dispatch(BasicMethodJoinPoint.java:66)
| at org.jboss.kernel.plugins.dependency.KernelControllerContextAction.dispatchJoinPoint(KernelControllerContextAction.java:97)
| at org.jboss.kernel.plugins.dependency.LifecycleAction.installActionInternal(LifecycleAction.java:221)
| at org.jboss.kernel.plugins.dependency.KernelControllerContextAction.installAction(KernelControllerContextAction.java:137)
| at org.jboss.kernel.plugins.dependency.KernelControllerContextAction.installAction(KernelControllerContextAction.java:47)
| at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
| at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
| at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
| at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:327)
| at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1309)
| at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:734)
| at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:862)
| at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:784)
| at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:574)
| at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:398)
| at org.jboss.kernel.plugins.deployment.AbstractKernelDeployer.deployBean(AbstractKernelDeployer.java:309)
| at org.jboss.kernel.plugins.deployment.AbstractKernelDeployer.deployBeans(AbstractKernelDeployer.java:279)
| at org.jboss.kernel.plugins.deployment.AbstractKernelDeployer.deploy(AbstractKernelDeployer.java:130)
| at org.jboss.kernel.plugins.deployment.xml.BeanXMLDeployer.deploy(BeanXMLDeployer.java:96)
| at org.jboss.messaging.integration.bootstrap.JBMBootstrapServer.deploy(JBMBootstrapServer.java:197)
| at org.jboss.messaging.integration.bootstrap.JBMBootstrapServer.deploy(JBMBootstrapServer.java:164)
| at org.jboss.messaging.integration.bootstrap.JBMBootstrapServer.bootstrap(JBMBootstrapServer.java:121)
| at org.jboss.kernel.plugins.bootstrap.AbstractBootstrap.run(AbstractBootstrap.java:89)
| at org.jboss.messaging.integration.bootstrap.JBMBootstrapServer.run(JBMBootstrapServer.java:82)
| at org.jboss.messaging.integration.bootstrap.JBMBootstrapServer.main(JBMBootstrapServer.java:75)
| 20:09:47,770 ERROR @main [JBMBootstrapServer] Failed to start server
| java.lang.IllegalStateException: Incompletely deployed:
|
|
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4221530#4221530
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4221530
17 years