AI archives get created even when no one is using the db

Posted by Joey Samoy on 02-Oct-2019 20:58

Hi,

Enabled ai archiver on a static database, set the interval to run every 2 mins. New archives get created but nobody else is using the database except me. What would be on those archives?

From rfutil list, it shows the extent status changes (busy, empty). When on one updates the db, what makes an extent busy to full?

TIA!

Posted by Rob Fitzpatrick on 02-Oct-2019 22:03

At the end of each -aiarcinterval, the process repeats.  The current (busy) extent is closed, marked full, archived, marked empty, then the next (empty) extent is opened and changed from empty to busy.  This assumes there is a next empty extent to switch to.  

All Replies

Posted by Rob Fitzpatrick on 02-Oct-2019 21:39

The extent status changes are being made by the AI archiver as it closes the current extent, archives it, and opens the next extent in sequence.

Posted by Joey Samoy on 02-Oct-2019 21:58

When next iteration executes, it archives the current busy extent and marks it as full, then empty, then goes to the next extent?

Posted by Rob Fitzpatrick on 02-Oct-2019 22:03

At the end of each -aiarcinterval, the process repeats.  The current (busy) extent is closed, marked full, archived, marked empty, then the next (empty) extent is opened and changed from empty to busy.  This assumes there is a next empty extent to switch to.  

Posted by Joey Samoy on 02-Oct-2019 22:15

Ok. Thanks, so that is why new archives are created everytime even there are no changes to data.

Posted by Joey Samoy on 02-Oct-2019 22:16

Thanks!

So that is why a new archive is created everytime even if there are no changes to the data.

Posted by Rob Fitzpatrick on 02-Oct-2019 22:19

If you configure the use of the AI archiver with an archive interval, you're saying you want a new extent every interval regardless of change activity.  

Posted by gus bjorklund on 03-Oct-2019 19:50

It would be better if the interval was skipped altogether when nothing has been written. The archived ai extents are of no value when there are no notes in them but they must be processed unnecessarily when rolling forward.

This thread is closed