Board index FlightGear Support Tools FGRun

Sqlite error, FG crashes

FGRun is a graphical frontend to run FlightGear.

Sqlite error, FG crashes

Postby FL2070 » Tue Sep 08, 2015 3:36 pm

Whenever I try to start flightgear, this happens:


Image
Code: Select all
Sqlite error: attempt to write to a readonly database (8) while running:
        received DELETE_FROM groundnet edge


And then FG crashes.

What does this mean?
All my sound work can be found here: http://www.thejabberwocky.net/viewtopic.php?f=57&t=416
User avatar
FL2070
 
Posts: 99
Joined: Sat Jun 13, 2015 6:55 pm
Location: The skies above
Callsign: FL2070
Version: 3.4 FGRun
OS: Windows 7 x64

Re: Sqlite error, FG crashes

Postby legoboyvdlp » Tue Sep 08, 2015 4:22 pm

I see you are Windows, so go to C:/Users/FL2070/AppData/Roaming/flightgear.org and delete the navdata file. Close FGRUN if open, then open it again and load as normal. Should work!
User avatar
legoboyvdlp
 
Posts: 5697
Joined: Sat Jul 26, 2014 1:28 am
Callsign: YV-LEGO
Version: 2018.3.1
OS: Windows 10 HP

Re: Sqlite error, FG crashes

Postby Johan G » Tue Sep 08, 2015 4:50 pm

See also the FlightGear wiki section Navdata cache#Known issues (perm).
Low-level flying — It's all fun and games till someone looses an engine. (Paraphrased from a YouTube video)
Improving the Dassault Mirage F1 (Wiki, Forum, GitLab. Work in slow progress)
Johan G
Moderator
 
Posts: 5292
Joined: Fri Aug 06, 2010 5:33 pm
Location: Sweden
Callsign: SE-JG
IRC name: Johan_G
Version: 3.0.0
OS: Windows 7, 32 bit

Re: Sqlite error, FG crashes

Postby FL2070 » Tue Sep 08, 2015 7:03 pm

Thanks, Lego, it works!
All my sound work can be found here: http://www.thejabberwocky.net/viewtopic.php?f=57&t=416
User avatar
FL2070
 
Posts: 99
Joined: Sat Jun 13, 2015 6:55 pm
Location: The skies above
Callsign: FL2070
Version: 3.4 FGRun
OS: Windows 7 x64

Re: Sqlite error, FG crashes

Postby CaptB » Wed Sep 09, 2015 8:35 am

Actually, I just got this error and removing navdata.cache results in the launcher crashing immediately.
CaptB
 
Posts: 483
Joined: Thu May 23, 2013 6:36 pm
Callsign: EKCH_AP
IRC name: CAPTB
Version: 2018.1
OS: Xubuntu, Win7 64

Re: Sqlite error, FG crashes

Postby bugman » Wed Sep 09, 2015 8:42 am

You can always try the --restore-defaults command line option. This will rebuild the navigation data cache, if it is broken or missing, and reset all your settings.

Regards,

Edward
bugman
Moderator
 
Posts: 1524
Joined: Thu Mar 19, 2015 9:01 am
Version: next

Re: Sqlite error, FG crashes

Postby CaptB » Wed Sep 09, 2015 9:22 am

Thanks, but same result.
CaptB
 
Posts: 483
Joined: Thu May 23, 2013 6:36 pm
Callsign: EKCH_AP
IRC name: CAPTB
Version: 2018.1
OS: Xubuntu, Win7 64

Re: Sqlite error, FG crashes

Postby Hooray » Wed Sep 09, 2015 2:16 pm

please go and file a full bug report at the issue tracker
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: 11163
Joined: Tue Mar 25, 2008 8:40 am

Re: Sqlite error, FG crashes

Postby legoboyvdlp » Wed Sep 09, 2015 2:45 pm

Just delete the WHOLE flightgear.org folder. Worked for me!
User avatar
legoboyvdlp
 
Posts: 5697
Joined: Sat Jul 26, 2014 1:28 am
Callsign: YV-LEGO
Version: 2018.3.1
OS: Windows 10 HP

Re: Sqlite error, FG crashes

Postby CaptB » Wed Sep 09, 2015 7:15 pm

legoboyvdlp wrote in Wed Sep 09, 2015 2:45 pm:Just delete the WHOLE flightgear.org folder. Worked for me!


this one worked, thank you!
CaptB
 
Posts: 483
Joined: Thu May 23, 2013 6:36 pm
Callsign: EKCH_AP
IRC name: CAPTB
Version: 2018.1
OS: Xubuntu, Win7 64

Re: Sqlite error, FG crashes

Postby Hooray » Thu Sep 10, 2015 1:15 pm

still, please file a bug report, especially if you should be able to reproduce this !
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: 11163
Joined: Tue Mar 25, 2008 8:40 am

Re: Sqlite error, FG crashes

Postby VisayanAirways » Wed Oct 21, 2015 3:44 am

Deleting it worked! thanks a lot!
Visayan Airways, The FlightGear Airline of the Philippines :)
User avatar
VisayanAirways
 
Posts: 167
Joined: Mon Feb 16, 2015 2:19 am

Re: Sqlite error, FG crashes

Postby legoboyvdlp » Wed Oct 21, 2015 1:39 pm

Yeah, same for me this morning.
1. Console shows wierd errors with squlite, then fails to find parking position xyz
2. I delete navcache, sometimes, it regens automatically, others it still crashes, like it is not told to regen
3. If it doesn't I rename flightgear.org to flightgear.org.bak, run flightgear, close once I get into the cockpit, and put my stuff (export, autosave, aircrft saved settings etc) aback in, leaving fgfs.pid the two logs, and he old navcache out.
User avatar
legoboyvdlp
 
Posts: 5697
Joined: Sat Jul 26, 2014 1:28 am
Callsign: YV-LEGO
Version: 2018.3.1
OS: Windows 10 HP

Re: Sqlite error, FG crashes

Postby Hooray » Wed Oct 21, 2015 1:43 pm

Unfortunately, the NavCache feature has become kinda infamous for rendering FG unusable for a number of folks, especially Windows users - even though it is a great feature/idea in theory, but we're really getting too little constructive feedback to help narrow down what is going on here, i.e. in terms of corrupted tables, but also the navcache taking ages to rebuild.
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: 11163
Joined: Tue Mar 25, 2008 8:40 am

Re: Sqlite error, FG crashes

Postby legoboyvdlp » Wed Oct 21, 2015 1:49 pm

Is there anything I can tell you?
I have the corrupted folder backed up and can give you any feedback required that does not need me to install linux or something :)
What tests exactly would you like?

It is not that it takes ages, but it crashes wihout a rebuild. Deleting the flightgear.org folder or preferably renaming is he only way to keep it safe.
User avatar
legoboyvdlp
 
Posts: 5697
Joined: Sat Jul 26, 2014 1:28 am
Callsign: YV-LEGO
Version: 2018.3.1
OS: Windows 10 HP

Next

Return to FGRun

Who is online

Users browsing this forum: No registered users and 2 guests