Sonos events causing HUGE Recorder database

I finally dove into my home-assistant_v2.db file to see why it was HUGE, and I found events from my Sonos gear filling it up.

I added an exclusion for media_player to the recorder section of my config, but it left me with a question: why is it happening? The events show no changes; this is idle Sonos gear.

Below is a sample of events from my Sonos devices; these are constantly streaming in, even when everything is idle:

{"new_state": {"last_changed": "2017-01-18T22:13:49.622577+00:00", "last_updated": "2017-01-18T22:14:32.570893+00:00", "attributes": {"entity_picture": "/api/media_player_proxy/media_player.living_room?token=139720318873728&cache=dcd40", "media_duration": 3253, "media_title": "Pool Party Tape", "media_content_id": "Pool Party Tape", "friendly_name": "Living Room", "source_list": ["102.9 | 102.9 MGK (Classic Rock)", "20130529 Funky Summer", "20141221 Party Solstice", "60s Rock", "88.5 HD2 | XPN2 - WXPN-HD2 (Eclectic)", "90.9 HD2 | WHYY-HD2 (Art)", "Ambient", "B.B. King Radio", "Chuckle Radio", "Classical Music - The Essential Collection", "Deep House", "Dinner Music", "Disco", "G+R 3- Rock-,Elec-", "GREG WILSON @ BESTIVAL JA\u0308GERHAUS 10.09.16", "Hipster Holidays Radio", "Ibiza Global Radio", "Mark Knopfler Radio", "Pool Party Tape", "Progressive1", "Say Hey (I Love You) Radio", "Sleepytime Tunes (Children's) Radio", "Soft", "SomaFM: Christmas Lounge", "White Room Radio", "Line-in", "TV", "Line-in", "TV"], "supported_media_commands": 31247, "media_artist": "Hypnolove", "media_position_updated_at": "2017-01-18T22:14:32.556633+00:00", "is_volume_muted": false, "media_album_name": "", "media_position": 0, "volume_level": 0.25, "media_content_type": "music"}, "state": "paused", "entity_id": "media_player.living_room"}, "old_state": {"last_changed": "2017-01-18T22:13:49.622577+00:00", "last_updated": "2017-01-18T22:14:21.582306+00:00", "attributes": {"entity_picture": "/api/media_player_proxy/media_player.living_room?token=139720318873728&cache=dcd40", "media_duration": 3253, "media_title": "Pool Party Tape", "media_content_id": "Pool Party Tape", "friendly_name": "Living Room", "source_list": ["102.9 | 102.9 MGK (Classic Rock)", "20130529 Funky Summer", "20141221 Party Solstice", "60s Rock", "88.5 HD2 | XPN2 - WXPN-HD2 (Eclectic)", "90.9 HD2 | WHYY-HD2 (Art)", "Ambient", "B.B. King Radio", "Chuckle Radio", "Classical Music - The Essential Collection", "Deep House", "Dinner Music", "Disco", "G+R 3- Rock-,Elec-", "GREG WILSON @ BESTIVAL JA\u0308GERHAUS 10.09.16", "Hipster Holidays Radio", "Ibiza Global Radio", "Mark Knopfler Radio", "Pool Party Tape", "Progressive1", "Say Hey (I Love You) Radio", "Sleepytime Tunes (Children's) Radio", "Soft", "SomaFM: Christmas Lounge", "White Room Radio", "Line-in", "TV", "Line-in", "TV"], "supported_media_commands": 31247, "media_artist": "Hypnolove", "media_position_updated_at": "2017-01-18T22:14:21.568112+00:00", "is_volume_muted": false, "media_album_name": "", "media_position": 0, "volume_level": 0.25, "media_content_type": "music"}, "state": "paused", "entity_id": "media_player.living_room"}, "entity_id": "media_player.living_room"}
{"new_state": {"last_changed": "2017-01-18T22:13:49.628041+00:00", "last_updated": "2017-01-18T22:14:32.578251+00:00", "attributes": {"entity_picture": "/api/media_player_proxy/media_player.living_room?token=139720318873728&cache=dcd40", "media_duration": 3253, "media_title": "Pool Party Tape", "media_content_id": "Pool Party Tape", "friendly_name": "LRTV", "supported_media_commands": 32267, "media_artist": "Hypnolove", "active_child": "media_player.living_room", "media_position_updated_at": "2017-01-18T22:14:32.556633+00:00", "is_volume_muted": false, "media_album_name": "", "media_position": 0, "volume_level": 0.25, "media_content_type": "music"}, "state": "paused", "entity_id": "media_player.lrtv"}, "old_state": {"last_changed": "2017-01-18T22:13:49.628041+00:00", "last_updated": "2017-01-18T22:14:21.589595+00:00", "attributes": {"entity_picture": "/api/media_player_proxy/media_player.living_room?token=139720318873728&cache=dcd40", "media_duration": 3253, "media_title": "Pool Party Tape", "media_content_id": "Pool Party Tape", "friendly_name": "LRTV", "supported_media_commands": 32267, "media_artist": "Hypnolove", "active_child": "media_player.living_room", "media_position_updated_at": "2017-01-18T22:14:21.568112+00:00", "is_volume_muted": false, "media_album_name": "", "media_position": 0, "volume_level": 0.25, "media_content_type": "music"}, "state": "paused", "entity_id": "media_player.lrtv"}, "entity_id": "media_player.lrtv"}
{"new_state": {"last_changed": "2017-01-18T22:13:49.622577+00:00", "last_updated": "2017-01-18T22:14:42.564067+00:00", "attributes": {"entity_picture": "/api/media_player_proxy/media_player.living_room?token=139720318873728&cache=dcd40", "media_duration": 3253, "media_title": "Pool Party Tape", "media_content_id": "Pool Party Tape", "friendly_name": "Living Room", "source_list": ["102.9 | 102.9 MGK (Classic Rock)", "20130529 Funky Summer", "20141221 Party Solstice", "60s Rock", "88.5 HD2 | XPN2 - WXPN-HD2 (Eclectic)", "90.9 HD2 | WHYY-HD2 (Art)", "Ambient", "B.B. King Radio", "Chuckle Radio", "Classical Music - The Essential Collection", "Deep House", "Dinner Music", "Disco", "G+R 3- Rock-,Elec-", "GREG WILSON @ BESTIVAL JA\u0308GERHAUS 10.09.16", "Hipster Holidays Radio", "Ibiza Global Radio", "Mark Knopfler Radio", "Pool Party Tape", "Progressive1", "Say Hey (I Love You) Radio", "Sleepytime Tunes (Children's) Radio", "Soft", "SomaFM: Christmas Lounge", "White Room Radio", "Line-in", "TV", "Line-in", "TV"], "supported_media_commands": 31247, "media_artist": "Hypnolove", "media_position_updated_at": "2017-01-18T22:14:42.549599+00:00", "is_volume_muted": false, "media_album_name": "", "media_position": 0, "volume_level": 0.25, "media_content_type": "music"}, "state": "paused", "entity_id": "media_player.living_room"}, "old_state": {"last_changed": "2017-01-18T22:13:49.622577+00:00", "last_updated": "2017-01-18T22:14:32.570893+00:00", "attributes": {"entity_picture": "/api/media_player_proxy/media_player.living_room?token=139720318873728&cache=dcd40", "media_duration": 3253, "media_title": "Pool Party Tape", "media_content_id": "Pool Party Tape", "friendly_name": "Living Room", "source_list": ["102.9 | 102.9 MGK (Classic Rock)", "20130529 Funky Summer", "20141221 Party Solstice", "60s Rock", "88.5 HD2 | XPN2 - WXPN-HD2 (Eclectic)", "90.9 HD2 | WHYY-HD2 (Art)", "Ambient", "B.B. King Radio", "Chuckle Radio", "Classical Music - The Essential Collection", "Deep House", "Dinner Music", "Disco", "G+R 3- Rock-,Elec-", "GREG WILSON @ BESTIVAL JA\u0308GERHAUS 10.09.16", "Hipster Holidays Radio", "Ibiza Global Radio", "Mark Knopfler Radio", "Pool Party Tape", "Progressive1", "Say Hey (I Love You) Radio", "Sleepytime Tunes (Children's) Radio", "Soft", "SomaFM: Christmas Lounge", "White Room Radio", "Line-in", "TV", "Line-in", "TV"], "supported_media_commands": 31247, "media_artist": "Hypnolove", "media_position_updated_at": "2017-01-18T22:14:32.556633+00:00", "is_volume_muted": false, "media_album_name": "", "media_position": 0, "volume_level": 0.25, "media_content_type": "music"}, "state": "paused", "entity_id": "media_player.living_room"}, "entity_id": "media_player.living_room"}
{"new_state": {"last_changed": "2017-01-18T22:13:49.628041+00:00", "last_updated": "2017-01-18T22:14:42.571372+00:00", "attributes": {"entity_picture": "/api/media_player_proxy/media_player.living_room?token=139720318873728&cache=dcd40", "media_duration": 3253, "media_title": "Pool Party Tape", "media_content_id": "Pool Party Tape", "friendly_name": "LRTV", "supported_media_commands": 32267, "media_artist": "Hypnolove", "active_child": "media_player.living_room", "media_position_updated_at": "2017-01-18T22:14:42.549599+00:00", "is_volume_muted": false, "media_album_name": "", "media_position": 0, "volume_level": 0.25, "media_content_type": "music"}, "state": "paused", "entity_id": "media_player.lrtv"}, "old_state": {"last_changed": "2017-01-18T22:13:49.628041+00:00", "last_updated": "2017-01-18T22:14:32.578251+00:00", "attributes": {"entity_picture": "/api/media_player_proxy/media_player.living_room?token=139720318873728&cache=dcd40", "media_duration": 3253, "media_title": "Pool Party Tape", "media_content_id": "Pool Party Tape", "friendly_name": "LRTV", "supported_media_commands": 32267, "media_artist": "Hypnolove", "active_child": "media_player.living_room", "media_position_updated_at": "2017-01-18T22:14:32.556633+00:00", "is_volume_muted": false, "media_album_name": "", "media_position": 0, "volume_level": 0.25, "media_content_type": "music"}, "state": "paused", "entity_id": "media_player.lrtv"}, "entity_id": "media_player.lrtv"}
{"new_state": {"last_changed": "2017-01-18T22:13:49.622577+00:00", "last_updated": "2017-01-18T22:14:52.563558+00:00", "attributes": {"entity_picture": "/api/media_player_proxy/media_player.living_room?token=139720318873728&cache=dcd40", "media_duration": 3253, "media_title": "Pool Party Tape", "media_content_id": "Pool Party Tape", "friendly_name": "Living Room", "source_list": ["102.9 | 102.9 MGK (Classic Rock)", "20130529 Funky Summer", "20141221 Party Solstice", "60s Rock", "88.5 HD2 | XPN2 - WXPN-HD2 (Eclectic)", "90.9 HD2 | WHYY-HD2 (Art)", "Ambient", "B.B. King Radio", "Chuckle Radio", "Classical Music - The Essential Collection", "Deep House", "Dinner Music", "Disco", "G+R 3- Rock-,Elec-", "GREG WILSON @ BESTIVAL JA\u0308GERHAUS 10.09.16", "Hipster Holidays Radio", "Ibiza Global Radio", "Mark Knopfler Radio", "Pool Party Tape", "Progressive1", "Say Hey (I Love You) Radio", "Sleepytime Tunes (Children's) Radio", "Soft", "SomaFM: Christmas Lounge", "White Room Radio", "Line-in", "TV", "Line-in", "TV"], "supported_media_commands": 31247, "media_artist": "Hypnolove", "media_position_updated_at": "2017-01-18T22:14:52.549344+00:00", "is_volume_muted": false, "media_album_name": "", "media_position": 0, "volume_level": 0.25, "media_content_type": "music"}, "state": "paused", "entity_id": "media_player.living_room"}, "old_state": {"last_changed": "2017-01-18T22:13:49.622577+00:00", "last_updated": "2017-01-18T22:14:42.564067+00:00", "attributes": {"entity_picture": "/api/media_player_proxy/media_player.living_room?token=139720318873728&cache=dcd40", "media_duration": 3253, "media_title": "Pool Party Tape", "media_content_id": "Pool Party Tape", "friendly_name": "Living Room", "source_list": ["102.9 | 102.9 MGK (Classic Rock)", "20130529 Funky Summer", "20141221 Party Solstice", "60s Rock", "88.5 HD2 | XPN2 - WXPN-HD2 (Eclectic)", "90.9 HD2 | WHYY-HD2 (Art)", "Ambient", "B.B. King Radio", "Chuckle Radio", "Classical Music - The Essential Collection", "Deep House", "Dinner Music", "Disco", "G+R 3- Rock-,Elec-", "GREG WILSON @ BESTIVAL JA\u0308GERHAUS 10.09.16", "Hipster Holidays Radio", "Ibiza Global Radio", "Mark Knopfler Radio", "Pool Party Tape", "Progressive1", "Say Hey (I Love You) Radio", "Sleepytime Tunes (Children's) Radio", "Soft", "SomaFM: Christmas Lounge", "White Room Radio", "Line-in", "TV", "Line-in", "TV"], "supported_media_commands": 31247, "media_artist": "Hypnolove", "media_position_updated_at": "2017-01-18T22:14:42.549599+00:00", "is_volume_muted": false, "media_album_name": "", "media_position": 0, "volume_level": 0.25, "media_content_type": "music"}, "state": "paused", "entity_id": "media_player.living_room"}, "entity_id": "media_player.living_room"}

Any insight into why this is happening? Am I alone?

You are not alone!

I too have a huge db file, and it’s caused by Sonos events spamming as well.