[teiid-issues] [JBoss JIRA] (TEIID-2578) add/remove schema elements

[Kylin Soong (JIRA)]

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

Kylin Soong edited comment on TEIID-2578 at 8/28/16 11:10 PM:
--------------------------------------------------------------

h2. 1. Unit test error
The unit test still have some error
{code}
Tests in error: 
  TestMetadataValidator.testCreateTrigger:142->buildModel:71 » Metadata TEIID312...
  TestMetadataValidator.testCreateTriggerFails:153->buildModel:71 » Metadata TEI...
  TestMetadataValidator.testExternalMaterializationValidate:327->buildModel:71 » Metadata
  TestMetadataValidator.testExternalMaterializationValidateColumnTypes:365->buildModel:71 » Metadata
  TestMetadataValidator.testExternalMaterializationValidateColumns:347->buildModel:71 » Metadata
  TestMetadataValidator.testExternalMaterializationValidateLoadScripts:411->buildModel:71 » Metadata
  TestMetadataValidator.testExternalMaterializationValidateMissingColumns:395->buildModel:71 » Metadata
  TestMetadataValidator.testExternalMaterializationValidateMissingStatus:380->buildModel:71 » Metadata
  TestMetadataValidator.testInternalMaterializationValidate:309->buildModel:71 » Metadata
  TestMetadataValidator.testModelArtifactsSucess:108->buildModel:71 » Metadata T...
  TestMetadataValidator.testProcMetadata:178->buildModel:71 » Metadata TEIID3123...
  TestMetadataValidator.testProcMetadataValidationError:187->buildModel:71 » Metadata
  TestMetadataValidator.testResolveMetadata:130->buildModel:71 » Metadata TEIID3...
  TestMetadataValidator.testResolveMetadataError:206->buildModel:71 » Metadata T...
  TestMetadataValidator.testResolveTempMetadata:197->buildModel:71 » Metadata TE...
  TestMetadataValidator.testViewKeys:488->buildModel:71 » Metadata TEIID31236 No...
  TestMetadataValidator.testViewModelArtifacts:100->buildModel:71 » Metadata TEI...
  TestDDLParser.testAlterDatabase:949->helpParse:763 » Metadata TEIID31214 DataW...
  TestDDLParser.testAlterProcedureOptions:886->helpParse:747 » Parse TEIID30386 ...
  TestDDLParser.testAlterTableAddColumnOptions:844->helpParse:747 » Metadata TEI...
  TestDDLParser.testAlterTableAddOptions:798->helpParse:747 » Metadata TEIID3035...
  TestDDLParser.testAlterTableDropOptions:828->helpParse:747 » Metadata TEIID303...
  TestDDLParser.testAlterTableModifyOptions:813->helpParse:747 » Metadata TEIID3...
  TestDDLParser.testAlterTableRemoveColumnOptions:864->helpParse:747 » Parse TEI...
  TestDDLParser.testAlterView:1114->helpParse:763 » Metadata TEIID30357 G1 does ...

Tests run: 6043, Failures: 0, Errors: 25, Skipped: 65
{code}

h2. 2. create database failed
{code}
/subsystem=teiid:db-store(ddl="create database foo")
{
    "outcome" => "failed",
    "result" => undefined,
    "failure-description" => "WFLYCTL0158: Operation handler failed: org.jboss.msc.service.ServiceNotFoundException: Service service jboss.teiid.database-storage not found",
    "rolled-back" => true
}
{code}

