R
rayherring
Guest
Not sure about your particular use-case, but we use Classic Appserver with Webspeed brokers/agents running in 'Stateless' mode, one of our temp-tables on very rare occasions ends up with a record in it that breaks the uniqueness. When that temp-table goes haywire, it starts causing intermittent issues across all webspeed agent requests that have nothing to do with that temp-table at all. A restart of the affected broker (it doesn't cross brokers thankfully, of which we have 3) cures the problem. I've never really worked out why it affects everything that isn't even related, the same thing occurs when a query isn't query-prepared properly in a service that the agents all fire up, once 1 agent causes the issue, all agents for that broker get affected by it until the broker is restarted.
Continue reading...
Continue reading...