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
Fernando Nunes - 30 Oct 2003 02:49 GMT
> All,
>
[quoted text clipped - 13 lines]
>
> 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
itsme - 30 Oct 2003 13:14 GMT
Bug: 163653 REFER 162377 SAME BUG IN 9.40 ENGINE HUNG ON BLOCKED CKPT DUE TO
DEADLOCK BETWEEN BTSCANNER AND SQLEXEC
May be you are hitting this bug, or something similar (when you delete
records, the btscanner is active). Check with tech support.
Leave some time between you delete the records and running the test again.
And see if you application hangs again.
> All,
>
[quoted text clipped - 16 lines]
> Thanks,
> Greg