Hi Tharindu, Please find the attach files which contains stack trace separately.
Cheers!
On Fri, Aug 14, 2015 at 3:55 PM, Tharindu Edirisinghe <tharin...@wso2.com>
wrote:
> Hi Indika,
>
> We are looking to identify the issue. Can you also send us the stack trace
> of the two scenarios separately.
>
> Thanks,
> TharinduE
>
> On Fri, Aug 14, 2015 at 3:50 PM, Indika Sampath <indi...@wso2.com> wrote:
>
>> Hi Tharindu,
>>
>> Above deadlock occurred when we remove topic subscription.
>>
>> DELETE FROM UM_HYBRID_ROLE WHERE UM_ROLE_NAME =
>> 'Q_tmp_192_168_1_21_41372_1' AND UM_TENANT_ID=-1234
>>
>> We are getting another deadlock when we adding topic subscription also.
>>
>> INSERT INTO UM_HYBRID_USER_ROLE (UM_USER_NAME, UM_ROLE_ID, UM_TENANT_ID,
>> UM_DOMAIN_ID) VALUES ('admin',(SELECT UM_ID FROM UM_HYBRID_ROLE WHERE
>> UM_ROLE_NAME='Q_tmp_192_168_1_21_58252_1' AND UM_TENANT_ID=-1234), -1234,
>> (SELECT UM_DOMAIN_ID FROM UM_DOMAIN WHERE UM_TENANT_ID=-1234 AND
>> UM_DOMAIN_NAME='PRIMARY'))
>>
>> Please find the attached text file which contains output of SHOW ENGINE
>> INNODB STATUS;
>>
>> Cheers!
>>
>> On Fri, Aug 14, 2015 at 3:40 PM, Indika Sampath <indi...@wso2.com> wrote:
>>
>>> Hi Tharindu,
>>>
>>> Please find the attach text file which contains output of above command.
>>>
>>> Cheers!
>>>
>>> On Fri, Aug 14, 2015 at 1:03 PM, Tharindu Edirisinghe <
>>> tharin...@wso2.com> wrote:
>>>
>>>> Hi Ramith,
>>>>
>>>> It seems this is not the exact same issue reported in [1]. For
>>>> investigating further can you connect to mysql database from terminal/mysql
>>>> client and run the following command and share the output with us. We
>>>> should be able to see the database level errors caused from the output of
>>>> this command [2].
>>>>
>>>> *SHOW ENGINE INNODB STATUS;*
>>>>
>>>> [1] https://wso2.org/jira/browse/CARBON-15265
>>>> [2] https://dev.mysql.com/doc/refman/5.5/en/show-engine.html
>>>>
>>>> Thanks,
>>>> TharinduE
>>>>
>>>> On Fri, Aug 14, 2015 at 12:44 PM, Ramith Jayasinghe <ram...@wso2.com>
>>>> wrote:
>>>>
>>>>> $subject. Could we have a look?
>>>>>
>>>>> --
>>>>> Ramith Jayasinghe
>>>>> Technical Lead
>>>>> WSO2 Inc., http://wso2.com
>>>>> lean.enterprise.middleware
>>>>>
>>>>> E: ram...@wso2.com
>>>>> P: +94 777542851
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>>
>>>> Tharindu Edirisinghe
>>>> Software Engineer | WSO2 Inc
>>>> Identity Server Team
>>>> Blog : tharindue.blogspot.com
>>>> mobile : +94 775 181586
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Dev mailing list
>>>> Dev@wso2.org
>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>>>
>>>>
>>>
>>>
>>> --
>>> Indika Sampath
>>> Senior Software Engineer
>>> WSO2 Inc.
>>> http://wso2.com
>>>
>>> Phone: +94 716 424 744
>>> Blog: http://indikasampath.blogspot.com/
>>>
>>>
>>
>>
>> --
>> Indika Sampath
>> Senior Software Engineer
>> WSO2 Inc.
>> http://wso2.com
>>
>> Phone: +94 716 424 744
>> Blog: http://indikasampath.blogspot.com/
>>
>>
>
>
> --
>
> Tharindu Edirisinghe
> Software Engineer | WSO2 Inc
> Identity Server Team
> Blog : tharindue.blogspot.com
> mobile : +94 775 181586
>
>
>
--
Indika Sampath
Senior Software Engineer
WSO2 Inc.
http://wso2.com
Phone: +94 716 424 744
Blog: http://indikasampath.blogspot.com/
add_subscription_stack_trace
Description: Binary data
remove_subscription_stack_trace
Description: Binary data
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
