Calc and Base keep on crashing all the time

English
,
#1

Setup:

  • OS: Ubuntu 20.04
  • local mysql server (shall be remote in the future)
  • base file:
    • connection to that DB server
    • includes a form to enter data
  • calc file that has the data I need to enter to the form

Problem
Base and Calc keep crashing abruptly on certain Input events, but I am not able to really figure out what is going on.

Within the Base Form there is a Table Controll Field, which works when entering new Values, but when trying to edit exiting ones, base freezes. But sometimes it even crashes when entering new values.

When crashing, both applications crash and the recovery screen shows up.

What could be the problem and how can I track it down?

Thanks for Help!!

#2

Base file will be connected to MySQL - or did I understand it wrong way? So Calc has nothing to do with the behavior of Base.

Are you allowed from MySQL to change existing data?

Which driver do you use together with Base: Internal direct connection, JDBC or ODBC?

Do you use the special Ubuntu packages and not the packages directly from LibreOffice?

#3

Yes, the calc and base file are »independent« and only base is connected to mysql. The mysql user has full permissions to read/update/delete data and modify the DB Scheme as well.

Driver: That is a good question. I have setup the connection a while ago, now I cannot remember. How can I find out which one is in use?

In /etc/apt/sources.list.d I can find: libreoffice-ubuntu-libreoffice-7-0-focal.list, which contains: deb http://ppa.launchpad.net/libreoffice/libreoffice-7-0/ubuntu focal main

I think the crashes are caused by focus events. When entering a record in the form and switching to another application (like calc) before the input of the record is done base crashes. But is confusion that both apps crash together.

Thanks for help!!

#4

it’s worth asking if you’ve tried resetting the user profile. [I don’t even try to figure out logically why to reset it anymore; it’s just a fixed step in troubleshooting weirdness.]

https://wiki.documentfoundation.org/UserProfile

In my experience when LO crashes, it all crashes. You might start a Writer document then see if you can be in an edit field in Base and crash everything switching to Writer, just as it happens for you with Calc, or even if Writer also crashes when you do switch to Calc.

Do you have any extensions installed?

#5

Do you have any possibility to change the version of LO? I see LO 7.0. Its the version from September 2020. At this moment you could get LO 7.2.5 on LO download.

The driver you are using could be detected through Edit → Database → Connection Type in main window of the Base file. It will also be shown at the status-bar at the bottom of the Base file. Here it shows “MySQL Connector” for example.

#6
  • Updating LO to latest shouldn’t be a problem.
  • even though I cannot open the file to check the driver right now, which one should be used?

Since you mentioned possible driver problems, I might be tempted to state that there are certain write actions of Base to the database which causes the crash. Switching Applications while inserting data in the form might cause a write, due to the focus blur, that happens. But that is just what my intuition tells me …

#7

If you updated to a version from LO directly, choose the direct connection (MySQL Connector). This should work. If it fails it is really a bug of the driver.

If there is a tablecontrol inside the form: Test changing data directly in the table. Does this work without any problems?

Do you use any macros inside your database?

#8

no, there are not macros. Just 5 tables and one view. I don’t know if it is useful to mention, but the hierarchy of Forms just looks like this:

+main
\
 + level-1
  \
   + level-2
    \
     +level-3

There is a Table control for each level an I am inserting data in level-3, due to the foreign keys that are used within the database.

#9

There are 4 different ways to connect a Base document with MySQL or MariaDB.
Bildschirmfoto von 2022-01-31 15-39-55
Bildschirmfoto von 2022-01-31 15-39-36
Bildschirmfoto von 2022-01-31 15-39-12

+ODBC (not availlable yet)

#10

@ottsy Could you upload the *.odb-file with this form and a structure of the database without data (or with dummy-data) from MySQL?

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