It appears this problem was a disk space issue so for now I am good with the 
error that was reported.

Thanks for the feedback.

Brett

-----Original Message-----
From: Bergquist, Brett [mailto:bbergqu...@canoga.com] 
Sent: Monday, November 28, 2011 9:44 AM
To: derby-dev@db.apache.org
Subject: RE: Got an error doing an online backup and don't know where to look

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.

Brett

-----Original Message-----
From: Rick Hillegas [mailto:rick.hille...@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,
-Rick

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.
>





Reply via email to