[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, VDR 2.4.8) - softhddevice-openglosd (ffmpeg 2.8) - epgd/epg2vdr (tvm) - skindesigner estuary4vdr (adaptiert) - 1920x1080@50 Hz | kodi 21 - xstream
    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);

    Edited once, last by Zabrimus (September 26, 2024 at 10:28 AM).

  • 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, VDR 2.4.8) - softhddevice-openglosd (ffmpeg 2.8) - epgd/epg2vdr (tvm) - skindesigner estuary4vdr (adaptiert) - 1920x1080@50 Hz | kodi 21 - xstream
    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 (September 27, 2024 at 12:28 AM).

  • 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, VDR 2.4.8) - softhddevice-openglosd (ffmpeg 2.8) - epgd/epg2vdr (tvm) - skindesigner estuary4vdr (adaptiert) - 1920x1080@50 Hz | kodi 21 - xstream
    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 September 30, 2024 at 11:31 PM

    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, VDR 2.4.8) - softhddevice-openglosd (ffmpeg 2.8) - epgd/epg2vdr (tvm) - skindesigner estuary4vdr (adaptiert) - 1920x1080@50 Hz | kodi 21 - xstream
    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!