Bugs in 2.0.2
Re: Bugs in 2.0.2
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
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
SQLite integrity check says ''database is OK''
Re: Bugs in 2.0.2
Are you still using your proxy ? or is this with just using VRS ?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???
Re: Bugs in 2.0.2
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
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!
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
@jester: same bug without the proxy...
Re: Bugs in 2.0.2
I've taken a look at the file - it does look like there are two things writing to it, and also it is corrupt:
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
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>
*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
Thanks a lot, i'll transmit all this to Laurent!