7035

Replication Server out of memory

Symptoms

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

I. 95/12/19 16:42:09. The DSI thread for database ‘westernDS.westDB’ is started.
 E. 95/12/19 16:42:17. 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. 95/12/19 16:50:21. Attempt to start a DSI thread for database ‘westernDS.westDB’ that has already been started.

Running adminwho_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.

Solutions

To fix this problem:

Increase the value of the memory_limit parameter.
Restart the Replication Server.