Shell command gurus, really need some help

mattlward · March 20, 2018, 1:50pm

Damn, spoke to soon! When run from an HA automation, after about 10 minutes… I got this again:

2018-03-20 08:48:00 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.OperationalError) disk I/O error (Background on this error at: http://sqlalche.me/e/e3q8)
2018-03-20 08:48:00 ERROR (Recorder) [homeassistant.components.recorder] Error in database connectivity: (sqlite3.OperationalError) disk I/O error (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)

It will run the command hundreds of times from a script, but when fired internally it is again killing the data base.

I did have a snapshot being created as well.

Yevgeniy · March 20, 2018, 2:00pm

Could you show your automation used and the configuration of the recorder? Have you removed “datа_template” from automation?

mattlward · March 20, 2018, 2:05pm

I have not… I need to?

Yevgeniy · March 20, 2018, 2:18pm

I mean, did you change the automation like this:

- id: "Broadcast Real Temp HTTP"
  alias: 'Broadcast Real Temp HTTP'
  initial_state: 'off'
  hide_entity: false
  trigger:
    - platform: time
      minutes: '/2'
      seconds: '30'
  action:
    service: shell_command.wu_temp_http

I’m not sure that the error is due to this. But I use curl commands with HassIO without any issues

mattlward · March 20, 2018, 5:27pm

I have made the requested changes and enabled 2 of the automations for testing. Here are the automations, after the requested change:

- id: "Broadcast Real Temp HTTP"
  alias: 'Broadcast Real Temp HTTP'
  initial_state: 'off'
  hide_entity: false
  trigger:
    - platform: time
      minutes: '/2'
      seconds: '30'
  action:
    - service: shell_command.wu_temp_http
#      data_template:
#        state: '{{ states.sensor.pws_temp_f.state }}'

- id: "Broadcast Feels Like Temp HTTP"
  alias: 'Broadcast Feels Like Temp HTTP'
  initial_state: 'off'
  hide_entity: false
  trigger:
    - platform: time
      minutes: '/2'
      seconds: '45'
  action:
    - service: shell_command.wu_fl_http
#      data_template:
#        state: '{{ states.sensor.pws_feelslike_f.state }}'

- id: "Broadcast Humidity HTTP"
  alias: 'Broadcast Humidity HTTP'
  initial_state: 'off'
  hide_entity: false
  trigger:
    - platform: time
      minutes: '/3'
      seconds: '0'
  action:
    - service: shell_command.wu_humidity_http
#      data_template:
#        state: '{{ states.sensor.pws_relative_humidity.state }}'

- id: "Broadcast Wind HTTP"
  alias: 'Broadcast Wind HTTP'
  initial_state: 'off'
  hide_entity: false
  trigger:
    - platform: time
      minutes: '/3'
      seconds: '15'
  action:
    - service: shell_command.wu_wind_http
#      data_template:
#        state: '{{ states.sensor.pws_wind_mph.state }}'

- id: "Broadcast Gust HTTP"
  alias: 'Broadcast Gust HTTP'
  initial_state: 'off'
  hide_entity: false
  trigger:
    - platform: time
      minutes: '/3'
      seconds: '30'
  action:
    - service: shell_command.wu_gust_http
#      data_template:
#        state: '{{ states.sensor.pws_wind_gust_mph.state }}'

- id: "Broadcast Wind Deg HTTP"
  alias: 'Broadcast Wind Deg HTTP'
  initial_state: 'off'
  hide_entity: false
  trigger:
    - platform: time
      minutes: '/3'
      seconds: '45'
  action:
    - service: shell_command.wu_wind_deg_http
#      data_template:
#        state: '{{ states.sensor.pws_wind_degrees.state }}'

And the shell commands, testing single and double quotes:

shell_command:
  wu_temp_http: 'curl GET http://192.168.1.121/control?cmd=event,RealTemp={{ states.sensor.pws_temp_f.state }}'
  wu_fl_http: 'curl GET http://192.168.1.121/control?cmd=event,FeelsLike={{states.sensor.pws_feelslike_f.state}}'
  wu_wind_http: 'curl GET http://192.168.1.121/control?cmd=event,Wind={{states.sensor.pws_wind_mph.state}}'
  wu_gust_http: 'curl GET http://192.168.1.121/control?cmd=event,Gust={{states.sensor.pws_wind_gust_mph.state}}'
  wu_wind_deg_http: "curl GET http://192.168.1.121/control?cmd=event,WindDeg={{states.sensor.pws_wind_degrees.state}}"
  wu_humidity_http: "curl GET http://192.168.1.121/control?cmd=event,Humidity={{states.sensor.pws_relative_humidity.state}}"

Yevgeniy · March 20, 2018, 5:45pm

Same error? Have you tried deleting the file home-assistant_v2.db? Warning, this will delete your entire history of sensor, switches etc

mattlward · March 20, 2018, 6:05pm

Yes, over and over. I have 4 running now and have only had this error on the new config:

2018-03-20 12:52:31 ERROR (MainThread) [homeassistant.components.shell_command] Error running command: `curl GET http://192.168.1.121/control?cmd=event,RealTemp={{ states.sensor.pws_temp_f.state }}`, return code: -11
NoneType: None

Could this be caused by WU not populating a variable? Once in a while WU just does not return data for a specific value for a poll cycle or 2.

Yevgeniy · March 20, 2018, 6:18pm

Do you have a recorder configured to store history of these sensors?

recorder:
  include:
    entities:
      - sensor.pws_temp_f
      - sensor.pws_feelslike_f
      - sensor.pws_wind_mph
      - sensor.pws_wind_gust_mph
      - sensor.pws_wind_degrees
      - sensor.pws_relative_humidity

mattlward · March 20, 2018, 6:29pm

I have them excluded, not interested in longterm data on these.

Yevgeniy · March 20, 2018, 6:33pm

Maybe HA does not find the state in the recorder and an error occurs? Please try to enable recording for these sensors

mattlward · March 20, 2018, 11:12pm

So, the logs looked like hell this afternoon after enabling the automations. I will add them into the recorder now and reboot.

Logs:

2018-03-20 12:07:19 WARNING (SyncWorker_0) [homeassistant.components.emulated_hue] When targeting Google Home, listening port has to be port 80
2018-03-20 12:07:39 WARNING (MainThread) [homeassistant.setup] Setup of wemo is taking over 10 seconds.
2018-03-20 12:07:42 WARNING (MainThread) [homeassistant.components.sensor] Setup of platform snmp is taking over 10 seconds.
2018-03-20 12:17:46 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.pws_weather_1d is taking over 10 seconds
2018-03-20 12:17:46 ERROR (MainThread) [homeassistant.components.sensor.wunderground] Error fetching WUnderground data: TimeoutError()
2018-03-20 12:52:31 ERROR (MainThread) [homeassistant.components.shell_command] Error running command: `curl GET http://192.168.1.121/control?cmd=event,RealTemp={{ states.sensor.pws_temp_f.state }}`, return code: -11
NoneType: None
2018-03-20 14:10:22 ERROR (MainThread) [aiohttp.server] Error handling request
Traceback (most recent call last):
  File "/usr/lib/python3.6/site-packages/aiohttp/web_protocol.py", line 231, in data_received
    messages, upgraded, tail = self._request_parser.feed_data(data)
  File "aiohttp\_http_parser.pyx", line 295, in aiohttp._http_parser.HttpParser.feed_data
aiohttp.http_exceptions.BadStatusLine: invalid HTTP method
2018-03-20 14:19:50 ERROR (MainThread) [homeassistant.core] Error doing job: Fatal error on transport TCPTransport (error status in uv_stream_t.read callback)
TimeoutError: [Errno 110] Operation timed out
2018-03-20 14:34:45 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.OperationalError) disk I/O error (Background on this error at: http://sqlalche.me/e/e3q8)
2018-03-20 14:34:46 ERROR (Recorder) [homeassistant.components.recorder] Error in database connectivity: (sqlite3.OperationalError) disk I/O error (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)
2018-03-20 14:46:28 ERROR (MainThread) [homeassistant.components.camera.generic] Error getting new camera image: None
2018-03-20 14:46:29 ERROR (MainThread) [homeassistant.components.camera.generic] Error getting new camera image: None
2018-03-20 15:06:46 ERROR (MainThread) [homeassistant.core] Error doing job: Task exception was never retrieved
Traceback (most recent call last):
  File "/usr/lib/python3.6/asyncio/tasks.py", line 182, in _step
    result = coro.throw(exc)
  File "/usr/lib/python3.6/site-packages/homeassistant/components/discovery.py", line 135, in scan_devices
    results = yield from hass.async_add_job(_discover, netdisco)
  File "/usr/lib/python3.6/asyncio/futures.py", line 332, in __iter__
    yield self  # This tells Task to wait for completion.
  File "/usr/lib/python3.6/asyncio/tasks.py", line 250, in _wakeup
    future.result()
  File "/usr/lib/python3.6/asyncio/futures.py", line 245, in result
    raise self._exception
  File "/usr/lib/python3.6/concurrent/futures/thread.py", line 56, in run
    result = self.fn(*self.args, **self.kwargs)
  File "/usr/lib/python3.6/site-packages/homeassistant/components/discovery.py", line 161, in _discover
    netdisco.scan()
  File "/usr/lib/python3.6/site-packages/netdisco/discovery.py", line 54, in scan
    self.mdns.start()
  File "/usr/lib/python3.6/site-packages/netdisco/mdns.py", line 21, in start
    self.zeroconf = zeroconf.Zeroconf()
  File "/usr/lib/python3.6/site-packages/zeroconf.py", line 1670, in __init__
    socket.inet_aton(_MDNS_ADDR) + socket.inet_aton(i))
