MariaDB version 10.5.5 Claims table do not exist

General
1

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?

Log:

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))

my.cnf:

    [mysqld]    
    port=3306
    bind-address=0.0.0.0
    # general stuff
    # skip_name_resolve=1
    key_buffer_size=16k
    skip_name_resolve=1
    query_cache_size=32M
    query_cache_limit=2M
    optimizer_search_depth=1
    character-set-server=utf8
    innodb_compression_default=OFF
    innodb_log_buffer_size=32M

    [client]
    port=3306
2

Privileges of the user per the databases?

3

I followed the kodi tutorial and the kodi user created the tables, re-indexed the lot etc.

4

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.

5

Did you implement RocksDB as engine?

6

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.

7

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…

8

Would you mind sharing your config? :slight_smile:

9

What exactly?
MySQL/MariaDB/RocksDB server config? Kodi “advancedsettings.xml” or… ?

10

Just the mariadb one.

11

rocksdb.cnf
[mariadb]
skip-innodb
innodb=OFF
default-storage-engine = rocksdb
default-tmp-storage-engine = MyISAM
plugin-load-add=ha_rocksdb.so

50-server.cnf
…
[mariadb]
log-bin
server_id=2
log-basename=master2
binlog-format=mixed
…

12

Oh, so one needs to load plugins. I see, hm… well got percona rolling and now have rocksdb. Yay.

Thanks!

Do you use ‘utf-8_bin’ in your configs or on a ‘per database’ setting?

13

Not at all.

14

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.

15

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.