Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to servodude,tjh290633,csearle,jfgw,bionichamster, for Donating to support the site

outages and contacts

Pull up a chair, have a biscuit - discuss the site and general questions about the LemonFool
didds
Lemon Quarter
Posts: 2132
Joined: November 4th, 2016, 12:04 pm
Has thanked: 854 times
Been thanked: 299 times

outages and contacts

#252539

Postby didds » September 18th, 2019, 3:31 pm

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

Clariman
Lemon Quarter
Posts: 1164
Joined: November 4th, 2016, 12:17 am
Has thanked: 772 times
Been thanked: 291 times

Re: outages and contacts

#252550

Postby Clariman » September 18th, 2019, 5:01 pm

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.

tjh290633
Lemon Quarter
Posts: 3683
Joined: November 4th, 2016, 11:20 am
Has thanked: 248 times
Been thanked: 1245 times

Re: outages and contacts

#252560

Postby tjh290633 » September 18th, 2019, 6:00 pm

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

PinkDalek
Lemon Quarter
Posts: 4325
Joined: November 4th, 2016, 1:12 pm
Has thanked: 1019 times
Been thanked: 1161 times

Re: outages and contacts

#252564

Postby PinkDalek » September 18th, 2019, 6:16 pm

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.

XFool
Lemon Quarter
Posts: 4296
Joined: November 8th, 2016, 7:21 pm
Been thanked: 197 times

Re: outages and contacts

#252760

Postby XFool » September 19th, 2019, 8:15 pm

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.

Itsallaguess
Lemon Quarter
Posts: 3981
Joined: November 4th, 2016, 1:16 pm
Has thanked: 1425 times
Been thanked: 2498 times

Re: outages and contacts

#253122

Postby Itsallaguess » September 22nd, 2019, 12:46 pm

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

monabri
Lemon Quarter
Posts: 3027
Joined: January 7th, 2017, 9:56 am
Has thanked: 324 times
Been thanked: 799 times

Re: outages and contacts

#253125

Postby monabri » September 22nd, 2019, 12:50 pm

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.

AsleepInYorkshire
Lemon Slice
Posts: 566
Joined: February 7th, 2017, 9:36 pm
Has thanked: 328 times
Been thanked: 228 times

Re: outages and contacts

#253130

Postby AsleepInYorkshire » September 22nd, 2019, 2:54 pm

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

Itsallaguess
Lemon Quarter
Posts: 3981
Joined: November 4th, 2016, 1:16 pm
Has thanked: 1425 times
Been thanked: 2498 times

Re: outages and contacts

#253132

Postby Itsallaguess » September 22nd, 2019, 3:15 pm

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

PinkDalek
Lemon Quarter
Posts: 4325
Joined: November 4th, 2016, 1:12 pm
Has thanked: 1019 times
Been thanked: 1161 times

Re: outages and contacts

#253136

Postby PinkDalek » September 22nd, 2019, 7:02 pm

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?

AleisterCrowley
Lemon Quarter
Posts: 3521
Joined: November 4th, 2016, 11:35 am
Has thanked: 721 times
Been thanked: 777 times

Re: outages and contacts

#253138

Postby AleisterCrowley » September 22nd, 2019, 7:17 pm

It has been timing out for me most of the afternoon. Only just managed to log on

Dod101
Lemon Quarter
Posts: 3929
Joined: October 10th, 2017, 11:33 am
Has thanked: 759 times
Been thanked: 1378 times

Re: outages and contacts

#253139

Postby Dod101 » September 22nd, 2019, 7:26 pm

Glad I am not the only one. Can someone in authority do something about it? very frustrating.

Dod

Snorvey
Lemon Quarter
Posts: 2756
Joined: November 4th, 2016, 12:51 pm
Has thanked: 962 times
Been thanked: 1123 times

Re: outages and contacts

#253140

Postby Snorvey » September 22nd, 2019, 7:30 pm

I don't know why but if I try to access the site on my mobile via Wi-Fi it times out. If I turn the wi-fi off and try to access via 4g it works fine.

My tablet works fine via the wi-fi though.

monabri
Lemon Quarter
Posts: 3027
Joined: January 7th, 2017, 9:56 am
Has thanked: 324 times
Been thanked: 799 times

Re: outages and contacts

#253142

Postby monabri » September 22nd, 2019, 7:46 pm

Currently 100 users online at TLF. The other users on the shared server must be unduly busy!

scotia
Lemon Quarter
Posts: 1515
Joined: November 4th, 2016, 8:43 pm
Has thanked: 289 times
Been thanked: 519 times

Re: outages and contacts

#253152

Postby scotia » September 22nd, 2019, 9:17 pm

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.

stooz
Site Admin
Posts: 744
Joined: November 3rd, 2016, 11:03 pm
Has thanked: 4 times
Been thanked: 222 times

Re: outages and contacts

#253161

Postby stooz » September 22nd, 2019, 10:12 pm

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.

AsleepInYorkshire
Lemon Slice
Posts: 566
Joined: February 7th, 2017, 9:36 pm
Has thanked: 328 times
Been thanked: 228 times

Re: outages and contacts

#253166

Postby AsleepInYorkshire » September 22nd, 2019, 10:52 pm

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

TheMotorcycleBoy
Lemon Quarter
Posts: 2382
Joined: March 7th, 2018, 8:14 pm
Has thanked: 1152 times
Been thanked: 172 times

Re: outages and contacts

#253191

Postby TheMotorcycleBoy » September 23rd, 2019, 7:02 am

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.

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.

PinkDalek
Lemon Quarter
Posts: 4325
Joined: November 4th, 2016, 1:12 pm
Has thanked: 1019 times
Been thanked: 1161 times

Re: outages and contacts

#253224

Postby PinkDalek » September 23rd, 2019, 10:04 am

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

stooz
Site Admin
Posts: 744
Joined: November 3rd, 2016, 11:03 pm
Has thanked: 4 times
Been thanked: 222 times

Re: outages and contacts

#253267

Postby stooz » September 23rd, 2019, 12:19 pm

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


Return to “Biscuit Bar”

Who is online

Users browsing this forum: No registered users and 3 guests