Cached Row for System Table Was Swapped Out

A cached row is swapped out to accommodate another row.

Symptom

This informational message appears many times in the Replication Server error log:

I. 2006/06/13 15:39:53. A cached row for system table
‘rs_columns’ was swapped out of the cache in order to
accomodate another row.

Explanation

When there is no space available in the cache for any more rows in a specific Replication Server System Database (RSSD) system table, that system table’s oldest rows are swapped out of the cache.

The sts_cachesize parameter specifies the maximum number of rows that are cached for a single RSSD system table.

Solution

Increase the value of the sts_cachesize parameter for the RSSD.