Page 9 of 10

Re: Bugs in 2.0.2

Posted: Wed Aug 20, 2014 7:03 pm
by 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???

Re: Bugs in 2.0.2

Posted: Thu Aug 21, 2014 12:56 am
by 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.

Re: Bugs in 2.0.2

Posted: Thu Aug 21, 2014 8:46 am
by Sentry_e3
Thanks Andrew, you can send it at sentry_e3@yahoo.fr

I'll use the integrity check too right now

Re: Bugs in 2.0.2

Posted: Thu Aug 21, 2014 9:23 am
by Sentry_e3
SQLite integrity check says ''database is OK''

Re: Bugs in 2.0.2

Posted: Thu Aug 21, 2014 6:22 pm
by Jester
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 ?

Re: Bugs in 2.0.2

Posted: Fri Aug 22, 2014 12:41 am
by 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.

Re: Bugs in 2.0.2

Posted: Fri Aug 22, 2014 8:15 am
by 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!

Re: Bugs in 2.0.2

Posted: Fri Aug 22, 2014 9:00 am
by Sentry_e3
@jester: same bug without the proxy...

Re: Bugs in 2.0.2

Posted: Sat Aug 23, 2014 12:49 pm
by 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

Re: Bugs in 2.0.2

Posted: Sat Aug 23, 2014 1:49 pm
by Sentry_e3
Thanks a lot, i'll transmit all this to Laurent!