After update to 0.72.2 all automation totally disappeared

  • I first made a snapshot. (was 0.76.2)
  • upgrade to the latest version (0.72.2)
  • automation does not work
  • I put the snapshot back
  • no automation at all (I have 2284 lines of automation.yaml file)
  • no configuration changes have occurred before
  • multiply hass.io host reboot - nothing changed.

Is there a possible authorization problem since 0.72.2 has already requested a user authentication?

The log complain database error… ???

Mon Sep 03 2018 12:20:35 GMT+0200
Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: ‘INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id) VALUES (?, ?, ?, ?, ?, ?, ?)’] [parameters: (‘service_registered’, ‘{“domain”: “recorder”, “service”: “purge”}’, ‘LOCAL’, ‘2018-09-03 10:20:03.588701’, ‘2018-09-03 10:20:35.044280’, ‘db8cbc81a0b94f2996f0f0772e864ac6’, None)] (Background on this error at: http://sqlalche.me/e/4xp6

That means:

DatabaseError

Exception raised for errors that are related to the database itself, and not the interface or data being passed.

This error is a DBAPI Error and originates from the database driver (DBAPI), not SQLAlchemy itself.

Unfortunately I do not get into the server because I’m abroad.
Is there any suggestion for someone?

After deleting home-assistant_v2.db, and hassio host reboot …

The home-assistent.log contains:

core-ssh:/config# cat home-assistant.log
2018-09-03 20:21:25 ERROR (MainThread) [homeassistant.core] Error doing job: Task exception was never retrieved
Traceback (most recent call last):
File “/usr/local/lib/python3.6/site-packages/homeassistant/setup.py”, line 56, in async_setup_component
return await task # type: ignore
File “/usr/local/lib/python3.6/site-packages/homeassistant/setup.py”, line 118, in _async_setup_component
conf_util.async_process_component_config(hass, config, domain)
File “/usr/local/lib/python3.6/site-packages/homeassistant/config.py”, line 675, in async_process_component_config
p_config)
File “/usr/local/lib/python3.6/site-packages/voluptuous/schema_builder.py”, line 267, in call
return self._compiled([], data)
File “/usr/local/lib/python3.6/site-packages/voluptuous/schema_builder.py”, line 589, in validate_dict
return base_validate(path, iteritems(data), out)
File “/usr/local/lib/python3.6/site-packages/voluptuous/schema_builder.py”, line 381, in validate_mapping
cval = cvalue(key_path, value)
File “/usr/local/lib/python3.6/site-packages/voluptuous/validators.py”, line 204, in _run
return self._exec(self._compiled, value, path)
File “/usr/local/lib/python3.6/site-packages/voluptuous/validators.py”, line 284, in _exec
v = func(path, v)
File “/usr/local/lib/python3.6/site-packages/voluptuous/schema_builder.py”, line 630, in validate_sequence
cval = validate(index_path, value)
File “/usr/local/lib/python3.6/site-packages/voluptuous/validators.py”, line 204, in _run
return self._exec(self._compiled, value, path)
File “/usr/local/lib/python3.6/site-packages/voluptuous/validators.py”, line 249, in _exec
return func(path, v)
File “/usr/local/lib/python3.6/site-packages/voluptuous/validators.py”, line 204, in _run
return self._exec(self._compiled, value, path)
File “/usr/local/lib/python3.6/site-packages/voluptuous/validators.py”, line 284, in _exec
v = func(path, v)
File “/usr/local/lib/python3.6/site-packages/voluptuous/schema_builder.py”, line 811, in validate_callable
return schema(data)
File “/usr/local/lib/python3.6/site-packages/voluptuous/schema_builder.py”, line 267, in call
return self._compiled([], data)
File “/usr/local/lib/python3.6/site-packages/voluptuous/schema_builder.py”, line 589, in validate_dict
return base_validate(path, iteritems(data), out)
File “/usr/local/lib/python3.6/site-packages/voluptuous/schema_builder.py”, line 381, in validate_mapping
cval = cvalue(key_path, value)
File “/usr/local/lib/python3.6/site-packages/voluptuous/schema_builder.py”, line 811, in validate_callable
return schema(data)
File “/usr/local/lib/python3.6/site-packages/homeassistant/helpers/config_validation.py”, line 325, in service
if valid_entity_id(value):
File “/usr/local/lib/python3.6/site-packages/homeassistant/core.py”, line 81, in valid_entity_id
return ENTITY_ID_PATTERN.match(entity_id) is not None
TypeError: expected string or bytes-like object
core-ssh:/config#

Solved!

In one of the action the service keyword contained nothing. Acidentally editing failure. Sorry!