mysql09 (Merged Threads)

[roleli]

Is powweb having problems with the Mysql Databse server?

I am getting intermitten errors on my site http://jamaicagasprices.com.jm/?

The queries were working well but now they work intermittenly.

THis is fustrating!

[WATRD]

Does this look familiar to anyone?

Warning: mysql_connect(): Too many connections in /www/w/path/path/path/db/mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /www/w/path/path/path/db/mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /www/w/path/path/path/db/mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database

It's been happening with increasing frequency on my forum, usually just as you have completed a long post and click the <Submit> button. Yet, if you click the back button, then <Submit> again, it works fine. Sometimes it takes a couple of times for it to work, but eventually it goes through.

This used to happen once in rare while, then suddenly this morning it's happening almost ever attempt to submit a reply. The forum currently has 8 people logged on, so I don't think there is actually a problem with too many connections...

It's really getting irritating.

mysql09.powweb.com

[stevehare]

A visitor to a osCommerce shopping cart reported a "too many connections" error that led me to this link:

http://dev.mysql.com/doc/mysql/en/too-many-connections.html

Is there a way to "fix" this or increase the number of allowed connections (the link indicates that there is a max_connections setting)?

[WATRD]

Which server? See my thread from about 20 minutes before you started this one... I am seeing it too.

[stevehare]

This is the error my visitor reported (it has NEVER happened to me).

/www/t/thinkingteal/htdocs/ttproducts/catalog/includes/functions/database.php on line 19

[YvetteKuhns]

You already posted the answer to your question in the link. While you can edit osCommerce, you can also edit your .htaccess file.

Another symptom for PHP users, the "max_connections" error being returned to the browsers and the "show processlist" filling up with sleeping threads: This can sometimes be alleviated by using the PHP .htaccess option to lower the connect timeout from the default 60 seconds.

php_value mysql.connect_timeout 20


This would be easier to try. Make a copy of your .htaccess file before editing it. Then add the line. If that doesn't work or help, you can always remove it or replace the file with the original. Be sure to edit scripts in Notepad or another plain editor.

[WATRD]

The thread makes two suggestions;

In the php.ini
[MySQL]
; Allow or prevent persistent links.
mysql.allow_persistent=Off

and in .htaccess
php_value mysql.connect_timeout 20

What are the advantages or disadvantages to either? Are we sure this is something we should be trying to fix individually or is it a problem at Powweb's level?

[stevehare]

My .htaccess didn't say anything about mysql...it basically just refers to the .htpasswd file.

Looking at the line that the error referred to, here is the exact line:

$$link = mysql_connect($server, $username, $password);

What do I need to change?

[mitchind]

