Base froze on an error

English
#1

Lubuntu 22.04 LO 7.3.7.2 A general question:

After a freeze I turned off the computer, restored drive, then all was fine.

But some questions. How do I get out of a freeze in linux. And if I have a backup of my ODB file, is copying it back to Documents good enough?

Meaning does a freeze also “wreak” base files (internal files) or will it just mess up the ODB file?

I have the database separate, it’s a Mysql db, the ODB file is just the front end to it.

But as of now I do not even know how to get out of base on a freeze. Thanks,

#2

If it is really Linux “freezing”, google

Raising Skinny Elephants Is Utterly Boring
Reddit - Dive into anything

But usually only Base/LibreOffice is unresponsive, so it should be sufficient to close/terminate only LibreOffice. Basics described here:

#3

As we don’t know why your system freezes nobody can know for sure.
.
As your data is separate in the database, there should not be a problem (unless it is MySQL wrecking its own database and Base waiting forever until MySQL finishes). The typical question would be Was my latest Input/Edit saved in the database or not.
.
Often you can just start the .odb again and everything works. In your case there is the additional question, if the connection to the database was closed also, or if MySQL has an active/unused connection to the earlier process and if there is a problem with this.
.
To have backups is always recommended (also for MySQL), but you should find out when the system/LibreOffice is “freezing”…

#4

The error was

Error inserting the new record ./connectivity/source/commontools/dbtools.cxx:747

Field ‘checkid’ doesn’t have a default value ./connectivity/source/drivers/jdbc/Object.cxx:175

I left out entering the primary key checkid (entered manually)

On a same setup in Windows, it doesn’t freeze, just shows the warning, click ok and fix.

However in Base on linux Base froze up. I hit ok at least 20 times.

Linux did not freeze, the dialog in Base would not close after hitting ok.

So my main question is How to get out of the dialog in such a case, and how to get out of base if it does freeze?

#5

You have connected through JDBC. Is driver version in Windows and Linux the same?

How to get out: I would press Ctrl + Alt + ESC and kill Base.

#6

Yes jdbc and the driver is mysql-connector-j-8.0.33.jar platform independent.

All works, but if leaving out a required field of course you get the popup. But hitting ok once should work, the popup should close.

It does not happen every time, as said I tested it again, I hit ok, it closed, I entered the missing field, and all was fine.

So why does it happen only sometimes?

Also you said press Ctrl + Alt + ESC and kill Base, but doesn’t that ask for a pid? Then how do I get the pid?

#7

Is this the popup from the form, which has been set by the properties of the field (shows a error message in your langugage) or is the message in the popup from MySQL for a required field. I would prefer to set the required field in the form also, so the GUI won’t allow to send the data to MySQL without content in all required fields.

No, the cursor in my system (OpenSUSE 15.4 64bit rpm Linux with KDE) change to death’s head and I will set the mouse on the title of the window. Click with the mouse and the application will be killed.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.