Server crash on handling API requests with large integer values

[OhmSpectator]

Description

A bug has been identified where the server crashes with a SequelizeDatabaseError when processing API requests with excessively large integer values. This issue leads to an 'out of range for type integer' error and was originally found by the Mayhem fuzzer.

Steps to Reproduce

1. Send an API request to any of the following endpoints with extremely large integer values:
   • /api/regions/-999999999999999999/siblings
   • /api/regions/-999999999999999999/geometry
   • /api/regions/999999999999999999/siblings
   • /api/regions/-786773861553238898/geometry

Expected Behavior

The API should handle large integer inputs correctly, either by processing them or by returning a proper error message, without causing a server crash.

Actual Behavior

The server crashes, throwing a SequelizeDatabaseError. This error states that the value "-999999999999999999" is out of range for the type integer.

Commit Version

This bug first found here: 527ad8e

Additional Context

This issue appears to arise from Sequelize's handling of large integer values in database queries. A solution might involve better input validation or modifications to query handling in Sequelize.

Possible Solution

• Implement robust input validation to ensure integer values are within a permissible range before processing the API request.
• Modify the Sequelize query construction to accommodate or reject large integer values gracefully.
• Introduce exception handling for SequelizeDatabaseError related to integer size limits to prevent the server from crashing.