LibreELEC Clean MySQL Install of v10.0.2 Fails

nuxref · September 21, 2022 at 3:57 PM

Summary

I basically just want to load a fresh instance of Kodi leveraging a local MySQL database. The fresh loading of a v10.0.2 seems to be bugged. It seems to detect what it needs to do correctly but when it starts running the inserts, create tables, create triggers, etc, it eventually just fails.

If i power of the Pi and drop the SQL tables; then restart the PI again, the same errors occur. So the bug appears to be in the database schema.

Just a little system details:

LibraELEC version: 10.0.2
Database: mysql v8.0.2
kernel: Linux ARM 32-bit version 5.10.95

Logs

Cleared the database and set up permissions okay (verified i could log in as the kodi user and manage tables etc). Started up the PI and here are the logs in ~/.kodi/temp/kodi.log (i highlighted the errors in red)

Code

...2022-09-21 01:43:43.022 T:726      INFO <general>: -----------------------------------------------------------------------                    
2022-09-21 01:43:43.022 T:726      INFO <general>: Starting Kodi (19.4 (19.4.0) Git:19.4-Matrix). Platform: Linux ARM 32-bit                     
2022-09-21 01:43:43.022 T:726      INFO <general>: Using Release Kodi x32                                              
2022-09-21 01:43:43.022 T:726      INFO <general>: Kodi compiled 2022-03-05 by GCC 10.2.0 for Linux ARM 32-bit version 5.10.95 (330335)
2022-09-21 01:43:43.022 T:726      INFO <general>: Running on BCM2835 with LibreELEC (official): 10.0.2, kernel: Linux ARM 32-bit version 5.10.95
2022-09-21 01:43:43.022 T:726      INFO <general>: FFmpeg version/source: 4.3.2-Kodi                        
2022-09-21 01:43:43.022 T:726      INFO <general>: Host CPU: ARMv7 Processor rev 4 (v7l), 4 cores available            
2022-09-21 01:43:43.022 T:726      INFO <general>: ARM Features: Neon enabled                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
# normal startup here... except the line below... i wonder if this is my problem?                                                                                                        
2022-09-21 01:43:43.080 T:726   WARNING <CSettingsManager>: missing version attribute                                                  
2022-09-21 01:43:45.918 T:726      INFO <general>: Loading special://xbmc/system/keymaps/keyboard.xml
2022-09-21 01:43:45.932 T:726      INFO <general>: Loading special://xbmc/system/keymaps/mouse.xml
2022-09-21 01:43:45.933 T:726      INFO <general>: Loading special://xbmc/system/keymaps/remote.xml
2022-09-21 01:43:45.941 T:726      INFO <general>: Loading special://xbmc/system/keymaps/touchscreen.xml
2022-09-21 01:43:45.947 T:726      INFO <general>: GUI format 1920x1080, Display 1920x1080 @ 60.000000 Hz
2022-09-21 01:43:45.947 T:726      INFO <general>: CLangInfo: loading resource.language.en_gb language information...
2022-09-21 01:43:45.963 T:726      INFO <general>: global locale set to C
2022-09-21 01:43:45.963 T:726      INFO <general>: CLangInfo: loading resource.language.en_gb language strings...
2022-09-21 01:43:46.141 T:747      INFO <general>: Running database version Addons33
2022-09-21 01:43:46.146 T:747      INFO <general>: Running database version ViewModes6
2022-09-21 01:43:47.699 T:747      INFO <general>: Running database version Textures13
2022-09-21 01:43:48.130 T:747      INFO <general>: MYSQL: Connected to version 8.0.28
2022-09-21 01:43:48.136 T:747     ERROR <general>: Unable to open database: kodi_music82 [1049](Unknown database 'kodi_music82')
2022-09-21 01:43:48.194 T:747     ERROR <general>: Unable to open database: kodi_music81 [1049](Unknown database 'kodi_music81')
# ... <truncated - several versions checked; i presume this is normal and part of the migration process>
2022-09-21 01:43:51.023 T:747     ERROR <general>: Unable to open database: kodi_music32 [1049](Unknown database 'kodi_music32')
2022-09-21 01:43:51.084 T:747      INFO <general>: creating version table
2022-09-21 01:43:51.089 T:747      INFO <general>: create artist table
2022-09-21 01:43:51.096 T:747      INFO <general>: create album table
2022-09-21 01:43:51.102 T:747      INFO <general>: create audiobook table
2022-09-21 01:43:51.106 T:747      INFO <general>: create album_artist table
2022-09-21 01:43:51.109 T:747      INFO <general>: create album_source table
2022-09-21 01:43:51.113 T:747      INFO <general>: create genre table
2022-09-21 01:43:51.116 T:747      INFO <general>: create path table
2022-09-21 01:43:51.120 T:747      INFO <general>: create source table
2022-09-21 01:43:51.124 T:747      INFO <general>: create source_path table
2022-09-21 01:43:51.127 T:747      INFO <general>: create song table
2022-09-21 01:43:51.133 T:747      INFO <general>: create song_artist table
2022-09-21 01:43:51.137 T:747      INFO <general>: create song_genre table
2022-09-21 01:43:51.140 T:747      INFO <general>: create role table
2022-09-21 01:43:51.145 T:747      INFO <general>: create infosetting table
2022-09-21 01:43:51.148 T:747      INFO <general>: create discography table
2022-09-21 01:43:51.152 T:747      INFO <general>: create art table
2022-09-21 01:43:51.156 T:747      INFO <general>: create versiontagscan table
2022-09-21 01:43:51.161 T:747      INFO <general>: create removed_link table
2022-09-21 01:43:51.165 T:747      INFO <general>: CreateAnalytics - creating indices
2022-09-21 01:43:51.352 T:747      INFO <general>: create triggers
2022-09-21 01:43:51.353 T:747     ERROR <general>: SQL: [kodi_music82] Undefined MySQL error: Code (1419)
                                                   Query: CREATE TRIGGER tgrDeleteAlbum AFTER delete ON album FOR EACH ROW BEGIN  DELETE FROM song WHERE song.idAlbum = old.idAlbum;  DELETE FROM album_artist WHERE album_artist.idAlbum = old.idAlbum;  DELETE FROM album_source WHERE album_source.idAlbum = old.idAlbum;  DELETE FROM art WHERE media_id=old.idAlbum AND media_type='album'; END
                                                   
