BUG: kodi-rpi 16.0-1 with mysql database crashes

Development on core packages and the distribution goes on in here.

BUG: kodi-rpi 16.0-1 with mysql database crashes

Postby graysky » Thu Mar 03, 2016 11:09 pm

Kodi crashes on my RPi2 upon trying to connect to my mariadb which worked perfectly under the 15.x series. If I use a virgin kodi profile (ie without the info for it to connect to the mysqld in advancedsettings.xml, it works as expected).

When I inspect the kodi.service on the RPi2, I find this but am unsure how to proceed:

Code: Select all
% sudo journalctl -u kodi
Mar 03 18:04:46 bedroom systemd[1]: Started Starts an instance of Kodi.
Mar 03 18:04:48 bedroom kodi-standalone[1022]: /usr/lib/kodi/kodi.bin: relocation error: /usr/lib/kodi/kodi.bin: symbol mysql_init, version libmysqlclient_16 not defined in file libmysqlclient.so.18 with link time reference
Mar 03 18:04:50 bedroom kodi-standalone[1022]: /usr/lib/kodi/kodi.bin: relocation error: /usr/lib/kodi/kodi.bin: symbol mysql_init, version libmysqlclient_16 not defined in file libmysqlclient.so.18 with link time reference
Mar 03 18:04:53 bedroom kodi-standalone[1022]: /usr/lib/kodi/kodi.bin: relocation error: /usr/lib/kodi/kodi.bin: symbol mysql_init, version libmysqlclient_16 not defined in file libmysqlclient.so.18 with link time reference
Mar 03 18:04:53 bedroom kodi-standalone[1022]: /usr/bin/kodi --standalone -l /run/lirc/lircd has exited in an unclean state 3 times in the last 7 seconds.


Here is the complete kodi log:
Code: Select all
18:10:07 T:1949614080  NOTICE: special://profile/ is mapped to: special://masterprofile/
18:10:07 T:1949614080  NOTICE: -----------------------------------------------------------------------
18:10:07 T:1949614080  NOTICE: Starting Kodi (16.0 Git:Unknown). Platform: Linux ARM 32-bit
18:10:07 T:1949614080  NOTICE: Using Release Kodi x32 build (version for Raspberry Pi)
18:10:07 T:1949614080  NOTICE: Kodi compiled Mar  2 2016 by GCC 5.1.0 for Linux ARM 32-bit version 4.4.1 (263169)
18:10:07 T:1949614080  NOTICE: Running on Arch Linux ARM rolling, kernel: Linux ARM 32-bit version 4.1.18-3-ARCH
18:10:07 T:1949614080  NOTICE: FFmpeg statically linked, version: 2.8.6-kodi-2.8.6-Jarvis-16.0
18:10:07 T:1949614080  NOTICE: Host CPU: ARMv7 Processor rev 5 (v7l), 4 cores available
18:10:07 T:1949614080  NOTICE: ARM Features: Neon enabled
18:10:07 T:1949614080  NOTICE: special://xbmc/ is mapped to: /usr/share/kodi
18:10:07 T:1949614080  NOTICE: special://xbmcbin/ is mapped to: /usr/lib/kodi
18:10:07 T:1949614080  NOTICE: special://masterprofile/ is mapped to: /var/lib/kodi/.kodi/userdata
18:10:07 T:1949614080  NOTICE: special://home/ is mapped to: /var/lib/kodi/.kodi
18:10:07 T:1949614080  NOTICE: special://temp/ is mapped to: /var/lib/kodi/.kodi/temp
18:10:07 T:1949614080  NOTICE: The executable running is: /usr/lib/kodi/kodi.bin
18:10:07 T:1949614080  NOTICE: Local hostname: bedroom
18:10:07 T:1949614080  NOTICE: Log File is located: /var/lib/kodi/.kodi/temp/kodi.log
18:10:07 T:1949614080  NOTICE: -----------------------------------------------------------------------
18:10:07 T:1949614080   ERROR: DBus: Error org.freedesktop.DBus.Error.InvalidArgs - No such property 'CanSuspend'
18:10:07 T:1949614080   ERROR: DBus: Error org.freedesktop.DBus.Error.InvalidArgs - No such property 'CanHibernate'
18:10:07 T:1949614080  NOTICE: load settings...
18:10:07 T:1949614080  NOTICE: Found 2 Lists of Devices
18:10:07 T:1949614080  NOTICE: Enumerated PI devices:
18:10:07 T:1949614080  NOTICE:     Device 1
18:10:07 T:1949614080  NOTICE:         m_deviceName      : HDMI
18:10:07 T:1949614080  NOTICE:         m_displayName     : HDMI
18:10:07 T:1949614080  NOTICE:         m_displayNameExtra:
18:10:07 T:1949614080  NOTICE:         m_deviceType      : AE_DEVTYPE_HDMI
18:10:07 T:1949614080  NOTICE:         m_channels        : FL,FR
18:10:07 T:1949614080  NOTICE:         m_sampleRates     : 8000,11025,16000,22050,24000,32000,44100,48000,88200,96000,176400,192000
18:10:07 T:1949614080  NOTICE:         m_dataFormats     : AE_FMT_FLOAT,AE_FMT_S32NE,AE_FMT_S16NE,AE_FMT_S32LE,AE_FMT_S16LE,AE_FMT_FLOATP,AE_FMT_S32NEP,AE_FMT_S16NEP,AE_FMT_AC3,AE_FMT_DTS,AE_FMT_EAC3
18:10:07 T:1949614080  NOTICE:     Device 2
18:10:07 T:1949614080  NOTICE:         m_deviceName      : Analogue
18:10:07 T:1949614080  NOTICE:         m_displayName     : Analogue
18:10:07 T:1949614080  NOTICE:         m_displayNameExtra:
18:10:07 T:1949614080  NOTICE:         m_deviceType      : AE_DEVTYPE_PCM
18:10:07 T:1949614080  NOTICE:         m_channels        : FL,FR
18:10:07 T:1949614080  NOTICE:         m_sampleRates     : 48000
18:10:07 T:1949614080  NOTICE:         m_dataFormats     : AE_FMT_FLOAT,AE_FMT_S32LE,AE_FMT_S16LE,AE_FMT_FLOATP,AE_FMT_S32NEP,AE_FMT_S16NEP
18:10:07 T:1949614080  NOTICE:     Device 3
18:10:07 T:1949614080  NOTICE:         m_deviceName      : Both
18:10:07 T:1949614080  NOTICE:         m_displayName     : HDMI and Analogue
18:10:07 T:1949614080  NOTICE:         m_displayNameExtra:
18:10:07 T:1949614080  NOTICE:         m_deviceType      : AE_DEVTYPE_PCM
18:10:07 T:1949614080  NOTICE:         m_channels        : FL,FR
18:10:07 T:1949614080  NOTICE:         m_sampleRates     : 48000
18:10:07 T:1949614080  NOTICE:         m_dataFormats     : AE_FMT_FLOAT,AE_FMT_S32LE,AE_FMT_S16LE,AE_FMT_FLOATP,AE_FMT_S32NEP,AE_FMT_S16NEP
18:10:07 T:1949614080  NOTICE: Enumerated ALSA devices:
18:10:07 T:1949614080  NOTICE:     Device 1
18:10:07 T:1949614080  NOTICE:         m_deviceName      : @
18:10:07 T:1949614080  NOTICE:         m_displayName     : Default (bcm2835 ALSA bcm2835 ALSA)
18:10:07 T:1949614080  NOTICE:         m_displayNameExtra:
18:10:07 T:1949614080  NOTICE:         m_deviceType      : AE_DEVTYPE_PCM
18:10:07 T:1949614080  NOTICE:         m_channels        : FL,FR
18:10:07 T:1949614080  NOTICE:         m_sampleRates     : 8000,11025,16000,22050,32000,44100,48000
18:10:07 T:1949614080  NOTICE:         m_dataFormats     : AE_FMT_S16NE,AE_FMT_S16LE,AE_FMT_U8
18:10:07 T:1949614080  NOTICE: Loaded settings file from special://xbmc/system/advancedsettings.xml
18:10:07 T:1949614080  NOTICE: Contents of special://xbmc/system/advancedsettings.xml are...
                                            <?xml version="1.0" encoding="UTF-8" ?>
                                            <advancedsettings>
                                              <video>
                                                <defaultplayer>dvdplayer</defaultplayer>
                                                <defaultdvdplayer>dvdplayer</defaultdvdplayer>
                                              </video>
                                            </advancedsettings>
