Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 5970 invoked from network); 29 Jan 2011 16:08:15 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 29 Jan 2011 16:08:15 -0000 Received: (qmail 74705 invoked by uid 500); 29 Jan 2011 16:08:14 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 74458 invoked by uid 500); 29 Jan 2011 16:08:12 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 74447 invoked by uid 99); 29 Jan 2011 16:08:10 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 29 Jan 2011 16:08:10 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of mortenbreum@gmail.com designates 209.85.161.44 as permitted sender) Received: from [209.85.161.44] (HELO mail-fx0-f44.google.com) (209.85.161.44) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 29 Jan 2011 16:08:02 +0000 Received: by fxm9 with SMTP id 9so4702855fxm.31 for ; Sat, 29 Jan 2011 08:07:41 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type; bh=k6TdLvxwKB4dsCOi4QUKNjhnbeY0QzNg+ebm6lbEh/c=; b=ZZ15KE1Ujw0FdHAvUnNeDDpOU45/RYFtCUKmppYvusOiVI0UrwA1kRugn6UJ8gtbfx ARCPyyTx/UOfS55BBimCLfgoLhneaF7VtwKcDT5M5zajol3vhMShxUwqLinBnEyScGzS KxpOaS4O/Bu+MJ8qk0G/B1VAdzJXoYcY1atPA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=ZNAkaNycLT0GiWJseqrrjiHs0h0aFbbm1CKojZfICv0stt1gW18JbeFXosLW2OdTVQ zpHfwLuB/vasTXxv28Kp59cWSFm7JPFEFbkKhZ2c7encV5wgAz5XBGJwf4lwYhu+Hrxy 25LQpq+0MT4NqiebDnrKFyRh09VIzaSNJCoU8= MIME-Version: 1.0 Received: by 10.223.100.8 with SMTP id w8mr4136922fan.55.1296317261656; Sat, 29 Jan 2011 08:07:41 -0800 (PST) Received: by 10.223.111.211 with HTTP; Sat, 29 Jan 2011 08:07:41 -0800 (PST) In-Reply-To: References: Date: Sat, 29 Jan 2011 17:07:41 +0100 Message-ID: Subject: Re: ERROR XSLA0: Cannot flush the log file to disk From: Morten Mikkelsen To: Derby Discussion Content-Type: multipart/alternative; boundary=20cf3054a62de5b157049afe6121 X-Virus-Checked: Checked by ClamAV on apache.org --20cf3054a62de5b157049afe6121 Content-Type: text/plain; charset=ISO-8859-1 Hi. I am absolutely no expert with derby, but I'm going out on a limb here: Could it be the "No space left on device" message? Is the device, /mnt/rw-ti/rw/DerbyDatabase/TICYCLESMFR/log/ resides on full? /Morten On Sat, Jan 29, 2011 at 4:51 PM, Sakthivel.P wrote: > Hi, > > I'm new to derby, when I start writing data into db i'm getting the > follwoing exception from derby.log > can any one help me to fix it. > > thanks > > ------------ BEGIN SHUTDOWN ERROR STACK ------------- > > ERROR XSLA0: Cannot flush the log file to disk > /mnt/rw-ti/rw/DerbyDatabase/TICYCLESMFR/log/log1460.dat. > at org.apache.derby.iapi.error.StandardException.newException(Unknown > Source) > at org.apache.derby.impl.store.raw.log.LogToFile.flush(Unknown Source) > at org.apache.derby.impl.store.raw.log.LogToFile.flush(Unknown Source) > at org.apache.derby.impl.store.raw.log.FileLogger.flush(Unknown Source) > at org.apache.derby.impl.store.raw.xact.Xact.prepareCommit(Unknown > Source) > at org.apache.derby.impl.store.raw.xact.Xact.commit(Unknown Source) > at org.apache.derby.impl.store.raw.xact.Xact.commit(Unknown Source) > at org.apache.derby.impl.store.access.RAMTransaction.commit(Unknown > Source) > at > org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.doCommit(Unknown > Source) > at > org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.userCommit(Unknown > Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.commit(Unknown > Source) > at org.apache.derby.impl.jdbc.EmbedConnection.commit(Unknown Source) > at org.apache.derby.impl.drda.Database.commit(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 java.io.RandomAccessFile.writeBytes(Native Method) > at java.io.RandomAccessFile.write(Unknown Source) > at org.apache.derby.impl.store.raw.log.LogAccessFile.writeToLog(Unknown > Source) > at > org.apache.derby.impl.store.raw.log.LogAccessFile.flushDirtyBuffers(Unknown > Source) > ... 14 more > ============= begin nested exception, level (1) =========== > java.io.IOException: No space left on device > at java.io.RandomAccessFile.writeBytes(Native Method) > at java.io.RandomAccessFile.write(Unknown Source) > at org.apache.derby.impl.store.raw.log.LogAccessFile.writeToLog(Unknown > Source) > at > org.apache.derby.impl.store.raw.log.LogAccessFile.flushDirtyBuffers(Unknown > Source) > at org.apache.derby.impl.store.raw.log.LogToFile.flush(Unknown Source) > at org.apache.derby.impl.store.raw.log.LogToFile.flush(Unknown Source) > at org.apache.derby.impl.store.raw.log.FileLogger.flush(Unknown Source) > at org.apache.derby.impl.store.raw.xact.Xact.prepareCommit(Unknown > Source) > at org.apache.derby.impl.store.raw.xact.Xact.commit(Unknown Source) > at org.apache.derby.impl.store.raw.xact.Xact.commit(Unknown Source) > at org.apache.derby.impl.store.access.RAMTransaction.commit(Unknown > Source) > at > org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.doCommit(Unknown > Source) > at > org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.userCommit(Unknown > Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.commit(Unknown > Source) > at org.apache.derby.impl.jdbc.EmbedConnection.commit(Unknown Source) > at org.apache.derby.impl.drda.Database.commit(Unknown Source) > > > > -- /Morten --20cf3054a62de5b157049afe6121 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi.
I am absolutely no expert with derby, but I'm going out on a lim= b here:
Could it be the "No space left on device" message?
Is the devic= e, /mnt/rw-ti/rw/DerbyDatabase/TICYCLESMFR/log/ resides on full?

