Noone ever encountered this problem ?
This may be a configuration issue but I really need help, PLEASE
Gérard BUNEL a écrit :
Oups, I forgot to also tell that when all my client processes are stopped,
active transactions remain on each backend:
+--------------------------+-------------------------------------------------------------------------------------------+
| Backend Name |
sd01
|
| Driver |
com.mysql.jdbc.Driver
|
| URL |
jdbc:mysql://192.168.22.192/matisse?zeroDateTimeBehavior=convertToNull&autoReconnect=true
|
| Active transactions |
4
|
| Pending Requests |
0
|
| Read Enabled |
true
|
| Write Enabled |
true
|
| Is Initialized |
true
|
| Static Schema |
false
|
| Connection Managers |
1
|
| Total Active Connections |
14
|
| Persistent Connections |
0
|
| Total Requests |
6248
|
| Total Transactions |
586
|
| 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 |
1
|
| Pending Requests |
0
|
| Read Enabled |
true
|
| Write Enabled |
true
|
| Is Initialized |
true
|
| Static Schema |
false
|
| Connection Managers |
1
|
| Total Active Connections |
11
|
| Persistent Connections |
0
|
| Total Requests |
6247
|
| Total Transactions |
586
|
| Last known checkpoint |
<unknown>
|
+--------------------------+-------------------------------------------------------------------------------------------+
Gérard BUNEL a écrit :
> 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
> --
>
> *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 <http://www.altran.com>
>
>
> --------------------------------------------------------------------------------
>
> _______________________________________________
> Sequoia mailing list
> [email protected]
> https://forge.continuent.org/mailman/listinfo/sequoia
--
*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 <http://www.altran.com>
------------------------------------------------------------------------
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
--
*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 <http://www.altran.com>
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
