Board index FlightGear Development Scenery

Objects massive addition form

Questions and discussion about enhancing and populating the FlightGear world.

Objects massive addition form

Postby Alex H » Thu Nov 08, 2018 8:58 am

Adding objects with the Objects massive addition form results in;

504 Gateway Time-out

Any clues?
Regards

Alex
Alex H
 
Posts: 28
Joined: Wed Sep 26, 2018 8:38 pm
Location: Northumberland, England
Version: 2018.1.1
OS: Ubuntu 18.0.4

Re: Objects massive addition form

Postby Alex H » Sun Nov 11, 2018 8:45 am

I still get the same error.

Does no-one else add scenery in this way?
Regards

Alex
Alex H
 
Posts: 28
Joined: Wed Sep 26, 2018 8:38 pm
Location: Northumberland, England
Version: 2018.1.1
OS: Ubuntu 18.0.4

Re: Objects massive addition form

Postby Catalanoic » Sun Nov 11, 2018 9:43 am

Added some +70 objects this way today, no issues, all works as always. Copy here some of these lines to know me if are correct.
User avatar
Catalanoic
 
Posts: 1014
Joined: Mon Mar 05, 2012 12:33 am
Location: Barcelona (LEBL)
Callsign: Catalanoic
Version: 2017.3
OS: Lubuntu/Windows 7

Re: Objects massive addition form

Postby Alex H » Sun Nov 11, 2018 10:31 am

Just tried the last line only and it went to the second screen.

Try all the lines and the first screen just sits there until 'gateway timeout'

This is all I'm trying to add

OBJECT_SHARED Models/Power/generic_pylon_50m.ac -1.650503 55.261218 41.2848 60.0 0.0 -0.0
OBJECT_SHARED Models/Power/generic_pylon_50m.ac -1.649559 55.258895 41.9334 80.0 0.0 -0.0
OBJECT_SHARED Models/Power/generic_pylon_50m.ac -1.648014 55.256523 43.7325 80.0 0.0 -0.0
OBJECT_SHARED Models/Power/generic_pylon_50m.ac -1.646426 55.254065 45.6961 80.0 0.0 -0.0
OBJECT_SHARED Models/Power/generic_pylon_50m.ac -1.644495 55.252230 45.8411 40.0 0.0 -0.0
OBJECT_SHARED Models/Power/generic_pylon_50m.ac -1.640439 55.251325 45.5914 20.0 0.0 -0.0
OBJECT_SHARED Models/Power/generic_pylon_50m.ac -1.635847 55.250310 45.9539 20.0 0.0 -0.0
OBJECT_SHARED Models/Power/generic_pylon_50m.ac -1.631298 55.249344 45.8242 20.0 0.0 -0.0
OBJECT_SHARED Models/Power/generic_pylon_50m.ac -1.627908 55.248194 47.2316 30.0 0.0 -0.0
OBJECT_SHARED Models/Power/generic_pylon_50m.ac -1.623530 55.246751 51.0208 30.0 0.0 -0.0
Regards

Alex
Alex H
 
Posts: 28
Joined: Wed Sep 26, 2018 8:38 pm
Location: Northumberland, England
Version: 2018.1.1
OS: Ubuntu 18.0.4

Re: Objects massive addition form

Postby Catalanoic » Sun Nov 11, 2018 1:27 pm

hmh i see, maybe wrong coordinates, unless you want pylons some thousands km away from somalia coasts in the middle of nowhere, also you dont need these zeros but the system just ignores it, just coordinates , object height and orientation. check these coordinates and be sure are correct, maybe near UK?? and try again with the import proccess
PS: Yes, it is, example: object in first line the correct one is: 55.261218 -1.650503
User avatar
Catalanoic
 
Posts: 1014
Joined: Mon Mar 05, 2012 12:33 am
Location: Barcelona (LEBL)
Callsign: Catalanoic
Version: 2017.3
OS: Lubuntu/Windows 7