18:10:07 T:1949614080  NOTICE: Loaded settings file from special://profile/advancedsettings.xml
18:10:07 T:1949614080  NOTICE: Contents of special://profile/advancedsettings.xml are...
                                            <advancedsettings>
                                              <videodatabase>
                                                <type>mysql</type>
                                                <host>192.168.1.100</host>
                                                <port>3306</port>
                                                <user>xbmc</user>
                                                <pass>xbmc</pass>
                                              </videodatabase>
                                              <musicdatabase>
                                                <type>mysql</type>
                                                <host>192.168.1.100</host>
                                                <port>3306</port>
                                                <user>xbmc</user>
                                                <pass>xbmc</pass>
                                              </musicdatabase>
                                              <videolibrary>
                                                <importwatchedstate>true</importwatchedstate>
                                                <importresumepoint>true</importresumepoint>
                                              </videolibrary>
                                            </advancedsettings>
18:10:07 T:1949614080 WARNING: VIDEO database configuration is experimental.
18:10:07 T:1949614080  NOTICE: Default DVD Player: dvdplayer
18:10:07 T:1949614080  NOTICE: Default Video Player: dvdplayer
18:10:07 T:1949614080  NOTICE: Default Audio Player: paplayer
18:10:07 T:1949614080  NOTICE: Disabled debug logging due to GUI setting. Level 0.
18:10:07 T:1949614080  NOTICE: Log level changed to "LOG_LEVEL_NORMAL"
18:10:07 T:1949614080  NOTICE: CMediaSourceSettings: loading media sources from special://masterprofile/sources.xml
18:10:07 T:1949614080  NOTICE: Loading player core factory settings from special://xbmc/system/playercorefactory.xml.
18:10:07 T:1949614080  NOTICE: Loaded playercorefactory configuration
18:10:07 T:1949614080  NOTICE: Loading player core factory settings from special://masterprofile/playercorefactory.xml.
18:10:07 T:1949614080  NOTICE: special://masterprofile/playercorefactory.xml does not exist. Skipping.
18:10:07 T:1949614080  NOTICE: Running database version Addons20
18:10:07 T:1949614080  NOTICE: ADDONS: Using repository repository.xbmc.org
18:10:07 T:1949614080  NOTICE: Raspberry PI firmware version: Feb 29 2016 14:23:50
                                            Copyright (c) 2012 Broadcom
                                            version dea971b793dd6cf89133ede5a8362eb77e4f4ade (clean) (release)
18:10:07 T:1949614080  NOTICE: ARM mem: 880MB GPU mem: 128MB MPG2:0 WVC1:0
18:10:07 T:1949614080  NOTICE: Config:
                                            arm_freq=900
                                            audio_pwm_mode=1
                                            audio_sdm_mod_order=2
                                            config_hdmi_boost=5
                                            disable_commandline_tags=2
                                            disable_l2cache=1
                                            emmc_pll_core=1
                                            force_eeprom_read=1
                                            force_pwm_open=1
                                            framebuffer_ignore_alpha=1
                                            framebuffer_swap=1
                                            hdmi_channel_map=8
                                            hdmi_force_cec_address=65535
                                            init_uart_clock=0x2dc6c0
                                            lcd_framerate=60
                                            over_voltage_avs=0x1b774
                                            overscan_bottom=48
                                            overscan_left=48
                                            overscan_right=48
                                            overscan_top=48
                                            pause_burst_frames=1
                                            program_serial_random=1
                                            sdram_freq=450
                                            temp_limit=85
