LO 5.2.6 crashes when logging in to mysql with Base

Greetings,

I am running LO 5.2.6.2 under Linux 4.4 (Slackware 14.2) with Oracle JDK 1.8u112, MySQL_Connector_Java 5.1.40, and Mariadb 10.0.30.

Now that I upgraded to LO 5.2.6.2 from LO 5.1.6, every time I try to log in to Mariadb to access my database, LO crashes hard. This worked fine in 5.1.6 and it still works now in OpenOffice 4.1.3. I checked the Java config under Options and it is fine. I tried deleting the profile directory and starting from scratch. It still crashed. LO also crashes when I use the "Test Connection" button in the database configuration dialog to try to log in to Mariadb.

Any ideas before I return to 5.1.6?

Thanks.
Girvin Herr

Hi Girvin,

Now that I upgraded to LO 5.2.6.2 from LO 5.1.6, every time I try to log
in to Mariadb to access my database, LO crashes hard. This worked fine
in 5.1.6 and it still works now in OpenOffice 4.1.3. I checked the Java
config under Options and it is fine. I tried deleting the profile
directory and starting from scratch. It still crashed. LO also crashes
when I use the "Test Connection" button in the database configuration
dialog to try to log in to Mariadb.

Any ideas before I return to 5.1.6?

Could be several things, although off the cuff, LO5.2.x was known to
crash in certain circumstances with JDKu112, so either:
- revert back to LO5.1.x or else
- try updating your JDK to a much more recent one and see if that makes
a difference with LO5.2.x, or else
- move to LO5.3.x and a current JDK.

Why do I mention a Java problem ? Because the devs changed the version
number recognition pattern for JDK/JVM instantiation somewhere between
5.1 and 5.2, and this is what caused crashing for some. This was fixed
in 5.3. Of course, it could all be specific to your Slackware setup...

Alex

Alex,
Thanks for your prompt response. I have been working on this problem all morning. I first upgraded jdk-8u112 with jdk-8u131 with the same results. I then tried LO 5.2.7.2 with the same results. I then tried LO 5.3.4.2 with the same results. I then upgraded the MySQL Connector from 5.1.40 to 5.1.42 with the same results. Nothing I do seems to affect whatever is causing LO to crash. I also started LO from a console to see if LO spit out any pertinent messages when it crashed - none.

Whatever is happening here, it is broad. I even tried to use my OpenOffice Base odb file with the same LO results. Now this file works fine in AOO.

There are two datapoints I had not thought of when I posted my message yesterday. One is that I successfully edited and printed a report on 6/19/17 with LO 5.2.6.2. So, it was working at that time.

The other is that I upgraded glibc from version 2.23 build 1 to 2.23 build 2 yesterday, before I noticed LO crashing. But I tried returning to the old glibc version and LO still crashed, so I doubt glibc was the cause. The other Slackware packages that I changed yesterday are: bind, irssi, mozilla-firefox, openvpn, sudo, the Linux kernel, httpd, libcgroup, libcrypt, mkinitrd, mozilla-thunderbird, nasm, and pkg-config. None of these should have affected LO, but...

There is something else going on besides Base crashing. I was checking the "Tools" | "Options" with nothing loaded and when I got to the bottom item, "Internet" | "MediaWiki", LO crashed when I selected it. I wasn't even close to MySQL or Base at the time.

BTW: I am running a Dual-core Athlon CPU, 32-bit ix86 Linux and Java, 8GB RAM, and 10% of 1TB disk space used. So it shouldn't be a lack of resources. Besides, as I said, OpenOffice is still running fine. My problem with using AOO, is that it does not have the Base Report Generator I need to print my reports.

Hope this helps narrow this problem down. I am about to issue a bug report on this. It is certainly repeatable, if frustrating.
Thanks.
Girvin

Just a shot in the dark.

May want to look to see all proper groups are set.

