The new mysql09 thread (april 15th+)

[msxsecurity.com]

It seems the max connections error and slowness has been fixed, however many people are now getting errors with tables being corrupted.
So, if you have a error like (mySQL error: Can't open file: 'xxx_inserttablehere' (errno: 145) Post your URL and the specifics of your issue.

Repairing the tables with phpmyadmin is a VERY temporary fix ( somtimes only lasting 10 seconds before corruption )

For those who want to try and repair there tables (despite the fact it wont help) do the following:
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

To the community:
POST YOUR URL, FORUM SOFTWARE AND ERROR MSG. This will be very helpfull to the mods for correcting the problem

To the mods:
DO NOT SUGGEST THIS PROBLEM IS BASED ON OUR FORUM SOFTWARE - IT IS A GLOBAL ISSUE FOR PEOPLE ON MYSQL09 -
PLEASE DO NOT MERGE THIS THREAD - THIS IS DISCUSSING NEW ISSUES WITH MYSQL09 THAT HAVE ARISEN FROM APRIL 15TH AND PAST

[AzNxRaVeR]

I have this sort of problem too. I have a forum and the error I get is:
mySQL error: Can't open file: 'ibf_posts.MYI' (errno: 145)
I did "Repair Table ibf_posts" and the problem got fixed. However, when I post again in my forums, the error pops up again.

My forums is http://aznx.icyhell.net and the software is Invision Power Board

[phoginator]

Yea I'm getting the 145 error as well for about the last 5-6 hours- but on mysql02. Can repair the table, but any additions to the table cause another complete db failure.

Sent a ticket in- hope is resolved soon.

[WATRD]

Add me to the list. I am seeing the same symptoms as everyone else. It's making a shambles of my forum on MySQL09 :(

EDIT:

URL: http://www.wattora.com/forum/
Software: PHPBB Current version
Error: Could not insert new word

DEBUG MODE

INSERT IGNORE INTO phpbb_search_wordlist (word_text, word_common) VALUES ('test', 0)

Line : 234
File : /www/w/wattoracom/htdocs/forum/includes/functions_search.php


How are you repairing the table via MyPHPAdmin? I would like to give it a shot.

[WATRD]

How are you repairing the table via MyPHPAdmin? I would like to give it a shot.

Nevermind :) I figured it out...

[msxsecurity.com]

Lets all merge all posts into here.. Too many "cant open xxxxx.myi" posts

[transgenik]

I'm on mysql04 but this looks like being related. Here is the error I get on my forum, located at www.banlieusardises.com/voisins/ (but you have to add index2.php because I've placed a message for my users on the root of the forum):

phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1016 Can't open file: 'forum_sessions.MYI' (errno: 145)

INSERT INTO forum_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in) VALUES ('1e2b05950d027670277b440fad2f42cb', 2, 1113675979, 1113675979, '18cb4980', 0, 1)

Line : 158
File : sessions.php

Also, I can't even get to the MYSQL tab on PowWeb's OPS. Here's what I get:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@ops.powweb.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

[blw911]

THIS IS A TOTALY JOKE POWWEB, UNACCEPTABLE. WHAT A JOKE!! :mad: :mad:

Same problem for me, only it's my Oscommerce store getting the Erno 145 error

[Ifrit]

add me

error 1016 cant find file.myi etc etc

ffxposed.net at mysql5 running (trying too ....) phpbb2.0.13

[lucho]

my forum doesn't work very well and when I want to upgrade it.... doesn't work Importing vbulletin-language.xml
does somebody know that happens?
my base is in mysql09.powweb.com

[lucho]

I also have this error

Database error in vBulletin 3.0.7:

