Created
April 30, 2024 07:20
-
-
Save kekonn/a36ddfd983773d6b3efc46ee9a42afda to your computer and use it in GitHub Desktop.
HA Recorder error
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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