18:10:07 T:1949614080  NOTICE: Config:
                                            device_tree=-
18:10:07 T:1949614080  NOTICE: InitWindowSystem: Using EGL Implementation: raspberrypi
18:10:07 T:1949614080  NOTICE: Found resolution 1920 x 1080 for display 0 with 1920 x 1080 @ 60.000000 Hz
18:10:07 T:1949614080  NOTICE: Found (1920x1080@60.000000) at 16, setting to RES_DESKTOP at 16
18:10:07 T:1949614080  NOTICE: Checking resolution 16
18:10:07 T:1949614080  NOTICE: GL_VENDOR = Broadcom
18:10:07 T:1949614080  NOTICE: GL_RENDERER = VideoCore IV HW
18:10:07 T:1949614080  NOTICE: GL_VERSION = OpenGL ES 2.0
18:10:07 T:1949614080  NOTICE: GL_SHADING_LANGUAGE_VERSION = OpenGL ES GLSL ES 1.00
18:10:07 T:1949614080  NOTICE: GL_EXTENSIONS = GL_OES_compressed_ETC1_RGB8_texture GL_OES_compressed_paletted_texture GL_OES_texture_npot GL_OES_depth24 GL_OES_vertex_half_float GL_OES_EGL_image GL_OES_EGL_image_external GL_EXT_discard_framebuffer GL_OES_rgb8_rgba8 GL_OES_depth32 GL_OES_mapbuffer GL_EXT_texture_format_BGRA8888 GL_APPLE_rgb_422 GL_EXT_debug_marker
18:10:08 T:1949614080   ERROR: Window Translator: Can't find window tv
18:10:08 T:1949614080   ERROR: Previous line repeats 1 times.
18:10:08 T:1949614080   ERROR: Window Translator: Can't find window pvrosddirector
18:10:08 T:1949614080   ERROR: Window Translator: Can't find window pvrosdcutter
18:10:08 T:1949614080   ERROR: Window Translator: Can't find window tv
18:10:08 T:1949614080   ERROR: Previous line repeats 1 times.
18:10:08 T:1949614080   ERROR: Window Translator: Can't find window pvrosddirector
18:10:08 T:1949614080   ERROR: Window Translator: Can't find window pvrosdcutter
18:10:08 T:1949614080  NOTICE: Register - new cec device registered on cec->RPI: CEC Adapter (2708:1001)
18:10:09 T:1949614080  NOTICE: Running database version Addons20
18:10:09 T:1949614080  NOTICE: Running database version ViewModes6
18:10:09 T:1949614080  NOTICE: Running database version Textures13


EDIT: I have posted to the kodi forums as well.
graysky
 
Posts: 355
Joined: Sun Jun 26, 2011 6:56 am
Location: /run/user/1000

Re: BUG: kodi-rpi 16.0-1 with mysql database crashes

Postby moonman » Fri Mar 04, 2016 1:55 am

Well... This is unexpected since this kodi is compiled with gcc5.1
Pogoplug V4 | GoFlex Home | Raspberry Pi B 512 | CuBox-i4 Pro | ClearFog | BeagleBone Black | Odroid U2 | Odroid C1 | Odroid XU4
-----------------------------------------------------------------------------------------------------------------------
[armv5] Updated U-Boot | |[armv5] How to install my.pogoplug.com service | [armv5] NAND Rescue System
moonman
Developer
 
Posts: 3089
Joined: Sat Jan 15, 2011 3:36 am
Location: Calgary, Canada

Re: BUG: kodi-rpi 16.0-1 with mysql database crashes

Postby graysky » Fri Mar 04, 2016 11:49 am

One of the kodi folks from the thread I linked had some thoughts:
wsnipex wrote:anyway, looks like either kodi was linked against another mysql/mariadb version or similar.
Also -Ofast has been reported for causing issues.


Relevant to our package?

