New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Low memory error/crash #22
Comments
Thanks @johnchoiniere. I actually haven't used a mysql connection with |
Is there a way to clear any memory the script is using between years? Or is the solution just to run independent scripts for each year? |
You could try using |
Thanks!
|
Closing since this is a duplicate of #27 (which has a more complete report of the issue). |
Was building a pitchf/x db from scratch, using pitchrx. I repeatedly had system crashes from low memory. It was more frequent using Rstudio, but happened both when using Rstudio and when running the script from the command line. In RStudio it would make it roughly a year, cmd roughly two years before crashing.
Code I was running:
I was able to work around the issue by querying for gameday_link, sorting so the most recent date was found, and deleting rows from all tables where that date was part of the link and then modifying the code to start at that date.
The text was updated successfully, but these errors were encountered: