Random SQL errors

Tell us how you think the forum can be improved. We will listen.
Individual
Posts: 1970
Joined: Mon Jan 12, 2009 2:19 am

Random SQL errors

Post by Individual »

Today, I got some error messages a bit more often than usual. It's happened in the past -- I usually just refresh and it's gone. Today, there was one error that lasted a bit longer than that.

Anybody know what these errors are? Next time I see one, I could get the exact name of the error, if you need more detail.

Also, in the wake of the e-Sangha crisis, I have to ask: Are you certain your forum is secure?
The best things in life aren't things.

The Diamond Sutra
Individual
Posts: 1970
Joined: Mon Jan 12, 2009 2:19 am

Re: Random SQL errors

Post by Individual »

I got the error AGAIN.

First, it said this:
SQL ERROR [ mysql4 ]

Lost connection to MySQL server during query [2013]
I refreshed and then it said this:
SQL ERROR [ mysql4 ]

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) [2002]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
After that, it would give me the same error message, the one above, every time I refreshed... for a few seconds. Then it worked again.
The best things in life aren't things.

The Diamond Sutra
User avatar
retrofuturist
Posts: 27848
Joined: Tue Dec 30, 2008 9:52 pm
Location: Melbourne, Australia
Contact:

Re: Random SQL errors

Post by retrofuturist »

Greetings Individual,

I think it's just systematic of the server being down momentarily.

The reason I'm pretty sure that this is the problem, is because I too was getting the same messages from Dharmawheel.

Metta,
Retro. :)
"Whatever is true, whatever is noble, whatever is right, whatever is pure, whatever is lovely, whatever is admirable—if anything is excellent or praiseworthy—think about such things."
Individual
Posts: 1970
Joined: Mon Jan 12, 2009 2:19 am

Re: Random SQL errors

Post by Individual »

retrofuturist wrote:Greetings Individual,

I think it's just systematic of the server being down momentarily.

The reason I'm pretty sure that this is the problem, is because I too was getting the same messages from Dharmawheel.

Metta,
Retro. :)
Why would the server go down momentarily?
The best things in life aren't things.

The Diamond Sutra
User avatar
retrofuturist
Posts: 27848
Joined: Tue Dec 30, 2008 9:52 pm
Location: Melbourne, Australia
Contact:

Re: Random SQL errors

Post by retrofuturist »

Greetings Individual,

The ISP probably doesn't want to pay for the kind of redundancy required to keep it up and running 99.999% of the time. Beyond a point, the investment returns aren't worth it and beyond a point you start having to pay a real premium price for extreme reliability and continuity of service.

Metta,
Retro. :)
"Whatever is true, whatever is noble, whatever is right, whatever is pure, whatever is lovely, whatever is admirable—if anything is excellent or praiseworthy—think about such things."
User avatar
poto
Posts: 369
Joined: Sat Oct 17, 2009 3:21 am

Re: Random SQL errors

Post by poto »

I was seeing the SQL errors too. The fact that this forum is on a shared hosting account with some 500-odd other sites on it is probably the reason.

I'm not trying to bash or anything, I'm actually liking it here, which is why I mention this. If you guys are serious about running a forum and membership here continues to grow, at some point you will need a dedicated server just to handle the traffic load. You can get a small starter server on the cheap, usually for less than a hundred bucks a month. Sometimes you can catch sales or special deals that will knock the price down lower too. It may not be needed right this minute, but it is something you might want to consider in the future.
"Of all tyrannies, a tyranny exercised for the good of its victims may be the most oppressive. It may be better to live under robber barons than under omnipotent moral busybodies. The robber baron's cruelty may sometimes sleep, his cupidity may at some point be satiated; but those who torment us for our own good will torment us without end, for they do so with the approval of their own conscience." -- C. S. Lewis
Individual
Posts: 1970
Joined: Mon Jan 12, 2009 2:19 am

Re: Random SQL errors

Post by Individual »

poto wrote:I was seeing the SQL errors too. The fact that this forum is on a shared hosting account with some 500-odd other sites on it is probably the reason.

I'm not trying to bash or anything, I'm actually liking it here, which is why I mention this. If you guys are serious about running a forum and membership here continues to grow, at some point you will need a dedicated server just to handle the traffic load. You can get a small starter server on the cheap, usually for less than a hundred bucks a month. Sometimes you can catch sales or special deals that will knock the price down lower too. It may not be needed right this minute, but it is something you might want to consider in the future.
I agree and I don't think anybody would mind some Google ads, to partially cover the costs.

It's great to see Dhamma Wheel grow, as I thought it would. This website has a very bright future ahead of it. :)
The best things in life aren't things.

The Diamond Sutra
User avatar
BlackBird
Posts: 2069
Joined: Fri Apr 17, 2009 12:07 pm

Re: Random SQL errors

Post by BlackBird »

Hi there

Getting SQL errors at random intervals also.

:anjali:
"For a disciple who has conviction in the Teacher's message & lives to penetrate it, what accords with the Dhamma is this:
'The Blessed One is the Teacher, I am a disciple. He is the one who knows, not I." - MN. 70 Kitagiri Sutta

