goci icon indicating copy to clipboard operation
goci copied to clipboard

testing importing large publication with >30000 studies failed

Open Santhi1901 opened this issue 2 years ago • 6 comments

Testing PMID: 34375979

Was successfully submitted in the testing environment (without sumstat): https://wwwdev.ebi.ac.uk/gwas/depo-curation/submissions/62e27657fd97600001675cec

but after it is imported in the testing environment, the page is not loading gwas-snoopy.ebi.ac.uk:9780/gwas/curation/submissions/62e27657fd97600001675cec.

No. of studies 30445 No.of associations: 50450

This is a user-submitted study: https://www.ebi.ac.uk/gwas/depo-curation/submissions/62c592398a6cfa0001651079

Santhi1901 avatar Sep 05 '22 09:09 Santhi1901

@Santhi1901 @ljwh2 based on my investigation the Submission page is not loading due to huge Payload of the AZ submission , the API being called by Curation for loading submission is not paginated so it hangs trying to process huge payload, We need to create a Dev story in order to introduce Pagination in API then only the AZ submission can be curated .

sajo-ebi avatar Sep 13 '22 15:09 sajo-ebi

Dependent on the implementation of the new features here:

https://app.zenhub.com/workspaces/gwas-59df823c4a6feb3786810391/issues/ebispot/gwasdepo-ingest-service/37

https://app.zenhub.com/workspaces/gwas-59df823c4a6feb3786810391/issues/ebispot/goci/847

sprintell avatar Sep 29 '22 16:09 sprintell

The submission status after importing shows 'CURATION COMPLETE' (http://gwas-snoopy.ebi.ac.uk:9780/gwas/curation/submissions/62e27657fd97600001675cec), but the imported studies are not seen in the curation app http://gwas-snoopy.ebi.ac.uk:9780/gwas/curation/publication/34375979

Santhi1901 avatar Oct 06 '22 12:10 Santhi1901

Just noting here I confirmed with @jdhayhurst the sumstats submission part is complete, sumstats are on staging already and no further work should be needed on the sumstats service to get the studies published: https://www.ebi.ac.uk/gwas/deposition/submission/62c592398a6cfa0001651079

ljwh2 avatar Oct 07 '22 13:10 ljwh2

The changes have been deployed in Prod as part of Scaling issue fix for Depo Sync , we will optimize further for AZ submission , identified few improvement areas

sajo-ebi avatar Jul 17 '23 09:07 sajo-ebi

@Santhi1901 tested re-import, still running after several days so likely this has failed

ljwh2 avatar Sep 21 '23 09:09 ljwh2