Skip to content

Instantly share code, notes, and snippets.

@kekonn
Created April 30, 2024 07:20
Show Gist options
  • Save kekonn/a36ddfd983773d6b3efc46ee9a42afda to your computer and use it in GitHub Desktop.
Save kekonn/a36ddfd983773d6b3efc46ee9a42afda to your computer and use it in GitHub Desktop.
HA Recorder error
Logger: homeassistant.components.recorder.core
Source: components/recorder/core.py:1187
integration: Recorder (documentation, issues)
First occurred: 29 April 2024 at 09:34:25 (31256 occurrences)
Last logged: 09:18:35
Error in database connectivity during commit: Error executing query: (psycopg2.errors.IndexCorrupted) right sibling's left-link doesn't match: block 51232 links to 17835 instead of expected 17748 in index "ix_states_metadata_id_last_updated_ts" [SQL: INSERT INTO states (entity_id, state, attributes, event_id, last_changed, last_changed_ts, last_reported_ts, last_updated, last_updated_ts, old_state_id, attributes_id, context_id, context_user_id, context_parent_id, origin_idx, context_id_bin, conte ... 15638 characters truncated ... 17, p18, sen_counter) ORDER BY sen_counter RETURNING states.state_id, states.state_id AS state_id__1] [parameters: {'entity_id__0': None, 'state__0': '0.00182197273456295', 'context_id__0': None, 'context_parent_id_bin__0': None, 'last_reported_ts__0': 1714376080.61078, 'origin_idx__0': 0, 'context_id_bin__0': <psycopg2.extensions.Binary object at 0x7f5b991140>, 'context_user_id__0': None, 'attributes_id__0': 1969655, 'last_changed__0': None, 'last_updated_ts__0': 1714376080.61078, 'attributes__0': None, 'old_state_id__0': 390141534, 'context_user_id_bin__0': None, 'context_parent_id__0': None, 'last_updated__0': None, 'event_id__0': None, 'last_changed_ts__0': None, 'metadata_id__0': 69, 'entity_id__1': None, 'state__1': '0.000436246992782678', 'context_id__1': None, 'context_parent_id_bin__1': None, 'last_reported_ts__1': 1714376080.611513, 'origin_idx__1': 0, 'context_id_bin__1': <psycopg2.extensions.Binary object at 0x7f5b991ad0>, 'context_user_id__1': None, 'attributes_id__1': 1969688, 'last_changed__1': None, 'last_updated_ts__1': 1714376080.611513, 'attributes__1': None, 'old_state_id__1': 390141535, 'context_user_id_bin__1': None, 'context_parent_id__1': None, 'last_updated__1': None, 'event_id__1': None, 'last_changed_ts__1': None, 'metadata_id__1': 26, 'entity_id__2': None, 'state__2': '0.000430633520449078', 'context_id__2': None, 'context_parent_id_bin__2': None, 'last_reported_ts__2': 1714376080.614254, 'origin_idx__2': 0, 'context_id_bin__2': <psycopg2.extensions.Binary object at 0x7f5b990c30>, 'context_user_id__2': None, 'attributes_id__2': 1969657, 'last_changed__2': None, 'last_updated_ts__2': 1714376080.614254, 'attributes__2': None ... 565 parameters truncated ... 'context_user_id__32': None, 'attributes_id__32': 54, 'last_changed__32': None, 'last_updated_ts__32': 1714376085.411261, 'attributes__32': None, 'old_state_id__32': 390141512, 'context_user_id_bin__32': None, 'context_parent_id__32': None, 'last_updated__32': None, 'event_id__32': None, 'last_changed_ts__32': None, 'metadata_id__32': 67, 'entity_id__33': None, 'state__33': '189', 'context_id__33': None, 'context_parent_id_bin__33': None, 'last_reported_ts__33': None, 'origin_idx__33': 0, 'context_id_bin__33': <psycopg2.extensions.Binary object at 0x7f5ba38060>, 'context_user_id__33': None, 'attributes_id__33': 55, 'last_changed__33': None, 'last_updated_ts__33': 1714376085.411823, 'attributes__33': None, 'old_state_id__33': 390141513, 'context_user_id_bin__33': None, 'context_parent_id__33': None, 'last_updated__33': None, 'event_id__33': None, 'last_changed_ts__33': None, 'metadata_id__33': 53, 'entity_id__34': None, 'state__34': '62', 'context_id__34': None, 'context_parent_id_bin__34': None, 'last_reported_ts__34': None, 'origin_idx__34': 0, 'context_id_bin__34': <psycopg2.extensions.Binary object at 0x7f5ba3b9c0>, 'context_user_id__34': None, 'attributes_id__34': 2580254, 'last_changed__34': None, 'last_updated_ts__34': 1714376085.412284, 'attributes__34': None, 'old_state_id__34': 390141514, 'context_user_id_bin__34': None, 'context_parent_id__34': None, 'last_updated__34': None, 'event_id__34': None, 'last_changed_ts__34': None, 'metadata_id__34': 6}] (Background on this error at: https://sqlalche.me/e/20/2j85). (retrying in 3 seconds)
Error in database connectivity during commit: Error executing query: (psycopg2.errors.IndexCorrupted) right sibling's left-link doesn't match: block 51232 links to 17835 instead of expected 17748 in index "ix_states_metadata_id_last_updated_ts" [SQL: INSERT INTO states (entity_id, state, attributes, event_id, last_changed, last_changed_ts, last_reported_ts, last_updated, last_updated_ts, old_state_id, attributes_id, context_id, context_user_id, context_parent_id, origin_idx, context_id_bin, conte ... 11678 characters truncated ... 17, p18, sen_counter) ORDER BY sen_counter RETURNING states.state_id, states.state_id AS state_id__1] [parameters: {'entity_id__0': None, 'state__0': '0.00184282277465918', 'context_id__0': None, 'context_parent_id_bin__0': None, 'last_reported_ts__0': 1714376090.584754, 'origin_idx__0': 0, 'context_id_bin__0': <psycopg2.extensions.Binary object at 0x7f62e50990>, 'context_user_id__0': None, 'attributes_id__0': 1969655, 'last_changed__0': None, 'last_updated_ts__0': 1714376090.584754, 'attributes__0': None, 'old_state_id__0': 390141588, 'context_user_id_bin__0': None, 'context_parent_id__0': None, 'last_updated__0': None, 'event_id__0': None, 'last_changed_ts__0': None, 'metadata_id__0': 69, 'entity_id__1': None, 'state__1': '0.000250200481154771', 'context_id__1': None, 'context_parent_id_bin__1': None, 'last_reported_ts__1': 1714376090.585426, 'origin_idx__1': 0, 'context_id_bin__1': <psycopg2.extensions.Binary object at 0x7f62e51050>, 'context_user_id__1': None, 'attributes_id__1': 1969688, 'last_changed__1': None, 'last_updated_ts__1': 1714376090.585426, 'attributes__1': None, 'old_state_id__1': 390141589, 'context_user_id_bin__1': None, 'context_parent_id__1': None, 'last_updated__1': None, 'event_id__1': None, 'last_changed_ts__1': None, 'metadata_id__1': 26, 'entity_id__2': None, 'state__2': '0.000167602245388933', 'context_id__2': None, 'context_parent_id_bin__2': None, 'last_reported_ts__2': 1714376090.588753, 'origin_idx__2': 0, 'context_id_bin__2': <psycopg2.extensions.Binary object at 0x7f62e517a0>, 'context_user_id__2': None, 'attributes_id__2': 1969657, 'last_changed__2': None, 'last_updated_ts__2': 1714376090.588753, 'attributes__2': None ... 394 parameters truncated ... 'context_user_id__23': None, 'attributes_id__23': 55, 'last_changed__23': None, 'last_updated_ts__23': 1714376095.402708, 'attributes__23': None, 'old_state_id__23': 390141570, 'context_user_id_bin__23': None, 'context_parent_id__23': None, 'last_updated__23': None, 'event_id__23': None, 'last_changed_ts__23': None, 'metadata_id__23': 53, 'entity_id__24': None, 'state__24': '65', 'context_id__24': None, 'context_parent_id_bin__24': None, 'last_reported_ts__24': None, 'origin_idx__24': 0, 'context_id_bin__24': <psycopg2.extensions.Binary object at 0x7f5b39adf0>, 'context_user_id__24': None, 'attributes_id__24': 2580254, 'last_changed__24': None, 'last_updated_ts__24': 1714376095.403715, 'attributes__24': None, 'old_state_id__24': 390141571, 'context_user_id_bin__24': None, 'context_parent_id__24': None, 'last_updated__24': None, 'event_id__24': None, 'last_changed_ts__24': None, 'metadata_id__24': 6, 'entity_id__25': None, 'state__25': '4030.988', 'context_id__25': None, 'context_parent_id_bin__25': None, 'last_reported_ts__25': None, 'origin_idx__25': 0, 'context_id_bin__25': <psycopg2.extensions.Binary object at 0x7f5b399920>, 'context_user_id__25': None, 'attributes_id__25': 61, 'last_changed__25': None, 'last_updated_ts__25': 1714376095.420642, 'attributes__25': None, 'old_state_id__25': None, 'context_user_id_bin__25': None, 'context_parent_id__25': None, 'last_updated__25': None, 'event_id__25': None, 'last_changed_ts__25': None, 'metadata_id__25': 21}] (Background on this error at: https://sqlalche.me/e/20/2j85). (retrying in 3 seconds)
Error in database connectivity during commit: Error executing query: (psycopg2.errors.IndexCorrupted) right sibling's left-link doesn't match: block 51232 links to 17835 instead of expected 17748 in index "ix_states_metadata_id_last_updated_ts" [SQL: INSERT INTO states (entity_id, state, attributes, event_id, last_changed, last_changed_ts, last_reported_ts, last_updated, last_updated_ts, old_state_id, attributes_id, context_id, context_user_id, context_parent_id, origin_idx, context_id_bin, conte ... 10798 characters truncated ... 17, p18, sen_counter) ORDER BY sen_counter RETURNING states.state_id, states.state_id AS state_id__1] [parameters: {'entity_id__0': None, 'state__0': '0.00302030869212023', 'context_id__0': None, 'context_parent_id_bin__0': None, 'last_reported_ts__0': 1714376100.52765, 'origin_idx__0': 0, 'context_id_bin__0': <psycopg2.extensions.Binary object at 0x7f5ba0dd70>, 'context_user_id__0': None, 'attributes_id__0': 1969655, 'last_changed__0': None, 'last_updated_ts__0': 1714376100.52765, 'attributes__0': None, 'old_state_id__0': 390141647, 'context_user_id_bin__0': None, 'context_parent_id__0': None, 'last_updated__0': None, 'event_id__0': None, 'last_changed_ts__0': None, 'metadata_id__0': 69, 'entity_id__1': None, 'state__1': '0.000389926888708367', 'context_id__1': None, 'context_parent_id_bin__1': None, 'last_reported_ts__1': 1714376100.528402, 'origin_idx__1': 0, 'context_id_bin__1': <psycopg2.extensions.Binary object at 0x7f61971dd0>, 'context_user_id__1': None, 'attributes_id__1': 1969688, 'last_changed__1': None, 'last_updated_ts__1': 1714376100.528402, 'attributes__1': None, 'old_state_id__1': 390141648, 'context_user_id_bin__1': None, 'context_parent_id__1': None, 'last_updated__1': None, 'event_id__1': None, 'last_changed_ts__1': None, 'metadata_id__1': 26, 'entity_id__2': None, 'state__2': '0.00123314378554021', 'context_id__2': None, 'context_parent_id_bin__2': None, 'last_reported_ts__2': 1714376100.530023, 'origin_idx__2': 0, 'context_id_bin__2': <psycopg2.extensions.Binary object at 0x7f5c2353e0>, 'context_user_id__2': None, 'attributes_id__2': 1969664, 'last_changed__2': None, 'last_updated_ts__2': 1714376100.530023, 'attributes__2': None ... 356 parameters truncated ... 'context_user_id__21': None, 'attributes_id__21': 1969699, 'last_changed__21': None, 'last_updated_ts__21': 1714376104.307362, 'attributes__21': None, 'old_state_id__21': None, 'context_user_id_bin__21': None, 'context_parent_id__21': None, 'last_updated__21': None, 'event_id__21': None, 'last_changed_ts__21': None, 'metadata_id__21': 50, 'entity_id__22': None, 'state__22': 'Monitoring', 'context_id__22': None, 'context_parent_id_bin__22': None, 'last_reported_ts__22': None, 'origin_idx__22': 0, 'context_id_bin__22': <psycopg2.extensions.Binary object at 0x7f5b405d70>, 'context_user_id__22': None, 'attributes_id__22': 1376232, 'last_changed__22': None, 'last_updated_ts__22': 1714376105.009746, 'attributes__22': None, 'old_state_id__22': None, 'context_user_id_bin__22': None, 'context_parent_id__22': None, 'last_updated__22': None, 'event_id__22': None, 'last_changed_ts__22': 1714376005.048321, 'metadata_id__22': 541, 'entity_id__23': None, 'state__23': '67', 'context_id__23': None, 'context_parent_id_bin__23': None, 'last_reported_ts__23': None, 'origin_idx__23': 0, 'context_id_bin__23': <psycopg2.extensions.Binary object at 0x7f5b406280>, 'context_user_id__23': None, 'attributes_id__23': 2580254, 'last_changed__23': None, 'last_updated_ts__23': 1714376105.405719, 'attributes__23': None, 'old_state_id__23': 390141627, 'context_user_id_bin__23': None, 'context_parent_id__23': None, 'last_updated__23': None, 'event_id__23': None, 'last_changed_ts__23': None, 'metadata_id__23': 6}] (Background on this error at: https://sqlalche.me/e/20/2j85). (retrying in 3 seconds)
Error in database connectivity during commit: Error executing query: (psycopg2.errors.IndexCorrupted) right sibling's left-link doesn't match: block 51232 links to 17835 instead of expected 17748 in index "ix_states_metadata_id_last_updated_ts" [SQL: UPDATE states SET last_reported_ts=%(last_reported_ts)s WHERE states.state_id = %(states_state_id)s] [parameters: [{'last_reported_ts': 1714376135.485695, 'states_state_id': 390141981}, {'last_reported_ts': 1714376135.486706, 'states_state_id': 390141982}, {'last_reported_ts': 1714376135.497482, 'states_state_id': 390141978}, {'last_reported_ts': 1714376135.499157, 'states_state_id': 390141979}, {'last_reported_ts': 1714376135.499569, 'states_state_id': 390141980}, {'last_reported_ts': 1714376136.729352, 'states_state_id': 390141950}, {'last_reported_ts': 1714376136.731921, 'states_state_id': 390141983}, {'last_reported_ts': 1714376136.734185, 'states_state_id': 390141984} ... displaying 10 of 16 total bound parameter sets ... {'last_reported_ts': 1714376139.204542, 'states_state_id': 390141941}, {'last_reported_ts': 1714376139.204625, 'states_state_id': 390141942}]] (Background on this error at: https://sqlalche.me/e/20/2j85). (retrying in 3 seconds)
Error in database connectivity during commit: Error executing query: (psycopg2.errors.InFailedSqlTransaction) current transaction is aborted, commands ignored until end of transaction block [SQL: UPDATE states SET last_reported_ts=%(last_reported_ts)s WHERE states.state_id = %(states_state_id)s] [parameters: [{'last_reported_ts': 1714376135.485695, 'states_state_id': 390141981}, {'last_reported_ts': 1714376135.486706, 'states_state_id': 390141982}, {'last_reported_ts': 1714376135.497482, 'states_state_id': 390141978}, {'last_reported_ts': 1714376135.499157, 'states_state_id': 390141979}, {'last_reported_ts': 1714376135.499569, 'states_state_id': 390141980}, {'last_reported_ts': 1714376136.729352, 'states_state_id': 390141950}, {'last_reported_ts': 1714376136.731921, 'states_state_id': 390141983}, {'last_reported_ts': 1714376136.734185, 'states_state_id': 390141984} ... displaying 10 of 16 total bound parameter sets ... {'last_reported_ts': 1714376139.204542, 'states_state_id': 390141941}, {'last_reported_ts': 1714376139.204625, 'states_state_id': 390141942}]] (Background on this error at: https://sqlalche.me/e/20/2j85). (retrying in 3 seconds)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment