Hi,
My mariadb database upgrade takes a whole week now. I don’t see any progress. Just my sensors are not updated, which is fine for a couple of hours but this is a bit long.
I installed mariaDB 2.6.10 in the 2.5.2 addon. It is a 1.7Gb states table. Due to powerloss the system restarted yesterday and I got the notification the upgrade is busy and system performance is degraded. Which is fine, but how can I tell is isn’t stuck or hanging?
In the 2023.2.3, I believe, I had to drop the homeassistant database and import it back in. Which was in addon version 2.5.1. Due to indexes being corrupt. It worked fine afterwards and I still had all my data.
I read something about setting the logger level to info instead of the default warning level. This is something I didn’t do. And there are no log entries regarding the MariaDB.
EDIT:
MariaDB Log:
2023-02-20 22:50:52 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-02-20 22:50:52 0 [Note] Server socket created on IP: '::'.
2023-02-20 22:50:52 0 [Note] /usr/bin/mariadbd: ready for connections.
Version: '10.6.10-MariaDB' socket: '/run/mysqld/mysqld.sock' port: 3306 MariaDB Server
[22:50:53] INFO: Check data integrity and fix corruptions
mysql.column_stats OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.global_priv OK
mysql.gtid_slave_pos OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.index_stats OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.roles_mapping OK
mysql.servers OK
mysql.table_stats OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.transaction_registry OK
nginxproxymanager.access_list OK
nginxproxymanager.access_list_auth OK
nginxproxymanager.access_list_client OK
nginxproxymanager.audit_log OK
nginxproxymanager.auth OK
nginxproxymanager.certificate OK
nginxproxymanager.dead_host OK
nginxproxymanager.migrations OK
nginxproxymanager.migrations_lock OK
nginxproxymanager.proxy_host OK
nginxproxymanager.redirection_host OK
nginxproxymanager.setting OK
nginxproxymanager.stream OK
nginxproxymanager.user OK
nginxproxymanager.user_permission OK
phpmyadmin.pma__bookmark OK
phpmyadmin.pma__central_columns OK
phpmyadmin.pma__column_info OK
phpmyadmin.pma__designer_settings OK
phpmyadmin.pma__export_templates OK
phpmyadmin.pma__favorite OK
phpmyadmin.pma__history OK
phpmyadmin.pma__navigationhiding OK
phpmyadmin.pma__pdf_pages OK
phpmyadmin.pma__recent OK
phpmyadmin.pma__relation OK
phpmyadmin.pma__savedsearches OK
phpmyadmin.pma__table_coords OK
phpmyadmin.pma__table_info OK
phpmyadmin.pma__table_uiprefs OK
phpmyadmin.pma__tracking OK
phpmyadmin.pma__userconfig OK
phpmyadmin.pma__usergroups OK
phpmyadmin.pma__users OK
sys.sys_config OK
[22:50:53] INFO: Ensuring internal database upgrades are performed
[22:50:53] INFO: Ensure databases exists
[22:50:54] INFO: Create database HomeAssistant
[22:50:54] INFO: Ensure users exists and are updated
[22:50:54] INFO: Update user homeass
[22:50:54] INFO: Init/Update rights
[22:50:54] INFO: Granting all privileges to homeass on HomeAssistant
[22:50:55] ERROR: Got unexpected response from the API: There is already a MySQL service in use from core_mariadb
[22:50:55] INFO: Successfully send service information to Home Assistant.
2023-02-21 5:44:04 27 [Warning] Aborted connection 27 to db: 'HomeAssistant' user: 'homeass' host: '172.30.XXX.XXX' (Got an error reading communication packets)
2023-02-21 5:44:04 31 [Warning] Aborted connection 31 to db: 'HomeAssistant' user: 'homeass' host: '172.30.XXX.XXX' (Got an error reading communication packets)
2023-02-21 5:44:04 33 [Warning] Aborted connection 33 to db: 'HomeAssistant' user: 'homeass' host: '172.30.XXX.XXX' (Got an error reading communication packets)
2023-02-21 5:44:04 26 [Warning] Aborted connection 26 to db: 'HomeAssistant' user: 'homeass' host: '172.30.XXX.XXX' (Got an error reading communication packets)
2023-02-21 7:24:45 28 [Warning] Aborted connection 28 to db: 'HomeAssistant' user: 'homeass' host: '192.168.XXX.XXX' (Got timeout reading communication packets)
Edit 2:
Some hardware info:
- Quad 'Core' Intel(R) Celeron(R) CPU J1900
- 240 SATA SSD
- 4Gb Memory
Mem info:
total used free shared buff/cache available
Mem: 3638 1928 201 1 1508 1449
Swap: 7977 496 7481
Is there anything else I can do?