Duplicate queries of duplicate queries that never finished continued until they consumed all resources on the database server.
Until I shut down the cluster.
(And saved the database server and all the other applications whose databases also live on that server).
How’d I do it?
In a running cluster, using Weblogic 9.2, the underpinnings of Bb Vista 8.0, I changed the JMS server settings from “WebCTManagedNode A (migratable)” to “WebCTManagedNode A”.
Weblogic told me the configuration change was activated and no restart was necessary.
Exactly like on our development and test environments.
Only this time people were doing tasks which were reliant upon the JMS servers, and the application kept asking the database for a response on their behalf … I think.
Chime in those of you who might understand the Weblogic/Vista underlying architecture.
Another for my list of “Things to Never do Again.”