SQL ERROR [ mysql4 ]

A place for Site Announcements, Suggestions, Bug Reports and Unadulterated Praise..
Post Reply
User avatar
PFVA
Sheepie Whore
Sheepie Whore
Posts: 14996
Joined: Fri May 24, 2002 1:40 am 0
Location: Paralel 38

SQL ERROR [ mysql4 ]

Post by PFVA »

General Error
SQL ERROR [ mysql4 ]

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

An sql error occurred while fetching this page.


Just reporting i got this late last night, after midnight until about 2AM when i went sleep. Today is fine. I'm not sure if it's important or not.
User avatar
RiK
Sheepie Whore
Sheepie Whore
Posts: 16092
Joined: Tue Apr 23, 2002 11:32 pm 0
XBL Gamertag: Dr Olpin
PSN: Dr Thumpy
Location: The Shire
Contact:

Re: SQL ERROR [ mysql4 ]

Post by RiK »

User avatar
gravy
Sheepie Whore
Sheepie Whore
Posts: 19572
Joined: Wed May 01, 2002 1:28 pm 0
Location: The Other Place

Re: SQL ERROR [ mysql4 ]

Post by gravy »

Cheers :)
User avatar
zip accident
Sheepie Whore
Sheepie Whore
Posts: 13928
Joined: Sun Feb 20, 2005 1:58 pm 0
Location: Bristol, UK

Re: SQL ERROR [ mysql4 ]

Post by zip accident »

I presume someone here knows about this, but on the off chance that no-one does, I thought I ought to mention it. I don't know what whatever logs there are are saying, but last night from about 12 midnight the site was down, with this error.

It's happened once before since this thread was started, on a Sunday, but I don't remember whether it was at the Saturday -> Sunday or Sunday -> Monday switchover.
"My way is the way of not fighting":- the book of Enter the Dragon.
User avatar
gravy
Sheepie Whore
Sheepie Whore
Posts: 19572
Joined: Wed May 01, 2002 1:28 pm 0
Location: The Other Place

Re: SQL ERROR [ mysql4 ]

Post by gravy »

It's done it a couple of times in the last month after running out of swap space.

I need to set up a daemon that resets the machine when that happens. On the plus side it's now 6 quid a month for hosting as opposed to £70 :D
User avatar
defsdoor
Baaaaaa!
Baaaaaa!
Posts: 3909
Joined: Fri Jan 30, 2004 12:26 am 0
Location: Sunny Beduff

Re: SQL ERROR [ mysql4 ]

Post by defsdoor »

Can't you set ulimit on the guilty process to kill it long before it affects the server ? Or maybe rub it via DJB's softlimit ?
User avatar
cj2003
Baaaaa!
Baaaaa!
Posts: 1339
Joined: Tue Jan 03, 2006 12:49 pm 0
Location: Denmark
Contact:

Re: SQL ERROR [ mysql4 ]

Post by cj2003 »

gravy wrote:...On the plus side it's now 6 quid a month for hosting as opposed to £70 :D
Great - enjoy :tea:
Say hi to my new website Wewalk.dk
Post Reply