2022-09-21 01:43:51.353 T:747     ERROR <general>: CreateDatabase unable to create database:0
2022-09-21 01:43:51.411 T:747     ERROR <general>: Unable to open database: kodi_video119 [1049](Unknown database 'kodi_video119')
# ... <truncated - several versions checked; i presume this is normal and part of the migration process>
2022-09-21 01:43:53.927 T:747     ERROR <general>: Unable to open database: kodi_video75 [1049](Unknown database 'kodi_video75')
2022-09-21 01:43:53.989 T:747      INFO <general>: creating version table
2022-09-21 01:43:53.994 T:747      INFO <general>: create bookmark table
2022-09-21 01:43:53.998 T:747      INFO <general>: create settings table
2022-09-21 01:43:54.004 T:747      INFO <general>: create stacktimes table
2022-09-21 01:43:54.007 T:747      INFO <general>: create genre table
2022-09-21 01:43:54.014 T:747      INFO <general>: create country table
2022-09-21 01:43:54.022 T:747      INFO <general>: create movie table
2022-09-21 01:43:54.027 T:747      INFO <general>: create actor table
2022-09-21 01:43:54.042 T:747      INFO <general>: create path table
2022-09-21 01:43:54.046 T:747      INFO <general>: create files table
2022-09-21 01:43:54.050 T:747      INFO <general>: create tvshow table
2022-09-21 01:43:54.055 T:747      INFO <general>: create episode table
2022-09-21 01:43:54.060 T:747      INFO <general>: create tvshowlinkpath table
2022-09-21 01:43:54.064 T:747      INFO <general>: create movielinktvshow table
2022-09-21 01:43:54.067 T:747      INFO <general>: create studio table
2022-09-21 01:43:54.075 T:747      INFO <general>: create musicvideo table
2022-09-21 01:43:54.080 T:747      INFO <general>: create streaminfo table
2022-09-21 01:43:54.085 T:747      INFO <general>: create sets table
2022-09-21 01:43:54.089 T:747      INFO <general>: create seasons table
2022-09-21 01:43:54.093 T:747      INFO <general>: create art table
2022-09-21 01:43:54.097 T:747      INFO <general>: create tag table
2022-09-21 01:43:54.104 T:747      INFO <general>: create rating table
2022-09-21 01:43:54.108 T:747      INFO <general>: create uniqueid table
2022-09-21 01:43:54.112 T:747      INFO <general>: CreateAnalytics - creating indices
2022-09-21 01:43:54.400 T:747      INFO <general>: CreateAnalytics - creating triggers
2022-09-21 01:43:54.401 T:747     ERROR <general>: SQL: [kodi_video119] Undefined MySQL error: Code (1419)
                                                   Query: CREATE TRIGGER delete_movie AFTER DELETE ON movie FOR EACH ROW BEGIN DELETE FROM genre_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM actor_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM director_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM studio_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM country_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM writer_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM movielinktvshow WHERE idMovie=old.idMovie; DELETE FROM art WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM tag_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM rating WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM uniqueid WHERE media_id=old.idMovie AND media_type='movie'; END
                                                   