OSError: [Errno 9] Bad file descriptor
2018-03-20 15:22:46 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.OperationalError) disk I/O error (Background on this error at: http://sqlalche.me/e/e3q8)
2018-03-20 15:22:46 ERROR (Recorder) [homeassistant.components.recorder] Error in database connectivity: (sqlite3.OperationalError) disk I/O error (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)
2018-03-20 16:10:46 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.OperationalError) disk I/O error (Background on this error at: http://sqlalche.me/e/e3q8)
2018-03-20 16:10:46 ERROR (Recorder) [homeassistant.components.recorder] Error in database connectivity: (sqlite3.OperationalError) disk I/O error (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)
2018-03-20 16:17:18 ERROR (MainThread) [aiohttp.server] Error handling request
Traceback (most recent call last):
  File "/usr/lib/python3.6/site-packages/aiohttp/web_protocol.py", line 231, in data_received
    messages, upgraded, tail = self._request_parser.feed_data(data)
  File "aiohttp\_http_parser.pyx", line 295, in aiohttp._http_parser.HttpParser.feed_data
aiohttp.http_exceptions.BadStatusLine: invalid HTTP method
2018-03-20 16:24:34 ERROR (MainThread) [aiohttp.server] Error handling request
Traceback (most recent call last):
  File "/usr/lib/python3.6/site-packages/aiohttp/web_protocol.py", line 231, in data_received
    messages, upgraded, tail = self._request_parser.feed_data(data)
  File "aiohttp\_http_parser.pyx", line 295, in aiohttp._http_parser.HttpParser.feed_data
aiohttp.http_exceptions.BadStatusLine: invalid HTTP method
2018-03-20 16:46:43 ERROR (MainThread) [homeassistant.components.camera.generic] Error getting new camera image: None
2018-03-20 16:46:44 ERROR (MainThread) [homeassistant.components.camera.generic] Error getting new camera image: None
2018-03-20 16:48:16 ERROR (MainThread) [homeassistant.core] Error doing job: UVProcess exit callback called with handle.data == NULL
2018-03-20 17:16:46 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.OperationalError) disk I/O error (Background on this error at: http://sqlalche.me/e/e3q8)
2018-03-20 17:16:46 ERROR (Recorder) [homeassistant.components.recorder] Error in database connectivity: (sqlite3.OperationalError) disk I/O error (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)
2018-03-20 17:28:45 ERROR (MainThread) [homeassistant.components.shell_command] Error running command: `curl GET http://192.168.1.121/control?cmd=event,FeelsLike={{states.sensor.pws_feelslike_f.state}}`, return code: -11
NoneType: None
2018-03-20 17:35:02 ERROR (MainThread) [aiohttp.server] Error handling request
Traceback (most recent call last):
  File "/usr/lib/python3.6/site-packages/aiohttp/web_protocol.py", line 231, in data_received
    messages, upgraded, tail = self._request_parser.feed_data(data)
  File "aiohttp\_http_parser.pyx", line 295, in aiohttp._http_parser.HttpParser.feed_data
aiohttp.http_exceptions.BadStatusLine: invalid HTTP method
2018-03-20 17:50:31 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.OperationalError) disk I/O error (Background on this error at: http://sqlalche.me/e/e3q8)
2018-03-20 17:50:31 ERROR (Recorder) [homeassistant.components.recorder] Error in database connectivity: (sqlite3.OperationalError) disk I/O error (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)

mattlward · March 20, 2018, 11:43pm

Ok, recorder recording WU stuff now. Stopped HA, deleted database, started HA and had these errors appear. This is a fresh reboot and the logfile from boot going forward.

2018-03-20 18:17:30 WARNING (SyncWorker_5) [homeassistant.components.emulated_hue] When targeting Google Home, listening port has to be port 80
2018-03-20 18:17:44 WARNING (MainThread) [homeassistant.setup] Setup of wemo is taking over 10 seconds.
2018-03-20 18:17:47 WARNING (MainThread) [homeassistant.components.sensor] Setup of platform snmp is taking over 10 seconds.
2018-03-20 18:34:29 ERROR (MainThread) [homeassistant.core] Error doing job: Fatal error on transport TCPTransport (error status in uv_stream_t.read callback)
TimeoutError: [Errno 110] Operation timed out
2018-03-20 18:36:45 ERROR (MainThread) [homeassistant.components.shell_command] Error running command: `curl GET http://192.168.1.121/control?cmd=event,FeelsLike={{states.sensor.pws_feelslike_f.state}}`, return code: -11
NoneType: None
2018-03-20 18:39:45 ERROR (MainThread) [homeassistant.components.shell_command] Error running command: `curl GET http://192.168.1.121/control?cmd=event,WindDeg={{states.sensor.pws_wind_degrees.state}}`, return code: -11
NoneType: None
2018-03-20 18:52:35 WARNING (MainThread) [aiohttp.websocket] websocket connection is closing.
2018-03-20 19:05:49 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.tankpi_temp is taking over 10 seconds
2018-03-20 19:21:30 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.OperationalError) disk I/O error (Background on this error at: http://sqlalche.me/e/e3q8)
2018-03-20 19:21:30 ERROR (Recorder) [homeassistant.components.recorder] Error in database connectivity: (sqlite3.OperationalError) disk I/O error (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)

mattlward · March 21, 2018, 12:46pm

So, out of desperation last night I set up MariaDB and managed to get it running. I do not like going this route, less information and I can’t even find the database to check it’s size. But, vast improvement the database does not go offline with these automations running…

I am getting some stuff in the log file, I think most of it is due to WU queries for radar images (cameras) that do fail from time to time. I have also noticed that the api does not always give back 100% of requested weather data.

Here are my most recent logs, since a reboot at about 11:18 last night… yes, it ran all night!

2018-03-20 23:18:37 WARNING (SyncWorker_16) [homeassistant.components.emulated_hue] When targeting Google Home, listening port has to be port 80
2018-03-20 23:18:56 WARNING (MainThread) [homeassistant.setup] Setup of wemo is taking over 10 seconds.
2018-03-20 23:19:14 WARNING (MainThread) [homeassistant.components.sensor] Setup of platform snmp is taking over 10 seconds.
2018-03-20 23:35:41 ERROR (MainThread) [homeassistant.core] Error doing job: Fatal error on transport TCPTransport (error status in uv_stream_t.read callback)
TimeoutError: [Errno 110] Operation timed out
2018-03-21 00:58:49 ERROR (MainThread) [aiohttp.server] Error handling request
Traceback (most recent call last):
  File "/usr/lib/python3.6/site-packages/aiohttp/web_protocol.py", line 231, in data_received
    messages, upgraded, tail = self._request_parser.feed_data(data)
  File "aiohttp\_http_parser.pyx", line 295, in aiohttp._http_parser.HttpParser.feed_data
aiohttp.http_exceptions.BadStatusLine: invalid HTTP method
2018-03-21 01:19:43 ERROR (MainThread) [homeassistant.components.camera.generic] Error getting new camera image: None
2018-03-21 02:06:25 ERROR (MainThread) [homeassistant.components.camera.generic] Timeout getting camera image
2018-03-21 02:44:27 ERROR (MainThread) [aiohttp.server] Error handling request
Traceback (most recent call last):
  File "/usr/lib/python3.6/site-packages/aiohttp/web_protocol.py", line 231, in data_received
    messages, upgraded, tail = self._request_parser.feed_data(data)
  File "aiohttp\_http_parser.pyx", line 295, in aiohttp._http_parser.HttpParser.feed_data
aiohttp.http_exceptions.BadStatusLine: invalid HTTP method
2018-03-21 02:56:45 ERROR (MainThread) [homeassistant.core] Error doing job: Task exception was never retrieved
Traceback (most recent call last):
  File "/usr/lib/python3.6/asyncio/tasks.py", line 180, in _step
    result = coro.send(None)
ValueError: coroutine already executing
2018-03-21 03:06:02 ERROR (MainThread) [homeassistant.components.sensor.wunderground] Error fetching WUnderground data: ClientConnectorError(-3, 'Try again')
2018-03-21 03:19:49 ERROR (MainThread) [homeassistant.components.camera.generic] Error getting new camera image: None
2018-03-21 04:06:40 ERROR (MainThread) [homeassistant.components.camera.generic] Error getting new camera image: None
2018-03-21 04:19:09 ERROR (MainThread) [homeassistant.core] Timer got out of sync. Resetting
2018-03-21 05:20:03 ERROR (MainThread) [homeassistant.components.camera.generic] Error getting new camera image: None
2018-03-21 06:06:55 ERROR (MainThread) [homeassistant.components.camera.generic] Error getting new camera image: None
2018-03-21 06:36:15 ERROR (MainThread) [homeassistant.core] Error doing job: Task exception was never retrieved
Traceback (most recent call last):
  File "/usr/lib/python3.6/asyncio/tasks.py", line 180, in _step
    result = coro.send(None)
ValueError: coroutine already executing

I do not consider this fixed because I had to change the database to keep it running.

Yevgeniy · March 21, 2018, 1:04pm

I read in your first post that you tried it on different sd cards. Which class of micro sd card do you use?

mattlward · March 21, 2018, 1:08pm

I have tried Sandisk Ultra’s and Ultra Elite’s, all class 10 and now I am using one of their video recording cards made for security cameras, the white ones also class 10.

Yevgeniy · March 21, 2018, 1:24pm

Please try to change the http method

wu_temp_http: 'curl POST http://192.168.1.121/control?cmd=event,RealTemp={{ states.sensor.pws_temp_f.state }}'

If you turn off these automation HassIO is working fine?

mattlward · March 21, 2018, 1:36pm

Hassio works great with those turned off. I will try that, but it will be with MariaDB until I roll back to the stock database. Which I intend to do, that was just one more testing data point.

Can you tell me what the difference between GET and Post would be?

mattlward · March 22, 2018, 4:59am

Made the change and it instantly blew up MariaDB on boot!:

018-03-21 23:51:37 WARNING (SyncWorker_5) [homeassistant.components.emulated_hue] When targeting Google Home, listening port has to be port 80
2018-03-21 23:51:51 WARNING (MainThread) [homeassistant.setup] Setup of wemo is taking over 10 seconds.
2018-03-21 23:52:20 WARNING (MainThread) [homeassistant.components.sensor] Setup of platform snmp is taking over 10 seconds.
2018-03-21 23:57:00 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (_mysql_exceptions.OperationalError) (2006, 'MySQL server has gone away') [SQL: 'INSERT INTO events (event_type, event_data, origin, time_fired, created) VALUES (%s, %s, %s, %s, %s)'] [parameters: ('call_service', '{"domain": "shell_command", "service": "wu_humidity_http", "service_data": {}, "service_call_id": "1968015376-34"}', 'LOCAL', datetime.datetime(2018, 3, 22, 4, 57, 0, 61924, tzinfo=<UTC>), datetime.datetime(2018, 3, 22, 4, 57, 0, 207624))] (Background on this error at: http://sqlalche.me/e/e3q8)
2018-03-21 23:57:00 ERROR (Recorder) [homeassistant.components.recorder] Error in database connectivity: (_mysql_exceptions.OperationalError) (2006, 'MySQL server has gone away') [SQL: 'INSERT INTO events (event_type, event_data, origin, time_fired, created) VALUES (%s, %s, %s, %s, %s)'] [parameters: ('call_service', '{"domain": "shell_command", "service": "wu_humidity_http", "service_data": {}, "service_call_id": "1968015376-34"}', 'LOCAL', datetime.datetime(2018,3, 22, 4, 57, 0, 61924, tzinfo=<UTC>), datetime.datetime(2018, 3, 22, 4, 57, 0, 207624))] (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)

mattlward · March 22, 2018, 1:01pm

Back to stock DB with GET’s, verify issue present and same. Will not convert to POST’s and reboot:

2018-03-22 04:05:21 ERROR (MainThread) [homeassistant.core] Timer got out of sync. Resetting
2018-03-22 04:20:45 ERROR (MainThread) [homeassistant.components.shell_command] Error running command: `curl GET http://192.168.1.121/control?cmd=event,FeelsLike={{states.sensor.pws_feelslike_f.state}}`, return code: -11
NoneType: None
2018-03-22 04:33:00 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.OperationalError) disk I/O error (Background on this error at: http://sqlalche.me/e/e3q8)
2018-03-22 04:33:00 ERROR (Recorder) [homeassistant.components.recorder] Error in database connectivity: (sqlite3.OperationalError) disk I/O error (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)
2018-03-22 04:48:00 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.OperationalError) disk I/O error (Background on this error at: http://sqlalche.me/e/e3q8)
2018-03-22 04:48:00 ERROR (Recorder) [homeassistant.components.recorder] Error in database connectivity: (sqlite3.OperationalError) disk I/O error (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)
2018-03-22 05:00:05 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.OperationalError) database is locked [SQL: 'INSERT INTO events (event_type, event_data, origin, time_fired, created) VALUES (?, ?, ?, ?, ?)'] [parameters: ('logbook_entry', '{"name": "Basement IP address", "message": "has been triggered", "domain": "automation", "entity_id": "automation.basement_ip_address"}', 'LOCAL', '2018-03-22 10:00:00.303192', '2018-03-22 10:00:00.476038')] (Background on this error at: http://sqlalche.me/e/e3q8)
2018-03-22 05:00:05 ERROR (Recorder) [homeassistant.components.recorder] Error in database connectivity: (sqlite3.OperationalError) database is locked [SQL: 'INSERT INTO events (event_type, event_data, origin, time_fired, created) VALUES (?, ?, ?, ?, ?)'] [parameters: ('logbook_entry', '{"name": "Basement IP address", "message": "has been triggered", "domain": "automation", "entity_id": "automation.basement_ip_address"}', 'LOCAL', '2018-03-22 10:00:00.303192', '2018-03-22 10:00:00.476038')] (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)
2018-03-22 05:15:30 ERROR (MainThread) [homeassistant.components.shell_command] Error running command: `curl GET http://192.168.1.121/control?cmd=event,Gust={{states.sensor.pws_wind_gust_mph.state}}`, return code: -11
NoneType: None
2018-03-22 05:40:30 ERROR (MainThread) [homeassistant.components.shell_command] Error running command: `curl GET http://192.168.1.121/control?cmd=event,RealTemp={{ states.sensor.pws_temp_f.state }}`, return code: -11
NoneType: None
2018-03-22 05:45:30 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.OperationalError) disk I/O error (Background on this error at: http://sqlalche.me/e/e3q8)
2018-03-22 05:45:30 ERROR (Recorder) [homeassistant.components.recorder] Error in database connectivity: (sqlite3.OperationalError) disk I/O error (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)
2018-03-22 06:26:45 ERROR (MainThread) [homeassistant.components.shell_command] Error running command: `curl GET http://192.168.1.121/control?cmd=event,FeelsLike={{states.sensor.pws_feelslike_f.state}}`, return code: -11
NoneType: None
2018-03-22 06:27:15 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.OperationalError) disk I/O error (Background on this error at: http://sqlalche.me/e/e3q8)
2018-03-22 06:27:15 ERROR (Recorder) [homeassistant.components.recorder] Error in database connectivity: (sqlite3.OperationalError) disk I/O error (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)
2018-03-22 06:51:00 ERROR (MainThread) [homeassistant.core] Error doing job: Task exception was never retrieved
Traceback (most recent call last):
  File "/usr/lib/python3.6/asyncio/tasks.py", line 180, in _step
    result = coro.send(None)
ValueError: coroutine already executing
2018-03-22 06:58:45 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.OperationalError) disk I/O error (Background on this error at: http://sqlalche.me/e/e3q8)
2018-03-22 06:58:45 ERROR (Recorder) [homeassistant.components.recorder] Error in database connectivity: (sqlite3.OperationalError) disk I/O error (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)
2018-03-22 07:14:45 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.OperationalError) disk I/O error (Background on this error at: http://sqlalche.me/e/e3q8)
2018-03-22 07:14:45 ERROR (Recorder) [homeassistant.components.recorder] Error in database connectivity: (sqlite3.OperationalError) disk I/O error (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)
2018-03-22 07:30:15 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.OperationalError) disk I/O error (Background on this error at: http://sqlalche.me/e/e3q8)
2018-03-22 07:30:15 ERROR (Recorder) [homeassistant.components.recorder] Error in database connectivity: (sqlite3.OperationalError) disk I/O error (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)
2018-03-22 07:42:00 ERROR (MainThread) [homeassistant.components.shell_command] Error running command: `curl GET http://192.168.1.121/control?cmd=event,Humidity={{states.sensor.pws_relative_humidity.state}}`, return code: -11
NoneType: None
2018-03-22 07:45:45 ERROR (MainThread) [homeassistant.components.shell_command] Error running command: `curl GET http://192.168.1.121/control?cmd=event,WindDeg={{states.sensor.pws_wind_degrees.state}}`, return code: -11
NoneType: None
2018-03-22 07:55:04 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.pws_alerts is taking over 10 seconds
2018-03-22 07:55:04 ERROR (MainThread) [homeassistant.components.sensor.wunderground] Error fetching WUnderground data: TimeoutError()

mattlward · March 23, 2018, 2:45pm

I have converted to POSTS and it results in hard crashes around 24 hours in while accessing the web interface on the Pi. I could not catch a log since the unit crashed.

I do not understand what the problem is here. I had been pushing this data with MQTT but the remote device had a software change that no longer allows it to take more than 4 MQTT unique inputs. So, that prompted the change to HTTP to feed the units with data.

I am going back to GETs and guess I will reboot every 8 to 12 hours. I may fall back to the last version of 64 as the problem was not nearly as bad.