Thanks for your response. groups? In what way? Anything specific I should be aware of from your experience? Does something with LO require a special group, like k3b "suggests" a "burner" group, which I would need to be a member of to burn CDs? I just checked the group file and didn't see anything out of the ordinary or any group I should be a member of and am not.

Since this problem seems ubiquitous across many LO versions and across other user accounts on my machine that I tested, I am now doubting this issue is a LO problem. Although it may be a problem which only LO encounters, since no other apps, including AOO, are having any problems. I am going off to do some troubleshooting with another similar computer which has not been updated yet since the end of March. Hopefully, it will work and I can incrementally install the security updates one at a time while retesting LO for crashing after each installation. Hopefully, the culprit update package will show itself. So, I may be off for a while, but if I discover anything, I will post it here on this thread. I will keep your suggestion in mind as I am troubleshooting.

Thanks.
Girvin

Nothing specific, but it is an edge case sometimes missed when updating/adding other linux software.

Have you seen https://ask.libreoffice.org/en/question/79135/how-do-i-set-up-a-odbc-connector-for-mariadb-in-base/

Paul,

No, I haven't seen that. I filed it away for future reference if I ever look at ODBC again, thanks. I looked at ODBC years ago and decided the JDBC Connector was better suited for me. It has been working for me for a long time until now.

I still think my problem lies in the many Slackware packages, both security and non-security, I installed on my workstation between when LO was last working on June 19 and the day before I noticed it stopped working, July 4. This morning, I verified LO 5.2.6.2 does work on my Slackware Linux laptop with updates installed up to the beginning of May. That is about a month before the last time LO worked, so it should be a good starting point. My plan is to install the Slackware updates one at a time, checking if LO is still functional between each one. When and if LO stops working, the package I just installed is most likely the culprit and I can back it out again, hopefully restoring LO to functionality. I can then try backing out the same package on my workstation and hopefully get it working again. At least that is my plan.

Thanks again.
Girvin

Hi,

Don't know if it's going to help you, but I have experienced some
unexplainable crashes in the past which were "cured" by erasing the
user configuration folders/data in ~/.config/libreoffice. Word of
caution: erasing that folder will reset all settings to their default
value. And I do mean all of them. One test you could do is to rename
the folder, launch LO and see if the problem still exists; if it does,
erase the new config folder and rename your previous one back, at least
you will not loose anything.

I hope this helps.

Rémy Gauthier.

Paul,

> No, I haven't seen that. I filed it away for future reference if I

ever

> look at ODBC again, thanks. I looked at ODBC years ago and decided

the

> JDBC Connector was better suited for me. It has been working for me

for

a long time until now.

I still think my problem lies in the many Slackware packages, both 
> security and non-security, I installed on my workstation between when

LO

was last working on June 19 and the day before I noticed it stopped 
working, July 4. This morning, I verified LO 5.2.6.2 does work on my 
Slackware Linux laptop with updates installed up to the beginning of 
> May. That is about a month before the last time LO worked, so it

should

> be a good starting point. My plan is to install the Slackware

updates

> one at a time, checking if LO is still functional between each one.

When

> and if LO stops working, the package I just installed is most likely

the

culprit and I can back it out again, hopefully restoring LO to 
functionality. I can then try backing out the same package on my 
> workstation and hopefully get it working again. At least that is my

plan.

Thanks again.
Girvin

> Nothing specific, but it is an edge case sometimes missed when 
> updating/adding other linux software.
>
> Have you seen 
> > > https://ask.libreoffice.org/en/question/79135/how-do-i-set-up-a-odb

c-connector-for-mariadb-in-base/

>
>
> > > > > Thanks for your response. groups? In what way? Anything specific

I

> > should be aware of from your experience? Does something with LO 
> > > > > require a special group, like k3b "suggests" a "burner" group,

which

> > > > > I would need to be a member of to burn CDs? I just checked the

group

> > file and didn't see anything out of the ordinary or any group I 
> > should be a member of and am not.
> >
> > Since this problem seems ubiquitous across many LO versions and 
> > across other user accounts on my machine that I tested, I am now 
> > > > > doubting this issue is a LO problem. Although it may be a

problem

> > > > > which only LO encounters, since no other apps, including AOO,

are

> > > > > having any problems. I am going off to do some troubleshooting

with

> > > > > another similar computer which has not been updated yet since the

end

> > > > > of March. Hopefully, it will work and I can incrementally install

the

> > > > > security updates one at a time while retesting LO for crashing

after

> > > > > each installation. Hopefully, the culprit update package will

show

> > > > > itself. So, I may be off for a while, but if I discover anything,

I

> > > > > will post it here on this thread. I will keep your suggestion in

mind

> > as I am troubleshooting.
> >
> > Thanks.
> > Girvin
> >
> >
> > > Just a shot in the dark.
> > >
> > > May want to look to see all proper groups are set.
> > >
> > >
> > >
> > > >
> > > >
> > > > >
> > > > > Hi Girvin,
> > > > >
> > > > >
> > > > > > > > > > > > > Now that I upgraded to LO 5.2.6.2 from LO 5.1.6, every

time I try

> > > > > > to log
> > > > > > > > > > > > > in to Mariadb to access my database, LO crashes hard.

This worked

> > > > > > fine
> > > > > > > > > > > > > in 5.1.6 and it still works now in OpenOffice 4.1.3. I

checked

> > > > > > the Java
> > > > > > > > > > > > > config under Options and it is fine. I tried deleting the

profile

> > > > > > > > > > > > > directory and starting from scratch. It still crashed. LO

also

> > > > > > crashes
> > > > > > when I use the "Test Connection" button in the database 
> > > > > > configuration
> > > > > > dialog to try to log in to Mariadb.
> > > > > >
> > > > > > Any ideas before I return to 5.1.6?
> > > > > > > > > > > Could be several things, although off the cuff, LO5.2.x was

known to

> > > > > crash in certain circumstances with JDKu112, so either:
> > > > > - revert back to LO5.1.x or else
> > > > > > > > > > > - try updating your JDK to a much more recent one and see

if that

> > > > > makes
> > > > > a difference with LO5.2.x, or else
> > > > > - move to LO5.3.x and a current JDK.
> > > > >
> > > > >
> > > > > > > > > > > Why do I mention a Java problem ? Because the devs changed

the

> > > > > version
> > > > > > > > > > > number recognition pattern for JDK/JVM instantiation

somewhere

> > > > > between
> > > > > > > > > > > 5.1 and 5.2, and this is what caused crashing for some.

This was

> > > > > fixed
> > > > > > > > > > > in 5.3. Of course, it could all be specific to your

Slackware

> > > > > setup...
> > > > >
> > > > > Alex
> > > > >
> > > > >
> > > > Alex,
> > > > Thanks for your prompt response. I have been working on this 
> > > > > > > > > problem all morning. I first upgraded jdk-8u112 with jdk-

8u131 with

> > > > > > > > > the same results. I then tried LO 5.2.7.2 with the same

results. I

> > > > > > > > > then tried LO 5.3.4.2 with the same results. I then upgraded

the

> > > > MySQL Connector from 5.1.40 to 5.1.42 with the same results. 
> > > > > > > > > Nothing I do seems to affect whatever is causing LO to crash.

I

> > > > > > > > > also started LO from a console to see if LO spit out any

pertinent

> > > > messages when it crashed - none.
> > > >
> > > > > > > > > Whatever is happening here, it is broad. I even tried to use

my

> > > > > > > > > OpenOffice Base odb file with the same LO results. Now this

file

> > > > works fine in AOO.
> > > >
> > > > > > > > > There are two datapoints I had not thought of when I posted

my

> > > > > > > > > message yesterday. One is that I successfully edited and

printed a

> > > > > > > > > report on 6/19/17 with LO 5.2.6.2. So, it was working at that

time.

> > > >
> > > > > > > > > The other is that I upgraded glibc from version 2.23 build 1

to

> > > > > > > > > 2.23 build 2 yesterday, before I noticed LO crashing. But I