The stacktrace in server
{code}
11:07:59,592 ERROR [org.jboss.as.controller.management-operation] (management-handler-thread - 19) WFLYCTL0013: Operation ("db-store") failed - address: ([("subsystem" => "teiid")]): org.jboss.msc.service.ServiceNotFoundException: Service service jboss.teiid.database-storage not found
	at org.jboss.msc.service.ServiceContainerImpl.getRequiredService(ServiceContainerImpl.java:669)
	at org.jboss.as.controller.OperationContextImpl$OperationContextServiceRegistry.getRequiredService(OperationContextImpl.java:2211)
	at org.teiid.jboss.TeiidOperationHandler.getDatabaseStorage(TeiidOperationHandler.java:165)
	at org.teiid.jboss.DDLExecutor.executeOperation(TeiidOperationHandler.java:1721)
	at org.teiid.jboss.DDLExecutor.executeOperation(TeiidOperationHandler.java:1684)
	at org.teiid.jboss.BaseOperationHandler$1.execute(BaseOperationHandler.java:79)
	at org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:890)
	at org.jboss.as.controller.AbstractOperationContext.processStages(AbstractOperationContext.java:659)
	at org.jboss.as.controller.AbstractOperationContext.executeOperation(AbstractOperationContext.java:370)
	at org.jboss.as.controller.OperationContextImpl.executeOperation(OperationContextImpl.java:1344)
	at org.jboss.as.controller.ModelControllerImpl.internalExecute(ModelControllerImpl.java:392)
	at org.jboss.as.controller.ModelControllerImpl.execute(ModelControllerImpl.java:217)
	at org.jboss.as.controller.remote.ModelControllerClientOperationHandler$ExecuteRequestHandler.doExecute(ModelControllerClientOperationHandler.java:208)
	at org.jboss.as.controller.remote.ModelControllerClientOperationHandler$ExecuteRequestHandler.access$300(ModelControllerClientOperationHandler.java:130)
	at org.jboss.as.controller.remote.ModelControllerClientOperationHandler$ExecuteRequestHandler$1$1.run(ModelControllerClientOperationHandler.java:152)
	at org.jboss.as.controller.remote.ModelControllerClientOperationHandler$ExecuteRequestHandler$1$1.run(ModelControllerClientOperationHandler.java:148)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAs(Subject.java:422)
	at org.jboss.as.controller.AccessAuditContext.doAs(AccessAuditContext.java:92)
	at org.jboss.as.controller.remote.ModelControllerClientOperationHandler$ExecuteRequestHandler$1.execute(ModelControllerClientOperationHandler.java:148)
	at org.jboss.as.protocol.mgmt.AbstractMessageHandler$ManagementRequestContextImpl$1.doExecute(AbstractMessageHandler.java:363)
	at org.jboss.as.protocol.mgmt.AbstractMessageHandler$AsyncTaskRunner.run(AbstractMessageHandler.java:472)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
	at org.jboss.threads.JBossThread.run(JBossThread.java:320)
{code}


was (Author: kylin):
h2. 1. Unit test error
The unit test still have some error
{code}
Tests in error: 
  TestMetadataValidator.testCreateTrigger:142->buildModel:71 » Metadata TEIID312...
  TestMetadataValidator.testCreateTriggerFails:153->buildModel:71 » Metadata TEI...
  TestMetadataValidator.testExternalMaterializationValidate:327->buildModel:71 » Metadata
  TestMetadataValidator.testExternalMaterializationValidateColumnTypes:365->buildModel:71 » Metadata
  TestMetadataValidator.testExternalMaterializationValidateColumns:347->buildModel:71 » Metadata
  TestMetadataValidator.testExternalMaterializationValidateLoadScripts:411->buildModel:71 » Metadata
  TestMetadataValidator.testExternalMaterializationValidateMissingColumns:395->buildModel:71 » Metadata
  TestMetadataValidator.testExternalMaterializationValidateMissingStatus:380->buildModel:71 » Metadata
  TestMetadataValidator.testInternalMaterializationValidate:309->buildModel:71 » Metadata
  TestMetadataValidator.testModelArtifactsSucess:108->buildModel:71 » Metadata T...
  TestMetadataValidator.testProcMetadata:178->buildModel:71 » Metadata TEIID3123...
  TestMetadataValidator.testProcMetadataValidationError:187->buildModel:71 » Metadata
  TestMetadataValidator.testResolveMetadata:130->buildModel:71 » Metadata TEIID3...
  TestMetadataValidator.testResolveMetadataError:206->buildModel:71 » Metadata T...
  TestMetadataValidator.testResolveTempMetadata:197->buildModel:71 » Metadata TE...
  TestMetadataValidator.testViewKeys:488->buildModel:71 » Metadata TEIID31236 No...
  TestMetadataValidator.testViewModelArtifacts:100->buildModel:71 » Metadata TEI...
  TestDDLParser.testAlterDatabase:949->helpParse:763 » Metadata TEIID31214 DataW...
  TestDDLParser.testAlterProcedureOptions:886->helpParse:747 » Parse TEIID30386 ...
  TestDDLParser.testAlterTableAddColumnOptions:844->helpParse:747 » Metadata TEI...
  TestDDLParser.testAlterTableAddOptions:798->helpParse:747 » Metadata TEIID3035...
  TestDDLParser.testAlterTableDropOptions:828->helpParse:747 » Metadata TEIID303...
  TestDDLParser.testAlterTableModifyOptions:813->helpParse:747 » Metadata TEIID3...
  TestDDLParser.testAlterTableRemoveColumnOptions:864->helpParse:747 » Parse TEI...
  TestDDLParser.testAlterView:1114->helpParse:763 » Metadata TEIID30357 G1 does ...

Tests run: 6043, Failures: 0, Errors: 25, Skipped: 65
{code}

> add/remove schema elements
> --------------------------
>
>                 Key: TEIID-2578
>                 URL: https://issues.jboss.org/browse/TEIID-2578
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>            Reporter: Ramesh Reddy
>            Assignee: Ramesh Reddy
>             Fix For: 9.1
>
>
> Schemas are currently static after load.  Modifications can only happen with restarts or new versions.  We should allow add/drop at runtime.



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