Recent Topics

1 Jul 13, 2013 00:56    

Ever since upgraded to V504, my sites have been crashing quite regularly and causing my home server to stall. On checking log files it's often these 2 tables that crashed. Initially I thought it's one of the sites that's been heavily accessed by bots or hackers (or whatever) almost 24/7. But the other blog which doesn't have much traffic also logged the same error on these 2 tables. I often need to repair these 2 tables, which I never had to do in prior to the upgrade.

My server is running PHP V5.3.10 and MYSQL V5.5.29. Is this a bug somewhere?

2 Jul 13, 2013 03:40

What error message do you see, precisely?

Shot in the dark: you may turn off logging in the analytics settings.

3 Jul 13, 2013 08:53

you see a series of errors involving these 2 tables from mysql's error.log (with db name edited out):

130713 8:00:05 [ERROR] /usr/sbin/mysqld: Table './xxxmdb/xxx_sessions' is marked as crashed and should be repaired
130713 8:00:05 [Warning] Checking table: './xxxdb/xxx_sessions'
130713 8:02:48 [ERROR] /usr/sbin/mysqld: Table './xxxdb/xxx_hitlog' is marked as crashed and should be repaired
130713 8:02:51 [Warning] Checking table: './xxxdb/xxx_hitlog'
130713 8:03:03 [ERROR] /usr/sbin/mysqld: Table './xxxdb/xxx_hitlog' is marked as crashed and should be repaired

4 Jul 15, 2013 18:49

b2evolution cannot do anything to crash your tables. When MySQL tables crash, it is generally when MySQL dies (bug, out of memory) or if a computer/sever is switched off without properly shutting down the system.

This is not really a b2evolution problem.

Note: you can repair your MySQL tables with phpMyAdmin.

Beyond that, what is your "home server"? If it stalls when running b2evolution v5, maybe it's not powerful enough? Is that possible? How old is that machine?

5 Jul 20, 2013 19:08

The server is 2-3 years old, on 24/7, currently running Ubuntu V12 with 1.5G memory. It's not as powerful as professional web hosting servers, but it didn't have the stall problem prior to the upgrade, hence I thought it's probably related to V5. Maybe something is using more memory than prior versions?

Yes, I'm using phpmyadmin to access and repair those tables.

Currently my work-around fix is to add a cron job to restart apache every hour. This is probably not the correct fix but the frequency of stalling and repairing table has reduced.

6 Jul 21, 2013 00:49

Sometimes it's also a bug in MySQL. Make sure you keep it up to date with latest fixes.


Form is loading...