[BUG] GOD Mode - Activity History: Sponsor Profile Logs not fetched from Database (500 Error)

[rknearn-qa]

Summary

In GOD Mode (Super Admin), the Activity History section for a Sponsor Profile fails to load. The backend returns a 500 Internal Server Error related to a Prisma database query (eventLog.findMany()), indicating a database-side resource or query optimization issue.

Preconditions:

• Sponsor with GOD Mode (https://nearn-app-staging.onrender.com/t/userqa/)
• Sponsor Profile changes made before

Steps To Reproduce

1. Navigate to the Activity History -> Sponsor Profile logs

Actual Result:

The page fails to load activity history.

API call returns 500 error:

{
  "error": "\nInvalid `prisma.eventLog.findMany()` invocation:\n\n\nError occurred during query execution:\nConnectorError(ConnectorError { user_facing_error: None, kind: QueryError(Server(MysqlError { code: 1038, message: \"Out of sort memory, consider increasing server sort buffer size\", state: \"HY001\" })), transient: false })"
}

sponsor.logs.-.rk.webm

Expected Result:

The Sponsor’s Activity History should load successfully, displaying all relevant events.
No backend errors should occur during query execution.

Special notes:
Database query for event logs may be retrieving too many records at once
or lacks proper pagination / filtering, causing MySQL “Out of sort memory” error.
Likely related to insufficient server sort buffer size or inefficient query ordering.

Workarounds: -

Repro rate: Always (10/10)

Setup - OS - Browser - Environment

Windows 11 (x64, 1366x768)

Reproduced in:
Chrome 140.0.7339.210
Mozilla Firefox 142.0
Safari
staging

Resources & Additional Notes

No response

Priority

🟡 P2 : Medium