SQL ERROR [ mysqli ]

Post Reply New Topic

Yup, same here when I clicked the topic reply notification to try to get here. Ain't been fixed yet.

For a simple viewing activity like opening a post or looking at a forum, a retry is harmless enough - but when making a post, if the error appears on "Submit", then a browser "back" action (away from the error message to your post edit screen) followed by "Submit" should be Ok to retain both your post's content and avoid questions about resending data. Repeat until it eventually works.

Alex has responded to my report - it seems the problem may be caused by a tweak to a timeout setting at the hosting provider, a tweak they'd made.
But as yet, no actual fix.

I would suggest copying and pasting one's post into a separate text file, as a backup, before clicking "Submit."

Yep - I always do, for the more lengthy ones, and not just on WP.

Edit: actually, selecting all the text and copying it to the clipboard is sufficient in most cases and is easily done with Ctrl-A then Ctrl-C
In the event of the text vanishing it can be restored with Ctrl-V to paste into the post.

That approach sometimes causes me to get a double post so I have to delete the second one. Also if the glitch happens to me again after backing I may not be able to back a second time. It's safer to select all & copy the post before submitting a second time & after the second error I paste in a text file & then do something unrelated to WP & try again later or another day.

Glad to have an idea of what's going on. The hosting provider should prioritize a fix if other sites start reporting problems.

That should be fairly bulletproof. I'm too lazy / RSI averse to actually save it to the HD, but my browser has hardly ever crashed and (so far) this current problem isn't a browser-crashing thing.

I really thought WP was down when I arrived today. Must have refreshed at least 6 times and nothing. Even the front page wouldn't open. Different error message there. But in the end I got here. Moral: don't worry.

I just tried hitting that "re-send data" button and it didn't eat my post. But I wouldn't do it without copying post first, just in case.

I'm sure it is being worked on.

I found this. Just trying to help. Although, I understand it could be something more exotic. Perhaps a change was made and SQL connections are running rampant? Or something new is causing more connections than normal?
How to fix: mysql_connect(): Too many connections

I hit the refresh button as well, until the page loads.

My buddy ChatGPT says:

The error message "SQL ERROR [ mysqli ] Too many connections [1040]" indicates that the MySQL server has reached its maximum number of allowed connections. This issue can occur when too many clients are trying to connect to the MySQL server simultaneously, exceeding the limit set in the server's configuration.

Here are the steps to troubleshoot and fix this issue:

1. Check the Current Connection Limit:
- Connect to your MySQL server and run the following command to check the maximum allowed connections:

- This will display the current limit on the number of connections.

2. Increase the Maximum Connections Limit:
- If the current limit is too low, you can increase it. Edit the MySQL configuration file (`my.cnf` or `my.ini`, depending on your operating system). Find the `max_connections` setting and increase its value. For example:


- After making the change, restart the MySQL server to apply the new configuration.

3. Identify Long-Running Queries:
- Long-running queries can hold connections open for extended periods, contributing to the issue. Use the following command to identify any problematic queries:


- This will list all active connections and their states. Investigate and optimize any queries that are running for an unusually long time.

4. Optimize Connection Usage in Your Application:
- Ensure your application is properly closing database connections when they are no longer needed. Using a connection pool can help manage connections more efficiently.
- Review the code in your phpBB forum software or any other applications connecting to the MySQL server to ensure connections are being properly managed and closed.

5. Monitor Connection Usage:
- Set up monitoring to track the number of connections over time. Tools like MySQL Enterprise Monitor, phpMyAdmin, or third-party monitoring solutions can help you identify patterns and potential issues with connection usage.

6. Consider Hardware and Configuration Upgrades:
- If your server consistently reaches the connection limit despite optimization, it might be necessary to upgrade the server hardware or consider a more scalable database architecture, such as a database cluster.

By following these steps, you can address the "Too many connections [1040]" error and improve the reliability and performance of your MySQL server.

I am taking a break from WP for a while until this is cleared up.

Well, them SQuirreLs is still nutting around with my connection, even skipping characters when I type too fast.

By the way, I knew it was them SQuirreLs all along.  First the servers, then the power lines (or is it the other way around?).

Read the Complete and Unedited Article  HERE .

I’m getting it too, how long will it last? I really need WP online 24/7

^ WP remains online 24/7 - just with some irritating extra hoops to jump through.
It is possible, with care, to handle them - see earlier: viewtopic.php?f=13&t=420742&p=9507052#p9506663

It is happening here too.

The errors will be generated for every WP user.

Hasn't been fixed. Had to reload 7 times at one point.