Thought I’d try out mariaDB. Re-indexing went fine, and according to my eyesight and phpmyadmin it populated the “missing” tables below, however, apparently not. What can cause this?
2020-09-16 15:22:30.995 T:3924792192 NOTICE: MYSQL: Connected to version 10.5.5-MariaDB
2020-09-16 15:22:31.003 T:3924792192 NOTICE: Running database version MyMusic72
2020-09-16 15:22:31.012 T:3924792192 NOTICE: Running database version MyVideos116
2020-09-16 15:22:31.015 T:3924792192 NOTICE: Running database version TV32
2020-09-16 15:22:31.017 T:3924792192 NOTICE: Running database version Epg12
2020-09-16 15:22:31.018 T:4062290512 NOTICE: start dvd mediatype detection
2020-09-16 15:22:31.080 T:4062290512 NOTICE: load skin from: /usr/share/kodi/addons/skin.estuary (version: 2.0.27)
2020-09-16 15:22:31.578 T:4062290512 ERROR: SQL: [MyMusic72] The table does not exist
Query: select count(idSong) as NumSongs from songview
2020-09-16 15:22:31.578 T:4062290512 ERROR: GetSongsCount() failed
2020-09-16 15:22:31.761 T:3916399488 ERROR: SQL: [MyVideos116] The table does not exist
Query: select * from movie_view WHERE (movie_view.idFile IN (SELECT DISTINCT idFile FROM bookmark WHERE type = 1))
# general stuff
Privileges of the user per the databases?
I followed the kodi tutorial and the kodi user created the tables, re-indexed the lot etc.
Never mind, I nuked the system (which is one point for me to use mariadb testing/quick restore etc) and it works now.
Almost forgot. Do note that even though IF your media is stored locally, you must give path that kodi sees as network-storage.
Note to self: chattr +C on your sql-datadir if you use btrfs.
Did you implement RocksDB as engine?
It does not seem to be available for mariadb v.10.5.5 atm, however there is always percona-server which sells itself as drop-in for mysql and boasts rocksdb etc.
It is available,
and I’ve been using it since MariaDB 10.4.x for more than an year.
Just wanted to receive some impressions from some other experience…
Would you mind sharing your config?
MySQL/MariaDB/RocksDB server config? Kodi “advancedsettings.xml” or… ?
Oh, so one needs to load plugins. I see, hm… well got percona rolling and now have rocksdb. Yay.
Do you use ‘utf-8_bin’ in your configs or on a ‘per database’ setting?
Thanks. Alright, so it scans, but… well…
Populated database, info, no artwork. Weird. The path is there in the db: “http://image.tmdb…” and so forth.
Edit: the ./kodi/userdata/Thumbnails & .kodi/userdata/Database/Textures13.db have content.
Well, now we know percona-server does not work for this purpose.
Mariadb with rocksdb is seems faster, yes. Art works now, so it’s something with percona.
This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.