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:

$this->bbcode_second_pass_code('', '% 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:
$this->bbcode_second_pass_code('', '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
Developer
 
Posts: 1728
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 4 4GB | CuBox-i4 Pro | ClearFog | BeagleBone Black | Odroid U2 | Odroid C1 | Odroid XU4
-----------------------------------------------------------------------------------------------------------------------
[armv5] Updated U-Boot | [armv5] NAND Rescue System
moonman
Developer
 
Posts: 3387
Joined: Sat Jan 15, 2011 3:36 am

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:
$this->bbcode_second_pass_quote('wsnipex', 'a')nyway, 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
Developer
 
Posts: 1728
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
Developer
 
Posts: 1728
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: 6807
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

$this->bbcode_second_pass_quote('WarheadsSE', 'A')ssuming 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
Developer
 
Posts: 1728
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: 6807
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 1 guest