[Perlbo]

Hi,

seit ihr auf maridb umgestellt habt, habe ich folgenden Fehler.

Code: [Select]

May 15 18:43:54 (MLD) daemon.err mysqld: 2017-05-15 18:43:54 140617237161728 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on t
May 15 18:43:54 (MLD) daemon.err mysqld: 2017-05-15 18:43:54 140617237161728 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT IGNORE... SELECT is unsafe because the order in which rows are retrieved by
May 15 18:43:54 (MLD) daemon.err mysqld: 2017-05-15 18:43:54 140617237161728 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from a
May 15 18:43:54 (MLD) user.err epgd: SQL-Error in 'execute(stmt_execute)' - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators var


[Perlbo]

Hi,

um den Fhler oben weg zu bekommen habe ich nochmal mariadb-server gelöscht +epgd + epg2vdr + scraper2vdr + /var/cache/mysql + /etc/epgd

Nach Neuinstallation bekomme ich folgenden Fehler ...

Code: [Select]

May 20 09:22:29 (MLD) user.err vdr: epg2vdr: Trying to re-connect to database!
May 20 09:22:29 (MLD) user.err vdr: epg2vdr: Calling mysql_init(2297)
May 20 09:22:29 (MLD) user.err vdr: epg2vdr: SQL-Error in 'prepare(stmt_prepare)' - Table 'epg2vdr.eventsview' doesn't exist (1146) 'Table 'epg2vdr.eventsview' doesn't exist' [select useid, eventid, source, delflg, updflg, fileref, tableid, version, title, shorttext
May 20 09:22:29 (MLD) user.err vdr: epg2vdr: Retry #22 failed, retrying in 60 seconds!
May 20 09:22:29 (MLD) user.err vdr: epg2vdr: Closing mysql connection and calling mysql_thread_end(2297)
May 20 09:23:29 (MLD) user.err vdr: epg2vdr: Trying to re-connect to database!
May 20 09:23:29 (MLD) user.err vdr: epg2vdr: Calling mysql_init(2297)
May 20 09:23:29 (MLD) user.err vdr: epg2vdr: SQL-Error in 'prepare(stmt_prepare)' - Table 'epg2vdr.eventsview' doesn't exist (1146) 'Table 'epg2vdr.eventsview' doesn't exist' [select useid, eventid, source, delflg, updflg, fileref, tableid, version, title, shorttext
May 20 09:23:29 (MLD) user.err vdr: epg2vdr: Retry #23 failed, retrying in 60 seconds!
May 20 09:23:29 (MLD) user.err vdr: epg2vdr: Closing mysql connection and calling mysql_thread_end(2297)
May 20 09:24:29 (MLD) user.err vdr: epg2vdr: Trying to re-connect to database!
May 20 09:24:29 (MLD) user.err vdr: epg2vdr: Calling mysql_init(2297)
May 20 09:24:29 (MLD) user.err vdr: epg2vdr: SQL-Error in 'prepare(stmt_prepare)' - Table 'epg2vdr.eventsview' doesn't exist (1146) 'Table 'epg2vdr.eventsview' doesn't exist' [select useid, eventid, source, delflg, updflg, fileref, tableid, version, title, shorttext
May 20 09:24:29 (MLD) user.err vdr: epg2vdr: Retry #24 failed, retrying in 60 seconds!
May 20 09:24:29 (MLD) user.err vdr: epg2vdr: Closing mysql connection and calling mysql_thread_end(2297)
May 20 09:24:30 (MLD) user.err epgd: Set locale to 'de_DE.UTF-8'
May 20 09:24:30 (MLD) user.err epgd: Info: Systemd support not enabled, epgd won't be sending notifications!
May 20 09:24:30 (MLD) user.err epgd: Loading uuid from '/etc/epgd/uuid' succeeded [EDBACECA-5E2F-4095-BFE2-2162E5DE226D]
May 20 09:24:30 (MLD) user.err epgd: Dictionary '/etc/epgd/epg.dat' loaded
May 20 09:24:30 (MLD) user.err epgd: Initialize python script '/etc/epgd/recording.py'
May 20 09:24:30 (MLD) user.err epgd: Error: Opening plugin directory '/usr/lib/epgd/plugins' failed, No such file or directory
May 20 09:24:30 (MLD) user.err epgd: Read 30 option from /etc/epgd/epgd.conf
May 20 09:24:30 (MLD) user.err epgd: Using syslog facility 'user' (8), log level set to (0)
May 20 09:24:30 (MLD) user.err epgd: Checking database connection ...
May 20 09:24:30 (MLD) user.err epgd: Calling mysql_init(6530)
May 20 09:24:30 (MLD) user.err epgd: SQL client character now 'utf8'
May 20 09:24:30 (MLD) user.err epgd: Checking table structure and indices ...
May 20 09:24:30 (MLD) user.err epgd: Closing mysql connection and calling mysql_thread_end(6530)
May 20 09:24:30 (MLD) user.err epgd: Checking table structure and indices succeeded
May 20 09:24:30 (MLD) user.err epgd: Calling mysql_init(6530)
May 20 09:24:30 (MLD) user.err epgd: State now 'init'
May 20 09:24:30 (MLD) user.err epgd: SQL-Error in 'select epglv('123', '123')' - FUNCTION epg2vdr.epglv does not exist (1305)
May 20 09:24:30 (MLD) user.err epgd: SQL-Error in 'select epglvr('123', '123')' - FUNCTION epg2vdr.epglvr does not exist (1305)
May 20 09:24:30 (MLD) user.err epgd: Error: Missing functions epglv/epglvr, please install first!
May 20 09:24:30 (MLD) user.err epgd: Closing mysql connection and calling mysql_thread_end(6530)
Dein Upload Code lautet: mYGXAJ

[brötchen]

Hi,

ich habe ja auch gerade frisch installiert. Diese Fehler habe ich bei mir nicht. Einzigen Unterschied den ich jetzt feststellen kann ist, dass ich den scraper2vdr bei mir nicht installiert habe auf dem Server.

Zickt der evtl. rum?

Gruß

[HagenS]

Ok - ich habe DIE Fehler jetzt auch (wieder). Nach ein wenig Recherche habe ich in der /etc/mysql/mariadb.conf.d/50-mld_mariadb-server.cnf folgende Zeile hinzugefügt:

Code: [Select]

binlog_format                   = mixed
Ich beobachte mal, ob das erfolgreich war :-)

Hi,

seit ihr auf maridb umgestellt habt, habe ich folgenden Fehler.

Code: [Select]

May 15 18:43:54 (MLD) daemon.err mysqld: 2017-05-15 18:43:54 140617237161728 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on t
May 15 18:43:54 (MLD) daemon.err mysqld: 2017-05-15 18:43:54 140617237161728 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT IGNORE... SELECT is unsafe because the order in which rows are retrieved by
May 15 18:43:54 (MLD) daemon.err mysqld: 2017-05-15 18:43:54 140617237161728 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from a
May 15 18:43:54 (MLD) user.err epgd: SQL-Error in 'execute(stmt_execute)' - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators var


[Perlbo]

Hi,

das beruhigt mir irgendwie ... hier läuft auch wieder alles ... nur diese Meldung hab ich halt ... lag übrigens nicht an scraper2vdr ...

[Perlbo]

Die letzt Änderung scheint geholfen zu haben.