Re: Objects massive addition form

Postby Alex H » Sun Nov 11, 2018 1:57 pm

the long / lat is fine (NE England)
here is the console output; from a test i just did;

$ fgfs --aircraft=ufo --lat=55.279486 --lon=-1.721408 --altitude=388.18 --heading=188.7

why the requirement to turn this round, i have no idea, but this is what is asked for by the form

OBJECT_SHARED Models/Power/generic_pylon_50m.ac -1.72101608 55.27647020 59.8637 0.0 0.0 -0.0


I can input 1 line OK it goes to the second confirmation page fairly quickly

Input 2 lines it takes longer but gets there

10 lines - Gateway timeout

This was all Ok 2 weeks ago - I had input over 100 wind turbines and pylons using the mass form

i have now tried from 2 PCs and an android tablet with the same result, so i don't think it's me.
Regards

Alex
Alex H
 
Posts: 28
Joined: Wed Sep 26, 2018 8:38 pm
Location: Northumberland, England
Version: 2018.1.1
OS: Ubuntu 18.0.4

Re: Objects massive addition form

Postby Catalanoic » Sun Nov 11, 2018 3:50 pm

yes, i've tried it and goes like you described. For some reason, massive import dont work on these pylons, with nearly 1M positions to date. Perhaps the last changes in TS server touched something,
PS: Mailed to the devel-list
User avatar
Catalanoic
 
Posts: 1014
Joined: Mon Mar 05, 2012 12:33 am
Location: Barcelona (LEBL)
Callsign: Catalanoic
Version: 2017.3
OS: Lubuntu/Windows 7

Re: Objects massive addition form

Postby Alex H » Sun Nov 11, 2018 6:08 pm

Catalanoic wrote in Sun Nov 11, 2018 3:50 pm:yes, i've tried it and goes like you described. For some reason, massive import dont work on these pylons, with nearly 1M positions to date. Perhaps the last changes in TS server touched something,
PS: Mailed to the devel-list


Great, thanks very much for your help.
Regards

Alex
Alex H
 
Posts: 28
Joined: Wed Sep 26, 2018 8:38 pm
Location: Northumberland, England
Version: 2018.1.1
OS: Ubuntu 18.0.4

Re: Objects massive addition form

Postby Alex H » Sat Dec 08, 2018 2:42 pm

Any news on this - I have lots of pylons to place!
Regards

Alex
Alex H
 
Posts: 28
Joined: Wed Sep 26, 2018 8:38 pm
Location: Northumberland, England
Version: 2018.1.1
OS: Ubuntu 18.0.4

Re: Objects massive addition form

Postby Hooray » Thu Dec 13, 2018 9:22 pm

I don't know whether the back-end code responsible for this is openly available or not (i.e. if we can take a look or not), but depending on the bottleneck/nature of the problem, one relatively simple change would be accepting a compressed text file with the objects/positions to be added.

If the bottleneck/timeout is elsewhere (e.g. between different servers), another thing that might help is not to directly update the database, but instead do those updates in "batches", e.g. by adding cron jobs to spread out the database queries (as in, a simple form of load-balancing).

Obviously, there won't be immediate feedback that way, but the back-end script would merely split up the import and creates batches of import queries and executes those in a staggered fashion - that way, there would be no problem from a timing standpoint, because the CGI (server) side would only ever add cron jobs instead of accessing the database back-end directly.

To make more specific suggestions or to provide patches, one would obviously need to have a look at the corresponding modules (ideally git repo links)
Please don't send support requests by PM, instead post your questions on the forum so that all users can contribute and benefit
Thanks & all the best,
Hooray
Help write next month's newsletter !
pui2canvas | MapStructure | Canvas Development | Programming resources
Hooray
 
Posts: 11191
Joined: Tue Mar 25, 2008 8:40 am


Return to Scenery

Who is online

Users browsing this forum: No registered users and 7 guests

cron