[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

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Won't Fix
• Affects Version/s: 10.1.3.1, 10.2.1.6
• Component/s: Documentation
• Labels: derby_triage10_5_2
• Urgency: Low
• Assignee: Unassigned
• Reporter: Rajesh Kartha
• Created: 10/Aug/06 20:54
• Updated: 09/Sep/14 18:35
• Resolved: 09/Sep/14 18:35

Description

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.