MySQL on Lunar

[arachnopets]

Why is it that my site can't go for a day without problems with MySQL? My error from my vBulletin database for the day is...


Database error in vBulletin :

Link-ID == false, connect failed
mysql error: Host '127.0.0.1' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts'

mysql error number: 1129

Date: Wednesday 09th of July 2003 01:17:08 PM
Script: /arachnoboards/forumdisplay.php?s=&forumid=2
Referer:


I think that I'm gonna start a log here and everytime I receive an email error message over 100 times from vBulletin, I'll post it here. We can start a running commentary on it....

This is ridiculous already....

[RocketJeff]

mysql error: Host '127.0.0.1'
This error message makes it look like you're using 'localhost' as your database server name. Try changing it to 'lunar.powweb.com'.

MySQL connects to the database using different methods if you specify 'localhost' or the full name of the server (even if they're actually the same box).

[Walt_Felix]

Originally posted by RocketJeff
This error message makes it look like you're using 'localhost' as your database server name. Try changing it to 'lunar.powweb.com'.

MySQL connects to the database using different methods if you specify 'localhost' or the full name of the server (even if they're actually the same box).

I don't think that's it because I'm getting the similar errors and my database server name is set to 'lunar.powweb.com'.

I keep getting the following errors multiple times a day going back over a month:

Database error in vBulletin :

Link-ID == false, connect failed
mysql error: Can't connect to MySQL server on 'lunar.powweb.com' (60)

mysql error number: 2003

Date: Monday 30th of June 2003 01:51:51 PM
Script: /cgi-bin/forums/forumdisplay.php?s=&forumid=4
Referer:

Database error in vBulletin :

Link-ID == false, connect failed
mysql error: Lost connection to MySQL server during query

mysql error number: 2013

Date: Monday 30th of June 2003 04:07:23 PM
Script: http://www.CruiseNights.Info/cgi-bin/forums/cgi-bin/index.php?s=
Referer: http://search.yahoo.com/bin/search?p=cruise+night+ct&ei=UTF-8

Database error in vBulletin :

Link-ID == false, connect failed
mysql error: Host '127.0.0.1' is blocked because of many connection errors.
Unblock with 'mysqladmin flush-hosts'

mysql error number: 1129

Date: Wednesday 09th of July 2003 01:07:28 PM
Script: http://www.CruiseNights.Info/cgi-bin/forums/cgi-bin/index.php
Referer:


I could get very vocal here about how my one site hosted here suffers more down time than my other 7 sites combined which are hosted elsewhere. But, last time I got real vocal, my posts were edited, then deleted and my IP address at work was blocked from these forums. :mad:

[arachnopets]

Walt,

I get those all the time too, but like I said, I think I'm gonna start a log. Next time I start getting those messages in bulk, I'll put them up here too. The best one that I've had so far was when I kept getting messages that I went over the 36000 question limit. I got over 70,000 emails over a period of two days for that one. Of course they then shut my site down due to using too many resources when if their MySQL server counts were resetting themselves the way they should have, it would have never happened. My forum, running the same software as this one btw, gets much less usage yet I never remember getting a MySQL error while I'm on here......

[arachnopets]

Originally posted by RocketJeff
This error message makes it look like you're using 'localhost' as your database server name. Try changing it to 'lunar.powweb.com'.

MySQL connects to the database using different methods if you specify 'localhost' or the full name of the server (even if they're actually the same box).

Jeff,

I've been using localhost since I started my forums here back in July of last year. Never had a single problem till they started putzing around with MySQL limits. Since then my forums go down at least once a day for some period of time....

Scott

[Walt_Felix]

Originally posted by arachnopets
My forum, running the same software as this one btw, gets much less usage yet I never remember getting a MySQL error while I'm on here......

Funny you should say that because I have never had a problem on this forum either, that is until today. While checking for replies to this thread, I got the following error

MySQL Error 12 from table handler on SELECT <font face="ve

First time I've seen an error here.

[arachnopets]

We have our second log entry:

Database error in vBulletin :

Link-ID == false, connect failed
mysql error: Can't connect to MySQL server on 'lunar.powweb.com' (60)

mysql error number: 2003

Date: Friday 11th of July 2003 02:15:55 PM
Script: /arachnoboards/showthread.php?threadid=11506&perpage=15&pagenumber=2
Referer:

[linuxknight]

Im Using PHP-Nuke For My Website, Using MySQL, And My Server Is Hosted Under mysql01.powweb.com. Yours Will Be mysqlX.powweb.com Too!!

PS: I Had To Pay For My MySQL Account. I Deserve A Refund, Or Another Database!

[arachnopets]

Originally posted by linuxknight
Im Using PHP-Nuke For My Website, Using MySQL, And My Server Is Hosted Under mysql01.powweb.com. Yours Will Be mysqlX.powweb.com Too!!

PS: I Had To Pay For My MySQL Account. I Deserve A Refund, Or Another Database!

Actually, my database won't be on mysqlX.powweb.com because I've been here and had my database running since before they had dedicated MySQL servers such as "mysqlX".

On another note, MySQL on lunar has been dropping connections for my database for the past 20 minutes..... Anyone else having any problems????

Scott

[Walt_Felix]

Yes, I had seven more error notifications this morning and two from yesterday. :mad: :mad: This is not acceptable!

[Walt_Felix]

Apparently these clowns can’t seem to figure out how to set up a reliable MySQL server. I went away on vacation for 2 weeks and came home to find 222 database error messages in my inbox. Damn thing must have been down for most of my vacation.


Database error in vBulletin :

Link-ID == false, connect failed
mysql error: Host '127.0.0.1' is blocked because of many connection errors.
Unblock with 'mysqladmin flush-hosts'

mysql error number: 1129

Date: Thursday 24th of July 2003 12:44:16 PM
Script: /cgi-bin/forums/forumdisplay.php
Referer:



Database error in vBulletin :

Link-ID == false, connect failed
mysql error: Can't create a new thread (errno 35). If you are not out of
available memory, you can consult the manual for a possible OS-dependent
bug

mysql error number: 1135

Date: Friday 01st of August 2003 05:13:43 PM
Script: /cgi-bin/forums/forumdisplay.php?forumid=77&daysprune=1
Referer:



Database error in vBulletin 2.2.6:

Invalid SQL: SELECT template,title
FROM template
WHERE (title IN
('forumdisplay_threadslist_rateoption','forumdispl ay_threadslist_threadrate
','forumdisplaybit_threadrate','forumhome_lastpost by','forumdisplay_announc
ement','forumdisplay_moderator','forumdisplay_newt hreadlink','forumdisplay_
moderatedby','forumdisplay_forumbit_level1_post',' forumdisplay_forumbit_lev
el1_nopost','forumdisplay_forumbit_level2_post','f orumdisplay_forumbit_leve
l2_nopost','forumdisplay_loggedinuser','forumdispl ay_loggedinusers','forumd
isplay_adminoptions','forumdisplay_forumslist','fo rumdisplay_multipagenav_m
ore','forumdisplay_multipagenav_pagenumber','forum display_multipagenav','fo
rumdisplay_gotonew','forumdisplaybit','forumdispla y_threadslist','forumdisp
lay_nothreads','forumrules','forumdisplay','forumd isplay_sortarrow','forumd
isplay_newthreadlink','forumdisplay_announcementso nly','forumhome_moderator
','gobutton','timezone','username_loggedout','user name_loggedin','phpinclud
e','headinclude','header','footer','forumjumpbi!

t','forumjump','nav_linkoff','nav_linkon','navbar' ,'nav_joiner','pagenav','
pagenav_curpage','pagenav_firstlink','pagenav_last link','pagenav_nextlink',
'pagenav_pagelink','pagenav_prevlink')
AND (templatesetid=-1 OR templatesetid='1'))


ORDER BY templatesetid
mysql error: Lost connection to MySQL server during query

mysql error number: 2013

Date: Friday 01st of August 2003 05:21:16 PM
Script:
http://www.cruisenights.info/cgi-bin/forums/cgi-bin/forums/forumdisplay.php
?forumid=30&daysprune=1
Referer:



Database error in vBulletin :

Link-ID == false, connect failed
mysql error: Lost connection to MySQL server during query

mysql error number: 2013

Date: Monday 04th of August 2003 07:21:25 AM
Script: http://www.CruiseNights.Info/cgi-bin/forums/cgi-bin/index.php
Referer: http://www.cruisenights.info/

[RobC]

HI all,

I too am having the same problem on "lunar".

I'm simply hosting a very small OsCommerce site & for around the past 3 to 4hrs I've been unable to access my site at all....

This error is received:

Warning: mysql_connect() [function.mysql-connect]: Host '127.0.0.1' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /www/m/myusername/htdocs/catalog/includes/functions/database.php on line 19

I'm unaware as to how often this occurs or for how long, either way it's NOT GOOD!

Admins: Whats going on?

regards,

Rob:mad:

[Walt_Felix]

I deleted 222 errors the other day and found 136 new errors in the inbox today.


Database error in vBulletin 2.2.6:

Invalid SQL: DELETE FROM session WHERE sessionhash=''
mysql error: MySQL server has gone away

mysql error number: 2006

Date: Thursday 14th of August 2003 06:31:13 AM
Script: http://www.cruisenights.info/cgi-bin/forums/cgi-bin/index.php
Referer: http://www.cruisenights.info


Database error in vBulletin :

Link-ID == false, connect failed
mysql error: Host '127.0.0.1' is blocked because of many connection errors.
Unblock with 'mysqladmin flush-hosts'

mysql error number: 1129

Date: Thursday 14th of August 2003 11:33:55 AM
Script: /cgi-bin/forums/forumdisplay.php?forumid=84&daysprune=11
Referer:

[mjp]

I've brought this to the attention of two admins and hopefully one or both will pick up the message soon and take a look at this issue.

mjp

[mjp]

I already heard back from an admin who ran flush-hosts on the lunar MySQL server which should clear up the problem. They'll be keeping an eye on it as well.

mjp