sql error

Discuss technical problems and features here
User avatar
Tristano
Green Belt
Posts: 294
Joined: Mon Jul 20, 2015 7:11 am
Location: The Netherlands
Languages: Italian (N), English (C1), Dutch (B2), French (B2--), Spanish (B1?), Hebrew (A0++ illiterate), Russian (on hold)
Language Log: viewtopic.php?f=15&t=5141
x 375

sql error

Postby Tristano » Mon Nov 28, 2016 1:39 pm

Hi guys,
I'm getting this error often today:
Attachments
fout.png
fout.png (11.38 KiB) Viewed 627 times
1 x

User avatar
jeff_lindqvist
Blue Belt
Posts: 791
Joined: Sun Aug 16, 2015 9:52 pm
Languages: sv, en
de, es
ga, eo
---
fi, yue, ro, tp, cy, kw, pt, sk
Language Log: viewtopic.php?f=15&t=2773
x 1194

Re: sql error

Postby jeff_lindqvist » Mon Nov 28, 2016 4:19 pm

It happened to me once or twice during the weekend but I just reloaded the page again, and then it worked fine.
0 x
Leabhair/Greannáin léite as Gaeilge: 9 / 18
Ar an seastán oíche: Oileán an Órchiste
Duolingo - finished trees: sp/ga/de/fr/pt/it
Finnish with extra pain : 100 / 100

User avatar
Tristano
Green Belt
Posts: 294
Joined: Mon Jul 20, 2015 7:11 am
Location: The Netherlands
Languages: Italian (N), English (C1), Dutch (B2), French (B2--), Spanish (B1?), Hebrew (A0++ illiterate), Russian (on hold)
Language Log: viewtopic.php?f=15&t=5141
x 375

Re: sql error

Postby Tristano » Wed Nov 30, 2016 11:24 am

Yes of course. Yesterday I had 5 minutes where I couldn't log in at all. Now I had it once again but I could login immediately after.
My suggestion is that these kind of issues are not overlooked as they are a turn off and in the extreme case becomes like the old HTLAL.
0 x

User avatar
rdearman
Site Admin
Posts: 2232
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 4417
Contact:

Re: sql error

Postby rdearman » Wed Nov 30, 2016 1:38 pm

Tristano wrote:Yes of course. Yesterday I had 5 minutes where I couldn't log in at all. Now I had it once again but I could login immediately after.
My suggestion is that these kind of issues are not overlooked as they are a turn off and in the extreme case becomes like the old HTLAL.

The problem is this is shared hosting and in order to eliminate the problem I would have to get a dedicated server. This would mean I couldn't continue to fund the site out of my own pocket, so then we'd have to have some donation drive, or charging model, or advertising. So it is a bit of a trade off between keeping it free (to you) and getting more robust service. I will chase up the hosting company, and I will start looking again at alternatives for DB hosting. There isn't a quick fix for this, but I take your point.
6 x

User avatar
smallwhite
Blue Belt
Posts: 928
Joined: Mon Jul 06, 2015 6:55 am
Location: Αυστραλία
Languages: Cantonese (n) > Mandarin > Eng > Spa > Fra (C1) > Ita > Nld > Swe.
.
Studying: Deutsch > Ελληνικά.
·
x 1444
Contact:

Re: sql error

Postby smallwhite » Wed Nov 30, 2016 2:50 pm

But the error that OP posted was a "No such file" and not a "Too many connections".

And even with the latter, I've read that sometimes it's actually the result of suboptimal code rather than there being too many visitors.
2 x
Greek
: 1522 / 8000 /8k words
: 46 / 600 /10hr transcripted audio
: 688 sentences

User avatar
Tristano
Green Belt
Posts: 294
Joined: Mon Jul 20, 2015 7:11 am
Location: The Netherlands
Languages: Italian (N), English (C1), Dutch (B2), French (B2--), Spanish (B1?), Hebrew (A0++ illiterate), Russian (on hold)
Language Log: viewtopic.php?f=15&t=5141
x 375

