Author Topic: Forum Posting Problem  (Read 28016 times)

0 Members and 1 Guest are viewing this topic.

Offline EEVblogTopic starter

  • Administrator
  • *****
  • Posts: 37661
  • Country: au
    • EEVblog
Forum Posting Problem
« on: October 18, 2014, 03:18:57 am »
Seems the database got corrupted and wouldn't allow posting. I think it's repaired now.
Testing...
 

Offline Skimask

  • Super Contributor
  • ***
  • Posts: 1433
  • Country: us
Re: Forum Posting Problem
« Reply #1 on: October 18, 2014, 03:27:02 am »
Looks good...

(P.S.  Pull up your pants!  Or spackle that thing shut!)
I didn't take it apart.
I turned it on.

The only stupid question is, well, most of them...

Save a fuse...Blow an electrician.
 

Offline EEVblogTopic starter

  • Administrator
  • *****
  • Posts: 37661
  • Country: au
    • EEVblog
Re: Forum Posting Problem
« Reply #2 on: October 18, 2014, 01:58:58 pm »
Just check'n again
 

Offline GEuser

  • Frequent Contributor
  • **
  • Posts: 502
  • Country: 00
  • Is Leaving
Re: Forum Posting Problem
« Reply #3 on: October 18, 2014, 03:20:46 pm »
Up late too Dave  :-/O , I thought that was just the innernet as I also had slow and disappearing (404's) at that time too .

But just got this after clicking the post button
Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.
Soon
 

Offline EEVblogTopic starter

  • Administrator
  • *****
  • Posts: 37661
  • Country: au
    • EEVblog
Re: Forum Posting Problem
« Reply #4 on: October 18, 2014, 10:39:29 pm »
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.

That one, apparently for the last  for the last 3 hours was due to the MySQL server being locked up. A database service reboot fixed it.
 

Offline EEVblogTopic starter

  • Administrator
  • *****
  • Posts: 37661
  • Country: au
    • EEVblog
Re: Forum Posting Problem
« Reply #5 on: October 18, 2014, 11:23:53 pm »
Hmm, all sorts of problems at the moment it seems. Had to reboot the MySQL server again, and there is a big load on the server. Something isn't right...
 

Offline Pack34

  • Frequent Contributor
  • **
  • Posts: 753
Re: Forum Posting Problem
« Reply #6 on: October 18, 2014, 11:29:59 pm »
Hmm, all sorts of problems at the moment it seems. Had to reboot the MySQL server again, and there is a big load on the server. Something isn't right...

I remember having a similar issue with my company's web host. Maybe the physical server is starting to go. Any way to request a migration to a different machine?
 

Offline EEVblogTopic starter

  • Administrator
  • *****
  • Posts: 37661
  • Country: au
    • EEVblog
Re: Forum Posting Problem
« Reply #7 on: October 19, 2014, 12:11:19 am »
I remember having a similar issue with my company's web host. Maybe the physical server is starting to go. Any way to request a migration to a different machine?

I've been thinking about that. No real evidence that's the case, but it can't hurt I guess, but does seem to have had more downtime/crashes/reboots than I'd expect. I can ask...
 

Offline Pack34

  • Frequent Contributor
  • **
  • Posts: 753
Re: Forum Posting Problem
« Reply #8 on: October 19, 2014, 06:17:25 am »
I remember having a similar issue with my company's web host. Maybe the physical server is starting to go. Any way to request a migration to a different machine?

I've been thinking about that. No real evidence that's the case, but it can't hurt I guess, but does seem to have had more downtime/crashes/reboots than I'd expect. I can ask...

Yes, but without knowing what the problem is it is equally likely it can't (won't) help either. If they are willing to migrate you to a different machine as a "goodwill" gesture, which is what it will be in the absence of any evidence of the cause of the problem, then they will become increasingly less willing in the event of a recurrence in future. They'll say no anyway, unless they can see a fault.

