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
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev
