Android app crashes if mysql connection unavailable

[fhteagle]

Bug report

Describe the bug

Here is a clear and concise description of what the problem is:

Using advancedsettings.xml defined music and video libraries pointing to a mysql server on my LAN, if mysql connection fails for any reason, the android app will crash 100% of the time sometime during startup. Crash will occur either on splash screen, on subsequent blank black screen, or if it makes it to the skin loaded stage, the crash will occur as soon as you select a section that uses mysql library, such as music.

I am using Kodi app 21.0 installed via Google Play store. This is repeatable 100% of the time on OnePlus 7T HD1905 with LineageOS 20. I can test other devices with OEM ROMs (though much older versions of android) if need be.

The crash does not occur, library data loads, and everything works as expected if the mysql connection is available.

Kodi 21 binary installed on arch linux amd64 hosts are able to ride through the mysql connection failure, and load with a blank library.

Expected Behavior

Here is a clear and concise description of what was expected to happen:

Kodi app loads and launches with a blank or fallback local library if mysql connnection is unavailable.

Actual Behavior

Kodi app freezes on splash screen, or blank black screen, or self force-closes on first media section selection that would draw from the mysql library

Possible Fix

To Reproduce

Steps to reproduce the behavior:

1. Define valid mysql library sources in advancedsettings.xml, optionally populate said library
2. Launch Kodi android app with mysql connection unavailable (wifi disconnected, mysql server stopped, etc)
3. Note crash

Debuglog

The most complete debuglog can be found here:

https://paste.kodi.tv/avecihelan.kodi

However, during many crash occurrences, the log file stops before the error <general>: Unable to open database: kodi-music83 [2002](Can't connect to server on '***hostredacted***' (115)) line is written even.

Screenshots

Here are some links or screenshots to help explain the problem:

Additional context or screenshots (if appropriate)

Here is some additional context or explanation that might help:

Your Environment

Used Operating system:

• Android

• iOS

• tvOS

• Linux

• macOS

• Windows

• Windows UWP

• Operating system version/name: Android LineageOS 20

• Kodi version: 21.0

note: Once the issue is made we require you to update it with new information or Kodi versions should that be required.
Team Kodi will consider your problem report however, we will not make any promises the problem will be solved.

[fhteagle]

I just checked Kodi 21.0 app installed on an old Samsung Galaxy S9 with OEM Android 10. Exact same behavior: works perfectly before MySQL library is defined, when mysql library is defined and connection is available, but 100% crash rate with MySQL connection unavailable.