{"action":"closed","issue":{"url":"https://api.github.com/repos/noblesamurai/node-pg-jobs/issues/27","repository_url":"https://api.github.com/repos/noblesamurai/node-pg-jobs","labels_url":"https://api.github.com/repos/noblesamurai/node-pg-jobs/issues/27/labels{/name}","comments_url":"https://api.github.com/repos/noblesamurai/node-pg-jobs/issues/27/comments","events_url":"https://api.github.com/repos/noblesamurai/node-pg-jobs/issues/27/events","html_url":"https://github.com/noblesamurai/node-pg-jobs/issues/27","id":157840107,"number":27,"title":"Database details not documented; db connection silently fails","user":{"login":"jonathan-stone","id":6812837,"avatar_url":"https://avatars0.githubusercontent.com/u/6812837?v=3","gravatar_id":"","url":"https://api.github.com/users/jonathan-stone","html_url":"https://github.com/jonathan-stone","followers_url":"https://api.github.com/users/jonathan-stone/followers","following_url":"https://api.github.com/users/jonathan-stone/following{/other_user}","gists_url":"https://api.github.com/users/jonathan-stone/gists{/gist_id}","starred_url":"https://api.github.com/users/jonathan-stone/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jonathan-stone/subscriptions","organizations_url":"https://api.github.com/users/jonathan-stone/orgs","repos_url":"https://api.github.com/users/jonathan-stone/repos","events_url":"https://api.github.com/users/jonathan-stone/events{/privacy}","received_events_url":"https://api.github.com/users/jonathan-stone/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-06-01T07:24:13Z","updated_at":"2017-05-14T22:48:28Z","closed_at":"2017-05-14T22:48:28Z","body":"I'm trying to use node-pg-jobs and I can't tell if I'm supposed to create the DB tables myself, or if the package is supposed to do it for me. I don't see any evidence that it's connecting to my DB, but there are no helpful error messages about the DB connection.\n\nIs this project functional?\n\nI don't get any errors back from `pg-jobs()`. \n\nThe callback from `jobs.process(worker, callback)` is called immediately, but with no parameters passed. According to the docs this means job processing has stopped, but I have no idea why.\n\nCalling `jobs.create(myJobObject, null, callback)` -> Callback is called without invoking the worker, and it returns the following error object:\n\n```\n{ [error: relation \"job_snapshots\" does not exist]\n   name: 'error',\n   length: 105,\n   severity: 'ERROR',\n   code: '42P01',\n   detail: undefined,\n   hint: undefined,\n   position: '13',\n   internalPosition: undefined,\n   internalQuery: undefined,\n   where: undefined,\n   schema: undefined,\n   table: undefined,\n   column: undefined,\n   dataType: undefined,\n   constraint: undefined,\n   file: 'parse_relation.c',\n   line: '1159',\n   routine: 'parserOpenTable' }\n```\n\nThis error, along with the fact that the job_snapshots table does not exist in my DB, leads me to believe there is no DB connection happening. \n\nHow can I troubleshoot this? Also, some documentation of the DB interactions / instructions would be helpful. \n"}}
{"actor":{"display_login":"timlesallen"}}