Home Assistant beginners

Those options look good will have to try them.

I realised the Asus ROG Ally doesn't allow setting power on AC restore, lukilly came across Smokeless and got into hidden options, now have WOL enabled and also wake on AC restore. So that's first step out of the way.

I will keep it on Windows, I'll install Apollo so I can remotely stream it as well.

I'll install HA on VirtualBox.
 
bought this
www.ebay.co.uk

Windows 11 PRO PC Tiny Core i7 32GB RAM 1TB SSD Wi-Fi PC Desktop | eBay UK

Windows 11 Lenovo ThinkCentre Tiny Core i7 32GB RAM 1TB SSD Wi-Fi PC Desktop. SSD : Select from above 120GB TO 1TB SSD. RAM : 8GB, 16GB OR 32GB. Windows : Windows 11 Pro. Gaming PC Bundles. Look no further than the Tiny mini computer!
www.ebay.co.uk
£75, i5, 16Gb Ram, 120GB SSD.

seems like it will do the job, I think I have to get a dongle now for the zigbee
 
Dr House said:
bought this
www.ebay.co.uk

Windows 11 PRO PC Tiny Core i7 32GB RAM 1TB SSD Wi-Fi PC Desktop | eBay UK

Windows 11 Lenovo ThinkCentre Tiny Core i7 32GB RAM 1TB SSD Wi-Fi PC Desktop. SSD : Select from above 120GB TO 1TB SSD. RAM : 8GB, 16GB OR 32GB. Windows : Windows 11 Pro. Gaming PC Bundles. Look no further than the Tiny mini computer!
www.ebay.co.uk
£75, i5, 16Gb Ram, 120GB SSD.

seems like it will do the job, I think I have to get a dongle now for the zigbee
Click to expand...
Go for a PoE dongle if you can as that’ll give you more flexibility with placement. The SMLight range are well regarded and I have the SLZB06 myself
 
Dr House said:
bought this
www.ebay.co.uk

Windows 11 PRO PC Tiny Core i7 32GB RAM 1TB SSD Wi-Fi PC Desktop | eBay UK

Windows 11 Lenovo ThinkCentre Tiny Core i7 32GB RAM 1TB SSD Wi-Fi PC Desktop. SSD : Select from above 120GB TO 1TB SSD. RAM : 8GB, 16GB OR 32GB. Windows : Windows 11 Pro. Gaming PC Bundles. Look no further than the Tiny mini computer!
www.ebay.co.uk
£75, i5, 16Gb Ram, 120GB SSD.

seems like it will do the job, I think I have to get a dongle now for the zigbee
Click to expand...
Strongly recommend the PoE recommendation as above, or a very cheap USB2 hub. I had big problems plugging a USB dongle into a USB 3.0 port, causes all sorts of nonsense
 
Finally found some errors.

Code: 
Logger: homeassistant.components.recorder.core
Source: components/recorder/core.py:1194
integration: Recorder (documentation, issues)
First occurred: 2 December 2025 at 17:46:24 (29584 occurrences)
Last logged: 16:06:32

