had an issue overnight regarding our psql backing ...
# ask-community
d
had an issue overnight regarding our psql backing database for dagster:
Copy code
sqlalchemy.exc.InternalError: (psycopg2.errors.IndexCorrupted) index "idx_event_type" contains unexpected zero page at block 234195
HINT:  Please REINDEX it.

[SQL: INSERT INTO event_logs (run_id, event, dagster_event_type, timestamp, step_key, asset_key, partition) VALUES (%(run_id)s, %(event)s, %(dagster_event_type)s, %(timestamp)s, %(step_key)s, %(asset_key)s, %(partition)s)
Is this a known issue? The solution ended up being to truncate a couple of tables to get rid of "duplicate key" errors, and then reindex the database, but not sure what caused it in the first place