While writing to DB I've got following error(exception;) :
java.sql.SQLException: System will shutdown, got I/O Exception while
accessing log file.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.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.TransactionResourceImpl.wrapInSQLException(Un
known Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unkno
wn Source)
at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedConnection.commitIfNeeded(Unknown
Source)
at
org.apache.derby.impl.jdbc.ConnectionChild.commitIfNeeded(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unkno
wn Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
at
pegasus.logging.derby.appenders.DerbyWriterForCurrent.makePersistent(Der
byWriterForCurrent.java:44)
at
pegasus.logging.derby.appenders.DerbyAppender.appendRecord(DerbyAppender
.java:88)
at
pegasus.logging.derby.appenders.DerbyAppender.appendEvent(DerbyAppender.
java:80)
at
pegasus.logging.derby.appenders.DerbyAppender.append(DerbyAppender.java:
112)
at
org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:230)
at
org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(Ap
penderAttachableImpl.java:65)
at
org.apache.log4j.Category.callAppenders(Category.java:203)
at
org.apache.log4j.Category.forcedLog(Category.java:388)
at org.apache.log4j.Category.log(Category.java:853)
at
pegasus.logging.tracingmachines.log4j.Log4jLoggingLogger.delegateLogging
(Log4jLoggingLogger.java:530)
at
pegasus.logging.tracingmachines.log4j.Log4jLoggingLogger.genericLog(Log4
jLoggingLogger.java:329)
at
pegasus.logging.internal.factories.LoggerAdapter.delegateLogging(LoggerA
dapter.java:341)
at
pegasus.logging.internal.factories.LoggerAdapter.debug(LoggerAdapter.jav
a:73)
at
pegasus.logging.internal.factories.LoggerAdapter.debug(LoggerAdapter.jav
a:58)
at
pegasus.rfiav.udpcp.internal.DataRegistry.receive(DataRegistry.java:68)
at
pegasus.rfiav.udpcp.internal.UdpcpState.receive(UdpcpState.java:56)
at
pegasus.rfiav.udpcp.UdpcpServerSocket.processData(UdpcpServerSocket.java
:150)
at
pegasus.rfiav.udpcp.UdpcpServerSocket.receiveFragment(UdpcpServerSocket.
java:104)
at
pegasus.rfiav.udpcp.UdpcpSocket$UdpcpSocketReceiver.run(UdpcpSocket.java
:176)
Caused by: java.sql.SQLException: System will shutdown, got I/O
Exception while accessing log file.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcr
ossDRDA(Unknown Source)
... 30 more
Caused by: java.sql.SQLException: Java exception:
'D:\repos\TOPIK\workspace\log\db_20120614_114744\loggingDB20120614_11474
4\log\log2846.dat (The process cannot access the file because it is
being used by another process): java.io.FileNotFoundException'.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcr
ossDRDA(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.javaException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Un
known Source)
... 27 more
Caused by: java.io.FileNotFoundException:
D:\repos\TOPIK\workspace\log\db_20120614_114744\loggingDB20120614_114744
\log\log2846.dat (The process cannot access the file because it is being
used by another process)
at java.io.RandomAccessFile.open(Native Method)
at java.io.RandomAccessFile.<init>(Unknown Source)
at
org.apache.derby.impl.io.DirRandomAccessFile.<init>(Unknown Source)
at
org.apache.derby.impl.io.DirFile4.getRandomAccessFile(Unknown Source)
at
org.apache.derby.impl.store.raw.log.LogToFile.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native
Method)
at
org.apache.derby.impl.store.raw.log.LogToFile.privRandomAccessFile(Unkno
wn Source)
at
org.apache.derby.impl.store.raw.log.LogToFile.openLogFileInWriteMode(Unk
nown Source)
at
org.apache.derby.impl.store.raw.log.LogToFile.switchLogFile(Unknown
Source)
at
org.apache.derby.impl.store.raw.log.LogToFile.flush(Unknown Source)
at
org.apache.derby.impl.store.raw.log.LogToFile.flush(Unknown Source)
at
org.apache.derby.impl.store.raw.log.FileLogger.flush(Unknown Source)
at
org.apache.derby.impl.store.raw.xact.Xact.prepareCommit(Unknown Source)
at
org.apache.derby.impl.store.raw.xact.Xact.commit(Unknown Source)
at
org.apache.derby.impl.store.raw.xact.Xact.commit(Unknown Source)
at
org.apache.derby.impl.store.access.RAMTransaction.commit(Unknown Source)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.doCommit
(Unknown Source)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.userComm
it(Unknown Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.commit(Unknown
Source)
... 24 more
Dev guide of derby says that : /log directory
Contains files that make up the database transaction log, used
internally for data recovery (not the same thing as the error log).
http://db.apache.org/derby/docs/dev/devguide/cdevdvlp40724.html
There aren't select's performed on DB - however updates occur.
Default isolation level is set.
Any idea?
..........................
Regards / Pozdrowienia
Jan Bartosz
MBB RP I&V Tools&Autom Pegasus Core PL
My contact info in Phonebook
<http://domino.inside.nokiasiemensnetworks.com/nsn/phonebook.nsf/n/61282
459>
Click to call me by using Softphone <sip:[email protected]>
