sql error

Discuss technical problems and features here
User avatar
arthaey
Blue Belt
Posts: 962
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 1338
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 : 53 / 2204 April vocab challenge : 373 / 300

User avatar
Brun Ugle
Brown Belt
Posts: 1266
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 2229
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)

: 12735 / 50000 words - Output Challenge Spanish Writing
: 367 / 3000 minutes - Output Challenge Spanish Speaking

User avatar
MorkTheFiddle
Green Belt
Posts: 344
Joined: Sat Jul 18, 2015 8:59 pm
Location: Texas, USA
Languages: English (N), French (read fluently), Spanish (read fluently). Studying Ancient Greek and Latin. Once studied Old Norse.
Language Log: viewtopic.php?f=15&t=5680&p=70021#p70021
x 406

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
ἐς Τροίαν πειρώμενοι ἦνθον ᾿Αχαιοί,
καλλίστα παίδων: πείρᾳ θην πάντα τελεῖται.
Theocritus, Idyll 15

User avatar
Systematiker
Green Belt
Posts: 417
Joined: Tue May 10, 2016 6:09 pm
Location: Florida, 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 790

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

Online
User avatar
tomgosse
Blue Belt
Posts: 998
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 1765
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: 330
Joined: Mon Jul 06, 2015 4:55 am
Location: Honolulu, USA
Languages: Adv: English (N), German.
Int: Russian, Hawaiian, New Zealand Sign Language (NZSL), French, Hawaiian Pidgin English, Spanish.
Beg: Japanese, Irish, Swedish, Latin, Ancient Egyptian, Toki Pona.
Language Log: https://teango.wordpress.com/
x 848
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: 72
Joined: Thu Oct 15, 2015 7:49 am
Location: France
Languages: French (N), English (I), Russian (?), Japanese (?)
x 102

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 - 1st Dan
Posts: 1756
Joined: Wed Jan 06, 2016 7:34 pm
Languages: English
x 2618

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: 1266
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 2229
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)

: 12735 / 50000 words - Output Challenge Spanish Writing
: 367 / 3000 minutes - Output Challenge Spanish Speaking

User avatar
rdearman
Site Admin
Posts: 2223
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 4396
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


Return to “Technical Support and Feature Requests”

Who is online

Users browsing this forum: No registered users and 1 guest