Beta 3 – MySQL library support broken

Hi,
my Android media player box is a MK902II with a Rockchip 3288 SoC. My Android Version is 5.1.1. I run a central MySQL database for storing the music and video library on a linux home server. The other media players running Kodi are PCs. Until Isengard everything worked well. I could continue a movie that was started on a different media player.

Starting with Krypton the Android box doesn’t even start if I set my mysql library. Once a local store is configured everything turns back to normal. My log doesn’t show anything unusual (as far as I understand).

Some additional observations

  • It only occurs when accessing a database migrated by another (PC) Kodi installation. If the conversion was done by the Android box it works.
  • If the PCs make changes in the database the Android Kodi breaks again

Kodi log

Code:
19:25:27 T:18446744072512401392  NOTICE: special://profile/ is mapped to: special://masterprofile/
19:25:27 T:18446744072512401392  NOTICE: Previous line repeats 1 times.
19:25:27 T:18446744072512401392  NOTICE: -----------------------------------------------------------------------
19:25:27 T:18446744072512401392  NOTICE: Starting Kodi (17.0-BETA3 Git:20161004-df45f18). Platform: Android ARM 32-bit
19:25:27 T:18446744072512401392  NOTICE: Using Unknown Kodi x32 build
19:25:27 T:18446744072512401392  NOTICE: Kodi compiled Oct  4 2016 by GCC 4.8.0 for Android ARM 32-bit API level 17 (API level 17)
19:25:27 T:18446744072512401392  NOTICE: Running on rockchip RKM MK902II with Android 5.1.1 API level 22, kernel: Linux ARM 32-bit version 3.10.0
19:25:27 T:18446744072512401392  NOTICE: FFmpeg version/source: ffmpeg-3.1-kodi
19:25:27 T:18446744072512401392  NOTICE: Host CPU: ARMv7 Processor rev 1 (v7l), 4 cores available
19:25:27 T:18446744072512401392  NOTICE: Product: rk3288_box, Device: rk3288_box, Board: rk30sdk - Manufacturer: rockchip, Brand: RKM, Model: RKM MK902II, Hardware: rk30board
19:25:27 T:18446744072512401392  NOTICE: External storage path = /mnt/internal_sd; status = ok
19:25:27 T:18446744072512401392  NOTICE: ARM Features: Neon enabled
19:25:27 T:18446744072512401392  NOTICE: special://xbmc/ is mapped to: /data/data/org.xbmc.kodi/cache/apk/assets
19:25:27 T:18446744072512401392  NOTICE: special://xbmcbin/ is mapped to: /data/data/org.xbmc.kodi/cache/apk/assets
19:25:27 T:18446744072512401392  NOTICE: special://xbmcbinaddons/ is mapped to: /data/app/org.xbmc.kodi-1/lib/arm
19:25:27 T:18446744072512401392  NOTICE: special://masterprofile/ is mapped to: /mnt/internal_sd/Android/data/org.xbmc.kodi/files/.kodi/userdata
19:25:27 T:18446744072512401392  NOTICE: special://envhome/ is mapped to: /mnt/internal_sd/Android/data/org.xbmc.kodi/files
19:25:27 T:18446744072512401392  NOTICE: special://home/ is mapped to: /mnt/internal_sd/Android/data/org.xbmc.kodi/files/.kodi
19:25:27 T:18446744072512401392  NOTICE: special://temp/ is mapped to: /mnt/internal_sd/Android/data/org.xbmc.kodi/files/.kodi/temp
19:25:27 T:18446744072512401392  NOTICE: special://logpath/ is mapped to: /mnt/internal_sd/Android/data/org.xbmc.kodi/files/.kodi/temp
19:25:27 T:18446744072512401392  NOTICE: The executable running is: /system/bin/app_process32_original
19:25:27 T:18446744072512401392  NOTICE: Local hostname: mediaplaye-sz
19:25:27 T:18446744072512401392  NOTICE: Log File is located: /mnt/internal_sd/Android/data/org.xbmc.kodi/files/.kodi/temp//kodi.log
19:25:27 T:18446744072512401392  NOTICE: -----------------------------------------------------------------------
19:25:27 T:18446744072512401392  NOTICE: load settings...
19:25:27 T:18446744072512401392   DEBUG: CSettings: loaded settings definition from special://xbmc/system/settings/settings.xml
19:25:27 T:18446744072512401392 WARNING: CSettingInt: unknown options filler "audiocdactions" of "audiocds.autoaction"
19:25:27 T:18446744072512401392   DEBUG: CSettings: loaded settings definition from special://xbmc/system/settings/android.xml
19:25:27 T:18446744072512401392   DEBUG: AESinkAUDIOTRACK - 32000 supported
19:25:27 T:18446744072512401392   DEBUG: AESinkAUDIOTRACK - 44100 supported
19:25:27 T:18446744072512401392   DEBUG: AESinkAUDIOTRACK - 48000 supported
19:25:27 T:18446744072512401392   DEBUG: AESinkAUDIOTRACK - 96000 supported
19:25:27 T:18446744072512401392  NOTICE: Found 1 Lists of Devices
19:25:27 T:18446744072512401392  NOTICE: Enumerated AUDIOTRACK devices:
19:25:27 T:18446744072512401392  NOTICE:     Device 1
19:25:27 T:18446744072512401392  NOTICE:         m_deviceName      : AudioTrack
19:25:27 T:18446744072512401392  NOTICE:         m_displayName     : android
19:25:27 T:18446744072512401392  NOTICE:         m_displayNameExtra: audiotrack
19:25:27 T:18446744072512401392  NOTICE:         m_deviceType      : AE_DEVTYPE_HDMI
19:25:27 T:18446744072512401392  NOTICE:         m_channels        : FL,FR,FC,LFE,BL,BR,SL,SR
19:25:27 T:18446744072512401392  NOTICE:         m_sampleRates     : 32000,44100,48000,96000
19:25:27 T:18446744072512401392  NOTICE:         m_dataFormats     : AE_FMT_S16LE,AE_FMT_RAW
19:25:27 T:18446744072512401392  NOTICE:         m_streamTypes     : STREAM_TYPE_AC3,STREAM_TYPE_EAC3
19:25:27 T:18446744072512401392   DEBUG: CSkinSettings: no <skinsettings> tag found
19:25:27 T:18446744072512401392  NOTICE: No settings file to load (special://xbmc/system/advancedsettings.xml)
19:25:27 T:18446744072512401392  NOTICE: Loaded settings file from special://profile/advancedsettings.xml
19:25:27 T:18446744072512401392  NOTICE: Contents of special://profile/advancedsettings.xml are...
                                            <advancedsettings>
                                              <videodatabase>
                                                <type>mysql</type>
                                                <host>192.168.1.200</host>
                                                <port>3306</port>
                                                <user>myuser</user>
                                                <pass>mypass</pass>
                                                <name>kodi_video</name>
                                              </videodatabase>
                                              <musicdatabase>
                                                <type>mysql</type>
                                                <host>192.168.1.200</host>
                                                <port>3306</port>
                                                <user>myuser</user>
                                                <pass>mypass</pass>
                                                <name>kodi_music</name>
                                              </musicdatabase>
                                              <videolibrary>
                                                <allitemsonbottom>false</allitemsonbottom>
                                                <!-- sorts the "*All" items at the bottom of the list when in Ascending order -->
                                                <backgroundupdate>false</backgroundupdate>
                                                <!-- set to hide the video scanner dialog from the gui -->
                                                <!-- NOTE: To get this working properly, you have to do a 'Clean Library' in settings the first time after you enable the setting. -->
                                                <cleanonupdate>false</cleanonupdate>
                                                <!-- default set to false to prevent xbmc from removing items from the database while updating.  -->
                                                <hideallitems>false</hideallitems>
                                                <!-- removes the "*All" items from the video library -->
                                                <hideemptyseries>false</hideemptyseries>
                                                <!-- hide empty series in the video library -->
                                                <recentlyaddeditems>35</recentlyaddeditems>
                                                <!-- number of recently added items. Defaults to 25 -->
                                                <itemseparator> / </itemseparator>
                                                <!-- separator used for multiple artists/genres in tags. Note, this is *space* *slash* *space* -->
                                                <exportautothumbs>true</exportautothumbs>
                                                <!-- export auto-generated thumbs. Defaults to false -->
                                                <importwatchedstate>true</importwatchedstate>
                                                <!-- import previously exported playdate and playcount from .nfo files. Defaults to false -->
                                                <importresumepoint>true</importresumepoint>
                                                <!-- import previously exported resume point from .nfo files. Defaults to false -->
                                                <mymovies>
                                                  <!-- Options specific to MyMovies XML file parsing -->
                                                  <categoriestogenres>false</categoriestogenres>
                                                  <!-- Add MyMovies Custom Categories to {{subst:Name}} Genres (boolean, default is false) -->
                                                </mymovies>
                                                <dateadded>1</dateadded>
                                                <!-- 0 results in using the current datetime when adding a video;
                                                                             1 (default) results in prefering to use the files mtime (if it's valid) and only using the file's ctime if the mtime isn't valid;
                                                                             2 results in using the newer datetime of the file's mtime and ctime -->
                                              </videolibrary>
                                              <musiclibrary>
                                                <itemseparator>/</itemseparator>
                                              </musiclibrary>
                                              <video>
                                                <cleanstrings>
                                                  <cleanstrings append="yes" />
                                                  <regexp>[ _\,\.\(\)\[\]\-](ac3|dts|custom|dc|divx|divx5|dsr|dsrip|dutch|dvd|dvdrip|dvdscr|dvdscreener|scre​ener|dvdivx|cam|fragment|fs|hd
tv|hdrip|hdtvrip|internal|limited|multisubs|ntsc|ogg|ogm|pal|pdtv|proper|repack|​rerip|retail|r3|r5|bd5|se|svcd|en|englisch|de|deutsch|english|german|read.nfo|nf​ofix|unrated|ws|telesync|t
s|telecine|tc|brrip|bdrip|480|480p|480i|576|576p|576i|720|720p|720i|1080|1080p|1​080i|hrhd|hrhdtv|hddvd|bluray|x264|h264|xvid|xvidvd|xxx|www.www|cd[1-9]|\[.*\])([ _\,\.\(\)\[\]\-]|$)</reg
exp>
                                                  <regexp>(\[.*\])</regexp>
                                                </cleanstrings>
                                              </video>
                                              <pictureextensions>
                                                <remove>.cr2|.dng|.lrcat|.lrprev|.tmp|.pdf|.db|.lrmprev|.pub|.indd|.psa|.ai|.xps|.ttf​|.eps|.thm|.zip|.pano|.onetoc|.url</remove>
                                              </pictureextensions>
                                            </advancedsettings>
19:25:27 T:18446744072512401392 WARNING: VIDEO database configuration is experimental.
19:25:27 T:18446744072512401392  NOTICE: Default Video Player: VideoPlayer
19:25:27 T:18446744072512401392  NOTICE: Default Audio Player: paplayer
19:25:27 T:18446744072512401392  NOTICE: Disabled debug logging due to GUI setting. Level 0.
19:25:27 T:18446744072512401392  NOTICE: Log level changed to "LOG_LEVEL_NORMAL"
19:25:27 T:18446744072512401392  NOTICE: CMediaSourceSettings: loading media sources from special://masterprofile/sources.xml
19:25:27 T:18446744072512401392  NOTICE: Loading player core factory settings from special://xbmc/system/playercorefactory.xml.
19:25:27 T:18446744072512401392  NOTICE: Loaded playercorefactory configuration
19:25:27 T:18446744072512401392  NOTICE: Loading player core factory settings from special://masterprofile/playercorefactory.xml.
19:25:27 T:18446744072512401392  NOTICE: special://masterprofile/playercorefactory.xml does not exist. Skipping.
19:25:27 T:18446744072512401392  NOTICE: Running database version Addons26
19:25:27 T:18446744072512401392  NOTICE: ADDONS: Using repository repository.xbmc.org
19:25:27 T:18446744072514072776 WARNING: ActiveAE::void ActiveAE::CActiveAE::Configure(AEAudioFormat*) - sink returned large buffer of 185 ms, reducing to 100 ms
19:25:27 T:18446744072512401392  NOTICE: virtual bool CWinSystemEGL::InitWindowSystem(): Using EGL Implementation: android
19:25:27 T:18446744072512401392  NOTICE: CEGLNativeTypeAndroid: Switching to resolution:
19:25:27 T:18446744072512401392  NOTICE: Current resolution: 1920x1080 @ 60.00 - Full Screen
19:25:27 T:18446744072512401392  NOTICE: Previous line repeats 1 times.
19:25:27 T:18446744072512401392  NOTICE: Found resolution 1920 x 1080 for display 0 with 1920 x 1080 @ 60.000004 Hz
19:25:27 T:18446744072512401392  NOTICE: Found ([email protected]) at 16, setting to RES_DESKTOP at 16
19:25:27 T:18446744072512401392  NOTICE: Checking resolution 16
19:25:27 T:18446744072512401392  NOTICE: Current resolution: 1920x1080 @ 60.00 - Full Screen
19:25:28 T:18446744072512401392  NOTICE: CEGLNativeTypeAndroid: Switching to resolution: 1920x1080 @ 60.00 - Full Screen
19:25:28 T:18446744072512401392  NOTICE: GL_VENDOR = ARM
19:25:28 T:18446744072512401392  NOTICE: GL_RENDERER = Mali-T760
19:25:28 T:18446744072512401392  NOTICE: GL_RENDERER = Mali-T760
19:25:28 T:18446744072512401392  NOTICE: GL_VERSION = OpenGL ES 3.1 v1.r6p0-02rel0.0f4218be5cc66c20a4f31b6cc856ee46
19:25:28 T:18446744072512401392  NOTICE: GL_SHADING_LANGUAGE_VERSION = OpenGL ES GLSL ES 3.10
19:25:28 T:18446744072512401392  NOTICE: GL_EXTENSIONS = GL_EXT_debug_marker GL_ARM_rgba8 GL_ARM_mali_shader_binary GL_OES_depth24 GL_OES_depth_texture GL_OES_depth_texture_cube_map GL_O
ES_packed_depth_stencil GL_OES_rgb8_rgba8 GL_EXT_read_format_bgra GL_OES_compressed_paletted_texture GL_OES_compressed_ETC1_RGB8_texture GL_OES_standard_derivatives GL_OES_EGL_image GL_O
ES_EGL_image_external GL_OES_EGL_sync GL_OES_texture_npot GL_OES_vertex_half_float GL_OES_required_internalformat GL_OES_vertex_array_object GL_OES_mapbuffer GL_EXT_texture_format_BGRA88
88 GL_EXT_texture_rg GL_EXT_texture_type_2_10_10_10_REV GL_OES_fbo_render_mipmap GL_OES_element_index_uint GL_EXT_shadow_samplers GL_OES_texture_compression_astc GL_KHR_texture_compressi
on_astc_ldr GL_KHR_texture_compression_astc_hdr GL_KHR_debug GL_EXT_occlusion_query_boolean GL_EXT_disjoint_timer_query GL_EXT_blend_minmax GL_EXT_discard_framebuffer GL_OES_get_program_
binary GL_OES_texture_3D GL_EXT_texture_storage GL_EXT_multisampled_render_to_texture GL_OES_surfaceless_context GL_OES_texture_stencil8 GL_EXT_shader_pixel_local_storage GL_ARM_shader_f
ramebuffer_fetch GL_ARM_shader_framebuffer_fetch_depth_stencil GL_ARM_mali_program_binary GL_EXT_sRGB GL_EXT_sRGB_write_control GL_EXT_texture_sRGB_decode GL_KHR_blend_equation_advanced
GL_KHR_blend_equation_advanced_coherent GL_OES_texture_storage_multisample_2d_array GL_OES_shader_image_atomic GL_EXT_robustness GL_EXT_draw_buffers_indexed GL_OES_draw_buffers_indexed G
L_EXT_texture_border_clamp GL_OES_texture_border_clamp GL_EXT_texture_cube_map_array GL_OES_texture_cube_map_array GL_OES_sample_variables GL_OES_sample_shading GL_OES_shader_multisample
_interpolation GL_EXT_gpu_shader5 GL_OES_gpu_shader5 GL_EXT_texture_buffer GL_OES_texture_buffer
19:25:28 T:18446744072514072776 WARNING: ActiveAE::void ActiveAE::CActiveAE::Configure(AEAudioFormat*) - sink returned large buffer of 185 ms, reducing to 100 ms
19:25:28 T:18446744072512401392  NOTICE: Current resolution: 1920x1080 @ 60.00 - Full Screen
19:25:28 T:18446744072512401392  NOTICE: Running database version Addons26
19:25:28 T:18446744072512401392  NOTICE: Running database version ViewModes6
19:25:28 T:18446744072512401392  NOTICE: Running database version Textures13
19:25:28 T:18446744072512401392  NOTICE: Running database version kodi_music60
19:25:28 T:18446744072512401392  NOTICE: Running database version kodi_video107
19:25:28 T:18446744072512401392  NOTICE: Running database version TV29
19:25:28 T:18446744072512401392  NOTICE: Running database version Epg11
19:25:28 T:18446744072512401392 WARNING: JSONRPC: Could not parse type "Setting.Details.SettingList"
19:25:28 T:18446744072512401392   ERROR: JSONRPC: Unable to parse JSON Schema definition for ""
19:25:28 T:18446744072512401392   ERROR: JSONRPC: Invalid JSON Schema definition for method ""

Anyone sharing the same experience? Huh
Any ideas? Confused

Thanks
dolittle