POST API call to {hostname}/leaderboard/ in dev environment returns a server error: error: permission denied for sequence leaderboard_id_seq. This error occurs using AWS personal user creds, but not AWS prod creds.
Cause
I think there is some permission error in our AWS Postgres instance preventing api calls from localhost:3001 from going through to our database. This is why the error appears in dev but not prod.
Steps to Replicate
Open Dev Environment frontend and backend (with AWS personal user credentials)
Check console (API call is made immediately on page load in a useEffect)
Overview
POST API call to
{hostname}/leaderboard/in dev environment returns a server error:error: permission denied for sequence leaderboard_id_seq. This error occurs using AWS personal user creds, but not AWS prod creds.Cause
I think there is some permission error in our AWS Postgres instance preventing api calls from
localhost:3001from going through to our database. This is why the error appears in dev but not prod.Steps to Replicate
Frontend: zotnfound-frontend/src/components/Home/Home.jsx (Leaderboard GetInfo UseEffect) Backend: zotnfound-backend/routes/leaderboard.js/ (POST call from
await pool.query(...))Update - I believe this is happening to all API calls to Postgres Instance