Error in database connectivity during commit: Error executing query: (sqlite3.OperationalError) disk I/O error (Background on this error at: https://sqlalche.me/e/20/e3q8). (retrying in 3 seconds)
Error in database connectivity during commit: Error executing query: (sqlite3.OperationalError) unable to open database file (Background on this error at: https://sqlalche.me/e/20/e3q8). (retrying in 3 seconds)

Code: 
Logger: homeassistant.components.hassio
Source: components/hassio/websocket_api.py:145
integration: Home Assistant Supervisor (documentation, issues)
First occurred: 16:06:19 (1 occurrence)
Last logged: 16:06:19

Failed to to call /host/disks/default/usage -

Code: 
Logger: homeassistant.components.recorder.core
Source: components/recorder/core.py:896
integration: Recorder (documentation, issues)
First occurred: 2 December 2025 at 17:46:29 (1 occurrence)
Last logged: 2 December 2025 at 17:46:29

Unrecoverable sqlite3 database corruption detected: (sqlite3.DatabaseError) database disk image is malformed [SQL: UPDATE states SET last_reported_ts=? WHERE states.state_id = ?] [parameters: (1764696685.2828643, 442326)] (Background on this error at: https://sqlalche.me/e/20/4xp6)
Traceback (most recent call last):
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/engine/base.py", line 1963, in _exec_single_context
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/engine/default.py", line 943, in do_execute
sqlite3.DatabaseError: database disk image is malformed

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/usr/src/homeassistant/homeassistant/components/recorder/core.py", line 896, in _process_one_task_or_event_or_recover
  File "/usr/src/homeassistant/homeassistant/components/recorder/tasks.py", line 297, in run
  File "/usr/src/homeassistant/homeassistant/components/recorder/core.py", line 1192, in _commit_event_session_or_retry
  File "/usr/src/homeassistant/homeassistant/components/recorder/core.py", line 1218, in _commit_event_session
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/orm/session.py", line 2365, in execute
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/orm/session.py", line 2251, in _execute_internal
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/orm/bulk_persistence.py", line 1627, in orm_execute_statement
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/orm/bulk_persistence.py", line 357, in _bulk_update
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/orm/persistence.py", line 912, in _emit_update_statements
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/engine/base.py", line 1415, in execute
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/sql/elements.py", line 523, in _execute_on_connection
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/engine/base.py", line 1637, in _execute_clauseelement
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/engine/base.py", line 1842, in _execute_context
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/engine/base.py", line 1982, in _exec_single_context
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/engine/base.py", line 2351, in _handle_dbapi_exception
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/engine/base.py", line 1963, in _exec_single_context
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/engine/default.py", line 943, in do_execute
sqlalchemy.exc.DatabaseError: (sqlite3.DatabaseError) database disk image is malformed
[SQL: UPDATE states SET last_reported_ts=? WHERE states.state_id = ?]
[parameters: (1764696685.2828643, 442326)]
(Background on this error at: https://sqlalche.me/e/20/4xp6)

Theres a few more as well. Also get this when i try to restart the config.

Failed to reload configuration​


Cannot quick reload all YAML configurations because the configuration is not valid: File configuration.yaml not found.

A few searches a few people have mentioned SSDs can be a problem, but when i check my SSD is on the OK list.

I get this error as well, could that be the cause of crashing.
github.com

Pickers missing translations for en-GB · Issue #157033 · home-assistant/core

The problem I find the following errors in the logs. Logger: frontend.js.modern.202511051 Source: components/system_log/__init__.py:331 First occurred: 01:18:41 (2402 occurrences) Last logged: 01:3...
github.com github.com
 
Last edited:
Subliminal Aura said:
@robj20 is your disk or virtual disk full ? Or you need to rebuild home-assistant_v2.db ... better still restore to last working backup :D

Any context to your current setup - where is it in this thread
Click to expand...
It's a Raspberry Pi5, with an SSD and powered by Poe.
Nothing fancy. Loads of empty space it's a 256gb.

Is there a way to default the installation I wonder, I don't have loads of automations so doesn't take long to add them back.

I might see what the 2025.12 update did it says it fixes one of the issues that I can see.

Original post.

Home Assistant beginners

The lack of voice set alarms and moving back to bluetooth for speakers are bummers but I can live with that. Check out Music Assistant. Although predominantly for broadcasting music to WiFi enabled speakers such as HomePod and Echo, it exposes those speakers to Home Assistant to use as you wish.
forums.overclockers.co.uk forums.overclockers.co.uk
 
Last edited:
robj20 said:
It's a Raspberry Pi5, with an SSD and powered by Poe.
Nothing fancy. Loads of empty space it's a 256gb.
Click to expand...

Assuming that you used this guide https://www.home-assistant.io/installation/raspberrypi and have HASS OS fully installed

robj20 said:
Finding I need to restart HA most days, soon as I click on the settings page it crashes otherwise.
Going to try a Restart Home Assistant automation, the Restart Host Device didn't seem to work.

Honestly getting close to ditching all this automation stuff. Just checked and right now I can't access the device just get the HA logo and nothing else, the app fails to connect.
Click to expand...

This post is not filling me with any confidence with regards to the hardware/setup, have you tried running the PI from a stable power source with plenty of amps available ? Do you know what POE power profile is being delivered ?

- Can you get on your console
- type login (this should drop you into a root shell)
- Have a look through your kernel logs for clues eg journalctl -k

If you see absolutely nothing in your logs at the time of the crashes then 90% of the time it's a power issue
 
Does sound as if your database is corrupted which may be related to your power issues and/ or the constant restarting. You can delete or rename the database file so it's recreated on a reboot and see if that gets you anywhere. The database is just used for historical data from all your devices so it won't affect your automations or suchlike.

However, I do think you need to try your Pi with a non PoE power source just to rule out the power supply as an issue. HA is a stable appliance OS that shouldn't be giving you any issues such as those that you've experienced
 
Subliminal Aura said:
Assuming that you used this guide https://www.home-assistant.io/installation/raspberrypi and have HASS OS fully installed



This post is not filling me with any confidence with regards to the hardware/setup, have you tried running the PI from a stable power source with plenty of amps available ? Do you know what POE power profile is being delivered ?

- Can you get on your console
- type login (this should drop you into a root shell)
- Have a look through your kernel logs for clues eg journalctl -k

If you see absolutely nothing in your logs at the time of the crashes then 90% of the time it's a power issue
Click to expand...
POE+ and currently drawing 3.82W, console no idea what's that? I don't really know exactly when it crashes only find out when i try to access something. I have connected a USB PSU so will see how that goes.
 
Last edited:
robj20 said:
POE+ and currently drawing 3.82W, console no idea what's that? I don't really know exactly when it crashes only find out when i try to access something. Will try connecting a usb psu see how it gets on.
Click to expand...

You've accessed the console before according to this post ;)
Regarding POE it'll be the switch which decides how much power it's delivering anyway as suggested - get it off POE and onto a stable PSU that can deliver at least 15W... Personally the more the better
See how you get on
 
Subliminal Aura said:
You've accessed the console before according to this post ;)
Regarding POE it'll be the switch which decides how much power it's delivering anyway as suggested - get it off POE and onto a stable PSU that can deliver at least 15W... Personally the more the better
See how you get on
Click to expand...
The switch is POE++ the pi hat board is only +.
But yes external power supply added as well so plenty of power now.

That console, that means disconnecting the Pi5 from my switch and hooking it up to a monitor and keyboard but yes could be done if needed.
 
Bluecube said:
Does sound as if your database is corrupted which may be related to your power issues and/ or the constant restarting. You can delete or rename the database file so it's recreated on a reboot and see if that gets you anywhere. The database is just used for historical data from all your devices so it won't affect your automations or suchlike.

However, I do think you need to try your Pi with a non PoE power source just to rule out the power supply as an issue. HA is a stable appliance OS that shouldn't be giving you any issues such as those that you've experienced
Click to expand...
Which data base is it, I have the file explorer add-on so hopefully I can do it via that?

Thanks both of you for the assistance, it's kind of fun learning all this stuff but at the same time, I like it when it just works.

Backup plan is to go really simple and buy a really cheap NUC pc and just install on that.
Setting up the pi for the m.2 was a little annoying.
 
Last edited:
tres said:
Strongly recommend the PoE recommendation as above, or a very cheap USB2 hub. I had big problems plugging a USB dongle into a USB 3.0 port, causes all sorts of nonsense
Click to expand...
I just used a USB2 extension cable. 1.5 metres and I hang it above the mini PC.

I do think PoE is a brilliant solution for the dongle though. But the USB port issues are easy to overcome with a short (or long) extension.
 
Dr House said:
bought this
www.ebay.co.uk

Windows 11 PRO PC Tiny Core i7 32GB RAM 1TB SSD Wi-Fi PC Desktop | eBay UK

Windows 11 Lenovo ThinkCentre Tiny Core i7 32GB RAM 1TB SSD Wi-Fi PC Desktop. SSD : Select from above 120GB TO 1TB SSD. RAM : 8GB, 16GB OR 32GB. Windows : Windows 11 Pro. Gaming PC Bundles. Look no further than the Tiny mini computer!
www.ebay.co.uk
£75, i5, 16Gb Ram, 120GB SSD.

seems like it will do the job, I think I have to get a dongle now for the zigbee
Click to expand...

That seems like a bargain?

Will it suffice for runing Plex, Minecraft server and HAOS in a virtualbox all at the same time?

Also then will have 2* external HDD connected for photo backup, so want to run some sort of server for that as well.

Currently running my ROG ALLY at 10w and it seems to be ok just feels wrong though, or stupid.
 
Last edited:
I have a NUC running plex, and people did tell me to just run HA on that's as well, but i really like my devices separate. Might just bite the bullet and get an N97 based NUC for HA, should be mega low power, i presume you can just install HA on the pc as an OS?
 
Last edited:
You must log in or register to reply here.
Back
Top Bottom