topic Re: load testing connection pooling in Alfresco Archive

load testing connection pooling

luisalves00 — Fri, 09 Sep 2011 11:33:56 GMT

Hello,My load test seem to fail because of some kind of connection starvation (still not sure).O configure the engine programmaticalyrg.apache.commons.dbcp.BasicDataSource bds = new org.apache.commons.dbcp.BasicDataSource(); bds.setDefaultAutoCommit(false); //FIXME: make me configurable

Re: load testing connection pooling

luisalves00 — Fri, 09 Sep 2011 11:55:40 GMT

6 parallel requests…seem to work…

Re: load testing connection pooling

ronald_van_kuij — Fri, 09 Sep 2011 13:21:55 GMT

Activity 0.9 is not supported anymore

Re: load testing connection pooling

luisalves00 — Fri, 09 Sep 2011 13:37:30 GMT

ronald.van.kuijk,

I'm using activiti-5.6 what is Activity 0.9?

Re: load testing connection pooling

luisalves00 — Fri, 09 Sep 2011 14:13:01 GMT

Updates…

using code like this:

           .setJdbcUrl("jdbc:mysql://localhost:3306/activiti?autoReconnect=true") 
                    .setJdbcDriver("com.mysql.jdbc.Driver") 
                    .setJdbcUsername("activiti") 
                    .setJdbcPassword("activiti")
                    //.setDataSource(bds) <- NOT USING THIS

When using an external DS I need to add something like c3p0?

Re: load testing connection pooling

jbarrez — Thu, 15 Sep 2011 12:35:00 GMT

No, in this case Ibatis will be able to do the connection pooling. Check the userguide for the details on how you can configure these settings.
When you provide a datasource, you will need to do it yourself (eg with c3p0).

Re: load testing connection pooling

luisalves00 — Tue, 20 Sep 2011 08:13:14 GMT

And how can I get ibatis to support autoCommit?

I'm getting org.apache.ibatis.transaction.TransactionException: Error configuring AutoCommit. Your driver may not support getAutoCommit() or setAutoCommit(). Requested setting: false. Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Re: load testing connection pooling

jbarrez — Tue, 20 Sep 2011 09:23:24 GMT

why do you need autocommit? I wouldn't use it .. ever.

Re: load testing connection pooling

luisalves00 — Tue, 20 Sep 2011 16:19:12 GMT

I do not know if I need it…but I'm getting that exception…and I don't know why.

I'm using Activiti 5.6.

Re: load testing connection pooling

ronald_van_kuij — Tue, 20 Sep 2011 16:43:49 GMT

look in jira for the dbid generator issue. That is probably where you run into.

Re: load testing connection pooling

luisalves00 — Tue, 20 Sep 2011 17:06:42 GMT

is this fixed on 5.7?

Re: load testing connection pooling

ronald_van_kuij — Tue, 20 Sep 2011 17:31:34 GMT

I think it is in present in 5.7 but not fully tested and therefor not enabled by default and not documented

Re: load testing connection pooling

luisalves00 — Thu, 29 Sep 2011 17:29:28 GMT

how to disable it?

I'm allways getting this exception:

29-09-2011 06:30:16 CommandContext [ERROR] Error while closing command context
org.apache.ibatis.transaction.TransactionException: Error configuring AutoCommit.  Your driver may not support getAutoCommit() or setAutoCommit(). Requested setting: false.  Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 86.321.988 milliseconds ago.  The last packet sent successfully to the server was 86.321.988 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
 at org.apache.ibatis.transaction.jdbc.JdbcTransaction.setDesiredAutoCommit(JdbcTransaction.java:47)
 at org.apache.ibatis.transaction.jdbc.JdbcTransaction.<init>(JdbcTransaction.java:15)
 at org.apache.ibatis.transaction.jdbc.JdbcTransactionFactory.newTransaction(JdbcTransactionFactory.java:15)
 at org.apache.ibatis.session.defaults.DefaultSqlSessionFactory.openSessionFromDataSource(DefaultSqlSessionFactory.java:77)
 at org.apache.ibatis.session.defaults.DefaultSqlSessionFactory.openSession(DefaultSqlSessionFactory.java:32)
 at org.activiti.engine.impl.db.DbSqlSession.<init>(DbSqlSession.java:84)
 at org.activiti.engine.impl.db.DbSqlSessionFactory.openSession(DbSqlSessionFactory.java:77)
 at org.activiti.engine.impl.interceptor.CommandContext.getSession(CommandContext.java:177)
 at org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext.getDbSqlSession(StandaloneMybatisTransactionContext.java:77)
 at org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext.commit(StandaloneMybatisTransactionContext.java:58)
 at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:112)
 at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:49)
 at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
 at org.activiti.engine.impl.IdentityServiceImpl.createUserQuery(IdentityServiceImpl.java:70)

Already got autoReconnect=true ….wait_timeout is set to mysql default (think its 8 hours)…

Re: load testing connection pooling

lichtin — Fri, 30 Sep 2011 13:25:24 GMT

http://jira.codehaus.org/browse/ACT-789?focusedCommentId=274693&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-274693

In your activiti.cfg.xml

<bean id="processEngineConfiguration" … >
…
<property name="idGenerator">
<bean class="org.activiti.engine.impl.persistence.StrongUuidGenerator" />
</property>

</bean>

Re: load testing connection pooling

luisalves00 — Tue, 04 Oct 2011 07:41:06 GMT

lichtin,

I'm configuring my processEngine on java code…not in the xml.

Questions:

1. how to set this on the code?
2. is valid for 5.6 or only 5.7?

best regards,
la00

Re: load testing connection pooling

lichtin — Tue, 04 Oct 2011 08:40:22 GMT

1. how to set this on the code?
2. is valid for 5.6 or only 5.7?

1. Use the setter

setIdGenerator(IdGenerator idGenerator)

2. from 5.7 on

Re: load testing connection pooling

luisalves00 — Tue, 04 Oct 2011 15:01:07 GMT

I'm looking ate http://activiti.org/javadocs/index.html and ProcessEngineConfiguration doesn't have that method…

I've updated to 5.7 and can't find it…

Re: load testing connection pooling

luisalves00 — Thu, 06 Oct 2011 08:48:33 GMT

tried:


ProcessEngineConfigurationImpl pec =  (ProcessEngineConfigurationImpl) ProcessEngineConfiguration …..

pec.setIdGenerator(new org.activiti.engine.impl.persistence.StrongUuidGenerator());

ProcessEngine processEngine = (ProcessEngine) pec.buildProcessEngine();

(new org.activiti.engine.impl.persistence.StrongUuidGenerator()); this throws an exception…
I think I can't do 'new' because StrongUuidGenerator must depend on some dependency injection…

Do you know any factory method?

Re: load testing connection pooling

marcus1 — Thu, 06 Oct 2011 09:41:33 GMT

Which exception is thrown? Probably a ClassNotFoundException. StrongUuidGenerator needs the library java-uuid-generator-3.1.2.jar.

Re: load testing connection pooling

luisalves00 — Thu, 06 Oct 2011 09:55:20 GMT

tks Marcus and lichtin

library java-uuid-generator-3.1.2.jar did the trick…