brianjking
November 20, 2016, 10:00pm
1
Home Assistant
Home Assistant Version: 0.33.0
Raspberry Pi 3
All-in-One Installer
MySQL DB Driver
Explanation
On 16 November I switched from the default database setup to using MySQL, however, the log displayed at the /dev-info screen is still displaying info from before the MySQL database was setup. I’ve restarted the Pi, Home Assistant, upgraded Home Assistant to the newly released 0.33.0, etc.
Any ideas?
Thanks!
gistfile1.txt
The following errors have been logged this session:
16-11-16 16:17:14 homeassistant.components.recorder: Ended unfinished session (id=65 from 2016-11-16 04:59:43.136255)
16-11-16 16:17:14 homeassistant.components.recorder: Found unfinished sessions
16-11-16 16:18:05 homeassistant.components.recorder: Error during query: (sqlite3.OperationalError) database is locked [SQL: 'SELECT states.state_id AS states_state_id, states.domain AS states_domain, states.entity_id AS states_entity_id, states.state AS states_state, states.attributes AS states_attributes, states.event_id AS states_event_id, states.last_changed AS states_last_changed, states.last_updated AS states_last_updated, states.created AS states_created \nFROM states \nWHERE states.entity_id = ? AND states.last_changed = states.last_updated AND states.state != ? ORDER BY states.state_id DESC\n LIMIT ? OFFSET ?'] [parameters: ('sensor.speedtest_upload', 'unknown', 1, 0)]
16-11-16 16:18:10 homeassistant.components.recorder: Error during query: (sqlite3.OperationalError) database is locked [SQL: 'SELECT states.state_id AS states_state_id, states.domain AS states_domain, states.entity_id AS states_entity_id, states.state AS states_state, states.attributes AS states_attributes, states.event_id AS states_event_id, states.last_changed AS states_last_changed, states.last_updated AS states_last_updated, states.created AS states_created \nFROM states \nWHERE states.entity_id = ? AND states.last_changed = states.last_updated AND states.state != ? ORDER BY states.state_id DESC\n LIMIT ? OFFSET ?'] [parameters: ('sensor.speedtest_upload', 'unknown', 1, 0)]
16-11-16 16:18:35 homeassistant.components.recorder: Error during query: (sqlite3.OperationalError) database is locked
16-11-16 16:18:40 homeassistant.components.recorder: Error during query: (sqlite3.OperationalError) database is locked
16-11-16 16:18:45 homeassistant.components.recorder: Error during query: (sqlite3.OperationalError) database is locked
16-11-16 16:18:51 homeassistant.components.recorder: Error during query: (sqlite3.OperationalError) database is lockedshow original
dap35
November 21, 2016, 2:05am
2
I have seen this as well. I think it is a browser cache problem.
I switched from Safari to Chrome and didn’t see the problem. Then I went into Safari and cleared the cache and the system updated, but Safari seems to be stuck on a cached version of dev-info log.
