Jump to content











Photo
- - - - -

Intermittent failure of forum database


  • Please log in to reply
7 replies to this topic

#1 alacran

alacran

    Gold Member

  • .script developer
  • 1016 posts
  •  
    Mexico

Posted 4 weeks ago

All this week there is intermittent failure on forum database, sometimes for some minutes other times for some hours.

alacran

Attached Thumbnails

  • Failure.png


#2 steve6375

steve6375

    Platinum Member

  • Developer
  • 7042 posts
  • Location:UK
  • Interests:computers, programming (masm,vb6,C,vbs), photography,TV,films,guitars, www.easy2boot.com
  •  
    United Kingdom

Posted 4 weeks ago

It was bad all week but no problems today!



#3 Wonko the Sane

Wonko the Sane

    The Finder

  • Advanced user
  • 14955 posts
  • Location:The Outside of the Asylum (gate is closed)
  •  
    Italy

Posted 4 weeks ago

It was bad all week but no problems today!

till now :w00t:, I just had (the nth) 

reboot.pro Driver Error
There appears to be an error with the database.

If you are seeing this page, it means there was a problem communicating with our database. Sometimes this error is temporary and will go away when you refresh the page. Sometimes the error will need to be fixed by an administrator before the site will become accessible again.

You can try to refresh the page by clicking here

 
:(
 
:duff:
Wonko

#4 ambralivio

ambralivio

    Frequent Member

  • Advanced user
  • 193 posts
  •  
    Italy

Posted 4 weeks ago

I'm suffering the same problem, too...



#5 erwan.l

erwan.l

    Platinum Member

  • Developer
  • 2756 posts
  • Location:Nantes - France
  •  
    France

Posted 3 weeks ago

Server was in a bad state.

Gave it a reboot.

 

Some mysql tables were damaged.

Gave them a repair.

 

HHVM was taking all cpu power.

Removed old HHVM sessions.

 

Next to database hickups, mail notifications were stuck as well (fixed now).

 

Thats a quick fix but that should get it going for a while :)


  • alacran likes this

#6 Wonko the Sane

Wonko the Sane

    The Finder

  • Advanced user
  • 14955 posts
  • Location:The Outside of the Asylum (gate is closed)
  •  
    Italy

Posted 3 weeks ago

Thanks for your efforts :).

 

But unfortunately :( it seems like the issue is not completely solved, this morning I had the same problem.

 

:duff:

Wonko



#7 erwan.l

erwan.l

    Platinum Member

  • Developer
  • 2756 posts
  • Location:Nantes - France
  •  
    France

Posted 3 weeks ago

Thanks for your efforts :).

 

But unfortunately :( it seems like the issue is not completely solved, this morning I had the same problem.

 

:duff:

Wonko

 

Indeed, spotted that.

 

There was indeed a crashed table this morning which I repaired.

I believe it was unrelated to previous issues (where i could witness that the whole server was really unstable and was in need of a reboot plus some filesystem cleanup).

 

Mysql tables crashing when used by forums like this is unfortunately a common issue.

Most of the times it is a session table left in a bad state because some http session/transaction did not complete (blame it on "the internet" and/or the forum software we are using).

To cover this I am considering to implement an automatic cron task at night to repair mysql tables.

Thus, this could be considered as bad practice and "purists" would argue that the root cause should be addressed, not the symptom ... 

I could reply then to go ahead and fix the internet :) or may be more realistically, fix the forum software.

 

In the meantime, whenever I spot this, I fix it manually.

I probably repaired table over a dozen times this last year.

Posting a message about it will also notify me but this is a catch22 situation as usually this is no longer possible to post :)

A mail directly to me then is also an option :)



#8 Wonko the Sane

Wonko the Sane

    The Finder

  • Advanced user
  • 14955 posts
  • Location:The Outside of the Asylum (gate is closed)
  •  
    Italy

Posted 3 weeks ago

Posting a message about it will also notify me but this is a catch22 situation as usually this is no longer possible to post  :)

A mail directly to me then is also an option :)

 

Yep, but anyone with some basic politeness would probably not disturb you for such a matter, I mean it is not like you are a paid employee of a commercial company and we were paying users ...

 

... no wait, bad example :(, if that was the case we could e-mail, but the result would be an automated reply and no action taken ;).

 

:duff:

Wonko






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users