Base+HSQLDB: Closing a table, LO crashed.

asked 2019-11-25 10:32:19 +0200

lonk gravatar image

updated 2019-11-25 10:37:56 +0200

After viewing the last record,

image description

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 |

edit retag flag offensive close merge delete



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

lonk gravatar imagelonk ( 2019-11-25 10:48:16 +0200 )edit

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.

Ratslinger gravatar imageRatslinger ( 2019-11-25 16:33:42 +0200 )edit

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.

lonk gravatar imagelonk ( 2019-11-25 16:46:51 +0200 )edit