GitHub user claude89757 added a comment to the discussion: Error on Inserting
Session Data: psycopg2.errors.NumericValueOutOfRange: integer out of range
### Fix for `airflow-web` Issue
1. **Check the Maximum ID**:
- Run the query:
`SELECT MAX(id) FROM session;`
Result: `2147483647`
2. **Delete Recent Entries**:
- Execute the query:
`DELETE FROM session WHERE id IN (SELECT id FROM session ORDER BY id DESC
LIMIT 1000000);`
3. **Verify the New Maximum ID**:
- Run the query:
`SELECT MAX(id) FROM session;`
Result: `2146483647`
This procedure temporarily resolves the issue with `airflow-web` by clearing a
large number of session records.
GitHub link:
https://github.com/apache/airflow/discussions/45782#discussioncomment-11876948
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]
