blog documentation FAQ followers forum marketplace services youtube

solved had to remove jr banned irtems because....

The Jamroom Network » Forum » Jamroom Developers » Page » had to remove jr banned irtems because....
soaringeagle
@soaringeagle
10 years ago
3,304 posts
the jr_jrbanned_items table kept crashing, daily or more often
it only started after switching to mariadb
so on your test systems running mariadb, test the banned items module out thouroughly adding several ips to the list
and see if the table doesnt crash on you often



--
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: 02/01/16 07:21:11PM
soaringeagle
@soaringeagle
10 years ago
3,304 posts
omfg even after removing the module i can often not access my site because it still says the tables crashed why is it trying to read the table when i removed the module!


--
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
soaringeagle:
omfg even after removing the module i can often not access my site because it still says the tables crashed why is it trying to read the table when i removed the module!

You really need to get to the bottom of your server issues - this is NOT a Jamroom issue - again, there's no way code or a query can crash the DB server.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
soaringeagle
@soaringeagle
10 years ago
3,304 posts
the still doing it after removing the module was a litespeed cache issue but the table has crashed over and over since upgrading to mariadb ..and continues to be marked as crashed often even with the module removed
how its crashing when i emptied it and removed the module is beyond me i even removed the module, dropped the tabe snd reinstalled the module to recreate a fresh table and it still crashed


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
soaringeagle
@soaringeagle
10 years ago
3,304 posts
ahhh doing optimize all tables i get this error

greentec_jam.jr_jrbanned_banned
error : Can't create new tempfile: '/var/lib/mysql/greentec_jam/jr_jrbanned_banned.TMM'


--
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
soaringeagle:
ahhh doing optimize all tables i get this error

greentec_jam.jr_jrbanned_banned
error : Can't create new tempfile: '/var/lib/mysql/greentec_jam/jr_jrbanned_banned.TMM'

You are out of disk space on your server, or at least the partition your mysql server is on.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
soaringeagle
@soaringeagle
10 years ago
3,304 posts
thats not it either the most used partitions 50%
that would make sense but thats not the case

that table should be tiny too when it 1st crashed had 6 banned ips since then trunkated it dropped it recreated it i can only guess its failing to overwrite a currupt file


--
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
soaringeagle:
thats not it either the most used partitions 50%
that would make sense but thats not the case

that table should be tiny too when it 1st crashed had 6 banned ips since then trunkated it dropped it recreated it i can only guess its failing to overwrite a currupt file

You will need to contact your hosting provider - that error clearly indicates it was unable to create the temp file.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
soaringeagle
@soaringeagle
10 years ago
3,304 posts
yea and running it again said its corrupt
so im thinking delete the temp file drop the table re-install the module and see from there
i mean with the module not in use or installed it cant hurt to do these steps right


--
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
soaringeagle:
yea and running it again said its corrupt
so im thinking delete the temp file drop the table re-install the module and see from there
i mean with the module not in use or installed it cant hurt to do these steps right

Nope - you can drop it - if the module is not installed it will not be recreated on an integrity check.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
soaringeagle
@soaringeagle
10 years ago
3,304 posts
argh after doing that then reinstalling the module i got another error and couldnt access the site had to do a db restiore from last night


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

Tags