My schemes are gone, what to do?

themisterbondy · March 26, 2019, 5:19pm

I logged in and it did not log, I tried to use via api and nothing, when I opened the mongo compose to see the schemas he was not there, what to do?

Sebastian · March 26, 2019, 5:27pm

I have no idea how this could happen as Squidex never deletes data. There is not even a delete method.^

But as long as the events are still there everything can be restored. We just need a method for it.

themisterbondy · March 26, 2019, 5:30pm

Is there any way to recover this data?

Sebastian · March 26, 2019, 5:53pm

I added a commit with a rebuilder, where you can rebuild the content based on the schemas:

You can enable it in the settings:

github.com

Squidex/squidex/blob/master/src/Squidex/appsettings.json#L346


   * The name of the event store database.
   */
  "database": "Squidex"
},
"getEventStore": {
  /*
   * The connection string to your EventStore.
   * 
   * Read Mode: http://docs.geteventstore.com/dotnet-api/4.0.0/connecting-to-a-server/
   */
  "configuration": "ConnectTo=tcp://admin:changeit@localhost:1113; HeartBeatTimeout=500; MaxReconnections=-1",
  /*
   * The host name of your EventStore where projection requests will be sent to.
   */
  "projectionHost": "localhost",
  /*
   * Prefix for all streams and projections (for multiple installations).
   */
  "prefix": "squidex"
},
"cosmosDb": {

See the full commit here:

You can enable it with environment variable: REBUILD__SCHEMAS=true

or you can just run it with dotnet run --Rebuild:Schemas=true (I think)

You can read more about it here:

themisterbondy · March 26, 2019, 10:10pm

Even doing what you gave me can not retrieve the schemas / data, any other suggestions?

Sebastian · March 26, 2019, 10:26pm

You can export your database and send it over to me me, so that I can debug through it and have a look.

themisterbondy · March 26, 2019, 10:36pm

I’ve remade the compose again!

Sebastian · March 27, 2019, 9:15am

And it solved the problem?

themisterbondy · March 27, 2019, 10:57am

No, this is very strange!

Sebastian · March 27, 2019, 11:02am

As I said: Send me your backup and I can have a look. Otherwise it is like a blackbox for me.

themisterbondy · March 27, 2019, 1:07pm

Can I pass you the connection string?

Sebastian · March 27, 2019, 1:29pm

If your mongodb is available from the outside, sure

themisterbondy · March 27, 2019, 2:04pm

Follow the connection string
https://send.firefox.com/download/ded3fb2439da4045/#_LbAQLJOYryMulBMPe27Lw
Password download: DELETED

Sebastian · March 27, 2019, 2:31pm

Thx, please send it as PM the next time

Sebastian · March 27, 2019, 2:34pm

It looks like the whole database has been recreated. I don’t know what has happened but this is basically an empty database + 1 user. There is nothing I can do for you.

themisterbondy · March 27, 2019, 2:35pm

No problem, thanks for the help!

Sebastian · March 27, 2019, 2:40pm

You are welcome. I am 100% sure, that is not Squidex. Because there is nothing that deletes users or events from the database. The whole concept of Squidex is to never delete data.

obivandamme · June 19, 2019, 8:42am

Hey @Sebastian,
I am experiencing the same issue. It looks like after I restart my Docker Container something recreated the Database. I can remember to read something about recreating the Mongo Db on the configured folder even if it is not empty.

Sebastian · June 19, 2019, 8:53am

I am 100% sure that Squidex does not recreate any databases. Do you have a persistence volume for your database?

obivandamme · June 19, 2019, 9:41am

I mapped an szure storage account as described in my Azure Setup Documentation. For some reason they are all empty. It looks like the MongoDb container does not use it to persist the data.