• 首页 首页 icon
  • 工具库 工具库 icon
    • IP查询 IP查询 icon
  • 内容库 内容库 icon
    • 快讯库 快讯库 icon
    • 精品库 精品库 icon
    • 问答库 问答库 icon
  • 更多 更多 icon
    • 服务条款 服务条款 icon

“此网页上的错误可能会导致其没办法正常工作".

用户头像
it1352
帮助1

问题说明

大家好,

当我向girdview投标数据时,我收到一条错误消息,如下所示.

Sys.webforms.pagerequestmangerservererrorexception:transaction(进程ID 55)已与其他进程在锁资源上发生死锁,因此被选为死锁受害者.


问候,
Jeevan.

Hi All,

When i am biding data to the girdview i am getting an error message as shown bellow.

Sys.webforms.pagerequestmangerservererrorexception:transaction(process ID 55) was deadlocked on lock resources with other process and has been chosen as the deadlock victim.


Regards,
Jeevan.

正确答案

#1


请检查以下可能对您有帮助的链接,

http://forums.asp.net/p/1069384/1555817.aspx

http://msdn.microsoft.com/en-us/library/bb397479.aspx

http://stackoverflow.com/questions/239669/sys-webforms-pagerequestmanagerservererrorexception-12031
Hi,

Please check following links which might help you,

http://forums.asp.net/p/1069384/1555817.aspx

http://msdn.microsoft.com/en-us/library/bb397479.aspx

http://stackoverflow.com/questions/239669/sys-webforms-pagerequestmanagerservererrorexception-12031
阅读:http://blog.sqlauthority.com/2007/05/16/sql-server-fix-error-1205-transaction-process-id已在资源上与另一个进程死锁,并已选择作为死锁受害者- rerun-the-transaction/ [ ^ ]

没有更多信息,就不可能更具体.
Read this: http://blog.sqlauthority.com/2007/05/16/sql-server-fix-error-1205-transaction-process-id-was-deadlocked-on-resources-with-another-process-and-has-been-chosen-as-the-deadlock-victim-rerun-the-transaction/[^]

Without more information, it is not possible to be more specific.
嗯,我从您的问题中了解的内容如下.

通常,SQL Server以特定方式组织表中的数据.如果有1000个用户在允许的同一张表上操作,但所有用户都在更新/编辑同一条记录或相似的记录,则sql server允许以先到先得的方式运行,并且该用户锁定表以完成更新,我们称之为作为死锁条件.请通过运行sql探查器检查是否有这种情况...
Well What I understood from your question is as follows.

In general sql server organizes data in tables in a specific manner. If there are 1000 users operating on the same table it allowed but all they are updating/editing the same record or similar records then sql server allows in first come first serve basis and table is locked for updation to finish by that user, this we call as deadlock condition. Please check if there is any situation like this by running the sql profiler...

这篇好文章是转载于:学新通技术网

  • 版权申明: 本站部分内容来自互联网,仅供学习及演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系,请提供相关证据及您的身份证明,我们将在收到邮件后48小时内删除。
  • 本站站名: 学新通技术网
  • 本文地址: /reply/detail/tanhcfkajk
系列文章
更多 icon
同类精品
更多 icon
继续加载