SQL Error?

A place for you to give us feedback on the site, what's working well, and what other features you'd like to see

Moderators: Rick, Lance Murray

Post Reply
User avatar
Rich
5 Diamonds Member
5 Diamonds Member
FIRST NAME: Rich
Aircraft: DA40
Registration: N40XE
Airport: S39

Posts: 1878
Joined: Mon Aug 30, 2010 12:40 pm
Has thanked: 46 times
Been thanked: 220 times

SQL Error?

Post by Rich » Sun May 05, 2019 3:47 pm

Lately I often get this message when posting a reply.

General Error
SQL ERROR [ mysqli ]

MySQL server has gone away [2006]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.


The reply has succeeded, but the screen refresh fails with the error.
2002 DA40: MT, PF, 530W/430W, KAP140, ext. baggage, 1090 ES out, 2646 MTOW, 40gal.
User avatar
Colin
5 Diamonds Member
5 Diamonds Member
FIRST NAME: Colin
Aircraft: DA42
Registration: N972RD
Airport: KSMO

Posts: 1312
Joined: Sat Aug 21, 2010 8:37 pm
Has thanked: 129 times
Been thanked: 183 times

Re: SQL Error?

Post by Colin » Mon May 06, 2019 1:15 am

I just got the same thing.
Colin Summers, PP Multi-Engine IFR, ~2,300hrs
colin@mightycheese.com
http://www.flyingsummers.com
N972RD DA42 G1000 2.0 s/n 42.AC100
N971RD DA40 G1000 s/n 40.508 (traded)
User avatar
Chris
5 Diamonds Member
5 Diamonds Member
FIRST NAME: Chris
Aircraft: DA40
Registration: N984ES
Airport: KHIO

Posts: 525
Joined: Sat Jun 19, 2010 3:34 am
Has thanked: 206 times
Been thanked: 72 times

Re: SQL Error?

Post by Chris » Mon May 06, 2019 2:30 pm

Thanks for letting me know. I'll probably switch us back to a beefier server. My guess is that we're either running short of memory or queries are timing out when the site is busy.
Chris
N984ES / DA40-180XL / 40.827
KHIO
User avatar
Rich
5 Diamonds Member
5 Diamonds Member
FIRST NAME: Rich
Aircraft: DA40
Registration: N40XE
Airport: S39

Posts: 1878
Joined: Mon Aug 30, 2010 12:40 pm
Has thanked: 46 times
Been thanked: 220 times

Re: SQL Error?

Post by Rich » Mon May 06, 2019 2:33 pm

Chris wrote:
Mon May 06, 2019 2:30 pm
Thanks for letting me know. I'll probably switch us back to a beefier server. My guess is that we're either running short of memory or queries are timing out when the site is busy.
That's what it feels like, as it does seem to be hanging before the error pops up.
2002 DA40: MT, PF, 530W/430W, KAP140, ext. baggage, 1090 ES out, 2646 MTOW, 40gal.
User avatar
Colin
5 Diamonds Member
5 Diamonds Member
FIRST NAME: Colin
Aircraft: DA42
Registration: N972RD
Airport: KSMO

Posts: 1312
Joined: Sat Aug 21, 2010 8:37 pm
Has thanked: 129 times
Been thanked: 183 times

Re: SQL Error?

Post by Colin » Tue May 07, 2019 12:56 am

I think it's probably that the SQL server isn't spun up yet, but it's essentially the same issue solved the same way.
Colin Summers, PP Multi-Engine IFR, ~2,300hrs
colin@mightycheese.com
http://www.flyingsummers.com
N972RD DA42 G1000 2.0 s/n 42.AC100
N971RD DA40 G1000 s/n 40.508 (traded)
User avatar
Chris
5 Diamonds Member
5 Diamonds Member
FIRST NAME: Chris
Aircraft: DA40
Registration: N984ES
Airport: KHIO

Posts: 525
Joined: Sat Jun 19, 2010 3:34 am
Has thanked: 206 times
Been thanked: 72 times

Re: SQL Error?

Post by Chris » Fri May 10, 2019 7:47 am

Switchover to a more capable server is complete. Please let me know if you see the error again.
Chris
N984ES / DA40-180XL / 40.827
KHIO
Post Reply