[JBoss JIRA] Updated: (TEIID-607) Connectors with invalid connection properties should show Source Unavailable at startup
by Ramesh Reddy (JIRA)
[ https://jira.jboss.org/jira/browse/TEIID-607?page=com.atlassian.jira.plug... ]
Ramesh Reddy updated TEIID-607:
-------------------------------
Fix Version/s: 6.2.0
(was: 6.1.1)
> Connectors with invalid connection properties should show Source Unavailable at startup
> ---------------------------------------------------------------------------------------
>
> Key: TEIID-607
> URL: https://jira.jboss.org/jira/browse/TEIID-607
> Project: Teiid
> Issue Type: Bug
> Components: Server
> Affects Versions: 6.0.0
> Environment: MMServer: Fedora 8 Kernel 2.6.26.6-49.fc8
> Connector: Oracle JDBC Connector
> Reporter: Larry O'Leary
> Fix For: 6.2.0
>
> Original Estimate: 1 hour
> Remaining Estimate: 1 hour
>
> If invalid connection properties are used in a connector binding the connector status shows "Running" at startup of the connector. When the first query is executed against the MMSystem that needs this connector an exception is thrown indicating that the connector wasn't found. This is due to the connector state changing to "Data Source Unavailable".
> Although this is the expected behavior it is very mis-leading to the administrator after creating/adding a new connector or bouncing the system. The MMConsole gives the appearance that everything is okay until users actually start running queries.
> What should be occurring is the current behavior and if Data Source Monitoring is enabled on the connector we should then check the data source available during connector startup. In other words, start the monitor thread with a timer of 0 instead a timer of monitoring interval. The idea is to show the connector as "Data Source Unavailable" at connector startup if the source isn't can't be reached due to invalid connection properties.
> TEST:
> To test this issue you simply need to have a connector deployed to a running MMSystem and verify that it is actually starting correctly with correct properties (ie verify you can run queries using this connector).
> Now, change the password on the connector to something that is invalid. Stop and then start the connector. The connector will show a "Running" state yet as soon as you execute the query the query will fail and the status of the connector will change to "Source Unavailable".
> EXPECTED RESULT:
> When you start a connector using an invalid password (or other connection type property like SID, DatabaseName, etc) the connector state should immediately reflect "Data Source Unavailable".
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
16 years, 10 months
[JBoss JIRA] Updated: (TEIID-409) server port number should be checked for availability when creating a second mmprocess
by Ramesh Reddy (JIRA)
[ https://jira.jboss.org/jira/browse/TEIID-409?page=com.atlassian.jira.plug... ]
Ramesh Reddy updated TEIID-409:
-------------------------------
Fix Version/s: 6.2.0
(was: 6.1.1)
> server port number should be checked for availability when creating a second mmprocess
> --------------------------------------------------------------------------------------
>
> Key: TEIID-409
> URL: https://jira.jboss.org/jira/browse/TEIID-409
> Project: Teiid
> Issue Type: Bug
> Components: Server
> Affects Versions: 6.x
> Reporter: Marc Shirley
> Fix For: 6.2.0
>
>
> Creating a second process on a server increments the port number by one from the primary process. This port number does not seem to be checked for availability, and so, if the second process's port is already in use, then status of the second process will be unreliable (it flickers between "Running" and "Not Started" states). One or more of the below actions should be taken:
> 1) A check should be added to the process of adding a second process to detect whether a port is already in use.
> 2) A KI entry should be made to cover the issue.
> 3) Steps should be added to the Console User's Guide and/or Server Tuning Guide to advise the reader to make sure the port assigned to the second process is not in use by another application.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
16 years, 10 months