Dimuthu, I was under the impression this was solved. Thought Anjana had a look @ it. This cannot be a caching issue @ the database level. Then it should impact everywhere. I still feel this is an application level concurrency issue.
Let me discuss with Anjana & get back to you. Sorry for allowing you to live with this for long. On Wed, Jul 4, 2012 at 3:56 PM, Dimuthu Leelarathne <[email protected]>wrote: > 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 >>>> >>> >>> >> > -- /sumedha +94 773017743
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
