Casper Posted December 4, 2009 Report Share Posted December 4, 2009 Seems to be something randomly screwing up with the database. I'm working on tracking it down. It seems hit or miss. Very odd. If you get a database error, copy and paste it here. Quote Link to comment Share on other sites More sharing options...
Artmageddon Posted December 4, 2009 Report Share Posted December 4, 2009 Got one earlier on my phone, never thought to copy and paste it though. Quote Link to comment Share on other sites More sharing options...
blake1221 Posted December 4, 2009 Report Share Posted December 4, 2009 I think Gump may be trying to "clog" up the works Quote Link to comment Share on other sites More sharing options...
jporter12 Posted December 4, 2009 Report Share Posted December 4, 2009 Damn it! I read this thread AFTER a DB error, didn't know to ctrl+C, ctrl+V it..... Quote Link to comment Share on other sites More sharing options...
Casper Posted December 4, 2009 Author Report Share Posted December 4, 2009 Probably looks like:Database error in vBulletin 3.8.1:Invalid SQL: SELECT eventid, userid, event.title, recurring, recuroption, dateline_from, dateline_to, event.calendarid, IF (dateline_to = 0, 1, 0) AS singleday, customfields, dateline_from AS dateline_from_user, dateline_to AS dateline_to_user, utc, dst FROM vbb_event AS event INNER JOIN vbb_calendar AS calendar USING (calendarid) WHERE ((dateline_to >= 1259729643 AND dateline_from < 1261198443) OR (dateline_to = 0 AND dateline_from >= 1259729643 AND dateline_from <= 1261198443 )) AND visible = 1 AND calendar.options & 512 ORDER BY dateline_from;MySQL Error : Got error 28 from storage engineError Number : 1030Request Date : Thursday, December 3rd 2009 @ 11:54:03 PMError Date : Thursday, December 3rd 2009 @ 11:54:03 PMScript : http://www.ohio-riders.com/Referrer : http://www.ohio-riders.com/IP Address : 99.54.96.232Username : CasperClassname : vB_DatabaseMySQL Version : 5.0.45 Quote Link to comment Share on other sites More sharing options...
Casper Posted December 4, 2009 Author Report Share Posted December 4, 2009 Alright, think I have it fixed. Let me know if anyone has the problem anymore. Quote Link to comment Share on other sites More sharing options...
jporter12 Posted December 4, 2009 Report Share Posted December 4, 2009 What the fuck Chuck? The site was down for a few minutes! Had me worried! What I got was a 400 type error looking page, with the vbulletin logo on it saying database error. Was there a link for details that I should be aware of, in case it happens in the future, to send you debug info?Thanks for all the hard work you put into the site, man. It's helping me waste my life away on a daily basis! Quote Link to comment Share on other sites More sharing options...
Casper Posted December 4, 2009 Author Report Share Posted December 4, 2009 What the fuck Chuck? The site was down for a few minutes! Had me worried! What I got was a 400 type error looking page, with the vbulletin logo on it saying database error. Was there a link for details that I should be aware of, in case it happens in the future, to send you debug info?Thanks for all the hard work you put into the site, man. It's helping me waste my life away on a daily basis!I restarted the server. That's why it was down for a few minutes. Everything should be good now. I had a table not wanting to let go of unused disk space. Quote Link to comment Share on other sites More sharing options...
jblosser Posted December 4, 2009 Report Share Posted December 4, 2009 Disclaimer: I'm not a MySQL admin. I have MS, LPI, VMWare certs, but the only MySQL instance I have in production is my OpenNMS box...That being said, an "error 1030" is usually disk space. Might not be where the actual db resides, could be /var/logs running out. My guess is you've checked that - just trying to help. I restarted the server.#1 tool in Windows Server Admin toolkit, the three finger salute (or the power cables if it's really unhappy).... (Yes, I know this is a Linux box, CentOS if the headers aren't lying). Just thought I'd throw that in there. Quote Link to comment Share on other sites More sharing options...
jporter12 Posted December 4, 2009 Report Share Posted December 4, 2009 That all went right over my head, other than 3-finger salute, and yank the power cord! (Ok, not TOTALLY over my head, just stuff I have no experience with.) Quote Link to comment Share on other sites More sharing options...
Casper Posted December 4, 2009 Author Report Share Posted December 4, 2009 Disclaimer: I'm not a MySQL admin. I have MS, LPI, VMWare certs, but the only MySQL instance I have in production is my OpenNMS box...That being said, an "error 1030" is usually disk space. Might not be where the actual db resides, could be /var/logs running out. My guess is you've checked that - just trying to help. #1 tool in Windows Server Admin toolkit, the three finger salute (or the power cables if it's really unhappy).... (Yes, I know this is a Linux box, CentOS if the headers aren't lying). Just thought I'd throw that in there.Error 28 is the OS error for disk space. I already knew it was disk space, but we had over 10gb free. As I said above, it need up just being a database table not releasing unused space. The OS showed the disk as not being used, but it wasn't available either. Quote Link to comment Share on other sites More sharing options...
wrillo Posted December 4, 2009 Report Share Posted December 4, 2009 Error 28 is the OS error for disk space. I already knew it was disk space, but we had over 10gb free. As I said above, it need up just being a database table not releasing unused space. The OS showed the disk as not being used, but it wasn't available either.silly computers always think they know what they're talkin about Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.