Hi all,
This seems to be a blocker for us. Looks like a caching issue at mysql
and/or pooling layer. I tried without the following indexing and still get
the same results. I don't think it is a mysql layer because the same SQL is
running on mysql_workbench.
CREATE UNIQUE INDEX INDEX_UM_TENANT_UM_DOMAIN_NAME
ON UM_TENANT (UM_DOMAIN_NAME);
thanks,
dimuthu
On Mon, Jul 2, 2012 at 12:51 PM, Dimuthu Leelarathne <[email protected]>wrote:
> Hi all,
>
> AppFactory setup done last hour shows the same error again.
>
> thanks,
> dimuthu
>
>
> On Thu, Jun 28, 2012 at 7:44 PM, Dimuthu Leelarathne <[email protected]>wrote:
>
>> Hi all,
>>
>> I believe what is happening is AppFactory is trying to read the
>> uncommitted data from the db. The attached screenshot explains the scenario
>> nicely. I kept adding test1,test2,test3 .... test8 and out of these only
>> even numbers are actually added - odd ones are failing.
>>
>> But after that I stopped the server did a "select *" before doing the
>> "select UM_ID from where *" in user.core. Then replaced the jar and
>> restarted the server. As you can see test9, test10, test11 and test12 are
>> added without any issue at all. Meaning doing a "select *" somehow forced
>> "select UM_ID from where *" to work correctly. Looks like we are doing some
>> dirty reads.
>>
>> thanks,
>> dimuthu
>>
>>
>> On Thu, Jun 28, 2012 at 5:37 PM, Dimuthu Leelarathne
>> <[email protected]>wrote:
>>
>>> Hi all,
>>>
>>> This is fun. I am wondering whether I should a screen recording of this
>>> event.
>>>
>>> thanks,
>>> dimuthu
>>>
>>
>>
>
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
