{"action":"created","issue":{"url":"https://api.github.com/repos/aodn/content/issues/178","repository_url":"https://api.github.com/repos/aodn/content","labels_url":"https://api.github.com/repos/aodn/content/issues/178/labels{/name}","comments_url":"https://api.github.com/repos/aodn/content/issues/178/comments","events_url":"https://api.github.com/repos/aodn/content/issues/178/events","html_url":"https://github.com/aodn/content/issues/178","id":132303915,"number":178,"title":"SOOP_SST still references `/mnt/imos-t3`","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/configuration","name":"configuration","color":"e11d21"},{"url":"https://api.github.com/repos/aodn/content/labels/data","name":"data","color":"207de5"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-02-09T01:11:22Z","updated_at":"2016-02-09T01:37:25Z","closed_at":null,"body":"```\r\nharvest=> select url from soop_sst.soop_sst_nrt_trajectory_map limit 10;\r\n                                                                  url                                                                  \r\n---------------------------------------------------------------------------------------------------------------------------------------\r\n /mnt/imos-t3/IMOS/opendap/SOOP/SOOP-SST/9HA2479_Pacific-Sun/2010/IMOS_SOOP-SST_MT_20101212T120000Z_9HA2479_FV01_C-20120528T071954Z.nc\r\n /mnt/imos-t3/IMOS/opendap/SOOP/SOOP-SST/9HA2479_Pacific-Sun/2010/IMOS_SOOP-SST_MT_20101213T000000Z_9HA2479_FV01_C-20120528T071955Z.nc\r\n /mnt/imos-t3/IMOS/opendap/SOOP/SOOP-SST/9HA2479_Pacific-Sun/2010/IMOS_SOOP-SST_MT_20101214T000000Z_9HA2479_FV01_C-20120528T071955Z.nc\r\n /mnt/imos-t3/IMOS/opendap/SOOP/SOOP-SST/9HA2479_Pacific-Sun/2010/IMOS_SOOP-SST_MT_20101215T000000Z_9HA2479_FV01_C-20120528T071955Z.nc\r\n /mnt/imos-t3/IMOS/opendap/SOOP/SOOP-SST/9HA2479_Pacific-Sun/2010/IMOS_SOOP-SST_MT_20101216T000000Z_9HA2479_FV01_C-20120528T071955Z.nc\r\n /mnt/imos-t3/IMOS/opendap/SOOP/SOOP-SST/9HA2479_Pacific-Sun/2010/IMOS_SOOP-SST_MT_20101217T000000Z_9HA2479_FV01_C-20120528T071956Z.nc\r\n /mnt/imos-t3/IMOS/opendap/SOOP/SOOP-SST/9HA2479_Pacific-Sun/2010/IMOS_SOOP-SST_MT_20101218T000000Z_9HA2479_FV01_C-20120528T071956Z.nc\r\n /mnt/imos-t3/IMOS/opendap/SOOP/SOOP-SST/9HA2479_Pacific-Sun/2010/IMOS_SOOP-SST_MT_20101219T000000Z_9HA2479_FV01_C-20120528T071956Z.nc\r\n /mnt/imos-t3/IMOS/opendap/SOOP/SOOP-SST/9HA2479_Pacific-Sun/2010/IMOS_SOOP-SST_MT_20101220T000000Z_9HA2479_FV01_C-20120528T071956Z.nc\r\n /mnt/imos-t3/IMOS/opendap/SOOP/SOOP-SST/9HA2479_Pacific-Sun/2010/IMOS_SOOP-SST_MT_20101221T020000Z_9HA2479_FV01_C-20120528T071957Z.nc\r\n(10 rows)\r\n```\r\n\r\nIn the table `indexed_file` it was modified. This view/table should source the key from the `indexed_file` table."},"comment":{"url":"https://api.github.com/repos/aodn/content/issues/comments/181661163","html_url":"https://github.com/aodn/content/issues/178#issuecomment-181661163","issue_url":"https://api.github.com/repos/aodn/content/issues/178","id":181661163,"user":{"login":"lbesnard","id":2382814,"avatar_url":"https://avatars.githubusercontent.com/u/2382814?v=3","gravatar_id":"","url":"https://api.github.com/users/lbesnard","html_url":"https://github.com/lbesnard","followers_url":"https://api.github.com/users/lbesnard/followers","following_url":"https://api.github.com/users/lbesnard/following{/other_user}","gists_url":"https://api.github.com/users/lbesnard/gists{/gist_id}","starred_url":"https://api.github.com/users/lbesnard/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lbesnard/subscriptions","organizations_url":"https://api.github.com/users/lbesnard/orgs","repos_url":"https://api.github.com/users/lbesnard/repos","events_url":"https://api.github.com/users/lbesnard/events{/privacy}","received_events_url":"https://api.github.com/users/lbesnard/received_events","type":"User","site_admin":false},"created_at":"2016-02-09T01:37:25Z","updated_at":"2016-02-09T01:37:25Z","body":"The talend harvester populates both **soop_sst_dm_trajectory_map** and **soop_sst_nrt_trajectory_map** tables with the url value from indexed_file from the time of first harvest. Which means that since they aren't views, the url value hasn't been updated and contains the '/mnt/...' part for the files harvested before the migration. New harvested files are all good.\r\nThose 2 tables need their url column to be updated as well. Could you please do this @danfruehauf \r\n\r\nWe probably need to pay attention as well to *_map* and *_data from other schemas which aren't views\r\n\r\nFYI @smancini "}}