> On May 19, 2019, at 07:33, Two Way Communications via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > 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. > > 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? > I agree that the indexes may be suspect. Have you rebuilt the index file? (just delete the .indx file and it will auto-rebuild). Also, have you run MSC on the master data file? That could be informative. HTH, Tom Benedict ********************************************************************** 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 **********************************************************************