People have mentioned in other threads that a dodgy lan cable or power supply can cause issues.
Have you tried changing these to see what happens.
I don't know if this works or not as I have not had the issues you are getting but it might be worth a try.
Yes, I think the OP knows that... He just said it has been <24 hours since his last soft reset... Yes, it looks likes he needs to do it again, for whatever reason though.
I know I would be very frustrated if I got database corruption in <24 hours after a reset, too.
Just an off-the-wall question, there aren't any special characters being used in rule/device names are there? Commas, quotes, etc...? Is it truly database corruption or query corruption?
No commas or quotes but many use hyphens. But so does another hub at a different property that is completely fine yet runs a similar set of apps but fewer devices. It's strange indeed.
Done already. This situation follows a soft reset. And today the hub's remained up but slow at times and yet fine at other times. As an example, went out to the terrace this evening, the lights didn't come on. Went back out 10 minutes later, lights came on as designed. No obvious issues I can spot in the logs.
Time to log this with support I think. Right now this hub is more or less worthless.
No, it's running quite cool. It's in the lounge which is air conditioned most of the time. I don't think that's the issue. I'm going to try it upside down anyway just in case that helps.
Didn't think about this. Maybe. I'm trying a new LAN cable today as suggested by @bobbles above. If that doesn't help I will try another PSU. It's not on a smoothed supply. Maybe I can try to get a smoothed UPS or something if it will help.