Zitat von: Prof. Dr. Peter Henning am 07 Mai 2024, 04:41:52Dein Code mit dem geschachtelten at ist, vorsichtig gesagt, schwer wartbar. Nach 3 Jahren weißt Du nicht mehr, was das eigentlich machen soll.
Zitat von: Papa Romeo am 07 Mai 2024, 14:07:46...scheint bei ihm aber nicht zu funktionieren oder ist nicht aktiviert.
Raspberry Pi 3:
# $Id: 93_DbRep.pm 28714 2024-03-27 21:40:03Z DS_Starter $
2024.05.02 01:15:00 3: DbRep myDbRep_Vacuum - ################################################################
2024.05.02 01:15:00 3: DbRep myDbRep_Vacuum - ### New optimize table / vacuum execution ###
2024.05.02 01:15:00 3: DbRep myDbRep_Vacuum - ################################################################
2024.05.02 01:15:00 3: DbRep myDbRep_Vacuum - execute command before optimize: 'set myDbLog reopen 3600'
2024.05.02 01:15:00 2: myDbLog - Connection closed until 02:15:00 (3600 seconds).
2024.05.02 01:15:00 3: myDbLog - Database disconnected by request.
2024.05.02 01:15:00 3: DbRep myDbRep_Vacuum - Size of database /opt/fhem/fhem.db before optimize (MB): 2616
2024.05.02 01:45:31 1: DbRep myDbRep_Vacuum -> BlockingCall HASH(0x466cf48)}{fn} pid:DEAD:26397 Process died prematurely
2024.05.02 01:45:31 3: DbRep myDbRep_Vacuum - execute command after optimize: 'set myDbLog reopen'
2024.05.02 01:45:31 3: myDbLog - Reopen requested
2024.05.02 01:45:31 3: DbRep myDbRep_Vacuum - command message after optimize: >Reopen executed.<
2024.05.02 01:45:31 2: DbRep myDbRep_Vacuum - Database optimize aborted: "Process died prematurely"
2024.05.02 01:45:40 3: myDbLog - Database disconnected by request.
2024.05.02 01:45:48 3: myDbLog - SubProcess connected to /opt/fhem/fhem.db
Raspberry Pi 2:
# $Id: 93_DbRep.pm 28714 2024-03-27 21:40:03Z DS_Starter $
2024.04.08 04:01:00 3: DbRep myDbRep_Vacuum - ################################################################
2024.04.08 04:01:00 3: DbRep myDbRep_Vacuum - ### New optimize table / vacuum execution ###
2024.04.08 04:01:00 3: DbRep myDbRep_Vacuum - ################################################################
2024.04.08 04:01:00 3: DbRep myDbRep_Vacuum - execute command before optimize: 'set myDbLog reopen 7200'
2024.04.08 04:01:00 2: myDbLog - Connection closed until 06:01:00 (7200 seconds).
2024.04.08 04:01:00 3: DbRep myDbRep_Vacuum - Size of database /opt/fhem/fhem.db before optimize (MB): 1717
2024.04.08 04:01:00 3: myDbLog - Database disconnected by request.
2024.04.08 04:39:55 1: DbRep myDbRep_Vacuum -> BlockingCall HASH(0x2961da8)}{fn} pid:DEAD:9923 Process died prematurely
2024.04.08 04:39:55 3: DbRep myDbRep_Vacuum - execute command after optimize: 'set myDbLog reopen'
2024.04.08 04:39:55 3: myDbLog - Reopen requested
2024.04.08 04:39:55 3: DbRep myDbRep_Vacuum - command message after optimize: >Reopen executed.<
2024.04.08 04:39:55 2: DbRep myDbRep_Vacuum - Database optimize aborted: "Process died prematurely"
2024.04.08 04:39:56 3: myDbLog - Database disconnected by request.
2024.04.08 04:39:59 3: myDbLog - SubProcess connected to /opt/fhem/fhem.db
Raspberry Pi 2: SQLITE_FILE_SIZE_MB 1712
Raspberry Pi 3: SQLITE_FILE_SIZE_MB 2569
Raspberry Pi 2:
# $Id: 93_DbRep.pm 28525 2024-02-16 20:57:30Z DS_Starter $
2024.05.07 13:13:28 3: DbRep myDbRep_Vacuum - ################################################################
2024.05.07 13:13:28 3: DbRep myDbRep_Vacuum - ### New optimize table / vacuum execution ###
2024.05.07 13:13:28 3: DbRep myDbRep_Vacuum - ################################################################
2024.05.07 13:13:28 3: DbRep myDbRep_Vacuum - execute command before optimize: 'set myDbLog reopen 7200'
2024.05.07 13:13:28 2: myDbLog - Connection closed until 15:13:28 (7200 seconds).
2024.05.07 13:13:28 3: myDbLog - Database disconnected by request.
2024.05.07 13:13:29 3: DbRep myDbRep_Vacuum - Size of database /opt/fhem/fhem.db before optimize (MB): 1711
2024.05.07 14:00:00 3: DbRep myDbRep_Size - connection myDbLog to db /opt/fhem/fhem.db is closed until 15:13:28 - svrinfo postponed
2024.05.07 14:21:57 3: DbRep myDbRep_Vacuum - Size of database /opt/fhem/fhem.db after optimize (MB): 1711
2024.05.07 14:22:01 3: DbRep myDbRep_Vacuum - Optimize tables of /opt/fhem/fhem.db finished - total time (hh:mm:ss): 01:08:31
2024.05.07 14:22:01 3: DbRep myDbRep_Vacuum - Optimize tables finished successfully.
2024.05.07 14:22:01 3: DbRep myDbRep_Vacuum - execute command after optimize: 'set myDbLog reopen'
2024.05.07 14:22:02 3: myDbLog - Reopen requested
2024.05.07 14:22:02 2: DbRep myDbRep_Vacuum - command message after optimize: >Reopen executed.<
2024.05.07 14:22:03 3: myDbLog - Database disconnected by request.
2024.05.07 14:22:04 3: myDbLog - SubProcess connected to /opt/fhem/fhem.db
Raspberry Pi 3:
# $Id: 93_DbRep.pm 28627 2024-03-09 10:38:48Z DS_Starter $
Messages collected while initializing FHEM:configfile: Device "myDbRep_Vacuum" -> The attribute 'allowDeletion' is obsolete and will be deleted soon. Please press "save config" when FHEM start is finished.
Device "myDbRep_delEntries" -> The attribute 'allowDeletion' is obsolete and will be deleted soon. Please press "save config" when FHEM start is finished.
Device "myDbRep_delDevice" -> The attribute 'allowDeletion' is obsolete and will be deleted soon. Please press "save config" when FHEM start is finished.
Device "myDbRep_delReadings" -> The attribute 'allowDeletion' is obsolete and will be deleted soon. Please press "save config" when FHEM start is finished.
2024.05.07 11:38:25 3: DbRep myDbRep_Vacuum - ################################################################
2024.05.07 11:38:25 3: DbRep myDbRep_Vacuum - ### New optimize table / vacuum execution ###
2024.05.07 11:38:25 3: DbRep myDbRep_Vacuum - ################################################################
2024.05.07 11:38:25 3: DbRep myDbRep_Vacuum - execute command before optimize: 'set myDbLog reopen 3600'
2024.05.07 11:38:25 2: myDbLog - Connection closed until 12:38:25 (3600 seconds).
2024.05.07 11:38:25 3: DbRep myDbRep_Vacuum - Size of database /opt/fhem/fhem.db before optimize (MB): 2568
2024.05.07 11:38:25 3: myDbLog - Database disconnected by request.
2024.05.07 11:39:01 3: Timer: time difference too large! interval=59, Sekunde=01
2024.05.07 11:41:03 3: Timer: time difference too large! interval=57, Sekunde=03
2024.05.07 11:43:04 3: Timer: time difference too large! interval=57, Sekunde=03
2024.05.07 11:45:01 3: Timer: time difference too large! interval=59, Sekunde=01
Neustart weil keine Reaktion mehr
2024.05.07 11:22:39 1: Including fhem.cfg
...
2024.05.07 11:23:06 3: sduinoESP8266_1: StartInit, get version, retry = 1
2024.05.07 13:16:39 1: sduinoESP8266_1: CheckVersionResp, Not an SIGNALduino device, got for V: undef
Zitat von: beaune am 07 Mai 2024, 11:10:56Wie kann man denn bei periodicCmd Perl einbauen? Gibts dafür ein Beispiel?Ist etwas "durch die Brust ins Auge", aber z.B. in OpenGatewayMCU gibt es sowas, dass einmal am Tag "den Schotter wegräumt":
attr DEVICE setList\
bla...
deleteReadings:noArg {fhem "deletereading -q $NAME (?!associatedWith|attrTemplateVersion|last|LWT|version|Sys_).* 86400"}
attr DEVICE periodicCmd deleteReadings:1440
Zitat von: frober am 07 Mai 2024, 10:44:20Soweit ich das gelesen habe, hat die OV5640 einen Autofokus, den man aktivieren kann.