Missing Database Record

Hi there. Has anyone of you had an instance of missing database record in one of your apps?

In one of my apps, I have an app that has 250 instances of missing record/deleted record in the database. (This thing has around hundred thousands of records) However, I am sure that this is not done in my end, nor in any of my workflows. The bubble support confirmed this in their logs. They cannot find any instance in the app logs, nor in bubble logs itself, that the data had been deleted. This is their engineering response word by word after 3 days of investigation.

Thank you for the follow-up!

I’ve just received an update from the Engineering Team in regards to their investigation. After thoroughly checking out the logs and operations that ran in your app, it seems they were unable to find an instance of this record being removed from the database. They’ve assured me that this was not performed from our end and there are no logs to indicate any deletions within Bubble itself. That being said, the Engineering Team believes that this is unlikely to occur again. I apologize for the limited information here, and while we’re confident that this shouldn’t happen again, if it were to, please let us know so we can investigate immediately.

Thank you for your understanding and have a wonderful rest of your day!

Any opinion about this? Any possible reasons why it did occur? Has this happened to any of you?

Hi guys. Did any of you observed similar behavior?

It seems that the unique id of deleted things are still intact in other data table that is linked but the details cannot be located and appears deleted.

Is this somewhat related?

How can you determine if you have poorly-optimized queries? Also, how do you determine if query cancellation can have a huge impact on a page or workflow?

I have an open bug report that already exists for weeks now without proper solution yet and thinking if this is connected to this one.

In one of my apps, I have a bug where client/server side is not communicating properly resulting to missing records. Scenario is given below:

  • We have Data Types “Company” and “Transaction”, where “Transaction” has a field that references to “Company”.
  • The app is a SPA (Single Page App), so no page refresh is needed most of the time. I have two separate workflows:
  1. Workflow that Creates a New Company
  2. Workflow that Creates a New Transaction for a particular Company
  • Technically speaking, you cannot create a New Transaction without the Linked Company.
  • However, upon checking my “Transactions” Data (about ~500,000 records in live database), there are 250 of them where the field “linked_company” is marked as “(deleted thing)”, but no company has been deleted, nor in my logs, nor in bubble logs as confirmed by the bubble support.
  • Upon checking, this is marked as “(deleted thing)” but when opening the record thru Data Tab in editor, there is linked unique id for that “linked_company” field but cannot be found in the database.
  • My observation in the app, and one aspect that bubble support is looking at is the possibility of sometimes having a mismatch with client-side and server-side process.
  • They say that the client-side thinks that the “New Company” has been created, wherein the server-side had trouble creating that record and failed.
  • Now the Server doesn’t have that record but the client-side thinks that this was created properly.
  • So when you create a Transaction that is linked to that Company, in client side, it proceeds to create a new transaction thinking there is the newly created company with its unique id that used as reference. The server side proceeds to create that transaction, linking the unique id generated in client-side, but now cannot find that unique id, creating a “(deleted thing)” tag in the data tab.

Upon checking in the database, there are 250 occurrences of this bug coming randomly from December 2022 up to present.

Bubble support is taking too long for investigation, and hopefully this can shed some light on what is happening in this bug.

Sending to the team :+1:

It seems no one is concerned about this issue.

The official Bubble forum moderator forwarded your request to the Bubble team to check out; I’m not sure what you mean by this:

Yes you probably can, if the privacy rules prevent the new Company from being visible that could result in Step 2 being empty.

This should not be the case in my app. The workflow that generates New Transaction in my app can only be triggered when there is a Company attached.

I’m not sure why there is a client/server side mismatch. The client side assumes that the “company” is created in server side, however, server side did not actually create the “company”. So in client side, there is actually a “company” with its unique but not in server.

Then there is a popup to create “transaction” where data source is the recently created “company”. So when they create a transaction, it is registering the unique id from the client side on that instance. But when they refresh the page, now the client side company is gone.