I suggest looking at the systems logs to see what messages are present. There may well be an answer there. Something has changed. It could be a server hardware fault. It could also be a capacity problem or a software upgrade has introduced a bug, either on the server itself or with another server it communicates with.

Do you think it could be something dns related? Intermittently pointing towards the website's old location? I don't know if an intermittent DNS problem is possible, just throwing out ideas.
 

Offline atferrari

  • Frequent Contributor
  • **
  • Posts: 314
  • Country: ar
Re: Forum Posting Problem
« Reply #9 on: October 19, 2014, 11:03:47 am »
More than posting, my problem just to access the site. I cannot recall but there was a three-letters acronym involved, something like MPS or similar and an error code, starting with 5, but not sure really.
Agustín Tomás
In theory, there is no difference between theory and practice. In practice, however, there is.
 

Offline GEuser

  • Frequent Contributor
  • **
  • Posts: 502
  • Country: 00
  • Is Leaving
Re: Forum Posting Problem
« Reply #10 on: October 19, 2014, 11:07:58 am »
I did not have to log on this evening as I could not log off early this morning as that message kept popping up .

The site behaves real snappy here atm , instantaneous practically ..
Soon
 

Offline T3sl4co1l

  • Super Contributor
  • ***
  • Posts: 21606
  • Country: us
  • Expert, Analog Electronics, PCB Layout, EMC
    • Seven Transistor Labs
Re: Forum Posting Problem
« Reply #11 on: October 19, 2014, 12:34:47 pm »
Had this happen a few times, somewhat randomly.  Seems to come and go.

Tim
Seven Transistor Labs, LLC
Electronic design, from concept to prototype.
Bringing a project to life?  Send me a message!
 

Offline Neilm

  • Super Contributor
  • ***
  • Posts: 1545
  • Country: gb
Re: Forum Posting Problem
« Reply #12 on: October 19, 2014, 07:16:57 pm »
I have had 2 or 3 issues getting onto the EEVblog main site and the forum over the last few weeks.
Two things are infinite: the universe and human stupidity; and I'm not sure about the the universe. - Albert Einstein
Tesla referral code https://ts.la/neil53539
 

Online tautech

  • Super Contributor
  • ***
  • Posts: 28136
  • Country: nz
  • Taupaki Technologies Ltd. Siglent Distributor NZ.
    • Taupaki Technologies Ltd.
Re: Forum Posting Problem
« Reply #13 on: October 20, 2014, 09:57:40 pm »
I have had 2 or 3 issues getting onto the EEVblog main site and the forum over the last few weeks.
Me too. Seems reliability is an issue ATM.
Had this again this morning, though it seems all good now.

Connection Problems

Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.
Avid Rabid Hobbyist
Siglent Youtube channel: https://www.youtube.com/@SiglentVideo/videos
 

Offline atferrari

  • Frequent Contributor
  • **
  • Posts: 314
  • Country: ar
Re: Forum Posting Problem
« Reply #14 on: October 21, 2014, 01:59:21 am »
I have had 2 or 3 issues getting onto the EEVblog main site and the forum over the last few weeks.
Me too. Seems reliability is an issue ATM.
Had this again this morning, though it seems all good now.

Connection Problems

Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.

The same here, several times today.
Agustín Tomás
In theory, there is no difference between theory and practice. In practice, however, there is.
 

Offline retiredcaps

  • Super Contributor
  • ***
  • Posts: 3575
  • Country: ca
Re: Forum Posting Problem
« Reply #15 on: October 21, 2014, 02:02:51 am »
I also had problems Monday Oct 20 starting at 10AM and ongoing to 10:30AM MST.  I tried later in the afternoon around 2PM MST and was able to get on.

I was able to ping www.eevblog.com, but the forum and main page were down with the same error messages posted by others.
 

Offline EEVblogTopic starter

  • Administrator
  • *****
  • Posts: 37661
  • Country: au
    • EEVblog
