CDLUC3 / mrt-doc

Documentation and Information regarding the Merritt repository
8 stars 4 forks source link

Dryad presigned retrieval error #769

Closed terrywbrady closed 2 years ago

terrywbrady commented 2 years ago
dpr2@uc3-mrtui03x2-prd:~/apps/ui/current/log$ grep 2c591204-1761-4968-ba30-9e935ea3f53d production.log
I, [2021-08-20T13:53:56.839249 #17936]  INFO -- : [2c591204-1761-4968-ba30-9e935ea3f53d] Started GET "/api/presign-file/ark%3A%2F13030%2Fm51s1rwr/1/producer%2FREADME_for_MeisnerLongtermCageData.txt?no_redirect=true" for 52.35.63.239 at 2021-08-20 13:53:56 -0700
I, [2021-08-20T13:53:56.839865 #17936]  INFO -- : [2c591204-1761-4968-ba30-9e935ea3f53d] Processing by FileController#presign as TEXT
I, [2021-08-20T13:53:56.839912 #17936]  INFO -- : [2c591204-1761-4968-ba30-9e935ea3f53d]   Parameters: {"no_redirect"=>"true", "object"=>"ark:/13030/m51s1rwr", "version"=>"1", "file"=>"producer/README_for_MeisnerLongtermCageData.txt"}
D, [2021-08-20T13:53:56.843579 #17936] DEBUG -- : [2c591204-1761-4968-ba30-9e935ea3f53d]   InvFile Load (1.3ms)  SELECT  `inv_files`.* FROM `inv_files` INNER JOIN `inv_versions` ON `inv_versions`.`id` = `inv_files`.`inv_version_id` INNER JOIN `inv_objects` ON `inv_objects`.`id` = `inv_files`.`inv_object_id` WHERE (inv_objects.ark = 'ark:/13030/m51s1rwr') AND (inv_versions.number = '1') AND (inv_files.pathname = 'producer/README_for_MeisnerLongtermCageData.txt') ORDER BY `inv_files`.`id` ASC LIMIT 1
D, [2021-08-20T13:53:56.845203 #17936] DEBUG -- : [2c591204-1761-4968-ba30-9e935ea3f53d]   InvVersion Load (1.1ms)  SELECT  `inv_versions`.* FROM `inv_versions` WHERE `inv_versions`.`id` = 3961374 LIMIT 1
D, [2021-08-20T13:53:56.846641 #17936] DEBUG -- : [2c591204-1761-4968-ba30-9e935ea3f53d]   InvObject Load (1.0ms)  SELECT  `inv_objects`.* FROM `inv_objects` WHERE `inv_objects`.`id` = 2930690 LIMIT 1
D, [2021-08-20T13:53:56.848529 #17936] DEBUG -- : [2c591204-1761-4968-ba30-9e935ea3f53d]   InvCollection Load (1.1ms)  SELECT  `inv_collections`.* FROM `inv_collections` INNER JOIN `inv_collections_inv_objects` ON `inv_collections`.`id` = `inv_collections_inv_objects`.`inv_collection_id` WHERE `inv_collections_inv_objects`.`inv_object_id` = 2930690 ORDER BY `inv_collections`.`id` ASC LIMIT 1
D, [2021-08-20T13:53:56.940538 #17936] DEBUG -- : [2c591204-1761-4968-ba30-9e935ea3f53d]   InvEmbargo Load (2.7ms)  SELECT  `inv_embargoes`.* FROM `inv_embargoes` WHERE `inv_embargoes`.`inv_object_id` = 2930690 LIMIT 1
I, [2021-08-20T13:53:56.941168 #17936]  INFO -- : [2c591204-1761-4968-ba30-9e935ea3f53d]   Rendering public/401.html
I, [2021-08-20T13:53:56.941248 #17936]  INFO -- : [2c591204-1761-4968-ba30-9e935ea3f53d]   Rendered public/401.html (0.0ms)
I, [2021-08-20T13:53:56.941348 #17936]  INFO -- : [2c591204-1761-4968-ba30-9e935ea3f53d] Filter chain halted as :check_download rendered or redirected
I, [2021-08-20T13:53:56.941418 #17936]  INFO -- : [2c591204-1761-4968-ba30-9e935ea3f53d] Completed 401 Unauthorized in 101ms (Views: 0.4ms | ActiveRecord: 7.2ms)

The embargo has expired

MySQL [inv]> SELECT  `inv_embargoes`.* FROM `inv_embargoes` WHERE `inv_embargoes`.`inv_object_id` = 2930690 LIMIT 1;
+-------+---------------+---------------------+
| id    | inv_object_id | embargo_end_date    |
+-------+---------------+---------------------+
| 19205 |       2930690 | 2015-01-13 16:00:00 |
+-------+---------------+---------------------+
1 row in set (0.00 sec)

When browsing to the files in Dryad, the 401 does not recur.

https://datadryad.org/stash/dataset/doi:10.5061/dryad.h73b0

marisastrong commented 2 years ago

This error was discovered while troubleshooting Nagios alerts on 8-20-2021. Unknown impact to user. Expected behavior of being able to download dataset from Dryad is functioning properly