Document ID: TEC1920756Last Modified Date: 2/13/201
Author: Hallett_German
Products
Description:
The Postgres APM database is seeing "Out of Shared Memory Errors." What can be done about this?
Issue:
Customer has a MOM and an APM Postgres Database on the same server. Shared Memory Errors appear when doing one of two things:
update ts_us_sessions_map set ts_soft_delete=true, ts_ageout_time='2013-01-21 17:45:00' where ts_soft_delete=false and ts_last_update<'2013-01-21 16:45:00' and ts_app_id=1;
However, the database table involved is empty and executing the following query returns a value of zero:
select count (*) from ts_us_sessions_map;
apmdes01:/opt/wily_data/data/bin> PGUSER=admin PGPASSWORD="admin" psql -q -d cemdb cemdb=> update ts_us_sessions_map set ts_soft_delete=true, ts_ageout_time='2015-01-21 17:45:00' where ts_soft_delete=false and ts_last_update<'2015-01-21 16:45:00' and ts_app_id=1; WARNING: out of shared memory ERROR: out of shared memory HINT: You might need to increase max_locks_per_transaction. cemdb-> \q
Solution:
Here are some things to investigate should this issue occurs
Additional Information:
http://www.thegeekstuff.com/2010/08/ipcs-command-examples/
https://communities.ca.com/servlet/JiveServlet/downloadBody/117511715-102-2-13530/20140424%20Database%20Maintenance.pdf
Also see TEC610638.
Search the Entire CA APM Knowledge Base