HELP - User threads "Waiting on a buffer"

All, We are running into an issue with IDS 7.31.UD4 engine. We are running some load testing against our applications, and we notice that eventually the application hangs. There are no X locks on the DB at athe time, but a ton of my threads are in "Waiting on a Buffer" status. It looks like they are all waiting for the same buffer. It is interesting that the application always hangs (gets the buffer waits) trying to read from the same table. Also interesting enough, if we drop and recreate the table and then run our load test, we do not see the issue. It is only after we delete the test records from the table and rerun the load test that we see the issue. Any thoughts or rcommendations on troubleshooting this? Thanks, Greg

Greg Collett wrote: > All, > > We are running into an issue with IDS 7.31.UD4 engine. > > We are running some load testing against our applications, and we > notice that eventually the application hangs. There are no X locks on > the DB at athe time, but a ton of my threads are in "Waiting on a > Buffer" status. It looks like they are all waiting for the same > buffer. > > It is interesting that the application always hangs (gets the buffer > waits) trying to read from the same table. Also interesting enough, > if we drop and recreate the table and then run our load test, we do > not see the issue. It is only after we delete the test records from > the table and rerun the load test that we see the issue. > > Any thoughts or rcommendations on troubleshooting this? I've seen a situation similar to this. If I make a "status" in dbaccess I also "lock" my self... Are you making grants on some tables? Did you get the stack trace of the sessions? I couldn't get enough information at the time it happened. I can't reproduce the situation... :( Regards