fail to check-in all change
yu wang (488●1●62●45)
| asked Feb 25 '08, 1:51 a.m.
retagged Oct 08 '15, 8:57 a.m. by David Lafreniere (4.8k●7)
I check some changed file and directory,but display following error:
reason: Error uploading new contents return code 500 from http request :internal server error. *********tomcat log************************ cess$0(ExportProxyServiceRecord.java:316) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$1. invoke(ExportProxyServiceRecord.java:106) at $Proxy25.runInTransaction(Unknown Source) at com.ibm.team.repository.service.internal.RepositoryItemService.saveIt em(RepositoryItemService.java:1357) at sun.reflect.GeneratedMethodAccessor99.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:615) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in voke(ExportProxyServiceRecord.java:324) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac cess$0(ExportProxyServiceRecord.java:316) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$1. invoke(ExportProxyServiceRecord.java:106) at $Proxy50.saveItem(Unknown Source) at com.ibm.team.repository.service.internal.ComponentRepositoryItemServi ce.saveItem(ComponentRepositoryItemService.java:222) at com.ibm.team.repository.service.internal.ChangeEventService.save(Chan geEventService.java:160) at sun.reflect.GeneratedMethodAccessor118.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:615) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in voke(ExportProxyServiceRecord.java:324) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac cess$0(ExportProxyServiceRecord.java:316) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$1. invoke(ExportProxyServiceRecord.java:106) at $Proxy53.save(Unknown Source) at com.ibm.team.repository.service.internal.LogChangeEventAppenderTask.s aveChangeEventsForLogEntries(LogChangeEventAppenderTask.java:61) at com.ibm.team.repository.service.internal.LogChangeEventAppenderTask.r unTask(LogChangeEventAppenderTask.java:82) at com.ibm.team.repository.service.async.AbstractAutoScheduledTask.execu teTask(AbstractAutoScheduledTask.java:116) at com.ibm.team.repository.service.internal.scheduler.InstrumentedAsynch ronousTask.executeTask(InstrumentedAsynchronousTask.java:63) at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRu nner.run(AsynchronousTaskRunner.java:147) at java.lang.Thread.run(Thread.java:801) 12:44:08,328 WARN com.ibm.team.repository - An exception occurred while trying to add some log entries t o the feed com.ibm.team.repository.common.TeamRepositoryException: Failed to create change event for log entry at com.ibm.team.repository.service.internal.LogChangeEventAppenderTask.s aveChangeEventsForLogEntries(LogChangeEventAppenderTask.java:67) at com.ibm.team.repository.service.internal.LogChangeEventAppenderTask.r unTask(LogChangeEventAppenderTask.java:82) at com.ibm.team.repository.service.async.AbstractAutoScheduledTask.execu teTask(AbstractAutoScheduledTask.java:116) at com.ibm.team.repository.service.internal.scheduler.InstrumentedAsynch ronousTask.executeTask(InstrumentedAsynchronousTask.java:63) at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRu nner.run(AsynchronousTaskRunner.java:147) at java.lang.Thread.run(Thread.java:801) Caused by: com.ibm.team.repository.common.RetryableDatabaseException: Virtual storage or da tabase resource is not available. SQL: Insert Into REPOSITORY.CHANGE_EVENT (STATE_ID, ITEM_ID, MODIFIED, MODIFIED_ BY_ITEM_ID, EVENT_OWNER_NS, EVENT_TIME, EVENT_AUTHOR_ITEM_ID, EVENT_CATEGORY, EV ENT_PRIORITY, EVENT_PROCESS_AREA_ITEM_ID, JZ_EVENT_PROCESS_AREA_DSCRMNTR, EVENT_ EXPIRATION, ITEM_ITEM_ID, JZ_ITEM_DISCRIMINATOR) Values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SQL Exception #1 SQL Message: DB2 SQL error: SQLCODE: -964, SQLSTATE: 57011, SQLERRMC: null SQL State: 57011 Error Code: -964 at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.Abstr actErrLogWrapper.logAndReturnException(AbstractErrLogWrapper.java:94) at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.State mentErrLogWrapper.logAndReturnException(StatementErrLogWrapper.java:66) at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.Prepa redStatementErrLogWrapper.executeUpdate(PreparedStatementErrLogWrapper.java:88) at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.Prepare dStatementLeakWrapper.executeUpdate(PreparedStatementLeakWrapper.java:59) at com.ibm.team.repository.service.internal.dataaccess.BatchingRowReceiv er.executeBatch(BatchingRowReceiver.java:319) at com.ibm.team.repository.service.internal.dataaccess.BatchingRowReceiv er.execute(BatchingRowReceiver.java:180) at com.ibm.team.repository.service.internal.dataaccess.IRowReceiver$IRow ReceiverLocator.executePendingChanges(IRowReceiver.java:140) at com.ibm.team.repository.service.internal.dataaccess.FlushingMediatorS ervice.flush(FlushingMediatorService.java:57) at com.ibm.team.repository.service.internal.dataaccess.FlushingMediatorS ervice.saveNew(FlushingMediatorService.java:70) at com.ibm.team.repository.service.internal.dataaccess.MediatorServiceDe legator.saveNew(MediatorServiceDelegator.java:53) at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.cr eateSimpleItem(RdbRepositoryDataMediator.java:580) at com.ibm.team.repository.service.internal.RepositoryItemService.doCrea teSimpleItem(RepositoryItemService.java:1605) at com.ibm.team.repository.service.internal.RepositoryItemService.doSave SimpleItem(RepositoryItemService.java:1576) at com.ibm.team.repository.service.internal.RepositoryItemService.doSave Item(RepositoryItemService.java:1390) at com.ibm.team.repository.service.internal.RepositoryItemService.access $14(RepositoryItemService.java:1366) at com.ibm.team.repository.service.internal.RepositoryItemService$24.run (RepositoryItemService.java:1360) at com.ibm.team.repository.service.internal.RepositoryItemService$24.run (RepositoryItemService.java:1) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Trans action.run(RepositoryDatabase.java:449) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTr ansaction(RepositoryDatabase.java:263) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runIn Transaction(RepositoryDatabase.java:218) at com.ibm.team.repository.service.internal.TransactionService.runInTran saction(TransactionService.java:77) at sun.reflect.GeneratedMethodAccessor69.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:615) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in voke(ExportProxyServiceRecord.java:324) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac cess$0(ExportProxyServiceRecord.java:316) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$1. invoke(ExportProxyServiceRecord.java:106) at $Proxy25.runInTransaction(Unknown Source) at com.ibm.team.repository.service.internal.RepositoryItemService.saveIt em(RepositoryItemService.java:1357) at sun.reflect.GeneratedMethodAccessor99.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:615) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in voke(ExportProxyServiceRecord.java:324) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac cess$0(ExportProxyServiceRecord.java:316) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$1. invoke(ExportProxyServiceRecord.java:106) at $Proxy50.saveItem(Unknown Source) at com.ibm.team.repository.service.internal.ComponentRepositoryItemServi ce.saveItem(ComponentRepositoryItemService.java:222) at com.ibm.team.repository.service.internal.ChangeEventService.save(Chan geEventService.java:160) at sun.reflect.GeneratedMethodAccessor118.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:615) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in voke(ExportProxyServiceRecord.java:324) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac cess$0(ExportProxyServiceRecord.java:316) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$1. invoke(ExportProxyServiceRecord.java:106) at $Proxy53.save(Unknown Source) at com.ibm.team.repository.service.internal.LogChangeEventAppenderTask.s aveChangeEventsForLogEntries(LogChangeEventAppenderTask.java:61) ... 5 more Caused by: com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -964, SQLSTATE: 57011, S QLERRMC: null at com.ibm.db2.jcc.b.zc.d(zc.java:1351) at com.ibm.db2.jcc.a.db.l(db.java:366) at com.ibm.db2.jcc.a.db.a(db.java:64) at com.ibm.db2.jcc.a.r.a(r.java:48) at com.ibm.db2.jcc.a.tb.c(tb.java:266) at com.ibm.db2.jcc.b.ad.Z(ad.java:1666) at com.ibm.db2.jcc.b.ad.d(ad.java:2224) at com.ibm.db2.jcc.b.ad.V(ad.java:521) at com.ibm.db2.jcc.b.ad.executeUpdate(ad.java:504) at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.Prepare dStatementStatWrapper.executeUpdate(PreparedStatementStatWrapper.java:63) at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.Prepa redStatementErrLogWrapper.executeUpdate(PreparedStatementErrLogWrapper.java:86) ... 48 more 12:50:41,281 ERROR sqlExceptionLogger - Virtual storage or database resource is not available. SQL: insert into REPOSITORY.CONTENT_STORAGE (UUID, OWNER_ITEM_UUID, FILE_SIZE, M IME_TYPE, MODIFIED, DELTA_PARENT, COMPRESSION_METHOD, CONTENT_BYTES) values (?, ?, ?, ?, ?, ?, ?, ?) SQL Exception #1 SQL Message: DB2 SQL error: SQLCODE: -289, SQLSTATE: 57011, SQLERRMC: CONTENTTS SQL State: 57011 Error Code: -289 com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -289, SQLSTATE: 57011, S QLERRMC: CONTENTTS at com.ibm.db2.jcc.b.zc.d(zc.java:1351) at com.ibm.db2.jcc.a.db.l(db.java:366) at com.ibm.db2.jcc.a.db.a(db.java:64) at com.ibm.db2.jcc.a.r.a(r.java:48) at com.ibm.db2.jcc.a.tb.c(tb.java:266) at com.ibm.db2.jcc.b.ad.Z(ad.java:1666) at com.ibm.db2.jcc.b.ad.d(ad.java:2224) at com.ibm.db2.jcc.b.ad.V(ad.java:521) at com.ibm.db2.jcc.b.ad.executeUpdate(ad.java:504) at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.Prepare dStatementStatWrapper.executeUpdate(PreparedStatementStatWrapper.java:63) at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.Prepa redStatementErrLogWrapper.executeUpdate(PreparedStatementErrLogWrapper.java:86) at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.Prepare dStatementLeakWrapper.executeUpdate(PreparedStatementLeakWrapper.java:59) at com.ibm.team.repository.service.internal.db.filestorage.ContentStorag e.saveContent(ContentStorage.java:268) at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.re memberFutureContent(RdbRepositoryDataMediator.java:977) at com.ibm.team.repository.service.internal.ContentService.storeUnclaime dContent(ContentService.java:812) at com.ibm.team.repository.service.internal.ContentService.access$10(Con tentService.java:799) at com.ibm.team.repository.service.internal.ContentService$3$1.persist(C ontentService.java:554) at com.ibm.team.repository.service.internal.ContentService.internalStore ContentFileBuffer(ContentService.java:785) at com.ibm.team.repository.service.internal.ContentService.internalStore Content(ContentService.java:593) at com.ibm.team.repository.service.internal.ContentService.access$11(Con tentService.java:576) at com.ibm.team.repository.service.internal.ContentService$3.run(Content Service.java:550) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Trans action.run(RepositoryDatabase.java:449) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTr ansaction(RepositoryDatabase.java:263) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runIn Transaction(RepositoryDatabase.java:218) at com.ibm.team.repository.service.internal.TransactionService.runInTran saction(TransactionService.java:77) at sun.reflect.GeneratedMethodAccessor69.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:615) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in voke(ExportProxyServiceRecord.java:324) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac cess$0(ExportProxyServiceRecord.java:316) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$1. invoke(ExportProxyServiceRecord.java:106) at $Proxy25.runInTransaction(Unknown Source) at com.ibm.team.repository.service.internal.ContentService.doPut(Content Service.java:565) at com.ibm.team.repository.service.internal.ContentService.put(ContentSe rvice.java:1126) at sun.reflect.GeneratedMethodAccessor325.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:615) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in voke(ExportProxyServiceRecord.java:324) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac cess$0(ExportProxyServiceRecord.java:316) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$1. invoke(ExportProxyServiceRecord.java:106) at $Proxy32.put(Unknown Source) at com.ibm.team.repository.servlet.AbstractTeamServerServlet.doPut(Abstr actTeamServerServlet.java:687) at javax.servlet.http.HttpServlet.service(HttpServlet.java:712) at com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(Abs tractTeamServerServlet.java:1334) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrap per.service(ServletManager.java:180) at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleR equest(ServletRegistration.java:90) at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(P roxyServlet.java:111) at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyS ervlet.java:75) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet .java:115) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV alve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV alve.java:178) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica torBase.java:432) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j ava:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j ava:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal ve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav a:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java :869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p rocessConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo int.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol lowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP ool.java:684) at java.lang.Thread.run(Thread.java:801) *********************tomcat log*********************** how to do? |
6 answers
On Mon, 25 Feb 2008 06:57:49 +0000, openeis wrote:
SQL Message: DB2 SQL error: SQLCODE: -289, SQLSTATE: 57011, SQLERRMC: This means the transaction log is full. Increasing the log size should solve this problem. - Dmitry |
On Mon, 25 Feb 2008 13:54:18 +0000, Dmitry Karasik wrote:
SQL Message: DB2 SQL error: SQLCODE: -289, SQLSTATE: 57011, SQLERRMC: Sorry that's wrong, this means your CONTENTTS tablespace is full. The other error you have: SQL Message: DB2 SQL error: SQLCODE: -964, SQLSTATE: 57011, SQLERRMC: null means your transaction log is full as well. - Dmitry |
|
Hi all,
What would be the workaround for the following error then SQLCODE: -1218, SQLSTATE: 57011, SQLERRMC: 4096 ? The SQLSTATE specifies the following: Virtual storage or database resource is not available The SQLCode Error SQL1218N There are no pages currently available in bufferpool buffpool-num. Explanation All of the pages in the bufferpool are currently being used. A request to use another page failed. The statement cannot be processed. User response The bufferpool is not large enough to provide pages to all database processes or threads at this time. The bufferpool is too small or there are too many active processes or threads. The statement may be successful if executed again. If this error occurs frequently, some or all of the following actions may prevent further failures: 1. increase the bufferpool size 2. decrease the maximum number of database agents and/or connections 3. decrease the maximum degree of parallelism 4. decrease the prefetch size for table spaces that are in this bufferpool 5. move some table spaces into other bufferpools. sqlcode: -1218 sqlstate: 57011 How can we auto increase the buffer pool? We're still using Jazz 0.6M5a Thanks! |
On Thu, 12 Jun 2008 04:57:50 +0000, Thunder wrote:
How can we auto increase the buffer pool? We're still using Jazz 0.6M5a Run the command: select npages, bpname from syscat.bufferpools then pick the name of the bufferpool whose size you want to set to automatic and run: alter bufferpool <name> immediate size automatic Note however that I have not had success with setting the size to automatic (on db2 9.5fp1) as it does not grow enough when there is a sudden spike in the need for bufferpool pages. Instead I set the size to 16384 pages using: alter bufferpool <name> immediate size 16384 and that has been working much better. - Dmitry |
|
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.