I have resolved CARBON-15265/IDENTITY-3511 as it seems to be related but
different. The current issue will be tracked in IDENTITY-3423.

On Fri, Aug 14, 2015 at 4:07 PM, Indika Sampath <[email protected]> wrote:

> Hi Tharindu,
>
> Please find the attach files which contains stack trace separately.
>
> Cheers!
>
> On Fri, Aug 14, 2015 at 3:55 PM, Tharindu Edirisinghe <[email protected]>
> 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 <[email protected]> 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 <[email protected]>
>>> 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 <
>>>> [email protected]> 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 <[email protected]>
>>>>> wrote:
>>>>>
>>>>>> $subject. Could we have a look?
>>>>>>
>>>>>> --
>>>>>> Ramith Jayasinghe
>>>>>> Technical Lead
>>>>>> WSO2 Inc., http://wso2.com
>>>>>> lean.enterprise.middleware
>>>>>>
>>>>>> E: [email protected]
>>>>>> P: +94 777542851
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>>
>>>>> Tharindu Edirisinghe
>>>>> Software Engineer | WSO2 Inc
>>>>> Identity Server Team
>>>>> Blog : tharindue.blogspot.com
>>>>> mobile : +94 775 181586
>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Dev mailing list
>>>>> [email protected]
>>>>> 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/
>
>
> _______________________________________________
> Dev mailing list
> [email protected]
> http://wso2.org/cgi-bin/mailman/listinfo/dev
>
>


-- 
Thanks & Regards,

*Johann Dilantha Nallathamby*
Technical Lead & Product Lead of WSO2 Identity Server
Integration Technologies Team
WSO2, Inc.
lean.enterprise.middleware

Mobile - *+94777776950*
Blog - *http://nallaa.wordpress.com <http://nallaa.wordpress.com>*
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev

Reply via email to