sql error

Discuss technical problems and features here
User avatar
arthaey
Blue Belt
Posts: 990
Joined: Sat Jul 18, 2015 9:11 pm
Location: Seattle, WA, USA
Languages: EN (N); ES (adv receptive, int productive); FR (false beginner); DE (lapsed beg); ASL (lapsed beg); HU (tourist)
Language Log: viewtopic.php?f=15&t=3864&view=unread#unread
x 1434
Contact:

Re: sql error

Postby arthaey » Sat Dec 31, 2016 9:16 am

Even a footer at the bottom of the forum pages showing "funded through the next 12 months" or something would probably motivate me to donate some funds, if a "Donate" button were also conveniently in said footer. :)
3 x
Log links: ASLFrenchHungarianSpanish
Anki catchup : 565 / 2204

User avatar
Brun Ugle
Brown Belt
Posts: 1450
Joined: Mon Jul 27, 2015 12:48 pm
Location: Steinkjer, Norway
Languages: English (N), Norwegian (~C1/C2), Spanish (B1/B2), Esperanto (A2?), German (A2/B1?), Japanese (very rusty), Finnish (just started)
Language Log: viewtopic.php?f=15&t=5170
x 2749
Contact:

Re: sql error

Postby Brun Ugle » Sun Jan 15, 2017 11:38 am

I've been getting the SQL error several times a day everyday lately. It usually clears up after a few minutes. I hope it isn't a sign of a bigger problem.
2 x
(aka Easily Distracted Tortoise)

: 13811 / 50000 words - Output Challenge Spanish Writing
: 477 / 3000 minutes - Output Challenge Spanish Speaking

User avatar
MorkTheFiddle
Blue Belt
Posts: 512
Joined: Sat Jul 18, 2015 8:59 pm
Location: Texas, USA
Languages: English (N), French (read fluently), Spanish (read fluently). Studying Ancient Greek. Relearning German.
Language Log: viewtopic.php?f=15&t=5680&p=70021#p70021
x 732

Re: sql error

Postby MorkTheFiddle » Sun Jan 15, 2017 3:17 pm

Brun Ugle wrote:I've been getting the SQL error several times a day everyday lately. It usually clears up after a few minutes. I hope it isn't a sign of a bigger problem.

Same here for this morning (Sunday 1/15/17). I was paging through the S's for member names, jumping ahead several pages. I don't do that very often.
0 x
Ah ! Le bon billet qu'a La Châtre !

User avatar
Systematiker
Blue Belt
Posts: 550
Joined: Tue May 10, 2016 6:09 pm
Location: Pennsylvania, USA
Languages: ENG (N); DEU (C2+) // SWG (~C1); BAR (~C1); SPA, FRA (~C1->C2); SCO (~C1); NLD (~B2*); LAT (B2); GRC (B2); CAT (~B2*); POR (~B2*); SWE (~B2*); HBO (B1); DAN (~B1*); RUS (~A2); KOR (~A1); GLA (~A1); CYM (~A1); EUS (A0); FIN (A0). Next: SYC, CLD, GLG, ARA, ANG, ITA, ISL, SWA, AFR, RON, Siebenbürger Sächsich.
*averaged for high receptive skill
Language Log: viewtopic.php?f=15&t=2764
x 1134

Re: sql error

Postby Systematiker » Wed Jan 18, 2017 4:47 pm

I'm consistently getting the "too many connections" error daily in a window starting at 1900 EST and lasting 7-10 minutes. I suspect it may have something to do with the midnight rollover if the server is on Zulu time.

