http://bugzilla.opensuse.org/show_bug.cgi?id=1178334 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 --> http://bugzilla.opensuse.org/attachment.cgi?id=843204&action=edit 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?... 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: You are on the CC list for the bug.