[jboss-jira] [JBoss JIRA] (WFLY-5527) "WFLYCTL0171 unsatisfied dependencies" when removing an xa-datasource-properties resource

Stefano Maestri (JIRA) issues at jboss.org
Wed Oct 14 10:58:00 EDT 2015


    [ https://issues.jboss.org/browse/WFLY-5527?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13118293#comment-13118293 ] 

Stefano Maestri commented on WFLY-5527:
---------------------------------------

In fact it doesn't no more makes sense to remove xa-datasource-properties (and also datasource=*/connection-properties) w/o :reload because we have totally removed the concept of disabled data-source. Linked PR is making :remove for those subresources a ReloadRequiredRemoveOperation, accordingly all other properties in datasource/xa-datasource

> "WFLYCTL0171 unsatisfied dependencies" when removing an xa-datasource-properties resource
> -----------------------------------------------------------------------------------------
>
>                 Key: WFLY-5527
>                 URL: https://issues.jboss.org/browse/WFLY-5527
>             Project: WildFly
>          Issue Type: Bug
>          Components: JCA
>    Affects Versions: 9.0.1.Final, 10.0.0.CR2
>            Reporter: Peter Palaga
>            Assignee: Stefano Maestri
>
> Steps to reproduce, same fro WF 9.0.1.Final and 10.0.0.CR2:
> (1) create an XA Datasource:
> {code}
> {
>     "operation" => "composite",
>     "address" => [],
>     "steps" => [
>         {
>             "operation" => "add",
>             "address" => [
>                 ("subsystem" => "datasources"),
>                 ("xa-data-source" => "testXaDs")
>             ],
>             "jndi-name" => "java:/testXaDs",
>             "driver-name" => "h2",
>             "xa-datasource-class" => "org.h2.jdbcx.JdbcDataSource",
>             "user-name" => "sa",
>             "password" => "sa",
>             "new-connection-sql" => undefined,
>             "url-delimiter" => undefined,
>             "url-selector-strategy-class-name" => undefined,
>             "use-java-context" => undefined,
>             "max-pool-size" => undefined,
>             "min-pool-size" => undefined,
>             "initial-pool-size" => undefined,
>             "pool-prefill" => undefined,
>             "pool-use-strict-min" => undefined,
>             "interleaving" => undefined,
>             "capacity-incrementer-class" => undefined,
>             "capacity-decrementer-class" => undefined,
>             "no-tx-separate-pool" => undefined,
>             "pad-xid" => undefined,
>             "same-rm-override" => undefined,
>             "wrap-xa-resource" => undefined,
>             "security-domain" => undefined,
>             "reauth-plugin-class-name" => undefined,
>             "flush-strategy" => undefined,
>             "allow-multiple-users" => undefined,
>             "connection-listener-class" => undefined,
>             "prepared-statements-cache-size" => undefined,
>             "share-prepared-statements" => undefined,
>             "track-statements" => undefined,
>             "allocation-retry" => undefined,
>             "allocation-retry-wait-millis" => undefined,
>             "blocking-timeout-wait-millis" => undefined,
>             "idle-timeout-minutes" => undefined,
>             "query-timeout" => undefined,
>             "use-try-lock" => undefined,
>             "set-tx-query-timeout" => undefined,
>             "transaction-isolation" => undefined,
>             "check-valid-connection-sql" => undefined,
>             "exception-sorter-class-name" => undefined,
>             "stale-connection-checker-class-name" => undefined,
>             "valid-connection-checker-class-name" => undefined,
>             "background-validation-millis" => undefined,
>             "background-validation" => undefined,
>             "use-fast-fail" => undefined,
>             "validate-on-match" => undefined,
>             "xa-resource-timeout" => undefined,
>             "spy" => undefined,
>             "use-ccm" => undefined,
>             "enabled" => undefined,
>             "connectable" => undefined,
>             "statistics-enabled" => undefined,
>             "tracking" => undefined,
>             "recovery-username" => undefined,
>             "recovery-password" => undefined,
>             "recovery-security-domain" => undefined,
>             "recovery-plugin-class-name" => undefined,
>             "no-recovery" => undefined,
>             "url-property" => undefined,
>             "reauth-plugin-properties" => undefined,
>             "exception-sorter-properties" => undefined,
>             "stale-connection-checker-properties" => undefined,
>             "valid-connection-checker-properties" => undefined,
>             "recovery-plugin-properties" => undefined,
>             "connection-listener-property" => undefined,
>             "capacity-incrementer-properties" => undefined,
>             "capacity-decrementer-properties" => undefined
>         },
>         {
>             "operation" => "add",
>             "address" => [
>                 ("subsystem" => "datasources"),
>                 ("xa-data-source" => "testXaDs"),
>                 ("xa-datasource-properties" => "URL")
>             ],
>             "value" => "jdbc:h2:mem:test"
>         },
>         {
>             "operation" => "add",
>             "address" => [
>                 ("subsystem" => "datasources"),
>                 ("xa-data-source" => "testXaDs"),
>                 ("xa-datasource-properties" => "xaProp2")
>             ],
>             "value" => "xaVal2"
>         }
>     ]
> }
> {code}
> (2) Update or remove any of the {{xa-datasource-properties}}:
> {code}
> {
>     "operation" => "composite",
>     "address" => [],
>     "steps" => [
>         {
>             "operation" => "remove",
>             "address" => [
>                 ("subsystem" => "datasources"),
>                 ("xa-data-source" => "testXaDs"),
>                 ("xa-datasource-properties" => "URL")
>             ]
>         },
>         {
>             "operation" => "add",
>             "address" => [
>                 ("subsystem" => "datasources"),
>                 ("xa-data-source" => "testXaDs"),
>                 ("xa-datasource-properties" => "URL")
>             ],
>             "value" => "jdbc:h2:mem:test;DB_CLOSE_DELAY=5000"
>         },
>         {
>             "operation" => "remove",
>             "address" => [
>                 ("subsystem" => "datasources"),
>                 ("xa-data-source" => "testXaDs"),
>                 ("xa-datasource-properties" => "xaProp2")
>             ]
>         },
>         {
>             "operation" => "add",
>             "address" => [
>                 ("subsystem" => "datasources"),
>                 ("xa-data-source" => "testXaDs"),
>                 ("xa-datasource-properties" => "xaProp3")
>             ],
>             "value" => "xaVal3"
>         }
>     ]
> }
> {code}
> (3) NOT OK: the composite operation fails
> {code}
> {
>     "outcome" => "failed",
>     "result" => {
>         "step-1" => {
>             "outcome" => "failed",
>             "failure-description" => "WFLYCTL0171: Removing services has lead to unsatisfied dependencies:
> Service jboss.xa-data-source-config.testXaDs.xa-datasource-properties.URL was depended upon by service jboss.xa-data-source-config.testXaDs",
>             "rolled-back" => true
>         },
>         "step-2" => {
>             "outcome" => "failed",
>             "response-headers" => {"operation-requires-reload" => true},
>             "rolled-back" => true
>         },
>         "step-3" => {
>             "outcome" => "failed",
>             "failure-description" => "WFLYCTL0171: Removing services has lead to unsatisfied dependencies:
> Service jboss.xa-data-source-config.testXaDs.xa-datasource-properties.xaProp2 was depended upon by service jboss.xa-data-source-config.testXaDs",
>             "rolled-back" => true
>         },
>         "step-4" => {
>             "outcome" => "failed",
>             "response-headers" => {"operation-requires-reload" => true},
>             "rolled-back" => true
>         }
>     },
>     "failure-description" => {"WFLYCTL0062: Composite operation failed and was rolled back. Steps that failed:" => {
>         "Operation step-7" => "WFLYCTL0171: Removing services has lead to unsatisfied dependencies:
> Service jboss.xa-data-source-config.testXaDs.xa-datasource-properties.URL was depended upon by service jboss.xa-data-source-config.testXaDs",
>         "Operation step-9" => "WFLYCTL0171: Removing services has lead to unsatisfied dependencies:
> Service jboss.xa-data-source-config.testXaDs.xa-datasource-properties.xaProp2 was depended upon by service jboss.xa-data-source-config.testXaDs"
>     }},
>     "rolled-back" => true,
>     "response-headers" => {"process-state" => "reload-required"}
> }
> {code}
> EXPECTED: the operation should succeed
> Workaround: When the same request is sent once again, the second invocation succeeds.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)


More information about the jboss-jira mailing list