2022-09-21 01:43:54.402 T:747     ERROR <general>: CreateDatabase unable to create database:0
2022-09-21 01:43:54.418 T:747      INFO <general>: Running database version TV38
2022-09-21 01:43:54.424 T:747      INFO <general>: Running database version Epg13
2022-09-21 01:43:54.452 T:726      INFO <general>: start dvd mediatype detection
2022-09-21 01:43:54.569 T:726      INFO <general>: Unloaded skin
2022-09-21 01:43:54.573 T:726      INFO <general>:   load skin from: /usr/share/kodi/addons/skin.estuary/ (version: 3.0.5)
2022-09-21 01:43:54.573 T:726      INFO <general>:   load fonts for skin...
2022-09-21 01:43:54.617 T:726      INFO <general>: Loading skin includes from /usr/share/kodi/addons/skin.estuary/xml/Includes.xml
2022-09-21 01:43:54.827 T:726      INFO <general>: Loading fonts from /usr/share/kodi/addons/skin.estuary/xml/Font.xml
2022-09-21 01:43:54.969 T:726      INFO <general>:   load new skin...
2022-09-21 01:43:54.970 T:726      INFO <general>: Loading custom window XMLs from skin path /usr/share/kodi/addons/skin.estuary/xml
2022-09-21 01:43:54.998 T:726      INFO <general>:   initialize new skin...
2022-09-21 01:43:54.999 T:726      INFO <general>: Loading skin file: Custom_1109_TopBarOverlay.xml, load type: LOAD_ON_GUI_INIT
2022-09-21 01:43:55.062 T:726      INFO <general>: Loading skin file: DialogVolumeBar.xml, load type: LOAD_ON_GUI_INIT
2022-09-21 01:43:55.065 T:726      INFO <general>: Loading skin file: DialogBusy.xml, load type: LOAD_ON_GUI_INIT
2022-09-21 01:43:55.069 T:726      INFO <general>: Loading skin file: Pointer.xml, load type: LOAD_ON_GUI_INIT
2022-09-21 01:43:55.081 T:726      INFO <general>: Loading skin file: DialogExtendedProgressBar.xml, load type: LOAD_ON_GUI_INIT
2022-09-21 01:43:55.085 T:726      INFO <general>: Loading skin file: DialogSeekBar.xml, load type: LOAD_ON_GUI_INIT
2022-09-21 01:43:55.123 T:726      INFO <general>: Loading skin file: DialogNotification.xml, load type: LOAD_ON_GUI_INIT
2022-09-21 01:43:55.126 T:726      INFO <general>: Loading skin file: DialogBusy.xml, load type: LOAD_ON_GUI_INIT
2022-09-21 01:43:55.131 T:726      INFO <general>: Loading resource://resource.uisounds.kodi/sounds.xml
2022-09-21 01:43:55.264 T:726      INFO <general>:   skin loaded...
2022-09-21 01:43:55.264 T:726      INFO <general>: Loading skin file: Startup.xml, load type: LOAD_EVERY_TIME
2022-09-21 01:43:55.265 T:726      INFO <general>: Loading skin file: Home.xml, load type: KEEP_IN_MEMORY
2022-09-21 01:43:55.477 T:726     ERROR <general>: SQL: [kodi_music82] The table does not exist
                                                   Query: select count(idSong) as NumSongs from songview 
                                                   
