|
|
Joined: Nov 2000
Posts: 1,271
Kahuna
|
|
Kahuna
Joined: Nov 2000
Posts: 1,271 |
<br />Warning: mysql_query(): Unable to save result set in /home/robkam2/public_html/ubbthreads/mysql.inc.php on line 107<br />SQL ERROR: Fri, May 28 2004 23:48:06 -0700 Unable to do_query: SELECT B_Number FROM w3t_Posts WHERE B_Posterid = '5' AND B_Subject = 'Re: Franta, I challenge thee to a DUEL' AND B_Body = 'agreed' AND B_Board = 'UBB9' <br />Got error 127 from table handler<br />Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/robkam2/public_html/ubbthreads/mysql.inc.php on line 133<br />SQL ERROR: Fri, May 28 2004 23:48:06 -0700 Unable to do_query: INSERT INTO w3t_Posts (B_Board,B_Parent,B_Main,B_Posted,B_Last_Post,B_IP,B_Subject,B_Body,B_Kept,B_Status,B_Approved,B_Icon,B_Reged,B_Poll,B_Replies,B_Topic,B_Convert,B_PosterId,B_AnonName,B_Sticky,B_ParentUser,B_CalDay,B_CalMonth,B_CalYear,B_AddSig) VALUES ('UBB9','282181','281686','1085824086','1085824086','67.81.191.98','Re: Franta, I challenge thee to a DUEL','agreed',' ','O','yes','','y','','0',0,'markup','5','','0','77','','','','1') <br />Duplicate entry '5' for key 7<br />Warning: Cannot modify header information - headers already sent by (output started at /home/robkam2/public_html/ubbthreads/mysql.inc.php:107) in /home/robkam2/public_html/ubbthreads/ubbt.inc.php on line 269now if that aint fun... what is??  http://www.robkamphausen.com/ubbthreads/ubbthreads.php?Cat=
|
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
Not exactly fun - very common... so the answer is posted here.  When you get an error like this do a search for the error by putting it in quotes "Got error 127" will bring up all the pertinent posts. Essentially you'll want to do REPAIR TABLE w3t_Posts Also - essential to bookmark the error messages and solution thread from infopop. Then you'll know what each MySQL error code means. http://www.ubbcentral.com/boards/showflat.php?Cat=&Number=35663I keep it bookmarked because it's really an excellent reference.
|
|
|
|
|
Joined: Nov 2000
Posts: 1,271
Kahuna
|
|
Kahuna
Joined: Nov 2000
Posts: 1,271 |
yer a good man, charlie brown! thank y'josh! i didn't know if there was a general error title that i could search for, like a "404" or something. will all errors have that similar titling?
|
|
|
|
|
Joined: Nov 2000
Posts: 1,271
Kahuna
|
|
Kahuna
Joined: Nov 2000
Posts: 1,271 |
hmm... like now for example. i did whatcha said above, and i get a new, bigger error: SQL ERROR: Sat, May 29 2004 00:08:30 -0700 Unable to do_query: SELECT t1.Bo_Title,t1.Bo_Description,t1.Bo_Keyword,t1.Bo_Total,t1.Bo_Last,t1.Bo_Number,t1.Bo_Moderated,t1.Bo_Read_Perm,t1.Bo_Write_Perm,t1.Bo_Threads,t1.Bo_Sorter,t1.Bo_Posterid,t1.Bo_LastMain,t1.Bo_LastNumber,t2.U_Username,t3.B_Subject,t3.B_Icon,t3.B_Reged,t3.B_AnonName,t1.Bo_Image FROM w3t_Boards AS t1 LEFT JOIN w3t_Users AS t2 ON t1.Bo_Posterid = t2.U_Number LEFT JOIN w3t_Posts AS t3 ON t1.Bo_LastNumber = t3.B_Number WHERE t1.Bo_Cat = 2 AND (t1.Bo_Read_Perm LIKE '%-3-%' OR t1.Bo_Read_Perm LIKE '%-1-%') ORDER BY t1.Bo_Sorter <br />Can't open file: 'w3t_Posts.MYI'. (errno: 144)<br />Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/robkam2/public_html/ubbthreads/mysql.inc.php on line 133<br />SQL ERROR: Sat, May 29 2004 00:08:30 -0700 Unable to do_query: SELECT t1.Bo_Title,t1.Bo_Description,t1.Bo_Keyword,t1.Bo_Total,t1.Bo_Last,t1.Bo_Number,t1.Bo_Moderated,t1.Bo_Read_Perm,t1.Bo_Write_Perm,t1.Bo_Threads,t1.Bo_Sorter,t1.Bo_Posterid,t1.Bo_LastMain,t1.Bo_LastNumber,t2.U_Username,t3.B_Subject,t3.B_Icon,t3.B_Reged,t3.B_AnonName,t1.Bo_Image FROM w3t_Boards AS t1 LEFT JOIN w3t_Users AS t2 ON t1.Bo_Posterid = t2.U_Number LEFT JOIN w3t_Posts AS t3 ON t1.Bo_LastNumber = t3.B_Number WHERE t1.Bo_Cat = 3 AND (t1.Bo_Read_Perm LIKE '%-3-%' OR t1.Bo_Read_Perm LIKE '%-1-%') ORDER BY t1.Bo_Sorter <br />Can't open file: 'w3t_Posts.MYI'. (errno: 144)<br />Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/robkam2/public_html/ubbthreads/mysql.inc.php on line 133<br />SQL ERROR: Sat, May 29 2004 00:08:30 -0700 Unable to do_query: SELECT t1.Bo_Title,t1.Bo_Description,t1.Bo_Keyword,t1.Bo_Total,t1.Bo_Last,t1.Bo_Number,t1.Bo_Moderated,t1.Bo_Read_Perm,t1.Bo_Write_Perm,t1.Bo_Threads,t1.Bo_Sorter,t1.Bo_Posterid,t1.Bo_LastMain,t1.Bo_LastNumber,t2.U_Username,t3.B_Subject,t3.B_Icon,t3.B_Reged,t3.B_AnonName,t1.Bo_Image FROM w3t_Boards AS t1 LEFT JOIN w3t_Users AS t2 ON t1.Bo_Posterid = t2.U_Number LEFT JOIN w3t_Posts AS t3 ON t1.Bo_LastNumber = t3.B_Number WHERE t1.Bo_Cat = 4 AND (t1.Bo_Read_Perm LIKE '%-3-%' OR t1.Bo_Read_Perm LIKE '%-1-%') ORDER BY t1.Bo_Sorter <br />Can't open file: 'w3t_Posts.MYI'. (errno: 144)<br />Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/robkam2/public_html/ubbthreads/mysql.inc.php on line 133 so what should i search for? whats, like, the title of the error? is it what appears in bold? or "144"? whats the easiest way to determine what the error message is?
|
|
|
|
|
Joined: Nov 2000
Posts: 1,271
Kahuna
|
|
Kahuna
Joined: Nov 2000
Posts: 1,271 |
well, lets just say i tried searching for everything some key phrases had more success than others. my main problem now, tho, is i don't know enough about mysql or mysql errors to know which advice to follow. all of the problems seem similar, but not identical, and i don't wanna screw anything up more than it is. the link you sent me to seems to indicate i should check out my error logs for further info, but the admin-panel-provided logs are giving me what appears to be the same (or similar) error message. Sat, May 29 2004 00:37:36 -0700 /ubbthreads/index.php Rob Kamphausen <br />Unable to do_query: SELECT B_Poll,B_Replies,B_Number,B_Board,B_Posted, B_Subject FROM w3t_Posts WHERE B_Number = B_Main AND B_Approved = 'yes' AND B_Board = 'wmxx' AND B_Poll != '' ORDER BY B_Posted DESC LIMIT 0,1 - Can't open file: 'w3t_Posts.MYI'. (errno: 144) i'm already dumb, now you throw in confusing?? and its 4 am?? forget it! ;-) i created the admin account mentioned here in case one of the pros wants to take it to wherever the next step is. i'm definitely interested in learning how to figure this kinda stuff out, though. i hate completely not knowing things (despite my persistance to do so)
|
|
|
|
|
Joined: Nov 2000
Posts: 1,271
Kahuna
|
|
Kahuna
Joined: Nov 2000
Posts: 1,271 |
oy.... there's nothing better than getting a completely new error, simply cuz a few hours have passed!  i've actually had a variety this morning, and i keep chasing them in circles. i've repaired boards, posts, online... just chasing whatever the current error of the moment says. rigth now, it appears to be stuck on 'posts', despite trying to repair that again and again. <br />SQL ERROR: Sat, May 29 2004 09:40:54 -0700 Unable to do_query: SELECT t1.Bo_Title,t1.Bo_Description,t1.Bo_Keyword,t1.Bo_Total,t1.Bo_Last,t1.Bo_Number,t1.Bo_Moderated,t1.Bo_Read_Perm,t1.Bo_Write_Perm,t1.Bo_Threads,t1.Bo_Sorter,t1.Bo_Posterid,t1.Bo_LastMain,t1.Bo_LastNumber,t2.U_Username,t3.B_Subject,t3.B_Icon,t3.B_Reged,t3.B_AnonName,t1.Bo_Image FROM w3t_Boards AS t1 LEFT JOIN w3t_Users AS t2 ON t1.Bo_Posterid = t2.U_Number LEFT JOIN w3t_Posts AS t3 ON t1.Bo_LastNumber = t3.B_Number WHERE t1.Bo_Cat = 2 AND (t1.Bo_Read_Perm LIKE '%-3-%' OR t1.Bo_Read_Perm LIKE '%-1-%') ORDER BY t1.Bo_Sorter <br />Can't open file: 'w3t_Posts.MYI'. (errno: 144)<br />Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/robkam2/public_html/ubbthreads/mysql.inc.php on line 133<br />SQL ERROR: Sat, May 29 2004 09:40:54 -0700 Unable to do_query: SELECT t1.Bo_Title,t1.Bo_Description,t1.Bo_Keyword,t1.Bo_Total,t1.Bo_Last,t1.Bo_Number,t1.Bo_Moderated,t1.Bo_Read_Perm,t1.Bo_Write_Perm,t1.Bo_Threads,t1.Bo_Sorter,t1.Bo_Posterid,t1.Bo_LastMain,t1.Bo_LastNumber,t2.U_Username,t3.B_Subject,t3.B_Icon,t3.B_Reged,t3.B_AnonName,t1.Bo_Image FROM w3t_Boards AS t1 LEFT JOIN w3t_Users AS t2 ON t1.Bo_Posterid = t2.U_Number LEFT JOIN w3t_Posts AS t3 ON t1.Bo_LastNumber = t3.B_Number WHERE t1.Bo_Cat = 3 AND (t1.Bo_Read_Perm LIKE '%-3-%' OR t1.Bo_Read_Perm LIKE '%-1-%') ORDER BY t1.Bo_Sorter <br />Can't open file: 'w3t_Posts.MYI'. (errno: 144)<br />Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/robkam2/public_html/ubbthreads/mysql.inc.php on line 133<br />SQL ERROR: Sat, May 29 2004 09:40:54 -0700 Unable to do_query: SELECT t1.Bo_Title,t1.Bo_Description,t1.Bo_Keyword,t1.Bo_Total,t1.Bo_Last,t1.Bo_Number,t1.Bo_Moderated,t1.Bo_Read_Perm,t1.Bo_Write_Perm,t1.Bo_Threads,t1.Bo_Sorter,t1.Bo_Posterid,t1.Bo_LastMain,t1.Bo_LastNumber,t2.U_Username,t3.B_Subject,t3.B_Icon,t3.B_Reged,t3.B_AnonName,t1.Bo_Image FROM w3t_Boards AS t1 LEFT JOIN w3t_Users AS t2 ON t1.Bo_Posterid = t2.U_Number LEFT JOIN w3t_Posts AS t3 ON t1.Bo_LastNumber = t3.B_Number WHERE t1.Bo_Cat = 4 AND (t1.Bo_Read_Perm LIKE '%-3-%' OR t1.Bo_Read_Perm LIKE '%-1-%') ORDER BY t1.Bo_Sorter <br />Can't open file: 'w3t_Posts.MYI'. (errno: 144)<br />Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/robkam2/public_html/ubbthreads/mysql.inc.php on line 133 the "w3t_posts.myi" part would indicate the problem is in the posts, right? isn't that how you identify issues? doing the repair posts command is only getting me "Resource id #14 row(s) affected by your query." ... but no effect on my board. still error chaos.
|
|
|
|
|
Joined: Dec 2000
Posts: 1,471
Addict
|
|
Addict
Joined: Dec 2000
Posts: 1,471 |
Seems like you have to shutdown the mysql server and run a "myisamchk -r" on the w3t_Posts.MYI file.
|
|
|
|
|
Joined: Nov 2000
Posts: 1,271
Kahuna
|
|
Kahuna
Joined: Nov 2000
Posts: 1,271 |
eef, that sounds painful. i'm really weak with mysql stuff ....
quick questions:
1) how do i shut it down? (and then bring it back?)
2) do i do this check in the sql command box, like the otherS?
3) and will this check cause any sorta damage or loss to the boards?
|
|
|
|
|
Joined: Nov 2000
Posts: 1,271
Kahuna
|
|
Kahuna
Joined: Nov 2000
Posts: 1,271 |
ok, did the sql command "myisamchk -r" and got this: <br />SQL ERROR: Sat, May 29 2004 11:21:55 -0700 Unable to do_query: myisamchk -r<br />You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'myisamchk -r' at line 1 row(s) affected by your query.
|
|
|
|
|
Joined: Nov 2000
Posts: 1,271
Kahuna
|
|
Kahuna
Joined: Nov 2000
Posts: 1,271 |
and tried doing a REPAIR in my server admin area on the database, and got the following: robkam2_drkknght.w3t_Posts<br />info : Found block that points outside data file at 153041516<br />error : 28 when fixing table<br />error : Can't copy datafile-header to tempfile, error 9<br />status : Operation failed man, do i hate this stuff.
|
|
|
|
|
Joined: Nov 2000
Posts: 1,271
Kahuna
|
|
Kahuna
Joined: Nov 2000
Posts: 1,271 |
tryin some other stuff.... <br />SQL-query : <br /><br />SHOW KEYS FROM `w3t_Posts` <br /><br />MySQL said: <br />#1016 - Can't open file: 'w3t_Posts.MYI'. (errno: 144) <br /> i keep trying other fixits, but... i'm so clueless here. ill probably make the problem worse before it gets better ;-)
|
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
Yeah, in a nutshell your Posts table is corrupt but the repair table didn't work for you.
Error Number 28 = No space left on device
Is the drive that MySQL runs on full? Or are you close to your quota with your webhost. - that's why it might not allow you to reapir the table.
The commands astaran posted would be done at the server level, not any SQL interface. If it's not your own server, ask your host for this.
|
|
|
|
|
Joined: Nov 2000
Posts: 1,271
Kahuna
|
|
Kahuna
Joined: Nov 2000
Posts: 1,271 |
this afternoon, i went to bug my web hosts' forums while waitin for more advice here. they suggested the same thing, about the web space. this is my stat line (according to the cpanel of my account) MySQL Databases 1 / 1 Disk usage 556.56 Megabytes SQL Disk usage 176.80 Megabytes Disk space available 243.44 Megabytes Bandwidth usage (current month) 15737.63 Megabytes shows that i have a buncha space left, though i have had problems in the past, where i'm put on a smaller server than what i'm allowed. i'll havta check into that, i guess. i'll also ask them about the myisamchk thing (cuz lunarpages.com hosts it, not me) thanks for all the help with this stuff, guys. sucha pain when the boards collapse -- i feel so helpless! 
|
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
Yeah, I'd ask them - just because you have that much space in your quota doesn't mean that they have space left on the drive they are running MySQL on. Either way, they will need to do some advanced repair for you.
|
|
|
|
|
Joined: Nov 2000
Posts: 1,271
Kahuna
|
|
Kahuna
Joined: Nov 2000
Posts: 1,271 |
this is the response i got from them, when making the requests: I checked on the disk status for MySQL. It had 20% free when I posted my very first answer above. Additionally, I don't think we can bring down the MySQL service, as this would interrupt MySQL service for all users on that server. ( http://www.lunarforums.com/forum/viewtopic.php?p=102175#102175) i'm not sure where that leaves me now
|
|
|
|
|
Joined: Nov 2000
Posts: 1,271
Kahuna
|
|
Kahuna
Joined: Nov 2000
Posts: 1,271 |
ok, they said.... - It appears to be a problem with your database file. Do you have a backup copy? You can back it up at any time in Cpanel under Backups. This task can even be automated. See our forums at http://lunarforums.com or http://www.lunarforums.com/forum/viewtopic.php?p=59984#59984
You can try to repair the damage by looking at line 133 in mysql.inc.php to see what it is calling then use phpmyadmin in Cpanel under MySQL.
Our backups are for major server catastrophe and are of the entire server. It is very difficult to pull one site's files out and we only do that if the problem is directly caused by us.
You may wish to change to phpbb forums as UBB is resource intensive.
Best regards.
i'd, of course, prefer to not switch to another program, as that'd cause the loss of looooots of info. and my most recent backup copy is about 2 months old, and i'd really hate to lose 60 days worth. line 133 of mysql.inc.php is as follows: $this->row = mysql_fetch_array($sth); but i'm not really sure how thats wrong (??). i also dont know how to use phpmyadmin, nor would i know what to fix. gi joe says that knowing is half the battle, so i'm already failing!
|
|
|
|
|
Joined: Dec 2000
Posts: 1,471
Addict
|
|
Addict
Joined: Dec 2000
Posts: 1,471 |
Ask them if the can send you the corrupted file or offer it for download.
Someone could import it on his mysql server and try to repair it.
|
|
|
|
|
Joined: Nov 2000
Posts: 1,271
Kahuna
|
|
Kahuna
Joined: Nov 2000
Posts: 1,271 |
the corrupted mysql database file, you mean?
i downloaded a copy yesterday (its like 45 mb) -- will that help?
|
|
|
|
|
Joined: Nov 2000
Posts: 1,271
Kahuna
|
|
Kahuna
Joined: Nov 2000
Posts: 1,271 |
ok, if thats the file you need, i just put it online: http://www.robkamphausen.com/2004-05-28-ubbthreads-backup-drkknght.gz or, if someone knows how to fix whatever is rwong via that phpmyadmin thing, i can set you up with access. whatever'll get this thing back online, asap! as always, any help is super appreciated
|
|
|
|
|
Joined: Dec 2000
Posts: 1,471
Addict
|
|
Addict
Joined: Dec 2000
Posts: 1,471 |
I'll see if I can repair it.
|
|
|
|
|
Joined: Nov 2000
Posts: 1,271
Kahuna
|
|
Kahuna
Joined: Nov 2000
Posts: 1,271 |
thank you so much, astaran! i hate when my boards are down
|
|
|
|
|
Joined: Dec 2000
Posts: 1,471
Addict
|
|
Addict
Joined: Dec 2000
Posts: 1,471 |
Mhh, are you sure that's a valid archive?
I can't open it and it claims to be 281mb large.
|
|
|
|
|
Joined: Nov 2000
Posts: 1,271
Kahuna
|
|
Kahuna
Joined: Nov 2000
Posts: 1,271 |
hmm... mebbe it didn't download all the way? it says 45 mb in my ftp program.
just to be safe, i'll reupload the file right now. should be ready in like 5 minutes from this post
|
|
|
|
|
Joined: Nov 2000
Posts: 1,271
Kahuna
|
|
Kahuna
Joined: Nov 2000
Posts: 1,271 |
|
|
|
|
|
Joined: Nov 2000
Posts: 1,271
Kahuna
|
|
Kahuna
Joined: Nov 2000
Posts: 1,271 |
some issues: i have a backup of my mysql database from 2 days ago, right after i started getting all of the errors. its about 45 mb big, but obviously contains the error (whatever the heck that is). its the one i uploaded in the above posts. however, if i try to make a new backup of my mysql database, its less than 1 mb (about 600kb). i'm assuming thats because its stripped of all post content (?) so, now i don't know if i'm totally screwed or not. should i at least re-upload the 45 mb file, first, so that there's something there to fix? and, if so, will that phpmyadmin thing give me (or astaran) access to the w3t_posts.myi file, so that we can try to repair that directly? (....so frustrating!!!)
|
|
|
|
|
Joined: Nov 2000
Posts: 1,271
Kahuna
|
|
Kahuna
Joined: Nov 2000
Posts: 1,271 |
man, am i the middle man (of my own problem, no less! ) the other forum (the one for my web host) seems to think that this is a ubb.threads problem. the feeling i get here is that there was a database problem. what kinda problem izzit? did the database just explode? was it something someone posted that tripped the whole ordeal? if the problem was the server's fault, they said they can go to the extent of backing up the files (meaning, i think, i wouldn't lose anything). they said "Our backups are for major server catastrophe and are of the entire server. It is very difficult to pull one site's files out and we only do that if the problem is directly caused by us." so... i guess if it was their fault, that'd kinda help, oddly enough. ...i think...
|
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
Did you ask them to repair the database with myisamchk. If you can't repair it with a REPAIR TABLE command and you don't have shell access to do it, then they will have to.
|
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
I'd say it's a database problem - nothing within UBB.Threads can corrupt the actual database. And your host doesn't seem to konw exactly what they are talking about, UBB.Threads is less intensive on the server than the "free" stuff like phpBB. The free stuff throws in every feature without much effort into efficiency. My guess they are mixing up UBB (Classic) and UBB.Threads.
Web hosts tend to say "we don't allow UBB" or "UBB is too intensive on the server" but they usually are thinking of UBB.Classic (flat file).
|
|
|
|
|
Joined: Nov 2000
Posts: 1,271
Kahuna
|
|
Kahuna
Joined: Nov 2000
Posts: 1,271 |
heya jp i did ask them to do that myisamchk check, and i also asked for that one w3t_posts.myi file, but didn't really get a straight response, either time. meanwhile, i tried a whole buncha things on my own, in a desperate, know-nothing attempt to get things back online. quick recap: the mysql database i had online as of sunday was only 600 kb big. the one i had on friday, with the errors, was 45 mb big. knowing the 600kb one was obviously wrong, i deleted it. then, i uploaded the broken one from friday. i tried this a few times, along with putzing around that phpmyadmin thing. finally, something, somewhere, clicked. the boards came back online. however... not all is perfect. for starters, im missing data. for example: http://www.robkamphausen.com/ubbthreads/ubbthreads.php?Cat=0 the top forum, called "rob's web log." the "last post" information indicates that the last post is on friday, may 28, which is accurate -- thats the last time i made a reply before the crash. hwoever, the last post IN that forum is on wednesday, may 26th. the last post info looks like the missing posts are in there somewhere (right?), they're just... stuck. the same is true of every forum, it looks like (but i'm really only mega concerned about the "web log" forum and the "front page" forum). so, question 1) is there anyway to retrieve those posts? (since they seem to be in there "somewhere") question 2) since this is, essentially, the same database that was corrupt and exploded last i used it, whats preventing it from erodign again?
|
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
The "last post" info is stored in a different table (w3t_Boards) not the Post table.
There's no way to recover what isn't there - frequent backups is the key to prevent any kind of data loss.
It probably won't corrupt again - a lot of times, it can corrupt from a server crash or server under too much load. Probably a fluke. I'd close the forum and optimize all the tables though just to make sure it's all as efficient as possible.
|
|
|
|
|
Joined: Nov 2000
Posts: 1,271
Kahuna
|
|
Kahuna
Joined: Nov 2000
Posts: 1,271 |
ok -- i didnt wanna reply in those forums, just incase the data was still in there somewhere, and my replies would screw it up.
but, if you think those 2 days are really gone for good, i'll move on
|
|
|
|
|
Joined: Nov 2000
Posts: 1,271
Kahuna
|
|
Kahuna
Joined: Nov 2000
Posts: 1,271 |
also... i'm pretty nervous about the optimize tables thing. in fact... i'm pretty nervous about doing much of anything, at this point.
the mysql database i uploaded (the one my boards are currently using) is from a backup i made after i originally had all the problems.
i'm worried that if i do anything, it'll explode again.
i mean, at this point, i guess its possible that if i optimize the tables, i'd get the 2 missing days back. but, its just as possible the boards'll go down again.
i'm gun shy!
|
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
I don't think you'll get the missing 2 days back if the backup is from before the days you're missing. But optimizing the tables might prevent the corruption from happening if the db is already b0rked up.
|
|
|
|
|
Joined: Nov 2000
Posts: 1,271
Kahuna
|
|
Kahuna
Joined: Nov 2000
Posts: 1,271 |
the backup is from friday the 28th. however, other than the "last post" info in areas like the web log, the database is only showing info up to wednesday the 26th. so those 2 missing days are in the mysql database (soooOOooomewhere), they're just not registering, for whatever reason. thats why i think there's still some issues with my database, and why i'm afraid everything'll get b0rked up even more (i like that term! ) i could set someone up with access (to my boards or my servers), if they wouldn't mind poking around, to make sure all things are kosher? i've had some bad luck lately
|
|
|
|
|
Joined: Nov 2000
Posts: 1,271
Kahuna
|
|
Kahuna
Joined: Nov 2000
Posts: 1,271 |
btw, here's some general info i just got from the web hosts boards, if this helps:
question:if those 2 days are gone for good... why? why if the backup was made friday, would the data only go up to wednesday? why, do you think, the database "died" on friday?
answer: They weren't properly backed up on Friday, for some reason. I don't know the internals behind MySQL's coding, so I can't answer this question. Somehow, it just didn't work. It wasn't database corruption, since the backup was fully done and there was no error in restoration (i.e. it didn't restore a corrupted database). I am honestly clueless to this. All I know, your tables were locked at the time I checked your original database. Apparently the lock was never released and could not be released. Repairs also failed. I have not seen any other tickets regarding this, so I doubt it's a major issue. I can only speculate it's some glitch in MySQL itself, but then again, I know nothing about how it is coded.
question: why does that same database now work today? (since the backup i'm currently using is from after it died on friday)
answer: The database works today as when the database was dropped, the lock was cleared. Reuploading the database only restores data and not locks. The lock was preventing queries to that specific table in the database to timeout while waiting (it's queued for processing, but never executed on the server as the table is kept locked). Again, I don't know why it shows as locked or what caused it. Repairing usually works, but it didn't work at that time.
|
|
|
|
|
Joined: Nov 2000
Posts: 1,271
Kahuna
|
|
Kahuna
Joined: Nov 2000
Posts: 1,271 |
ok -- i had a buddy who knows way more than i do look into the errors n'such that were logged via my message boards. just incase it helps clarify the situation, here's what he found: - The first of the errors I've seen relating to this happened Friday night at 11:26 P.M. All earlier errors that day have appeared on past days, so they're probably just routine and not related to the problem.
Here's the first related error:
Unable to connect to the database! - User robkam2_drkknght has already more than 'max_user_connections' active connections
These errors popped up for users 209.214.144.54, 69.164.99.99, 64.68.82.25, 63.183.144.54, 64.68.82.174, 81.211.210.90, 205.188.116.75, and 205.188.116.205. I'm assuming you had multiple PCs you were working from, or maybe multiple users accessed the same account. These errors lasted until 11:30.
At 11:38 this error popped up:
Lost connection to MySQL server during query
This error I've seen in earlier logs, so it may not be related.
At 11:39, there are intermittent errors that appear until the end of the day:
Got error 127 from table handler - This error appears for SELECT statements (database retrievals) and UPDATE statements.
Duplicate entry '0-0-0' for key 8 or Duplicate entry '5' for key 7 - These errors appear for INSERT statements.
It appears people were also noticing problems at this time, since a couple of posters posted about the board having problems.
Saturday at 12:59 A.M., errors like this appeared:
Can't open file: 'w3t_Boards.MYI'.
Can't open file: 'w3t_Posts.MYI'.(errno: 144)
From 1:36 to 1:59 the "max_user_connections" errors appeared again.
From 2:16 to 2:51 this error appears:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
For the rest of the day errors are mostly "w3t_******" errors, with several "max_user_connections" appearing as well.
i've also noticed that my board is running unusually slow since its resurgence. so, i'm backing up like a madman!
|
|
|
|
|
Joined: Oct 2003
Posts: 2,305
Old Hand
|
|
Old Hand
Joined: Oct 2003
Posts: 2,305 |
this line
Unable to connect to the database! - User robkam2_drkknght has already more than 'max_user_connections' active connections
sounds like either you have ALOT of runaway processes indicating your mysql server is not tuned correctly OR you haven't gotten enough max connections to support your boards which could happen if you have ALOT of users.
|
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
Yeah, the MySQL server maxed out and shut you out - then because the database was in the midst of being updated/worked with - it didn't like that and the table got corrupted.
Cannot connect messages are just what you think they are - you weren't being allowed to connect to the MySQL server.
The Error 127 is a generic message about the table being corrupted.
Error number 144 means "Table is crashed and last repair failed."
|
|
|
|
|
Joined: Nov 2000
Posts: 1,271
Kahuna
|
|
Kahuna
Joined: Nov 2000
Posts: 1,271 |
wow... i didn't even know there could be a max! my boards has 1,200 members. i'd say half of that number only visited the boards during the registration process -- but i like to keep them around, just incase realistically, the most i'd ever have on at one time would be... i dunno... 75? even that is probably high. 25 is average. so, because that doesn't seem large at all, i'm assuming that wasn't/isn't the problem. i'd put my stock in this assessment: [] scroungr said:you have ALOT of runaway processes indicating your mysql server is not tuned correctly[/] if thats the case... what can i do to take better care of it? as it is, right now my boards are back but walking on thin cyber ice. they're slow and creaky and i'm too afraid to optimize the tables or do any other maintenence things, for fear something'll crumble. i'm also not in control of my servers -- i host with www.lunarpages.com so they'd have my database.
|
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
The number of users you have isn't always the issue - unless you're on a dedicated server, don't forget that other websites and users will be using that same MySQL server.
Since this isn't a dedicated server, you won't be able to make server adjustments, your host will have to do that. Don't forget though, your site might not be causing the problems... anotehr site using that server could be using too many resources and causing trouble for MySQL.
One thing to check - edit your config file and make sure persistant connections is off.
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
|
Posts: 69
Joined: January 2001
|
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
| |
Most Online5,166
Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