Name your server (mysql##.powweb.com) and others can compare.


users are reporting problems on mysql09 ... is that your db server too?

[YvetteKuhns]

What are the advantages or disadvantages to either? Are we sure this is something we should be trying to fix individually or is it a problem at Powweb's level?

Good question! It is easy to add one line of code to the .htaccess file. If that works, great. If not, you could try to edit the php.ini file. That file is a big one, but if that works, great. If not, then hopefully PowWeb can help, but sometimes that can take longer and if you can fix it yourself quicker, that is nice.

I have not personally experienced your EXACT problem, so I can only make suggestions if you don't want to sit and wait.

[stevehare]

Here's the contents of my .htaccess (what would/could I change?):

# $Id: .htaccess,v 1.3 2003/06/12 10:53:20 hpdl Exp $
#
# This is used with Apache WebServers
#
# For this to work, you must include the parameter 'Options' to
# the AllowOverride configuration
#
# Example:
#
# <Directory "/usr/local/apache/htdocs">
# AllowOverride Options
# </Directory>
#
# 'All' with also work. (This configuration is in the
# apache/conf/httpd.conf file)

# The following makes adjustments to the SSL protocol for Internet
# Explorer browsers

<IfModule mod_setenvif.c>
<IfDefine SSL>
SetEnvIf User-Agent ".*MSIE.*" \
nokeepalive ssl-unclean-shutdown \
downgrade-1.0 force-response-1.0
</IfDefine>
</IfModule>

# Fix certain PHP values
# (commented out by default to prevent errors occuring on certain
# servers)

#<IfModule mod_php4.c>
# php_value session.use_trans_sid 0
# php_value register_globals 1
#</IfModule>

[mitchind]

My .htaccess didn't say anything about mysql...it basically just refers to the .htpasswd file.

Looking at the line that the error referred to, here is the exact line:

$$link = mysql_connect($server, $username, $password);

What do I need to change?

I'm assuming that's not the exact quote - you shouldn't have two "$" signs in your variable name.

As asked before - what mysql server are you on? (mysql##.powweb.com)

This likely doesn't have anything to do with htaccess - it's more likely to do with a busy mysql server that's shared by many users.

So unless you're selling a lot of products in your catalog, I don't see the benefit of fine-tuning your php file. You'd have to get everyone else doing the same thing (or Powweb turning that on by default) to have it make a difference.

Who knows what other problems migth come into play too?

[stevehare]

mysql09

That was an exact quote.

Here's some more from database.php (about 3 lines before and after line 19):

function tep_db_connect($server = DB_SERVER, $username = DB_SERVER_USERNAME, $password = DB_SERVER_PASSWORD, $database = DB_DATABASE, $link = 'db_link') {
global $$link;

if (USE_PCONNECT == 'true') {
$$link = mysql_pconnect($server, $username, $password);
} else {
$$link = mysql_connect($server, $username, $password);
}

if ($$link) mysql_select_db($database);

return $$link;

[mitchind]

The "too many connections" doesn't have anything to do with your forum - especially if there's only a few users online.

As it suggests It's symptomatic of a busy mysql server - that's shared by a lot of other users here.

Maybe one of them is using of those dreaded "Chat" applications that occasionally causes a site to be disabled. :confused: Or it could be someone doing a big inefficient restore. Only the admins can tell for sure...

In any case your best bet is to keep track of when the errors occur and ask Powweb support about it. Maybe they can track down the offender.

A check on http://www.tbonekkt.com/?pg=status shows it looks okay now - but that means nothing for "connection" errors - they can be sporadic.

[WATRD]

Good question! It is easy to add one line of code to the .htaccess file. If that works, great. If not, you could try to edit the php.ini file. That file is a big one, but if that works, great. If not, then hopefully PowWeb can help, but sometimes that can take longer and if you can fix it yourself quicker, that is nice.

I have not personally experienced your EXACT problem, so I can only make suggestions if you don't want to sit and wait.

I can experiment, but it's more the possible, unexpected, undesired side effects that I am worried about.

Since it appears that more than one of us is having problems with connections on mysql09, my gut says it's a more global problem, so I have opened a trouble ticket. We shall see what the reaction to that is... If I don't see any movement, then I will see what I can do individually :)

Thanks!

[WATRD]

Thanks! It's been happening more and more frequently, so I opened a support ticket earlier to see if they can give me an indication of what is going on.

From reading other threads, I am not the only who is having problems with mysql09, so I suspect it's overloaded :(

[Skunkboy]

It's been made aware now at least four times in the past hour about issues with mySQL09. I myself am not using any SQL nor have anything on 09; but, I have made a call into PW to inform them of the issues and our friendly admins are on it even as we speak - four separate sites on the same box, something must be happening.

[White Bear]

I've been have problems with slow response and database timeouts, for the last 9 hours. Spoke to POW WEB, Tech. support a few Min. ago. They are working on the problem.

seastriper.com

[roleli]

database server ->mysql09.powweb.com

Problems persists

[White Bear]

I'm now about 13 hours into this problem. Opened a ticket, but don't have a time for resolution. :confused:

Database error in vBulletin :

Link-ID == false, connect failed
mysql error:

mysql error number: 0

Date: Friday 08th of April 2005 04:09:47 PM

[Skunkboy]

As per a conversation with one of the superiors, this problem has been resolved to the best of their knowledge. IF you are still experiencing problems, please let us know with what site the problem resides.

Thank you ;)

[dantol]

o geez, why did I pick mysql09.powweb.com, I had 8 other choices.
Is there any way I can switch to mysql08.powweb.com ?

[ergo_etc]

man, my website has been online and offline due to mysql09 problem over the last 12 hours!. This is really bad. I really hope they are doing something about it.

I know powweb is cheap and for that, i do expect less feature, but i don't expect it not to work.

[msxsecurity.com]

Or is it me?
I run www.msxsecurity.com and it is tremendously slow most of the time, sometimes not responding at all, other times responding normally.
When it doesnt respond at all, sometimes I get a mysql warning, somethin along the lines of " mySQL error: Too many connections " I know this has nothing to do with my site because I never had this problem before yesterday, and now the problem wont go away.
Any ideas?
I have no custom php.ini's or any modded htaccess files (except one for error documents)
Thanks..

[dantol]

mysql09 sucks, change it to mysql08 or any other.
I had tremendous problems with installing php script yesterday, all because mysql09.

[White Bear]

It's still bad for my site also. It's been that way for about 36 hours. I've been in phone and e-mail contact with Tech. support, they said they had removed some resource hogs, but my site is still having the same problems. Just, sent them another follow-up e-mail.

I'm having the same problems that you are, with failure to connect and long time delays on mysql09. If it's a money issue, I'd pay more per Mo. to get better service. :confused: :confused:

seastriper.com
----------------------------------------
Database error in vBulletin :

Link-ID == false, connect failed
mysql error:

mysql error number: 0

Date: Saturday 09th of April 2005 10:06:47 AM

[White Bear]

mysql09 sucks, change it to mysql08 or any other.
I had tremendous problems with installing php script yesterday, all because mysql09.
What's the process to do this ?? Just, make a request to powweb tech support, that I want to move ??

[dantol]

I am not 100% sure and if I am wrong you can correct me, BUT I think that you can have up to 5 free MYSQL databases. And also, when you login to your phpmyadmin, I also noticed there is a "server choice" and then you have listed all 9 mysql hosts. Maybe you could download your current database and upload it to mysql08 or mysql07? Would that work?

[alphadesk]

I am not 100% sure and if I am wrong you can correct me, BUT I think that you can have up to 5 free MYSQL databases. And also, when you login to your phpmyadmin, I also noticed there is a "server choice" and then you have listed all 9 mysql hosts. Maybe you could download your current database and upload it to mysql08 or mysql07? Would that work?No ... when you order a DB that DB name user pass are "assigned" a certain DB and you can't change it at will.

[RTH10260]

mysql09 sucks, change it to mysql08 or any other.
You cannot just change the server, you need to take what Powweb assigns to you by default ...

Ooops - see that alphadesk has already answered ... :D

[RTH10260]

BUT I think that you can have up to 5 free MYSQL databases. The databases are not 'free', they are part of your initial subscription. Any further database will cost you $$$.
And also, when you login to your phpmyadmin, I also noticed there is a "server choice" and then you have listed all 9 mysql hosts.The dropdown is an easy way to select the server where your database is on, it's not that you can make an arbitrary choice of a server.

For the Powweb wishlist: of course a nice phpAdmin inegration with Powweb would just show the users databases and only ask for the password, without asking for the physical server.

[msxsecurity.com]

Ok, I cant get on IRC because the stupid bot keeps banning me.
Nobody seems to want to do anything about it either.
What I dont get is, I PAY for this, yet I have had NO answer at all at whats going on?
Can I just mvoe to another mysql server or something? This is ridiculous.

[msxsecurity.com]

Seriously though, my site has been slow as hell, or totally unresponsive for the past 36 hours.
Either move me to another server or fix the problem!
99% uptime isnt sounding so true anymore.

[RTH10260]

Ok, I cant get on IRC because the stupid bot keeps banning me.
Nobody seems to want to do anything about it either.
What I dont get is, I PAY for this, yet I have had NO answer at all at whats going on?
Can I just mvoe to another mysql server or something? This is ridiculous.
Is your problem related with this:
http://powweb.com/faq/index.php?category=Supported+Applications&faq_id=276
or
Customer Use of Services in http://powweb.com/PowWeb/Company/Policy/TOS (search page for term IRC)

[xpanshun]

Does this look familiar to anyone?



It's been happening with increasing frequency on my forum, usually just as you have completed a long post and click the <Submit> button. Yet, if you click the back button, then <Submit> again, it works fine. Sometimes it takes a couple of times for it to work, but eventually it goes through.

This used to happen once in rare while, then suddenly this morning it's happening almost ever attempt to submit a reply. The forum currently has 8 people logged on, so I don't think there is actually a problem with too many connections...

It's really getting irritating.

mysql09.powweb.com


Been experiencing that EXACT problem! Glad to see I'm not alone since the
reason for our move to a new server here at POWWEB was for room to grow and
also b/c we had been HACKED, my forum moderators were getting worried we
were being 'targeted' again for some reason.

site is: www.jregrassroots.org

Board has been slowing down and having connectivity issues. Put in a couple
of queries in multiple related threads in the hopes of getting a faster response.

Hopefully this will be taken care of soon.

-XP

[msxsecurity.com]

Is your problem related with this:
http://powweb.com/faq/index.php?category=Supported+Applications&faq_id=276
or
Customer Use of Services in http://powweb.com/PowWeb/Company/Policy/TOS (search page for term IRC)
I meant IRC as in the #powweb, in live chat.
Thats sort of off the point though isnt it?

[msxsecurity.com]

Nevermind all of that, When will this problem be resolved.
This is the 24th hour than ALL users on mysql09 have had HORRIBLY slow connections (IF ANY)
And also no response from any admin on the issue as to a ETA to being fixed.

[Gorkfu]

So this means the login is down for mysql09? Was just about to integrate stuff too :(

[roleli]

I am still having problems. Very disappointed.

[msxsecurity.com]

Can we please get a response here? this is coming up on 48 hours downtime, not like what I was promised when I signed on.

[msxsecurity.com]

2AM central time, problem persists.

[White Bear]

Not counting the slow response problems, I've had 76 "failure to connect" to my database errors, on mysql09 today. I have an open trouble ticket with POW WEB Tech. support, also called the support phone number today. They said the Admin. types were looking at a excessive loading problem, but as I write this the problem continues on mysql09.

It's still bad for my site also. It's been that way for about 36 hours. I've been in phone and e-mail contact with Tech. support, they said they had removed some resource hogs, but my site is still having the same problems. Just, sent them another follow-up e-mail.

I'm having the same problems that you are, with failure to connect and long time delays on mysql09. If it's a money issue, I'd pay more per Mo. to get better service. :confused: :confused:

seastriper.com
----------------------------------------
Database error in vBulletin :

Link-ID == false, connect failed
mysql error:

mysql error number: 0

Date: Saturday 09th of April 2005 10:06:47 AM

[ergo_etc]

i have had numerous connection fialure over the last 2 days.. very disappointing... it was ok for a few hours today and now it is starting again...

Do we need to remind powweb what they promise?

Truly Dependable Web Hosting - The PowWeb Hosting Advantage
PowWeb offers top notch web hosting, domain names, and email services. Our quality hosting is affordable for either a small business website or a personal web site. Many web hosting review sites rank us as the best web hosting provider, because we offer web tools for web site marketing, webmail services, domain names and other web hosting services.

[Jam-cat]

0 DB_ERROR_NOT_CONNECTED

ARRRRRRGGGGGGHHHHHHHHHH... It's getting a wee bit stupid now.

C'mon guys

[stradicaster]

Hey this errors ruined my web site. Just seeing nothing but database errors is not fun. My all site's database is on mysql09. I have the same problem and getting embrassed to users.

spturk.com

[White Bear]

The problems with mysql09 continues today for me also, problems started for me almost 4 days ago. My guess is that this loading or resource issue is impacting everyone on this server.

This might be a case where the sales or marketing side of the house, oversold the internal resources of the company. The Admin. staff is just trying to make the best of a bad situation. Sounds like they need to add another sql server or redistribute the loads.

[KRaNiX]

im on the same server and having intermittant faults pretty much all the time for maybe 3 days now, MySQL09 "TOO MANY CONNECTIONS...."

[msxsecurity.com]

2:45 pm, problem persists. Going on 72 hours downtime.
UNACCEPTABLE

[xpanshun]

I realize that just having people complain doesn't help fix the problem
any faster, but if an admin or POWWEB Staffer could PLEASE give us
an update and/or make suggestions as to help US help YOU fix this
issue, I think many here would be VERY GRATEFUL.

Still getting errors...
Site is: http://www.jregrassroots.org

Warning: mysql_connect(): Too many connections in /www/j/jregrassroot/htdocs/db/mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /www/j/jregrassroot/htdocs/db/mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /www/j/jregrassroot/htdocs/db/mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database

Anyone know how to minimize the number of dB queries per page for
an installation of phpBB? I'm willing to help out where I can if it will
make a difference.

Come on--this is seriously slowly killing my site membership off!
Please POWWEB, update...suggestions...ANYTHING! :(

-XP

[White Bear]

I talked to Peter in PowWeb Support a few Min. ago. PowWeb admin is aware of problem, but it will not be resolved until Monday. Sounds like the weekend crew is just a caretaker group. I'm not sure why it was not taken of last week, before the staff left for the weekend.

I asked about moving my site to another mysql server, they don't want to do that. Guess the problem is, if they do it for one site, everyone else would want to move off the server having problems.

Will see what happens on Monday...

[dantol]

MySQL09 sucks, my php can't connect to database. PowWeb, you got2 upgrade your hardware. This problem persists for days. It's horrible. And me, fool, I had 8 other options, and I picked MySQL09.

[takashi_maze]

All the apps we have currently running on my database in SQL09 keep ceasing to work every so often. It's been happening for a day or 2.

[msxsecurity.com]

5pm, problem persists.

[ergo_etc]

yup still had problem...

[White Bear]

Yes, everyone on mysql09 is having problems. See the MySQL forum for more info.

I don't know why the Admin. guys here at PowWeb don't post a message in the "Outages/Service Problems" area for everyone to read, when they have a known problem impacting lots of users like this.

It would save everyone lots of time & effort.

[Gorkfu]

Mysql09 been crazy yea, but I'm sure It'll get better. It's pretty much random, some connects work and some don't. Kinda like relationships... ;)

[kung]

I am on MySQL05 and my php site is also extremely slow intermittently. I am not getting errors but my pages are taking 20 to 30 secs to load. I dont even have that much content per page. :(

Anyone on MYSQL 05 with the same problems?

Personally I think that with their new promotion they are probably signing up more then they can handle.

Kung

[ergo_etc]

Mysql09 been crazy yea, but I'm sure It'll get better. It's pretty much random, some connects work and some don't. Kinda like relationships... ;)

but we paid for this!

[ergo_etc]

True! Powweb admin, just come forward and admit the problem and say some bs like "we are aware of the problem and are trying hard to fix it.. bla bla bla..." it won't fix a thing, but at least your loyal customers will feel much better!

[Gorkfu]

hahaha.. everybody is going mad! this has been going on for some time!!!


Your quote from the other thread pretty much explains my prior response. LOL :p

[msxsecurity.com]

8pm, problem persists.

[xspeed]

this is interesting, because i am running a brand new e-store, of which is not publicly available yet, and i am the only user on it, yet i am receiving the "too many connections" error.

this is strange.

[RTH10260]

this is interesting, because i am running a brand new e-store, of which is not publicly available yet, and i am the only user on it, yet i am receiving the "too many connections" error.

this is strange.
It's not strange, your application is running in a shared environment, and the database server itself is running at the limit of configured number of parallel open sessions. Sometimes you are the lucky guy and get a free slot, other times you get hit by the limit.

Technically you could run a small loop around the db connect command (with a controlled exit after a few unsuccessful retries) and wait a few seconds until retry rather than droping out immediatly with an error.

[roleli]

Problem continues.... :(

[msxsecurity.com]

11pm, problem persists.

[Skunkboy]

Computers are machines and break down - there's no stopping that from happening. Powweb hates downtime as much as if not more than you the customers. Keep in mind that they HAVE been working on the problem through the weekend - as I have had direct contact with an admin who has verified some of the activity they're doing. Humans then are not God either by any means and don't have the answer to everything with the flick of a wrist. They have been at it throughout the weekend and in general, considering they've got over 60,000 sites hosted here, well, I've been in the web for nearly ten years somehow or another and quite frankly, I don't think any of my previous hosts could handle the load as Powweb does. I'm about to enter my third year here and, well, for the very few glitches they've had, Powweb still is an A+ in my book. Afterall, it's a SHARED hosting server - NOT a dedicated box of your own... to run a box of your own, unadministered... unless you really know what you're doing, good luck!

[Skunkboy]

time... time... time...
Your quoting of times means nothing - where it's 0100 in one place it could be 1400 in Powweb's timezone. Aside from spamming the forum, I see no need... your msgs have no body content.

Powweb admin, just come forward and admit the problem and say some bs like "we are aware of the problem and are trying hard to fix it.. bla bla bla..."
Hmm, if you think about it, that's an oxymoron. You're not wnating to hear that "we are aware of the problem and are..." from staff but yet wouldn't you rather have the qualified admins doing their job at troubleshooting the root of the problem? I personally am glad that tier1 staff is telling people that admins are aware of the problem. If admins have a whole bunch of extra time on their hands then they're obviously not working on the problem; but, considering you've barely seen any admin posts in the forum, rest assured, they are working on a resolution

[ergo_etc]

Skunkboy, you call me a moron? Is it wrong for me to ask for official words from Powweb? How many people here think I am wrong to ask Powweb to make official announcement? In OPS main panel, there is a section called "Outages / Service Problems:". Is it really that hard to post an announcement there? Would it take more than a few minutes?

I was working on my site when this happen and i thought it was my mistakes. I keep on editing my files, upload it, test it only to have these intermittent problem. I battle with it for hours thinking that it was my fault. Only after i browse in here that i found out that it wasn't my fault at all.

but, considering you've barely seen any admin posts in the forum, rest assured, they are working on a resolution
Maybe that works for you, but i bet it doesn't work like that for most people. Not having any official words here is the very thing that makes people nervous. You expect people to just chill out and rest assured?

[White Bear]

Is it wrong for me to ask for official words from Powweb? How many people here think I am wrong to ask Powweb to make official announcement? In OPS main panel, there is a section called "Outages / Service Problems:". Is it really that hard to post an announcement there? Would it take more than a few minutes?

I totally agree. This is a major service problem, and still no official announcements after almost four days. They don't seem to be able to fix the technical problems, so at least give us a status update.

If the Admin staff has been working all weekend on this problem, I'm not sure if the problem will be fixed on Monday. If the services have been oversold, then the only solution is to buy more hardware or reduce the number of heavy users.

If any PowWeb marketing staff read this, I'd gladly pay more money per Mo. for a higher level of service.

[RTH10260]

If any PowWeb marketing staff read this, I'd gladly pay more money per Mo. for a higher level of service.But that's exactly the UPS, the Unique Selling Proposal, of Powweb's marketing plan, to offer a single level of service over their whole platform at a very low price in a shared environment. If you are willing to pay more, than maybe you should be looking for a service provider elsewhere.

PS. I agree on the general tone in this thread, that Powweb for once has missed to announce that they have a technical problem, and are working on it. Usually the forum moderator will act as intermediary to TPTB, but once in a while they are also permitted to have their free day and weekend off ;)

[BerksWebGuy]

An announcement has been made HERE (http://forum.powweb.com/showthread.php?t=49780).

[WATRD]

Hmm, if you think about it, that's an oxymoron.

Skunkboy, you call me a moron?

He's not calling you a "moron". He's saying it's an oxymoronic statement to say the admins need to work harder on this task, but they need to take time out from their work to post their progress on the forum.

ox·y·mo·ron ( P ) Pronunciation Key (ks-môrn, -mr-)
n. pl. ox·y·mo·ra (-môr, -mr) or ox·y·mo·rons
A rhetorical figure in which incongruous or contradictory terms are combined, as in a deafening silence and a mournful optimist.
oxy·mo·ronic (-m-rnk) adj.
oxy·mo·roni·cal·ly adv.

http://dictionary.reference.com/search?q=oxymoron

[jang]

I know the admins have posted today that they're working on the problem with mysql09, but I just wanted to go on the record that my site has been having the same "too many connections" problem since last week. I hope they get it fixed soon!

[ergo_etc]

Ehm.. I apologize to skunkboy for accusing him of calling me names. Sincerely...

I was just trying to say that asking for official announcement is not an oxymoronic action. Anyway, we now have official status so lets not blow the issue. But i do think it is ok for user to post their issues if there are still problems. It seems to be getting better compared to saturday, but i still seeing the error every now and then, just have an error a minute ago and my site doesn't even have any visitor except me. (I put on a index.htm, but my real site uses index.php)

I am also worried that we are now receiving similar reports on other server as well.

ps: it amazed me that if a discussion forum is long enogh there is always a chance someone might eventually pull out a dictionary or argue with grammer... :) No offence ok WATRD

[White Bear]

Anybody hear any news, other than they are working on the problem. Any estimates for when mySQL09 will be normal ??

I'm fairly new to PowWeb, can any of you more experienced users here give some prospective to this problem ?? It would seem like 4 plus days would be enough to correct the problem, does this situation occur often ??

Before the "defenders of PowWeb" jump on this question with "Admin. guys are working hard" and all that, I'm just trying to get some history data over the last 12 Mos. or so.

Thanks, for any info you have, or want to share...

[ergo_etc]

i have 1 site at powweb for over a year. I don't have quatitative data, just a general feedback...

- occasional database downtime every month or 2, but never as persistance as this, things normally go back to normal within hours. Acceptable i''d say... but then again on all my previous site, i had some caching mechanism that will handle database downtime for a few hours.

- some email downtime. Once in 2 or 3 months our email are inaccesible for a few hours. If you are heavy on email, it could get pretty serious. There are times when i am thinking of getting dedicated email server.

-ftp can get really slow with connection error on busy day.

Other than that, it's pretty good.

[WATRD]

ps: it amazed me that if a discussion forum is long enogh there is always a chance someone might eventually pull out a dictionary or argue with grammer... :) No offence ok WATRD

None taken. I just wanted to make sure that we were all using the same terms and not taking them personally.

BTW; just to pile on, my site continues, like everyone elses, to experience mysql errors. The duration of these errors is what troubles me...

[msxsecurity.com]

...

[msxsecurity.com]

alphadesk --> http://msxsecurity.com/proof.jpg

[ergo_etc]

don't worry max, there is a problem, you're not alone... i don't understand why alphadesk want any proof, this is cush a common problem over the last few days...

Having said that, i haven't experience any problem over the last few hours. But it still is slow... my home page occasionally load really slowly > a minute! sometimes it is fast,

[xspeed]

well lets just hope they fix it soon

[White Bear]

ergo_etc,

Thanks, for the info.

It really bothers me that the PowWeb Admin. guys do not update us as we go into day 6.

i have 1 site at powweb for over a year. I don't have quatitative data, just a general feedback...

- occasional database downtime every month or 2, but never as persistance as this, things normally go back to normal within hours. Acceptable i''d say... but then again on all my previous site, i had some caching mechanism that will handle database downtime for a few hours.

- some email downtime. Once in 2 or 3 months our email are inaccesible for a few hours. If you are heavy on email, it could get pretty serious. There are times when i am thinking of getting dedicated email server.

-ftp can get really slow with connection error on busy day.

Other than that, it's pretty good.

[roleli]

problems not as bad but scripts now intermittenly run extremely slow

[WATRD]

Do we have ANY official update on what progress is being made? Are there sites pounding the server or is it just plain overloaded? I am still seeing errors perhaps 1/3 to 1/2 of the time I attempt to access my forum.

[White Bear]

Can any of the Moderators be of assistance in getting a status update on the sql09 problems ?? Maybe, they have better communication links to the PowWeb Admin staff.

Right now, it's a "Black Hole". All input, no output back to us.

[WATRD]

Well, on the upside, this has given me four days to fine tune the debug messages that PHP throws when it can't reach the database.

Now instead of that verbose path revealing error, it has been showing this to my users for the last two days;

phpBB : Critical Error

Could not connect to the database

Sorry, that is the best I can do for a bright side. I have only been here since December and among load-balancing problems, DDoS attacks and MySQL downtime it's been rare that my site was fully functional for more than a few days in a row.

[ergo_etc]

I have decided to stop praying and jump into other 'religion', for those who stays, good luck guys...

[ergo_etc]

To be honest, i used to be pretty impressed with powweb. Everything works, but when i start seeing that "Limited time offer" that never ends on powweb frontpage, with those automated countdown, i started to feel uneasy.

I mean, honestly, would you trust a website that claims that they have "Limited Time offer" when in truth, those are just some automated script that keep repeating over and over to con people.?

Don't take me wrong, i am not bitter, i am just trying to give a constructive criticism. Powweb has an extremely good package, and if they monitor their service very very closely, avoid the server from being overcrowded, no one will have any reason to leave.

btw, i still have 2 site under powweb, i just took my latest one somewhere else. so, i do have the right to say a few words here.

[White Bear]

No response from the Moderators or any of the PowWeb staff, so I called their support phone number and talked with Peter. Nice guy, would like to help, but does not have any idea when the problem will be fixed. No information or status was available, just that "Yes" PowWeb does have a problem. That's not much for having "worked the problem" for 6 days.

Nick's announcement early yesterday morning said, "We will keep you posted on it's status and thank you for your patience.". 32 hours later, we still have not received an update from anyone at PowWeb.

After 6 days, I have to wonder if we will be here next week, talking about the same problem.

Can any of the Moderators be of assistance in getting a status update on the sql09 problems ?? Maybe, they have better communication links to the PowWeb Admin staff.

Right now, it's a "Black Hole". All input, no output back to us.

[tsaraber]

I'm also having the problems with mysql09... I've been getting quite a few of the "0 DB_ERROR_NOT_CONNECTED" errors and the site is so slow it's not funny. But that's nothing new. I've had nothing but database problems and slowness issues ever since I signed up with PowWeb last November.

I personally can't wait until my year is up so I can move my site elsewhere. I had contacted PowWeb before regarding all my problems and they assured me that they had solved the problems and offered me three free months to stay with them. I'm sorry I accepted that offer.

I have two sites with another host and with them I have never experienced anything close to the problems I've had with PowWeb.

[msxsecurity.com]

I just edited my forums, Optimizing it every which way possible for faster speeds..
No more skin selection, no logging at all, no cacheing, Removed a ton of things from invision, and still, its slow as hell. I know now for a fact that its not my site, seeing as I disabled ALL features except for the required ones, and took the board offline so ONLY I could see the board, and it was still slow as ****

[ablaye]

Funny how they disable my site since Thursday blaming me for slowing down MySQL09 and yet the problem persists.
This is so messed up. My site has been down for 6 days now. I lost so much money. They basically drove me out of business. I never believed a second that my site was responsible for this. But, if they want to keep my site disabled, that's fine with me. I don't really care anymore as I am currently pulling all my sites out this mess.

[emaredee]

I'd like to dog pile on this thread. My site's been almost unusable for nearly a week now. I realize I'm only paying $7.77 a month, but this is getting absurd.

[thefordmccord]

I am getting really tired of this. My site has been screwing up for a week now...

[msxsecurity.com]

OO!! A new error message! sweet!


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 code:
Date: Tuesday 12th of April 2005 06:26:18 PM

[iancull]

Oh fabulous - I just got that exciting brand new error message too ... no more comments on my weblog, no more access to my weblog - and to think I only switched from 1and1 to PowWeb to get better reliability :(

[RTH10260]

and to think I only switched from 1and1 to PowWeb to get better reliability :(Interesting observation, Powweb suggests 1and1 as sevice to hosts that outrun the limits of a Powweb hosting ...

[White Bear]

Still, no update from the PowWeb staff ?? Come on guys, if you were a customer is this how you would like to be treated ?? 7 days into this and no one can give us a update ??

I noticed, that my last no connection error was at 8:25 pm West Coast time, last night. That's the good news. The bad news is the sql09 server response is still very very slow. 30 sec. or longer, sometimes it just times out on my vBulletin site.

Maybe, the PowWeb solution is to stress enough users into leaving, so as to reduce the load. I have to wonder if the sales side of the house is still putting new users on-line.

[WolfWonderess]

I keep getting this error, and users have reported that it has been happening for about a week now, and with an increasing frequency that I am noticing, as well.

Warning: mysql_connect(): 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 in /www/e/earthspirits/htdocs/forum/db/mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /www/e/earthspirits/htdocs/forum/db/mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /www/e/earthspirits/htdocs/forum/db/mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database

My forum, because of this, is also really slow, and this is really becoming troublesome...

http://www.spiritsoftheearth.net/forum

[ticoroman]

I'm also running a forum on mysql09 and it's terribly slow. My main website runs on mysql01 and it's very fast, without any problems even under peak times.

I hope the speed will be soon back to normal. That would save me some time, otherwise I'm have to move to the forum to mysql01... which is a waste of time...

[White Bear]

Still, no update from the PowWeb staff ?? Come on guys, if you were a customer is this how you would like to be treated ?? 7 days into this and no one can give us a update ??

I noticed, that my last no connection error was at 8:25 pm West Coast time, last night. That's the good news. The bad news is the sql09 server response is still very very slow. 30 sec. or longer, sometimes it just times out on my vBulletin site.

Maybe, the PowWeb solution is to stress enough users into leaving, so as to reduce the load. I have to wonder if the sales side of the house is still putting new users on-line.

I was wrong this morning, thought it might be getting better. Shortly after I posted this message it started having more problems. Failure to connect and being very slow. I like to know how they generate the 99.9% uptime spec.

Will we ever hear from PowWeb staff on this ?? I guess, once they have your money, that's the end of their customer service.

[ergo_etc]

Maybe, the PowWeb solution is to stress enough users into leaving, so as to reduce the load. I have to wonder if the sales side of the house is still putting new users on-line.

Hey, u know what? this is a pretty good tactic! Those fussy customers (like me!) with heavy traffic site will go somewhere else and those who are loyal will then have a better uptime. :D .

ps: pm me if you want to know what my new hosting are.

[WATRD]

Interesting... check out this thread; http://forum.powweb.com/showthread.php?p=291710

It appears the Powweb "Tech Support Manager" is not aware of the MySQL problems we are having. That might explain why we have seen no announcements or progress.

[iancull]

There is an announcement (http://forum.powweb.com/showthread.php?t=49780); it's just that there is no update or improvement ...

[ticoroman]

mysql09 is definitely broken. I'm moving my forum elsewehere... :(

[WATRD]

I am beginning to agree. It's yet another day and MySQL09 still has problems.

Not a word from anyone official here.
My trouble tickets keep getting deleted without comment.
The "Tech Support Manager" seems to know nothing about any problems.

I am sensing that Powweb's "official" reaction to this situation is to ignore it.

[tbonekkt]

Folks - our admins are still monitoring mysql09 to determine the exact problem. There have been an excessive amount of abusers that have been difficult to pinpoint. All PowWeb staff knows that there are problems with mysql09 and that our admins are working as hard as they possibly can to resolve all issues once and for all.

[Jeeper]

So I am on the phone with tech support right now. They told me yesterday that they had a good grasp on the issue and it would be fixed by COB of 4/14/05. I just have 2 sites with this hosting company and I am completely frustrated. Been with them less then a month.......
I am getting the answer "They are still monitoring the servers" This is BS
I am asking to speak to someone else...
Guess we will see where that gets me. (probably no where)
transfered to :
Tech - Day Supervisor Casey - issue - myswl09 issues have been sever down then came back then had a new connection issue. They fixed the connection issue and are now having a lag issue.
Casey is talking with the system admin right now and they are working on the lag issue. Supposedly the server admin is monitoring the situation and they feel they have the issue resolved. Yet they do acknowledge some are still seeing latency issues

(fyi) I started this post at roughly 9:50am before the post above was written

[White Bear]

Folks - our admins are still monitoring mysql09 to determine the exact problem. There have been an excessive amount of abusers that have been difficult to pinpoint. All PowWeb staff knows that there are problems with mysql09 and that our admins are working as hard as they possibly can to resolve all issues once and for all.
Tom,

I have to thank you for at least posting something. That's more than anyone else at PowWeb has done, except for the one note on early Monday morning.

I would think after a 8 day system problem, impacting many users, that PowWeb management would be here. If all the technical guys are busy, what are they doing ??

The real issue to me long term, is why does it take PowWeb Staff over a week to fix this problem ?? It's a weak statement that after over a week, the problem is PowWeb users, using too many resources. My theory is still, that the the system resources have been over-sold. Are new users still being added to mySQL09 ??

How about adding another server and taking some of the load off mySQL09 ??

[tbonekkt]

How about adding another server and taking some of the load off mySQL09 ??mysql10 is being prepared for production use. ;)

[White Bear]

mysql10 is being prepared for production use. ;)
Tom,

This is the best news, I've seen in the last 8 days. :)
Do you know when it will be in service ??

Thanks, for posting !!

[jang]

Well it's been a week since I started noticing the too many connection errors on my photoblog. The last couple of days I haven't been seeing the errors but it's still running VERY slow. And judging from the other posts on the MySQL board, the problem seems to be spreading to other MySQL servers! What's up with that?? I'm hoping there will be an improvement for all of us very soon! :(

[WATRD]

I thought it was getting better too... but this morning it's back to throwing "too many connections" errors :(

[White Bear]

I notice this morning that mySQL09 has an increased error rate and even poorer performance. How long can it take to install a new SQL server ?? I'm worried now that one more SQL box will not cover the existing load.

"When its Rock Solid it's PowWeb" ???

I guess, as long as new customers keep buying the PowWeb service, no need to worry about the old ones. :( It's an easy way to make the most profit in the least amount of time.

[White Bear]

PowWeb Management,

We are now into Day 9 of a major problem with overloading on mySQL09 and other mySQL servers. No one in your customer service area knows when this problem will be fixed and no updates are being posted here. I have two requests:

1. When can we expect mySQL09 to return to normal ??

2. Can someone at PowWeb be assigned the task of posting a status update in your Forum area, at least once a day ?? This will reduce your service request and call volume.

An unhappy customer,

White Bear

[hershel@belkind]

Warning: This post may be a bit lengthy and a bit blunt...

There are some major performance problems with the sql09 server (possibly with others as well, but not with all servers.) I've been seeing this problem since last Friday (today is one week folks!) I also see a lot of chatter on these forums regarding this problem, and even quite a bit implying that this is somehow a user site problem...

I was in I.T. for 30 years, a VP in Information Technology and managed a team of UNIX admins supporting hundreds of servers. THE PROBLEMS HERE ARE POWWEB PROBLEMS. Having said that, I should also say that I have a number of sites hosted at PowWeb and have been generally happy over the past several years. Problems that cropped up were usually dealt with quickly. Some of my sites (even those using SQL) are still performing properly -- on servers other than sql09.

As a former manager, I know that UNIX problems do happen. But I also know that allowing them to continue for a WEEK without even providing a status update (last post was 4/11, and gave no details) is unacceptable. I have been in touch with tech support several times, but they have no more detail and cannot put me in touch with more senior staff. I AM PRIMARILY ADDRESSING THIS TO POWWEB:

You need to resolve these persistent suport issues if you are to grow the company. Many customers will choose to host elsewhere if you cannot resolve problems and outages quickly. For the most part computers don't just "act up" -- something has changed... either you've overloaded the server (in which case you should immediatly move some hosted databases to another server while you think about how to fix or upgrade sql09), or you made a change (like a software patch --- in which case, ROLL IT BACK, it's bad!), or you have a hardware failure (unlikely or you'd have found it by now).

The recurrence of "SQL too many connections" messages tells me that you have a SQL process software problem. Connections are per account. I've gotten this error when I'm the only user on a non-released site -- no way "1" is too many connections!

Don't blame the network or ISPs (this is not a connectivity error.) Don't blame the users (users are not causing the problem with their own sites.)

My guess is a software problem with MYSQL -- If you've recently modified or patched it or have recently added more sites to sql09. If not, then this is most likely an OS bug, probably introduced via a recent OS patch. (My experience over many years is that many OS patches are buggy when released. If you see new problems shortly after applying patches, roll them off and do more testing!)

The short message here is: FIX THE PERFORMANCE PROBLEMS, NO MATTER WHAT IT TAKES... if you have to move everything off sql09 to a new server, then do that. You need to start treating this as a PRODUCTION environment. I've seen seveal serious performance/outage problems over the past 2 months -- and many were not resolved nearly quickly enough. None were adequately explained. If you need to hire some more experienced UNIX admins, then do so. Or bring in a consultant. You need to restore good service first, and only then work on long-term solutions.

You also need to be much more forthcoming with information. ALL OUTAGES SHOULD (a) BE UPDATED IN THE FORUM AT LEAST ONCE A DAY WITH PROGRESS REPORTS AND SOME LEVEL OF TECHNICAL INFORMATION, and (b) BE FULLY EXPLAINED AFTER-THE-FACT -- i.e. tell us exactly what happened (even if someone goofed, admit it!) and tell us what measures you've taken to avoid recurrence. DO **NOT** just say "issue has been resolved" (and then have the same thing happen 2 weeks later.)

Case in point: Recent network connectivity issue that blocked access to MANY Powweb sites was reported as a DOS attack... while this may be the initial cause, the truth is that the *extended* outage was due to incorrect addresses being manually entered into a routing table (not by Powweb staff). It took more than 24 hours to fix this! By admitting this problem and telling us how you are going to monitor for such a problem in the future so that if such an error is made you'd be able to detect it and have it fixed within an hour, you would build a strong level of confidence among your customers.

Sorry for the long "attack". I don't want to switch hosting providers -- I want PowWeb to step up to the plate and address the growing technical issues. Thanks!

[mjp]

Is 09 still creating ongoing problems for any of you? We've made a lot of adjustments to smooth things out (see http://forum.powweb.com/showthread.php?t=49780), so most of the connection errors should be cleared up...

[lucho]

I also have problem with the server mysql09.powweb.com

My web page is: foro.arroyocyber.com.ar

[White Bear]

Is 09 still creating ongoing problems for any of you? We've made a lot of adjustments to smooth things out (see http://forum.powweb.com/showthread.php?t=49780), so most of the connection errors should be cleared up...

I've had 6 "unable to connect" or "loss of connection" errors on a vBulletin forum with 4 or 5 users, after you posted your message.

In general my forum seems to be running fine, at times. But, at random will slow to a crawl then sometimes get a fatal connection error.

BTW, Thanks for posting a message. It really helps us to know more about what's going on.

[johnwa]

Yes, I'm also seeing a lot of mysql errors. I'm now getting errors on inserts and deletes that I have never seen before. I've taken the precaution of shuting down my BB. I'm now concerned about the potential for d/b corruption issues.

[lesliedgordon]

I too am experiencing SQL insert and delete errors when attempting to post to my board. Please let us know what is going on and when we can expect it to be fixed.

Thank you,

Leslie

[WATRD]

Mine seems to be working at the moment, but it is still going through periods where it is slower than (insert homey expression for something that's really slow here). At least I am not seeing the outright failures, so that is an improvement.

[White Bear]

I've had 6 "unable to connect" or "loss of connection" errors on a vBulletin forum with 4 or 5 users, after you posted your message.

In general my forum seems to be running fine, at times. But, at random will slow to a crawl then sometimes get a fatal connection error.

BTW, Thanks for posting a message. It really helps us to know more about what's going on.
I've had 8 connection errors from my last post about 2 hours ago, with about 4 users average on a vBulletin forum.

As noted by WATRD, response is very very slow at times.

[msxsecurity.com]

My site is still extremely slow and/or timing out for me.

[msxsecurity.com]

OK, now something weird is happening, It keeps throwing me completely random errors, and then they dissapear. Heres one now:

mySQL query error: DELETE FROM ibf_cache_store WHERE cs_key='systemvars'
mySQL error: Lost connection to MySQL server during query
mySQL error code:
Date: Friday 15th of April 2005 04:30:01 PM

OO! heres another one!


mySQL error: Can't connect to MySQL server on 'mysql09.powweb.com' (60)
mySQL error code:
Date: Friday 15th of April 2005 04:35:22 PM

[mx_race]

77 emails in 5 minutes.. www.savageracer.com

the site doesn't have that many users.. only 800

Whoops while I was typing I had 15 more emails.. Unable to connect.. Great service.. My site has only been like this for ohhhh 7 days now.. :confused:

[White Bear]

Not sure what's going on. The mySQL09 server is unavailable, no connections possible. :mad:

Same for everyone ??

[xuezhongwen]

Mine too was down, now I seem to think they are putting too many sites on one server, there were too many downtimes in the past 2 months!

[ergo_etc]

hahaha what a joke... now my 2 remaining site with powweb is dead! cannot connect to mysql05 at all! mysql09 is completely dead right now? or maybe the whole powweb database server is dead?

I though my 2 site would be ok on mysql05, now i have to move it all somewhere else... And btw, start downloading your database backups everyone!!!

[jamyam]

Yeah, can't reach my site either. www.csuforums.com

[emuzone]

Hello,

It's my first post here after two or three months with my page at powweb.

I have problems with 09 since a few days ago, and tonight is impossible for me to enter my forums, at http://computeremuzone.com/forum

----------
Warning: mysql_connect(): Can't connect to MySQL server on 'mysql09.powweb.com' (60) in /www/c/computeremuz/htdocs/forum/db/mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /www/c/computeremuz/htdocs/forum/db/mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /www/c/computeremuz/htdocs/forum/db/mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database
------------

[rpgsales]

Lore System Error

Unable to connect to the MySQL database at mysql09.powweb.com. Please ensure that a MySQL database server is running, and check your login credentials in the configuration file.

Can't connect to MySQL server on 'mysql09.powweb.com' (60)

how long will be fixed????

[WATRD]

I guess I spoke too soon in my earlier post. MySQL09 now seems to be completely non-functional. So much for the improvement I spoke of...

[alphadesk]

All mysql servers should be coming back up now or shortly ... if yours is still down please get with support or post in a new thread with domain name.

[msxsecurity.com]

Looking good for now!
GJ powweb!

[ergo_etc]

ok, both mysql05 and 09 are running! and it looks good too! fast and working pretty good. Hope it stays that way. Perhaps it was a scheduled downtime with no announcement?. We'll see how it goes witin the next few days.

[WATRD]

Agreed... good at the moment...

[mx_race]

Mine was great.. Now getting a error while trying to send pm's in the forums..

weird.. I'll have to do some troubleshooting to see if it's on my end.. I sent 4 pm's on the site in less that a minute or 2 now I have a error.. Hmmmmm Speed is back up though

[mx_race]

Database error in vBulletin 3.0.6:

Invalid SQL:
REPLACE INTO vb3_postindex
(wordid, postid, score, intitle)
VALUES
(3, 25200, 1, 0)

mysql error: Can't open file: 'vb3_postindex.MYI' (errno: 145)

mysql error number: 1016

Date: Friday 15th of April 2005 06:13:39 PM
Script: http://savageracer.com/forum/newreply.php
Referer: http://savageracer.com/forum/showthread.php?t=2622

That's the error I'm getting now.. can't post.. Can't PM.. Ughhh..

[alphadesk]

Mine was great.. Now getting a error while trying to send pm's in the forums..

weird.. I'll have to do some troubleshooting to see if it's on my end.. I sent 4 pm's on the site in less that a minute or 2 now I have a error.. Hmmmmm Speed is back up thoughAre you getting something like this error?

Warning: fsockopen(): php_network_getaddresses: getaddrinfo failed: No address associated with hostname in /www/u/username/forum/htdocs/includes/smtp.php on line 109

[mx_race]

I fixed it.. I just ran the repair and optimize tables from the forums software.. Everything is good for now.. Glad to see some speed in my site again.. Thanks PW.. I honestly was trasfer sites come monday if it wasn't resolved .. But looks like all is good *Cross Fingers*

[iancull]

All mysql servers should be coming back up now or shortly ... if yours is still down please get with support or post in a new thread with domain name.
So after a week or more are you saying you have *found* and *fixed* a problem?

Exactly now, my extremely undemanding site (http://www.gbmini.net/mtblog) is running & accessing the MySQL fine. But during today it was sick, slow, and rubbish.
Have you done a quick reboot to make the problem go away for a few hours, or is there a real fix that has solved the problem?

[iancull]

... I honestly was trasfer sites come monday if it wasn't resolved .. But looks like all is good *Cross Fingers*

I already am half way through transferring to another hosting company (again, only joined PowWeb two months ago) :(
Now I don't know whether to trust PowWeb and stay, or leave them anyway. Since I arrived all it has been is trouble, with load balancing, sessions, MySQL etc ...

[Phiya]

The admins have found a permanent fix for it. More information can be found at http://forum.powweb.com/showthread.php?t=49780

Again, We apologize for the inconvenience.

[WATRD]

Whatever change was made, broke posting on my PHPBB forum.

When you try to post, you now get this...

Could not insert new word

DEBUG MODE

INSERT IGNORE INTO phpbb_search_wordlist (word_text, word_common) VALUES ('dump', 0), ('front', 0), ('love', 0), ('own', 0), ('plate', 0)

Line : 234
File : /www/w/path/path/path/path/functions_search.php

[WATRD]

The admins have found a permanent fix for it. More information can be found at http://forum.powweb.com/showthread.php?t=49780

Again, We apologize for the inconvenience.

The last post in that thread was from eight hours ago and many of us have posted problems since then...

[auction247]

few hours ago , it's very fast ( still slow down few seconds - cycle )
But now it back to normal

[WATRD]

I found a corrupted table in my forum DB and repaired it. For the moment, all is well and the forum is SCREAMING along and seems to be error free.

Hopefully that will last.

[White Bear]

Worked OK for awhile, great speed, then my forum files were corrupted for the second time.

At least they are working on the problem, (I hope).

[goudy]

Same thing with me. Very disappointed with PowWeb. Nothing's working.

[phoginator]

Defintely not fixed - I'm on server02 and still getting complete db crahes every time I add anything new to my database (yes this is after doing a repair to temporarily fix it):

DB Error: Bad SQL Query: SELECT cat_id, COUNT(image_id) AS new_images FROM 4images_images WHERE image_active = 1 AND image_date >= 1113379695 GROUP BY cat_id
Incorrect key file for table '4images_images'; try to repair it


Tracking Code: 407239510001c3f6

[xpanshun]

My site was finally getting back up and running fast and 'normal' (as in normal for how the
site was on my OLD server, since I have only been on PW for a couple weeks and have seen
nothing but trouble, I cannot say what 'normal' is here!) ... until my phpBB forum had trouble
loading a few pages (something I suspect from my experiences so far has more to do with
PW than my site!) and THEY DISABLED ME WITHOUT SO MUCH AS AN EMAIL!

I had to be informed of the problem through my (increasingly unhappy and dwindling)
membership! :(

I've contacted customer support and have told them I'm more than willing to work
on optimizing my site--but seriously--IS IT WORTH IT?! I had done my studying
and PW seemed like the perfect solution for a site that has to rely on member
donations to purchase hosting--but if the site is never up and running, what good
is hosting?

Also--how can I fix my site to reduce the number of queries etc without having access
to the site b/c my database is disabled?!

Very frustrated... :-/
-XP

[White Bear]

I don't know if it's a poor technical staff, bad management or just the lack of hardware to cover the loads. But, I'm busy installing a test site at another web host. I don't have much faith that PW will solve it's problems in the next week and I have to take care of my users.

This is taking way too much of my time, following up on and correcting PW induced problems.

Note to PW staff, I'm still getting failure to connect message at midnight tonight.

[njnightsky]

Still having errors today

[alphadesk]

Still having errors todayDid you repair your tables?

Login with https://phpmyadmin.powweb.com/

Then click on the DB name upper left ...

Then on the right below all the rows of tables click Select All ...

Then with the dropdown box select Repair Table ...

[ticoroman]

Did you repair your tables?

Login with https://phpmyadmin.powweb.com/

Then click on the DB name upper left ...

Then on the right below all the rows of tables click Select All ...

Then with the dropdown box select Repair Table ...
Unfortunately the tables just craches soon after, and it's not only on mysql09 anymore... Other servers are affected too...

[alphadesk]

Unfortunately the tables just craches soon after, and it's not only on mysql09 anymore... Other servers are affected too...What is your domain name ... I havn't experienced any problems after repairing tables and many others that have repaired their tables havn't had any more problems.

[ticoroman]

What is your domain name ... I havn't experienced any problems after repairing tables and many others that have repaired their tables havn't had any more problems.The error I'm talking about is the one described in http://forum.powweb.com/showthread.php?t=49969

My domain name shouldn't help, as no error message is showed there (hidden by PHP). I think it's a different error, that occured after PWs tried to fix the problem (in the beginning of this thread) and optimize the servers, but instead broke something else... I hope it will not take another week to fix this one...

[WATRD]

I repaired a table last evening, but sometime during the night, it became corrupted again. When my backup script ran last night, it failed for the first time in months and threw the following error;

/usr/local/bin/mysqldump: Got error: 1016: Can't open file: 'phpbb_search_wordlist.MYI' (errno: 144) when using LOCK TABLES
Database wattoraforum has been backed up to /www/w/path/path/wattoraforum0504160320.sql. The file is 620 Bytes.Content-type: text/html

After repairing the table again this morning and running the back up script again; it succeeded with the following message;

Database wattoraforum has been backed up to /www/w/path/path/wattoraforum0504160729.sql. The file is 4543245 Bytes.

Something is still not right...

MySQL09 and the domain is wattora.com

[RTH10260]

More information can be found at http://forum.powweb.com/showthread.php?t=49780

and quote from that message: A few problem users were also disabled, and "delayed inserts" were disabled.Please give some more information:
Were these 'problem users' using the 'delayed insert' or are there now suddenly new undocumented restrictions on the usage of MySql databases ?

[cyberCrank]

if being caused by new Powweb MySQL restrictions or configuration changes without testing, then gee wizzers golly; surely not, tell us it ain't so mama ...

[stevel]

sql03 seems to be offline at this time. Even PowWeb's phpmyadmin can't connect to it.

[msxsecurity.com]

omg.. Apparently all of the problems in this thread are back.. Lovely.