How long does Database upgrade take?

wanders2 · February 15, 2022, 2:05am

I recently updated to version 2022.2.3 of Home assistant from 2021.12.10 and received the notification below

Database upgrade in progress

System performance will temporarily degrade during the database upgrade. Do not power down or restart the system until the upgrade completes. Integrations that read the database, such as logbook and history, may return inconsistent results until the upgrade completes.

Last week

How long should this database upgrade take? Is there a way to check on the status of the database upgrade?

So far everything seems to be working but I don’t want to make any changes till the database upgrade is complete since I can’t restart

tom_l · February 15, 2022, 2:13am

How big is your database and what hardware are you running on?

The worst case I’ve seen ( a massive 30 day db on a pi3) took 36 hours.

wanders2 · February 15, 2022, 2:22am

I’m running on a Raspberry Pi 4. I believe my database is 4.22 gig. I’m looking at home-assistant_v2.db in windows file explorer. on the samba share.

tom_l · February 15, 2022, 2:50am

If you updated last week it’s definitely finished.

wanders2 · February 15, 2022, 3:08am

Thanks Tom, Kind of what I thought but wanted to be sure. Wish there was some way to verify. I checked the logs and didn’t see a completion message

tom_l · February 15, 2022, 3:15am

It will actually prevent and warn you if you attempt to restart during a database upgrade.

Also, maybe it was logged in the Supervisor log?

duceduc · February 15, 2022, 3:23am

I wondered about that question as well. Saw that prompt for a brief second after the upgrade. A few hours a later I restarted HA having forgotten about the warning. Didn’t see a warning about database is in progress of upgrading though.

I noticed the lights turn on a tad slower after a motion has been detected with this version. Maybe it is in my head.

gerardsamara · February 15, 2022, 8:30am

Hi
The issue is that there is no log message indicating that the DB update is completed.
This is a recurrent problem for users

ondras12345 · February 15, 2022, 9:06am

It looks like there is, but it’s log level is INFO while the first message is a WARNING.

github.com

home-assistant/core/blob/33623c3fe86e52a5cf89b5d495901a213eeb4a07/homeassistant/components/recorder/migration.py#L70-L80


      
          def migrate_schema(instance, current_version):
              """Check if the schema needs to be upgraded."""
              _LOGGER.warning("Database is about to upgrade. Schema version: %s", current_version)
              for version in range(current_version, SCHEMA_VERSION):
                  new_version = version + 1
                  _LOGGER.info("Upgrading recorder db schema to version %s", new_version)
                  _apply_update(instance, new_version, current_version)
                  with session_scope(session=instance.get_session()) as session:
                      session.add(SchemaChanges(schema_version=new_version))
          
                  _LOGGER.info("Upgrade to version %s done", new_version)

gerardsamara · February 17, 2022, 1:44pm

Thanks a lot @ondras12345

my default log level is “warning” , so il will change it to “info”

logger:
  default: warning
  logs:
    homeassistant.components.mqtt: info
    homeassistant.components.shell_command: info

Then il will see these messages :

“Upgrading recorder db schema to version %s”
“Upgrade to version %s done”, new_version

ondras12345 · February 17, 2022, 2:06pm

It should probably be enough to just change it for homeassistant.components.recorder.migration.

logger:
  default: warning
  logs:
    homeassistant.components.mqtt: info
    homeassistant.components.shell_command: info
    homeassistant.components.recorder.migration: info