Report - Imaging host report
trying to run the imaging report but get an error
This page isn’t working
fog-server is currently unable to handle this request.
HTTP ERROR 500
I have updated in the last 10 mins to git “working” to try and fix it.
If anyone else needs this:
I cheated but it worked for my needs
My personal notes =
Downloaded MySQL Workbench to complete tasks
See records to be deleted.
SELECT * FROM fog.imagingLog where ilImageName NOT LIKE ‘%<latest image name>%’;
Delete Records (Rerun command until effected rows =0) - due to safety feature in Workbench
DELETE FROM fog.imagingLog where ilImageName NOT LIKE ‘<latest image name>’ LIMIT 1000;
Even better would be one what deletes all records older than 3 months or the last 200 imaging logs
can I have an SQL command to clean the tables required so i can start it from now?
@itcc most likely it’s related to memory overlimit. The imaging log is never really cleaned up, and as such it can become very large over time.