Random SQL errors

Tell us how you think the forum can be improved. We will listen.

Random SQL errors

Postby Individual » Thu Oct 29, 2009 2:12 am

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

Postby Individual » Thu Oct 29, 2009 2:19 am

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
Individual
 
Posts: 1970
Joined: Mon Jan 12, 2009 2:19 am

Re: Random SQL errors

Postby retrofuturist » Thu Oct 29, 2009 2:46 am

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. :)
If you have asked me of the origination of unease, then I shall explain it to you in accordance with my understanding:
Whatever various forms of unease there are in the world, They originate founded in encumbering accumulation. (Pārāyanavagga)


Exalted in mind, just open and clearly aware, the recluse trained in the ways of the sages:
One who is such, calmed and ever mindful, He has no sorrows! -- Udana IV, 7


Dharma Wheel (Mahayana / Vajrayana forum) -- Open flower ~ Open book (blog)
User avatar
retrofuturist
Site Admin
 
Posts: 14674
Joined: Tue Dec 30, 2008 9:52 pm
Location: Melbourne, Australia

Re: Random SQL errors

Postby Individual » Thu Oct 29, 2009 3:11 am

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
Individual
 
Posts: 1970
Joined: Mon Jan 12, 2009 2:19 am

Re: Random SQL errors

Postby retrofuturist » Thu Oct 29, 2009 3:13 am

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. :)
If you have asked me of the origination of unease, then I shall explain it to you in accordance with my understanding:
Whatever various forms of unease there are in the world, They originate founded in encumbering accumulation. (Pārāyanavagga)


Exalted in mind, just open and clearly aware, the recluse trained in the ways of the sages:
One who is such, calmed and ever mindful, He has no sorrows! -- Udana IV, 7


Dharma Wheel (Mahayana / Vajrayana forum) -- Open flower ~ Open book (blog)
User avatar
retrofuturist
Site Admin
 
Posts: 14674
Joined: Tue Dec 30, 2008 9:52 pm
Location: Melbourne, Australia

Re: Random SQL errors

Postby poto » Thu Oct 29, 2009 3:57 am

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
User avatar
poto
 
Posts: 363
Joined: Sat Oct 17, 2009 3:21 am

Re: Random SQL errors

Postby Individual » Thu Oct 29, 2009 4:19 am

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
Individual
 
Posts: 1970
Joined: Mon Jan 12, 2009 2:19 am

Re: Random SQL errors

Postby BlackBird » Thu Oct 29, 2009 4:34 am

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
User avatar
BlackBird
 
Posts: 1861
Joined: Fri Apr 17, 2009 12:07 pm
Location: New Zealand

Re: Random SQL errors

Postby retrofuturist » Thu Oct 29, 2009 4:36 am

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/
http://www.dhammawheel.com/

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. :)
If you have asked me of the origination of unease, then I shall explain it to you in accordance with my understanding:
Whatever various forms of unease there are in the world, They originate founded in encumbering accumulation. (Pārāyanavagga)


Exalted in mind, just open and clearly aware, the recluse trained in the ways of the sages:
One who is such, calmed and ever mindful, He has no sorrows! -- Udana IV, 7


Dharma Wheel (Mahayana / Vajrayana forum) -- Open flower ~ Open book (blog)
User avatar
retrofuturist
Site Admin
 
Posts: 14674
Joined: Tue Dec 30, 2008 9:52 pm
Location: Melbourne, Australia

Re: Random SQL errors

Postby catmoon » Thu Oct 29, 2009 4:44 am

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

Do the errors correspond with usage peaks?
User avatar
catmoon
 
Posts: 368
Joined: Sat Oct 17, 2009 1:59 am

Re: Random SQL errors

Postby retrofuturist » Thu Oct 29, 2009 4:49 am

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. :)
If you have asked me of the origination of unease, then I shall explain it to you in accordance with my understanding:
Whatever various forms of unease there are in the world, They originate founded in encumbering accumulation. (Pārāyanavagga)


