search

drencken / VRS-flights-db

Code to export Virtual Radar Server flight records and track logs to a MySQL database.
2 stars 1 forks source link

Loaded a total of 0 records from this csv file at 11/29/2017 08:30:09 pm #3

Open dxmekch opened 6 years ago

dxmekch commented 6 years ago

Good evening,

I edited the script and all paths are correct. But everytime I run db_query.sh this "error" occurs:

Loaded a total of 0 records from this csv file at 11/29/2017 08:30:09 pm

If I check the flights.csv file manually it is also empty. I'm running VRS and VRS-flights-db on a Raspberry Pi 3 with Debian Jessie installed.

Thanks, Dominik

dxmekch commented 6 years ago

I just found out that issue occurs, because the BaseStation.sqb gets locked as soon as 2 processes request an action from the BaseStation.sqb. Do you know, how to solve this problem?

Thanks, Dominik

strk1204 commented 6 years ago

I also have this issue. Have you found a fix yet?

dxmekch commented 6 years ago

@strk1204

I always copy the db with rsync to another folder. Don't forget to set read AND write permissions for this sqb file.