Bug 1121935
| Summary: | Running test-connection-in-pool operation leaves datasource in a bad state | ||
|---|---|---|---|
| Product: | [JBoss] JBoss Enterprise Application Platform 6 | Reporter: | bkramer <bkramer> |
| Component: | JCA | Assignee: | Martin Simka <msimka> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Martin Simka <msimka> |
| Severity: | medium | Docs Contact: | Russell Dickenson <rdickens> |
| Priority: | unspecified | ||
| Version: | 6.1.0 | ||
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2014-09-25 16:21:25 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
|
Description
bkramer
2014-07-22 07:46:35 UTC
As a workaround do one of the following: 1. Disable the "Test Connection?" trait from JBoss ON; 2. Restart the EAP server every time the issue happens; 3. Flush the connections in the pool every time the issue happens. This issue reported against older version, cannot be reproduced against latest bits (I used 6.4.0.DR2), which means it was fixed earlier. Therefore, we are closing this bug. Thank you for reporting this issue.
I've tried to run "/subsystem=datasources/xa-data-source=gamificationDS:test-connection-in-pool()" 2000 times with 2 seconds breaks. No error, no exception.
Datasource used for test:
<xa-datasource jndi-name="java:jboss/datasources/gamificationDS" pool-name="gamificationDS" enabled="true" use-ccm="false">
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
<xa-datasource-property name="URL">jdbc:mysql://localhost:3306/test</xa-datasource-property>
<driver>mysql.jar</driver>
<xa-pool>
<is-same-rm-override>false</is-same-rm-override>
<interleaving>false</interleaving>
<pad-xid>false</pad-xid>
<wrap-xa-resource>false</wrap-xa-resource>
</xa-pool>
<security>
<user-name>test</user-name>
<password>test</password>
</security>
<validation>
<validate-on-match>false</validate-on-match>
<background-validation>false</background-validation>
</validation>
<statement>
<share-prepared-statements>false</share-prepared-statements>
</statement>
</xa-datasource>
Feel free to reopen if you experience same problem with JON and EAP 6.3.0+
|