ISISComputingGroup / IBEX

Top level repository for IBEX stories
5 stars 2 forks source link

Investigate whether a progressbar is implementable for truncate database. #8236

Closed LowriJenkins closed 7 months ago

LowriJenkins commented 7 months ago

The "Backing up database" step takes a while for say a 10GB sql file - this is because it is copying over a network share to avoid backing the file up locally on a disk which may not have enough space to do so. It would be nice to be able to see the progress of this step. there may already be a flag to the sql dump command we use, this ticket is to investigate and implement if trivial.

Acceptance criteria

LowriJenkins commented 7 months ago

https://github.com/ISISComputingGroup/ibex_utils/pull/192 cleaner implementations using a progress bar library seem to conflict with our logging framework.

LowriJenkins commented 7 months ago

The SQL dump flag sadly seems to not be in community edition, this solution sets logging to verbose, runs it through popen pipe so we can access the output to stdout, and allows checking for a string in the output and displaying the number of times its happened against an expected value.