Same thing as yesterday...Home page won't load...

Please report Bugs and Problems here

Moderator: FSAirlines Staff

Locked
flugkapitan
Flight Attendant
Posts: 134
Joined: Thu Nov 02, 2006 7:24 am

Same thing as yesterday...Home page won't load...

Post by flugkapitan » Thu May 06, 2021 10:34 pm

or loads very slowly...Client error message that I'm not connected to the Internet (I obviously am) or that the Home Page is down.

Well, as I was typing the above, I got the Client to load by "running as administrator"...not sure if that had anything to do with it.

Regards,
Scott
Image

"...now let's get this thing on the hump - we've got some flyin' to do!" ~ Major Kong

User avatar
joefremont
FSAirlines Developer
Posts: 3694
Joined: Tue May 16, 2006 5:46 am
Location: KSFO

Re: Same thing as yesterday...Home page won't load...

Post by joefremont » Thu May 06, 2021 10:44 pm

I just restarted everything, trying to reduce the size of the number of packages in the database to see if it helps. We also keep all the delivered packages to show on the reports but I think that after four months there is probably no reason to keep them. As it is there are now more delivered packages in the database than pending (7,762,317 packages delivered so far!)

Upgrading the server is in my todo list, we have been using the current one for about 5 years now, all a matter of finding the time, making sure all our older code works with the latest versions of all the software packages.

Continuing to monitor.
Image
I've sworn an oath of solitude until the pestilence is purged from the lands.

flugkapitan
Flight Attendant
Posts: 134
Joined: Thu Nov 02, 2006 7:24 am

Re: Same thing as yesterday...Home page won't load...

Post by flugkapitan » Thu May 06, 2021 10:54 pm

Hi Joe,

Thanks for the information and your plan for the packages/server!

Regards,
Scott
Image

"...now let's get this thing on the hump - we've got some flyin' to do!" ~ Major Kong

User avatar
joefremont
FSAirlines Developer
Posts: 3694
Joined: Tue May 16, 2006 5:46 am
Location: KSFO

Re: Same thing as yesterday...Home page won't load...

Post by joefremont » Fri May 07, 2021 1:06 am

I think people are hammering the global package search screen, when i have looked to see what is running when things were bogging down I saw a query that was being run for all packages of 20,000 kg or less, sorted by size. That probably should not be allowed. I will probably have to work on that screen to make it more efficient.
Image
I've sworn an oath of solitude until the pestilence is purged from the lands.

User avatar
joefremont
FSAirlines Developer
Posts: 3694
Joined: Tue May 16, 2006 5:46 am
Location: KSFO

Re: Same thing as yesterday...Home page won't load...

Post by joefremont » Fri May 07, 2021 2:09 am

I have replaced the current database -> packages search page with one that just shows a table for each of the three biggest package sizes, showing the top 100 airports where they are waiting, hopefully this will keep people happy for a bit while I work the page that page.
Image
I've sworn an oath of solitude until the pestilence is purged from the lands.

User avatar
BVU-951
Flight Attendant
Posts: 117
Joined: Tue Sep 28, 2010 8:47 am
Location: Northampton UK
Contact:

Re: Same thing as yesterday...Home page won't load...

Post by BVU-951 » Fri May 07, 2021 2:13 pm

Problem still exists at 13:00 UTC, but working ok 30 mins later
Image

brazvo
Ticket Agent
Posts: 17
Joined: Thu Mar 11, 2021 5:40 pm

Re: Same thing as yesterday...Home page won't load...

Post by brazvo » Fri May 07, 2021 8:53 pm

From ca 19:30 UTC very slow or unavailable . Before that everything OK. It looks to me as DDoS attack.
Image

User avatar
joefremont
FSAirlines Developer
Posts: 3694
Joined: Tue May 16, 2006 5:46 am
Location: KSFO

Re: Same thing as yesterday...Home page won't load...

Post by joefremont » Sat May 08, 2021 12:19 am

I think I may have found the issue, continuing to monitor.
Image
I've sworn an oath of solitude until the pestilence is purged from the lands.

Locked