db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bergquist, Brett" <BBergqu...@canoga.com>
Subject RE: Got an error doing an online backup and don't know where to look
Date Mon, 28 Nov 2011 14:43:48 GMT
Thanks Rick, I will do so.  This is at a large customer site and maybe it ran out of disk space.
 I am combing through their logs trying to find out if this is the case.


-----Original Message-----
From: Rick Hillegas [mailto:rick.hillegas@oracle.com] 
Sent: Monday, November 28, 2011 9:18 AM
To: derby-dev@db.apache.org
Subject: Re: Got an error doing an online backup and don't know where to look

Hi Brett,

I've never used the ant <sql> task so I'm shooting in the dark here. It 
might help to specify -Dderby.language.logStatementText=true and 
-Dderby.stream.error.logSeverityLevel=0 on the ant command line in order 
to tell Derby to write more information to derby.log.

Hope this helps,

On 11/28/11 6:08 AM, Bergquist, Brett wrote:
> Got this error two nights in a row now while doing an online backup:
> [sql] Failed to execute: CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE('/containe
> r1/backup/database/2011-11-28_00-15')
> [sql] java.sql.SQLException: Cannot backup the database, got an I/O 
> Except
> ion while writing to the backup container file 
> /container1/backup/database/2011-
> 11-28_00-15/csemdb/seg0/cf3a0.dat.
> I run the online backup through an ANT SQL task. The 'derby.log' does 
> not show any errors, the server system log (Oracle M5000/Solaris 10) 
> shows no errors either. I am stumped where to look and any help will 
> be greatly appreciated.

View raw message