[Bug][Refresh] Unable to delete data and collect again

[pamflores-clip]

Search before asking

• [X] I had searched in the issues and found no similar issues.

What happened

I have a record in the DB that is not correctly updated. In github, this ticket has an updated date of september:

and in the DB the updated date is in march:

What do you expect to happen

I was searching for a way to delete all of the data that is in a project without deleting the actual project

How to reproduce

I have already tried the Collect Data in Full Refresh Mode but still is not updated in DB

Anything else

We updated our devlake version in August

Version

v1.0.1-beta7@3f84bae

Are you willing to submit PR?

• [ ] Yes I am willing to submit a PR!

Code of Conduct

• [X] I agree to follow this project's Code of Conduct

[dosubot[bot]]

Hello @pamflores-clip! I'm here to assist you with any bugs, questions, or contributions you may have. Let's work together to resolve your issue.

To delete all data in a project without deleting the actual project, you can use the "Collect Data in Full Refresh Mode." This mode will delete all existing data within the designated time range and re-collect it. Here are the steps:

1. Go to the Config UI at http://localhost:4000.
2. Navigate to the project you want to refresh.
3. Set the synchronization policy to "Collect Data in Full Refresh Mode."
4. Start the data collection process.

This should remove the outdated or incorrect data and re-collect it from the original tools ^[1].

If you have already tried this and the data is still not updated, there might be an issue with the specific version you are using (v1.0.1-beta7@3f84bae). Unfortunately, I couldn't find any known issues or bugs related to the 'Collect Data in Full Refresh Mode' for this version ^[2].

As a workaround, you can manually delete specific records from the database using the Delete method provided by the Dal interface. Here are the steps:

1. Identify the Record: Determine the specific record you want to delete. This usually involves knowing the primary key or a unique identifier for the record.
2. Create an Entity Instance: Create an instance of the entity that represents the record you want to delete. Populate it with the necessary identifying information.
3. Call the Delete Method: Use the Delete method from the Dal interface to delete the record.

Example Code

// Assuming you have a User model and you want to delete a user with a specific email
user := &models.User{
  Email: "[email protected]",  // assuming this is the Primary key
}

err := db.Delete(user)
if err != nil {
  // handle error
}

Precautions to Take

1. Backup Data: Always ensure you have a backup of your data before performing delete operations.
2. Verify Identifiers: Double-check the identifiers to ensure you are deleting the correct record.
3. Test in a Safe Environment: If possible, test the delete operation in a staging or development environment before executing it in production.
4. Error Handling: Implement proper error handling to catch and log any issues that occur during the delete operation.
5. Transaction Management: If the delete operation is part of a larger set of database operations, consider using transactions to ensure atomicity and consistency ^[3].

By following these steps and precautions, you can safely and effectively delete specific records from the database without using the UI.

To continue talking to Dosu, mention @dosu.

[Startrekzky]

@pamflores-clip , thanks for reporting. We'll look at it.

[xiaomingzhang12]

Hi @pamflores-clip , In the database, the update_date field represents when the data itself was last updated, while the update_at field indicates when it was updated in the database. Could you check if the update_at field shows the time you were expecting? Thank you

[pamflores-clip]

Hi @xiaomingzhang12 , sorry maybe I wrote this incorrectly or is misleading I have confirmed that the updated_at corresponds to the time when the issue was closed:

The thing is that the status is not changing or not reflecting the Closed status that is seen in Git's UI and searching in the columns returned by a " select * from lake.issues where url like '%/xxxx' " sentence, I cannot see anywhere a Closed or Completed status. Is there another column or table I should be searching on? Or, is this a real data sync issue?

[github-actions[bot]]

This issue has been automatically marked as stale because it has been inactive for 60 days. It will be closed in next 7 days if no further activity occurs.

[github-actions[bot]]

This issue has been closed because it has been inactive for a long time. You can reopen it if you encounter the similar problem in the future.