ERROR XSLA2: System will shutdown, got I/O Exception while accessing log file

[Farid subhan <as...@gmail.com>]

Hi,

  I am a derby user. I get the following error message very rarely when
there is a persistence storage error.

The error code XSLA2 refers to System will shutdown, got I/O Exception while
accessing log file. I donot get any other information from this error.
Can you please help me find out the root cause of this and how can i avoid
this error in future.


thanks and regards,
Farid.


ERROR XSLA2: System will shutdown, got I/O Exception while accessing log
file.
at org.apache.derby.iapi.error.StandardException.newException(
StandardException.java)
at org.apache.derby.impl.store.raw.log.LogToFile.switchLogFile(
LogToFile.java)
at org.apache.derby.impl.store.raw.log.LogToFile.flush(LogToFile.java)
at org.apache.derby.impl.store.raw.log.LogToFile.flush(LogToFile.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.flush(
BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.data.CachedPage.writePage(CachedPage.java
)
at org.apache.derby.impl.store.raw.data.CachedPage.clean(CachedPage.java)
at org.apache.derby.impl.services.cache.CachedItem.clean(CachedItem.java)
at org.apache.derby.impl.services.cache.Clock.rotateClock(Clock.java)
at org.apache.derby.impl.services.cache.Clock.findFreeItem(Clock.java)
at org.apache.derby.impl.services.cache.Clock.create(Clock.java)
at org.apache.derby.impl.store.raw.data.FileContainer.initPage(
FileContainer.java)
at org.apache.derby.impl.store.raw.data.FileContainer.newPage(
FileContainer.java)
at org.apache.derby.impl.store.raw.data.BaseContainer.addPage(
BaseContainer.java)
at org.apache.derby.impl.store.raw.data.BaseContainerHandle.addPage(
BaseContainerHandle.java)
at org.apache.derby.impl.store.access.btree.LeafControlRow.Allocate(
LeafControlRow.java)
at org.apache.derby.impl.store.access.btree.LeafControlRow.splitFor(
LeafControlRow.java)
at org.apache.derby.impl.store.access.btree.BranchControlRow.splitFor(
BranchControlRow.java)
at
org.apache.derby.impl.store.access.btree.BTreeController.start_xact_and_dosplit
(BTreeController.java)
at org.apache.derby.impl.store.access.btree.BTreeController.doIns(
BTreeController.java)
at org.apache.derby.impl.store.access.btree.BTreeController.insert(
BTreeController.java)
at org.apache.derby.impl.store.access.btree.index.B2IController.insert(
B2IController.java)
at org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(
IndexChanger.java)
at org.apache.derby.impl.sql.execute.IndexChanger.doInsert(IndexChanger.java
)
at org.apache.derby.impl.sql.execute.IndexChanger.insert(IndexChanger.java)
at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(
IndexSetChanger.java)
at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(
RowChangerImpl.java)
at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(
InsertResultSet.java)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(
InsertResultSet.java)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(
GenericPreparedStatement.java)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(
EmbedStatement.java)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(
EmbedPreparedStatement.java)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(
EmbedPreparedStatement.java)
at org.jpox.store.rdbms.request.Request.executeUpdate(Request.java:69)
at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java
:272)
at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2060)
at org.jpox.store.StoreManager.insert(StoreManager.java:733)
at org.jpox.state.StateManagerImpl.internalMakePersistent(
StateManagerImpl.java:3304)
at org.jpox.state.StateManagerImpl.flush(StateManagerImpl.java:4397)
at org.jpox.state.StateManagerImpl.getExternalObjectId(StateManagerImpl.java
:1300)
at org.jpox.state.StateManagerImpl.getObjectId(StateManagerImpl.java:1184)

Re: ERROR XSLA2: System will shutdown, got I/O Exception while accessing log file

[Stanley Bradbury <St...@gmail.com>]

Hi -
It looks like Derby is trying create a new logxx.dat file (method 
switchLogFile) and is failing to do so.  Check for things that would 
prevent file creation like limited disk space, limited open files, etc. 

It is unlikely but also check that the number being assigned to the 
logfiles is not reaching the limit:  4294967295

More info at:  http://issues.apache.org/jira/browse/DERBY-101


