ghost-on-heroku ER_USER_LIMIT_REACHED: User 'xxxx' has exceeded the 'max_questions' resource (current value: 3600)

ER_USER_LIMIT_REACHED: User 'xxxx' has exceeded the 'max_questions' resource (current value: 3600)

Open ashispavan opened this issue 3 years ago • 7 comments

Describe the bug With only a couple pages, I am getting this error on the deployed version of Ghost CMS on heroku: ER_USER_LIMIT_REACHED: User 'xxxx' has exceeded the 'max_questions' resource (current value: 3600)

To Reproduce Steps to reproduce the behavior:

Add/edit a couple of posts on the Ghost CMS instance. Read the instance APIs using a NextJS front-end stack deployed in Vercel.

Expected behavior No error should be thrown for seemingly light activities.

How are you deploying this? Clicked on 'Deploy to Heroku' and followed the setup steps.

Mar 14 '21 16:03 ashispavan

It seems to me that this is not an installation error, and it will exceed the database limit. Add migrate='safe' to your models. Otherwise mysql-adapter will spawn a new connection for every model/table it tries to alter (apparently ignoring the connection pool settings).