Due numbers depend on all of your collection I think. You can reposition all of your cards to fix that.
I think a long time ago I was also told to do a Check > Check database from the kebab menu. In any case, this isn’t necessarily a problem.
Search is:new -is:suspended, see if it works now.
Yes, Reposition is an edit action for each card, so using it on 32K+ cards would be quite taxing on the system.
Due numbers only matter relative to each other, so there isn’t an issue with having gaps in your New-queue.
If your goal here is to adjust your “bottom of queue” number so your new cards don’t get these absurdly high numbers [I’m guessing, because you still really haven’t said what help you’re looking for], you first need to use Reposition, but only on these very high numbered cards. Search for prop:pos>1000000 -is:suspended – is that a more reasonably sized set of cards?
You should reposition them to available New-queue numbers (because there’s no need to move any other cards for this, and AnkiDroid will always shift other cards on Reposition). From your screenshots, starting at 68600 looks like it would be clear, but I can’t tell if any of those are your full queue/collection.
Then after you reposition the cards, you can run Tools > Check Database to adjust the bottom of queue number.
For the future, this can happen whenever you import a shared deck that has high New #s, so keep an eye out for that.
Maybe put the wrong number there. But it’s not even a problem so you shouldn’t worry about it IMHO.
Did you already reposition those cards? What about without the “-is:suspended”? Try the next highest set of queue numbers from your screenshots – prop:pos>68000. Or just look at your is:new results again, and sort by the Due column to see where your largest numbers are. If you’re satisfied with that, then Check Database is the last step.
Oh, wait, when I checked with a test card, the floor is at a reasonable number now! Maybe check database finally fixed it?
Even though… I already did it before?
Yes, Check Database adjusts the bottom of the queue to the largest queue number. That’s why you need to Reposition those cards first and then run Check Database.