2022-09-21 01:43:55.478 T:726     ERROR <general>: GetSongsCount() failed
2022-09-21 01:43:56.421 T:726   WARNING <general>: JSONRPC: Could not parse type "Setting.Details.SettingList"
2022-09-21 01:43:56.422 T:726      INFO <general>: JSONRPC: Adding type "Setting.Details.SettingList" to list of incomplete definitions (waiting for "Setting.Details.Setting")
2022-09-21 01:43:56.425 T:726      INFO <general>: JSONRPC: Resolving incomplete types/methods referencing Setting.Details.Setting
2022-09-21 01:43:56.510 T:726      INFO <general>: JSONRPC v12.4.0: Successfully initialized
2022-09-21 01:43:56.530 T:726      INFO <general>: Register - new keyboard device registered on application->keyboard: Keyboard (0000:0000)
2022-09-21 01:43:56.532 T:726      INFO <general>: Register - new mouse device registered on application->mouse: Mouse (0000:0000)
2022-09-21 01:43:56.545 T:726      INFO <general>: Loading player core factory settings from special://xbmc/system/playercorefactory.xml.
2022-09-21 01:43:56.546 T:726      INFO <general>: Loaded playercorefactory configuration
2022-09-21 01:43:56.547 T:726      INFO <general>: Loading player core factory settings from special://masterprofile/playercorefactory.xml.
2022-09-21 01:43:56.547 T:726      INFO <general>: special://masterprofile/playercorefactory.xml does not exist. Skipping.
2022-09-21 01:43:56.547 T:726      INFO <general>: removing tempfiles
2022-09-21 01:43:56.559 T:726      INFO <general>: initialize done
2022-09-21 01:43:56.560 T:726      INFO <general>: Running the application...
2022-09-21 01:43:56.561 T:761      INFO <general>: initializing python engine.
2022-09-21 01:43:56.573 T:726      INFO <general>: starting zeroconf publishing
2022-09-21 01:43:56.573 T:726      INFO <general>: starting upnp client
2022-09-21 01:43:56.585 T:726      INFO <general>: starting upnp server
2022-09-21 01:43:56.593 T:726      INFO <general>: starting upnp renderer
2022-09-21 01:43:56.607 T:772      INFO <general>: ES: Starting UDP Event server on port 9777
2022-09-21 01:43:56.607 T:772      INFO <general>: UDP: Listening on port 9777 (ipv6 : true)
2022-09-21 01:43:56.607 T:726      INFO <general>: JSONRPC Server: Successfully initialized
2022-09-21 01:43:56.609 T:726      INFO <CWebserver[80]>: Started
2022-09-21 01:43:56.623 T:757      INFO <general>: Register - new cec device registered on cec->Linux: CEC Adapter (0000:0000)
2022-09-21 01:43:56.732 T:752     ERROR <general>: SQL: [kodi_music82] The table does not exist
                                                   Query: SELECT songview.*, songartistview.* FROM (SELECT idAlbum, dateAdded FROM album ORDER BY dateAdded DESC LIMIT 10) AS recentalbums JOIN songview ON songview.idAlbum = recentalbums.idAlbum JOIN songartistview ON songview.idSong = songartistview.idSong ORDER BY recentalbums.dateAdded DESC, songview.idAlbum DESC, songview.idSong, songartistview.idRole, songartistview.iOrder 
                                                   
