Error: "que_init: Cannot attach to shared memory/Notice: Parameter SP_QUE_POST_SHMSIZE was trunca (4220131)

Posting stops due to :
"Error: que_init: Cannot attach to shared memory"

"Error: queue initialization failed - exiting"

"Notice: Parameter SP_QUE_POST_SHMSIZE was truncated to <xxx bytes> (system page size <xxx>)."

This is because the system ran out of physical memory for post queue(s)

To resolve this issue decrease the SP_QUE_POST_SHMSIZE on this Target, from the specified number of Meg/bytes to a lower values in range of valid values: greater than 8388607. SharePlex has to be bounced in order for this param to take effect.This parameter determines the specific shared-memory size for EACH post queue.


For example:
sp_ctrl > set param SP_QUE_POST_SHMSIZE 8388607
sp_ctrl > shutdown
Restart sp_cop for param to take effect.

Starting with SharePlex 8.6, the unit of the following parameters have changed from bytes to megabytes (MB). Hence one may want to change all references to the parameters from bytes to megabytes. Here are the latest description of the parameters:

SP_QUE_POST_SHMSIZE

This parameter determines the specific shared-memory size for the post queue.

IMPORTANT: Increasing this parameter might require an increase in the maximum shared memory segment size

in your system settings.

Default: 32 megabytes

Range of valid values: integer greater than 0

Takes effect: When sp_cop is restarted

SP_QUE_Q_SHMSIZE

This parameter determines the specific shared-memory size for the capture and export queues.

Default: 8 megabytes

Range of valid values: integer greater than 0, no maximum

Takes effect: When sp_cop is restarted