[JBoss JIRA] (TEIID-3838) Provide fail over capability to the data source
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3838?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3838:
---------------------------------------
Then this should be rejected. In general HA should be a concern of the JCA layer.
> Provide fail over capability to the data source
> -----------------------------------------------
>
> Key: TEIID-3838
> URL: https://issues.jboss.org/browse/TEIID-3838
> Project: Teiid
> Issue Type: Feature Request
> Components: Server
> Reporter: Van Halbert
> Assignee: Steven Hawkins
>
> Provide fail over capability to the data source.
> Here's what's being envisioned:
> - similar to multi-source option, assign multiple data sources
> - assign a specific order of reading
> - only access 1 data source as part of a user query
> - if the primary data source is down, go down the line in order, to the next available data source
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 6 months
[JBoss JIRA] (TEIID-3838) Provide fail over capability to the data source
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3838?page=com.atlassian.jira.plugin... ]
Van Halbert commented on TEIID-3838:
------------------------------------
Someone just indicated that their data source (IIRC, its mysql) does not and would like to use Teiid for this.
> Provide fail over capability to the data source
> -----------------------------------------------
>
> Key: TEIID-3838
> URL: https://issues.jboss.org/browse/TEIID-3838
> Project: Teiid
> Issue Type: Feature Request
> Components: Server
> Reporter: Van Halbert
> Assignee: Steven Hawkins
>
> Provide fail over capability to the data source.
> Here's what's being envisioned:
> - similar to multi-source option, assign multiple data sources
> - assign a specific order of reading
> - only access 1 data source as part of a user query
> - if the primary data source is down, go down the line in order, to the next available data source
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 6 months
[JBoss JIRA] (TEIID-3838) Provide fail over capability to the data source
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3838?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3838:
---------------------------------------
Many drivers have this support built-in. Also EAP provides ha-* JDBC datasources. Are there non-JDBC sources that you would want this behavior for?
> Provide fail over capability to the data source
> -----------------------------------------------
>
> Key: TEIID-3838
> URL: https://issues.jboss.org/browse/TEIID-3838
> Project: Teiid
> Issue Type: Feature Request
> Components: Server
> Reporter: Van Halbert
> Assignee: Steven Hawkins
>
> Provide fail over capability to the data source.
> Here's what's being envisioned:
> - similar to multi-source option, assign multiple data sources
> - assign a specific order of reading
> - only access 1 data source as part of a user query
> - if the primary data source is down, go down the line in order, to the next available data source
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 6 months
[JBoss JIRA] (TEIID-3838) Provide fail over capability to the data source
by Van Halbert (JIRA)
Van Halbert created TEIID-3838:
----------------------------------
Summary: Provide fail over capability to the data source
Key: TEIID-3838
URL: https://issues.jboss.org/browse/TEIID-3838
Project: Teiid
Issue Type: Feature Request
Components: Server
Reporter: Van Halbert
Assignee: Steven Hawkins
Provide fail over capability to the data source.
Here's what's being envisioned:
- similar to multi-source option, assign multiple data sources
- assign a specific order of reading
- only access 1 data source as part of a user query
- if the primary data source is down, go down the line in order, to the next available data source
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 6 months
[JBoss JIRA] (TEIID-3837) AS400 deployVDB
by Mark Tawk (JIRA)
Mark Tawk created TEIID-3837:
--------------------------------
Summary: AS400 deployVDB
Key: TEIID-3837
URL: https://issues.jboss.org/browse/TEIID-3837
Project: Teiid
Issue Type: Feature Request
Reporter: Mark Tawk
Assignee: Steven Hawkins
I'm using Teiid 8.11.3 and db2i translator,
I'm connecting to an AS400 DB containing around 1000 tables, the deployvdb remained running for 2 hours and it did not finish.
Is there a way to speed up the deployvdb treatment? or to know more details on the vdb deployment progress?
I'm able to fetch the DB information schema via a jdbc connection and it is not taking that much time.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 6 months
[JBoss JIRA] (TEIID-3834) Error during (re) adding connection factory using CLI
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3834?page=com.atlassian.jira.plugin... ]
Ramesh Reddy updated TEIID-3834:
--------------------------------
Parent: TEIID-3519
Issue Type: Sub-task (was: Bug)
> Error during (re) adding connection factory using CLI
> -----------------------------------------------------
>
> Key: TEIID-3834
> URL: https://issues.jboss.org/browse/TEIID-3834
> Project: Teiid
> Issue Type: Sub-task
> Components: Server
> Affects Versions: 8.13
> Reporter: Kylin Soong
> Assignee: Van Halbert
> Fix For: 8.13
>
>
> enable datasource command
> {code}
> /subsystem=datasources/data-source=h2:enable
> {code}
> seems redundant, cause datasource add already enable it, so if execute setup.cli
> {code}
> ./bin/jboss-cli.sh --connect --file=setup.cli
> {code}
> will cause a eror
> {code}
> {
> "outcome" => "failed",
> "failure-description" => "WFLYCTL0158: Operation handler failed: org.jboss.msc.service.DuplicateServiceException: Service jboss.data-source-config.h2 is already registered",
> "rolled-back" => true
> }
> 14:35:55,436 ERROR [org.jboss.as.controller.management-operation] (management-handler-thread - 9) WFLYCTL0013: Operation ("enable") failed - address: ([
> ("subsystem" => "datasources"),
> ("data-source" => "h2")
> ]): org.jboss.msc.service.DuplicateServiceException: Service jboss.data-source-config.h2 is already registered
> at org.jboss.msc.service.ServiceRegistrationImpl.setInstance(ServiceRegistrationImpl.java:158)
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 6 months
[JBoss JIRA] (TEIID-3834) Error during (re) adding connection factory using CLI
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3834?page=com.atlassian.jira.plugin... ]
Ramesh Reddy reassigned TEIID-3834:
-----------------------------------
Assignee: Ramesh Reddy (was: Van Halbert)
> Error during (re) adding connection factory using CLI
> -----------------------------------------------------
>
> Key: TEIID-3834
> URL: https://issues.jboss.org/browse/TEIID-3834
> Project: Teiid
> Issue Type: Sub-task
> Components: Server
> Affects Versions: 8.13
> Reporter: Kylin Soong
> Assignee: Ramesh Reddy
> Fix For: 8.13
>
>
> enable datasource command
> {code}
> /subsystem=datasources/data-source=h2:enable
> {code}
> seems redundant, cause datasource add already enable it, so if execute setup.cli
> {code}
> ./bin/jboss-cli.sh --connect --file=setup.cli
> {code}
> will cause a eror
> {code}
> {
> "outcome" => "failed",
> "failure-description" => "WFLYCTL0158: Operation handler failed: org.jboss.msc.service.DuplicateServiceException: Service jboss.data-source-config.h2 is already registered",
> "rolled-back" => true
> }
> 14:35:55,436 ERROR [org.jboss.as.controller.management-operation] (management-handler-thread - 9) WFLYCTL0013: Operation ("enable") failed - address: ([
> ("subsystem" => "datasources"),
> ("data-source" => "h2")
> ]): org.jboss.msc.service.DuplicateServiceException: Service jboss.data-source-config.h2 is already registered
> at org.jboss.msc.service.ServiceRegistrationImpl.setInstance(ServiceRegistrationImpl.java:158)
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 6 months
[JBoss JIRA] (TEIID-3834) Error during (re) adding connection factory using CLI
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3834?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-3834:
-------------------------------------
I am working with WildFly team to resolve this issue
> Error during (re) adding connection factory using CLI
> -----------------------------------------------------
>
> Key: TEIID-3834
> URL: https://issues.jboss.org/browse/TEIID-3834
> Project: Teiid
> Issue Type: Quality Risk
> Components: Quick Starts
> Affects Versions: 8.13
> Reporter: Kylin Soong
> Assignee: Van Halbert
> Fix For: 8.13
>
>
> enable datasource command
> {code}
> /subsystem=datasources/data-source=h2:enable
> {code}
> seems redundant, cause datasource add already enable it, so if execute setup.cli
> {code}
> ./bin/jboss-cli.sh --connect --file=setup.cli
> {code}
> will cause a eror
> {code}
> {
> "outcome" => "failed",
> "failure-description" => "WFLYCTL0158: Operation handler failed: org.jboss.msc.service.DuplicateServiceException: Service jboss.data-source-config.h2 is already registered",
> "rolled-back" => true
> }
> 14:35:55,436 ERROR [org.jboss.as.controller.management-operation] (management-handler-thread - 9) WFLYCTL0013: Operation ("enable") failed - address: ([
> ("subsystem" => "datasources"),
> ("data-source" => "h2")
> ]): org.jboss.msc.service.DuplicateServiceException: Service jboss.data-source-config.h2 is already registered
> at org.jboss.msc.service.ServiceRegistrationImpl.setInstance(ServiceRegistrationImpl.java:158)
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 6 months
[JBoss JIRA] (TEIID-3834) Error during (re) adding connection factory using CLI
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3834?page=com.atlassian.jira.plugin... ]
Ramesh Reddy updated TEIID-3834:
--------------------------------
Issue Type: Bug (was: Quality Risk)
> Error during (re) adding connection factory using CLI
> -----------------------------------------------------
>
> Key: TEIID-3834
> URL: https://issues.jboss.org/browse/TEIID-3834
> Project: Teiid
> Issue Type: Bug
> Components: Quick Starts
> Affects Versions: 8.13
> Reporter: Kylin Soong
> Assignee: Van Halbert
> Fix For: 8.13
>
>
> enable datasource command
> {code}
> /subsystem=datasources/data-source=h2:enable
> {code}
> seems redundant, cause datasource add already enable it, so if execute setup.cli
> {code}
> ./bin/jboss-cli.sh --connect --file=setup.cli
> {code}
> will cause a eror
> {code}
> {
> "outcome" => "failed",
> "failure-description" => "WFLYCTL0158: Operation handler failed: org.jboss.msc.service.DuplicateServiceException: Service jboss.data-source-config.h2 is already registered",
> "rolled-back" => true
> }
> 14:35:55,436 ERROR [org.jboss.as.controller.management-operation] (management-handler-thread - 9) WFLYCTL0013: Operation ("enable") failed - address: ([
> ("subsystem" => "datasources"),
> ("data-source" => "h2")
> ]): org.jboss.msc.service.DuplicateServiceException: Service jboss.data-source-config.h2 is already registered
> at org.jboss.msc.service.ServiceRegistrationImpl.setInstance(ServiceRegistrationImpl.java:158)
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 6 months