Hello,

I'm currently doing load testing on an application based on:
sequoia 2.10.6, MySQL 5.0.37, RedHat 4ES, JDK 1.5.0_11

Just for this test I have set up the configuration with one controller holding 2 backends.
When launched, it seems that one of the backend supports the majority of the transactions and the other seems ok as shown below:

+--------------------------+-------------------------------------------------------------------------------------------+
| Backend Name             | sd01                                                                                      |
| Driver                   | com.mysql.jdbc.Driver                                                                     |
| URL                      | jdbc:mysql://192.168.22.192/matisse?zeroDateTimeBehavior=convertToNull&autoReconnect=true |
| Active transactions      | 101                                                                                       |
| Pending Requests         | 4                                                                                         |
| Read Enabled             | true                                                                                      |
| Write Enabled            | true                                                                                      |
| Is Initialized           | true                                                                                      |
| Static Schema            | false                                                                                     |
| Connection Managers      | 1                                                                                         |
| Total Active Connections | 101                                                                                       |
| Persistent Connections   | 0                                                                                         |
| Total Requests           | 2135                                                                                      |
| Total Transactions       | 154                                                                                       |
| Last known checkpoint    | <unknown>                                                                                 |
+--------------------------+-------------------------------------------------------------------------------------------+
| Backend Name             | sd02                                                                                      |
| Driver                   | com.mysql.jdbc.Driver                                                                     |
| URL                      | jdbc:mysql://192.168.22.193/matisse?zeroDateTimeBehavior=convertToNull&autoReconnect=true |
| Active transactions      | 0                                                                                         |
| Pending Requests         | 0                                                                                         |
| Read Enabled             | true                                                                                      |
| Write Enabled            | true                                                                                      |
| Is Initialized           | true                                                                                      |
| Static Schema            | false                                                                                     |
| Connection Managers      | 1                                                                                         |
| Total Active Connections | 10                                                                                        |
| Persistent Connections   | 0                                                                                         |
| Total Requests           | 2134                                                                                      |
| Total Transactions       | 154                                                                                       |
| Last known checkpoint    | <unknown>                                                                                 |
+--------------------------+-------------------------------------------------------------------------------------------+

At a time the first backend is disabled and many transactions are aborted.

If I do the same test with only one backend enabled, everything works fine.
I've done the same test with sequoia 2.10.9 and encountered the same problem.

Bug in controller ?
I really need an answer on this problem,
please, help !!!

Gérard
--
ALTRAN OUEST

Gérard BUNEL
Chef de Projet
____________________________________________________________________


Technopôle Brest Iroise
Site du Vernis – CS 23866
29238 Brest Cedex 3
Tél : + 33 2 98 05 43 21
Fax : + 33 2 98 05 20 34
www.altran.com

_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia

Reply via email to