{"action":"created","issue":{"url":"https://api.github.com/repos/spring-projects/spring-boot/issues/6637","repository_url":"https://api.github.com/repos/spring-projects/spring-boot","labels_url":"https://api.github.com/repos/spring-projects/spring-boot/issues/6637/labels{/name}","comments_url":"https://api.github.com/repos/spring-projects/spring-boot/issues/6637/comments","events_url":"https://api.github.com/repos/spring-projects/spring-boot/issues/6637/events","html_url":"https://github.com/spring-projects/spring-boot/issues/6637","id":170872210,"number":6637,"title":"Spring boot project : jpa query returning old data","user":{"login":"ankurgarg1041","id":20991433,"avatar_url":"https://avatars.githubusercontent.com/u/20991433?v=3","gravatar_id":"","url":"https://api.github.com/users/ankurgarg1041","html_url":"https://github.com/ankurgarg1041","followers_url":"https://api.github.com/users/ankurgarg1041/followers","following_url":"https://api.github.com/users/ankurgarg1041/following{/other_user}","gists_url":"https://api.github.com/users/ankurgarg1041/gists{/gist_id}","starred_url":"https://api.github.com/users/ankurgarg1041/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ankurgarg1041/subscriptions","organizations_url":"https://api.github.com/users/ankurgarg1041/orgs","repos_url":"https://api.github.com/users/ankurgarg1041/repos","events_url":"https://api.github.com/users/ankurgarg1041/events{/privacy}","received_events_url":"https://api.github.com/users/ankurgarg1041/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/spring-projects/spring-boot/labels/move-to-stackoverflow","name":"move-to-stackoverflow","color":"eb6420"}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-08-12T13:33:23Z","updated_at":"2016-08-12T14:19:35Z","closed_at":"2016-08-12T14:00:50Z","body":"Hi,\r\nWe have created a spring boot project using 1.3.5 version. Our application interacts with Mysql database.\r\nWe have created a set of jpa-repositories in which we are using findAll, findOne and other custom queries method.\r\n\r\nWe are facing a issue which is occurring randomly  .  Following are the  steps to reproduce it:\r\n1. Fire a read query on db using spring-boot application.\r\n2. Now Manually  change the data in Mysql  using mysql-console  for the records which are returned by above read query.\r\n3. Now again fire the same read query using application.\r\nAfter step 3 , we should have received  the modified results of step 2, but what we got was the data before modification.\r\n\r\n4. Now if we again fire the read query using application, It gives us correct values.\r\n\r\n\r\nThis issue is happening randomly. We are not using any kind of cache in our application.\r\n\r\nWhile debugging I found out that jpa-repository code is calling database and it fetches the latest result .  But when this call return back to our application service , it has the old data.\r\n\r\nPlease help us identify the possible cause of it.\r\n\r\n\r\n\r\n<!--\r\nThanks for raising a Spring Boot issue. What sort of issue are you raising?\r\n\r\nQuestion\r\n\r\nPlease ask questions about how to use something, or to understand why something isn't\r\nworking as you expect it to, on Stack Overflow using the spring-boot tag.\r\n\r\nBug report\r\n\r\nPlease provide details of the problem, including the version of Spring Boot that you\r\nare using. If possible, please provide a test case or sample application that reproduces\r\nthe problem. This makes it much easier for us to diagnose the problem and to verify that\r\nwe have fixed it.\r\n\r\nEnhancement\r\n\r\nPlease start by describing the problem that you are trying to solve. There may already\r\nbe a solution, or there may be a way to solve it that you hadn't considered.\r\n-->"},"comment":{"url":"https://api.github.com/repos/spring-projects/spring-boot/issues/comments/239458950","html_url":"https://github.com/spring-projects/spring-boot/issues/6637#issuecomment-239458950","issue_url":"https://api.github.com/repos/spring-projects/spring-boot/issues/6637","id":239458950,"user":{"login":"ankurgarg1041","id":20991433,"avatar_url":"https://avatars.githubusercontent.com/u/20991433?v=3","gravatar_id":"","url":"https://api.github.com/users/ankurgarg1041","html_url":"https://github.com/ankurgarg1041","followers_url":"https://api.github.com/users/ankurgarg1041/followers","following_url":"https://api.github.com/users/ankurgarg1041/following{/other_user}","gists_url":"https://api.github.com/users/ankurgarg1041/gists{/gist_id}","starred_url":"https://api.github.com/users/ankurgarg1041/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ankurgarg1041/subscriptions","organizations_url":"https://api.github.com/users/ankurgarg1041/orgs","repos_url":"https://api.github.com/users/ankurgarg1041/repos","events_url":"https://api.github.com/users/ankurgarg1041/events{/privacy}","received_events_url":"https://api.github.com/users/ankurgarg1041/received_events","type":"User","site_admin":false},"created_at":"2016-08-12T14:19:35Z","updated_at":"2016-08-12T14:19:35Z","body":"Hi\r\nLet me rephrase my concern.\r\nMy concern is that is there a any chance of possible bug in spring boot around this ?\r\n\r\nHas any one reported similar kind of bug till date?\r\n\r\nFirst I thought that there might be an issue at my end but I  have been contacted by an another person in my organisation who is facing similar issue with their application.\r\n\r\nPlease let me know if still I should post it only on stackoverflow."}}
{"actor":{"display_login":"ankurgarg1041"}}