We are using an orchestration process to deploy a fixlet id to computers by name. The orchestration process is basically preparing an XML to generate the action via a POST to REST. The process can submit several POST submissions per second and may be called by separate incident management systems. Last week we saw a couple of occurrences where actions created by this process were missing data from the VERSIONS table and this locked up the admin console from loading when trying to load the actions and the main server BESRelay.log on the main server was showing errors with the action ID’s for the DatabasePropogator.
Mon, 17 Jun 2019 05:47:50 -0500 - /data/actions (10628) - A problem occurred with the action having id = 1047149 Database Error: A database query unexpectedly failed to return any results.
Mon, 17 Jun 2019 05:47:50 -0500 - /data/actions (10628) - Database Error: A database query unexpectedly failed to return any results.
We cleared these actions by following the article https://www-01.ibm.com/support/docview.wss?uid=swg22015367 but are curious as to the root cause.
My question, if a scripted or orchestrated process is able to fire numerous POSTs in quick succession to REST, or if 2 separate systems initiate a the POST the REST at the same time, is REST able to queue and process these. I’m wondering if the situation where SYSTEM1 submitting a POST at the same time SYSTEM2 submits a POST, is it possible this might cause an issue that might result in missing data from the tables used by action data. The automation process may submit anything between 10 and 200 actions in a run cycle.
Thanks in advance for your thoughts