Debugg ID: 1345151247. Sync, Connector and Zotero completely useless in general

NoeliaDF

Debugg ID 1345151247

Hi, guys! This is the debugging ID in case anyone can take a look.

I'm having two main issues:
- The Connector is not saving papers. I'm working in PubMed and as soon as I open the article, the logo shows correctly but then it change to white and it gives me a warning related to translation issues: I've followed the recommendations of that page and nothing seems to work.

- The library is not properly working and it take ages to charge, if it finally charges without giving any alert, but I cannot access papers by collection.

- Finally, I've been cleaning feeds, but still, I cannot understand this option if it cannot handle high volumes of content and as a consequence, the library is not working.

I've uninstall and reinstall both the app and the Connector. I've also uninstall the app from my other computers. And I've eliminated all the plugins too.

Over the last few months, I came under a lot of problems with Zotero. I'm under the impression that it doesn't work as good as it used to be. I'm writing my dissertation and at this point I cannot handle bugs every single day. Is anyone having this same feeling? Any thought?

NoeliaDF

Please, can anyone take a look to my report? Yesterday, I added three feeds from authors's lists in PubMed and it has crashed again. I cannot either eliminate them neither add new ones. And as a consequence the library is not working.

I'm totally desperate with this issue because it has completely disrupted all my schedule.

dstillman

(4)(+0000492): DELETE FROM creators WHERE creatorID NOT IN (SELECT creatorID FROM itemCreators)

Can you go to Tools → Developer → Run JavaScript, run the following code, and let us know the output for each?

return await Zotero.DB.valueQueryAsync('SELECT COUNT(*) FROM feeds')
+ " " + await Zotero.DB.valueQueryAsync('SELECT COUNT(*) FROM creators')
+ ' ' + await Zotero.DB.valueQueryAsync('SELECT COUNT(*) FROM itemCreators JOIN items USING (itemID) JOIN libraries USING (libraryID) WHERE type!="feed"')
+ ' ' + await Zotero.DB.valueQueryAsync('SELECT COUNT(*) FROM itemCreators JOIN items USING (itemID) JOIN libraries USING (libraryID) WHERE type="feed"')
+ ' ' + await Zotero.DB.valueQueryAsync('SELECT COUNT(*) FROM items JOIN libraries USING (libraryID) WHERE type!="feed"')
+ " " + await Zotero.DB.valueQueryAsync('SELECT COUNT(*) FROM items JOIN libraries USING (libraryID) WHERE type="feed"')

But the answer here is likely still going to be that you've added a huge number of feeds to Zotero, well beyond what we've ever tested or what the vast majority of people are using, and the current design of that feature just isn't going to work well with those sorts of numbers.

For now, if you restart Zotero and just let it go for a while (e.g., when you're going to be away from your computer for multiple hours), it might finish the cleanup process it's doing at startup and start working normally. But if huge numbers of feed items are being added and removed each day, you may run into this again soon. Restarting Zotero more frequently (after feed updates or after deleting a bunch of feeds) may also help.

NoeliaDF

Thank you for all the information!

I'm working at this moment, so tonight or tomorrow I'll try again to give it more time as you suggest.

If it can be interesting for you:

- I initially added around 700 feeds and I had a warning so I couldn't sync.

- I made a selection and I reduce them to less than 400 and started working after several attempts.

- I was in the process of cleaning to reduce the number to avoid lagging issues, so I added a RSS that I created from certain author's bibliography from PubMed and it started again to give problems. I've already experienced this. So I don't know if it has something to do on top of everything else, but it happens when I add feeds created from the Advanced feature in PubMed. I read in the forum that someone had troubles with this several years ago.

Do you have any feed number that I should stick to? Which amount of feeds should be adecuate for Zotero running without issues?

I'll share the output as soon as I can.

Thank you again and have a nice end of the day!

NoeliaDF

Hi again!

The output I got is 372 355560 26738 207296 10339 24269

Can I use the code you share to eliminate the feeds I've created for specific authors in PubMed? Or is there a way to force to unsuscribe to a feed?

I've didn't touch the computer for two days and still, couldn't eliminate those feeds using the unsuscribe feature.

Thank you so much for your help! Have a wonderful day!

dstillman

OK, please try the latest Zotero beta. In theory that should dramatically speed up the cleanup operation that's taking so long for you at startup.

NoeliaDF

I already did that and I could delete some feeds,so it's now working again. I'll keep cleaning some feeds and let you know the top number I find it fluently works with.

Thank you again for your time and dedication.

Kind regards from Spain!