[USLIMS-US] UltraScan LIMS server maintenance/upgrade

[Gary Gorbet]

Emre,

I am wondering if you could slip in a potential recovery of the uslims3_CU_Boulder database on the aucsolutions lims server while doing the upgrade. What I mean specifically is that the mariadb service be first started with 
	[mysqld]
	innodb_force_recovery = 1    .
in the /etc/my.cnf file.

Then, after a few DB actions to insure basically uncorrupted data, the service restarted with
	innodb_force-recovery = 0    .

The above steps are a test of a theory about inaccessible 2DSA-FM model files; the theory being that
the model access problem is due to some kind of db corruption.

Does that sound reasonable and doable?

Gary

NB: actual innodb_force_recovery line is presently in /etc/my.cnf.d/mariadb-server.cnf .

> On Jan 24, 2022, at 10:42 AM, Emre Brookes <emre.brookes at mso.umt.edu> wrote:
> 
> Dear UltraScan LIMS users,
> 
> We will be upgrading the https://uslims.aucsolutions.com/ UltraScan LIMS server starting at
> 8 pm CST on Friday 28 January with completion expected by 8 am CST on Monday 31 January.
> Services will be unavailable during this time.
> Another announcement will be sent when services are restored.
> 
> Best regards,
> Emre
> 
> _______________________________________________
> USLIMS-US mailing list
> USLIMS-US at biophysics.uleth.ca
> https://www.biophysics.uleth.ca/mailman/listinfo/uslims-us