jr_jrcore_form table crashes autorepair fails

soaringeagle
@soaringeagle
10 years ago
3,304 posts
this keeps happening i cant login (nobody can) cause jr_jrcore_form table is marked zs crashed unable to auto repair
repairing with
mysqlcheck --check --auto-repair --all-databases
through ssh fixes it but it just will happen again And again

also new core release has reduced cpu loads, but not as low as they should be i think
(granted i did just upgrade to mariadb at the same time as the faulty core and have hadd insanely crazy cpu loads since ...been trying hard to tune it and have gotten it alot better but its stil high compared to where it used to be so its hard to be certain whats jr and whats mariadb thats causing the higher then normal loads)


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities

updated by @soaringeagle: 01/26/16 07:54:39AM
soaringeagle
@soaringeagle
10 years ago
3,304 posts
semi related what the hells this mean/ should i be worried?
1.jpg
1.jpg  •  137KB




--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
brian
@brian
10 years ago
10,149 posts
If your table keeps crashing, you have an underlying issue that you need to address - i.e. disk going bad, bad memory - something.

You should rarely see a table "marked as crashed" - if you do, it means your DB server is crashing on you on a regular basis - and you need to find out why (i.e. /var/log/mysql/error.log).


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

Tags