Hi,
Been using home assistant for a while now, but the default DB is getting large for me and I want to try doing some more intensive queries and additional logging soon. Since I use oracle alot for other stuff, I thought maybe worth trying to get that setup at home, and after a bit of config I think I’m there, and can see connections coming in.
Problem I’ve now got is what looks like schema creation, I’m stuck with these errors:
tail: hass.log: file truncated
2019-02-20 19:56:09 WARNING (Recorder) [homeassistant.components.recorder.migration] Database is about to upgrade. Schema version: None
2019-02-20 19:56:09 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (cx_Oracle.IntegrityError) ORA-01400: cannot insert NULL into (“HASS”.“SCHEMA_CHANGES”.“CHANGE_ID”) [SQL: ‘INSERT INTO schema_changes (schema_version, changed) VALUES (:schema_version, :changed) RETURNING schema_changes.change_id INTO :ret_0’] [parameters: {‘schema_version’: 7, ‘changed’: datetime.datetime(2019, 2, 20, 19, 56, 9, 375077), ‘ret_0’: <cx_Oracle.STRING with value [[], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], []]>}] (Background on this error at: http://sqlalche.me/e/gkpj)
I can see that the tables have been created though which is positive at least, but is there some issue with how they’ve been made - should these allow nulls? I have tried manually updating table config but still no joy, but that might be the wrong direction anyway.
Appreciate it might not be a common DB backend choice but any pointers/suggestions would be gratefully received!