| Issue Number | 718 |
|---|---|
| Summary | Full history display for article 730646 crashes |
| Created | 2023-01-30 15:59:30 |
| Issue Type | Bug |
| Submitted By | Kline, Bob (NIH/NCI) [C] |
| Assigned To | Kline, Bob (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2023-01-31 08:10:14 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/oceebms/issue.337566 |
The Apache logs say that PHP memory is exhausted. Interestingly, this is one of the records involved in the duplicate PMID pairs reported by OCEEBMS-717. Happens on https://ebms.rksystems.com as well as https://ebms4-dev.nci.nih.gov.
Article 730646 is one of the six duplicate pairs, sharing PMID 31749144 with article 730647 (see OCEEBMS-717). The original EBMS didn't anticipate such duplicates, so the refresh code only found one of the articles in the pair when it retrieved updated XML from PubMed. But each time the refresh job ran, it noticed that the other article of the pair needed to be refreshed, so it pulled down the XML again, but only refreshed the first article. So at the time the problem was noticed, article 730646 had 1,031 import refresh jobs associated with it, and the attempt to load the Batch entities for all of those jobs caused the PHP interpreter to run out of memory. So I have switched this entity query API code to use the Drupal Database API instead. https://ebms.rksystems.com/articles/730646 works now (still crashes on ebms4-dev, to which the fix will be deployed later).
This article is found with no problem on ebms4 so this seems to be fixed.
Verified on PROD. (Article found with no problems.)
Elapsed: 0:00:00.000848