Bugs in 2.0.2

[Sentry_e3]

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]

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]

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

I'll use the integrity check too right now

[Sentry_e3]

SQLite integrity check says ''database is OK''

[Jester]

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]

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]

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]

@jester: same bug without the proxy...

[agw]

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]

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