(I know the specific time as it's usually the first chance I get to sit down and log in right after my son goes to bed).
1 x

User avatar
tomgosse
Brown Belt
Posts: 1081
Joined: Tue Aug 25, 2015 11:29 am
Location: Massachusetts, USA
Languages: English (Native)
French (A1)
Language Log: viewtopic.php?f=15&t=1185
x 2071
Contact:

Re: sql error

Postby tomgosse » Wed Jan 18, 2017 4:53 pm

Systematiker wrote:I'm consistently getting the "too many connections" error daily in a window starting at 1900 EST and lasting 7-10 minutes. I suspect it may have something to do with the midnight rollover if the server is on Zulu time.

(I know the specific time as it's usually the first chance I get to sit down and log in right after my son goes to bed).

The same thing is happening to me. Not the worst thing in the world, but a minor annoyance.
1 x
Rejoignez notre groupe français ! Les Voyageurs

User avatar
Teango
Green Belt
Posts: 371
Joined: Mon Jul 06, 2015 4:55 am
Location: Honolulu, USA
Languages: Adv: English (N), German.
Int: French, Hawaiian, New Zealand Sign Language (NZSL), Russian, Spanish.
Beg: Ancient Egyptian, Irish, Japanese, Latin.
Language Log: https://teango.wordpress.com/
x 1019
Contact:

Re: sql error

Postby Teango » Sat Feb 04, 2017 12:37 am

Same for me - SQL errors pretty much several times a day now! Given that we currently have almost 4,400 members (and it's great to see our numbers on the rise by the way!), we really need suitable technical infrastructure to accommodate the subsequent larger numbers of simultaneous user connections. I don't know what "max_user_connections" is currently set to, but I'm sure it falls far below what is currently needed, and it's such a shame that members are locked out of the forum on a daily basis now. I can't deny that it worries me and reminds me of the problems we had with the old forum before it bit the dust.

I'm very grateful for all the hard work put in by our LLorg admin, moderators, and developers so far, but I think rdearman could do with a bit of financial support here to shoulder the costs of keeping this website running smoothly. The old HTLAL forum had a donations button, as well as premium membership for additional features or advertising for non-premium members (which I'm not a big fan of and would ideally like to steer clear of). I'm not saying we need to copy FX's way of doing things, but I do agree with arthaey and several others that we could at least have a donations button (perhaps with a transparent indication of how much money needs to be raised, and how much has been donated so far) to help gather financial support for maintaining a server-side upgrade for this forum. I think it could make a big difference to current members' confidence in and enjoyment of this unique forum, as well as encourage new members, and I'd be happy to give a regular donation, as I'm sure would others in our growing new community.
10 x
  • Language: NZSL | Goal: Complete "Thumbs Up!" course, units: 17 / 20
  • Language: NZSL | Goal: Complete "Learn NZSL" course, units: 4 / 9

User avatar
Voxel
Yellow Belt
Posts: 81
Joined: Thu Oct 15, 2015 7:49 am
Location: France
Languages: French (N), English (I), Russian (?), Japanese (?)
x 125

Re: sql error

Postby Voxel » Sat Feb 04, 2017 9:05 am

Don't care about max_connections and max_user_connections, it's due to the maximum number of simultaneous connections to the database allowed by this free hosting.
1 x

User avatar
reineke
Black Belt - 2nd Dan
Posts: 2222
Joined: Wed Jan 06, 2016 7:34 pm
Languages: Engrish
x 3609

Re: sql error

Postby reineke » Sat Feb 04, 2017 3:23 pm

I'm consistently getting different types of errors mentioned by others here.
1 x

User avatar
Brun Ugle
Brown Belt
Posts: 1450
Joined: Mon Jul 27, 2015 12:48 pm
Location: Steinkjer, Norway
Languages: English (N), Norwegian (~C1/C2), Spanish (B1/B2), Esperanto (A2?), German (A2/B1?), Japanese (very rusty), Finnish (just started)
Language Log: viewtopic.php?f=15&t=5170
x 2749
Contact:

Re: sql error

Postby Brun Ugle » Tue Feb 07, 2017 7:42 am

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator at webmaster@forum.language-learners.org to inform them of the time this error occurred, and the actions you performed just before this error.

More information about this error may be available in the server error log.

Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.


I haven't had this error before. Today was the first time. Usually it's the SQL too many connections thing. I've had that one a couple of times this morning too, as well as the forum just being slow.
1 x
(aka Easily Distracted Tortoise)

: 13811 / 50000 words - Output Challenge Spanish Writing
: 477 / 3000 minutes - Output Challenge Spanish Speaking

User avatar
rdearman
Site Admin
Posts: 2646
Joined: Thu May 14, 2015 4:18 pm
Location: United Kingdom
Languages: English (N)
French (studies), Italian (studies), Mandarin (studies),
Esperanto TAC (Only god knows why), Finnish (only in it for the cookies)
Language Log: viewtopic.php?f=15&t=1836
x 5507
Contact:

Re: sql error

Postby rdearman » Tue Feb 07, 2017 1:11 pm

I'm investigating with emk moving the database and service on to another hosting platform.
3 x
"Never blame on malice that which can be explained by stupidity."


Return to “Technical Support and Feature Requests”

Who is online

Users browsing this forum: No registered users and 1 guest