Re: Forum Posting Problem
« Reply #16 on: October 21, 2014, 02:24:55 am »
Yep, the server is having real problem at the moment, I need to speak with HostGator.
The database issues I'm pretty sure are caused by the server going down, and when it does, there is always a chance a database table can get corrupted.
 

Offline gnif

  • Administrator
  • *****
  • Posts: 1672
  • Country: au
Re: Forum Posting Problem
« Reply #17 on: October 21, 2014, 11:27:21 am »
Hi All,

I am sorry I have not been around to reply to any of this, I have been put out of action as I have been recovering from the whooping cough. I have suggested that Dave have all the RAM in the server replaced, the constant table crashes and now these major crashes point the finger at either RAM or HDD, but since the HDD is a RAID array and as far as I am aware is not reporting any issues, I would not expect this kind of crash (RAM is the easier to replace first too).
 

Offline dr.diesel

  • Super Contributor
  • ***
  • Posts: 2214
  • Country: us
  • Cramming the magic smoke back in...
Re: Forum Posting Problem
« Reply #18 on: October 21, 2014, 12:05:33 pm »
Would RAM errors not show up somewhere?

IIRC it's a Linux box, single bit ECC errors would show up in dmesg.

Offline EEVblogTopic starter

  • Administrator
  • *****
  • Posts: 37661
  • Country: au
    • EEVblog
Re: Forum Posting Problem
« Reply #19 on: October 21, 2014, 12:08:42 pm »
Hostgator are saying that it's the MySQL that is going down, and not the whole server. They are working on it...
 

Offline gnif

  • Administrator
  • *****
  • Posts: 1672
  • Country: au
Re: Forum Posting Problem
« Reply #20 on: October 21, 2014, 01:18:03 pm »
With regards to RAM, It looks like the server may be overcommited, I have reduced the total ram that MySQL is allowed to use, but this does not explain why it is getting blown way out. It seems to occur when there is heavy load on the server, I am seeing oom errors that is killing MySQL and hundreds of PHP processes running at the same time. I am investigating what PHP is doing during these periods.
 

Offline bookaboo

  • Frequent Contributor
  • **
  • Posts: 725
  • Country: ie
Re: Forum Posting Problem
« Reply #21 on: October 21, 2014, 01:21:17 pm »
May be unrelated but the entire site was intermittent for me today from about 11.00am until 2.00PM GMT.
 

Offline GEuser

  • Frequent Contributor
  • **
  • Posts: 502
  • Country: 00
  • Is Leaving
Re: Forum Posting Problem
« Reply #22 on: October 21, 2014, 01:24:11 pm »
Doing some internal search's like 10 minutes ago a cupla times it came back > Database error/corruption retry later or something ..
Soon
 

Offline gnif

  • Administrator
  • *****
  • Posts: 1672
  • Country: au
Re: Forum Posting Problem
« Reply #23 on: October 21, 2014, 01:34:18 pm »
May be unrelated but the entire site was intermittent for me today from about 11.00am until 2.00PM GMT.

It was related, logs show the database had crashed at that point.

Doing some internal search's like 10 minutes ago a cupla times it came back > Database error/corruption retry later or something ..

This may have occured while I was restarting the MySQL service to apply the memory changes.
 

Offline T3sl4co1l

  • Super Contributor
  • ***
  • Posts: 21606
  • Country: us
  • Expert, Analog Electronics, PCB Layout, EMC
    • Seven Transistor Labs
Re: Forum Posting Problem
« Reply #24 on: October 21, 2014, 01:42:16 pm »
Saw this earlier,

Code: [Select]
Table './eevblog_smp01/smf_members' is marked as crashed and should be repaired
Hope it's not hackers or something :(
Seven Transistor Labs, LLC
Electronic design, from concept to prototype.
Bringing a project to life?  Send me a message!
 


Share me

Digg  Facebook  SlashDot  Delicious  Technorati  Twitter  Google  Yahoo
Smf