2022-09-21 01:43:56.732 T:752     ERROR <general>: GetRecentlyAddedAlbumSongs failed
2022-09-21 01:43:56.734 T:752     ERROR <general>: SQL: [kodi_music82] The table does not exist
                                                   Query: SELECT albumview.*, albumartistview.* FROM (SELECT idAlbum FROM album WHERE strAlbum != '' ORDER BY dateAdded DESC LIMIT 10) AS recentalbums JOIN albumview ON albumview.idAlbum = recentalbums.idAlbum JOIN albumartistview ON albumview.idAlbum = albumartistview.idAlbum ORDER BY dateAdded DESC, albumview.idAlbum desc, albumartistview.iOrder 
                                                   
2022-09-21 01:43:56.734 T:752     ERROR <general>: GetRecentlyAddedAlbums failed
2022-09-21 01:43:57.316 T:752     ERROR <general>: SQL: [kodi_video119] The table does not exist
                                                   Query: select * from movie_view  ORDER BY dateAdded desc, idMovie desc LIMIT 10
                                                   
2022-09-21 01:43:57.317 T:752     ERROR <general>: GetMoviesByWhere failed
2022-09-21 01:43:57.319 T:752     ERROR <general>: SQL: [kodi_video119] The table does not exist
                                                   Query: select * from episode_view  ORDER BY dateAdded desc, idEpisode desc LIMIT 10
                                                   
2022-09-21 01:43:57.319 T:752     ERROR <general>: GetEpisodesByWhere failed
2022-09-21 01:43:57.322 T:752     ERROR <general>: SQL: [kodi_video119] The table does not exist
                                                   Query: select * from musicvideo_view  ORDER BY dateAdded desc, idMVideo desc LIMIT 10
                                                   
2022-09-21 01:43:57.322 T:752     ERROR <general>: GetMusicVideosByWhere failed
2022-09-21 01:43:57.413 T:752     ERROR <general>: SQL: [kodi_music82] The table does not exist
                                                   Query: SELECT COUNT(1) FROM artistview  WHERE (EXISTS (SELECT 1 FROM song_artist WHERE song_artist.idArtist = artistview.idArtist AND song_artist.idRole = 1) OR EXISTS (SELECT 1 FROM album_artist WHERE album_artist.idArtist = artistview.idArtist)) AND (artistview.strArtist != '')
                                                   
2022-09-21 01:43:57.413 T:752     ERROR <general>: GetSingleValueInt - failed on query 'SELECT COUNT(1) FROM artistview  WHERE (EXISTS (SELECT 1 FROM song_artist WHERE song_artist.idArtist = artistview.idArtist AND song_artist.idRole = 1) OR EXISTS (SELECT 1 FROM album_artist WHERE album_artist.idArtist = artistview.idArtist)) AND (artistview.strArtist != '')'
2022-09-21 01:43:57.414 T:752     ERROR <general>: SQL: [kodi_music82] The table does not exist
                                                   Query: SELECT count(1) FROM songview LIMIT 1
                                                   
2022-09-21 01:43:57.415 T:752     ERROR <general>: GetSingleValue - failed on query 'SELECT count(1) FROM songview LIMIT 1'
2022-09-21 01:43:57.416 T:752     ERROR <general>: SQL: [kodi_music82] The table does not exist
                                                   Query: SELECT count(distinct strAlbum) FROM songview LIMIT 1
                                                   
2022-09-21 01:43:57.416 T:752     ERROR <general>: GetSingleValue - failed on query 'SELECT count(distinct strAlbum) FROM songview LIMIT 1'
2022-09-21 01:43:57.493 T:752     ERROR <general>: SQL: [kodi_video119] The table does not exist
                                                   Query: SELECT count(1) FROM tvshow_view LIMIT 1
                                                   
