Hacker News new | past | comments | ask | show | jobs | submit login

Aaand we killed it.

> SQL ERROR [ mysqli ]

> User birdfo5_phpbb already has more than 'max_user_connections' active connections [1203]

> An sql error occurred while fetching this page. Please contact an administrator if this problem persists.




The influx of traffic has been a great surprise. I've contacted the host and updated the plan to handle the activity. They informed me the issue will be fixed soon. Sorry for any inconvenience.

Thank you for checking out Scooter Talk. Hope you enjoy!


You shouldn't need an updated plan to handle this. It seems as though every page load is hitting a database. I can't see the page since it won't load, but I'd imagine the content here can be easily cached.


If you don't want to pay more or deal with technical details like setting up cache servers, just put it behind CloudFlare or similar temporarily.


This is the best answer. Cloudflare free tier CDN is amazing, and is ridiculously easy to set up. They even provide and set up an SSL certificate for you.


Reduce the max users in your http servers. Your max database users should always be a bit less than your max http servers/instances/connections.

Http will queue connections if over the limit and everything will just work without errors. You won't even have an overloaded server (although some users may have a long wait).


If your database can’t handle the load, your queue will grow indefinitely. So users will have an infinite wait or timeout. Not a panacea.


Would be cool if it didn't leak half the authentication setup. Seems like the error handler could scan the text for configured values and mask before echoing it out.


Better yet, the error handler could not print anything back. A generic 500 is the way to go. Log your errors.

If you think you'd get worthwhile bug reports / don't want to implement log analysis or whatever, take whatever errors, stack traces, etc. you'd like, encrypt and base64 encode them, and print that.

Printing any hints about the nature of errors should be regarded as a security risk.


Absolutely true, and how I implement error handling personally (meaning give a friendly non technical message and track the error internally) I blame a brain collapse after a long day :)


> > User birdfo5_phpbb already has more than 'max_user_connections' active connections [1203]

I see not much has changed in web dev since the late '90s


Looks like someone could use pgbouncer :)


It's MySQL


exactly.


exactly! :D




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: