Bugs in 2.0.2

Is Virtual Radar Server not behaving itself? If so then please report it here.
Sentry_e3
Posts: 81
Joined: Wed May 15, 2013 11:57 pm

Re: Bugs in 2.0.2

Post by Sentry_e3 » Wed Aug 20, 2014 7:03 pm

Well i've talked with Laurent and, guess what, the bug is still there with only one feed! Any idea? Laurent thinks it's maybe from the database itself???

agw
Posts: 2241
Joined: Fri Feb 17, 2012 3:20 am

Re: Bugs in 2.0.2

Post by agw » Thu Aug 21, 2014 12:56 am

SQLite has a built-in integrity check, you could run that against the database and see if it reports any errors. I wrote a little .NET program a week or so ago to check and repair SQLite files, I can send an installer for that to you if you like.

Sentry_e3
Posts: 81
Joined: Wed May 15, 2013 11:57 pm

Re: Bugs in 2.0.2

Post by Sentry_e3 » Thu Aug 21, 2014 8:46 am

Thanks Andrew, you can send it at sentry_e3@yahoo.fr

I'll use the integrity check too right now

Sentry_e3
Posts: 81
Joined: Wed May 15, 2013 11:57 pm

Re: Bugs in 2.0.2

Post by Sentry_e3 » Thu Aug 21, 2014 9:23 am

SQLite integrity check says ''database is OK''

Jester
Posts: 54
Joined: Tue Apr 09, 2013 6:23 pm

Re: Bugs in 2.0.2

Post by Jester » Thu Aug 21, 2014 6:22 pm

Sentry_e3 wrote:Well i've talked with Laurent and, guess what, the bug is still there with only one feed! Any idea? Laurent thinks it's maybe from the database itself???
Are you still using your proxy ? or is this with just using VRS ?

agw
Posts: 2241
Joined: Fri Feb 17, 2012 3:20 am

Re: Bugs in 2.0.2

Post by agw » Fri Aug 22, 2014 12:41 am

If you could zip the BaseStation.sqb and then upload it to a file sharing site, and email or PM me the address of it, then I'll take a look at what's going on.

Sentry_e3
Posts: 81
Joined: Wed May 15, 2013 11:57 pm

Re: Bugs in 2.0.2

Post by Sentry_e3 » Fri Aug 22, 2014 8:15 am

I guess Laurent is still using a proxy. Things are getting worse, some aircraft are shown 3 times in a row...

Andrew, i'll send you the link by PM this morning

EDIT: the problem has been detected on some other stations too, not only mine. STRANGE!

Sentry_e3
Posts: 81
Joined: Wed May 15, 2013 11:57 pm

Re: Bugs in 2.0.2

Post by Sentry_e3 » Fri Aug 22, 2014 9:00 am

@jester: same bug without the proxy...

agw
Posts: 2241
Joined: Fri Feb 17, 2012 3:20 am

Re: Bugs in 2.0.2

Post by agw » Sat Aug 23, 2014 12:49 pm

I've taken a look at the file - it does look like there are two things writing to it, and also it is corrupt:

Code: Select all

sqlite> select * from flights where flightid > 569719;
569720|301|8352|2014-08-22 09:56:16.625||||||||||||||0|0|||||||||||||||0|0|0|
569721|305|8352|2014-08-22 09:56:16||||||||||||||0|0|||||||||||||||0|0|0|
569722|301|78997|2014-08-22 09:56:34.421||||||||||||||0|0|||||||||||||||0|0|0|
569723|301|74147|2014-08-22 09:56:35.843||||||||||||||0|0|||||||||||||||0|0|0|
569724|305|74147|2014-08-22 09:56:36||||||||||||||0|0|||||||||||||||0|0|0|
569725|301|114783|2014-08-22 09:56:41.328||||||||||||||0|0|||||||||||||||0|0|0|
569726|305|114783|2014-08-22 09:56:41||||||||||||||0|0|||||||||||||||0|0|0|
569727|305|78997|2014-08-22 09:56:42||||||||||||||0|0|||||||||||||||0|0|0|
Error: database disk image is malformed
sqlite>
The first number is the flight ID, the second is the session identifier and the third is the aircraft identifier. You can see that for every instance of an aircraft ID in the example there are two records, one for session 301 and another for session 305. I think there are two things writing to the database, you just need to get rid of one of them.

*edit: from memory I think the database writer plugin does not write fractions of a second when it writes times to BaseStation.sqb, it was causing a problem with something - so my guess is session 305 is the database writer plugin and 301 is probably BaseStation. Uninstall the database writer plugin.

The malformed disk image is a separate problem. I'll put together an installer for my SQLite file repair program and PM you the address. All it does is put a GUI on the process of using sqlite3 to take a dump of the corrupt file, rename the corrupt file and then rebuild the file from the dump - something along these lines:

http://techblog.dorogin.com/2011/05/sql ... ge-is.html

Sentry_e3
Posts: 81
Joined: Wed May 15, 2013 11:57 pm

Re: Bugs in 2.0.2

Post by Sentry_e3 » Sat Aug 23, 2014 1:49 pm

Thanks a lot, i'll transmit all this to Laurent!

Locked