7035: Replication Server out of memory

Symptom

After a connection is started, these error messages are displayed in the Replication Server error log:

I. 2006/06/13 10:58:42. The DSI thread for database ‘westernDS.westDB’ is
started.
E. 2006/06/13 10:58:42. ERROR #7035 DIST(westernDS.westDB) - m/memseg.c(771)
.........Additional allocation would exceed the memory_limit of ‘20000’
specified in the configuration.
Increase the value of the memory_limit parameter in the rs_config table and
restart the Repserver.

A second attempt at resuming the connection displays only the following informational message:

I. 2006/06/13 11:08:06. Attempt to start a DSI thread
for database ‘westernDS.westDB’ that has already been
started.

Running admin who_is_down at the Replication Server indicates that threads are down.

Both DIST and DIST EXEC threads are down:

Spid   Name        State   Info
----   ---------   -----   --------------------------
       DIST        Down    westernDS.westDB
       DIST EXEC   Down    105:1 westernDS.westDB

Explanation

Replication Server ran out of segment memory. The maximum amount of operating system memory that a Replication Server can use is equal to the value specified by the memory_limit parameter. Replication Server directly uses operating system memory.

Solution

To fix this problem:

  1. Increase the value of the memory_limit parameter.

  2. Restart the Replication Server.