Parsing upgrade scripts... takes forever

KnickKnack

Hi Community,

it's the first time that upon restoring a nodeBB instance backup, at the start time I see this

Parsing upgrade scripts... 
OK | 23 script(s) found, 79 skipped
  → [2019/6/23] Create zsets for user posts per category...
....
    [              ] (600/58868) 1% 2021-05-27T06:50:45.408Z [4567/4322] - verbose: [plugins/fireHook] filter:post.getFields
...

It's important to state that I've not run an update from an old to a newer version of nodebb. It's actually just a full instance restore where i restored both the DB and the nodebb files.

Any clue why it's happening? Any clue to avoid it?

Cheers, R

<baris>

If the upgrades are taking forever, make sure you have the proper indexes on the collections.

KnickKnack

@baris How to verify that the indexes on the collection are there? The mongorestore showed no flaws during the restore

<baris>

Run > db.objects.getIndexes() and post the output

KnickKnack

@baris said in Parsing upgrade scripts... takes forever:

db.objects.getIndexes()

[ { "v" : 2, "key" : { "_id" : 1 }, "name" : "_id_" } ]

<baris>

Yeah so the indexes does not exist. You need to create them with.

db.objects.createIndex({ _key: 1, score: -1 }, { background: true });
db.objects.createIndex({ _key: 1, value: -1 }, { background: true, unique: true, sparse: true });
db.objects.createIndex({ expireAt: 1 }, { expireAfterSeconds: 0, background: true });

KnickKnack

@baris Thanks a lot! Have a great weekend!