Error - Deadlock found when trying to get lock; try restarting

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Error - Deadlock found when trying to get lock; try restarting

prateekgommt
Hi Guys,

While hitting a request multiple times via Jmeter,  I'm getting this error
message from Application. Had a word with Dev & as per him, its an mysql
error .

Any idea on how to handle this from Jmeter end or Mysql's end ?


*{"status_code":422,"error_code":"","optional_msg":"(1213, u'Deadlock found
when trying to get lock; try restarting
transaction')","errmsg":"","error":true}*


Thanks,
Prateek Dua

--


::DISCLAIMER::


----------------------------------------------------------------------------------------------------------------------------------------------------





This message is intended only for the use of the addressee and may
contain information that is privileged, confidential and exempt from
disclosure under applicable law. If the reader of this message is not the
intended recipient, or the employee or agent responsible for delivering the
message to the intended recipient, you are hereby notified that any
dissemination, distribution or copying of this communication is strictly
prohibited. If you have received this e-mail in error, please notify us
immediately by return e-mail and delete this e-mail and all attachments
from your system.
Reply | Threaded
Open this post in threaded view
|

Re: Error - Deadlock found when trying to get lock; try restarting

贾国动
Do you parameterize your request?
Do not always operate on the same database record.


在 2018/12/10 21:29,“Prateek Dua”<[hidden email]> 写入:

    Hi Guys,
   
    While hitting a request multiple times via Jmeter,  I'm getting this error
    message from Application. Had a word with Dev & as per him, its an mysql
    error .
   
    Any idea on how to handle this from Jmeter end or Mysql's end ?
   
   
    *{"status_code":422,"error_code":"","optional_msg":"(1213, u'Deadlock found
    when trying to get lock; try restarting
    transaction')","errmsg":"","error":true}*
   
   
    Thanks,
    Prateek Dua
   
    --
   
   
    ::DISCLAIMER::
   
   
    ----------------------------------------------------------------------------------------------------------------------------------------------------
   
   
   
   
   
    This message is intended only for the use of the addressee and may
    contain information that is privileged, confidential and exempt from
    disclosure under applicable law. If the reader of this message is not the
    intended recipient, or the employee or agent responsible for delivering the
    message to the intended recipient, you are hereby notified that any
    dissemination, distribution or copying of this communication is strictly
    prohibited. If you have received this e-mail in error, please notify us
    immediately by return e-mail and delete this e-mail and all attachments
    from your system.
   
   



---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: Error - Deadlock found when trying to get lock; try restarting

prateekgommt
Thanks, I'll try that & let you know.

On Tue, Dec 11, 2018 at 2:34 PM 贾国动 <[hidden email]> wrote:

> Do you parameterize your request?
> Do not always operate on the same database record.
>
>
> 在 2018/12/10 21:29,“Prateek Dua”<[hidden email]> 写入:
>
>     Hi Guys,
>
>     While hitting a request multiple times via Jmeter,  I'm getting this
> error
>     message from Application. Had a word with Dev & as per him, its an
> mysql
>     error .
>
>     Any idea on how to handle this from Jmeter end or Mysql's end ?
>
>
>     *{"status_code":422,"error_code":"","optional_msg":"(1213, u'Deadlock
> found
>     when trying to get lock; try restarting
>     transaction')","errmsg":"","error":true}*
>
>
>     Thanks,
>     Prateek Dua
>
>     --
>
>
>     ::DISCLAIMER::
>
>
>
> ----------------------------------------------------------------------------------------------------------------------------------------------------
>
>
>
>
>
>     This message is intended only for the use of the addressee and may
>     contain information that is privileged, confidential and exempt from
>     disclosure under applicable law. If the reader of this message is not
> the
>     intended recipient, or the employee or agent responsible for
> delivering the
>     message to the intended recipient, you are hereby notified that any
>     dissemination, distribution or copying of this communication is
> strictly
>     prohibited. If you have received this e-mail in error, please notify
> us
>     immediately by return e-mail and delete this e-mail and all
> attachments
>     from your system.
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [hidden email]
> For additional commands, e-mail: [hidden email]
>
>

--


::DISCLAIMER::


----------------------------------------------------------------------------------------------------------------------------------------------------





This message is intended only for the use of the addressee and may
contain information that is privileged, confidential and exempt from
disclosure under applicable law. If the reader of this message is not the
intended recipient, or the employee or agent responsible for delivering the
message to the intended recipient, you are hereby notified that any
dissemination, distribution or copying of this communication is strictly
prohibited. If you have received this e-mail in error, please notify us
immediately by return e-mail and delete this e-mail and all attachments
from your system.
Reply | Threaded
Open this post in threaded view
|

Re: Error - Deadlock found when trying to get lock; try restarting

prateekgommt
Thank you. Parametrization worked out.

Just a quick question.. How can we change the Priority of execution of http
requests ( apart from drag & drop to change the position) within thread
group ?

On Tue, Dec 11, 2018 at 7:05 PM Prateek Dua <[hidden email]> wrote:

> Thanks, I'll try that & let you know.
>
> On Tue, Dec 11, 2018 at 2:34 PM 贾国动 <[hidden email]>
> wrote:
>
>> Do you parameterize your request?
>> Do not always operate on the same database record.
>>
>>
>> 在 2018/12/10 21:29,“Prateek Dua”<[hidden email]> 写入:
>>
>>     Hi Guys,
>>
>>     While hitting a request multiple times via Jmeter,  I'm getting this
>> error
>>     message from Application. Had a word with Dev & as per him, its an
>> mysql
>>     error .
>>
>>     Any idea on how to handle this from Jmeter end or Mysql's end ?
>>
>>
>>     *{"status_code":422,"error_code":"","optional_msg":"(1213, u'Deadlock
>> found
>>     when trying to get lock; try restarting
>>     transaction')","errmsg":"","error":true}*
>>
>>
>>     Thanks,
>>     Prateek Dua
>>
>>     --
>>
>>
>>     ::DISCLAIMER::
>>
>>
>>
>> ----------------------------------------------------------------------------------------------------------------------------------------------------
>>
>>
>>
>>
>>
>>     This message is intended only for the use of the addressee and may
>>     contain information that is privileged, confidential and exempt from
>>     disclosure under applicable law. If the reader of this message is not
>> the
>>     intended recipient, or the employee or agent responsible for
>> delivering the
>>     message to the intended recipient, you are hereby notified that any
>>     dissemination, distribution or copying of this communication is
>> strictly
>>     prohibited. If you have received this e-mail in error, please notify
>> us
>>     immediately by return e-mail and delete this e-mail and all
>> attachments
>>     from your system.
>>
>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [hidden email]
>> For additional commands, e-mail: [hidden email]
>>
>>

--


::DISCLAIMER::


----------------------------------------------------------------------------------------------------------------------------------------------------





This message is intended only for the use of the addressee and may
contain information that is privileged, confidential and exempt from
disclosure under applicable law. If the reader of this message is not the
intended recipient, or the employee or agent responsible for delivering the
message to the intended recipient, you are hereby notified that any
dissemination, distribution or copying of this communication is strictly
prohibited. If you have received this e-mail in error, please notify us
immediately by return e-mail and delete this e-mail and all attachments
from your system.
Reply | Threaded
Open this post in threaded view
|

Re: Error - Deadlock found when trying to get lock; try restarting

贾国动
Sampler elements are processed in the order in which they appear in the tree,
Logical Controllers let you customize the logic that JMeter uses to decide when to send requests.
Refer to: https://jmeter.apache.org/usermanual/component_reference.html#logic_controllers


在 2018/12/17 21:16,“Prateek Dua”<[hidden email]> 写入:

    Thank you. Parametrization worked out.
   
    Just a quick question.. How can we change the Priority of execution of http
    requests ( apart from drag & drop to change the position) within thread
    group ?
   
    On Tue, Dec 11, 2018 at 7:05 PM Prateek Dua <[hidden email]> wrote:
   
    > Thanks, I'll try that & let you know.
    >
    > On Tue, Dec 11, 2018 at 2:34 PM 贾国动 <[hidden email]>
    > wrote:
    >
    >> Do you parameterize your request?
    >> Do not always operate on the same database record.
    >>
    >>
    >> 在 2018/12/10 21:29,“Prateek Dua”<[hidden email]> 写入:
    >>
    >>     Hi Guys,
    >>
    >>     While hitting a request multiple times via Jmeter,  I'm getting this
    >> error
    >>     message from Application. Had a word with Dev & as per him, its an
    >> mysql
    >>     error .
    >>
    >>     Any idea on how to handle this from Jmeter end or Mysql's end ?
    >>
    >>
    >>     *{"status_code":422,"error_code":"","optional_msg":"(1213, u'Deadlock
    >> found
    >>     when trying to get lock; try restarting
    >>     transaction')","errmsg":"","error":true}*
    >>
    >>
    >>     Thanks,
    >>     Prateek Dua
    >>
    >>     --
    >>
    >>
    >>     ::DISCLAIMER::
    >>
    >>
    >>
    >> ----------------------------------------------------------------------------------------------------------------------------------------------------
    >>
    >>
    >>
    >>
    >>
    >>     This message is intended only for the use of the addressee and may
    >>     contain information that is privileged, confidential and exempt from
    >>     disclosure under applicable law. If the reader of this message is not
    >> the
    >>     intended recipient, or the employee or agent responsible for
    >> delivering the
    >>     message to the intended recipient, you are hereby notified that any
    >>     dissemination, distribution or copying of this communication is
    >> strictly
    >>     prohibited. If you have received this e-mail in error, please notify
    >> us
    >>     immediately by return e-mail and delete this e-mail and all
    >> attachments
    >>     from your system.
    >>
    >>
    >>
    >>
    >>
    >> ---------------------------------------------------------------------
    >> To unsubscribe, e-mail: [hidden email]
    >> For additional commands, e-mail: [hidden email]
    >>
    >>
   
    --
   
   
    ::DISCLAIMER::
   
   
    ----------------------------------------------------------------------------------------------------------------------------------------------------
   
   
   
   
   
    This message is intended only for the use of the addressee and may
    contain information that is privileged, confidential and exempt from
    disclosure under applicable law. If the reader of this message is not the
    intended recipient, or the employee or agent responsible for delivering the
    message to the intended recipient, you are hereby notified that any
    dissemination, distribution or copying of this communication is strictly
    prohibited. If you have received this e-mail in error, please notify us
    immediately by return e-mail and delete this e-mail and all attachments
    from your system.
   



---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]