db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rajesh Kartha (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-1667) Future Backups fails with "ERROR XSRS4: Error renaming file" after a consistency check is performed on the Backedup database and is not shutdown
Date Thu, 10 Aug 2006 21:59:15 GMT
     [ http://issues.apache.org/jira/browse/DERBY-1667?page=all ]

Rajesh Kartha updated DERBY-1667:
---------------------------------

          Summary: Future Backups fails with "ERROR XSRS4: Error renaming file" after a consistency
check is performed on the Backedup database and  is not shutdown  (was: Future Backups fails
with "ERROR XSRS4: Error renaming file" after a consistency check is performed on the Backedup
database)
      Component/s: Documentation
                       (was: Store)
          Urgency: Low  (was: Urgent)
    Fix Version/s:     (was: 10.2.0.0)
         Priority: Minor  (was: Major)

I agree,  added the line connect 'jdbc:derby:backupdir/testdb;shutdown=true'; before the second
set of backups and it was successful.

After performing the consistency check a shutdown got things working (a  bit strange,  even
though a disconnect was issued previously and there were no other connections to the backedup
database).  

Seems like a word of caution about this deserves a mention in the documentation. Changing
the component and priority.

> Future Backups fails with "ERROR XSRS4: Error renaming file" after a consistency check
is performed on the Backedup database and  is not shutdown
> -------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1667
>                 URL: http://issues.apache.org/jira/browse/DERBY-1667
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.2.0.0, 10.1.3.0, 10.1.3.1
>            Reporter: Rajesh Kartha
>            Priority: Minor
>         Attachments: onlinebackup_embed.sql
>
>
> After performing a consistency check on the backedup database, all future attempts to
backup the original database fails.  this happens with both SYSCS_UTIL.SYSCS_ONLINE_BACKUP_DATABASE
(online and offline) and SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE (online
and offline). 
> Following is the reproduction of this scenario using online backup:
> Derby version: latest synced up trunk -  10.2.0.5 alpha - (430519).  The offline backup
version in 10.1.3  also fails with the same error.
> ij version 10.2
> ij> connect 'jdbc:derby:testdb;create=true';
> ij> --
> -- Attempt for an online backup - SUCCESS
> --
> CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE_NOWAIT('backupdir',1);
> 0 rows inserted/updated/deleted
> ij> create table t(id int, col1 char(2));
> 0 rows inserted/updated/deleted
> ij> insert into t values(1,'ca');
> 1 row inserted/updated/deleted
> ij> insert into t values(2,'wa');
> 1 row inserted/updated/deleted
> ij> --
> -- Attempt for an online backup - SUCCESS
> --
> CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE_NOWAIT('backupdir',1);
> 0 rows inserted/updated/deleted
> ij> connect 'jdbc:derby:backupdir/testdb';
> ij(CONNECTION1)> --
> -- Check consistency on the backedup dir
> --
> SELECT schemaname, tablename,       SYSCS_UTIL.SYSCS_CHECK_TABLE(schemaname, tablename)
    FROM sys.sysschemas s, sys.systables t  WHERE s.schemaid = t.schemaid;
> SCHEMANAME                                                                          
                                           |TABLENAME                                    
                                                                                  |3     
    
> -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> SYS                                                                                 
                                           |SYSALIASES                                   
                                                                                  |1     
    
> SYS                                                                                 
                                           |SYSCHECKS                                    
                                                                                  |1     
    
> SYS                                                                                 
                                           |SYSCOLPERMS                                  
                                                                                  |1     
    
> SYS                                                                                 
                                           |SYSCOLUMNS                                   
                                                                                  |1     
    
> SYS                                                                                 
                                           |SYSCONGLOMERATES                             
                                                                                  |1     
    
> SYS                                                                                 
                                           |SYSCONSTRAINTS                               
                                                                                  |1     
    
> SYS                                                                                 
                                           |SYSDEPENDS                                   
                                                                                  |1     
    
> SYSIBM                                                                              
                                           |SYSDUMMY1                                    
                                                                                  |1     
    
> SYS                                                                                 
                                           |SYSFILES                                     
                                                                                  |1     
    
> SYS                                                                                 
                                           |SYSFOREIGNKEYS                               
                                                                                  |1     
    
> SYS                                                                                 
                                           |SYSKEYS                                      
                                                                                  |1     
    
> SYS                                                                                 
                                           |SYSREQUIREDPERM                              
                                                                                  |1     
    
> SYS                                                                                 
                                           |SYSROUTINEPERMS                              
                                                                                  |1     
    
> SYS                                                                                 
                                           |SYSSCHEMAS                                   
                                                                                  |1     
    
> SYS                                                                                 
                                           |SYSSTATEMENTS                                
                                                                                  |1     
    
> SYS                                                                                 
                                           |SYSSTATISTICS                                
                                                                                  |1     
    
> SYS                                                                                 
                                           |SYSTABLEPERMS                                
                                                                                  |1     
    
> SYS                                                                                 
                                           |SYSTABLES                                    
                                                                                  |1     
    
> SYS                                                                                 
                                           |SYSTRIGGERS                                  
                                                                                  |1     
    
> SYS                                                                                 
                                           |SYSVIEWS                                     
                                                                                  |1     
    
> APP                                                                                 
                                           |T                                            
                                                                                  |1     
    
> 21 rows selected
> ij(CONNECTION1)> disconnect;
> ij> show connections;
> CONNECTION0 - 	jdbc:derby:testdb
> No current connection
> ij> --
> -- Reconnect to the same original db
> --
> set connection CONNECTION0;
> ij> show connections;
> CONNECTION0* - 	jdbc:derby:testdb
> * = current connection
> ij> --
> -- Third attempt for an online backup - FAILS
> --
> CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE_NOWAIT('backupdir',1);
> ERROR XSRS4: Error renaming file (during backup) from backupdir\testdb to backupdir\testdb.OLD.
> ij> disconnect;
> ij> --
> -- No connections present
> --
> show connections;
> No connections available.
> ij> connect 'jdbc:derby:testdb;create=true';
> WARNING 01J01: Database 'testdb' not created, connection made to existing database instead.
> ij> --
> -- Another attempt for an online backup with a fresh connection - FAILS TOO
> --
> CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE_NOWAIT('backupdir',1);
> ERROR XSRS4: Error renaming file (during backup) from backupdir\testdb to backupdir\testdb.OLD.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message