Question
· May 25, 2023

Journal offset xxxx is not found in mirror journal log file

Hi,

I have refreshed my TEST system database from my DR box.

TEST consists of 2 linux servers TEST_NODE1 & TEST_NODE2 which are mirrored as PRIMARY failover and BACKUP failover

This is what I've done:

1. Remove TEST_NODE2 as Backup member using do ^MIRROR

2. Remove TEST_NODE1 mirror configuration using SMP (System Management Portal) GUI

3. Stop IRIS on TEST_NODE1 & TEST_NODE2

4. Copy files IRIS.DAT  from DR to TEST_NODE1

5. Start IRIS on TEST_NODE1

6. Turn off mirror flags on DB files on TEST_NODE1 using do ^MIRROR ('Remove one or more mirrored databases')

7. Create mirror on TEST_NODE1 using SMP ('Create a mirror')

8. Stop IRIS on TEST_NODE1

9.  Copy files IRIS.DAT  from TEST_NODE1 to TEST_NODE2

10. Start IRIS on TEST_NODE1 & TEST_NODE2

11. On TEST_NODE2, into the mirror as failover using SMP ('Join mirror as failover')

12. On TEST_NODE2, activate databases using SMP

13. On TEST_NODE2, catchup databases using SMP

However at the catchup databases I get the error "Journal offset xxxx is not found in mirror journal log file"

Journal records should not be needed as TEST_NODE1 and TEST_NODE2 IRIS.DAT files are identical.

TEST_NODE1 IRIS.DAT files should be clean as IRIS was shutdown cleanly.

Does anyone know how this problem can be fixed?
Thanks for any help.

Product version: IRIS 2022.3
Discussion (4)2
Log in or sign up to continue

Thanks to everybody's suggestions.
I fixed it this way:

I removed TEST_NODE2 as a failover member
I removed TEST_NODE1 mirror configuration
I stopped IRIS on TEST_NODE2 & TEST_NODE1
I removed all the journals as DB files IRIS.DAT are identical
I started IRIS on  TEST_NODE1 then  TEST_NODE2 
I configured the mirror on TEST_NODE1
I configured TEST_NODE2 as a failover member
Now Mirror Monitor in SMP[System Management Portal] GUI is showing no errors