Hi Ram,
Thanks for including the Derby log file. There are lots of errors in
this log. This error looks particularly suspicious:
java.io.IOException: No space left on device at
sun.nio.ch.FileDispatcher.pwrite0(Native Method) at
sun.nio.ch.FileDispatcher.pwrite(FileDispatcher.java:45)
Try freeing up some space on that disk or move your database to a disk
with more room.
Hope this helps,
-Rick
On 2/6/12 5:44 AM, Ram T wrote:
Hi All, I am using derby database to store the information related the
URL's in my content. I will insert the records using Java language and
read them using PHP. We use to remove the unnecessary tables from the
db. i have encountered the below exception. DDL is not permitted for a
read-only connection, user or database I have verified the derby.log
file i found that the above DB started in READ ONLY mode. I don't why
it is started in read only mode. Please suggest how to solve this
issue. Below is the log i found. ================= 2012-01-08
09:48:41.610 GMT: Shutting down instance
161ebc5f-012b-76a2-85ed-0000064a7052
----------------------------------------------------------------
Cleanup action completed 2012-01-08 09:49:13.841 GMT: Shutting down
instance 65f07c71-012b-76a2-85ed-0000064a7052
----------------------------------------------------------------
Cleanup action completed
----------------------------------------------------------------
2012-01-08 09:51:31.773 GMT: Booting Derby version The Apache Software
Foundation - Apache Derby - 10.4.2.0 - (689064): instance
f064522b-012b-76a2-85ed-0000064a7052 on database directory
/home/derby/data/hdcudb Database Class Loader started -
derby.database.classpath=''
----------------------------------------------------------------
2012-01-08 10:22:54.583 GMT: Booting Derby version The Apache Software
Foundation - Apache Derby - 10.4.2.0 - (689064): instance
ed151285-012b-76a2-85ed-0000064a7052 on database directory
/home/derby/data/hrspdb Database Class Loader started -
derby.database.classpath=''
----------------------------------------------------------------
2012-01-10 11:38:49.119 GMT: Booting Derby version The Apache Software
Foundation - Apache Derby - 10.4.2.0 - (689064): instance
ba49cff9-012b-76a2-85ed-0000064a7052 on database directory
/home/derby/data/oplpdb Database Class Loader started -
derby.database.classpath='' 2012-01-13 18:31:26.743 GMT
Thread[DRDAConnThread_143,5,main] Cleanup action starting
java.sql.SQLException: Database 'sthldb' not found. 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.newEmbedSQLException(Unknown
Source) at
org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown
Source) at
org.apache.derby.impl.jdbc.EmbedConnection.handleDBNotFound(Unknown
Source) at org.apache.derby.impl.jdbc.EmbedConnection. (Unknown
Source) at org.apache.derby.impl.jdbc.EmbedConnection30. (Unknown
Source) at org.apache.derby.impl.jdbc.EmbedConnection40. (Unknown
Source) at
org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) at
org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source) at
org.apache.derby.impl.drda.Database.makeConnection(Unknown Source) at
org.apache.derby.impl.drda.DRDAConnThread.getConnFromDatabaseName(Unknown
Source) at
org.apache.derby.impl.drda.DRDAConnThread.verifyUserIdPassword(Unknown
Source) at
org.apache.derby.impl.drda.DRDAConnThread.parseSECCHK(Unknown Source)
at
org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown
Source) at
org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown
Source) at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown
Source) Caused by: java.sql.SQLException: Database 'sthldb' not found.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source) at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source) ... 19 more ============= begin nested exception, level (1)
=========== java.sql.SQLException: Database 'sthldb' not found. at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source) at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(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.newEmbedSQLException(Unknown
Source) at
org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown
Source) at
org.apache.derby.impl.jdbc.EmbedConnection.handleDBNotFound(Unknown
Source) at org.apache.derby.impl.jdbc.EmbedConnection. (Unknown
Source) at org.apache.derby.impl.jdbc.EmbedConnection30. (Unknown
Source) at org.apache.derby.impl.jdbc.EmbedConnection40. (Unknown
Source) at
org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) at
org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source) at
org.apache.derby.impl.drda.Database.makeConnection(Unknown Source) at
org.apache.derby.impl.drda.DRDAConnThread.getConnFromDatabaseName(Unknown
Source) at
org.apache.derby.impl.drda.DRDAConnThread.verifyUserIdPassword(Unknown
Source) at
org.apache.derby.impl.drda.DRDAConnThread.parseSECCHK(Unknown Source)
at
org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown
Source) at
org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown
Source) at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown
Source) ============= end nested exception, level (1) ===========
Cleanup action completed 2012-01-13 18:31:26.752 GMT
Thread[DRDAConnThread_143,5,main] (DATABASE = sthldb), (DRDAID =
{11002361}), Database 'sthldb' not found. 2012-01-15 09:55:18.132 GMT
Thread[DRDAConnThread_28,5,main] 2012-01-15 09:55:18.132 GMT
Thread[DRDAConnThread_28,5,main] (XID = 9290664), (SESSIONID = 3485),
(DATABASE = hrspdb), (DRDAID =
KAC94205.E1B5-4398608134438264202{11120012}), Cleanup action starting
2012-01-15 09:55:18.132 GMT Thread[DRDAConnThread_28,5,main] (XID =
9290664), (SESSIONID = 3485), (DATABASE = hrspdb), (DRDAID =
KAC94205.E1B5-4398608134438264202{11120012}), Failed Statement is:
insert into TAB_33756_TAGSINURL(bid,tagValues) values(?,?) with 2
parameters begin parameter #1: 269805190 :end parameter begin
parameter #2: 269805190],[dianegilliard2...@yahoo.com],[ :end
parameter ERROR XSDG1: Page Page(2569,Container(0, 89761)) could not
be written to disk, please check if disk is full. at
org.apache.derby.iapi.error.StandardException.newException(Unknown
Source) at
org.apache.derby.impl.store.raw.data.CachedPage.writePage(Unknown
Source) at
org.apache.derby.impl.store.raw.data.CachedPage.createIdentity(Unknown
Source) at
org.apache.derby.impl.services.cache.ConcurrentCache.create(Unknown
Source) at
org.apache.derby.impl.store.raw.data.FileContainer.initPage(Unknown
Source) at
org.apache.derby.impl.store.raw.data.FileContainer.newPage(Unknown
Source) at
org.apache.derby.impl.store.raw.data.BaseContainer.addPage(Unknown
Source) at
org.apache.derby.impl.store.raw.data.BaseContainerHandle.addPage(Unknown
Source) at
org.apache.derby.impl.store.access.btree.LeafControlRow.allocate(Unknown
Source) at
org.apache.derby.impl.store.access.btree.LeafControlRow.splitFor(Unknown
Source) at
org.apache.derby.impl.store.access.btree.BranchControlRow.splitFor(Unknown
Source) at
org.apache.derby.impl.store.access.btree.BranchControlRow.splitFor(Unknown
Source) at
org.apache.derby.impl.store.access.btree.BTreeController.start_xact_and_dosplit(Unknown
Source) at
org.apache.derby.impl.store.access.btree.BTreeController.doIns(Unknown
Source) at
org.apache.derby.impl.store.access.btree.BTreeController.insert(Unknown Source)
at
org.apache.derby.impl.store.access.btree.index.B2IController.insert(Unknown
Source) at
org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(Unknown
Source) at
org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown
Source) at
org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown
Source) at
org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown
Source) at
org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown
Source) at
org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source) at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source) at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source) at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown
Source) at org.apache.derby.impl.drda.DRDAStatement.execute(Unknown
Source) at
org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTTobjects(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTT(Unknown
Source) at
org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown
Source) at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown
Source) Caused by: java.io.IOException: No space left on device at
sun.nio.ch.FileDispatcher.pwrite0(Native Method) at
sun.nio.ch.FileDispatcher.pwrite(FileDispatcher.java:45) at
sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:100) at
sun.nio.ch.IOUtil.write(IOUtil.java:75) at
sun.nio.ch.FileChannelImpl.write(FileChannelImpl.java:651) at
org.apache.derby.impl.store.raw.data.RAFContainer4.writeFull(Unknown
Source) at
org.apache.derby.impl.store.raw.data.RAFContainer4.writePage0(Unknown
Source) at
org.apache.derby.impl.store.raw.data.RAFContainer4.writePage(Unknown
Source) ... 31 more ============= begin nested exception, level (1)
=========== java.io.IOException: No space left on device at
sun.nio.ch.FileDispatcher.pwrite0(Native Method) at
sun.nio.ch.FileDispatcher.pwrite(FileDispatcher.java:45) at
sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:100) at
sun.nio.ch.IOUtil.write(IOUtil.java:75) at
sun.nio.ch.FileChannelImpl.write(FileChannelImpl.java:651) at
org.apache.derby.impl.store.raw.data.RAFContainer4.writeFull(Unknown
Source) at
org.apache.derby.impl.store.raw.data.RAFContainer4.writePage0(Unknown
Source) at
org.apache.derby.impl.store.raw.data.RAFContainer4.writePage(Unknown
Source) at
org.apache.derby.impl.store.raw.data.CachedPage.writePage(Unknown
Source) at
org.apache.derby.impl.store.raw.data.CachedPage.createIdentity(Unknown
Source) at
org.apache.derby.impl.services.cache.ConcurrentCache.create(Unknown
Source) at
org.apache.derby.impl.store.raw.data.FileContainer.initPage(Unknown
Source) at
org.apache.derby.impl.store.raw.data.FileContainer.newPage(Unknown
Source) at
org.apache.derby.impl.store.raw.data.BaseContainer.addPage(Unknown
Source) at
org.apache.derby.impl.store.raw.data.BaseContainerHandle.addPage(Unknown
Source) at
org.apache.derby.impl.store.access.btree.LeafControlRow.allocate(Unknown
Source) at
org.apache.derby.impl.store.access.btree.LeafControlRow.splitFor(Unknown
Source) at
org.apache.derby.impl.store.access.btree.BranchControlRow.splitFor(Unknown
Source) at
org.apache.derby.impl.store.access.btree.BranchControlRow.splitFor(Unknown
Source) at
org.apache.derby.impl.store.access.btree.BTreeController.start_xact_and_dosplit(Unknown
Source) at
org.apache.derby.impl.store.access.btree.BTreeController.doIns(Unknown
Source) at
org.apache.derby.impl.store.access.btree.BTreeController.insert(Unknown Source)
at
org.apache.derby.impl.store.access.btree.index.B2IController.insert(Unknown
Source) at
org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(Unknown
Source) at
org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown
Source) at
org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown
Source) at
org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown
Source) at
org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown
Source) at
org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source) at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source) at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source) at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown
Source) at org.apache.derby.impl.drda.DRDAStatement.execute(Unknown
Source) at
org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTTobjects(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTT(Unknown
Source) at
org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown
Source) at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown
Source) ============= end nested exception, level (1) ===========
2012-01-15 09:55:18.195 GMT: Shutting down instance
ed151285-012b-76a2-85ed-0000064a7052
----------------------------------------------------------------
Cleanup action completed 2012-01-15 09:55:32.156 GMT: Shutting down
instance f064522b-012b-76a2-85ed-0000064a7052
----------------------------------------------------------------
Cleanup action completed
----------------------------------------------------------------
2012-01-15 09:56:44.347 GMT: Booting Derby version The Apache Software
Foundation - Apache Derby - 10.4.2.0 - (689064): instance
14182dde-012b-76a2-85ed-0000064a7052 on database directory
/home/derby/data/hdcudb in READ ONLY mode Database Class Loader
started - derby.database.classpath=''
----------------------------------------------------------------
2012-01-15 10:15:04.251 GMT: Booting Derby version The Apache Software
Foundation - Apache Derby - 10.4.2.0 - (689064): instance
b5982e23-012b-76a2-85ed-0000064a7052 on database directory
/home/derby/data/hrspdb Database Class Loader started -
derby.database.classpath=''
----------------------------------------------------------------
2012-01-17 06:29:18.115 GMT: Booting Derby version The Apache Software
Foundation - Apache Derby - 10.4.2.0 - (689064): instance
cba927e4-012b-76a2-85ed-0000064a7052 on database directory
/home/derby/data/liondb Database Class Loader started -
derby.database.classpath=''
----------------------------------------------------------------
2012-01-17 07:56:05.055 GMT: Booting Derby version The Apache Software
Foundation - Apache Derby - 10.4.2.0 - (689064): instance
01042975-012b-76a2-85ed-0000064a7052 on database directory
/home/derby/data/lncrdb Database Class Loader started -
derby.database.classpath='' 2012-01-17 09:44:51.251 GMT
Thread[DRDAConnThread_7,5,main] (XID = 9389521), (SESSIONID = 666),
(DATABASE = hrspdb), (DRDAID =
KAC94205.BB58-722826413400468379{11183755}), Cleanup action starting
2012-01-17 09:44:51.251 GMT Thread[DRDAConnThread_7,5,main] (XID =
9389521), (SESSIONID = 666), (DATABASE = hrspdb), (DRDAID =
KAC94205.BB58-722826413400468379{11183755}), Failed Statement is:
insert into TAB_34138_TAGSINURL(bid,tagValues) values(?,?) with 2
parameters begin parameter #1: 275819973 :end parameter begin
parameter #2: 275819973],[d93...@yahoo.com],[ :end parameter ERROR
XSDG1: Page Page(657,Container(0, 90913)) could not be written to
disk, please check if disk is full. at
org.apache.derby.iapi.error.StandardException.newException(Unknown
Source) at
org.apache.derby.impl.store.raw.data.CachedPage.writePage(Unknown
Source) at
org.apache.derby.impl.store.raw.data.CachedPage.createIdentity(Unknown
Source) at
org.apache.derby.impl.services.cache.ConcurrentCache.create(Unknown
Source) at
org.apache.derby.impl.store.raw.data.FileContainer.initPage(Unknown
Source) at
org.apache.derby.impl.store.raw.data.FileContainer.newPage(Unknown
Source) at
org.apache.derby.impl.store.raw.data.BaseContainer.addPage(Unknown
Source) at
org.apache.derby.impl.store.raw.data.BaseContainerHandle.addPage(Unknown
Source) at
org.apache.derby.impl.store.access.btree.LeafControlRow.allocate(Unknown
Source) at
org.apache.derby.impl.store.access.btree.LeafControlRow.splitFor(Unknown
Source) at
org.apache.derby.impl.store.access.btree.BranchControlRow.splitFor(Unknown
Source) at
org.apache.derby.impl.store.access.btree.BranchControlRow.splitFor(Unknown
Source) at
org.apache.derby.impl.store.access.btree.BTreeController.start_xact_and_dosplit(Unknown
Source) at
org.apache.derby.impl.store.access.btree.BTreeController.doIns(Unknown
Source) at
org.apache.derby.impl.store.access.btree.BTreeController.insert(Unknown Source)
at
org.apache.derby.impl.store.access.btree.index.B2IController.insert(Unknown
Source) at
org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(Unknown
Source) at
org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown
Source) at
org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown
Source) at
org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown
Source) at
org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown
Source) at
org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source) at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source) at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source) at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown
Source) at org.apache.derby.impl.drda.DRDAStatement.execute(Unknown
Source) at
org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTTobjects(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTT(Unknown
Source) at
org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown
Source) at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown
Source) Caused by: java.io.IOException: No space left on device at
sun.nio.ch.FileDispatcher.pwrite0(Native Method) at
sun.nio.ch.FileDispatcher.pwrite(FileDispatcher.java:45) 2012-01-17
09:44:51.251 GMT Thread[DRDAConnThread_7,5,main] (XID = 9389521),
(SESSIONID = 666), (DATABASE = hrspdb), (DRDAID =
KAC94205.BB58-722826413400468379{11183755}), Cleanup action starting
2012-01-17 09:44:51.251 GMT Thread[DRDAConnThread_7,5,main] (XID =
9389521), (SESSIONID = 666), (DATABASE = hrspdb), (DRDAID =
KAC94205.BB58-722826413400468379{11183755}), Failed Statement is:
insert into TAB_34138_TAGSINURL(bid,tagValues) values(?,?) with 2
parameters begin parameter #1: 275819973 :end parameter begin
parameter #2: 275819973],[d93...@yahoo.com],[ :end parameter ERROR
XSDG1: Page Page(657,Container(0, 90913)) could not be written to
disk, please check if disk is full. at
org.apache.derby.iapi.error.StandardException.newException(Unknown
Source) at
org.apache.derby.impl.store.raw.data.CachedPage.writePage(Unknown
Source) at
org.apache.derby.impl.store.raw.data.CachedPage.createIdentity(Unknown
Source) at
org.apache.derby.impl.services.cache.ConcurrentCache.create(Unknown
Source) at
org.apache.derby.impl.store.raw.data.FileContainer.initPage(Unknown
Source) at
org.apache.derby.impl.store.raw.data.FileContainer.newPage(Unknown
Source) at
org.apache.derby.impl.store.raw.data.BaseContainer.addPage(Unknown
Source) at
org.apache.derby.impl.store.raw.data.BaseContainerHandle.addPage(Unknown
Source) at
org.apache.derby.impl.store.access.btree.LeafControlRow.allocate(Unknown
Source) at
org.apache.derby.impl.store.access.btree.LeafControlRow.splitFor(Unknown
Source) at
org.apache.derby.impl.store.access.btree.BranchControlRow.splitFor(Unknown
Source) at
org.apache.derby.impl.store.access.btree.BranchControlRow.splitFor(Unknown
Source) at
org.apache.derby.impl.store.access.btree.BTreeController.start_xact_and_dosplit(Unknown
Source) at
org.apache.derby.impl.store.access.btree.BTreeController.doIns(Unknown
Source) at
org.apache.derby.impl.store.access.btree.BTreeController.insert(Unknown Source)
at
org.apache.derby.impl.store.access.btree.index.B2IController.insert(Unknown
Source) at
org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(Unknown
Source) at
org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown
Source) at
org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown
Source) at
org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown
Source) at
org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown
Source) at
org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source) at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source) at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source) at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown
Source) at org.apache.derby.impl.drda.DRDAStatement.execute(Unknown
Source) at
org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTTobjects(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTT(Unknown
Source) at
org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown
Source) at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown
Source) Caused by: java.io.IOException: No space left on device at
sun.nio.ch.FileDispatcher.pwrite0(Native Method) at
sun.nio.ch.FileDispatcher.pwrite(FileDispatcher.java:45) at
sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:100) at
sun.nio.ch.IOUtil.write(IOUtil.java:75) at
sun.nio.ch.FileChannelImpl.write(FileChannelImpl.java:651) at
org.apache.derby.impl.store.raw.data.RAFContainer4.writeFull(Unknown
Source) at
org.apache.derby.impl.store.raw.data.RAFContainer4.writePage0(Unknown
Source) at
org.apache.derby.impl.store.raw.data.RAFContainer4.writePage(Unknown
Source) ... 31 more ============= begin nested exception, level (1)
=========== java.io.IOException: No space left on device at
sun.nio.ch.FileDispatcher.pwrite0(Native Method) at
sun.nio.ch.FileDispatcher.pwrite(FileDispatcher.java:45) at
sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:100) at
sun.nio.ch.IOUtil.write(IOUtil.java:75) at
sun.nio.ch.FileChannelImpl.write(FileChannelImpl.java:651) at
org.apache.derby.impl.store.raw.data.RAFContainer4.writeFull(Unknown
Source) at
org.apache.derby.impl.store.raw.data.RAFContainer4.writePage0(Unknown
Source) at
org.apache.derby.impl.store.raw.data.RAFContainer4.writePage(Unknown
Source) at
org.apache.derby.impl.store.raw.data.CachedPage.writePage(Unknown
Source) at
org.apache.derby.impl.store.raw.data.CachedPage.createIdentity(Unknown
Source) at
org.apache.derby.impl.services.cache.ConcurrentCache.create(Unknown
Source) at
org.apache.derby.impl.store.raw.data.FileContainer.initPage(Unknown
Source) at
org.apache.derby.impl.store.raw.data.FileContainer.newPage(Unknown
Source) at
org.apache.derby.impl.store.raw.data.BaseContainer.addPage(Unknown
Source) at
org.apache.derby.impl.store.raw.data.BaseContainerHandle.addPage(Unknown
Source) at
org.apache.derby.impl.store.access.btree.LeafControlRow.allocate(Unknown
Source) at
org.apache.derby.impl.store.access.btree.LeafControlRow.splitFor(Unknown
Source) at
org.apache.derby.impl.store.access.btree.BranchControlRow.splitFor(Unknown
Source) at
org.apache.derby.impl.store.access.btree.BranchControlRow.splitFor(Unknown
Source) at
org.apache.derby.impl.store.access.btree.BTreeController.start_xact_and_dosplit(Unknown
Source) at
org.apache.derby.impl.store.access.btree.BTreeController.doIns(Unknown
Source) at
org.apache.derby.impl.store.access.btree.BTreeController.insert(Unknown Source)
at
org.apache.derby.impl.store.access.btree.index.B2IController.insert(Unknown
Source) at
org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(Unknown
Source) at
org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown
Source) at
org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown
Source) at
org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown
Source) at
org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown
Source) at
org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source) at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source) at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source) at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown
Source) at org.apache.derby.impl.drda.DRDAStatement.execute(Unknown
Source) at
org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTTobjects(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTT(Unknown
Source) at
org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown
Source) at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown
Source) ============= end nested exception, level (1) ===========
2012-01-17 09:44:51.323 GMT: Shutting down instance
b5982e23-012b-76a2-85ed-0000064a7052
----------------------------------------------------------------
Cleanup action completed
----------------------------------------------------------------
2012-01-17 09:54:05.862 GMT: Booting Derby version The Apache Software
Foundation - Apache Derby - 10.4.2.0 - (689064): instance
19cb6c66-012b-76a2-85ed-0000064a7052 on database directory
/home/derby/data/hrspdb in READ ONLY mode / Database Class Loader
started - derby.database.classpath=''
----------------------------------------------------------------
2012-01-30 05:58:27.422 GMT: Booting Derby version The Apache Software
Foundation - Apache Derby - 10.4.2.0 - (689064): instance
391a3f1f-012b-76a2-85ed-0000064a7052 on database directory
/home/derby/data/pidrdb Database Class Loader started -
derby.database.classpath='' 2012-01-31 10:11:38.784 GMT
Thread[DRDAConnThread_265,5,main] Cleanup action starting
java.sql.SQLNonTransientConnectionException: Connection authentication
failure occurred. Reason: Invalid authentication.. 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.newEmbedSQLException(Unknown
Source) at
org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown
Source) at
org.apache.derby.impl.jdbc.EmbedConnection.checkUserCredentials(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection. (Unknown Source) at
org.apache.derby.impl.jdbc.EmbedConnection30. (Unknown Source) at
org.apache.derby.impl.jdbc.EmbedConnection40. (Unknown Source) at
org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) at
org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source) at
org.apache.derby.impl.drda.Database.makeConnection(Unknown Source) at
org.apache.derby.impl.drda.DRDAConnThread.getConnFromDatabaseName(Unknown
Source) at
org.apache.derby.impl.drda.DRDAConnThread.verifyUserIdPassword(Unknown
Source) at
org.apache.derby.impl.drda.DRDAConnThread.parseSECCHK(Unknown Source)
at
org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown
Source) at
org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown
Source) at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown
Source) Caused by: java.sql.SQLException: Connection authentication
failure occurred. Reason: Invalid authentication.. at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source) at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source) ... 19 more ============= begin nested exception, level (1)
=========== java.sql.SQLException: Connection authentication failure
occurred. Reason: Invalid authentication.. at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source) at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(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.newEmbedSQLException(Unknown
Source) at
org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown
Source) at
org.apache.derby.impl.jdbc.EmbedConnection.checkUserCredentials(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection. (Unknown Source) at
org.apache.derby.impl.jdbc.EmbedConnection30. (Unknown Source) at
org.apache.derby.impl.jdbc.EmbedConnection40. (Unknown Source) at
org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) at
org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source) at
org.apache.derby.impl.drda.Database.makeConnection(Unknown Source) at
org.apache.derby.impl.drda.DRDAConnThread.getConnFromDatabaseName(Unknown
Source) at
org.apache.derby.impl.drda.DRDAConnThread.verifyUserIdPassword(Unknown
Source) at
org.apache.derby.impl.drda.DRDAConnThread.parseSECCHK(Unknown Source)
at
org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown
Source) at
org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown
Source) at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown
Source) ============= end nested exception, level (1) ===========
Cleanup action completed 2012-01-31 10:11:38.796 GMT
Thread[DRDAConnThread_265,5,main] (DATABASE = hdcudb), (DRDAID =
{11609856}), Connection authentication failure occurred. Reason:
Invalid authentication.. 2012-01-31 11:55:30.729 GMT
Thread[DRDAConnThread_241,5,main] (DATABASE = 18fldb), (DRDAID =
D841DB05.DE26-939562144249245829{11610209}), Execution failed because
of a Distributed Protocol Error: DRDA_Proto_PRCCNVRM; CODPNT arg =
2113; Error Code Value = 12 Execution failed because of a Distributed
Protocol Error: DRDA_Proto_PRCCNVRM; CODPNT arg = 2113; Error Code
Value = 12 org.apache.derby.impl.drda.DRDAProtocolException: Execution
failed because of a Distributed Protocol Error: DRDA_Proto_PRCCNVRM;
CODPNT arg = 2113; Error Code Value = 12 at
org.apache.derby.impl.drda.DRDAConnThread.rdbnamMismatch(Unknown
Source) at
org.apache.derby.impl.drda.DRDAConnThread.parsePKGNAMCSN(Unknown
Source) at
org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLIMM(Unknown
Source) at
org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown
Source) at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown
Source) 2012-01-31 11:55:30.748 GMT Thread[DRDAConnThread_241,5,main]
(DATABASE = 18fldb), (DRDAID =
D841DB05.DE26-939562144249245829{11610209}), Execution failed because
of a Distributed Protocol Error: DRDA_Proto_PRCCNVRM; CODPNT arg =
2113; Error Code Value = 12 Execution failed because of a Distributed
Protocol Error: DRDA_Proto_PRCCNVRM; CODPNT arg = 2113; Error Code
Value = 12 org.apache.derby.impl.drda.DRDAProtocolException: Execution
failed because of a Distributed Protocol Error: DRDA_Proto_PRCCNVRM;
CODPNT arg = 2113; Error Code Value = 12 at
org.apache.derby.impl.drda.DRDAConnThread.rdbnamMismatch(Unknown
Source) at
org.apache.derby.impl.drda.DRDAConnThread.parsePKGNAMCSN(Unknown
Source) at
org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLIMM(Unknown
Source) at
org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown
Source) at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
View this message in context: Derby database started in READ ONLY mode
<http://old.nabble.com/Derby-database-started-in-READ-ONLY-mode-tp33271488p33271488.html>
Sent from the Apache Derby Users mailing list archive
<http://old.nabble.com/Apache-Derby-Users-f93.html> at Nabble.com.