02-24-2023, 07:52 PM
Oh wow, that's a long time and will be an insane amount of data for the graphs, with some quick math at 5 minutes per write would be 122,400 lines per chart. I think maybe that's the limit for dygraphs which is pretty decent. I just made my own chart for dosing and ATO, after a few hundred lines there's a lag haha. Unfortunately dygraphs reads from CSV files which are much harder to edit via code, I need to add a trim method so maybe no more than 100,000 entries are recorded. As things are recorded every 5 minutes ideally I would like to remove lines between readings say after a week or two, maybe space readings out 1-2 hours which should be fine for historic data.
To fix this you need to either delete the chart CSV files or open them and remove 90% of the data. Opening them in the SSH could be difficult as that's a large file. Here's how to get to the chart files via SSH.
cd /var/www/html/chartData
Then run ls command to see the files. The sensor ID is the file name.
To delete the file run the following commands but replace the file name with yours. Note C and F have their own file.
sudo rm 0317028addff_C.csv
sudo rm 0317028addff_F.csv
For program not running do the console thing which will tell us if problem is in the frontend. Then do the following to see if problem is with the backend. Run the following commands to start the program manually, if it runs and doesn't crash then backend is ok.
cd /var/www/html/cpp
sudo systemctl stop robotank.service
sudo ./robotank
If it crashes you'll be able to run another command, if it runs you can't run any more commands in that SSH terminal as the program is running, you would need to open a 2nd.
If it crashes run the following command.
g++ -o robotank robotank.cpp `mysql_config --cflags --libs` -lpthread -lquickmail -lcurl
The run this again.
sudo ./robotank
If it still crashes it could be a database issue. Send me the output from the SSH so I know where it's crashing.
To fix this you need to either delete the chart CSV files or open them and remove 90% of the data. Opening them in the SSH could be difficult as that's a large file. Here's how to get to the chart files via SSH.
cd /var/www/html/chartData
Then run ls command to see the files. The sensor ID is the file name.
To delete the file run the following commands but replace the file name with yours. Note C and F have their own file.
sudo rm 0317028addff_C.csv
sudo rm 0317028addff_F.csv
For program not running do the console thing which will tell us if problem is in the frontend. Then do the following to see if problem is with the backend. Run the following commands to start the program manually, if it runs and doesn't crash then backend is ok.
cd /var/www/html/cpp
sudo systemctl stop robotank.service
sudo ./robotank
If it crashes you'll be able to run another command, if it runs you can't run any more commands in that SSH terminal as the program is running, you would need to open a 2nd.
If it crashes run the following command.
g++ -o robotank robotank.cpp `mysql_config --cflags --libs` -lpthread -lquickmail -lcurl
The run this again.
sudo ./robotank
If it still crashes it could be a database issue. Send me the output from the SSH so I know where it's crashing.