ERROR XSLA2: System will shutdown, got I/O Exception while accessing log 
file.
at 
org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
at 
org.apache.derby.impl.store.raw.log.LogToFile.switchLogFile(LogToFile.java)
at org.apache.derby.impl.store.raw.log.LogToFile.flush(LogToFile.java)
at org.apache.derby.impl.store.raw.log.LogToFile.flush(LogToFile.java)

Farid subhan wrote:
> Hi,
>
>   I am a derby user. I get the following error message very rarely 
> when there is a persistence storage error.
>
> The error code XSLA2 refers to System will shutdown, got I/O Exception 
> while accessing log file. I donot get any other information from this 
> error.
> Can you please help me find out the root cause of this and how can i 
> avoid this error in future.
>
>
> thanks and regards,
> Farid.
>
>
> ERROR XSLA2: System will shutdown, got I/O Exception while accessing 
> log file.
> at 
> org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
> at 
> org.apache.derby.impl.store.raw.log.LogToFile.switchLogFile(LogToFile.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.flush(LogToFile.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.flush(LogToFile.java)
> at 
> org.apache.derby.impl.store.raw.data.BaseDataFileFactory.flush(BaseDataFileFactory.java)
> at 
> org.apache.derby.impl.store.raw.data.CachedPage.writePage(CachedPage.java)
> at org.apache.derby.impl.store.raw.data.CachedPage.clean(CachedPage.java)
> at org.apache.derby.impl.services.cache.CachedItem.clean(CachedItem.java)
> at org.apache.derby.impl.services.cache.Clock.rotateClock(Clock.java)
> at org.apache.derby.impl.services.cache.Clock.findFreeItem(Clock.java)
> at org.apache.derby.impl.services.cache.Clock.create(Clock.java)
> at 
> org.apache.derby.impl.store.raw.data.FileContainer.initPage(FileContainer.java)
> at 
> org.apache.derby.impl.store.raw.data.FileContainer.newPage(FileContainer.java)
> at 
> org.apache.derby.impl.store.raw.data.BaseContainer.addPage(BaseContainer.java)
> at 
> org.apache.derby.impl.store.raw.data.BaseContainerHandle.addPage(BaseContainerHandle.java)
> at 
> org.apache.derby.impl.store.access.btree.LeafControlRow.Allocate(LeafControlRow.java)
> at 
> org.apache.derby.impl.store.access.btree.LeafControlRow.splitFor(LeafControlRow.java)
> at 
> org.apache.derby.impl.store.access.btree.BranchControlRow.splitFor(BranchControlRow.java)
> at 
> org.apache.derby.impl.store.access.btree.BTreeController.start_xact_and_dosplit(BTreeController.java)
> at 
> org.apache.derby.impl.store.access.btree.BTreeController.doIns(BTreeController.java)
> at 
> org.apache.derby.impl.store.access.btree.BTreeController.insert(BTreeController.java)
> at 
> org.apache.derby.impl.store.access.btree.index.B2IController.insert(B2IController.java)
> at 
> org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(IndexChanger.java)
> at 
> org.apache.derby.impl.sql.execute.IndexChanger.doInsert(IndexChanger.java)
> at 
> org.apache.derby.impl.sql.execute.IndexChanger.insert(IndexChanger.java)
> at 
> org.apache.derby.impl.sql.execute.IndexSetChanger.insert(IndexSetChanger.java)
> at 
> org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(RowChangerImpl.java)
> at 
> org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(InsertResultSet.java)
> at 
> org.apache.derby.impl.sql.execute.InsertResultSet.open(InsertResultSet.java)
> at 
> org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java)
> at 
> org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java)
> at 
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java)
> at 
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(EmbedPreparedStatement.java)
> at org.jpox.store.rdbms.request.Request.executeUpdate(Request.java:69)
> at 
> org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:272)
> at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2060)
> at org.jpox.store.StoreManager.insert(StoreManager.java:733)
> at 
> org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3304)
> at org.jpox.state.StateManagerImpl.flush(StateManagerImpl.java:4397)
> at 
> org.jpox.state.StateManagerImpl.getExternalObjectId(StateManagerImpl.java:1300)
> at org.jpox.state.StateManagerImpl.getObjectId(StateManagerImpl.java:1184)