Page 2 of 6 [ 82 posts ]  Go to page Previous  1, 2, 3, 4, 5, 6  Next

ToughDiamond
Veteran
Veteran

User avatar

Joined: 15 Sep 2008
Age: 71
Gender: Male
Posts: 11,685

18 May 2024, 2:47 am

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



Cornflake
Administrator
Administrator

User avatar

Joined: 30 Oct 2010
Gender: Male
Posts: 66,766
Location: Over there

18 May 2024, 7:18 am

ToughDiamond wrote:
BillyTree wrote:
^ For me it works to hit refresh button.

That's probably easier than the "back button and retry" method for most operations. One exception may be when submitting a long post. If I refresh the page then, the browser says it can't do it unless it re-sends the data, which makes me think it might eat the post. Probably PTSD from the "Cloudflare ate my post" days, haven't experimented further. Always wise to copy post to clipboard before sending, though it's a couple more extra steps.
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. :roll:

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.


_________________
Giraffe: a ruminant with a view.


Mona Pereth
Veteran
Veteran

Joined: 11 Sep 2018
Gender: Female
Posts: 7,846
Location: New York City (Queens)

18 May 2024, 8:00 am

Cornflake wrote:
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. :roll:

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


_________________
- Autistic in NYC - Resources and new ideas for the autistic adult community in the New York City metro area.
- Autistic peer-led groups (via text-based chat, currently) led or facilitated by members of the Autistic Peer Leadership Group.
- My Twitter / "X" (new as of 2021)


Cornflake
Administrator
Administrator

User avatar

Joined: 30 Oct 2010
Gender: Male
Posts: 66,766
Location: Over there

18 May 2024, 8:43 am

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.


_________________
Giraffe: a ruminant with a view.


nick007
Veteran
Veteran

User avatar

Joined: 4 May 2010
Age: 41
Gender: Male
Posts: 27,321
Location: was Louisiana but now Vermont in the police state called USA

18 May 2024, 9:15 am

Cornflake wrote:
ToughDiamond wrote:
BillyTree wrote:
^ For me it works to hit refresh button.

That's probably easier than the "back button and retry" method for most operations. One exception may be when submitting a long post. If I refresh the page then, the browser says it can't do it unless it re-sends the data, which makes me think it might eat the post. Probably PTSD from the "Cloudflare ate my post" days, haven't experimented further. Always wise to copy post to clipboard before sending, though it's a couple more extra steps.
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. :roll:

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.
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.


_________________
"I don't have an anger problem, I have an idiot problem!"
~King Of The Hill


"Hear all, trust nothing"
~Ferengi Rule Of Acquisition #190
https://memory-alpha.fandom.com/wiki/Ru ... cquisition


ToughDiamond
Veteran
Veteran

User avatar

Joined: 15 Sep 2008
Age: 71
Gender: Male
Posts: 11,685

18 May 2024, 10:18 am

Mona Pereth wrote:
Cornflake wrote:
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. :roll:

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

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.



ToughDiamond
Veteran
Veteran

User avatar

Joined: 15 Sep 2008
Age: 71
Gender: Male
Posts: 11,685

18 May 2024, 1:02 pm

ToughDiamond wrote:
BillyTree wrote:
^ For me it works to hit refresh button.

That's probably easier than the "back button and retry" method for most operations. One exception may be when submitting a long post. If I refresh the page then, the browser says it can't do it unless it re-sends the data, which makes me think it might eat the post. Probably PTSD from the "Cloudflare ate my post" days, haven't experimented further. Always wise to copy post to clipboard before sending, though it's a couple more extra steps.

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.



pcgoblin
Veteran
Veteran

User avatar

Joined: 11 Apr 2013
Gender: Male
Posts: 1,653
Location: My House, US

18 May 2024, 2:28 pm

Quote:
General Error
SQL ERROR [ mysqli ]

Too many connections [1040]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.


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.



Fenn
Veteran
Veteran

User avatar

Joined: 1 Sep 2014
Gender: Male
Posts: 2,610
Location: Pennsylvania

18 May 2024, 6:16 pm

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:

Code:
sql
     SHOW VARIABLES LIKE 'max_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:
Code:
ini
     [mysqld]
     max_connections = 200


- 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:
Code:
sql
     SHOW PROCESSLIST;


- 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.


_________________
ADHD-I(diagnosed) ASD-HF(diagnosed)
RDOS scores - Aspie score 131/200 - neurotypical score 69/200 - very likely Aspie


ASPartOfMe
Veteran
Veteran

User avatar

Joined: 25 Aug 2013
Age: 66
Gender: Male
Posts: 34,673
Location: Long Island, New York

19 May 2024, 12:15 am

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


_________________
Professionally Identified and joined WP August 26, 2013
DSM 5: Autism Spectrum Disorder, DSM IV: Aspergers Moderate Severity

“My autism is not a superpower. It also isn’t some kind of god-forsaken, endless fountain of suffering inflicted on my family. It’s just part of who I am as a person”. - Sara Luterman


Fnord
Veteran
Veteran

User avatar

Joined: 6 May 2008
Age: 67
Gender: Male
Posts: 60,201
Location: Stendec

19 May 2024, 12:21 am

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 .


:wink:


_________________
 
No love for Hamas, Hezbollah, Iranian Leadership, Islamic Jihad, other Islamic terrorist groups, OR their supporters and sympathizers.


Kitty4670
Veteran
Veteran

User avatar

Joined: 18 Nov 2014
Gender: Female
Posts: 8,049
Location: California,USA

19 May 2024, 1:16 am

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



Cornflake
Administrator
Administrator

User avatar

Joined: 30 Oct 2010
Gender: Male
Posts: 66,766
Location: Over there

19 May 2024, 4:07 am

^ 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


_________________
Giraffe: a ruminant with a view.


cecilfienkelstien
Veteran
Veteran

User avatar

Joined: 10 May 2006
Age: 40
Gender: Male
Posts: 21,355
Location: Ontario Canada

20 May 2024, 8:47 am

It is happening here too.


_________________
I like to talk about Asperger's related issues as well as Asperger's related interest. So PM me!


Cornflake
Administrator
Administrator

User avatar

Joined: 30 Oct 2010
Gender: Male
Posts: 66,766
Location: Over there

20 May 2024, 8:50 am

The errors will be generated for every WP user.


_________________
Giraffe: a ruminant with a view.


ElmersTrueLove
Velociraptor
Velociraptor

User avatar

Joined: 8 Feb 2024
Age: 21
Gender: Female
Posts: 456
Location: Elmer Fudd's Cupid form

20 May 2024, 10:36 am

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


_________________
Someone: You attract what you fear.‬
‪Me: I'm terrified of Elmer Fudd.

Elmer's wife since 2022

.。*゚+.*.。 ゚+..。*゚+