I hope you had the best of care and (just to annoy the 'Muricans), free! No payment, and usually not even sign anything on the way out. Just busy, polite professionals doing their best.
Iโm looking at your sensors you are storing data for.
โ sensor.sonoff_10012393db_voltage โ 76017 โ
โ sensor.sonoff_1001361b68_voltage โ 74817 โ
โ sensor.sonoff_1001361f45_voltage โ 73610 โ
โ sensor.sonoff_100123ae52_voltage โ 72001 โ
โ sensor.sonoff_1000cd7a20_voltage โ 71688 โ
โ sensor.sonoff_10012393d2_voltage โ 68508 โ
--
โ sensor.shellyem_34945470fae8_channel_1_voltage โ 56303 โ
โ sensor.shellyem_34945470fae8_channel_2_voltage โ 56303 โ
Pull up graphs of these over an hour, day, week, year and see by how much they vary.
Does your voltage vary at each sensor point on each sonoff? By much? The same amount always? Are they in sync, following each other up and down? Once you confirm it is close to normal 230/240/250v (depending on your location in respect of the power station and street wiring which you have little control over, and local load, which you do), is it important to keep those statistics longer term? Unless you are having issues you need to discuss with your power company, maybe these donโt need to be stored, just monitored for normality, and a possible trigger alerts if they fall outside the nominal Australian standard +/-5% range, maybe triggering above 265 volts (surge) and below 210 (brown-out)? Yes you have to collect voltage to calculate wattage/power from multiplying current and voltage, but do you need to store it longer term?
Maybe store the ones from the Shelly EM (which should closely match all the other ones). Yes, keep the power consumed, measure in current (amps), wattage (volts x amps), consumption, energy, but you could probably cull those voltage sensors from being stored long term, and prune even more from your database.
Your previous reference to MusicAssistant as well as voice input has piqued my interest. Any add-ons, apps, or voice assisted things that rely on that installed?
When an individual brain cannot store and recall every single small detail, you need assistance to be able to manage a project effectively. Things have become so complicated and interwoven that even teams of individuals that used to be thrown at a complex issue is not good enough any more. HomeAssistant has grown to be a collaboration of many individuals, Open Source notwithstanding, and some of the add-ons, integrations and apps are done by persons of varying skills and ability, increasingly vibe coded, all coexisting and expected to work together in an orderly way. By the very relentless pace of developments in the computer industry, it has to weave and change to keep up, add functionality, and accommodate vendor changes, some done for improvement, and sometimes for spite, the endless pursuit of money being the dominant driver, and the noble altruistic efforts of some in the Open Source sector being the balancing counterpart.
The ability of AI is increasingly to be able to digest enormous amounts of information and find patterns, inconsistencies, analyse things that are the same and different, and with correct prompting from a skilled individual that still knows what the ultimate goal is, recognising and redirecting AI slop and hallucinations, to provide similar consistent error free code that was previously done for less complex projects. Like a wheelchair or walking frame as you age, the tools are to assist you, to achieve the same goals as before, to get to the pub before closing time, and get home again later!
Voice input and discussion has been the Holy Grail for computing for decades. The grunt behind the scenes to be able to do this unobtrusively, naturally, is not quite here but not far away. Yes, hobbyists are driving the technology hard, identifying the weak spots, and the industry is pouring billions into AI, Data Centers, and software to string it all together, just so you can have a conversation.
The day you can hobble into ER, the robot nurse bathe and change a dressing, all the while speaking to you about the weather as well as uniquely adapting to your medical condition that nobody else in the building has at that very moment, will be the day that you know the industry has arrived. In the meantime, we struggle, we make miztakes, and we enjoy whatever life has to offer, the alternate not being so exciting. A caring individual support person will not become unemployed for quite a few decades I suspect โ empathy being something that is extremely hard to train a computer to do well.
Keep us posted on how your system is performing and how stable it now is, and whether the original problem that started this thread still exists.