Invalid SQL: INSERT INTO adminhelp
(script, action, optionname, displayorder, volatile)
VALUES
('forumpermission', '', '', 1, 1),
('forumpermission', 'duplicate', '', 1, 1),
('forumpermission', 'duplicate', 'ugid_from', 10, 1),
('forumpermission', 'duplicate', 'usergrouplist', 20, 1),
('forumpermission', 'duplicate', 'limitforumid', 30, 1),
('forumpermission', 'duplicate', 'overwritedupes_group', 40, 1),
('forumpermission', 'duplicate', 'overwriteinherited_group', 50, 1),
('forumpermission', 'duplicate', 'forumid_from', 60, 1),
('forumpermission', 'duplicate', 'forumlist', 70, 1),
('forumpermission', 'duplicate', 'overwritedupes_forum', 80, 1),
('forumpermission', 'duplicate', 'overwriteinherited_forum', 90, 1),
('forumpermission', 'edit', '', 1, 1),
('forumpermission', 'edit', 'mode', 20, 1),
('forumpermission', 'edit,quickforum', 'canview', 30, 1),
('forumpermission', 'edit,quickforum', 'canviewothers', 40, 1),
('forumpermission', 'edit,quickforum', 'canseedelnotice', 45, 1),
('forumpermission', 'edit,quickforum', 'cansearch', 50, 1),
('forumpermission', 'edit,quickforum', 'canemail', 60, 1),
('forumpermission', 'edit,quickforum', 'cangetattachment', 70, 1),
('forumpermission', 'edit,quickforum', 'canpostnew', 80, 1),
('forumpermission', 'edit,quickforum', 'canreplyown', 90, 1),
('forumpermission', 'edit,quickforum', 'canreplyothers', 100, 1),
('forumpermission', 'edit,quickforum', 'isalwaysmoderated', 110, 1),
('forumpermission', 'edit,quickforum', 'canpostattachment', 120, 1),
('forumpermission', 'edit,quickforum', 'canthreadrate', 140, 1),
('forumpermission', 'edit,quickforum', 'caneditpost', 150, 1),
('forumpermission', 'edit,quickforum', 'candeletepost', 160, 1),
('forumpermission', 'edit,quickforum', 'canmove', 170, 1),
('forumpermission', 'edit,quickforum', 'canopenclose', 180, 1),
('forumpermission', 'edit,quickforum', 'candeletethread', 190, 1),
('forumpermission', 'edit,quickforum', 'canpostpoll', 200, 1),
('forumpermission', 'edit,quickforum', 'canvote', 220, 1),
('forumpermission', 'modify', '', 1, 1),
('forumpermission', 'quickedit', '', 1, 1),
('forumpermission', 'quickeditor', '', 1, 1),
('forumpermission', 'quickforum', '', 1, 1),
('forumpermission', 'quickforum', 'forumid', 10, 1),
('forumpermission', 'quickforum', 'usergrouplist', 20, 1)
mysql error: Duplicate entry '3572' for key 1

mysql error number: 1062

[LisaJ]

postindex Check Warning: Table is marked as crashed
postindex Check Error: Key in wrong position at page 46080
postindex Check Error: Corrupt
postindex
word Check Warning: Table is marked as crashed
word Check Error: Found key at page 25600 that points to record outside datafile
word Check Error: Corrupt

http://www.digitalsignageforum.com

running vbulletin 3.0.7

[LordKaT]

Well add me to the blasted list.

mysql02
SQL Error : 1016 Can't open file: 'phpbb_search_wordlist.MYI' (errno: 145)

[PlasticNavy]

http://www.plasticnavy.com/forum

running PHPBB 2.0.11


phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1016 Can't open file: 'phpbb_sessions.MYI' (errno: 145)

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in) VALUES ('1f271055f437a35d6724a02776f628e4', 3, 1113681347, 1113681347, '1898b5ef', 0, 1)

Line : 158
File : /www/p/pnadmin/htdocs/forum/includes/sessions.php

[WATRD]

What's interesting about this particular problem is that after doing a repair on one table of my forum database, it works fine for a while, then another table becomes corrupted. That coupled with the fact that everything worked just fine before the techs "fixed" the problem and it's not just PHPBB that's effected leads me to believe that the current problems are something that Powweb has done to the MySQL servers.

The question is, is anyone actually looking into this? We had to wait it out last weekend with no progress, then it took all week to "fix" that problem and create the current problems.

[HappyDays]

Its not just mysql09, I see threads of mysql01 and mysql05

not to mention my friends and I have sites using mysql04, but I think its about time the mods make a post saying anyone getting error 145 just to pipe-down and read the tons of other topics containing the same question with the same answers.

