Base+HSQLDB: Closing a table, LO crashed.

After viewing the last record,

I closed the table.

LO crashed.

image description

Database is not big.

image description

CPU or RAM has no problem for I could use other applications while LO was crashing.

This case is the first time for me.

After waiting so long, I clicked Terminate Application libreoffice-base.

And I’ve got a gift, .odb.lck .

image description

What should be done next ?

| Fedora 31 Workstation KDE Desktop Spins | LibreOffice |


After LO recovered, last 105 records previously saved had gone and odb.lck disappeared.

Unfortunately there is probably little that can be done. HSQLDB embedded has a history of problems (not everyday occurrences though) and just another reason to replace with Firebird embedded. It is not advised to use in a production environment.

You could report as a bug but you need to be able to duplicate the process which is usually not the case.

Dear @Ratslinger ,

Thank you for your advice and now I just realized with the last sentence of the second paragraph namely ‘Why’ on this web page.