Weblogic GC Overhead Limit / WebLogic consumes high CPU that stops Alfresco after restart
Alfresco deployed on WebLogic / Linux using high CPU resources thats stopping Alfresco application after restart. We tried few time but it works for few minutes then CPU usages goes up resulting in breaking the application. Below is the the error we're getting.
### The error may exist in alfresco/ibatis/#resource.dialect#/propval-common-SqlMap.xml
### The error may involve alfresco.propval.select_PropertyById-Inline
### The error occurred while setting parameters
### SQL: select pl.root_prop_id as link_root_prop_id, pl.prop_index as link_prop_index, pl.contained_in as link_contained_in, pl.key_prop_id as link_key_prop_id, pl.value_prop_id as link_value_prop_id, pv.actual_type_id as prop_actual_type_id, pv.persisted_type as prop_persisted_type, pv.long_value as prop_long_value, dv.double_value as prop_double_value, sv.string_value as prop_string_value, serv.serializable_value as prop_serializable_value from alf_prop_link pl join alf_prop_value pv on (pl.value_prop_id = pv.id) left join alf_prop_double_value dv on (dv.id = pv.long_value and pv.persisted_type = 2) left join alf_prop_string_value sv on (sv.id = pv.long_value and (pv.persisted_type = 3 OR pv.persisted_type = 5 OR pv.persisted_type = 6)) left join alf_prop_serializable_value serv on (serv.id = pv.long_value and pv.persisted_type = 4) where pl.root_prop_id = ?