Performance issue in loading repository workspace to our sandbox
Hi, we're getting the error below when loading a repository workspace to our sandbox.
2012-10-01 12:43:02,526 [ ccm: AsynchronousTaskRunner-4] ERROR com.ibm.team.process - CRJAZ6016E:Exception occurred attempting to load project area change listeners.
java.lang.IllegalStateException: CRJAZ1100I Extension service has not been started.
at com.ibm.team.repository.common.transport.registry.ExtensionServiceElementDescriptor.getImplementation(ExtensionServiceElementDescriptor.java:349)
at com.ibm.team.process.internal.service.ProjectAreaChangeListenerRegistry$ProjectAreaChangeListenerExtensionServiceElementDescriptor.getImplementation(ProjectAreaChangeListenerRegistry.java:233)
at com.ibm.team.process.internal.service.ProjectAreaChangeListenerRegistry.getCalledOnAllNodesListeners(ProjectAreaChangeListenerRegistry.java:200)
at com.ibm.team.process.internal.service.ProjectAreaChangeListenerRunningOnAllNodesTask.runTask(ProjectAreaChangeListenerRunningOnAllNodesTask.java:47)
at com.ibm.team.repository.service.async.AbstractAutoScheduledTask.executeTask(AbstractAutoScheduledTask.java:87)
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getSchemaDescriptor(Unknown Source)
at org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(Unknown Source)
at org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(Unknown Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unknown Source)
at org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source)
at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
... 58 more
2012-09-18 11:09:59,361 [ AsynchronousTaskRunner-1] ERROR sqlTxLogger - Exception preparing SQL: SELECT c.HASH_CODE, c.DELTA_PREDECESSOR FR
OM SCM.CONTENT c LEFT OUTER JOIN SCM.CONTENT_CLAIMER cl on c.HASH_CODE = cl.CLAIMED_CONTENT_HASH WHERE c.SEQUENCE = 0 AND cl.CLAIMED_CONTENT_HASH IS NULL
2012-09-18 11:09:59,364 [ AsynchronousTaskRunner-1] ERROR com.ibm.team.scm - CRRTC5001E SQL Exception encountered
java.sql.SQLSyntaxErrorException: Schema 'SCM' does not exist
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
2 answers
that looks bad, as if the database has an issue, not as if you have a performance issue. I would check the logs of the server if there are more errors, also use diagnostics (based on the RTC version you run) and check if there are service errors. Can you access SCM using the Web UI? If the database has an issue you might want to consider restoring a backup. You could even do this on an isolated test system to check if it fixes your issue.
Please be aware, Derby is really only supposed to be used for standalone test and demo systems. Any production system, even for very few users should use an enterprise DB. You can get DB2 on the Optional Programs tab on the download page of your version.
See http://dtoczala.wordpress.com/ for some hints, especially JazzMon https://jazz.net/library/article/822.
Also see https://jazz.net/blog/index.php/2012/05/15/performance-health-check/ for the Performance Health Check Widget and how to use it.
For the Eclipse client you can use the Metronome https://jazz.net/library/article/503 to look into performance issues.
Last but not least there is the server diagnostics: on https://<Server>:<Port>/jts/admin#action=jazz.viewPage&id=com.ibm.team.repository.server you can see various items in the top left menu. In 4.0 the Diagnostics should give you a health check and you can also downoad the stats mentioned in the JazzMon article. The diagnostics is also available for each application (replace jts by ccm or another context root.).
Are you running your client machines stand alone or in VMWare?
Comments
Jojie Valiente
Oct 01 '12, 7:22 p.m.Hi Ralph,
Thanks for replying on this post.
We're using Oracle 11g R2 DB. And the weird thing about this issue is that only one in my team is not facing this performance issue. Our sys admin yesterday had monitored the logs and couldn't find any other error except for this one.
What do you mean by use diagnostics based on RTC version we are running? Is there a tool for this?
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Oct 02 '12, 2:27 a.m.If you use Oracle, the error above is most likely due to the data warehouse. See answers below on performance monitoring.
Is there something special about the one not facing the performance issue? Different hardware, network connection/adapter (more than one) etc?