Sybase dbdata9.dll 阻塞线程并挂起 IIS
如果这个问题已经被问过并解决了，我们深表歉意，但通过大量的搜索和失去的头发，我们已经到了穷途末路的地步！
我们有一个通过 IIS 6 运行 Web 服务的 Web 服务器。这些 Web 服务与我们的数据库服务器通信，该数据库服务器同时拥有 Sybase SQL Anywhere 9 数据库和 MS SQL 数据库。自 12 月初发布以来，我们一直遇到 IIS 挂起的情况，只能通过回收默认应用程序池来再次响应。通过许多调查、内存转储和代码更改，一切似乎都指向 Sybase 数据库才是罪魁祸首。自该版本发布以来，它的访问量大大增加，这一事实证明了这一点。
我们已经尝试了几乎所有可能的方法，但是当 Web 服务器挂起时我们所做的每个内存转储都包含“检测到可能的阻塞或泄漏的关键部分” 以及与“dbdata9”相关的信息 这是用于 Sybase 数据库的主要 dll。
我们发现我们还没有获得最新的 Sybase .Net Provider，并且已在服务器和代码中更新了这些内容，但我们仍然会遇到这些偶尔的挂起！内存转储中多次报告的最新消息是：
“在 dbdata9 处检测到可能阻塞或泄漏的关键部分！AsaTransaction_SendTransactionCookie+46640 由线程 # 拥有”
我已经没有想法了为了解决这个问题，如果有人对如何进展有任何好的建议，那将是一个很大的帮助！
如果您需要更多信息，请询问，我会提供。
提前致谢。
Apologies if this has already been asked and solved but through numerous searches and lost hair we're getting to the end of our tether!
We have a web server running web services through IIS 6. These web services talk to our database server which has both Sybase SQL Anywhere 9 databases and MS SQL databases. Since a release at the start of December we have been experiencing IIS hanging and can only be made responsive again by re-cycling the default App Pool. Through many investigations, memory dumps and code changes everything seems to be pointing to the Sybase database that is being the culprit. This is backed up by the fact that it is now being accessed a lot more since this release.
We have tried pretty much everything possible but every memory dump we have done when the web server hangs contains the information that "Detected possible blocking or leaked critical section" and that it relates to "dbdata9" which is the main dll used for the Sybase database.
We found that we had not got the latest Sybase .Net Provider and have updated these on the server and in the code but we are still getting these occasional hangs! The latest message that has been reported in the memory dumps a few times is:
"Detected possible blocking or leaked critical section at dbdata9!AsaTransaction_SendTransactionCookie+46640 owned by thread #"
I'm running out of ideas how to get around this and if anyone has any good suggestions on how to progress with this it'd be a great help!
If you need any more information just ask and I will provide.
Thanks in advance.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
对于任何想知道的人来说，问题似乎出在 Sybase 本身，并在其软件的更高版本中得到修复。一旦我们将 dll 更新到最新版本，问题似乎就解决了。如果有人想了解更多这方面的信息，请随时询问。
For anyone who wants to know it seems that the problem was with Sybase itself and was fixed in a later version of its software. Once we updated the dlls to the latest version it seems to have cleared our issues. If anyone wants any more information on this please feel free to ask.