2022-09-21 01:43:57.494 T:752     ERROR <general>: GetSingleValue - failed on query 'SELECT count(1) FROM tvshow_view LIMIT 1'
2022-09-21 01:43:57.495 T:752     ERROR <general>: SQL: [kodi_video119] The table does not exist
                                                   Query: SELECT count(1) FROM movie_view LIMIT 1
                                                   
2022-09-21 01:43:57.495 T:752     ERROR <general>: GetSingleValue - failed on query 'SELECT count(1) FROM movie_view LIMIT 1'
2022-09-21 01:43:57.496 T:752     ERROR <general>: SQL: [kodi_video119] The table does not exist
                                                   Query: SELECT count(playCount) FROM movie_view LIMIT 1
                                                   
2022-09-21 01:43:57.496 T:752     ERROR <general>: GetSingleValue - failed on query 'SELECT count(playCount) FROM movie_view LIMIT 1'
2022-09-21 01:43:57.497 T:752     ERROR <general>: SQL: [kodi_video119] The table does not exist
                                                   Query: SELECT count(1) FROM musicvideo_view LIMIT 1
                                                   
2022-09-21 01:43:57.498 T:752     ERROR <general>: GetSingleValue - failed on query 'SELECT count(1) FROM musicvideo_view LIMIT 1'
2022-09-21 01:43:57.499 T:752     ERROR <general>: SQL: [kodi_video119] The table does not exist
                                                   Query: SELECT count(playCount) FROM musicvideo_view LIMIT 1
                                                   
2022-09-21 01:43:57.499 T:752     ERROR <general>: GetSingleValue - failed on query 'SELECT count(playCount) FROM musicvideo_view LIMIT 1'
2022-09-21 01:43:57.500 T:752     ERROR <general>: SQL: [kodi_video119] The table does not exist
                                                   Query: SELECT sum(watchedcount) FROM tvshow_view LIMIT 1
                                                   
2022-09-21 01:43:57.500 T:752     ERROR <general>: GetSingleValue - failed on query 'SELECT sum(watchedcount) FROM tvshow_view LIMIT 1'
2022-09-21 01:43:57.501 T:752     ERROR <general>: SQL: [kodi_video119] The table does not exist
                                                   Query: SELECT sum(totalcount) FROM tvshow_view LIMIT 1
                                                   
2022-09-21 01:43:57.501 T:752     ERROR <general>: GetSingleValue - failed on query 'SELECT sum(totalcount) FROM tvshow_view LIMIT 1'
2022-09-21 01:43:57.502 T:752     ERROR <general>: SQL: [kodi_video119] The table does not exist
                                                   Query: SELECT sum(watchedcount = totalcount) FROM tvshow_view LIMIT 1
                                                   
2022-09-21 01:43:57.502 T:752     ERROR <general>: GetSingleValue - failed on query 'SELECT sum(watchedcount = totalcount) FROM tvshow_view LIMIT 1'
2022-09-21 01:43:59.300 T:773      INFO <general>: JSONRPC Server: New connection added
2022-09-21 01:43:59.884 T:761      INFO <general>: SETTINGS: set_keyboard_layout # us
2022-09-21 01:43:59.884 T:761      INFO <general>: SETTINGS: set_keyboard_layout # loadkmap < `ls -1 /usr/lib/keymaps/*/us.bmap`
2022-09-21 01:44:02.257 T:761      INFO <general>: ## LibreELEC Addon ## updates::updateThread ## Started
2022-09-21 01:44:02.260 T:761      INFO <general>: ## LibreELEC Addon ## updates::set_auto_update ## manual
2022-09-21 01:44:02.448 T:832      INFO <general>: SETTINGS: run # Waiting
2022-09-21 01:45:28.405 T:726      INFO <general>: Samba is idle. Closing the remaining connections