Exalted in mind, just open and clearly aware, the recluse trained in the ways of the sages:
One who is such, calmed and ever mindful, He has no sorrows! -- Udana IV, 7


Dharma Wheel (Mahayana / Vajrayana forum) -- Open flower ~ Open book (blog)
User avatar
retrofuturist
Site Admin
 
Posts: 14674
Joined: Tue Dec 30, 2008 9:52 pm
Location: Melbourne, Australia

Re: Random SQL errors

Postby poto » Thu Oct 29, 2009 5:01 am

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
poto
 
Posts: 363
Joined: Sat Oct 17, 2009 3:21 am

Re: Random SQL errors

Postby retrofuturist » Thu Oct 29, 2009 5:09 am

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. :)
If you have asked me of the origination of unease, then I shall explain it to you in accordance with my understanding:
Whatever various forms of unease there are in the world, They originate founded in encumbering accumulation. (Pārāyanavagga)


Exalted in mind, just open and clearly aware, the recluse trained in the ways of the sages:
One who is such, calmed and ever mindful, He has no sorrows! -- Udana IV, 7


Dharma Wheel (Mahayana / Vajrayana forum) -- Open flower ~ Open book (blog)
User avatar
retrofuturist
Site Admin
 
Posts: 14674
Joined: Tue Dec 30, 2008 9:52 pm
Location: Melbourne, Australia

Re: Random SQL errors

Postby poto » Thu Oct 29, 2009 6:29 am

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
User avatar
poto
 
Posts: 363
Joined: Sat Oct 17, 2009 3:21 am

Re: Random SQL errors

Postby Mawkish1983 » Thu Oct 29, 2009 6:49 am

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!
Mawkish1983
 
Posts: 1175
Joined: Mon Jan 12, 2009 9:46 am
Location: Essex, UK

Re: Random SQL errors

Postby Sanghamitta » Thu Oct 29, 2009 12:55 pm

Mawkish1983 wrote: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!

That would be my view. On the rare occassions when I dropped into E Sangha I would be taken aback by some of the inappropriate ads that would drop down.
The going for refuge is the door of entrance to the teachings of the Buddha.

Bhikku Bodhi.
Sanghamitta
 
Posts: 1614
Joined: Wed Jul 29, 2009 9:21 am
Location: By the River Thames near London.

Re: Random SQL errors

Postby nomad » Sun Nov 01, 2009 1:59 pm

I’d rather pay a small fee than have to put up with ads.

~nomad

:sage:
"I am because we are." -Xhosa Tribal Saying
User avatar
nomad
 
Posts: 52
Joined: Sun May 10, 2009 12:59 am
Location: Dayton, OH

Re: Random SQL errors

Postby David N. Snyder » Sun Nov 01, 2009 2:03 pm

There won't be any ads here, rest assured. If we need more storage or bandwith space, I will cover the cost or there could be a dana collection at some point in the future, if necessary, but right now we are only using a small fraction of our allowed storage and bandwith space. See also:

viewtopic.php?f=8&t=2096
User avatar
David N. Snyder
Site Admin
 
Posts: 8115
Joined: Tue Dec 30, 2008 4:15 am
Location: Las Vegas, Nevada

Re: Random SQL errors

Postby nomad » Sun Nov 01, 2009 9:10 pm

David N. Snyder wrote:There won't be any ads here, rest assured. If we need more storage or bandwith space, I will cover the cost or there could be a dana collection at some point in the future, if necessary, but right now we are only using a small fraction of our allowed storage and bandwith space. See also:

viewtopic.php?f=8&t=2096


Wonderful to hear. :)

~nomad

:sage:
"I am because we are." -Xhosa Tribal Saying
User avatar
nomad
 
Posts: 52
Joined: Sun May 10, 2009 12:59 am
Location: Dayton, OH


Return to Suggestion box

Who is online

Users browsing this forum: No registered users and 1 guest