You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@devlake.apache.org by "SxjAccount (via GitHub)" <gi...@apache.org> on 2024/09/03 03:11:55 UTC
[I] [Question][config-ui] devlake admin background suddenly prompts [New Migration Scripts Detected] [incubator-devlake]
SxjAccount opened a new issue, #7992:
URL: https://github.com/apache/incubator-devlake/issues/7992
## Question
devlake has been in use for some time
devlake admin background suddenly prompts [New Migration Scripts Detected]
## Screenshots
## Additional context
After using Devlake for a while, it was able to enter the page normally before. Today, it suddenly appeared with 'New Migration Scripts Detected'. What is the reason for the appearance of 'New Migration Scripts Detected'. I have added some tables and data to the database generated by devlake. Will clicking on 'Proceed to Database Migration' on the screen cause changes to these tables and data?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@devlake.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Question][config-ui] devlake admin background suddenly prompts [New Migration Scripts Detected] [incubator-devlake]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #7992:
URL: https://github.com/apache/incubator-devlake/issues/7992#issuecomment-2484448448
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.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Question][config-ui] devlake admin background suddenly prompts [New Migration Scripts Detected] [incubator-devlake]
Posted by "SxjAccount (via GitHub)" <gi...@apache.org>.
SxjAccount commented on issue #7992:
URL: https://github.com/apache/incubator-devlake/issues/7992#issuecomment-2325673555
> How about other tables? any record? Seems like the database is corrupted. 😂
Do you know how the above situation came about? I didn't do anything with the server where devlake was installed, just set up an automatic shutdown.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Question][config-ui] devlake admin background suddenly prompts [New Migration Scripts Detected] [incubator-devlake]
Posted by "klesh (via GitHub)" <gi...@apache.org>.
klesh commented on issue #7992:
URL: https://github.com/apache/incubator-devlake/issues/7992#issuecomment-2325685938
No idea, it is likely caused by your server setup.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Question][config-ui] devlake admin background suddenly prompts [New Migration Scripts Detected] [incubator-devlake]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #7992:
URL: https://github.com/apache/incubator-devlake/issues/7992#issuecomment-2614654385
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.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Question][config-ui] devlake admin background suddenly prompts [New Migration Scripts Detected] [incubator-devlake]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed issue #7992: [Question][config-ui] devlake admin background suddenly prompts [New Migration Scripts Detected]
URL: https://github.com/apache/incubator-devlake/issues/7992
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Question][config-ui] devlake admin background suddenly prompts [New Migration Scripts Detected] [incubator-devlake]
Posted by "klesh (via GitHub)" <gi...@apache.org>.
klesh commented on issue #7992:
URL: https://github.com/apache/incubator-devlake/issues/7992#issuecomment-2325666484
How about other tables? any record?
Seems like the database is corrupted. 😂
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Question][config-ui] devlake admin background suddenly prompts [New Migration Scripts Detected] [incubator-devlake]
Posted by "klesh (via GitHub)" <gi...@apache.org>.
klesh commented on issue #7992:
URL: https://github.com/apache/incubator-devlake/issues/7992#issuecomment-2328004522
Try removing the automatic shutdown.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Question][config-ui] devlake admin background suddenly prompts [New Migration Scripts Detected] [incubator-devlake]
Posted by "d4x1 (via GitHub)" <gi...@apache.org>.
d4x1 commented on issue #7992:
URL: https://github.com/apache/incubator-devlake/issues/7992#issuecomment-2359948293
> > The screenshot indicates an uptime of 4 hours, suggesting a recent restart. Have you made any changes to the database during this time? Perhaps modified records in the _devlake_migration_history table?
>
> My computer is set to turn on at 8 am and turn off at 6 PM every day.  That's my database up there, and now all of a sudden it's not working.
@SxjAccount From your screenshot, lots of records have gone in table `_devlake_migration_history`. I think it's the root cause. You can try to find why records are missing.
I am not an expert on MySQL but here are some possible reasons:
1. There are many records but your db tool shows some of them only.
2. They are deleted by yourself/ some cronjobs/other people.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Question][config-ui] devlake admin background suddenly prompts [New Migration Scripts Detected] [incubator-devlake]
Posted by "klesh (via GitHub)" <gi...@apache.org>.
klesh commented on issue #7992:
URL: https://github.com/apache/incubator-devlake/issues/7992#issuecomment-2325558805
The screenshot indicates an uptime of 4 hours, suggesting a recent restart. Have you made any changes to the database during this time? Perhaps modified records in the _devlake_migration_history table?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Question][config-ui] devlake admin background suddenly prompts [New Migration Scripts Detected] [incubator-devlake]
Posted by "SxjAccount (via GitHub)" <gi...@apache.org>.
SxjAccount commented on issue #7992:
URL: https://github.com/apache/incubator-devlake/issues/7992#issuecomment-2328013498
> Try removing the automatic shutdown.
I deployed and set up EC2 automatic power on/off on AWS, but this situation suddenly occurred. I would like to observe the situation further and see if it is necessary to disable the automatic power on/off function
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Question][config-ui] devlake admin background suddenly prompts [New Migration Scripts Detected] [incubator-devlake]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
dosubot[bot] commented on issue #7992:
URL: https://github.com/apache/incubator-devlake/issues/7992#issuecomment-2325531002
<!-- Greeting -->
Hey @SxjAccount! I'm here to help you with any issues or questions you have regarding the repository. I can assist with bugs, answer questions, and help you become a contributor.
<!-- Answer -->
I found a similar closed issue where a user encountered a problem with launching DevLake. The issue was resolved by ensuring the database was empty and redoing the installation from scratch <sup>[[1]](https://github.com/apache/incubator-devlake/issues/6440)</sup>.
The "New Migration Scripts Detected" notification appears because DevLake has identified new migration scripts that need to be executed to update the database schema. Clicking "Proceed to Database Migration" will execute these migration scripts. The migration process involves checking the `migration_history` table, sorting the scripts by `Version` and `Name`, executing them, and saving the results in the `migration_history` table <sup>[[2]](https://github.com/apache/incubator-devlake-website/blob/main/docs/DeveloperManuals/DBMigration.md)</sup>.
Regarding the impact on custom tables and data you have added to the database, the migration scripts are designed to modify the database schema as defined by the scripts. If your custom tables and data are not referenced or affected by these scripts, they should remain unaffected. However, if the migration scripts include changes that impact your custom tables or data, those changes will be applied. To ensure your custom tables and data are not affected, you should review the migration scripts before proceeding <sup>[[2]](https://github.com/apache/incubator-devlake-website/blob/main/docs/DeveloperManuals/DBMigration.md)</sup>.
For more detailed examples and best practices, you can refer to the [DevLake migration documentation](https://github.com/apache/incubator-devlake/blob/main/backend/core/models/migrationscripts) <sup>[[2]](https://github.com/apache/incubator-devlake-website/blob/main/docs/DeveloperManuals/DBMigration.md)</sup>.
<!-- Dosu Comment Footer -->
*To continue talking to [Dosu](https://dosu.dev), mention @dosu.*
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Question][config-ui] devlake admin background suddenly prompts [New Migration Scripts Detected] [incubator-devlake]
Posted by "SxjAccount (via GitHub)" <gi...@apache.org>.
SxjAccount commented on issue #7992:
URL: https://github.com/apache/incubator-devlake/issues/7992#issuecomment-2325563393
> The screenshot indicates an uptime of 4 hours, suggesting a recent restart. Have you made any changes to the database during this time? Perhaps modified records in the _devlake_migration_history table?
My computer is set to turn on at 8 am and turn off at 6 PM every day.
That's my database up there, and now all of a sudden it's not working.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Question][config-ui] devlake admin background suddenly prompts [New Migration Scripts Detected] [incubator-devlake]
Posted by "SxjAccount (via GitHub)" <gi...@apache.org>.
SxjAccount commented on issue #7992:
URL: https://github.com/apache/incubator-devlake/issues/7992#issuecomment-2325563627
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Question][config-ui] devlake admin background suddenly prompts [New Migration Scripts Detected] [incubator-devlake]
Posted by "klesh (via GitHub)" <gi...@apache.org>.
klesh commented on issue #7992:
URL: https://github.com/apache/incubator-devlake/issues/7992#issuecomment-2328028659
Absolutely! I'm genuinely curious about the outcome—please feel free to share it when you can. 🌟
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org