EDIT: I removed the -Ofast option from the PKGBUILD and compiled on my RPi2 (using the current gcc which I believe is 5.3.0-5) and I can use the resulting package with a fresh kodi profile (ie one not using the mysql database), but I get the same errors and crash when I try connecting to the mysqld as I did with the repo package.

EDIT2: I can also verify that the mysql database works fine by running kodi on a totally new x86_64 box using the advancedsettings.xml that allows the access so whatever is wrong seems to be with our packages :/
graysky
 
Posts: 355
Joined: Sun Jun 26, 2011 6:56 am
Location: /run/user/1000

Re: BUG: kodi-rpi 16.0-1 with mysql database crashes

Postby bolderbast » Sat Mar 05, 2016 8:31 am

Hi,

I have the same issue. This is my configuration:

Client: Raspberry Pi2
kodi-rbp 16.0-1
sqlite 3.11.0-2
libmariadbclient 10.1.12-2

Database is located on my server:
Distribution: Debian SID
mysql-server version: 5.6.27-2

All worked well with latest kodi 15.2 version, but breaks after upgrade with the same errors graysky mentioned.

I do not have the knowledge to troubleshoot this myself but I am willing to help if given instructions... :-)
Please let me know if I can be of any assistance.
bolderbast
 
Posts: 2
Joined: Sat Mar 05, 2016 8:13 am

Re: BUG: kodi-rpi 16.0-1 with mysql database crashes

Postby seahawk1986 » Sat Mar 05, 2016 11:19 am

Could this error be related to https://bugs.archlinux.org/task/48394 ?
seahawk1986
 
Posts: 1
Joined: Sat Mar 05, 2016 11:14 am

Re: BUG: kodi-rpi 16.0-1 with mysql database crashes

Postby bolderbast » Sat Mar 05, 2016 4:07 pm

It seems to be... Downgraded to libmariadbclient-10.1.11-1 and kodi runs fine now... :D

Thanks!
bolderbast
 
Posts: 2
Joined: Sat Mar 05, 2016 8:13 am

Re: BUG: kodi-rpi 16.0-1 with mysql database crashes

Postby graysky » Sat Mar 05, 2016 5:40 pm

I too can confirm downgrading libmariadbclient (10.1.12-2 -> 10.1.11-1) allows kodi-rpi to work with the mariadb. Thank you very much for posting, seahawk1986.

@warhead - Is the rebuild against the new binutils possible prior to the Arch binutils leaving [testing]?
graysky
 
Posts: 355
Joined: Sun Jun 26, 2011 6:56 am
Location: /run/user/1000

Re: BUG: kodi-rpi 16.0-1 with mysql database crashes

Postby WarheadsSE » Sun Mar 06, 2016 4:46 pm

Assuming that upstream moves it, and them bumps maria, it should all be magic.
Core Developer
Remember: Arch Linux ARM is entirely community donation supported!
WarheadsSE
Developer
 
Posts: 6727
Joined: Mon Oct 18, 2010 2:12 pm

Re: BUG: kodi-rpi 16.0-1 with mysql database crashes

Postby graysky » Sun Mar 06, 2016 4:57 pm

WarheadsSE wrote:Assuming that upstream moves it, and them bumps maria, it should all be magic.


Does upstream in this context mean Arch i686/x86_64? I did see that they moved binutils from [testing] to [core] so that should mean that our toolchain including binutils will get rebuilt?
graysky
 
Posts: 355
Joined: Sun Jun 26, 2011 6:56 am
Location: /run/user/1000

Re: BUG: kodi-rpi 16.0-1 with mysql database crashes

Postby WarheadsSE » Sun Mar 06, 2016 8:50 pm

Yes, binutils was updated earlier today.
Core Developer
Remember: Arch Linux ARM is entirely community donation supported!
WarheadsSE
Developer
 
Posts: 6727
Joined: Mon Oct 18, 2010 2:12 pm

Next

Return to Arch Linux ARM

Who is online

Users browsing this forum: No registered users and 2 guests