General Error SQL ERROR [ mysql4 ]

Talk about stuff specific to the site -- bugs, suggestions, and of course praise welcome.
User avatar
Uncle Spellbinder
Posts: 3519
Joined: May 28th, 2004, 4:52 pm
Location: Highland, IN - U.S.A.
Contact:

General Error SQL ERROR [ mysql4 ]

Post by Uncle Spellbinder »

I've been getting these messages for many weeks. But the past week or so, it's been several times a day. I couldn't get in for over an hour just now due to the following message...

General Error
SQL ERROR [ mysql4 ]

Lost connection to MySQL server at 'reading initial communication packet', system error: 111 [2013]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
My Firefox Add-Ons Collection: Firefox Essentials
User avatar
ltsnow
Posts: 1173
Joined: March 23rd, 2006, 1:49 pm
Location: Valdosta, GA

Re: General Error SQL ERROR [ mysql4 ]

Post by ltsnow »

I have seen a higher frequency recently too. Get some everyday. Couldn't get on for the past 2 hours.
User avatar
DanRaisch
Moderator
Posts: 127224
Joined: September 23rd, 2004, 8:57 pm
Location: Somewhere on the right coast

Re: General Error SQL ERROR [ mysql4 ]

Post by DanRaisch »

There are issues with the servers the forums are hosted on. It's being worked on but apparently no solution has been implemented as yet.
User avatar
a;skdjfajf;ak
Posts: 17002
Joined: July 10th, 2004, 8:44 am

Re: General Error SQL ERROR [ mysql4 ]

Post by a;skdjfajf;ak »

This outage has been on-going for way too long - I have doubts anyojne is working on it....
User avatar
Daifne
Moderator
Posts: 123071
Joined: July 31st, 2005, 9:17 pm
Location: Where the Waters Meet, Wisconsin

Re: General Error SQL ERROR [ mysql4 ]

Post by Daifne »

kerz has reported in stating that he is...
DMCrimson
Posts: 1025
Joined: February 13th, 2004, 6:11 am

Re: General Error SQL ERROR [ mysql4 ]

Post by DMCrimson »

Hopefully it gets fixed soonish, it's rather irritating:)
User avatar
Daifne
Moderator
Posts: 123071
Joined: July 31st, 2005, 9:17 pm
Location: Where the Waters Meet, Wisconsin

Re: General Error SQL ERROR [ mysql4 ]

Post by Daifne »

It's irritating for all of us. I spotted a spam post a while ago, went to remove it and got the error...
DMCrimson
Posts: 1025
Joined: February 13th, 2004, 6:11 am

Re: General Error SQL ERROR [ mysql4 ]

Post by DMCrimson »

Well, it's good info that there's ppl working on it:) Have had this about once a day, but usually when I'm looking for some info on theming forum :D It might be annoying, but I can live with it - I think there's quite a few users on this forum and even more threads etc. so problems are bound to surface...
User avatar
kerz
mozillaZine Admin
Posts: 1804
Joined: November 4th, 2002, 2:04 pm
Contact:

Re: General Error SQL ERROR [ mysql4 ]

Post by kerz »

The database we use is a shared one. It was recently upgraded, and the upgrade is causing some segfaults. Our hosts are working hard to fix.

jason
User avatar
Uncle Spellbinder
Posts: 3519
Joined: May 28th, 2004, 4:52 pm
Location: Highland, IN - U.S.A.
Contact:

Re: General Error SQL ERROR [ mysql4 ]

Post by Uncle Spellbinder »

Thanks Jason for the info. But damn....it's been weeks (if not months). For a board as popular as MozillaZine, you'd think phpBB Group would be a bit more professional about this. I frequent a music discussion board that is also a phpBB Group board. Had the same issue. With a few persistent calls/emails and 2 server changes, the issue has been corrected. Seems if a small, indie music board with nowhere near the same number of members can garner the attention of phpBB Group and get this fixed, so can Mozillazine.
My Firefox Add-Ons Collection: Firefox Essentials
User avatar
Gingerbread Man
Posts: 7735
Joined: January 30th, 2007, 10:55 am

Re: General Error SQL ERROR [ mysql4 ]

Post by Gingerbread Man »

Uncle Spellbinder wrote:it's been weeks (if not months).

LIMPET235 wrote:It's a slight error/glitch with the forum software.
The boss knows about it & is working on it.

January 4th
And that's just what's still on the first page of this forum.
User avatar
Daifne
Moderator
Posts: 123071
Joined: July 31st, 2005, 9:17 pm
Location: Where the Waters Meet, Wisconsin

Re: General Error SQL ERROR [ mysql4 ]

Post by Daifne »

Uncle Spellbinder,
Our hosts are the Open Source Labs at Oregon State University. I don't think we'll be changing. Part of the problem is that we are using a shared database. The staff at OSL and Jason are tracking it down. We don't have the freedom to move like your small, indie music board.
User avatar
Uncle Spellbinder
Posts: 3519
Joined: May 28th, 2004, 4:52 pm
Location: Highland, IN - U.S.A.
Contact:

Re: General Error SQL ERROR [ mysql4 ]

Post by Uncle Spellbinder »

Daifne wrote:Uncle Spellbinder,
Our hosts are the Open Source Labs at Oregon State University. I don't think we'll be changing. Part of the problem is that we are using a shared database. The staff at OSL and Jason are tracking it down. We don't have the freedom to move like your small, indie music board.


Thanks for the clarification. I thought that a server move would have nothing to do with the host, providing the host has multiple servers. In any event, I hope this can be addressed soon. I guess the perils of shared databases is what we've been experiencing for months now. Too bad there can't be a dedicated database for Mozillazine.
My Firefox Add-Ons Collection: Firefox Essentials
User avatar
Uncle Spellbinder
Posts: 3519
Joined: May 28th, 2004, 4:52 pm
Location: Highland, IN - U.S.A.
Contact:

Re: General Error SQL ERROR [ mysql4 ]

Post by Uncle Spellbinder »

This is nuts. 1hr 45minutes I had the General Error SQL ERROR [ mysql4 ] error message. Then for another 20 minutes, I got this...

Can't find any servers to help you

The mozillazine servers seem to be on strike. The systems team is negotiating...

Please try again later

[this used to be the "drupal.org error"]


Then I had to log in again and was directed to a captcha screen.

It's becoming a chore to visit these forums.
My Firefox Add-Ons Collection: Firefox Essentials
User avatar
Gingerbread Man
Posts: 7735
Joined: January 30th, 2007, 10:55 am

Re: General Error SQL ERROR [ mysql4 ]

Post by Gingerbread Man »

The knowledge base is also often kaput.
The following error was encountered:

Connection Failed
The system returned:
(110) Connection timed out

The remote host or network may be down. Please try the request again.

But I guess I don't need to mention that, because all parties are aware of the problems and will diligently fix them very very soon.
Locked