Path Press - Ñāṇavīra Thera Dhamma Page - Ajahn Nyanamoli's Dhamma talks
User avatar
retrofuturist
Posts: 27848
Joined: Tue Dec 30, 2008 9:52 pm
Location: Melbourne, Australia
Contact:

Re: Random SQL errors

Post by retrofuturist »

Greetings,
Individual wrote:I agree and I don't think anybody would mind some Google ads, to partially cover the costs.
It's ultimately David's call, but I don't think Dhamma Wheel will be going down the Google Ads path... particularly now that some accounts about the E-Sangha attack suggest it was related to one of the ads that appeared on the site via Google Ads.

As for times when SQL errors are observed, try switching to the 'other' Dhamma Wheel domain or clicking the refresh button on your browser and see if that works.

http://dhammawheel.com/" onclick="window.open(this.href);return false;
http://www.dhammawheel.com/" onclick="window.open(this.href);return false;

I see they're still occurring intermittently. I'll ensure David knows about this, so he can investigate when he has the chance to do so.

Metta,
Retro. :)
"Whatever is true, whatever is noble, whatever is right, whatever is pure, whatever is lovely, whatever is admirable—if anything is excellent or praiseworthy—think about such things."
User avatar
catmoon
Posts: 369
Joined: Sat Oct 17, 2009 1:59 am

Re: Random SQL errors

Post by catmoon »

Got a number of sql errors about a half hour ago. seems ok now.

Do the errors correspond with usage peaks?
User avatar
retrofuturist
Posts: 27848
Joined: Tue Dec 30, 2008 9:52 pm
Location: Melbourne, Australia
Contact:

Re: Random SQL errors

Post by retrofuturist »

Greetings Catmoon,
catmoon wrote:Got a number of sql errors about a half hour ago. seems ok now.

Do the errors correspond with usage peaks?
Around Easter I think it was we had a few issues. I don't think it's DW-specific demand... just technical issues with the hosting company.

Those times aside, it's actually been quite reliable.

Metta,
Retro. :)
"Whatever is true, whatever is noble, whatever is right, whatever is pure, whatever is lovely, whatever is admirable—if anything is excellent or praiseworthy—think about such things."
User avatar
poto
Posts: 369
Joined: Sat Oct 17, 2009 3:21 am

Re: Random SQL errors

Post by poto »

retrofuturist wrote: particularly now that some accounts about the E-Sangha attack suggest it was related to one of the ads that appeared on the site via Google Ads.
That would be a XSS (Cross Site Scripting) exploit. The last Google Adsense XSS exploit that I remember was in 2005 and that was patched within a day or 2 if I remember correctly. Unless somebody has discovered a new XSS vulnerability, it's highly unlikely the Google Adsense ads that were displaying on E-Sangha were in any way responsible for the hack.
"Of all tyrannies, a tyranny exercised for the good of its victims may be the most oppressive. It may be better to live under robber barons than under omnipotent moral busybodies. The robber baron's cruelty may sometimes sleep, his cupidity may at some point be satiated; but those who torment us for our own good will torment us without end, for they do so with the approval of their own conscience." -- C. S. Lewis
User avatar
retrofuturist
Posts: 27848
Joined: Tue Dec 30, 2008 9:52 pm
Location: Melbourne, Australia
Contact:

Re: Random SQL errors

Post by retrofuturist »

Greetings Poto,

Yes, perhaps it was an early (incorrect) diagnosis... the only other explanation I've heard to date is of a deliberate targeted attack, which from what you're saying here, sounds most likely.

Metta,
Retro. :)
"Whatever is true, whatever is noble, whatever is right, whatever is pure, whatever is lovely, whatever is admirable—if anything is excellent or praiseworthy—think about such things."
User avatar
poto
Posts: 369
Joined: Sat Oct 17, 2009 3:21 am

Re: Random SQL errors

Post by poto »

retrofuturist wrote:Greetings Poto,

Yes, perhaps it was an early (incorrect) diagnosis... the only other explanation I've heard to date is of a deliberate targeted attack, which from what you're saying here, sounds most likely.

Metta,
Retro. :)
Well, if we're going to speculate, it could have been malware on the admin's computer that let somebody root the server, a security hole in an outdated script, a SQL injection or any number of other things. I really have no idea what one it was. There are a lot of automated exploits these days, and vast armies of botnets to do the dirty work. It's possible that E-Sangha could have been hacked by a bot as part of a larger exploit.

I was just pointing out that it's not likely to be Google Adsense ads.
"Of all tyrannies, a tyranny exercised for the good of its victims may be the most oppressive. It may be better to live under robber barons than under omnipotent moral busybodies. The robber baron's cruelty may sometimes sleep, his cupidity may at some point be satiated; but those who torment us for our own good will torment us without end, for they do so with the approval of their own conscience." -- C. S. Lewis
Mawkish1983
Posts: 1285
Joined: Mon Jan 12, 2009 9:46 am
Location: Essex, UK

Re: Random SQL errors

Post by Mawkish1983 »

I'd rather donate money every month than see google ads here and I imagine some other users would too. If the server is to be updated I hope it is when I am no-longer unemployed!
Locked