{"action":"created","issue":{"url":"https://api.github.com/repos/puppetlabs/puppetdb/issues/1599","labels_url":"https://api.github.com/repos/puppetlabs/puppetdb/issues/1599/labels{/name}","comments_url":"https://api.github.com/repos/puppetlabs/puppetdb/issues/1599/comments","events_url":"https://api.github.com/repos/puppetlabs/puppetdb/issues/1599/events","html_url":"https://github.com/puppetlabs/puppetdb/pull/1599","id":101087539,"number":1599,"title":"(PDB-1852) Add migration and storage for JSONB columns for Unchanged Resources","user":{"login":"ajroetker","id":3198124,"avatar_url":"https://avatars.githubusercontent.com/u/3198124?v=3","gravatar_id":"","url":"https://api.github.com/users/ajroetker","html_url":"https://github.com/ajroetker","followers_url":"https://api.github.com/users/ajroetker/followers","following_url":"https://api.github.com/users/ajroetker/following{/other_user}","gists_url":"https://api.github.com/users/ajroetker/gists{/gist_id}","starred_url":"https://api.github.com/users/ajroetker/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ajroetker/subscriptions","organizations_url":"https://api.github.com/users/ajroetker/orgs","repos_url":"https://api.github.com/users/ajroetker/repos","events_url":"https://api.github.com/users/ajroetker/events{/privacy}","received_events_url":"https://api.github.com/users/ajroetker/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/puppetlabs/puppetdb/milestones/8","html_url":"https://github.com/puppetlabs/puppetdb/milestones/3.2.0","labels_url":"https://api.github.com/repos/puppetlabs/puppetdb/milestones/8/labels","id":1256027,"number":8,"title":"3.2.0","description":"","creator":{"login":"ajroetker","id":3198124,"avatar_url":"https://avatars.githubusercontent.com/u/3198124?v=3","gravatar_id":"","url":"https://api.github.com/users/ajroetker","html_url":"https://github.com/ajroetker","followers_url":"https://api.github.com/users/ajroetker/followers","following_url":"https://api.github.com/users/ajroetker/following{/other_user}","gists_url":"https://api.github.com/users/ajroetker/gists{/gist_id}","starred_url":"https://api.github.com/users/ajroetker/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ajroetker/subscriptions","organizations_url":"https://api.github.com/users/ajroetker/orgs","repos_url":"https://api.github.com/users/ajroetker/repos","events_url":"https://api.github.com/users/ajroetker/events{/privacy}","received_events_url":"https://api.github.com/users/ajroetker/received_events","type":"User","site_admin":false},"open_issues":2,"closed_issues":0,"state":"open","created_at":"2015-08-14T23:38:34Z","updated_at":"2015-08-18T11:37:26Z","due_on":null,"closed_at":null},"comments":3,"created_at":"2015-08-14T19:31:57Z","updated_at":"2015-08-18T21:46:02Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/puppetlabs/puppetdb/pulls/1599","html_url":"https://github.com/puppetlabs/puppetdb/pull/1599","diff_url":"https://github.com/puppetlabs/puppetdb/pull/1599.diff","patch_url":"https://github.com/puppetlabs/puppetdb/pull/1599.patch"},"body":"This commit moves to using JSONB columns for metrics, logs, and the new\r\ncolumn resources in the reports table. The resources column will be used\r\nby unchanged resources for storing \"resource\" jsonb blobs. The old\r\nmetrics and logs json columns have been moved to deprecated_metrics and\r\ndeprecated_logs (coalesced with the jsonb columns in the query-eng to\r\npreserve querying for the old data).\r\n\r\nThis commit also changes PuppetDB's report storage to expect the v6\r\nwire-format with the resources (instead of resource_events) field and\r\nstores the resources document as a JSONB column in reports that was\r\ncreated in a previous commit's migration addition. This commit updates\r\nthe tests to be more compatible with the new version, removing\r\nunnecessary fields in the example reports' `resource_events` fields."},"comment":{"url":"https://api.github.com/repos/puppetlabs/puppetdb/issues/comments/132365242","html_url":"https://github.com/puppetlabs/puppetdb/pull/1599#issuecomment-132365242","issue_url":"https://api.github.com/repos/puppetlabs/puppetdb/issues/1599","id":132365242,"user":{"login":"pljenkinsro","id":6546951,"avatar_url":"https://avatars.githubusercontent.com/u/6546951?v=3","gravatar_id":"","url":"https://api.github.com/users/pljenkinsro","html_url":"https://github.com/pljenkinsro","followers_url":"https://api.github.com/users/pljenkinsro/followers","following_url":"https://api.github.com/users/pljenkinsro/following{/other_user}","gists_url":"https://api.github.com/users/pljenkinsro/gists{/gist_id}","starred_url":"https://api.github.com/users/pljenkinsro/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pljenkinsro/subscriptions","organizations_url":"https://api.github.com/users/pljenkinsro/orgs","repos_url":"https://api.github.com/users/pljenkinsro/repos","events_url":"https://api.github.com/users/pljenkinsro/events{/privacy}","received_events_url":"https://api.github.com/users/pljenkinsro/received_events","type":"User","site_admin":false},"created_at":"2015-08-18T21:46:02Z","updated_at":"2015-08-18T21:46:02Z","body":"Test FAILed.\nRefer to this link for build results (access rights to CI server needed): \nhttps://jenkins.puppetlabs.com/job/platform_puppetdb_intn-sys_pr/1807/"}}