Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Received-SPF: neutral (asf.osuosl.org: local policy)
Message-ID: <436F4423.4060104@debrunners.com>
Date: Mon, 07 Nov 2005 04:10:11 -0800
From: Daniel John Debrunner <djd@debrunners.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
 rv:1.7.3) Gecko/20040910
MIME-Version: 1.0
To: derby-dev@db.apache.org
CC: roy_mylchreest@triangle-group.com
Subject: Re: [jira] Created: (DERBY-685) Unexpected SQL Error
References: <990669888.1131357440004.JavaMail.jira@ajax.apache.org>
In-Reply-To: <990669888.1131357440004.JavaMail.jira@ajax.apache.org>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

roy mylchreest (JIRA) wrote:

> Unexpected SQL Error
> --------------------
> 
>          Key: DERBY-685
>          URL: http://issues.apache.org/jira/browse/DERBY-685
>      Project: Derby
>         Type: Bug
>     Versions: 10.0.2.1    
>  Environment: Windows XP Embedded
>     Reporter: roy mylchreest
> 
> 
> We are running Derby on over 20 IBM Revelation shop tills and about once a day we get the message.
> 
> ERROR XSLA4: Cannot write to the log, most likely the log is full.  Please
> delete unnecessary files.  It is also possible that the file system is read
> only, or the disk has failed, or some other problems with the media
> 
> This results in the till having to be re-booted, much to the frustration of the cashier and the customer.
> 
> However on investigation everything seems fine, the log is not full and there is plenty of room on the disk.
> 
> Could anybody give me some advice on this please as it is becoming a major issue for our retail operations.

Is it possible to get the stack trace for this exception and the
exception it nests? This SQLException should have a nested (chained)
exception that represents the original IOException from the file system.

Something like

catch (SQLException sqle)
{
   do {
       System.out.println("ERROR " + sqle.getSQLState() + " -- " +
sqle.getMessage());
       sqle.printStackTrace(System.out);
       sqle = sqle.getNextException();
   } while (sqle != null)
}

Derby does retry some writes multiple times when it hits an IOException,
to try and ensure it it's not some transient error. The stack trace
would tell if it was one of these multiple write on failure situation.

Thanks,
Dan.