Unable to connect to nabu-casa

1

I got a problem lately - would like to say it has something to do with the last update to 0.118.3 release but I don’t think that’s the case (I even went back to the previous release 0.118.2 using a snapshot). Here below is my current log summary, to me it looks like I got a corrupt database. Question is, how do I fix that? Or is that not the root cause of my current trouble when connecting to nabu-casa? Sorry about the german log messages but all you need to know is:
Die Nachricht ist zum ersten Mal um 15:52:03 aufgetreten und erscheint 3364 mal.

The message first occured at 15:52:03 and showed up 3364 times.

Error saving events: (sqlite3.DatabaseError) database disk image is malformed [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id, context_parent_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('state_changed', '{}', 'LOCAL', '2020-11-24 16:15:33.236427', '2020-11-24 16:15:33.236427', 'cbe01b0aff47fe2d26895d05d87ef9d6', None, None)] (Background on this error at: http://sqlalche.me/e/13/4xp6)
17:15:39 – Recorder (ERROR) - Die Nachricht ist zum ersten Mal um 15:52:03 aufgetreten und erscheint 3364 mal
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, context_parent_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('state_changed', '{}', 'LOCAL', '2020-11-24 16:15:33.236427', '2020-11-24 16:15:33.236427', 'cbe01b0aff47fe2d26895d05d87ef9d6', None, None)] (Background on this error at: http://sqlalche.me/e/13/4xp6)
17:15:39 – Recorder (ERROR) - Die Nachricht ist zum ersten Mal um 15:52:03 aufgetreten und erscheint 3364 mal
Connection problem to snitun server
17:15:38 – /usr/local/lib/python3.8/site-packages/hass_nabucasa/remote.py (ERROR) - Die Nachricht ist zum ersten Mal um 15:51:54 aufgetreten und erscheint 398 mal
Can't connect to SniTun server eu-west-2.ui.nabu.casa:443
17:15:38 – /usr/local/lib/python3.8/site-packages/snitun/client/client_peer.py (ERROR) - Die Nachricht ist zum ersten Mal um 15:51:54 aufgetreten und erscheint 398 mal
Unable to activate Alexa Report State: Cannot connect to host alexa-api.nabucasa.com:443 ssl:default [Try again]. Retrying in 30 seconds
17:15:13 – Home Assistant Cloud (WARNING) - Die Nachricht ist zum ersten Mal um 15:52:18 aufgetreten und erscheint 143 mal
Unable to connect: Cannot connect to host cloud.nabucasa.com:443 ssl:default [Try again]
17:11:28 – /usr/local/lib/python3.8/site-packages/hass_nabucasa/iot_base.py (WARNING) - Die Nachricht ist zum ersten Mal um 15:51:48 aufgetreten und erscheint 70 mal
Platform error sensor.yr - Integration 'yr' not found.
17:11:00 – Hass.io (ERROR) - Die Nachricht ist zum ersten Mal um 16:01:16 aufgetreten und erscheint 2 mal
2

Well, I deleted the “malformed database disk image” but the connection to nabu-casa was still not working. Then I rebootet my internet gateway and that did the trick. I think I got a new IP adress at the wrong time and that was a problem. Not completely sure but - case is closed.

3

Did you ever get this figured out ? I have been experiencing very long waits before a connection is established from my phone to home assistant via nabu casa for the last couple of months and it has gone from slow connection to no connection most of the time. Commands seem to execute fairly quickly once connected , It just takes forever (sometimes over 1 min watching the ha logo and spinning wheel and always at least 30 seconds, and that is when i am connected to my home wifi network @ 300+ speeds). Up until about 2 months ago it was almost instant when connected via wifi and depending on sig strength never took longer than 30 sec on cell data. I am running Home Assistant Supervised Core on a dedicated vm inside a dell r720 commercial class server with a gigabit internet connection so bandwidth is not an issue. If anyone can help me out here it would be greatly appreciated, i am about to cancel nabu casa and just open a port in pfsense and be done with it, but just really don’t want to do that for obvious reasons. Sorry for the log post but just wanted to put all the info out there incase someone else can help.
Thanks