{"action":"created","issue":{"url":"https://api.github.com/repos/ansible/ansible-modules-core/issues/3038","repository_url":"https://api.github.com/repos/ansible/ansible-modules-core","labels_url":"https://api.github.com/repos/ansible/ansible-modules-core/issues/3038/labels{/name}","comments_url":"https://api.github.com/repos/ansible/ansible-modules-core/issues/3038/comments","events_url":"https://api.github.com/repos/ansible/ansible-modules-core/issues/3038/events","html_url":"https://github.com/ansible/ansible-modules-core/pull/3038","id":133544226,"number":3038,"title":"if user is empty, it is not converted to tuple when using host_all","user":{"login":"saez0pub","id":3484146,"avatar_url":"https://avatars.githubusercontent.com/u/3484146?v=3","gravatar_id":"","url":"https://api.github.com/users/saez0pub","html_url":"https://github.com/saez0pub","followers_url":"https://api.github.com/users/saez0pub/followers","following_url":"https://api.github.com/users/saez0pub/following{/other_user}","gists_url":"https://api.github.com/users/saez0pub/gists{/gist_id}","starred_url":"https://api.github.com/users/saez0pub/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/saez0pub/subscriptions","organizations_url":"https://api.github.com/users/saez0pub/orgs","repos_url":"https://api.github.com/users/saez0pub/repos","events_url":"https://api.github.com/users/saez0pub/events{/privacy}","received_events_url":"https://api.github.com/users/saez0pub/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2016-02-14T14:28:49Z","updated_at":"2016-04-07T17:02:56Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/ansible/ansible-modules-core/pulls/3038","html_url":"https://github.com/ansible/ansible-modules-core/pull/3038","diff_url":"https://github.com/ansible/ansible-modules-core/pull/3038.diff","patch_url":"https://github.com/ansible/ansible-modules-core/pull/3038.patch"},"body":"We have an exception if user is empty in combination with host_all: true\r\nTraceback (most recent call last):\r\n  File \"/home/user/.ansible/tmp/ansible-tmp-1455456621.39-33584363856625/mysql_user.2.1\", line 2690, in <module>\r\n    main()\r\n  File \"/home/user/.ansible/tmp/ansible-tmp-1455456621.39-33584363856625/mysql_user.2.1\", line 555, in main\r\n    changed = user_delete(cursor, user, host, host_all, module.check_mode)\r\n  File \"/home/user/.ansible/tmp/ansible-tmp-1455456621.39-33584363856625/mysql_user.2.1\", line 334, in user_delete\r\n    hostnames = user_get_hostnames(cursor, user)\r\n  File \"/home/user/.ansible/tmp/ansible-tmp-1455456621.39-33584363856625/mysql_user.2.1\", line 344, in user_get_hostnames\r\n    cursor.execute(\"SELECT Host FROM mysql.user WHERE user = %s\", user)\r\n  File \"/usr/lib/python2.7/site-packages/MySQLdb/cursors.py\", line 187, in execute\r\n    query = query % tuple([db.literal(item) for item in args])\r\nTypeError: not enough arguments for format string\r\n"},"comment":{"url":"https://api.github.com/repos/ansible/ansible-modules-core/issues/comments/206995534","html_url":"https://github.com/ansible/ansible-modules-core/pull/3038#issuecomment-206995534","issue_url":"https://api.github.com/repos/ansible/ansible-modules-core/issues/3038","id":206995534,"user":{"login":"gregdek","id":252125,"avatar_url":"https://avatars.githubusercontent.com/u/252125?v=3","gravatar_id":"","url":"https://api.github.com/users/gregdek","html_url":"https://github.com/gregdek","followers_url":"https://api.github.com/users/gregdek/followers","following_url":"https://api.github.com/users/gregdek/following{/other_user}","gists_url":"https://api.github.com/users/gregdek/gists{/gist_id}","starred_url":"https://api.github.com/users/gregdek/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gregdek/subscriptions","organizations_url":"https://api.github.com/users/gregdek/orgs","repos_url":"https://api.github.com/users/gregdek/repos","events_url":"https://api.github.com/users/gregdek/events{/privacy}","received_events_url":"https://api.github.com/users/gregdek/received_events","type":"User","site_admin":false},"created_at":"2016-04-07T17:02:56Z","updated_at":"2016-04-07T17:02:56Z","body":"Stuck -- kicking."}}