[aggielaughs]

I am having the same exact problems as everyone else.

I am using Invision Power board 1.3x with a lot of mods and a portal wrapped around it using MySql 01 server.

Fix one table in phpMyAdmin and it, or another table corrupts when someone posts/reads a thread or reply.

I have checked, and IPB says it's not a problem with their software. Obviously if we are all having the same problem it's not software dependent.

Be patient, it's not easy administrating a hosting service like Powweb. Especially when they give us such flexibility and options.

But it does suck in the meantime.


---------


If you want to try and repair the tables yourself, although it will only help for a little while and doing it over and over the way some of us have, do the following:

> Log into OPS and click on your "package name"
> Click "mySQL" for that particular database, if you have more than one.
> Under "Database Connectivity" on the right you will see a link to phpmyadmin, that will take you to the phpmyadmin page for that MySQL server. You will need your database name, and password to enter.
> Click on your database name on the top left frame, this will open the database on the right frame. Check the box next to the table you need to repair. On the bottom of your table names you will see a drop down box that says "With Selected", open that and choose "Repair table". That will fix the problem TEMPORARILY.

It will drive you nuts doing that over and over and over the way I have, so I suggest you let your customers/viewers know you are working on the problem instead of staying in phpMyAdmin all day repairing tables over and over again.

[LisaJ]

It will drive you nuts doing that over and over and over the way I have, so I suggest you let your customers/viewers know you are working on the problem instead of staying in phpMyAdmin all day repairing tables over and over again.

This won't do any good for me, cause I can't even get into mine now, and can only assume my members are viewing the same message:


There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

[stevel]

Yes, I am seeing the problem where a table, shortly after being created, becomes corrupted - now on mysql10.

[LisaJ]

site seems to be running very good now...let's see if it stays that way....

www.digitalsignageforum.com

[msxsecurity.com]

omfg rofl.. Dude the people in powweb chat are BANNING you for singing songs now.
Apparently, you are not allowed to talk about anything except how marvelous powweb is.
They would rather be banning people and talking about having people working on problems then actually fixing them.. Check out this log, get a laugh as I am banned for reciting a line from the new CocaCola commercial..
I honestly can NOT believe they treat customers this way. This guy is especially unbelievable, and apparently 10 other people have requested me banned.. (and all to him also, so I guess thats more like 100 people want me gone considering there is 10 more staff members, and I am sure they have all receivied complaints about me..

(17:45:09) (+msxsecurity) put the lime in the coke you nut
(17:45:15) (@skunkboy) Powweb admins are aware of issues with SQL (as per the link when you entered the room). They have disabled many abusive sites and made mods to the servers but there are still issues that they are trying to track down. Weekend or not, the admins ARE working on it.
(17:45:23) —› mode: (Superman) sets (+o Majestic)
(17:45:26) (+rob24) i keep getting "Undelivered Mail Returned to Sender" even though it the person im sending it to get's the message
(17:45:27) (+Yasha-DT) SQL 03 just came online...
(17:45:30) —› mode: (Majestic) sets (+b *!*@*.no.no.cox.net)
(17:45:30) —› this (*!*@*.no.no.cox.net) ban affects (+msxsecurity)
(17:45:31) —› kick: (msxsecurity) was kicked by (Majestic) (msxsecurity)
(17:45:31) —› can't join #general (you're banned (+b))
(17:45:31) —› press (Control+F2) to retry!
(17:45:42) —› •majestic• why was I banned
(17:45:51) —› •majestic• All I said was a line from a ad on tv
(17:46:07) —› •majestic• Seriouslly, take out the agression somewhere else. I am a paying customer
(17:46:12) (Majestic) not appropiate
(17:46:23) (Majestic) for a tech channel
(17:46:28) (msxsecurity) A song isnt appropriate?
(17:46:39) (msxsecurity) CocaCola deems it appropriate for 13 yr olds watching nickelodeon, why was I banned for singing a song.. seriouslly..
(17:46:42) (Majestic) that type of thought is not appropiate for a tech channel
(17:47:01) (msxsecurity) Wait, I cant recite a song thats playing on nickelodeon?
(17:47:34) (Majestic) listen, I know who you are and I know your tricks, don't try to act innocent.
(17:47:53) (Majestic) people like you wosen things
(17:47:58) (msxsecurity) wosen?
(17:48:00) (msxsecurity) i dont care what I do
(17:48:03) (Majestic) I had 10 requests so far asking to get rid of you
(17:48:10) (msxsecurity) Thats bull****
(17:48:15) (Majestic) cool
(17:48:22) (Majestic) then don't let the door hit your butt
(17:48:24) (Majestic) bye.