/Morten

On Sat, Jan 29, 2011 at 4:51 = PM, Sakthivel.P <p.stivel@gmail.com> wrote:
Hi,

= I'm new to derby, when I start writing data into db i'm getting the= follwoing exception from derby.log
can any one help me to fix it.
thanks

------------=A0 BEGIN SHUTDOWN ERROR STACK -------------
<= br>ERROR XSLA0: Cannot flush the log file to disk /mnt/rw-ti/rw/DerbyDataba= se/TICYCLESMFR/log/log1460.dat.
=A0=A0=A0 at org.apache.derby.iapi.error= .StandardException.newException(Unknown Source)
=A0=A0=A0 at org.apache.derby.impl.store.raw.log.LogToFile.flush(Unknown So= urce)
=A0=A0=A0 at org.apache.derby.impl.store.raw.log.LogToFile.flush(U= nknown Source)
=A0=A0=A0 at org.apache.derby.impl.store.raw.log.FileLogg= er.flush(Unknown Source)
=A0=A0=A0 at org.apache.derby.impl.store.raw.xact.Xact.prepareCommit(Unknow= n Source)
=A0=A0=A0 at org.apache.derby.impl.store.raw.xact.Xact.commit(= Unknown Source)
=A0=A0=A0 at org.apache.derby.impl.store.raw.xact.Xact.c= ommit(Unknown Source)
=A0=A0=A0 at org.apache.derby.impl.store.access.RAMTransaction.commit(Unkno= wn Source)
=A0=A0=A0 at org.apache.derby.impl.sql.conn.GenericLanguageCo= nnectionContext.doCommit(Unknown Source)
=A0=A0=A0 at org.apache.derby.i= mpl.sql.conn.GenericLanguageConnectionContext.userCommit(Unknown Source) =A0=A0=A0 at org.apache.derby.impl.jdbc.TransactionResourceImpl.commit(Unkn= own Source)
=A0=A0=A0 at org.apache.derby.impl.jdbc.EmbedConnection.comm= it(Unknown Source)
=A0=A0=A0 at org.apache.derby.impl.drda.Database.comm= it(Unknown Source)
=A0=A0=A0 at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unkn= own Source)
=A0=A0=A0 at org.apache.derby.impl.drda.DRDAConnThread.run(U= nknown Source)
Caused by: java.io.IOException: No space left on device=A0=A0=A0 at java.io.RandomAccessFile.writeBytes(Native Method)
=A0=A0=A0 at java.io.RandomAccessFile.write(Unknown Source)
=A0=A0=A0 at= org.apache.derby.impl.store.raw.log.LogAccessFile.writeToLog(Unknown Sourc= e)
=A0=A0=A0 at org.apache.derby.impl.store.raw.log.LogAccessFile.flushD= irtyBuffers(Unknown Source)
=A0=A0=A0 ... 14 more
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D begin nest= ed exception, level (1) =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
java.io.IOExce= ption: No space left on device
=A0=A0=A0 at java.io.RandomAccessFile.wri= teBytes(Native Method)
=A0=A0=A0 at java.io.RandomAccessFile.write(Unkno= wn Source)
=A0=A0=A0 at org.apache.derby.impl.store.raw.log.LogAccessFile.writeToLog(U= nknown Source)
=A0=A0=A0 at org.apache.derby.impl.store.raw.log.LogAcces= sFile.flushDirtyBuffers(Unknown Source)
=A0=A0=A0 at org.apache.derby.im= pl.store.raw.log.LogToFile.flush(Unknown Source)
=A0=A0=A0 at org.apache.derby.impl.store.raw.log.LogToFile.flush(Unknown So= urce)
=A0=A0=A0 at org.apache.derby.impl.store.raw.log.FileLogger.flush(= Unknown Source)
=A0=A0=A0 at org.apache.derby.impl.store.raw.xact.Xact.p= repareCommit(Unknown Source)
=A0=A0=A0 at org.apache.derby.impl.store.raw.xact.Xact.commit(Unknown Sourc= e)
=A0=A0=A0 at org.apache.derby.impl.store.raw.xact.Xact.commit(Unknown= Source)
=A0=A0=A0 at org.apache.derby.impl.store.access.RAMTransaction.= commit(Unknown Source)
=A0=A0=A0 at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContex= t.doCommit(Unknown Source)
=A0=A0=A0 at org.apache.derby.impl.sql.conn.G= enericLanguageConnectionContext.userCommit(Unknown Source)
=A0=A0=A0 at = org.apache.derby.impl.jdbc.TransactionResourceImpl.commit(Unknown Source) =A0=A0=A0 at org.apache.derby.impl.jdbc.EmbedConnection.commit(Unknown Sour= ce)
=A0=A0=A0 at org.apache.derby.impl.drda.Database.commit(Unknown Sour= ce)



--
/Morten
--20cf3054a62de5b157049afe6121--