{"action":"created","issue":{"url":"https://api.github.com/repos/ghaering/pysqlite/issues/64","labels_url":"https://api.github.com/repos/ghaering/pysqlite/issues/64/labels{/name}","comments_url":"https://api.github.com/repos/ghaering/pysqlite/issues/64/comments","events_url":"https://api.github.com/repos/ghaering/pysqlite/issues/64/events","html_url":"https://github.com/ghaering/pysqlite/issues/64","id":29729146,"number":64,"title":"race condition bug? Bind error on cursor.execute. Second try with exact same vars works. ","user":{"login":"ZeerDonker","id":4290287,"avatar_url":"https://avatars.githubusercontent.com/u/4290287?v=3","gravatar_id":"","url":"https://api.github.com/users/ZeerDonker","html_url":"https://github.com/ZeerDonker","followers_url":"https://api.github.com/users/ZeerDonker/followers","following_url":"https://api.github.com/users/ZeerDonker/following{/other_user}","gists_url":"https://api.github.com/users/ZeerDonker/gists{/gist_id}","starred_url":"https://api.github.com/users/ZeerDonker/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ZeerDonker/subscriptions","organizations_url":"https://api.github.com/users/ZeerDonker/orgs","repos_url":"https://api.github.com/users/ZeerDonker/repos","events_url":"https://api.github.com/users/ZeerDonker/events{/privacy}","received_events_url":"https://api.github.com/users/ZeerDonker/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":{"login":"ghaering","id":907541,"avatar_url":"https://avatars.githubusercontent.com/u/907541?v=3","gravatar_id":"","url":"https://api.github.com/users/ghaering","html_url":"https://github.com/ghaering","followers_url":"https://api.github.com/users/ghaering/followers","following_url":"https://api.github.com/users/ghaering/following{/other_user}","gists_url":"https://api.github.com/users/ghaering/gists{/gist_id}","starred_url":"https://api.github.com/users/ghaering/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ghaering/subscriptions","organizations_url":"https://api.github.com/users/ghaering/orgs","repos_url":"https://api.github.com/users/ghaering/repos","events_url":"https://api.github.com/users/ghaering/events{/privacy}","received_events_url":"https://api.github.com/users/ghaering/received_events","type":"User","site_admin":false},"milestone":null,"comments":3,"created_at":"2014-03-19T12:50:36Z","updated_at":"2015-08-18T19:18:18Z","closed_at":"2015-08-18T19:18:18Z","body":"Hello,\r\n\r\nIn a program where multiple times cursors are opened, select and other statements are performed and then closed. \r\nSome of those select statements fail with the following error. This error does not happen, if the exact same line is executed again, with exactly the same variables. \r\n\r\n```\r\nInterfaceError: Error binding parameter 0 - probably unsupported type.\r\n```\r\n\r\nSo something like this fails occasionally. (Where the dataStr is more than 160 characters long. )\r\n```python\r\ncursor = conn.cursor()\r\nresults = cursor.execute (\"SELECT * FROM tableName WHERE Data_One LIKE ? AND is_bla=? AND Data_ola=?;\", (dataStr + '%', '1', '8',))\r\nhi = results.fetchone()\r\ncursor.close()\r\n```\r\nAnd something like this works.\r\n```python\r\ncursor = conn.cursor()\r\ntry:\r\n    results = cursor.execute (\"SELECT * FROM tableName WHERE Data_One LIKE ? AND is_bla=? AND Data_ola=?;\", (dataStr + '%', '1', '8',))\r\nexcept:\r\n    results = cursor.execute (\"SELECT * FROM tableName WHERE Data_One LIKE ? AND is_bla=? AND Data_ola=?;\", (dataStr + '%', '1', '8',))\r\nhi = results.fetchone()\r\ncursor.close()\r\n```"},"comment":{"url":"https://api.github.com/repos/ghaering/pysqlite/issues/comments/132322865","html_url":"https://github.com/ghaering/pysqlite/issues/64#issuecomment-132322865","issue_url":"https://api.github.com/repos/ghaering/pysqlite/issues/64","id":132322865,"user":{"login":"ghaering","id":907541,"avatar_url":"https://avatars.githubusercontent.com/u/907541?v=3","gravatar_id":"","url":"https://api.github.com/users/ghaering","html_url":"https://github.com/ghaering","followers_url":"https://api.github.com/users/ghaering/followers","following_url":"https://api.github.com/users/ghaering/following{/other_user}","gists_url":"https://api.github.com/users/ghaering/gists{/gist_id}","starred_url":"https://api.github.com/users/ghaering/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ghaering/subscriptions","organizations_url":"https://api.github.com/users/ghaering/orgs","repos_url":"https://api.github.com/users/ghaering/repos","events_url":"https://api.github.com/users/ghaering/events{/privacy}","received_events_url":"https://api.github.com/users/ghaering/received_events","type":"User","site_admin":false},"created_at":"2015-08-18T19:18:18Z","updated_at":"2015-08-18T19:18:18Z","body":"I cannot do much without a test case. I am sorry."}}