tmurphygns
New Member Posts:3
|
08 Apr 2014 02:35 PM |
|
I am unable to delete a namespace. Using either API code or the DTS Editor, my server reaches 99% cpu (with db process hogging it all) and essentially freezes up. This is with DTS4 under Jboss and SQL Server Enterprise Edition. Previously, I noticed that deleting even a small namespace - with nothing in it or with just 1 or 2 concepts in it - was taking around 10 *minutes*. The namespace I am trying to delete has perhaps 1-2 thousand concepts in it. Using the database diagnostic tools, the offending query appears to be: DELETE FROM dts_defining_concept t, deleted d WHERE t.concept_gid = d.gid OR t.superconcept_gid = d.gid;
|
|
|
|
|
tmurphygns
New Member Posts:3
|
08 Apr 2014 02:55 PM |
|
Slight mistake. SQL Server says the long running query is: DELETE FROM dts_defining_concept FROM dts_defining_concept t, deleted d WHERE t.concept_gid = d.gid OR t.superconcept_gid = d.gid; Also, after about an hour and a half, JBoss kills the transaction, and although sql server appears to recover at that point, jboss seems to go into an unuseable state, meaning it does not respond to browser requests. |
|
|
|
|
jbowie
Basic Member Posts:110
|
09 Apr 2014 08:27 AM |
|
We are aware of this performance/functionality problem on deletion of Namespaces and are working to correct. In addition to MySQL support, performance improvement is a major focus of Version 4.1. In the meantime, we would recommend using the kbDelete batch file (found in ...\bin\kb\content\delete ) for deleting large Namespaces. A short "user guide" on use of kbDelete is attached. |
|
|
|
|
tmurphygns
New Member Posts:3
|
22 Apr 2014 01:18 PM |
|
1. The kbcontent-delete.xml file has some kind of bug in it (won't parse) so I had to remove all the connection info to make this work. 2. The app server appears to cache the namespace names; if I refresh the tree in a browser I continue to see the deleted namespace It also took around 80 second to delete a namespace that consisted of just a single concept having a single property and no associations.
|
|
|
|
|