Domoticz crash everyday at midnight

[THBR]

Hello,

For several months now my Domoticz crashes almost every day at midnight for an unknown reason and after that it restarts succesfully, etc.
Remark: if Domoticz has not been continuously online for 24 hours in a 24-hour period (so between 00:00 and 24:00), it will not crash. Then it crashes at the next midnight.

The crash log always indicates a different cause, sometimes it is the Zigbee2MQTT plugin, sometimes the Google plugin, Sometime the Solax inverter plugin, sometime the Fujitsu airo plugin, etc.

The error messages in the latest Domoticz log started with:

2023-09-21 00:00:56.194 Solax Inverter: Plugin is stopping.
2023-09-21 00:00:56.776 Solax Inverter: Python error was set during unlock for 'onStopCallback'
2023-09-21 00:00:56.788 Error: Domoticz(pid:1263, tid:1288('Solax Inverter')) received fatal signal 11 (Segmentation fault)
2023-09-21 00:00:56.788 Error: siginfo address=0x4ef, address=(nil)
2023-09-21 00:00:56.803 Status: Solax Inverter: Stopping threads.

and Domoticz ended with:

2023-09-21 00:01:04.965 Error: Thread 8 (Thread 0x6b8fd200 (LWP 1288)):
2023-09-21 00:01:04.965 Error: #0 __waitpid (options=0, stat_loc=0x6b8fbef0, pid=8955) at ../sysdeps/unix/sysv/linux/waitpid.c:30
2023-09-21 00:01:04.965 Error: #1 __waitpid (pid=8955, stat_loc=0x6b8fbef0, options=0) at ../sysdeps/unix/sysv/linux/waitpid.c:25
2023-09-21 00:01:04.965 Error: #2 0x0023d55c in dumpstack_gdb(bool) ()
2023-09-21 00:01:04.965 Error: #3 0x0023db28 in signal_handler(int, siginfo_t*, void*) ()
2023-09-21 00:01:04.965 Error: #4 <signal handler called>
2023-09-21 00:01:04.965 Error: #5 raise (sig=11) at ../sysdeps/unix/sysv/linux/raise.c:50
2023-09-21 00:01:04.965 Error: #6 <signal handler called>
2023-09-21 00:01:04.965 Error: #7 0x75c319d4 in PyErr_Fetch () from /usr/lib/arm-linux-gnueabihf/libpython3.7m.so
2023-09-21 00:01:04.965 Error: #8 0x005dc734 in Plugins::CPlugin::LogPythonException() ()
2023-09-21 00:01:04.965 Error: #9 0x005dcde4 in Plugins::AccessPython::~AccessPython() ()
2023-09-21 00:01:04.965 Error: #10 0x001c60ac in Plugins::CPluginMessageBase::Process(Plugins::CPlugin*) ()
2023-09-21 00:01:04.965 Error: #11 0x005e80f8 in Plugins::CPlugin::Do_Work() ()
2023-09-21 00:01:04.965 Error: #12 0x0076710c in execute_native_thread_routine ()
2023-09-21 00:01:04.966 Error: #13 0x76ac5494 in start_thread (arg=0x6b8fd200) at pthread_create.c:486
2023-09-21 00:01:04.966 Error: #14 0x76978e98 in ?? () at ../sysdeps/unix/sysv/linux/arm/clone.S:73 from /lib/arm-linux-gnueabihf/libc.so.6

I have also already followed all the hints/info on this forum, such as disabling Python plugins step by step, disabling scripts, disabling auto backup, etc., unfortunately with no results. Also checked the database, is ok.

Except for the crash/restart at midnight, Domoticz works perfectly.

Can someone help me so solve this issue ?

Thanks!

My configuration:
RaspberryPi 3b
Booting/operating from 64 GB USB-flashdevice, no SD card
Raspbian GNU/Linux 10 (buster)
Domoticz version: 2023.2 (build 15555)
Python Version: 3.7.3
Zigbee2mqtt:plugin: v.3.2.0-beta
Zigbee2mqtt: v.1.33.0 (zStack3x0 20211114)
Zigbee Slaesh's CC2652RB coördinator USB-dongle
RTC DS1307

[waltervl]

At midnight the cleanup from the current day to the summerised data is executed. So something seems wrong in your database. Check with SQLite browser for inconsistencies, strange values in the tables.

[THBR]

Thanks for the response, I will check it!

I already saw an incorrect registration in my "water meter" in May 2022. Could this also cause the or a crash?

[HvdW]

Try the Kedi script.
For me it worked like a charm.
The malformed database was repaired at once.

Note the size of the database before and after. Garbage will be disposed of and it will shrink.

For adjusting or deleting this exceptional value it won't help.
Adjusting can be done by exporting your Meter_Calendar data to csv, manipulate and import again or by changing data using DB browser (SQLite)