Oracle DEADLOCKS caused by ActiveMQ

Solution


Edit /usr/local/blackboard/config/internal/sql/discovery/peer_service_db_specific.sql.
Add the highlighted text and save.

## Update the last_seen timestamp for all services provided by this node

update.last.seen=\

UPDATE peer_service

  SET last_seen = sysdate, inactive_ind = 'N'

  WHERE node_id = ${param.node_id}

## Flags services that have not been seen recently

mark.inactive=\

UPDATE peer_service

  SET inactive_ind = 'Y'

  WHERE last_seen < (sysdate - ${timeout_inactive}/86400)

  AND inactive_ind = 'N'

## Removes services that have not been seen recently

delete.stale=\

DELETE FROM peer_service