Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Informix Topics / October 2003

Tip: Looking for answers? Try searching our database.

HELP - User threads "Waiting on a buffer"

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Greg Collett - 29 Oct 2003 22:09 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.