I’ve been working on integrating a fleet of 10 Tuya Power sockets with Home Assistant, and it was going smoothly until I noticed something odd. After setting up energy consumption tracking using Riemann Integration and hourly metering, the power graphs for all devices froze, showing straight horizontal lines. No matter what I did—restarting Home Assistant, the Raspberry Pi, or the router—the issue persisted.
This led me to suspect a deeper problem, and eventually, I discovered that my Pi-Hole installation was the culprit. Checking the logs revealed database corruption and locking issues. Running a repair command fixed the database, and everything started working again.
If you’re experiencing similar issues with Tuya plugs or Pi-Hole, I recommend checking your Pi-Hole logs and running a database repair. This experience taught me the importance of monitoring system health and being prepared to troubleshoot across different components. Hope this helps someone else avoid the same frustration!