Bug ID 1178334
Summary Kodi Leia 18.9.0 Crashes with a Sqlite Error on Selection of the Music Menu on OpenSUSE Tumbleweed
Classification openSUSE
Product openSUSE Tumbleweed
Version Current
Hardware x86-64
OS openSUSE Tumbleweed
Status NEW
Severity Normal
Priority P5 - None
Component Other
Assignee screening-team-bugs@suse.de
Reporter steven.swart@gmail.com
QA Contact qa-bugs@suse.de
Found By ---
Blocker ---

Created attachment 843204 [details]
Kodi crashlog

2nd of November 2020

Good day, all!

I am having problems once again with Kodi on OpenSUSE. Kodi updated to version
18.9 on 28th October 2020. This version of Kodi was installed from the packman
repo. There was another Kodi update from that repo yesterday. There are two
errors that I am now having, that I didn���t have with any version 18.8.

When I launch Kodi, I get a visual error message, complaining that Kodi can���t
listen on port 9777.

But the more important problem is the crash.

Steps to reproduce:

1.    Remove or rename the .kodi directory in your home directory.
2.    Launch Kodi.
3.    Select the Music item from the main menu.
4.    Kodi crashes.

I see the following error in the log:

2020-11-01 16:39:10.��637 T:140647027474432   ERROR: SQL: [MyMusic 72.db] SQLite
error SQLITE_MISUSE (unable to open database file)
                                            Query: SELECT * FROM versiontagscan
2020-11-01 16:39:10. 679 T:140647027474432   ERROR: GetMusicNeedsTagScan failed
2020-11-01 16:39:10.��679 T:140647027474432   ERROR: SQL: [MyMusic 72.db] SQLite
error SQLITE_MISUSE (unable to open database file)
                                            Query: UPDATE versiontagscan SET
idVersion=72

I tried launching Kodi as root with kdesu, same and got the same errors. So, I
don���t think it���s a permissions problem.

I suspect that it may be an incompatibility issue with my installed version of
Sqlite, however I have a workaround with a version of Kodi 18.8 that I cloned
and built on Saturday, October 17, 2020, and that version presumably uses the
same version of Sqlite. I also have a flatpak version of Leia 18.8 installed,
and that is working perfectly. So I am not sure what is going on here.

The version of Sqlite I have installed, according to zypper, is:

steven@linux-ll3r:~> sudo zypper info libsqlite3-0
Loading repository data...
Reading installed packages...


Information for package libsqlite3-0:
-------------------------------------
Repository     : openSUSE:Factory
Name           : libsqlite3-0
Version        : 3.33.0-1.3
Arch           : x86_64
Vendor         : openSUSE
Installed Size : 1.3 MiB
Installed      : Yes
Status         : up-to-date
Source package : sqlite3-3.33.0-1.3.src
Summary        : Shared libraries for the Embeddable SQL Database Engine
Description    : 
    This package contains the shared libraries for the Embeddable SQL
    Database Engine.

    SQLite is a C library that implements an embeddable SQL database
    engine. Programs that link with the SQLite library can have SQL
    database access without running a separate RDBMS process.

    SQLite is not a client library used to connect to a big database
    server. SQLite is a server and the SQLite library reads and writes
    directly to and from the database files on disk.

    SQLite can be used via the sqlite command line tool or via any
    application that supports the Qt database plug-ins.

I tried testing the Kodi Leia 18.9.0 version installed from the packman repo on
my OpenSUSE Leap box, but I was not having the same problem there.

The version of Sqlite on my Leap box is an older version, according to
zypper,it  is:

steven@localhost:~> sudo zypper info libsqlite3-0
Loading repository data...
Reading installed packages...


Information for package libsqlite3-0:
-------------------------------------
Repository     : Main Repository
Name           : libsqlite3-0
Version        : 3.28.0-lp152.3.5
Arch           : x86_64
Vendor         : openSUSE
Installed Size : 1.1 MiB
Installed      : Yes
Status         : up-to-date
Source package : sqlite3-3.28.0-lp152.3.5.src
Summary        : Shared libraries for the Embeddable SQL Database Engine
Description    : 
    This package contains the shared libraries for the Embeddable SQL
    Database Engine.

    SQLite is a C library that implements an embeddable SQL database
    engine. Programs that link with the SQLite library can have SQL
    database access without running a separate RDBMS process.

    SQLite is not a client library used to connect to a big database
    server. SQLite is a server and the SQLite library reads and writes
    directly to and from the database files on disk.

    SQLite can be used via the sqlite command line tool or via any
    application that supports the Qt database plug-ins.

Kodi crashlog here:

https://paste.kodi.tv/samegelabi.kodi

GDB backtrace here:

https://paste.kodi.tv/ojadulijox.kodi

EDIT:

I reported this issue on the Kodi forums. You can see the discussion here:

https://forum.kodi.tv/showthread.php?tid=358116&pid=2985971#pid2985971

They said that it was suspicious that there were non-printable characters in
the crashlog:

I have uploaded the crashlog here:

https://www.dropbox.com/s/2fxt36j84a5l2sp/kodi_crashlog-20201101_184203.log?dl=0

They also said that this build was made by SUSE, and Team Kodi does not support
it.

They said entries like these look suspicious:

2020-11-01 16:22:59.343 T:140646069474880 ERROR: SQL: [MyMusic��72.db]

When the filename is supposed to be: MyMusic172.db

And so, I am reporting this as a SUSE bug.

Hardware:

My media server is based on an HP Proliant MicroServer, Gen10 (WW Entry BTO
Model), specs here:

https://h20195.www2.hpe.com/v2/GetDocument.aspx?docname=a00008701enw&doctype=quickspecs&doclang=EN_US&searchquery=&cc=us&lc=en

Briefly, the hardware is as follows:

CPU: AMD Opteron(TM) X3216 APU - Dual-core, x86_64
Memory-Main Memory-phys_mem: 8053063680
Monitor: LG TV
Network Cards: NC332i Adapter x2, RTL8192EE PCIe Wireless Network Adapter
Graphics Card: ATI Radeon R5 Graphics
Sound Card: Kabini HDMI/DP Audio (built into graphics card).

The hardware info as reported by YaST may be found here:

https://paste.kodi.tv/jivakukiku.kodi


You are receiving this mail because: