Why does Base keep freezing then corrupting the DB when editing?
As a user of LibreOffice Base, I am fed up with the constant freezing of the application during editing. This has been a problem in Base since LibreOffice first began. I did not have this issue with Open Office. Because of this I simply cannot build my Database to the level I want because as I edit it, it freezes and never releases. This causes a force quit and upon restart, a message is posted saying the app needs to be recovered. Most of the time, this fails as Writer comes up and another post indicatng the file is corrupted or there is no path to the source. This means restart from the beginning. I have done this many times thinking that the LO team will find and fix this issue or post information as to why it occurs and how to fix or prevent it. I have tried other computers as well as other forms and techniques to solve the issue with no avail. I am so frustrated, yet I do not see more people ranting about this. I cannot be the only one facing this. If anyone knows the remedy please share.
Can you narrow your problem down with respect to what you are doing when Base freezes? If so, your problem may be a good candidate for a bug report.
The first step in solving a bug report is to reproduce the bad behavior. This will probably require the database you are using. Can you share your database with the world?
Thank you Terrence for your quick response. The only reference I can give you is that the freeze is random. Sometimes, I can edit for hours with no problem. Other times it can be as little as thirty minutes. I can sometimes sense it failing as the time to save or click out of an edit begins to slow down dramatically. If at that point I can save my work and click out of edit, then save and completely exit form Base and LO, the freeze is prevented. I can then reopen Base and continue editing.
If I fail to do this, the system halts with no response. All attempts to log out or exit from edit fail and I eventually get the error message of system is failing to respond which causes me to force quit. Sometimes recovery works but most times I just get a corrupted file. Finally, this DB is only important to me and can be shared if needed.