RE: Got an error doing an online backup and don't know where to look

2011-11-30 Thread Bergquist, Brett 
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.

Got an error doing an online backup and don't know where to look

2011-11-28 Thread Bergquist, Brett 
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.

Re: Got an error doing an online backup and don't know where to look

2011-11-28 Thread Rick Hillegas 

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.

RE: Got an error doing an online backup and don't know where to look

2011-11-28 Thread Bergquist, Brett 
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.