188BET靠谱吗clearing Zotero trash leads to loading error

YuDiamond

Dear developer,

I came across a problem that had been bothering me for a long time

188BET靠谱吗Starting from around Zotero 7 beta 32, after clearing the Zotero trash, and then clicking on any collection, the main panel will show "Loading items...".188BET靠谱吗Usually, it takes at least 15 minutes to display the items rightly, and this bug can be reproduced when I clear the Zotero trash.

188BET靠谱吗I'm not sure if this issue is caused by Zotero itself or any Zotero plugin.188BET靠谱吗However, even if I disable all the zotero plugins, the issue persists.Here is a Debug ID: D962557224

Looking forward to the solution.

Many thanks.

dstillman

Using data directory Z:\[…]

[JavaScript Error: "Transaction timeout, most likely caused by unresolved pending work." {file: "resource://gre/modules/Sqlite.jsm" line: 1036}]

What is Z:?188BET靠谱吗Do you have your Zotero data directory on something other than a local disk?

YuDiamond

@dstillmanZ:\[…] is a partition of an external portable hard drive.

dstillman

Are you saying this happens after clearing even a single item from the trash, or just a large number?

YuDiamond

even clear a single item from the trash, this error will happen.

dstillman

How many itemsare there in your library?

YuDiamond

over 20000 items.Is it because there are too many items?

dstillman

That's not really that many items.If you go to Tools → Developer → Run JavaScript and run the following line, what's the result?

188BET靠谱吗return await Zotero.DB.valueQueryAsync("SELECT COUNT(*) FROM itemData")

dstillman

Also this:

188BET靠谱吗return await Zotero.DB.valueQueryAsync("SELECT COUNT(*) FROM items")

YuDiamond

please wait a moment, just now, this error is being triggered.

YuDiamond

the result is:
===>71409<=== (number)

dstillman

For which?

YuDiamond

select "My library" and then go to Tools → Developer → Run JavaScript and run the following line

188BET靠谱吗return await Zotero.DB.valueQueryAsync("SELECT COUNT(*) FROM items")

the result is:
===>71409<=== (number)

dstillman

Right but I asked for two things.

YuDiamond

sorry, I made a mistake.

188BET靠谱吗For, return await Zotero.DB.valueQueryAsync("SELECT COUNT(*) FROM itemData")
the result is: ===>333882<=== (number)


188BET靠谱吗For, return await Zotero.DB.valueQueryAsync("SELECT COUNT(*) FROM items")
the result is: ===>71408<=== (number)

dstillman

If you run this, what does it show?

var t = new Date;
188BET靠谱吗await Zotero.DB.queryAsync("DELETE FROM itemDataValues WHERE valueID NOT IN (SELECT valueID FROM itemData)");
return new Date - t;

YuDiamond

For,

var t = new Date;
188BET靠谱吗await Zotero.DB.queryAsync("DELETE FROM itemDataValues WHERE valueID NOT IN (SELECT valueID FROM itemData)");
return new Date - t;

the result is: ===>2059266<=== (number)

dstillman

Yeah, that's bizarrely slow.

188BET靠谱吗How big is your zotero.sqlite file?

188BET靠谱吗Can you try moving your Zotero data directory back to the default location on the internal disk, pointing Zotero there, and trying again with that?

YuDiamond

188BET靠谱吗My zotero.sqlite is about 2.70GB


1.188BET靠谱吗I remember it was that time I installed a new version of a zotero plugin, then when I started Zotero and deleted a lot of RSS feeds in zotero, Zotero got stuck during the deletion process.188BET靠谱吗After that, I forced Zotero to start, and then this problem kept occurring.
2.188BET靠谱吗Later, I used a method to repair the Zotero library file (zotero.sqlite) (see [Manual Zotero Database Repair Instructions]( 188BET靠谱吗//www.brodersterzo.com/utils/dbfix/manual) ), but the problem still existed.
3.I then tried deleting all the RSS feeds, but still faced the same problem.
4.I initially thought it might be caused by some plugin corrupting the data, but even after disabling all the plugins, the problem persisted.

I'm not sure if these above information can be helpful to you, but I think I need to tell you.



188BET靠谱吗maybe I can have a try to moving my Zotero data directory back to the default location on the internal disk.
but I don't think it will be better, because I had already use this outer disk before this problem happened first time.

I will tell you latter.

thanks.

YuDiamond

amazing,

188BET靠谱吗after moving my Zotero data directory back to the default location on the internal disk, this problem disappeared.

then, I try use on the outer disk, This problem is also gone, that seems so bizarre.

and now, on the outer disk, when I run this

var t = new Date;
188BET靠谱吗await Zotero.DB.queryAsync("DELETE FROM itemDataValues WHERE valueID NOT IN (SELECT valueID FROM itemData)");
return new Date - t;

the result is

===>232<=== (number)

I don't know what happened, but everything seems to go well.

thanks very very much.

I'll be watching to see if it runs correctly in the future.