[gelöst] epg2vdr - SQL-Fehlermeldungen "out bindings prepared"

  • Im syslog tauchen immer wieder jede Menge solcher Meldungen auf:


    Code
    Sep 25 23:24:09 myvdr vdr: epg2vdr: Statement 'insert into recordinglist set actor = ?, audio = ?, camera = ?, category = ?, channelid = ?, channelname = ?, country = ?, description = ?, director = ?, duration = ?, episodecompname = ?, episodecomppartname = ?, episodecompshortname = ?, episodelang = ?, eventid = ?, flags = ?, folder = ?, fsk = ?, genre = ?, guest = ?, imgid = ?, inssp = ?, inuse = ?, job = ?, lastifoupd = ?, longdescription = ?, md5path = ?, moderator = ?, music = ?, name = ?, numrating = ?, other = ?, owner = ?, path = ?, producer = ?, rating = ?, screenplay = ?, scrinfoepisodeid = ?, scrinfomovieid = ?, scrinfoseriesid = ?, scrmovieid = ?, scrnew = ?, scrseriesepisode = ?, scrseriesid = ?, scrsp = ?, shortreview = ?, shorttext = ?, starttime = ?, state = ?, tipp = ?, title = ?, topic = ?, txtrating = ?, updsp = ?, vdruuid = ?, year = ?;' with (56) in parameters and (0) out bindings prepared
    
    Sep 25 23:24:09 myvdr vdr: epg2vdr: Statement 'update recordinglist set actor = ?, audio = ?, camera = ?, category = ?, channelid = ?, channelname = ?, country = ?, description = ?, director = ?, duration = ?, episodecompname = ?, episodecomppartname = ?, episodecompshortname = ?, episodelang = ?, eventid = ?, flags = ?, folder = ?, fsk = ?, genre = ?, guest = ?, imgid = ?, inuse = ?, job = ?, lastifoupd = ?, longdescription = ?, moderator = ?, music = ?, name = ?, numrating = ?, other = ?, path = ?, producer = ?, rating = ?, screenplay = ?, scrinfoepisodeid = ?, scrinfomovieid = ?, scrinfoseriesid = ?, scrmovieid = ?, scrnew = ?, scrseriesepisode = ?, scrseriesid = ?, scrsp = ?, shortreview = ?, shorttext = ?, state = ?, tipp = ?, title = ?, topic = ?, txtrating = ?, updsp = ?, vdruuid = ?, year = ? where md5path = ? and owner = ? and starttime = ?;' with (55) in parameters and (0) out bindings prepared
    
    Sep 25 23:24:09 myvdr vdr: epg2vdr: Statement 'select t._endtime, t._starttime, t.action, t.active, t.autotimerid, t.autotimerinssp, t.autotimername, t.aux, t.channelid, t.childlock, t.day, t.directory, t.doneid, t.endtime, t.eventid, t.evtstarttime, t.expression, t.file, t.id, t.info, t.lifetime, t.namingmode, t.priority, t.retrys, t.source, t.starttime, t.state, t.tccmailcnt, t.template, t.type, t.vdruuid, t.vps, t.weekdays, t.wrncount, v.name, v.uuid, v.state from timers t, vdrs v where t.active and (t.state in ('P','R') or t.state is null) and t.type = 'R' and t.vdruuid = v.uuid order by t._starttime' with (0) in parameters and (37) out bindings prepared
    
    Sep 25 23:24:09 myvdr vdr: epg2vdr: Statement 'select _endtime, _starttime, action, active, autotimerid, autotimerinssp, autotimername, aux, channelid, childlock, day, directory, doneid, endtime, eventid, evtstarttime, expression, file, id, info, lifetime, namingmode, priority, retrys, source, starttime, state, tccmailcnt, template, type, vdruuid, vps, weekdays, wrncount from timers where active and (state in ('P','R') or state is null) and eventid = ?' with (1) in parameters and (34) out bindings prepared
    
    Sep 25 23:24:09 myvdr vdr: epg2vdr: Statement 'select sub_actor, sub_audio, sub_camera, sub_category, cnt_channelid, cnt_eventid, cnt_longdescription, cnt_source, sub_commentator, sub_complongdescription, sub_compshorttext, sub_comptitle, cnt_contents, sub_country, cnt_delflg, sub_director, cnt_duration, sub_episodecompname, sub_episodecomppartname, sub_episodecompshortname, epi_extracol1, epi_extracol2, epi_extracol3, epi_lang, epi_episodename, epi_number, epi_part, epi_partname, epi_parts, epi_season, epi_shortname, cnt_fileref, sub_flags, sub_genre, sub_guest, sub_imagecount, sub_longdescription, cnt_masterid, sub_moderator, sub_music, sub_numrating, sub_other, cnt_parentalrating, sub_producer, sub_rating, sub_screenplay, sub_scrmovieid, sub_scrseriesepisode, sub_scrseriesid, sub_scrsp, sub_shortdescription, sub_shortreview, sub_shorttext, cnt_starttime, sub_eventid, sub_source, cnt_tableid, sub_tipp, sub_title, sub_topic, sub_txtrating, cnt_updflg, all_updsp, cnt_useid, cnt_version, cnt_vps, sub_year from useevents where cnt_useid = ? and cnt_updflg in ('A','L','P','C','D','R')' with (1) in parameters and (67) out bindings prepared


    Eine Runde mysqlcheck/analyze/optimize/repair der mariadb/innodb habe ich schon hinter mir - eigentlich ohne Ergebnis oder Verbesserung.

    Bis auf die Fehlermeldungen wirkt der VDR beim Umschalten und im Menü nur leicht träger - sonst keine spürbaren Auswirkungen.


    Hat jemand von euch bitte eine Idee, wie ich das reparieren kann?

    MyVDR: yaVDR-Ansible (Ubuntu 20) - softhddevice-openglosd (ffmpeg 2.8) - epgd/epg2vdr - skindesigner estuary4vdr (adaptiert) - 1920x1080@50 Hz | kodi 18 - inputstream + amazon vod
    Aerocube M40 | 300W | ASRock H61M-GE | Intel G530 | Asus ENGT520 | 2 x TT-budget S2-3200 | ASRock Smart Remote (CIR) | 4 GB RAM | 120 GB SSD | 3 TB HDD

  • Bis auf die Fehlermeldungen wirkt der VDR beim Umschalten und im Menü nur leicht träger

    Bist du sicher, daß es Fehlermeldungen sind? Für mich sieht das eher so aus, als ob der Log-Level zu hoch gesetzt wurde.

    Was sagt denn

    Code
    grep LogLevel /etc/epgd/epgd.conf

    Und der Start Parameter

    Code
    -l <log-level>  set log level


    Edit:

    Darauf muss man erst kommen. Eloquence. Aber meine Vermutung stimmt wohl. Du hast irgendwo den Debug-Level eingestellt:

    Code
    tell(eloDebug, "Statement '%s' with (%ld) in parameters and (%d) out bindings prepared",
            stmtTxt.c_str(), mysql_stmt_param_count(stmt), outCount);
  • Wow - danke, darauf wär ich nicht gekommen.

    Werde ich mir gleich anschauen, wenn ich wieder an den VDR komme.


    Update:
    Loglevel stand auf 2 - habe jetzt auf 0 geändert und werde beobachten ....

    MyVDR: yaVDR-Ansible (Ubuntu 20) - softhddevice-openglosd (ffmpeg 2.8) - epgd/epg2vdr - skindesigner estuary4vdr (adaptiert) - 1920x1080@50 Hz | kodi 18 - inputstream + amazon vod
    Aerocube M40 | 300W | ASRock H61M-GE | Intel G530 | Asus ENGT520 | 2 x TT-budget S2-3200 | ASRock Smart Remote (CIR) | 4 GB RAM | 120 GB SSD | 3 TB HDD

    Edited once, last by davie2000 ().

  • Das syslog ist leider immer noch voll mit solchen Meldungen :(
    Hat bitte noch jemand eine Idee im peto?


    Kommando retour!

    Der loglevel war noch oder wieder auf 2 - shit - ich beobachte weiter ...

    MyVDR: yaVDR-Ansible (Ubuntu 20) - softhddevice-openglosd (ffmpeg 2.8) - epgd/epg2vdr - skindesigner estuary4vdr (adaptiert) - 1920x1080@50 Hz | kodi 18 - inputstream + amazon vod
    Aerocube M40 | 300W | ASRock H61M-GE | Intel G530 | Asus ENGT520 | 2 x TT-budget S2-3200 | ASRock Smart Remote (CIR) | 4 GB RAM | 120 GB SSD | 3 TB HDD

  • davie2000

    Changed the title of the thread from “epg2vdr - SQL-Fehlermeldungen "out bindings prepared"” to “[gelöst] epg2vdr - SQL-Fehlermeldungen "out bindings prepared"”.
  • Kaum macht mans richtig (loglevel 0) - ist die Meldung weg.
    Danke Zabrimus !

    MyVDR: yaVDR-Ansible (Ubuntu 20) - softhddevice-openglosd (ffmpeg 2.8) - epgd/epg2vdr - skindesigner estuary4vdr (adaptiert) - 1920x1080@50 Hz | kodi 18 - inputstream + amazon vod
    Aerocube M40 | 300W | ASRock H61M-GE | Intel G530 | Asus ENGT520 | 2 x TT-budget S2-3200 | ASRock Smart Remote (CIR) | 4 GB RAM | 120 GB SSD | 3 TB HDD

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!