The following errors are observed in event_log when sp_cop dies shortly after it is invoked or started (the values shown below are from an actual failure at a site):
Notice 2015-12-17 20:22:15.036000 5228 6752 Cop: Total queue shared memory required 84025344; total for post queues 67108864 [module que]
Error 2015-12-17 20:22:15.052000 5228 6752 Cop: No support to convert queue version 0, in queue [module que]
Error 2015-12-17 20:22:16.114000 5228 6752 Cop: queue initialization failed - exiting [module cop]
Increase the value of the parameter SP_SHS_SHMSIZE to a value equal to or higher than the one listed in the event log. For example, in our situation, increase it to a value higher than 84025344. Given the fact that sp_cop fails to come up, the value for SP_SHS_SHMSIZE cannot be set via sp_ctrl. The only way to set it is by setting it in the paramdb file. So, if we want to set it to say, 90000000, which is higher than 84025344, let us add the following entry in the paramdb file as below:
SP_SHS_SHMSIZE "90000000"
Then restart SharePlex. This should resolve the problem.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center