Sorry Tim, I think I caused a bit of confusion here. I will, from now on, only answer on dspace-tech.
I added a ticket: https://github.com/DSpace/DSpace/issues/9053 I also added a postgresql log file, after the longer rest api call I mentioned earlier. Att, Aroldo Em qua., 6 de set. de 2023 às 14:54, DSpace Community < dspace-commun...@googlegroups.com> escreveu: > Hi Aroldo, > > (This has gotten slightly confusing as we are now talking on > dspace-community when I initially responded on dspace-tech. I'd appreciate > it if we can keep this discussion to one list.) > > Could you check your logs for any additional clues? It'd be really > helpful to check to see if Solr or dspace.log (or similar) are providing > any other hints on what might be going on. > > Essentially, I'm looking for clues that other developers could use to try > to reproduce your setup. It's excellent that you've narrowed down the REST > API call... but if we can find more clues about what might be going on in > your logs when that REST API call occurs, that can really help us determine > where to look in our codebase for possible issues. > > It's still very possible that this is related to the other issue that I > mentioned on dspace-tech: https://github.com/DSpace/DSpace/issues/9052. > There are permissions checks going on here behind the scenes, and I wonder > if something there is acting slowly. So, based on what you've said so far, > it's very difficult to say if the 100 workflow items is the real cause or > if it's more related to how your Groups/EPersons are configured. If we can > find any other clues, that'd be really helpful. > > If it's easier for you to simply add all that you can find into a Ticket ( > https://github.com/DSpace/DSpace/issues), that's OK with me. I just need > as many clues as you can gather so that we can find a volunteer to > reproduce the issue & investigate what may be occurring. > > Thanks! > > Tim > > On Wednesday, September 6, 2023 at 12:19:07 PM UTC-5 aro...@gmail.com > wrote: > >> Hi Tim, thanks for the reply. >> >> The 2 rest calls that take the most time are these: >> >> Workflow task page (mais problem): >> >> server/api/discover/search/objects?sort=score,DESC&page=0&size=10&configuration=workflow&embed=thumbnail&embed=item%2Fthumbnail >> >> We have a team of 14 submitters who can submit new items in any of the >> 270 collections. We also have another team of 10 editors, who can accept or >> reject submitted items in all collections. When we had 100 items submitted >> in the queue for editing, the above rest call took 2 minutes to complete. >> >> Deposit a new item (the delay here doesn't bother you that much): >> server/api/workflow/workflowitems?projection=full >> >> Att, >> >> Aroldo >> >> Em qua., 6 de set. de 2023 às 13:27, DSpace Community < >> dspace-c...@googlegroups.com> escreveu: >> >>> This discussion is taking place on the dspace-tech list. Please try to >>> keep your emails to a single list if at all possible. Cross-posting to all >>> lists can make it difficult for others to locate the answer in the future. >>> >>> https://groups.google.com/g/dspace-tech/c/Me5TNlKcTEk >>> >>> On Tuesday, September 5, 2023 at 4:39:20 PM UTC-5 aro...@gmail.com >>> wrote: >>> >>>> We are back to Dspace 6 until we resolve the issues. >>>> >>>> Em sex., 1 de set. de 2023 às 14:58, Aroldo Rique Júnior < >>>> aro...@gmail.com> escreveu: >>>> >>>>> Hello everybody >>>>> Our >>>>> Workflow tasks page is taking a long time to load, over a minute. >>>>> Something similar also happens on the new item submission page. >>>>> >>>>> [image: image.png] >>>>> >>>>> >>>>> >>>>> >>>>> [image: image.png] >>>>> >>>>> My mpf-ui.json: >>>>> { >>>>> "apps": [ >>>>> { >>>>> "name": "mpf-ui", >>>>> "cwd": "/dspace/mpf-ui/", >>>>> "script": "dist/server/main.js", >>>>> "instances": "-1", >>>>> "exec_mode": "cluster", >>>>> "node_args": "--max_old_space_size=2048", >>>>> "env": { >>>>> "NODE_ENV": "production" >>>>> } >>>>> } >>>>> ] >>>>> } >>>>> >>>>> We currently have over 150,000 items, spread across 270 collections, >>>>> spread across various communities and subcommunities. >>>>> >>>>> We created 3 groups of people, a group of Administrators, another one >>>>> of Submitters and another one of Editors. These 3 groups are >>>>> administrators, submitters and editors of all collections. >>>>> >>>>> [image: image.png] >>>>> [image: image.png] >>>>> >>>>> We've already increased the memory of Solr, Tomcat and the machine >>>>> (SLES 15), but the slowness (and user complaints) continues... >>>>> >>>>> Att, >>>>> >>>>> Aroldo Rique >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> -- >>> All messages to this mailing list should adhere to the Code of Conduct: >>> https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "DSpace Community" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to dspace-communi...@googlegroups.com. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/dspace-community/12fa82fd-1ba9-4c75-b4d8-c6f7b2600b61n%40googlegroups.com >>> <https://groups.google.com/d/msgid/dspace-community/12fa82fd-1ba9-4c75-b4d8-c6f7b2600b61n%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- > All messages to this mailing list should adhere to the Code of Conduct: > https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx > --- > You received this message because you are subscribed to the Google Groups > "DSpace Community" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to dspace-community+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/dspace-community/888d6994-4493-4e08-ab49-7333a2b143c1n%40googlegroups.com > <https://groups.google.com/d/msgid/dspace-community/888d6994-4493-4e08-ab49-7333a2b143c1n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/CACKFi%2BdypQwe2U1KnKhNL7r6j-HnzWZGdE%3DDgt5KmQ8VhgTHew%40mail.gmail.com.
