Hi guys,

Has anyone encountered this problem?

Windows server 2008 R2, 4D server v15.4

A customer has this mirror setup, where code in the mirror database integrates 
log files coming from the master database.

The master database writes the log file every 5 minutes to a shared folder on a 
file server.
The mirror database reads the log file as soon as it is complete and integrates 
it. The code only starts reading when the log file has been saved completely by 
the master database.

There are no data operations in the mirror database. It is, however, being 
accesses frequently through SQL (read only).

This setup has been running for months without a problem.

Now, in 1 week time, 3 similar errors occured:

Error -1: 1282 (dbmg): Cannot find any record with that primary key in table xxx
Error -1: 1277 (dbmg): The database journal integration failed at entry #306 
(operation id 113410570).
Error -1: 1186 (dbmg): Log file cannot be integrated into database xxxx

The error mentions a different table each of the 3 times it happened.

To fix this, I delete the mirror database, make a new backup on the master, 
restore the backup on the mirror, and integrate the log files that have been 
created in the mean time.


What can be the cause of this? Indexes? Issues with the data file?


Regards,

Rudy Mortier



**********************************************************************
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**********************************************************************

Reply via email to