{"action":"created","issue":{"url":"https://api.github.com/repos/CrunchyData/crunchy-containers/issues/31","repository_url":"https://api.github.com/repos/CrunchyData/crunchy-containers","labels_url":"https://api.github.com/repos/CrunchyData/crunchy-containers/issues/31/labels{/name}","comments_url":"https://api.github.com/repos/CrunchyData/crunchy-containers/issues/31/comments","events_url":"https://api.github.com/repos/CrunchyData/crunchy-containers/issues/31/events","html_url":"https://github.com/CrunchyData/crunchy-containers/issues/31","id":185898786,"number":31,"title":"execute cannot be used while an asynchronous query is underway","user":{"login":"bkmagnetron","id":4893873,"avatar_url":"https://avatars.githubusercontent.com/u/4893873?v=3","gravatar_id":"","url":"https://api.github.com/users/bkmagnetron","html_url":"https://github.com/bkmagnetron","followers_url":"https://api.github.com/users/bkmagnetron/followers","following_url":"https://api.github.com/users/bkmagnetron/following{/other_user}","gists_url":"https://api.github.com/users/bkmagnetron/gists{/gist_id}","starred_url":"https://api.github.com/users/bkmagnetron/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bkmagnetron/subscriptions","organizations_url":"https://api.github.com/users/bkmagnetron/orgs","repos_url":"https://api.github.com/users/bkmagnetron/repos","events_url":"https://api.github.com/users/bkmagnetron/events{/privacy}","received_events_url":"https://api.github.com/users/bkmagnetron/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2016-10-28T11:18:37Z","updated_at":"2016-11-02T14:43:17Z","closed_at":"2016-11-02T14:43:17Z","body":"I have created a transaction which has 1000 inserts and executed it via pgpool but before the transaction completed I force terminated the client.\nNow, I can able to SELECT that table via pgpool as well as directly via master. But on replica when I execute SELECT query I get the following error.\n\n```\nexecute cannot be used while an asynchronous query is underway********** Error **********\n```\n\nI installed my cluster using [kubehelm](https://github.com/CrunchyData/crunchy-containers/tree/master/examples/kubehelm/crunchy-postgres)(1 crunchy-master, 3 crunchy-replicas) and [pgpool](https://github.com/CrunchyData/crunchy-containers/tree/master/examples/kube/pgpool) seprately. I don't even added persistent volumes. Its been a while now but I'm still getting the same error.\n\nlogs:\n\n```\n$ kubectl logs pgpool\n...\n2016-10-28 10:49:43: pid 29: LOG:  statement: BEGIN\n2016-10-28 10:49:43: pid 29: LOG:  statement: \n2016-10-28 10:49:43: pid 29: LOG:  statement: INSERT INTO \"public\".\"test\" (\"text\") VALUES (E'0')\n...\n2016-10-28 10:51:15: pid 29: LOG:  statement: \n2016-10-28 10:51:15: pid 29: LOG:  statement: INSERT INTO \"public\".\"test\" (\"text\") VALUES (E'502')\n2016-10-28 10:51:15: pid 29: ERROR:  unable to read data from frontend\n2016-10-28 10:51:15: pid 29: DETAIL:  socket read failed with an error \"Connection reset by peer\"\n2016-10-28 10:51:30: pid 30: LOG:  new connection received\n2016-10-28 10:51:30: pid 30: DETAIL:  connecting host=gke-cluster-1-default-pool-14ed9ed5-r6c7.c.container-1372.internal port=53435\n...\n```\n\nThen I also truncated that table and inserted 1000 records in single INSERT via using pgpool. It successfully completed and I can able to SELECT the inserted records via pgpool and master. But still having error on replica.\n\n```\n$ kubectl logs pgpool\n...\n2016-10-28 10:56:41: pid 30: LOG:  statement: INSERT INTO \"public\".\"test\" (\"text\") VALUES (E'0'),(E'1'),(E'2'),(E'3')\n...\n(E'9996'),(E'9997'),(E'9998'),(E'9999')\n2016-10-28 10:57:27: pid 30: LOG:  statement: \n```\n"},"comment":{"url":"https://api.github.com/repos/CrunchyData/crunchy-containers/issues/comments/257885340","html_url":"https://github.com/CrunchyData/crunchy-containers/issues/31#issuecomment-257885340","issue_url":"https://api.github.com/repos/CrunchyData/crunchy-containers/issues/31","id":257885340,"user":{"login":"jmccormick2001","id":863211,"avatar_url":"https://avatars.githubusercontent.com/u/863211?v=3","gravatar_id":"","url":"https://api.github.com/users/jmccormick2001","html_url":"https://github.com/jmccormick2001","followers_url":"https://api.github.com/users/jmccormick2001/followers","following_url":"https://api.github.com/users/jmccormick2001/following{/other_user}","gists_url":"https://api.github.com/users/jmccormick2001/gists{/gist_id}","starred_url":"https://api.github.com/users/jmccormick2001/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmccormick2001/subscriptions","organizations_url":"https://api.github.com/users/jmccormick2001/orgs","repos_url":"https://api.github.com/users/jmccormick2001/repos","events_url":"https://api.github.com/users/jmccormick2001/events{/privacy}","received_events_url":"https://api.github.com/users/jmccormick2001/received_events","type":"User","site_admin":false},"created_at":"2016-11-02T14:43:17Z","updated_at":"2016-11-02T14:43:17Z","body":"thanks, I'll close this one out.  cheers."}}
{"actor":{"display_login":"jmccormick2001"}}