Display More

When i start scanning the library it produces a lot of errors about missing tables, and when it's all done there is nothing to list...

Code

2022-09-21 02:13:52.196 T:726     ERROR <general>: SQL: [kodi_video119] The table does not exist                                                                          
                                                   Query: select * from movie_view  WHERE c23=1  

# ... then tryign to populate it, tons of errors like this appear
2022-09-21 13:00:58.551 T:7998    ERROR <general>: GetEpisodesByWhere failed
2022-09-21 13:01:20.833 T:8008    ERROR <general>: SQL: [kodi_video119] The table does not exist
                                                   Query: SELECT COUNT(1) FROM tvshow_view 
                                                   
2022-09-21 13:01:20.833 T:8008    ERROR <general>: GetSingleValue - failed on query 'SELECT COUNT(1) FROM tvshow_view '
2022-09-21 13:01:20.835 T:8008    ERROR <general>: SQL: [kodi_video119] The table does not exist
                                                   Query: SELECT * FROM tvshow_view  LIMIT 157
                                                   
2022-09-21 13:01:20.835 T:8008    ERROR <general>: GetTvShowsByWhere failed
2022-09-21 13:01:20.923 T:8008    ERROR <general>: SQL: [kodi_video119] The table does not exist
                                                   Query: select COUNT(1) from episode_view 
                                                   
2022-09-21 13:01:20.923 T:8008    ERROR <general>: GetSingleValue - failed on query 'select COUNT(1) from episode_view '
2022-09-21 13:01:20.924 T:8008    ERROR <general>: SQL: [kodi_video119] The table does not exist
                                                   Query: select * from episode_view  LIMIT 814
                                                   
2022-09-21 13:01:20.924 T:8008    ERROR <general>: GetEpisodesByWhere failed
2022-09-21 13:01:26.358 T:8008    ERROR <general>: SQL: [kodi_video119] The table does not exist
                                                   Query: select * from movie_view 
                                                   
2022-09-21 13:01:26.358 T:8008    ERROR <general>: GetMoviesByWhere failed
2022-09-21 13:01:28.168 T:8030    ERROR <general>: SQL: [kodi_video119] The table does not exist
                                                   Query: select * from movie_view  JOIN sets ON movie_view.idSet = sets.idSet ORDER BY sets.idSet
                                                   
2022-09-21 13:01:28.168 T:8030    ERROR <general>: GetMoviesByWhere failed
2022-09-21 13:01:28.301 T:8030    ERROR <general>: SQL: [kodi_video119] The table does not exist
                                                   Query: select COUNT(1) from movie_view 
                                                   
2022-09-21 13:01:28.301 T:8030    ERROR <general>: GetSingleValue - failed on query 'select COUNT(1) from movie_view '
2022-09-21 13:01:28.303 T:8030    ERROR <general>: SQL: [kodi_video119] The table does not exist
                                                   Query: select * from movie_view  LIMIT 472

Display More

I can't populate the database (from scratch at all). I've tried droping all databases several times and powering back up the Kodi instance (LibrELEC) and it consistently produces the same results.

Before i fall back to an ealier working version, i don't mind working with devs to help debug... Also it could very well be the user ; Perhaps you can spot something obvious i'm missing other then having just the DB ready to be written to? Is there another step i need to do first? Or is there a spot i could load the schema manually and jsut run from then?

nuxref · September 21, 2022 at 11:26 PM

So it turned out to be that this is NOT valid even though it works:

Code

GRANT ALL ON `kodi_video%`.* TO 'kodi';
GRANT ALL ON `kodi_music%`.* TO 'kodi';
FLUSH PRIVILEGES;

This however fixes the problem:

Code

GRANT ALL ON *.* TO 'kodi';
FLUSH PRIVILEGES;

Just sharing in case someone else stumbles across the same issue

LibreELEC Clean MySQL Install of v10.0.2 Fails

Summary

Logs

Similar Threads

mariadb and databases not being created properly