Restore mongodb backup error

I have…

  • Read the following guideline: Troubleshooting and Support | Squidex. I understand that my support request might get deleted if I do not follow the guideline.
  • Used code blocks with ``` to format my code examples like JSON or logs properly.

I’m submitting a…

  • Regression (a behavior that stopped working in a new release)
  • Bug report
  • Performance issue
  • Documentation issue or request

Current behavior

When I tried to restore it from MongoDB Backup, I got an error like

restore indexes: createIndexes for CMS.TextIndex2: (CannotCreateIndex) Error     in specification { key: { a: 1, _fts: "text", _ftsx: 1 }, name:     "a_1_t.t_text", v: 2 } :: caused by :: text index option 'weights' must     specify fields or the wildcard

MongoDB version 8.0.4.1

I checked the index.

db.TextIndex2.createIndex(
    {
        a: 1,
        _fts: "text",
        _ftsx: 1
    },
    {
        name: "a_1_t.t_text",
        weights: {
            "t.t": 1
        },
        default_language: "english",
        language_override: "language",
        textIndexVersion: 3
    }
);

The collection is like

// collection: CMS.TextIndex2
{
	"_id" : ObjectId("67f92467221e20f6c228c633"),
	"a" : "f63a6648-6502-4b5f-855b-7d0af97c1f19",
	"c" : "951eeac1-26d9-4840-88f4-e600ab010a59",
	"x" : 0,
	"e" : true,
	"p" : true,
	"s" : "951eeac1-26d9-4840-88f4-e600ab010a59",
	"t" : null
}

I think because there is no t.t, so it complains.

If I drop the index and create a backup, it works.

Thanks for looking into it.

Expected behavior

Minimal reproduction of the problem

Environment

App Name:

  • Self hosted with docker
  • Self hosted with IIS
  • Self hosted with other version
  • Cloud version

Version: 7.18.0

Browser:

  • Chrome (desktop)
  • Chrome (Android)
  • Chrome (iOS)
  • Firefox
  • Safari (desktop)
  • Safari (iOS)
  • IE
  • Edge

Others:

This is not a Squidex problem. Not going to help here. But Squidex creates the index anyway, so your workaround is fine.

Sorry, I am confused. I thought Squidex creates this index? Does this index work as expected?

Initially yes, but why the index could not be restored, I can’t answer, because I don’t know. Perhaps an incompatibility between mongo versions.

1 Like

Thanks. I understand now.