tried

> > > > > > > > > returning to the old glibc version and LO still crashed, so I

doubt

> > > > > > > > > glibc was the cause. The other Slackware packages that I

changed

> > > > > > > > > yesterday are: bind, irssi, mozilla-firefox, openvpn, sudo,

the

> > > > Linux kernel, httpd, libcgroup, libcrypt, mkinitrd, 
> > > > > > > > > mozilla-thunderbird, nasm, and pkg-config. None of these

should

> > > > have affected LO, but...
> > > >
> > > > > > > > > There is something else going on besides Base crashing. I

was

> > > > > > > > > checking the "Tools" | "Options" with nothing loaded and when

I got

> > > > > > > > > to the bottom item, "Internet" | "MediaWiki", LO crashed when

I

> > > > > > > > > selected it. I wasn't even close to MySQL or Base at the

time.

> > > >
> > > > > > > > > BTW: I am running a Dual-core Athlon CPU, 32-bit ix86 Linux

and

> > > > > > > > > Java, 8GB RAM, and 10% of 1TB disk space used. So it

shouldn't be a

> > > > > > > > > lack of resources. Besides, as I said, OpenOffice is still

running

> > > > > > > > > fine. My problem with using AOO, is that it does not have the

Base

> > > > Report Generator I need to print my reports.
> > > >
> > > > > > > > > Hope this helps narrow this problem down. I am about to issue

a bug

That was one of the first things I tried. No joy. LO still crashed.

Now the good (sort-of) news. My tests today showed that the latest Slackware Linux kernel security upgrade 4.4.75 kernel is the culprit. LO on my laptop was working fine until I installed the kernel upgrade. After the upgrade, the laptop's LO crashes just as my workstation does.

I just returned to the previous kernel, tried LO, and it is now working again - no crashes. Whew!
That just goes to show you that even security upgrades can bite you.

Thanks to all who helped with suggestions to solve this problem.

Girvin Herr

The upgrade manager on my Linux Mint 18 gives each package update a
priority level, 1 being the highest and 5 the lowest. The manager then
checks the upgrades it recommends installing. Since I installed Mint
nearly a year ago, the kernel upgrades have always been rated 5 and
never has the upgrade manager recommended that I install a kernel
upgrade. It also warns that kernel regressions can cause bad things to
happen. Since my computer is working fine, I have never clicked to
upgrade my kernel.

Virgil

Virgil,
I take computer security seriously, so when I see a security upgrade is available, I usually install it asap. That said, my experience with kernel upgrades has not been all that positive. Whenever something disastrous has happened, it usually has been after a kernel upgrade. I would guess my success rate is about 50% for kernel upgrades - whether I screw up the process, like forgetting to run LILO before rebooting, or in this case, a compromised kernel package. 50% is not a good success rate. Upgrades are risky, so your policy is probably a good one and I may assume that same policy from now on. Actually, I did have that policy a few years ago, but I got complacent from success and it bit me. I will have to revisit it. In general I agree with you - if it ain't broke, don't fix it.

Another aspect is that Slackware spends months, if not years, testing each new release to be sure it is a well-integrated and working set of packages. Updates, or what Slackware calls "patches", are not as fully tested because they need to get out fast, especially in the case of security patches. So, I doubt they are tested as thoroughly as for the distro release. Some "gotchas" are bound to slip through.

Note that what I am talking about are security updates, not non-security updates. The latter are totally optional. The former have a certain amount of risk if _not_ installed.

Note also that Slackware does not have an automatic update manger. I use the Linux security website, linuxsecurity.com ( http://www.linuxsecurity.com). The site lists the Slackware security updates by date released and then I go to my favorite Slackware mirror site, download the packages, check the gpg signatures, and install them. I usually do this once a month, just before I do my monthly backup. Actually, I install them _after_ the backup, so if something goes really badly, I can restore the backup and be where I was before the upgrades. Luckily, that has never been the case, but Murphy's law prevails, so I continue the policy.

Girvin