It's all about the answers!

Ask a question

fail to check-in all change


yu wang (4886144) | asked Feb 25 '08, 1:51 a.m.
retagged Oct 08 '15, 8:57 a.m. by David Lafreniere (4.8k7)
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



permanent link
Dmitry Karasik (1.8k11) | answered Feb 25 '08, 4:54 a.m.
JAZZ DEVELOPER
On Mon, 25 Feb 2008 06:57:49 +0000, openeis wrote:

SQL Message: DB2 SQL error: SQLCODE: -289, SQLSTATE: 57011, SQLERRMC:
CONTENTTS

This means the transaction log is full. Increasing the log size should
solve this problem.

- Dmitry

permanent link
Dmitry Karasik (1.8k11) | answered Feb 25 '08, 4:56 a.m.
JAZZ DEVELOPER
On Mon, 25 Feb 2008 13:54:18 +0000, Dmitry Karasik wrote:

SQL Message: DB2 SQL error: SQLCODE: -289, SQLSTATE: 57011, SQLERRMC:
CONTENTTS

This means the transaction log is full. Increasing the log size should
solve this problem.



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

permanent link
yu wang (4886144) | answered Mar 03 '08, 2:17 a.m.
Thanks a lot!

permanent link
Adil Chahid (45524118) | answered Jun 12 '08, 12:54 a.m.
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!

permanent link
Dmitry Karasik (1.8k11) | answered Jun 12 '08, 3:54 a.m.
JAZZ DEVELOPER
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

permanent link
Adil Chahid (45524118) | answered Jun 12 '08, 7:27 p.m.
Thanks!

Your answer


Register or to post your answer.