{"action":"created","issue":{"url":"https://api.github.com/repos/GSA/catalog-app/issues/29","repository_url":"https://api.github.com/repos/GSA/catalog-app","labels_url":"https://api.github.com/repos/GSA/catalog-app/issues/29/labels{/name}","comments_url":"https://api.github.com/repos/GSA/catalog-app/issues/29/comments","events_url":"https://api.github.com/repos/GSA/catalog-app/issues/29/events","html_url":"https://github.com/GSA/catalog-app/issues/29","id":139134072,"number":29,"title":"Resolving database inconsistencies","user":{"login":"dportnoy","id":2925801,"avatar_url":"https://avatars.githubusercontent.com/u/2925801?v=3","gravatar_id":"","url":"https://api.github.com/users/dportnoy","html_url":"https://github.com/dportnoy","followers_url":"https://api.github.com/users/dportnoy/followers","following_url":"https://api.github.com/users/dportnoy/following{/other_user}","gists_url":"https://api.github.com/users/dportnoy/gists{/gist_id}","starred_url":"https://api.github.com/users/dportnoy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dportnoy/subscriptions","organizations_url":"https://api.github.com/users/dportnoy/orgs","repos_url":"https://api.github.com/users/dportnoy/repos","events_url":"https://api.github.com/users/dportnoy/events{/privacy}","received_events_url":"https://api.github.com/users/dportnoy/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-03-08T00:13:21Z","updated_at":"2016-03-09T05:22:10Z","closed_at":null,"body":"I had problems harvesting data.json today with the latest catalog-app distribution. \r\n\r\nBackground...  I originally installed the catalog-app distro a couple weeks ago, when persistent store for postgresql, solr and ckan files wasn't configured.  I recently pulled the new configuration and executed \"docker-compose up\".  The result...\r\n\r\nThe result... CKAN seems to be working, but in some funky state.  The data originally harvested was blown away, due to not having persistent store previously.  But looks like the admin user and organization have been saved.  Going to the \"/harvest\" URL indicated no harvesters, but when I tried to add one, I got an error that the URL is already being harvested.  So I'm assuming the DB is somehow in an inconsistent state.  (While it's not seeing harvesters, it's seeing previously registered harvest URLs.)\r\n\r\nSo two questions:\r\n1. What's the easiest solution to this problem?\r\n2. What's the most efficient way to start with a clean CKAN DB? \r\n\r\ncc: @JJediny "},"comment":{"url":"https://api.github.com/repos/GSA/catalog-app/issues/comments/194117314","html_url":"https://github.com/GSA/catalog-app/issues/29#issuecomment-194117314","issue_url":"https://api.github.com/repos/GSA/catalog-app/issues/29","id":194117314,"user":{"login":"dportnoy","id":2925801,"avatar_url":"https://avatars.githubusercontent.com/u/2925801?v=3","gravatar_id":"","url":"https://api.github.com/users/dportnoy","html_url":"https://github.com/dportnoy","followers_url":"https://api.github.com/users/dportnoy/followers","following_url":"https://api.github.com/users/dportnoy/following{/other_user}","gists_url":"https://api.github.com/users/dportnoy/gists{/gist_id}","starred_url":"https://api.github.com/users/dportnoy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dportnoy/subscriptions","organizations_url":"https://api.github.com/users/dportnoy/orgs","repos_url":"https://api.github.com/users/dportnoy/repos","events_url":"https://api.github.com/users/dportnoy/events{/privacy}","received_events_url":"https://api.github.com/users/dportnoy/received_events","type":"User","site_admin":false},"created_at":"2016-03-09T05:22:10Z","updated_at":"2016-03-09T05:22:10Z","body":"This issue should be low priority or closed.  It might be a one-off problem that doesn't affect anyone else.  I think it was just a transitional issue when migrating to a version that configures persistent store.  Basically, the datasets in Solr were blown away, but some of the data in Postgres (users, orgs, harvesters) remained.  I had one other issue with harvesters not showing up in Postgres, but I was able to hack a fix to it.\r\n\r\nHowever, I still think it would be useful to provide instructions for restarting with a clean Solr and Postgres schema, in case data gets corrupted. "}}