It's all about the answers!

Ask a question

Derby problems


Daniele Grignani (16131) | asked Feb 07 '10, 10:30 a.m.
Hi
my Rational Team Concert 2.0.0.2 Server on Linux 64 (with Apache Derby) worked well, but, without any warning, Apache Derby has had some problems. Here the stacktrace from jazz.log:

2010-02-07 00:20:03,115 INFO uration.OverridablePropertyFileServerConfiguration - CRJAZ1363I Loading configuration from "file:///opt/IBM/TeamConcert/server/conf/jazz/teamserver.properties".
2010-02-07 00:20:06,029 INFO .repository.service.internal.rdb.ConnectionFactory - CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: repositoryDB
2010-02-07 00:20:07,588 ERROR .repository.service.internal.rdb.ConnectionFactory - CRJAZ0503I Failed to connect to the database: "Failed to start database 'repositoryDB', see the next exception for details."
Db Name/Location: "repositoryDB"
java.sql.SQLException: Failed to start database 'repositoryDB', see the next exception for details.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
at org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
at com.ibm.team.repository.service.db.provider.AbstractDbProvider.getConnection(AbstractDbProvider.java:115)
at com.ibm.team.repository.jdbcdriver.internal.derby.DerbyProvider.getConnection(DerbyProvider.java:77)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy20.getConnection(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.ConnectionFactory.createConnection(ConnectionFactory.java:89)
at com.ibm.team.repository.service.internal.rdb.JDBCConnectionPool.createEntry(JDBCConnectionPool.java:57)
at com.ibm.team.repository.service.internal.rdb.AbstractPool.getEntry(AbstractPool.java:199)
at com.ibm.team.repository.service.internal.rdb.JDBCConnectionPool.getConnection(JDBCConnectionPool.java:93)
at com.ibm.team.repository.service.internal.schemagen.PersistentMappingService.activate(PersistentMappingService.java:85)
at com.ibm.team.repository.service.AbstractService.bindRequiredServices(AbstractService.java:182)
at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.bindRequiredServices(AbstractActivationManagerOwner.java:236)
at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.doActivate(AbstractActivationManagerOwner.java:583)
at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.activate(AbstractActivationManagerOwner.java:166)
at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager.activate(BundleActivationManager.java:290)
at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager.performActivation(BundleActivationManager.java:1589)
at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager.access$2(BundleActivationManager.java:1574)
at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager$3.acquired(BundleActivationManager.java:573)
at org.eclipse.soda.sat.core.internal.record.container.ImportServiceRecordContainer.serviceAcquired(ImportServiceRecordContainer.java:582)
at org.eclipse.soda.sat.core.internal.record.container.ImportServiceRecordContainer.access$1(ImportServiceRecordContainer.java:566)
at org.eclipse.soda.sat.core.internal.record.container.ImportServiceRecordContainer$5.serviceAcquired(ImportServiceRecordContainer.java:352)
at org.eclipse.soda.sat.core.internal.record.ImportServiceRecord.acquire(ImportServiceRecord.java:116)
at org.eclipse.soda.sat.core.internal.record.container.ImportServiceRecordContainer$1.execute(ImportServiceRecordContainer.java:64)
at org.eclipse.soda.sat.core.internal.record.container.ServiceRecordContainer.doForService(ServiceRecordContainer.java:363)
at org.eclipse.soda.sat.core.internal.record.container.ServiceRecordContainer.doForEach(ServiceRecordContainer.java:330)
at org.eclipse.soda.sat.core.internal.record.container.ImportServiceRecordContainer.acquire(ImportServiceRecordContainer.java:303)
at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager.acquireImportedServices(BundleActivationManager.java:234)
at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager.acquireImportServiceRecords(BundleActivationManager.java:250)
at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager.startSync(BundleActivationManager.java:2054)
at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager.start(BundleActivationManager.java:2023)
at com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.register(OsgiServicesManager.java:404)
at com.ibm.team.repository.common.transport.services.TeamServiceRegistry.registerServices(TeamServiceRegistry.java:325)
at com.ibm.team.repository.common.transport.services.TeamServiceRegistry.initialize(TeamServiceRegistry.java:286)
at com.ibm.team.repository.common.transport.services.TeamServiceRegistry.start(TeamServiceRegistry.java:367)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.init(AbstractTeamServerServlet.java:1200)
at com.ibm.team.repository.servlet.TeamServerServlet.init(TeamServerServlet.java:192)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.initializeDelegate(ServletManager.java:195)
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:179)
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:121)
at com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:54)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:811)
Caused by:
java.sql.SQLException: Invalid checksum on Page Page(2,Container(0, 6768)), expected=1,327,448,919, on-disk version=3,467,064,184, page dump follows: Hex dump:
00000000: 0075 0000 0001 0000 0000 0000 1ecd 0016 .u...........ᅪ..

etc.

Where are the problems in your opinion?

thanks

Daniele

3 answers



permanent link
benjamin diz alvarez (811) | answered Oct 08 '10, 12:22 p.m.
Hi Daniele,

I'm currently facing the same problem, was it ever resolved on your end? If not, I will keep you posted with my progress.

Thank you,

Benjamin

permanent link
Lewis Tsao (2174963) | answered Oct 09 '10, 5:57 a.m.
The applicable message is the last exception "Invalid checksum..."

There can be many causes:
1. Disk hardware error.
2. System crash while writing to disk.
3. Most probable, disk full when writing.

Derby database is created in "/opt/IBM/JazzTeamServer....". Usually, /opt is meant to be for installation of apps and will be a director under / which is usually of limited size. Even if /opt is a separate filesystem, it is again usually limited in size.


Hi Daniele,

I'm currently facing the same problem, was it ever resolved on your end? If not, I will keep you posted with my progress.

Thank you,

Benjamin

permanent link
benjamin diz alvarez (811) | answered Nov 22 '10, 10:41 a.m.
Lewis,

Thanks for your insight. In my case the Derby Database had become corrupt and the problem was resolved after switching to a backup.

__________________________
Benjamin Kane
Jazz/RTC Service and Support

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.