{"action":"created","issue":{"url":"https://api.github.com/repos/aodn/content/issues/148","labels_url":"https://api.github.com/repos/aodn/content/issues/148/labels{/name}","comments_url":"https://api.github.com/repos/aodn/content/issues/148/comments","events_url":"https://api.github.com/repos/aodn/content/issues/148/events","html_url":"https://github.com/aodn/content/issues/148","id":114531821,"number":148,"title":"talend aatams_acoustic_reporting jams the DB","user":{"login":"danfruehauf","id":830676,"avatar_url":"https://avatars.githubusercontent.com/u/830676?v=3","gravatar_id":"","url":"https://api.github.com/users/danfruehauf","html_url":"https://github.com/danfruehauf","followers_url":"https://api.github.com/users/danfruehauf/followers","following_url":"https://api.github.com/users/danfruehauf/following{/other_user}","gists_url":"https://api.github.com/users/danfruehauf/gists{/gist_id}","starred_url":"https://api.github.com/users/danfruehauf/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/danfruehauf/subscriptions","organizations_url":"https://api.github.com/users/danfruehauf/orgs","repos_url":"https://api.github.com/users/danfruehauf/repos","events_url":"https://api.github.com/users/danfruehauf/events{/privacy}","received_events_url":"https://api.github.com/users/danfruehauf/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/aodn/content/labels/data","name":"data","color":"207de5"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":12,"created_at":"2015-11-02T06:17:55Z","updated_at":"2015-11-06T01:21:27Z","closed_at":null,"body":"This is the query that seems to take forever:\r\n```\r\nSELECT \"pkid\",\"detection_id\",\"project_name\",\"installation_name\",\"station_name\",\"bottom_depth\",\"common_name\",\"transmitter_id\",\"relea\r\nse_date\",\"release_locality\",\"detection_date\",\"longitude\",\"latitude\",\"sex\",\"scientific_name\",encode(ST_AsEWKB(\"geom\"),'base64') as \"geom\",\"detected\",\"r\r\neceiver_name\" FROM \"dw_aatams_acoustic\".\"aatams_acoustic_detections_data\" LIMIT 1\r\n```\r\n\r\nThe harvester is running and this query is also ran in front of geoserver-rc, which uses the same DB the harvester probably does. Will need more investigation, but until then, I suggest to not run that harvester.\r\n\r\n**This will affect users using the portal as it denies service**"},"comment":{"url":"https://api.github.com/repos/aodn/content/issues/comments/154255004","html_url":"https://github.com/aodn/content/issues/148#issuecomment-154255004","issue_url":"https://api.github.com/repos/aodn/content/issues/148","id":154255004,"user":{"login":"xhoenner","id":3443821,"avatar_url":"https://avatars.githubusercontent.com/u/3443821?v=3","gravatar_id":"","url":"https://api.github.com/users/xhoenner","html_url":"https://github.com/xhoenner","followers_url":"https://api.github.com/users/xhoenner/followers","following_url":"https://api.github.com/users/xhoenner/following{/other_user}","gists_url":"https://api.github.com/users/xhoenner/gists{/gist_id}","starred_url":"https://api.github.com/users/xhoenner/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/xhoenner/subscriptions","organizations_url":"https://api.github.com/users/xhoenner/orgs","repos_url":"https://api.github.com/users/xhoenner/repos","events_url":"https://api.github.com/users/xhoenner/events{/privacy}","received_events_url":"https://api.github.com/users/xhoenner/received_events","type":"User","site_admin":false},"created_at":"2015-11-06T01:21:27Z","updated_at":"2015-11-06T01:21:27Z","body":"it's definitely going to work now! "}}