{"action":"opened","issue":{"url":"https://api.github.com/repos/saltstack/salt/issues/25664","labels_url":"https://api.github.com/repos/saltstack/salt/issues/25664/labels{/name}","comments_url":"https://api.github.com/repos/saltstack/salt/issues/25664/comments","events_url":"https://api.github.com/repos/saltstack/salt/issues/25664/events","html_url":"https://github.com/saltstack/salt/issues/25664","id":96857504,"number":25664,"title":"2015.5.2  MySQL Returner: salt-run jobs.lookup_jid doesn't return full result for highstate output","user":{"login":"sdm24","id":12277967,"avatar_url":"https://avatars.githubusercontent.com/u/12277967?v=3","gravatar_id":"","url":"https://api.github.com/users/sdm24","html_url":"https://github.com/sdm24","followers_url":"https://api.github.com/users/sdm24/followers","following_url":"https://api.github.com/users/sdm24/following{/other_user}","gists_url":"https://api.github.com/users/sdm24/gists{/gist_id}","starred_url":"https://api.github.com/users/sdm24/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sdm24/subscriptions","organizations_url":"https://api.github.com/users/sdm24/orgs","repos_url":"https://api.github.com/users/sdm24/repos","events_url":"https://api.github.com/users/sdm24/events{/privacy}","received_events_url":"https://api.github.com/users/sdm24/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-07-23T16:54:19Z","updated_at":"2015-07-23T16:54:19Z","closed_at":null,"body":"I set up a MariaDB database to use MySQL returner recently, and it is correctly storing the jobs cache, and \"salt-run jobs.list_jobs\" correctly lists the jobs in the database. If I run \"salt-run jobs.list_job <jid>\", it will return all of the job data, including the results for all targeted minions. \"salt-run job.print_job <jid>\" returns this as well. \r\n\r\nWhen I run \"salt-run jobs.lookup_jid <jid>\", I only get the last minion's return data:\r\n```yaml\r\nminion3:\r\n----------\r\n          ID: test.ping\r\n    Function: module.run\r\n      Result: True\r\n     Comment: Module function test.ping executed\r\n     Started: 09:27:05.619453\r\n    Duration: 0.669 ms\r\n     Changes:\r\n              ----------\r\n              ret:\r\n                  True\r\n```\r\nIf I change the outputter to something besides the default highstate, I get the full list of all of my minions.\r\n\"salt-run jobs.lookup_jid <jid> --out=pprint\":\r\n```python \r\n{'winminion': {u'module_|-test.ping_|-test.ping_|-run': {u'__run_num__': 0,\r\n                                                             u'changes': {u'ret': True},\r\n                                                             u'comment': u'Module function test.ping executed',\r\n                                                             u'duration': 0.0,\r\n                                                             u'name': u'test.ping',\r\n                                                             u'result': True,\r\n                                                             u'start_time': u'09:23:55.147000'}},\r\n 'minion1': {u'module_|-test.ping_|-test.ping_|-run': {u'__run_num__': 0,\r\n                                                            u'changes': {u'ret': True},\r\n                                                            u'comment': u'Module function test.ping executed',\r\n                                                            u'duration': 6.434,\r\n                                                            u'name': u'test.ping',\r\n                                                            u'result': True,\r\n                                                            u'start_time': u'09:24:45.105072'}},\r\n 'mastermin': {u'module_|-test.ping_|-test.ping_|-run': {u'__run_num__': 0,\r\n                                                              u'changes': {u'ret': True},\r\n                                                              u'comment': u'Module function test.ping executed',\r\n                                                              u'duration': 0.922,\r\n                                                              u'name': u'test.ping',\r\n                                                              u'result': True,\r\n                                                              u'start_time': u'09:23:56.338629'}},\r\n 'minion2': {u'module_|-test.ping_|-test.ping_|-run': {u'__run_num__': 0,\r\n                                                              u'changes': {u'ret': True},\r\n                                                              u'comment': u'Module function test.ping executed',\r\n                                                              u'duration': 0.497,\r\n                                                              u'name': u'test.ping',\r\n                                                              u'result': True,\r\n                                                              u'start_time': u'09:23:54.459396'}},\r\n 'minion3': {u'module_|-test.ping_|-test.ping_|-run': {u'__run_num__': 0,\r\n                                                             u'changes': {u'ret': True},\r\n                                                             u'comment': u'Module function test.ping executed',\r\n                                                             u'duration': 0.669,\r\n                                                             u'name': u'test.ping',\r\n                                                             u'result': True,\r\n                                                             u'start_time': u'09:27:05.619453'}}}\r\n```\r\nThe last minion to return with pprint is also the last minion to return with list_job and the only one returned with lookup_jid, which was the last alphabetical minion (I changed the names of my minions because they have some sensitive data). However, if I run a call with errors, the lookup_jid <jid> will only return the FIRST minion that errored. \r\n\r\nsalt --versions-report:\r\n```yaml\r\n                  Salt: 2015.5.2\r\n                Python: 2.7.3 (default, Mar 13 2014, 11:03:55)\r\n                Jinja2: 2.6\r\n              M2Crypto: 0.21.1\r\n        msgpack-python: 0.1.10\r\n          msgpack-pure: Not Installed\r\n              pycrypto: 2.6\r\n               libnacl: Not Installed\r\n                PyYAML: 3.10\r\n                 ioflo: Not Installed\r\n                 PyZMQ: 13.1.0\r\n                  RAET: Not Installed\r\n                   ZMQ: 3.2.3\r\n                  Mako: 0.7.0\r\n Debian source package: 2015.5.2+ds-1~bpo70+1\r\n```\r\nI don't think this is an issue with using MariaDB instead of MySQL, since they use the exact same syntax, and the other salt commands work with it\r\n\r\n"}}