[WolfWonderess]

Could not query forums information

DEBUG MODE

SQL Error : 1016 Can't open file: 'phpbb_posts.MYI' (errno: 145)

SELECT f.*, p.post_time, p.post_username, u.username, u.user_id FROM (( phpbb_forums f LEFT JOIN phpbb_posts p ON p.post_id = f.forum_last_post_id ) LEFT JOIN phpbb_users u ON u.user_id = p.poster_id ) ORDER BY f.cat_id, f.forum_order

Line : 167
File : /www/e/earthspirits/htdocs/forum/index.php

http://www.spiritsoftheearth.net

phpBB

[msxsecurity.com]

still no progress. Go powweb!
Whats funny is this is going to be 2 weeks downtime soon, I wonder how they calculate 99.9% uptime.
It must be how long THERE webpage is up.
I noticed that powweb was able to receive new orders without a problem even during this mess.

[robertcorr]

Yes, exactly -- I can't imagine my site's been up for 99% of the last fortnight -- and when it has been, it's been incredibly slow to load, which is not a MySQL problem.

All the servers seem to be down for maintenance at the moment, so hopefully the problem will be resolved soon. But prompt action might be in order next time something goes wrong.

[ZombieMatt]

Add me to the list on mysql02 man, first errors with tables and repairing them would only last 10mins at most, then corrupt agian.

Now cant connect all together....sigh, 2nd time this has happened to me while with powweb.

[Sawatdee]

Add me to the list ! I'm tired of Powweb :mad:

mySQL query error: SELECT moderator.mid as is_mod, moderator.allow_warn, m.id, m.name, m.mgroup, m.password, m.email, m.restrict_post, m.view_sigs, m.view_avs, m.view_pop, m.view_img, m.auto_track,
m.mod_posts, m.language, m.skin, m.new_msg, m.show_popup, m.msg_total, m.time_offset, m.posts, m.joined, m.last_post,
m.last_visit, m.last_activity, m.dst_in_use, m.view_prefs, m.org_perm_id, m.temp_ban, m.sub_end, g.*
FROM forummembers m
LEFT JOIN forumgroups g ON (g.g_id=m.mgroup)
LEFT JOIN forummoderators moderator ON (moderator.member_id=m.id OR moderator.group_id=m.mgroup )
WHERE m.id=1

mySQL error: Can't connect to MySQL server on 'mysql09.powweb.com' (60)
mySQL error code:
Date: Sunday 17th of April 2005 12:44:03 AM

http://forum.tonyjaa.org/

I'll let you know when there will be another messages erros :mad:

[turbox777]

Just switch servers and tell everybody in your community not to join powweb.

[takashi_maze]

I'm tempted to ask for a refund since I'm not getting what I paid for. Apparantly since they put in that server balance thing we're supposed to get 100% uptime. Now that's all well and good if your site doesn't rely on SQL, but mine is TOTALLY dependent on it. Surely there must be some solution to all these database outages?

[ZombieMatt]

Mysql 02 seems to be back right now, hopefully for good, w/o any errors. Took awhile though, but it is the weekend.

[IanS]

I'm tempted to ask for a refund since I'm not getting what I paid for. Apparantly since they put in that server balance thing we're supposed to get 100% uptime. Now that's all well and good if your site doesn't rely on SQL, but mine is TOTALLY dependent on it. Surely there must be some solution to all these database outages?They've removed the 100% claim and changed it to 99.9% infrastructure up time - as the hardware hasn't failed, just the software installed on it - then they are probably meeting the 99.9% claim.