[JBoss JIRA] (TEIID-1811) Deleting a VDB from inventory does not remove it
by Van Halbert (Moved) (JIRA)
[ https://issues.jboss.org/browse/TEIID-1811?page=com.atlassian.jira.plugin... ]
Van Halbert moved SOA-3555 to TEIID-1811:
-----------------------------------------
Project: Teiid (was: JBoss Enterprise SOA Platform)
Key: TEIID-1811 (was: SOA-3555)
Affects Version/s: 7.6
(was: 5.2.0 GA)
Component/s: Tools
(was: Documentation)
(was: JON)
Security: (was: Public)
> Deleting a VDB from inventory does not remove it
> ------------------------------------------------
>
> Key: TEIID-1811
> URL: https://issues.jboss.org/browse/TEIID-1811
> Project: Teiid
> Issue Type: Bug
> Components: Tools
> Affects Versions: 7.6
> Environment: JON 2.4.1/3.0.0, PostgreSQL 8.4.8, OpenJDK 1.6.0, SOA-P/EDS
> 5.1.0/5.2.0 GA
> Reporter: Pavel Kralik
> Assignee: Pavel Kralik
>
> Using JON 2.4, deleting a VDB through JON GUI inventory removes the vdb from
> the EDS instance, but does not remove it from inventory. Instead, it shows the
> vdb as unavailable.
> How reproducible:
> Steps to Reproduce:
> 1. Deploy a vdb to EDS
> 2. Have agent report vdb to JON, verify in GUI
> 3. In JON inventory, delete the vdb
> Actual results:
> VDB is removed from physical server but remains in JON inventory, just as
> disabled. It remains there even after running 'discovery -f' from the agent
> console.
> Expected results:
> VDB is removed from physical server and removed from JON inventory.
> Additional info:
> https://bugzilla.redhat.com/show_bug.cgi?id=739789
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 11 months
[JBoss JIRA] (TEIID-1808) Cannot load metadata for dynamic VDB on oracle10g
by Steven Hawkins (Resolved) (JIRA)
[ https://issues.jboss.org/browse/TEIID-1808?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-1808.
-----------------------------------
Resolution: Rejected
>From the soa jira, you are loading the metadata for a recycle bin table: SOAESB1.BIN$mbjj432fhyLgQCIK4iBmlQ==$0. This table must be reported twice in the metadata, which is odd, but not entirely out of the realm of possibility since you are not limiting what metadata the importer should fetch. As the reference states you should be setting schema/table name patterns, etc. to appropriately limit the metadata.
> Cannot load metadata for dynamic VDB on oracle10g
> -------------------------------------------------
>
> Key: TEIID-1808
> URL: https://issues.jboss.org/browse/TEIID-1808
> Project: Teiid
> Issue Type: Bug
> Components: Server
> Affects Versions: 7.4.1
> Reporter: Filip Nguyen
> Assignee: Steven Hawkins
> Attachments: mytext-ds.xml, myvdb-vdb.xml, server.log
>
>
> There seems to be a problem with deploying dynamic VDB (attachment) which loads metadata from Oracle10g. It works on any other database supported by SOA P (including Oracle11g).
> When I deploy the VDB I get:
> {code:title=Server.log|borderStyle=solid}
> 2011-11-03 10:32:26,306 INFO [org.teiid.RUNTIME] (JBoss System Threads(1)-7) VDB myvdb.1 model EMPLOYEES metadata is currently being loaded. Start Time: 11/3/11 10:32 AM
> 2011-11-03 10:32:26,306 INFO [org.teiid.RUNTIME] (JBoss System Threads(1)-8) VDB myvdb.1 model TextFileData metadata is currently being loaded. Start Time: 11/3/11 10:32 AM
> 2011-11-03 10:32:26,307 INFO [org.teiid.RUNTIME] (HDScanner) VDB "myvdb.1[EMPLOYEES[oracle-connector/oracle/java:DefaultDS], TextFileData[text-connector/file/java:TxtFileDS]]" deployed in inactive state.
> 2011-11-03 10:32:26,307 DEBUG [org.jboss.deployers.plugins.deployers.DeployersImpl] (HDScanner) Fully Deployed vfsfile:/home/fnguyen/work/soaplatform/products/esb/jboss-as/server/oracle10g/deploy/myvdb-vdb.xml
> 2011-11-03 10:32:26,323 INFO [org.teiid.RUNTIME] (JBoss System Threads(1)-8) VDB myvdb.1 model TextFileData metadata is currently being loaded.
> ....
> ....
> 2011-11-03 10:35:04,832 WARN [org.teiid.RUNTIME] (JBoss System Threads(1)-7) myvdb.1 is now "incomplete", because model "EMPLOYEES" can not retrieve metadata. Please fix any errors and re-deploy relevant DataSources and/or the VDB.
> {code}
> In web console VDB is not active and contains following errors:
> {code:title=Web console|borderStyle=solid}
> ERROR VDB myvdb.1 model employees metadata is currently being loaded. Start Time: 11/3/11 10:54 AM
> ERROR myvdb.1 is now "incomplete", because model "employees" can not retrieve metadata. Please fix any errors and re-deploy relevant DataSources and/or the VDB.
> ERROR Teiid runtime names, which are case insensitive, for the imported metadata are not unique. If not already set, use the setting importer.useFullSchemaName to create Teiid names that include the source schema.
> {code}
> It looks like there is a problem with content of the database, but I only created one database table:
> {code:title=Employees table|borderStyle=solid}
> --------------------------------------------------------
> -- DDL for Table employees
> --------------------------------------------------------
> CREATE TABLE "SOAESB1"."employees"
> ( "ID" NUMBER(19,0),
> "NAME" VARCHAR2(255 CHAR),
> "SURNAME" VARCHAR2(255 CHAR),
> "SYMBOL" VARCHAR2(255 CHAR)
> ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
> STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
> PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
> TABLESPACE "USERS" ;
> --------------------------------------------------------
> -- DDL for Index SYS_C00330055
> --------------------------------------------------------
> CREATE UNIQUE INDEX "SOAESB1"."SYS_C00330055" ON "SOAESB1"."employees" ("ID")
> PCTFREE 10 INITRANS 2 MAXTRANS 255
> STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
> PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
> TABLESPACE "USERS" ;
> --------------------------------------------------------
> -- Constraints for Table employees
> --------------------------------------------------------
> ALTER TABLE "SOAESB1"."employees" MODIFY ("ID" NOT NULL ENABLE);
>
> ALTER TABLE "SOAESB1"."employees" ADD PRIMARY KEY ("ID")
> USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
> STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
> PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
> TABLESPACE "USERS" ENABLE;
> {code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 11 months
[JBoss JIRA] (TEIID-1808) Cannot load metadata for dynamic VDB on oracle10g
by Van Halbert (Moved) (JIRA)
[ https://issues.jboss.org/browse/TEIID-1808?page=com.atlassian.jira.plugin... ]
Van Halbert moved SOA-3552 to TEIID-1808:
-----------------------------------------
Project: Teiid (was: JBoss Enterprise SOA Platform)
Key: TEIID-1808 (was: SOA-3552)
Affects Version/s: 7.4.1
(was: 5.2.0.ER6)
Component/s: Server
(was: EDS)
Security: (was: Public)
> Cannot load metadata for dynamic VDB on oracle10g
> -------------------------------------------------
>
> Key: TEIID-1808
> URL: https://issues.jboss.org/browse/TEIID-1808
> Project: Teiid
> Issue Type: Bug
> Components: Server
> Affects Versions: 7.4.1
> Reporter: Filip Nguyen
> Assignee: Van Halbert
> Attachments: mytext-ds.xml, myvdb-vdb.xml, server.log
>
>
> There seems to be a problem with deploying dynamic VDB (attachment) which loads metadata from Oracle10g. It works on any other database supported by SOA P (including Oracle11g).
> When I deploy the VDB I get:
> {code:title=Server.log|borderStyle=solid}
> 2011-11-03 10:32:26,306 INFO [org.teiid.RUNTIME] (JBoss System Threads(1)-7) VDB myvdb.1 model EMPLOYEES metadata is currently being loaded. Start Time: 11/3/11 10:32 AM
> 2011-11-03 10:32:26,306 INFO [org.teiid.RUNTIME] (JBoss System Threads(1)-8) VDB myvdb.1 model TextFileData metadata is currently being loaded. Start Time: 11/3/11 10:32 AM
> 2011-11-03 10:32:26,307 INFO [org.teiid.RUNTIME] (HDScanner) VDB "myvdb.1[EMPLOYEES[oracle-connector/oracle/java:DefaultDS], TextFileData[text-connector/file/java:TxtFileDS]]" deployed in inactive state.
> 2011-11-03 10:32:26,307 DEBUG [org.jboss.deployers.plugins.deployers.DeployersImpl] (HDScanner) Fully Deployed vfsfile:/home/fnguyen/work/soaplatform/products/esb/jboss-as/server/oracle10g/deploy/myvdb-vdb.xml
> 2011-11-03 10:32:26,323 INFO [org.teiid.RUNTIME] (JBoss System Threads(1)-8) VDB myvdb.1 model TextFileData metadata is currently being loaded.
> ....
> ....
> 2011-11-03 10:35:04,832 WARN [org.teiid.RUNTIME] (JBoss System Threads(1)-7) myvdb.1 is now "incomplete", because model "EMPLOYEES" can not retrieve metadata. Please fix any errors and re-deploy relevant DataSources and/or the VDB.
> {code}
> In web console VDB is not active and contains following errors:
> {code:title=Web console|borderStyle=solid}
> ERROR VDB myvdb.1 model employees metadata is currently being loaded. Start Time: 11/3/11 10:54 AM
> ERROR myvdb.1 is now "incomplete", because model "employees" can not retrieve metadata. Please fix any errors and re-deploy relevant DataSources and/or the VDB.
> ERROR Teiid runtime names, which are case insensitive, for the imported metadata are not unique. If not already set, use the setting importer.useFullSchemaName to create Teiid names that include the source schema.
> {code}
> It looks like there is a problem with content of the database, but I only created one database table:
> {code:title=Employees table|borderStyle=solid}
> --------------------------------------------------------
> -- DDL for Table employees
> --------------------------------------------------------
> CREATE TABLE "SOAESB1"."employees"
> ( "ID" NUMBER(19,0),
> "NAME" VARCHAR2(255 CHAR),
> "SURNAME" VARCHAR2(255 CHAR),
> "SYMBOL" VARCHAR2(255 CHAR)
> ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
> STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
> PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
> TABLESPACE "USERS" ;
> --------------------------------------------------------
> -- DDL for Index SYS_C00330055
> --------------------------------------------------------
> CREATE UNIQUE INDEX "SOAESB1"."SYS_C00330055" ON "SOAESB1"."employees" ("ID")
> PCTFREE 10 INITRANS 2 MAXTRANS 255
> STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
> PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
> TABLESPACE "USERS" ;
> --------------------------------------------------------
> -- Constraints for Table employees
> --------------------------------------------------------
> ALTER TABLE "SOAESB1"."employees" MODIFY ("ID" NOT NULL ENABLE);
>
> ALTER TABLE "SOAESB1"."employees" ADD PRIMARY KEY ("ID")
> USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
> STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
> PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
> TABLESPACE "USERS" ENABLE;
> {code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 11 months
[JBoss JIRA] (TEIID-1808) Cannot load metadata for dynamic VDB on oracle10g
by Van Halbert (Assigned) (JIRA)
[ https://issues.jboss.org/browse/TEIID-1808?page=com.atlassian.jira.plugin... ]
Van Halbert reassigned TEIID-1808:
----------------------------------
Assignee: Steven Hawkins (was: Van Halbert)
> Cannot load metadata for dynamic VDB on oracle10g
> -------------------------------------------------
>
> Key: TEIID-1808
> URL: https://issues.jboss.org/browse/TEIID-1808
> Project: Teiid
> Issue Type: Bug
> Components: Server
> Affects Versions: 7.4.1
> Reporter: Filip Nguyen
> Assignee: Steven Hawkins
> Attachments: mytext-ds.xml, myvdb-vdb.xml, server.log
>
>
> There seems to be a problem with deploying dynamic VDB (attachment) which loads metadata from Oracle10g. It works on any other database supported by SOA P (including Oracle11g).
> When I deploy the VDB I get:
> {code:title=Server.log|borderStyle=solid}
> 2011-11-03 10:32:26,306 INFO [org.teiid.RUNTIME] (JBoss System Threads(1)-7) VDB myvdb.1 model EMPLOYEES metadata is currently being loaded. Start Time: 11/3/11 10:32 AM
> 2011-11-03 10:32:26,306 INFO [org.teiid.RUNTIME] (JBoss System Threads(1)-8) VDB myvdb.1 model TextFileData metadata is currently being loaded. Start Time: 11/3/11 10:32 AM
> 2011-11-03 10:32:26,307 INFO [org.teiid.RUNTIME] (HDScanner) VDB "myvdb.1[EMPLOYEES[oracle-connector/oracle/java:DefaultDS], TextFileData[text-connector/file/java:TxtFileDS]]" deployed in inactive state.
> 2011-11-03 10:32:26,307 DEBUG [org.jboss.deployers.plugins.deployers.DeployersImpl] (HDScanner) Fully Deployed vfsfile:/home/fnguyen/work/soaplatform/products/esb/jboss-as/server/oracle10g/deploy/myvdb-vdb.xml
> 2011-11-03 10:32:26,323 INFO [org.teiid.RUNTIME] (JBoss System Threads(1)-8) VDB myvdb.1 model TextFileData metadata is currently being loaded.
> ....
> ....
> 2011-11-03 10:35:04,832 WARN [org.teiid.RUNTIME] (JBoss System Threads(1)-7) myvdb.1 is now "incomplete", because model "EMPLOYEES" can not retrieve metadata. Please fix any errors and re-deploy relevant DataSources and/or the VDB.
> {code}
> In web console VDB is not active and contains following errors:
> {code:title=Web console|borderStyle=solid}
> ERROR VDB myvdb.1 model employees metadata is currently being loaded. Start Time: 11/3/11 10:54 AM
> ERROR myvdb.1 is now "incomplete", because model "employees" can not retrieve metadata. Please fix any errors and re-deploy relevant DataSources and/or the VDB.
> ERROR Teiid runtime names, which are case insensitive, for the imported metadata are not unique. If not already set, use the setting importer.useFullSchemaName to create Teiid names that include the source schema.
> {code}
> It looks like there is a problem with content of the database, but I only created one database table:
> {code:title=Employees table|borderStyle=solid}
> --------------------------------------------------------
> -- DDL for Table employees
> --------------------------------------------------------
> CREATE TABLE "SOAESB1"."employees"
> ( "ID" NUMBER(19,0),
> "NAME" VARCHAR2(255 CHAR),
> "SURNAME" VARCHAR2(255 CHAR),
> "SYMBOL" VARCHAR2(255 CHAR)
> ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
> STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
> PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
> TABLESPACE "USERS" ;
> --------------------------------------------------------
> -- DDL for Index SYS_C00330055
> --------------------------------------------------------
> CREATE UNIQUE INDEX "SOAESB1"."SYS_C00330055" ON "SOAESB1"."employees" ("ID")
> PCTFREE 10 INITRANS 2 MAXTRANS 255
> STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
> PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
> TABLESPACE "USERS" ;
> --------------------------------------------------------
> -- Constraints for Table employees
> --------------------------------------------------------
> ALTER TABLE "SOAESB1"."employees" MODIFY ("ID" NOT NULL ENABLE);
>
> ALTER TABLE "SOAESB1"."employees" ADD PRIMARY KEY ("ID")
> USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
> STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
> PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
> TABLESPACE "USERS" ENABLE;
> {code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 11 months
[JBoss JIRA] (TEIID-1804) VDB deployment in EDS can be extremely slow based upon indexing needs
by Johnathon Lee (Created) (JIRA)
VDB deployment in EDS can be extremely slow based upon indexing needs
---------------------------------------------------------------------
Key: TEIID-1804
URL: https://issues.jboss.org/browse/TEIID-1804
Project: Teiid
Issue Type: Bug
Components: Server
Affects Versions: 7.1.1, 7.2, 7.3, 7.4
Environment: JBoss Enterprise Data Services Platform 5.1.0
Reporter: Johnathon Lee
Assignee: Steven Hawkins
Problem:
The index metadata loading logic is not well optimized. In short, each time a call to IndexMetadataFactory.queryIndex is made the blocks are fully scanned. For small VDBs there isn't much of an issue because of the block caching logic, but during a vdb deploy we could be constantly re-reading data from the files.
Possible solution:
The IndexMetadataFactory loading strategy should be made aware of the index file per schema strategy so that scans can be made per schema rather than against all index files.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 11 months