Posts by uatschitchun

  • [solved] MySQL - Resume points not being saved

    Hi there.

    I'm running a central MySQL DB with multiple clients. All clients are Kodi 18.5. All clients save the resume points if watching a video:

    Laptop (Bionic): (tail -f kodi.log | grep -i mysql)

    Code
    2019-12-05 09:46:50.895 T:140293067859712   DEBUG: Mysql execute: DELETE FROM settings WHERE idFile=74502019-12-05 09:46:50.910 T:140293067859712   DEBUG: Mysql execute: update files set playCount=NULL,lastPlayed='2019-12-05 09:46:50' where idFile=74502019-12-05 09:46:50.919 T:140293067859712   DEBUG: Mysql execute: insert into bookmark (idBookmark, idFile, timeInSeconds, totalTimeInSeconds, thumbNailImage, player, playerState, type) values(NULL,7450,1809.793130,7001.630000,'','VideoPlayer','', 1)


    This is Amlogic Box running Coreelec:


    Code
    2019-12-05 09:25:00.400 T:3610657664   DEBUG: Mysql execute: DELETE FROM settings WHERE idFile=74502019-12-05 09:25:00.422 T:3766551424   DEBUG: Mysql execute: update files set playCount=NULL,lastPlayed='2019-12-05 09:25:00' where idFile=7450
2019-12-05 09:25:00.431 T:3766551424   DEBUG: Mysql execute: insert into bookmark (idBookmark, idFile, timeInSeconds, totalTimeInSeconds, thumbNailImage, player, playerState, type) values(NULL,7450,3055.282872,7001.630000,'','VideoPlayer','', 1)

    This is Libreelec (9.2.0) (Rpi3):

    Code
    2019-12-05 09:51:11.188 T:1793299328   DEBUG: Mysql execute: DELETE FROM settings WHERE idFile=7448


    As you can see, all systems (except LE) do execute the insert into the Mysql DB!?

    Code
    # grep -i mysql .kodi/temp/kodi.log                                                 <type>mysql</type>
                                               <type>mysql</type>
2019-12-05 09:35:16.603 T:1807721344  NOTICE: MYSQL: Connected to version 10.4.10-MariaDB-1:10.4.10+maria~bionic-log
2019-12-05 09:35:26.481 T:1648538496  NOTICE: [plugin.video.mediathekview-0.6.2:Updater]: Database driver: External (mysql)
2019-12-05 09:35:26.481 T:1648538496  NOTICE: [plugin.video.mediathekview-0.6.2:StoreMySQL]: Using MySQL connector version 1.1.7
2019-12-05 09:35:26.695 T:1648538496  NOTICE: [plugin.video.mediathekview-0.6.2:StoreMySQL]: Connected to server 192.168.5.13 running 10.4.10-MariaDB-1:10.4.10+maria~bionic-log
2019-12-05 09:38:01.949 T:1249416064   DEBUG: Mysql execute: DELETE FROM settings WHERE idFile=7448
2019-12-05 09:51:11.188 T:1793299328   DEBUG: Mysql execute: DELETE FROM settings WHERE idFile=7448

    As you can see, the connection is established, no errors regarding MySQL and even Mediathekview is able to connect to the DB.

    Only thing is, there's no bookmark execution running into the DB if a video is played from LE.


    I noticed that even playcounts for audio aren't saved into the DB from LE, but I have no logs available atm.

  • [8.2.3.1] LibreELEC 8.2 for S905/S905X

    Hi. I'm having problems with YouTube addon. It stopped working and is throwing Errors in log cause of SSLError. Anyone with similar problems?


    And a second problem:

    I seem to have corruptions on my filesystem :(

    What's the best way to do a clean install?

  • Mem leak on 7.95.3, 8.0 & Milhouse #0303 RPi3

    Pls, couldn't anyone tell what's needed to get this one pinned down?


    Dave and me are down to it being caused by Library Data Provider and/or Skin.Widget (both coming along with Xonfluence) and the regular queries done by that addons to the DB. MyMusic DB (MariaDB) is quite large 120k songs...
    Have had problems with mysql, so I switched to MariaDB as it's alot faster!


    Latest Milhouse (#0305) is better in the matter of "leaking" (not that fast as in the video), but there are still crashes (see above)


    I'm checking against Estuary with LDP & S.W running to see if it has an influence.


    No problem running Xonfluence with LDP & S.W on Linux (14.04) or Amlogic (kszaq) against my DB, only RPi3!

  • Mem leak on 7.95.3, 8.0 & Milhouse #0303 RPi3

    This is Milhouse #303 running since yesterday evening.
    LDP & skin.widget together with Xonfluence (tricked it into with adapting xbmc.gui version from required 5.12 to 5.13).
    This was running over night and produced 9 crashlogs and at least 1 reboot :s

  • Mem leak on 7.95.3, 8.0 & Milhouse #0303 RPi3

    Question:
    How do I set MALLOC_MMAP_THRESHOLD by hand on RPi? It gets set from within kodi-config for 64bit, but DaveBlake wanted me to test with MALLOC_MMAP_THRESHOLD_=32768
    kodi-config is read only and /run/libreelec/kodi.conf gets overwritten each time kodi starts, so I couldn't set it there.
    I tried setting it as environment variable and

    Code
    echo $MALLOC_MMAP_THRESHOLD_
32768


    make me believe I've done it right.
    Any other way?

  • Mem leak on 7.95.3, 8.0 & Milhouse #0303 RPi3

    On the mem leak, this is the last entry in mysql.log:


    And this is kodi.log
    jGTU


    Here's a video
    Dropbox - VID_20170227_221841.mp4

  • Mem leak on 7.95.3, 8.0 & Milhouse #0303 RPi3

    Ok, so after I got my music source scanned in (did switch from Mysql to a recent MariaDB which speeds up music scanning from 19h to 5h) the mem leak is definitely connected to using Xonfluence (guess it's skin.widget addon or library data provider, which come along with Xonfluence) together with a huge music source (130k files).


    I'll provide logs!


    Same setup on my s905x box is working great... so it's only the RPi3...