MongoDB query "offset is out of range" error

[injaan]

Checklist

• [x] I have searched budibase discussions and github issues to check if my issue already exists

Hosting

• Self
  • Method: Docker
  • Budibase Version: 2.32.16
  • App Version: 2.32.16
• Cloud
  • Tenant ID:

Describe the bug

• Connected to MongoDB successfully
• Tried to get all records from profiles collection (collection has ~85k records)
• Error says "Query Error: The value of "offset" is out of range. It must be >= 0 && <= 17825792. Received 17825797"

To Reproduce Steps to reproduce the behavior:

1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

Expected behavior A clear and concise description of what you expected to happen.

Screenshots

App Export If possible - please attach an export of your budibase application for debugging/reproduction purposes.

Desktop (please complete the following information):

• OS: [e.g. iOS]
• Browser [e.g. chrome, safari]
• Version [e.g. 22]

Additional context Add any other context about the problem here.

[linear[bot]]

BUDI-8725 MongoDB query "offset is out of range" error

[ConorWebb96]

Closing, please follow the bug template.