db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ram T <rtatava...@zetainteractive.com>
Subject Re: Derby database started in READ ONLY mode
Date Mon, 06 Feb 2012 14:12:44 GMT

Hi Rick,

I have verified the server memory there is lot of free space on the server.
Is there any relation as if there is no free space on the server then
database will start in READ ONLY mode?.

Please suggest me how can change this database to READ/WRITE mode.


Rick Hillegas-3 wrote:
> 
> 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.
> 
> 
> 

-- 
View this message in context: http://old.nabble.com/Derby-database-started-suddenly-in-READ-ONLY-mode-tp33271488p33271654.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message