View Full Version : Please go here and post ... try to crash it!
alphadesk
4-16-05, 02:13 PM
http://forum.alphadesk.net/
This is a pbpBB forum on mysql03 ... which most of you are running that are having problems. Anyone can post without registering.
Lets see if we can crash it :p
phoginator
4-16-05, 02:23 PM
From what I gather of reading the many posts on this- tables built from scratch like this are doing ok. We're really trying to avoid having to gut our existing tables and rebuilding.
ok, I posted, and it looks like it didn't crash - what's the secret?????
Skunkboy
4-16-05, 02:26 PM
doh!
I couldn't crash it. I opened six copies of the link in tabs at one time and none of 'em timed out. I tried to post all six at once but the delay between posts prevented me from doing so - NOT a powweb issue ;)
doh!
I couldn't crash it. I opened six copies of the link in tabs at one time and none of 'em timed out. I tried to post all six at once but the delay between posts prevented me from doing so - NOT a powweb issue ;)Posted as well, but no crash - as predicted ;)
cyberCrank
4-16-05, 02:29 PM
skunk is not fast enough on his keyboard and tabbing ;)
cyberCrank
4-16-05, 02:30 PM
mysql01 was failing too for us...
** me thinks it is indeed a Powweb issue, and checking on it... **
Skunkboy
4-16-05, 02:33 PM
I'm not fast enough.... bah! Alpha just won't let us hit "submit" six times in a matter of seconds.
"You cannot make another post so soon after your last; please try again in a short while."
I'm on mysql06, and had problems all night, and all morning.
alphadesk
4-16-05, 02:36 PM
mysql01 was failing too for us...
** me thinks it is indeed a Powweb issue, and checking on it... **I don't have anything on mysql01 ... but as you can see this phpBB forum on mysql03 has been setup long before and it does not (or hasn't yet) corrupted the tables by simply posting.
There is something else coming into play for the members that have a phpBB forums that continue to corrupt tables ...
Now i have no idea what that would be ...YET!
phoginator
4-16-05, 02:40 PM
You're welcome to crash my db Alpha - PM'ed you info on how to do it at the click of a button or two.
DrewGreen
4-16-05, 02:42 PM
check my post in this thread for a solution:
http://forum.powweb.com/showthread.php?t=50009
(I'm also on mysql01 and having no problems so far since I added the code)
Skunkboy
4-16-05, 02:43 PM
I'm not a phpbb user but considering there were hacks that went around the net around x-mas, is there another one goin' around now?
I don't have anything on mysql01 ... but as you can see this phpBB forum on mysql03 has been setup long before and it does not (or hasn't yet) corrupted the tables by simply posting.
There is something else coming into play for the members that have a phpBB forums that continue to corrupt tables ...
Now i have no idea what that would be ...YET!
this aint just an issue with phpbb, its also happening with vbulletin , as I have been having problems all night and day
My database goes currupt, then I repair it, then it goes currupt again 5 minutes later
cyberCrank
4-16-05, 02:51 PM
I'm not a phpbb user but considering there were hacks that went around the net around x-mas, is there another one goin' around now?
none noted, but there is a new phpBB 2.0.14 update out on www.phpbb.com ...
But this issue is MySQL/Powweb related, not just phpBB it seems as others are having similar forum problems with other packages too...
phoginator
4-16-05, 02:52 PM
Yea- my site is not a forum - and I believe Alpha just crashed it. :)
alphadesk
4-16-05, 02:53 PM
You're welcome to crash my db Alpha - PM'ed you info on how to do it at the click of a button or two.Crash and burn it did :confused: ... but that lady is still a doll :p
When I repaired the tables their was a message about sessions table not being repaired and then the rest of the message was off the page.
Are you running your own sessions?
http://forum.powweb.com/showthread.php?t=30966
canaryfan
4-16-05, 02:54 PM
i UPDATED MY FORUM TO 2.0.14 AND THE PROBLEM STILL PAIN IN THE ***.
I DO NOT THINK THAT IS RELATED TO THE VERSION OF THE PHPBB.
i UPDATED MY FORUM TO 2.0.14 AND THE PROBLEM STILL PAIN IN THE ***.
I DO NOT THINK THAT IS RELATED TO THE VERSION OF THE PHPBB.Another user has reported MySQL problems with Coppermine - so not just PHPBB is affected - their problem seems to be fixed however.
DrewGreen
4-16-05, 02:58 PM
No, it's a problem with the sql database getting corrupted all the time. For what reason is unclear to me. Add that code in the other thread and whilst the problem doesn't go away, it'll fix itself without you having to constantly repair the tables yourself.
While bulletin boards worldwide certainly seem to be affected, this is hardly limited to bulletin boards. My MySQL table on mysql01.powweb.com contains things to do and upcoming events in the local area, and contains about 28,000 rows. As the table is inoperative, my entire 450+ page site is dead.
phoginator
4-16-05, 03:01 PM
Crash and burn it did :confused: ... but that lady is still a doll :p
When I repaired the tables their was a message about sessions table not being repaired and then the rest of the message was off the page.
Are you running your own sessions?
http://forum.powweb.com/showthread.php?t=30966Yes she is. :)
Yea- I noticed that too on the repair. I'm running my own sessions - and nothing has changed in the site config that was working flawlessly till yesterday afternoon when she collapsed. What's weired is if I delete 2 images- I can then add 2 images successfully - but go over 204 and down 'she' goes.
cyberCrank
4-16-05, 03:01 PM
No, it's a problem with the sql database getting corrupted all the time. For what reason is unclear to me. Add that code in the other thread and whilst the problem doesn't go away, it'll fix itself without you having to constantly repair the tables yourself.
ditto that; the tables crash and lose post and/or whole threads (a few) with or without the new simple patch to automate repair; it may repair, but it does NOT "replace" missing posts/threads...
DrewGreen
4-16-05, 03:09 PM
Ah, that's possibly to do with how the scripts are working. My experience is with phpbb and the wordlist table, which is part of the search functions.
Posts are still added, probably because they are done before the problem occurs.
Admittedly only the wordlist is getting corrupted on my site, all other tables are still ok.
I can only suggest making sure there are no direct calls to mysql_query anywhere else in your scripts, and replacing them all with a call to the Query function instead.
Today I geting this permanently. I repaire table and in next minut problem is back
phpBB : Critical Error
Error doing DB query userdata row fetch
DEBUG MODE
SQL Error : 1016 Can't open file: 'phpbb_sessions.MYI' (errno: 145)
SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = 'a90f85e7656e03687de1bd19313ffbc8' AND u.user_id = s.session_user_id
Line : 247
File : sessions.php
so, for the people who dont understand any of whatever youre saying, what are we supposed to do?
is this fixed yet, or am i just forced to change host?
my WHOLE site depends on database, and as such it is 100% broken, so, in all cold truth this is as usefull as throwing money down the toilet
...it seems that the table works only as long as you do not add any rows to it. Of course, this means that bulletin boards would crash quickly.
I finally got in and used the Repair function, and my table seems to be working at present. Since I am the only one who can add rows to the table, I am hoping that it will continue to work long enough for PowWeb to isolate the problem and fix it permanently.
HappyDays
4-16-05, 03:23 PM
I have IPB and it has the same problem with posts, so its not just a script problem, its a Powweb problem, we should not have to change the code to make it work.
These past months have been pritty bad with my ftp, php, and mysql. Its more like a 70% uptime guarantee, not a 99.9%
Whats goin on Powweb? :(
I've been working with some folks using mysql04, and while their existing forums are so far working fine, the new code I started uploading yesterday has gotten all kinds of "Can't open file: 'tablename.MYI' (errno: 145)" errors that were never occurred on my prototype setup (an underpowered Duron 800 with MySQL 4.0).
Relevant points of data:
- the code worked flawlessly on a MySQL 4.0 system
- the database was completely empty 18 hours ago, and all tables in it were created from scratch. These are not tables that were upgraded from 4.0 to 4.1.
- 3 different tables in the database have been corrupted on updates, seemingly at random
- repairs "fix" the tables, but the exact same errors crop up again either on the next update, or a few updates after that
- phpMyAdmin queries seem to run quickly, often in less than 1 millisecond, so I hadn't thought mysql04 was heavily loaded. The code in question is almost definitely more write-intensive than the group's existing phpBB usage, but nothing that would bog down the much-lower-powered prototype with the same group of users.
DrewGreen
4-16-05, 03:27 PM
If you're referring to my posts Ifrit, it should be fairly straightforward, I've tried to explain how to fix it without you needing to know anything except how to use a text editor like notepad.
Read what I've said, copy and paste, and then use the "find and replace" feature of notepad or whatever for the last part. Sorry, I can't make it easier than that.
You're going to have to look through the .php files that make up your website and find the right ones to change. It will involve using your own brain I'm afraid, and you'll have to get your hands dirty as there's no single way of doing it.
If you're not sure where to look, either ask in the support forums for the website software you're using, or ask a more specific question here, like what are you using? phpbb? vbulletin? something that's not a forum, like postnuke?
cyberCrank
4-16-05, 03:29 PM
nice name HappyDays, bet you want to change it now? ;)
...It will involve using your own brain I'm afraid, and you'll have to get your hands dirty as there's no single way of doing it...
I am of the opinion that "Powweb" has some more "brain work" to do on this one and some explaining to do for us as well... ;)
If you're referring to my posts Ifrit, it should be fairly straightforward, I've tried to explain how to fix it without you needing to know anything except how to use a text editor like notepad.
Read what I've said, copy and paste, and then use the "find and replace" feature of notepad or whatever for the last part. Sorry, I can't make it easier than that.
You're going to have to look through the .php files that make up your website and find the right ones to change. It will involve using your own brain I'm afraid, and you'll have to get your hands dirty as there's no single way of doing it.
If you're not sure where to look, either ask in the support forums for the website software you're using, or ask a more specific question here, like what are you using? phpbb? vbulletin? something that's not a forum, like postnuke?
phpbb 2.0.13
ive got mysql4.php, and i pasted that code there, then nothing happened, errors were there
DrewGreen
4-16-05, 03:53 PM
check your Private Messages Ifrit.
i UPDATED MY FORUM TO 2.0.14 AND THE PROBLEM STILL PAIN IN THE ***.
I DO NOT THINK THAT IS RELATED TO THE VERSION OF THE PHPBB.
I agree. We use oscommerce as the backend for our site and we have been having problems since friday.
DrewGreen
4-16-05, 04:08 PM
I am of the opinion that "Powweb" has some more "brain work" to do on this one and some explaining to do for us as well... ;)
Hehe, I'm not saying it's anything to do with the normal users, I'm just trying to help out. I would have preferred to not do anything to my site scripts, but at least they're working again while we wait for a fix, explanation & apology :) It's a bit concerning how fast these dbs are going from fixed to broken to fixed to broken ... and so on.
HappyDays
4-16-05, 05:39 PM
nice name HappyDays, bet you want to change it now?
Whats that suppose to mean <_<
i bet its cus this isnt a happyday?
mathieumg
4-16-05, 06:59 PM
GRRR
It crashed my ibf_posts table as well!
this whole thread was of no help to anyone.
newly created forums or mysql dependent scripts were not affected, so this was an attempt to mock at the clients, failed, proof? its now also down due to powweb messing up, so what the hell was this for? dont make fun of your clients powweb.
Warning: mysql_connect(): Can't connect to MySQL server on 'mysql03.powweb.com' (60) in /www/a/alphadesk/forum/htdocs/db/mysql4.php on line 48
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /www/a/alphadesk/forum/htdocs/db/mysql4.php on line 330
Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /www/a/alphadesk/forum/htdocs/db/mysql4.php on line 331
phpBB : Critical Error
Could not connect to the database
this whole thread was of no help to anyone.
newly created forums or mysql dependent scripts were not affected, so this was an attempt to mock at the clients, failed, proof? its now also down due to powweb messing up, so what the hell was this for? dont make fun of your clients powweb.
Warning: mysql_connect(): Can't connect to MySQL server on 'mysql03.powweb.com' (60) in /www/a/alphadesk/forum/htdocs/db/mysql4.php on line 48
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /www/a/alphadesk/forum/htdocs/db/mysql4.php on line 330
Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /www/a/alphadesk/forum/htdocs/db/mysql4.php on line 331
phpBB : Critical Error
Could not connect to the databaseI think you're way off the mark. Alphadesk was trying to help (a fellow customer). It was working fine yesterday, it appears to have fallen victim to the MySQL problems encountered by everyone else.
what am i supposed to think? powweb gives us no explanations and then people make threads saying 'hey, check it out, its NOT DOWN, try to crash it and see if it is! ahah its not powweb its you!' and then it goes down, surely this is mockery
what am i supposed to think? powweb gives us no explanations and then people make threads saying 'hey, check it out, its NOT DOWN, try to crash it and see if it is! ahah its not powweb its you!' and then it goes down, surely this is mockeryNowhere in this thread have I seen the suggestion that its not powweb.
The single person that made this thread isn't a Powweb employee so how can it be Powweb mocking?
cyberCrank
4-17-05, 11:49 AM
Whats that suppose to mean <_<
HappyDays -- I was just kidding/teasing and trying to make some humor amongst the bad/sad day everyone is having. It was nothing personal at all and please accept my apologies. When we have days like these, then we have to sometimes find ways to laugh or smile in order to keep from crying...
i bet its cus this isnt a happyday?
You are correct Ifrit and just my slight attempt at humor given many (including me) were having a bad day, but HappyDays seems like a good sport...
Nowhere in this thread have I seen the suggestion that its not powweb...
Yes IanS -- you are absolutely correct IMO and especially about alphadesk; I commend alphadesk as always for being creative and helpful in ways some do not understand. This thread of his, is an attempt and method and measure to help isolate and determine cause and effect. By setting up a separate site and running these tests, his efforts are noted as genuine as always and help to establish a root cause and try to sort out the problems that Powweb should be doing aggressively. Had Powweb set up some simple sites and run tests as alphadesk is doing it would have helped; many professional organizations do pilot testing for configurations and systems before putting those changes/systems into operation. Had Powweb done this too, then many would likely not be having these problems.
Thanks to alphadesk for having the creative and helpful mindset to attempt to find cause or common ground to help either identify or to rule out possibilities; for this he gets a few more reputation points...
HappyDays
4-17-05, 12:15 PM
HappyDays -- I was just kidding/teasing and trying to make some humor amongst the bad/sad day everyone is having. It was nothing personal at all and please accept my apologies. When we have days like these, then we have to sometimes find ways to laugh or smile in order to keep from crying...
1. Find paper bag
2. Place paper bag over mouth
3. Breath in
4. Breath out
5. Repeat steps 3 and 4
vBulletin v3.6.0, Copyright ©2000-2009, Jelsoft Enterprises Ltd.