db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@oracle.com>
Subject Re: Derby database started in READ ONLY mode
Date Mon, 06 Feb 2012 14:02:13 GMT
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],[dianegilliard2003@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],[d93328@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],[d93328@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.


Mime
View raw message