Re: sql error

Postby Tristano » Thu Dec 01, 2016 9:49 am

rdearman wrote:The problem is this is shared hosting and in order to eliminate the problem I would have to get a dedicated server. This would mean I couldn't continue to fund the site out of my own pocket, so then we'd have to have some donation drive, or charging model, or advertising. So it is a bit of a trade off between keeping it free (to you) and getting more robust service. I will chase up the hosting company, and I will start looking again at alternatives for DB hosting. There isn't a quick fix for this, but I take your point.


I also take your point. I'm one of the users who won't mind to pay a subscription fee, but I can imagine that for many users isn't the same and it would result in a loss of users - of course an undesired situation.
For the remark over the poor quality software: probably it's a bug that affects this version where the error message doesn't match the actual event. That can possibly be solved with a new version of the platform. My report is anyway meant to notify an existing issue, as I didn't find other notifications.
1 x

User avatar
Teango
Green Belt
Posts: 332
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 851
Contact:

Re: sql error

Postby Teango » Fri Dec 02, 2016 12:26 am

I've also experienced several sql and "unable to connect to server" errors over the last few days. The last time I was unable to access the server was about 15 minutes ago (00:10 UTC/GMT, 14:10 my local time).

Do we have a Twitter feed or something similar just in case things go south for longer periods of time? I think it would be useful to have an emergency/downtime link posted somewhere on the forum to keep everyone informed and up to date in case of sudden technical issues or difficulties (apologies if this is already posted somewhere and I simply missed it).
0 x
  • Language: NZSL | Goal: Complete "Thumbs Up!" course, units: 17 / 20
  • Language: NZSL | Goal: Complete "Learn NZSL" course, units: 4 / 9

Online
User avatar
Serpent
Black Belt - 2nd Dan
Posts: 2279
Joined: Sat Jul 18, 2015 10:54 am
Location: Moskova
Languages: heritage
Russian (native); Belarusian, Polish

fluent or close: Finnish+ (certified C1), English; Portuguese, Spanish, German+, Italian+
learning: Croatian+, Ukrainian, Czech; Romanian+, Galician; Danish, Swedish
exploring: Latin, Karelian, Catalan, Dutch, Chaucer's English
+ means exploring the dialects/variants
x 2860
Contact:

Re: sql error

Postby Serpent » Fri Dec 02, 2016 12:40 am

We have a Facebook group and wikia. There's also a twitter and mailing list but I'm less confident about those.
1 x
: 2 / 40 Budva na pjenu od mora: 3rd season (Croatian/Montenegrin)
LyricsTraining now offers Catalan, Turkish and Japanese romaji

Online
User avatar
tomgosse
Blue Belt
Posts: 999
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 1767
Contact:

Re: sql error

Postby tomgosse » Tue Dec 06, 2016 12:16 pm

Just an FYI: I'm getting numerous sql errors and timeouts this morning (7a.m. EST). This has been going on for about two hours. And while it is very frustrating, I still want to thank rdearman for hosting this forum.
5 x
Rejoignez notre groupe français ! Les Voyageurs

William Camden
Green Belt
Posts: 303
Joined: Sat Nov 14, 2015 2:47 am
Location: Greenwich Mean Time zone
Languages: English (N), German (fluent), Turkish (fluent), Russian (fluent), French (semi-fluent), Spanish (semi-fluent), am studying Polish, have some knowledge of it, also studying modern Greek, basic knowledge of Arabic (mostly MSA, some exposure to colloquial dialects), basic knowledge of Latin and Italian, beginner in Scottish Gaelic.
x 322

Re: sql error

Postby William Camden » Wed Dec 07, 2016 3:58 pm

I couldn't get into it yesterday and only tried again five minutes ago. If I had still not been able to get in, I would have sought a technical solution, like sacrificing a goat.
4 x
: 9 / 25Greek FSI Part 1
: 3819 / 3819Greek Memrise


Return to “Technical Support and Feature Requests”

Who is online

Users browsing this forum: iguanamon and 1 guest