{"action":"closed","issue":{"url":"https://api.github.com/repos/pgjdbc/pgjdbc/issues/658","repository_url":"https://api.github.com/repos/pgjdbc/pgjdbc","labels_url":"https://api.github.com/repos/pgjdbc/pgjdbc/issues/658/labels{/name}","comments_url":"https://api.github.com/repos/pgjdbc/pgjdbc/issues/658/comments","events_url":"https://api.github.com/repos/pgjdbc/pgjdbc/issues/658/events","html_url":"https://github.com/pgjdbc/pgjdbc/issues/658","id":181658586,"number":658,"title":"PreparedStatement.executeBatch hangs indefinitely on query error","user":{"login":"mechkg","id":819194,"avatar_url":"https://avatars.githubusercontent.com/u/819194?v=3","gravatar_id":"","url":"https://api.github.com/users/mechkg","html_url":"https://github.com/mechkg","followers_url":"https://api.github.com/users/mechkg/followers","following_url":"https://api.github.com/users/mechkg/following{/other_user}","gists_url":"https://api.github.com/users/mechkg/gists{/gist_id}","starred_url":"https://api.github.com/users/mechkg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mechkg/subscriptions","organizations_url":"https://api.github.com/users/mechkg/orgs","repos_url":"https://api.github.com/users/mechkg/repos","events_url":"https://api.github.com/users/mechkg/events{/privacy}","received_events_url":"https://api.github.com/users/mechkg/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-10-07T12:39:19Z","updated_at":"2016-10-20T11:45:05Z","closed_at":"2016-10-20T11:45:05Z","body":"I am running into strange hangs with batch SQL -- the execute batch method simply hangs forever if the query contains an error. For instance I can see this in the log when I try to `executeBatch`:\r\n```\r\n2016-10-07 11:53:03 BST [28102-37] postgres@intake24_foods_development ERROR:  INSERT has more expressions than target columns at character 42\r\n2016-10-07 11:53:03 BST [28102-38] postgres@intake24_foods_development STATEMENT:  INSERT INTO source_images VALUES(DEFAULT,$1,$2,$3,DEFAULT)\r\n```\r\nand it never returns on the Java side.\r\n\r\nHowever if I fix the query it works just fine.\r\n\r\nI don't think I have ever run into this before, what can I do to diagnose the issue?\r\n\r\nOS: Ubuntu 16.04\r\nPostgreSQL server version: 9.5 (9.5+173)\r\nDriver version: 9.4.1211 (also tried 1210 and 1209, same result)\r\n\r\n"}}
{"actor":{"display_login":"mechkg"}}