Got a credit card? use our Credit Card & Finance Calculators
Thanks to Wasron,jfgw,Rhyd6,eyeball08,Wondergirly, for Donating to support the site
outages and contacts
-
- Lemon Half
- Posts: 5310
- Joined: November 4th, 2016, 12:04 pm
- Has thanked: 3295 times
- Been thanked: 1034 times
outages and contacts
I've noticed with the couple of outages very recently we of course get a message
"eneral Error
SQL ERROR [ mysqli ]
Connection timed out [2002]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists."
But of course we donjt have any way of contacting an adminstrator
Is there a generic admin email account we could email (presumably forwards to a real one etc) ?
Or other ideas ?
cheers
didds
"eneral Error
SQL ERROR [ mysqli ]
Connection timed out [2002]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists."
But of course we donjt have any way of contacting an adminstrator
Is there a generic admin email account we could email (presumably forwards to a real one etc) ?
Or other ideas ?
cheers
didds
-
- Lemon Quarter
- Posts: 3271
- Joined: November 4th, 2016, 12:17 am
- Has thanked: 3087 times
- Been thanked: 1559 times
Re: outages and contacts
You can always PM myself or Stooz. Or email us at those names at lemonfool.co.uk
We still share servers with other sites. We are looking again at dedicated servers to stop this happening.
We still share servers with other sites. We are looking again at dedicated servers to stop this happening.
-
- Lemon Half
- Posts: 8289
- Joined: November 4th, 2016, 11:20 am
- Has thanked: 919 times
- Been thanked: 4138 times
Re: outages and contacts
If it hangs after you have posted a reply, open the same forum in a new tab, and if your post is the most recent, then close the other one. That's assuming that you can get onto the site in the first place.
TJH
TJH
-
- Lemon Half
- Posts: 6139
- Joined: November 4th, 2016, 1:12 pm
- Has thanked: 1589 times
- Been thanked: 1801 times
Re: outages and contacts
tjh290633 wrote:... That's assuming that you can get onto the site in the first place.
That was the position for a lengthy period of time this morning.
-
- The full Lemon
- Posts: 12636
- Joined: November 8th, 2016, 7:21 pm
- Been thanked: 2608 times
Re: outages and contacts
More problems this morning:
General Error
SQL ERROR [ mysqli ]
User 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.
-
- Lemon Half
- Posts: 9129
- Joined: November 4th, 2016, 1:16 pm
- Has thanked: 4140 times
- Been thanked: 10032 times
Re: outages and contacts
There looks to have been more SQL-error outages this morning, and I saw one error that said this -
User lemonfoo_6dyf already has more than 'max_user_connections' active connections [1203] An sql error occurred while fetching this page.
Given that this username isn't one I recognise as a poster, I wonder if the user is connected to some sort of configured 'bot' process, and looking at the Lemon Fool search-history for that particular user-name, it seems that this 'user' has regularly been the source of some of these SQL site-error issues -
https://www.lemonfool.co.uk/search.php?keywords=lemonfoo_6dyf
I'll bring this specific point to Stooz's attention to see if this is something that can perhaps be managed better at a user-level for that particular 'user'.
Cheers,
Itsallaguess
User lemonfoo_6dyf already has more than 'max_user_connections' active connections [1203] An sql error occurred while fetching this page.
Given that this username isn't one I recognise as a poster, I wonder if the user is connected to some sort of configured 'bot' process, and looking at the Lemon Fool search-history for that particular user-name, it seems that this 'user' has regularly been the source of some of these SQL site-error issues -
https://www.lemonfool.co.uk/search.php?keywords=lemonfoo_6dyf
I'll bring this specific point to Stooz's attention to see if this is something that can perhaps be managed better at a user-level for that particular 'user'.
Cheers,
Itsallaguess
-
- Lemon Half
- Posts: 8427
- Joined: January 7th, 2017, 9:56 am
- Has thanked: 1549 times
- Been thanked: 3445 times
Re: outages and contacts
I've had the connection times out error (2002) preventing any access at all. I see that there are only 170 people browsing which is well below the 1083 all time high.
There have also been time out issues when posting..the post goes through but the window doesn't close as though the posting can't complete.
There have also been time out issues when posting..the post goes through but the window doesn't close as though the posting can't complete.
-
- Lemon Half
- Posts: 7383
- Joined: February 7th, 2017, 9:36 pm
- Has thanked: 10514 times
- Been thanked: 4659 times
Re: outages and contacts
Itsallaguess wrote:There looks to have been more SQL-error outages this morning, and I saw one error that said this -
User lemonfoo_6dyf already has more than 'max_user_connections' active connections [1203] An sql error occurred while fetching this page.
Is it a denial of service attack?
AiY
-
- Lemon Half
- Posts: 9129
- Joined: November 4th, 2016, 1:16 pm
- Has thanked: 4140 times
- Been thanked: 10032 times
Re: outages and contacts
AsleepInYorkshire wrote:Itsallaguess wrote:There looks to have been more SQL-error outages this morning, and I saw one error that said this -
User lemonfoo_6dyf already has more than 'max_user_connections' active connections [1203] An sql error occurred while fetching this page.
Is it a denial of service attack?
I don't think so.
I've not heard anything back from Stooz yet, but from the brief investigations I've done via Google, I suspect that the 'user' listed is actually the single 'connection' that our hosting site uses to connect us to the SQL server, so if that's correct then we might *all* be using that 'user' to connect to the site SQL database, and we might simply be swamping the SQL database with our collective 'limit' of connections that we're allowed at any particular time.
I know Stooz has previously said that this is a hosting issue, and there is a relatively small current limit to the SQL connections that the site can make via that hosting server, so I think this might perhaps simply be a consequence of being as popular a site as it currently is, and the growing number of issues like this are simply reflecting the rising tide of regular concurrent connections that the site is seeing...
Nice problem to have in a way, I suppose, and I know Stooz is actively looking to solve the issue..
Cheers,
Itsallaguess
-
- Lemon Half
- Posts: 6139
- Joined: November 4th, 2016, 1:12 pm
- Has thanked: 1589 times
- Been thanked: 1801 times
Re: outages and contacts
Itsallaguess wrote:... I know Stooz has previously said that this is a hosting issue, and there is a relatively small current limit to the SQL connections that the site can make via that hosting server, so I think this might perhaps simply be a consequence of being as popular a site as it currently is ...
Stooz has also said it is a shared server. Such that the number of connections causing the problem is not merely down to those seeking to access The Lemon Fool (today being the worst I've experienced over the years here).
Would that make sense to you?
-
- Lemon Half
- Posts: 6385
- Joined: November 4th, 2016, 11:35 am
- Has thanked: 1882 times
- Been thanked: 2026 times
Re: outages and contacts
It has been timing out for me most of the afternoon. Only just managed to log on
-
- The full Lemon
- Posts: 16629
- Joined: October 10th, 2017, 11:33 am
- Has thanked: 4343 times
- Been thanked: 7536 times
Re: outages and contacts
Glad I am not the only one. Can someone in authority do something about it? very frustrating.
Dod
Dod
-
- Lemon Half
- Posts: 8427
- Joined: January 7th, 2017, 9:56 am
- Has thanked: 1549 times
- Been thanked: 3445 times
Re: outages and contacts
Currently 100 users online at TLF. The other users on the shared server must be unduly busy!
-
- Lemon Quarter
- Posts: 3568
- Joined: November 4th, 2016, 8:43 pm
- Has thanked: 2376 times
- Been thanked: 1948 times
Re: outages and contacts
Just adding my problems today to the list of other users. Lots of failures to log in, and occasionally when logged in, further failures to access contributions. Most commonly - Connection timed out [2002]. Occasionally User lemonfoo_6dfy already has more than ' max_user_connections' active connections [1203]
Both are General Error SQL ERROR [ mysqli ] An sql error occurred while fetching this page. Please contact an administrator if this problem persists
All of the above using a PC over a wifi connection to a broadband link. I hope this info helps.
Both are General Error SQL ERROR [ mysqli ] An sql error occurred while fetching this page. Please contact an administrator if this problem persists
All of the above using a PC over a wifi connection to a broadband link. I hope this info helps.
-
- Site Admin
- Posts: 1455
- Joined: November 3rd, 2016, 11:03 pm
- Has thanked: 10 times
- Been thanked: 502 times
Re: outages and contacts
Thanks for your reports and my apologies.
I will post soon on the plans as it will require a short outage during the upgrade but it will hopefully result in a far better service.
I will post soon on the plans as it will require a short outage during the upgrade but it will hopefully result in a far better service.
-
- Lemon Half
- Posts: 7383
- Joined: February 7th, 2017, 9:36 pm
- Has thanked: 10514 times
- Been thanked: 4659 times
Re: outages and contacts
stooz wrote:Thanks for your reports and my apologies.
I will pay soon on the plans as it will require a short outage during the upgrade but it will hopefully result in s fast better service.
I can only speak for myself but hope I speak for the entire community. There's absolutely no need to apologise. What is happening here with this community is fantastic and you have made that possible. Whatever needs to be done should, in my opinion be done in your time.
Thank you
AiY
-
- Lemon Quarter
- Posts: 3246
- Joined: March 7th, 2018, 8:14 pm
- Has thanked: 2226 times
- Been thanked: 588 times
Re: outages and contacts
Yes, I saw this most of yesterday afternoon.
What was the consensus? Is TLF hitting the maximum number of sessions permitted on the hosting DB or something? Hopefully not a genuine data integrity error.
General Error
SQL ERROR [ mysqli ]
Connection timed out [2002]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
What was the consensus? Is TLF hitting the maximum number of sessions permitted on the hosting DB or something? Hopefully not a genuine data integrity error.
-
- Lemon Half
- Posts: 6139
- Joined: November 4th, 2016, 1:12 pm
- Has thanked: 1589 times
- Been thanked: 1801 times
Re: outages and contacts
TheMotorcycleBoy wrote:Yes, I saw this most of yesterday afternoon.General Error...
SQL ERROR [ mysqli ]
Connection timed out [2002]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
Hi Matt,
I can't help with your questions, other than there's been no indication of any integrity errors in the many separate Topics on this problem.
What I would mention, in passing, is I notice you often use pre and /pre in your replies, such that on a SmartPhone and iPad etc some sideways scrolling is required. I think Italics would do the job without the resultant scroll bar.
Foolish regards,
PD
-
- Site Admin
- Posts: 1455
- Joined: November 3rd, 2016, 11:03 pm
- Has thanked: 10 times
- Been thanked: 502 times
Re: outages and contacts
No it's just getting bigger and bigger and more popular so the existing hardware is starting to creak.
We will upgrade asap. I need to build a test transfer to make sure it works then repeat with live data
We will upgrade asap. I need to build a test transfer to make sure it works then repeat with live data
-
- Lemon Quarter
- Posts: 3246
- Joined: March 7th, 2018, 8:14 pm
- Has thanked: 2226 times
- Been thanked: 588 times
Re: outages and contacts
PinkDalek wrote:TheMotorcycleBoy wrote:Yes, I saw this most of yesterday afternoon.General Error...
SQL ERROR [ mysqli ]
Connection timed out [2002]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
Hi Matt,
I can't help with your questions, other than there's been no indication of any integrity errors in the many separate Topics on this problem.
What I would mention, in passing, is I notice you often use pre and /pre in your replies, such that on a SmartPhone and iPad etc some sideways scrolling is required. I think Italics would do the job without the resultant scroll bar.
Foolish regards,
PD
Sorry, for the "pre" stuff. Being a computer nerd I typically used the fixed width (i.e. pre) when quoting computery stuff, and a computer error message seemed to fit the bill! Of course it's my modus operandi at work, i.e. quoting code, diagnostics etc. in a fixed width type font.
I'll try to do less of it, in the non-analytical forums of TLF in future.
Yours foolishly
Matt
Return to “Room 102 - Site Issues, Complaints & General Chat”
Who is online
Users browsing this forum: No registered users and 59 guests